public void ChangePasswordTest() { CUser u = new CTeachingStaff("test", "test", "123456", "Software", "TS", "Lecturer", null); Program.update_sql("insert into login values('" + u.Id + "','" + u.Name + "','" + u.Password + "','" + u.Permission + "','" + u.Department + "','NULL')"); u.ChangePassword("123456"); DataTable dt = Program.get_dt("SELECT password from Login WHERE Id='" + u.Id + "'"); Assert.IsTrue(dt.Rows[0][0].ToString() == u.Password); Program.update_sql("DELETE login WHERE id='TEST'"); }
public void addConstraintsToDBTest() { CTeachingStaff t = new CTeachingStaff("test", "test", "test", "test", "test", "Lecturer", "abcd"); Program.update_sql("insert into login values('" + t.Id + "','" + t.Name + "','" + t.Password + "','" + t.Permission + "','" + t.Department + "','NULL')"); Program.update_sql("insert into teaching_staff values('" + t.Id + "','" + t.Type + "','test')"); t.addConstraintsToDB(); DataTable dt = Program.get_dt("SELECT constraints from Teaching_staff WHERE Id='" + t.Id + "'"); Assert.IsTrue(dt.Rows[0][0].ToString() == t.Constraints); Program.update_sql("DELETE TEACHING_STAFF WHERE id='test'"); Program.update_sql("DELETE login WHERE id='test'"); }
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); }