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