private void button1_Click(object sender, EventArgs e)
{
if (chooseTS.SelectedIndex == -1)
{
MessageBox.Show("Must choose lecturer");
return;
}
DataTable dt = Program.get_dt("select tsid from lessons where tsid='" + TS.Rows[chooseTS.SelectedIndex][1].ToString() + "'");
if (dt.Rows.Count > 0)
{
MessageBox.Show("Teaching Staff cannot be dissmised\n Teaching Staff assigned to lessons");
return;
}
if (Hod.DismissTeachingStaff(TS.Rows[chooseTS.SelectedIndex][1].ToString()))
{
MessageBox.Show("deleted succesfully");
chooseTS.SelectedIndex = -1;
chooseTS.Items.Clear();
TS = Program.get_dt("select f_name,id from login where permission='TS' and department='" + Hod.Department + "' order by f_name");
for (int i = 0; i < TS.Rows.Count; i++)
{
chooseTS.Items.Add(TS.Rows[i][0]);
}
}
else
{
MessageBox.Show("not found");
}
}
public void DismissTeachingStaffTest()
{
CHeadOfDepartment hod = new CHeadOfDepartment("test", "test", "test", "test", "test");
CTeachingStaff ts = new CTeachingStaff("test", "test", "test", "test", "test", "Lecturer", null);
Program.update_sql("insert into login values('" + ts.Id + "','" + ts.Name + "','" + ts.Password + "','" + ts.Permission + "','" + ts.Department + "')");
Program.update_sql("insert into teaching_staff values('" + ts.Id + "','" + ts.Type + "','" + ts.Constraints + "')");
hod.DismissTeachingStaff(ts.Id);
DataTable dt = Program.get_dt("SELECT * from teaching_staff WHERE Id='test'");
DataTable dt2 = Program.get_dt("SELECT * from login WHERE Id='test'");
Assert.IsTrue(dt.Rows.Count == 0 && dt2.Rows.Count == 0);
}