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