public void class_req_Test()
{
//insert one request for class in temp course.
SqlWorker.addCourse(courseName, lecturerID, practitionerID, LectureDuration, PracticeDuration, LabDuration, true);
SqlWorker.setClassRequest(lecID.ToString(), courseName, p, l);
Assert.IsTrue(SqlWorker.GetDataSet("select * from ClassRequest where TeacherID LIKE '" + lecID +
"' AND CourseName LIKE '" + courseName + "' AND Projector = '" + p + "' AND Lab = '" + l + "'").Tables[0].Rows.Count == 1);
//try to update the request
p = 0;
SqlWorker.addCourse(courseName, lecturerID, practitionerID, LectureDuration, PracticeDuration, LabDuration, true);
SqlWorker.setClassRequest(lecID.ToString(), courseName, p, l);
Assert.IsTrue(SqlWorker.GetDataSet("select * from ClassRequest where TeacherID LIKE '" + lecID +
"' AND CourseName LIKE '" + courseName + "' AND Projector = '" + p + "' AND Lab = '" + l + "'").Tables[0].Rows.Count == 1);
//delete the temp course.
SqlWorker.ExecuteQueries("Delete from Courses where CourseName='" + courseName + "'");
//delete the request
SqlWorker.ExecuteQueries("Delete from ClassRequest where CourseName='" + courseName + "'");
}
