public List <TeacherEnitity> GetTeachers() // Method to get all members in students table { // Strat connection with database DbConnection dbConnection = new DbConnection("spShowTeachers"); dbConnection.con.Open(); //DataSet dataSet = new DataSet(); dbConnection.cmd.ExecuteNonQuery(); dbConnection.FillData(teacherDataset); // Create list to add teachers in List <TeacherEnitity> tchList = new List <TeacherEnitity>(); // Loop to add teachers to the list foreach (DataRow dr in teacherDataset.Tables[0].Rows) { // In each iteration create a new obj of teacher, add values, then push to list TeacherEnitity currentTech = new TeacherEnitity(); currentTech.tchId = (int)dr[0]; currentTech.tchName = (string)dr[1]; tchList.Add(currentTech); } //Close connection with data-base dbConnection.con.Close(); // return the list of teachers return(tchList); }
private void _ٍShowTeach_Load(object sender, EventArgs e) { // Create object from TeacherEntity to access GetTeacher method TeacherEnitity teacherEntity = new TeacherEnitity(); // Create new list to save the teacher list returned from GetTeacher method List <TeacherEnitity> techList = teacherEntity.GetTeachers(); // Show the content of teacher list on DataGridView dataGridView2.DataSource = techList; }
private void button1_Click_1(object sender, EventArgs e) { // create object from TeacherEntity TeacherEnitity tachertEntity = new TeacherEnitity(); // Get course id to inesrt it to database int crsId = tachertEntity.GetCourseId(coursesComboBox.Text); // Passing teacher name to the object along with course id tachertEntity.SetTchByName(txtTchName.Text, crsId); // Confirm to user MessageBox.Show("Teacher added successfully!"); }