private void lb_nameCourse_SelectedIndexChanged(object sender, EventArgs e) { foreach (CoursesDB item in coursesDBList) { if (lb_nameCourse.Text.Contains(item.GetName())) { selectedCourseOBJ = item; break; } } lb_class.Items.Clear(); char semester_course; semester_course = selectedCourseOBJ.Getsemester(); dt_date.MaxDate = DateTime.Today.AddYears(20); //for clear dt_date.MinDate = semesterdb.GetStartDateTestSemester(semester_course); dt_date.MaxDate = semesterdb.GetEndDateTestSemester(semester_course); dt_date.Format = DateTimePickerFormat.Short; cb_hourse.Items.Clear(); cb_hourse.ResetText(); }
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); }
private void do_it_Click(object sender, EventArgs e) { string select_course, select_class; int select_hour; while (true) { //--------Name course check if ((nameCourse.Text == "")) { MessageBox.Show("You need choose course"); //empty textBox or not integer break; } select_course = nameCourse.Text; //-------check hour if (cb_hourse.SelectedIndex == -1) { MessageBox.Show("You need to choose hour"); select_hour = 0; break; } select_hour = cb_hourse.SelectedIndex + 8; if ((lb_class.Text == "")) { MessageBox.Show("You need choose class"); //No choose in ListBox break; } select_class = lb_class.Text; //-------All detailse fine------ test_Schedule_db.InsertNew_Test(select_course, selectedCourseOBJ.Getsemester(), dt_date.Value, select_hour, select_class); this.Hide(); break; } }