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++;
}
}
