public List <CourseEntity> GetCoursesTeachersStudents() // Method to show all courses with techers & students registered in { // Strat connection with database & excute the query DbConnection dbConnection = new DbConnection("GetCoursesTeachersStudents"); dbConnection.con.Open(); dbConnection.cmd.ExecuteNonQuery(); // Pass dataset to be filled dbConnection.FillData(coursesDataset); // Create list of courses type to push the result in List <CourseEntity> crsList = new List <CourseEntity>(); foreach (DataRow dr in coursesDataset.Tables[0].Rows) { // In each iteration push courses, teachers, students to list CourseEntity currenEnt = new CourseEntity(); currenEnt.crsName = (string)dr[0]; currenEnt.techName = (string)dr[1].ToString(); currenEnt.stdName = (string)dr[2].ToString(); crsList.Add(currenEnt); } // Close connection before moving to another query dbConnection.con.Close(); // return the list of students return(crsList); }
public AddTeacher() { InitializeComponent(); // Create obj from courseEntity to call FillCourses method CourseEntity courseEntity = new CourseEntity(); // Method to fill courses comboBox once page loaded coursesComboBox.DataSource = courseEntity.FillCoursesComboBox(); }
private void button2_Click(object sender, EventArgs e) { // create object from CourseEntity CourseEntity courseEntity = new CourseEntity(); // Passing course name to the object courseEntity.SetCrsByName(txtCrsName.Text); // Confirm to user MessageBox.Show("Course added successfully!"); }
private void ShowCourses_Load(object sender, EventArgs e) { // Create object from CourseEntity to access GetCoursesTeacherStduents method CourseEntity courseEntity = new CourseEntity(); // Create list to save the list returend from Get.. methond List <CourseEntity> crsList = courseEntity.GetCoursesTeachersStudents(); // Show the content of course list on DataGridView dataGridView2.DataSource = crsList; }