teacher.cs

it is beautiful was lit

using System;
using System.Collections.Generic;
using System.Text;

namespace Console
{
    public class Teacher
    {
        private string _dbConnStr = string.Empty;

        private System.Data.SqlClient.SqlDataAdapter _sqlDa = new System.Data.SqlClient.SqlDataAdapter();

        System.Data.DataTable _teacher = new System.Data.DataTable();

        public const string TeacherIDColumnName = "TeacherID";
        public const string NameColumnName = "Name";
        public const string DepartmentIDColumnName = "DepartmentID";

        public Teacher(string connStr)
        {
            _dbConnStr = connStr;

            _teacher.Columns.Add(new System.Data.DataColumn(Teacher.TeacherIDColumnName, typeof(string)));
            _teacher.Columns.Add(new System.Data.DataColumn(Teacher.NameColumnName, typeof(string)));
            _teacher.Columns.Add(new System.Data.DataColumn(Teacher.DepartmentIDColumnName, typeof(string)));
        }

        public System.Data.DataTable GetDataByName(string Name)
        {
            using (System.Data.SqlClient.SqlConnection conn =
                new System.Data.SqlClient.SqlConnection(_dbConnStr))
            {
                string sqlText = "SELECT * FROM Teacher WHERE Name LIKE '%' + @Name + '%'";

                System.Data.SqlClient.SqlCommand sqlCmd =
                    new System.Data.SqlClient.SqlCommand(sqlText, conn);

                sqlCmd.Parameters.Add(
                    new System.Data.SqlClient.SqlParameter("@Name", Name));

                _sqlDa.SelectCommand = sqlCmd;

                _sqlDa.Fill(_teacher);
            }

            return _teacher;
        }

        public void Insert(string TeacherID, string Name, string DepartmentID)
        {
            using (System.Data.SqlClient.SqlConnection conn =
                new System.Data.SqlClient.SqlConnection(_dbConnStr))
            {
                string sqlText = "INSERT INTO Teacher (TeacherID, Name, DepartmentID) VALUES(@TeacherID, @Name, @DepartmentID)";

                System.Data.SqlClient.SqlCommand sqlCmd =
                    new System.Data.SqlClient.SqlCommand(sqlText, conn);

                sqlCmd.Parameters.Add(
                    new System.Data.SqlClient.SqlParameter("@TeacherID", TeacherID));
                sqlCmd.Parameters.Add(
                    new System.Data.SqlClient.SqlParameter("@Name", Name));
                sqlCmd.Parameters.Add(
                    new System.Data.SqlClient.SqlParameter("@DepartmentID", DepartmentID));

                _sqlDa.InsertCommand = sqlCmd;

                System.Data.DataRow aRow = _teacher.NewRow();
                aRow[TeacherIDColumnName] = TeacherID;
                aRow[NameColumnName] = Name;
                aRow[DepartmentIDColumnName] = DepartmentID;

                _teacher.Rows.Add(aRow);

                _sqlDa.Update(_teacher);
            }
        }
    }
}