public void AddLecturer_PracAssignmentTest()
{
CHeadOfDepartment hod = new CHeadOfDepartment("test", "test", "test", "test", "test");
hod.AddLecturer_PracAssignment("test", "test");
DataTable dt = Program.get_dt("SELECT * from Lecturer_prac_assignment WHERE courseId='test'");
Assert.IsTrue(dt.Rows[0][0].ToString() == "test" && dt.Rows[0][1].ToString() == "test");
Program.update_sql("DELETE Lecturer_prac_assignment WHERE courseid='TEST'");
}
private void button1_Click(object sender, EventArgs e)
{/*add to DB*/
if (comboBox1.SelectedIndex == -1)
{
MessageBox.Show("Must choose lecturer");
return;
}
if (comboBox2.SelectedIndex == -1)
{
MessageBox.Show("Must choose course");
return;
}
DataTable dt1 = Program.get_dt("SELECT id FROM Login where department='" + Hod.Department + "' and permission='TS' and f_name='" + comboBox1.SelectedItem.ToString() + "'");
DataTable dt2 = Program.get_dt("SELECT id FROM courses where name='" + comboBox2.SelectedItem.ToString() + "'");
if (Hod.AddLecturer_PracAssignment(dt2.Rows[0][0].ToString(), dt1.Rows[0][0].ToString()))
{
MessageBox.Show("Added successfully");
}
else
{
MessageBox.Show("assignment allready exist");
}
}
