private void cb_hourse_SelectedIndexChanged(object sender, EventArgs e) { int day, hour, numOfhoursOnCourse; day = cb_day.SelectedIndex + 1; hour = cb_hourse.SelectedIndex + 8; int lecOrTut_INT = 0; foreach (CoursesDB item in coursesDBList) { if (lb_nameCourse.Text.Contains(item.GetName())) { selectedCourseOBJ = item; break; } } if (Lec_OR_Tut == "Lecture") { numOfhoursOnCourse = selectedCourseOBJ.GetNumOfLec(); lecOrTut_INT = 1; } else { numOfhoursOnCourse = selectedCourseOBJ.GetNumOfTut(); lecOrTut_INT = 2; } //-------for lecture if (day == 6 && (hour + numOfhoursOnCourse > 13) || day != 6 && (hour + numOfhoursOnCourse > 21)) { lb_nameLec.Items.Clear(); lb_class.Items.Clear(); MessageBox.Show("You have exceeded the operating hours of college"); } else { //--fill free class list lb_class.Items.Clear(); lb_nameLec.Items.Clear(); activecourse_db.fillfreeclasses_listBox(lb_class, cb_day, cb_hourse, lb_nameCourse, lecOrTut_INT, selectedCourseOBJ, numOfhoursOnCourse); //--fill lecturers that can study this cours and in this time if (Lec_OR_Tut == "Lecture") { lecturersdb.fillLecturers_list(lb_nameLec, lb_nameCourse.Text, day, hour, selectedCourseOBJ); } else { tutorsdb.fillTutors_list(lb_nameLec, lb_nameCourse.Text, day, hour, selectedCourseOBJ); } } }
public void fillTutors_list(ListBox lb_nameLecturers, string nameCourse, int day, int hour, CoursesDB selectedCourseOBJ) { //---input to list all lecturers of this course List <string> IDtutorsListFULL = new List <string>(); char semester; try { con.OpenCon(); com = new SqlCommand("SELECT * FROM TutorToCourses WHERE NameCourse = '" + nameCourse + "'", con.GetCon()); SqlDataReader rdr = com.ExecuteReader(); while (rdr.Read()) { IDtutorsListFULL.Add(rdr[1].ToString()); } con.CloseCon(); // lb_nameLecturers.DataSource = IDlecturers; } catch (Exception ex) { MessageBox.Show(ex.Message); } semester = selectedCourseOBJ.Getsemester(); int numh = selectedCourseOBJ.GetNumOfLec(); //---check if each lecturer can learning in this time checkPreferencesTutors(lb_nameLecturers, IDtutorsListFULL, day, hour, semester, numh); }