//---fill list lecturers public void fillLecturers_list(ListBox lb_nameLecturers, string nameCourse, int day, int hour, CoursesDB coursedb) { //---input to list all lecturers of this course List <string> IDlecturersList = new List <string>(); char semester; try { con.OpenCon(); com = new SqlCommand("SELECT * FROM LecturerToCourses WHERE NameCourse = '" + nameCourse + "'", con.GetCon()); SqlDataReader rdr = com.ExecuteReader(); while (rdr.Read()) { IDlecturersList.Add(rdr[1].ToString()); } con.CloseCon(); // lb_nameLecturers.DataSource = IDlecturers; } catch (Exception ex) { MessageBox.Show(ex.Message); } semester = coursedb.GetSemeterByCourse(nameCourse); int numh = coursedb.getNumHour(lb_nameLecturers.Text, 1); //---check if each lecturer can learning in this time checkPreferencesLecturers(lb_nameLecturers, IDlecturersList, day, hour, semester, numh); }
public void fillfreeclasses_list(ListBox lb_freeclasses, ComboBox day, ComboBox hour, ListBox lb_nameCourse, int LecOrTut, CoursesDB coursedb) //1 lec 2 tut { int lenClasses = 0, numh; string numecourse; int Day = day.SelectedIndex + 1; int Hour = hour.SelectedIndex + 8; try { con.OpenCon(); com = new SqlCommand("SELECT * FROM ListOfClasses", con.GetCon()); SqlDataReader rdr = com.ExecuteReader(); string nameC = ""; while (rdr.Read()) { nameC = rdr.GetString(0); lb_freeclasses.Items.Add(nameC); lenClasses++; } con.CloseCon(); } catch (Exception ex) { MessageBox.Show(ex.Message); } numecourse = lb_nameCourse.SelectedValue.ToString(); numh = coursedb.getNumHour(numecourse, LecOrTut); List <string> list = new List <string>(); list = isHeldclass(lb_freeclasses, Day, Hour, numh); int n = 0; foreach (string item in list) { lb_freeclasses.Items.Remove(list[n]); n++; } }
// Add Lecture - Confirmation Button private void button4_Click(object sender, EventArgs e) { CoursesDB courses_db = new CoursesDB(); ActiveCoursesDB actCourseDB = new ActiveCoursesDB(); int day = cbo_Day.SelectedIndex + 1; int hour = cbo_Hour.SelectedIndex + 8; int numOfhoursOnCourse = courses_db.getNumHour(cbo_Courses.Text, 1); // 1 for lecturer if (((day == 6) && (hour + numOfhoursOnCourse > 13)) || ((day != 6) && (hour + numOfhoursOnCourse > 21))) { MessageBox.Show("Illegal hours"); } else { //--fill free class list List <string> free_classes = new List <string>(); actCourseDB.Fill_Free_Classes_List(free_classes, cbo_Day.SelectedIndex + 1, Convert.ToInt32(cbo_Hour.Text), cbo_Courses.Text, 1, courses_db, "Lecture"); Requests_LecturersDB reqLec = new Requests_LecturersDB(); reqLec.Check_Classes(free_classes); try { if (free_classes.Count == 0) { throw new NullReferenceException("There are no available classrooms."); } string LeteralDay = cbo_Day.Text; if (LeteralDay == "'א") { LeteralDay = "A"; } else if (LeteralDay == "'ב") { LeteralDay = "B"; } else if (LeteralDay == "'ג") { LeteralDay = "C"; } else if (LeteralDay == "'ד") { LeteralDay = "D"; } else if (LeteralDay == "'ה") { LeteralDay = "E"; } else if (LeteralDay == "'ו") { LeteralDay = "F"; } reqLec.Add_Request(user.Get_ID(), user.Get_First_Name(), user.Get_Last_Name(), ADD_LEC, cbo_Courses.Text, LeteralDay, Convert.ToInt32(cbo_Hour.Text), free_classes[0]); } catch (NullReferenceException ex) { MessageBox.Show(ex.Message); } } cbo_Day.ResetText(); cbo_Hour.ResetText(); cbo_Courses.ResetText(); Panel_Cancell_Lec.Visible = true; Panel_Lecturer_Requests_Main.Visible = true; }
private void button2_Click(object sender, EventArgs e) { string select_class = "", select_lec = ""; int select_hour = 8, numberHoursCourse; char select_day = 'A'; int index = lb_activeCourse.Text.IndexOf("-"); string fixnumecourse = lb_activeCourse.Text.Substring(0, index); while (true) { //--------Name course check if ((lb_activeCourse.Text == "")) { MessageBox.Show("You need choose course"); //empty textBox or not integer break; } if (typeCourse_select.Contains("Lecture")) { numberHoursCourse = courses_db.getNumHour(fixnumecourse, 1); //-------day check switch (cb_day.SelectedIndex + 1) { case 1: select_day = 'A'; break; case 2: select_day = 'B'; break; case 3: select_day = 'C'; break; case 4: select_day = 'D'; break; case 5: select_day = 'D'; break; case 6: select_day = 'E'; break; default: MessageBox.Show("You need to choose day"); select_day = ' '; break; } if (select_day == ' ') { break; } //-------check hour if (cb_hour.SelectedIndex == -1) { MessageBox.Show("You need to choose hour"); select_hour = 0; break; } select_hour = cb_hour.SelectedIndex + 8; if ((lb_class.Text == "")) { MessageBox.Show("You need choose class"); //No choose in ListBox break; } select_class = lb_class.Text; //----check lecturer if ((lb_name_lecOrtut.Text == "")) { MessageBox.Show("You need choose lecturer"); //No choose in ListBox break; } select_lec = lb_name_lecOrtut.Text; //-------All detailse fine------ activecourse_db.Update_ActiveCourse(id_active_course, select_hour, select_day, select_class, select_lec); this.Hide(); break; } else { break; } } }