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(); }
// Cancell Lecture Button private void Cancell_Lecture_Menu_Button(object sender, EventArgs e) { Panel_Lecturer_Requests_Main.Visible = false; CoursesDB course_db = new CoursesDB(); course_db.Get_Course_Days(user, cbo_Cancell_Day, cbo_Courses.SelectedText); }
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); } } }
private void button2_Click(object sender, EventArgs e) { lb_cuorse.Items.Clear(); CoursesDB C = new CoursesDB(); List <string> listOfCourses = new List <string>(); string semester = returnSemestr(cb_semester.SelectedItem.ToString());// SelectedItem.ToString(); string year = returnYear(cb_year.SelectedItem.ToString()); listOfCourses = C.fillCoursesBySenester_list(semester, year); foreach (string Item in listOfCourses) { lb_cuorse.Items.Add(Item); } }
public Requests_Tutors(string userName, string password) { InitializeComponent(); //this.Show(); users_db = new UsersDB(); user = new User(); users_db.FindUser(userName, password, ref user, "Tutors"); //MessageBox.Show(user.GetType() + user.GetUserType()); string id = ""; id = user.Get_ID(); courses_db = new CoursesDB(); courses_db.Get_Courses_Name_by_User_ID(this.cbo_Courses, id, "Tutors"); }
public void Get_Remainig_Hours_Of_Day(string course, string day) { CoursesDB courseDB = new CoursesDB(); //int lecture_length = -1; List <ActiveCourses> courses = new List <ActiveCourses>(); try { con.OpenCon(); com = new SqlCommand("SELECT NumOfLec FROM Courses WHERE Name = '" + course + "'", con.GetCon()); SqlDataReader rdr = com.ExecuteReader(); int length = 0; while (rdr.Read()) { length = Convert.ToInt32(rdr[0].ToString()); } con.CloseCon(); rdr.Close(); con.OpenCon(); com = new SqlCommand("SELECT * FROM ActiveCourses WHERE nameCourse = '" + course + "' AND day = '" + day + "'", con.GetCon()); rdr = com.ExecuteReader(); while (rdr.Read()) { courses.Add(new ActiveCourses(rdr[0].ToString(), rdr[1].ToString(), rdr[3].ToString(), rdr[4].ToString(), Convert.ToInt32(rdr[5].ToString()), Convert.ToInt32(rdr[6].ToString()), Convert.ToInt32(rdr[7].ToString()), rdr[8].ToString(), rdr[9].ToString())); // lecture_length = Convert.ToInt32(rdr[0].ToString()); } con.CloseCon(); rdr.Close(); } catch (Exception e) { MessageBox.Show(e.Message); } }
// 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; }
//---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 Get_Lecturer_Courses(ComboBox courses, string id) { CoursesDB courses_db = new CoursesDB(); courses_db.Get_Courses_Name_by_User_ID(courses, id, "Lecturers"); }
public void fillfreeclasses_list(ListBox lb_freeclasses, DateTime datetime, ComboBox hour, CoursesDB nameCourseSelect, CoursesDB coursedb) //1 lec 2 tut { int numhTest = 3; int Hour = hour.SelectedIndex + 8; if (freeClass_FullList.Count == 0) { try { con.OpenCon(); com = new SqlCommand("SELECT * FROM ListOfClasses", con.GetCon()); SqlDataReader rdr = com.ExecuteReader(); // string nameC = ""; while (rdr.Read()) { freeClass_FullList.Add(rdr.GetString(0)); /* * nameC = rdr.GetString(0) ; * lb_freeclasses.Items.Add(nameC); * lenClasses++; */ } con.CloseCon(); } catch (Exception ex) // { MessageBox.Show(ex.Message); } } List <string> listHeld = new List <string>(); /* * int n = 0; * foreach (string item in listHeld) * { * lb_freeclasses.Items.Remove(listHeld[n]); * n++; * } */ foreach (string cla in isHeldclass(datetime, Hour, numhTest)) { lb_freeclasses.Items.Add(cla); } }
public void Fill_Free_Classes_List(List <string> free_classes, int day, int hour, string courseName, int LecOrTut, CoursesDB course_DB, string type) { int class_len = 0, numHour = 0; try { con.OpenCon(); com = new SqlCommand("SELECT * FROM ListOfClasses", con.GetCon()); SqlDataReader rdr = com.ExecuteReader(); string nameC = ""; while (rdr.Read()) { nameC = rdr.GetString(0); free_classes.Add(nameC); class_len++; } con.CloseCon(); rdr.Close(); } catch (Exception e) // { MessageBox.Show(e.Message); } //remove "Lectur" or Tutur" if have //int index = courseName.IndexOf("-"); //String fixnumecourse = courseName.Substring(/*0*/1, index); //numHour = course_DB.getNumHour(fixnumecourse, LecOrTut); List <string> list = new List <string>(); list = isHeldClass_List(free_classes, day, hour, numHour); int n = 0; foreach (string item in list) { free_classes.Remove(list[n]); n++; } }
public void fillfreeclasses_listBox(ListBox lb_freeclasses, ComboBox day, ComboBox hour, ListBox lb_nameCourse, int LecOrTut, CoursesDB coursedb, int numOfhoursOnCourse) //1 lec 2 tut { int lenClasses = 0; 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()+type; * * //remove "Lectur" or Tutur" if have * int index = numecourse.IndexOf("-"); * String fixnumecourse = numecourse.Substring(0, index); * numh = coursedb.getNumHour(fixnumecourse, LecOrTut); */ numecourse = lb_nameCourse.SelectedValue.ToString(); // numh = coursedb.getNumHour(numecourse, LecOrTut); List <string> list = new List <string>(); list = isHeldclass(lb_freeclasses, Day, Hour, numOfhoursOnCourse); int n = 0; foreach (string item in list) { lb_freeclasses.Items.Remove(list[n]); n++; } }