//Save the pre course
private void save_Click(object sender, EventArgs e)
{
//Check if any courses was chosen
if (comboBox1.SelectedItem == null || comboBox2.SelectedItem == null)
{
MessageBox.Show("Please choose pre course and course", "Error"
, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
//Get two strings from combobox
DataRowView oDataRowView = comboBox1.SelectedItem as DataRowView;
string preCourse = oDataRowView.Row["CourseName"] as string;
oDataRowView = comboBox2.SelectedItem as DataRowView;
string course = oDataRowView.Row["CourseName"] as string;
//Check if the courses isn't the same
if (preCourse == course)
{
MessageBox.Show("Course can't have himself as pre course", "Error"
, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
int success = SqlWorker.addPreCourse(preCourse, course);
//Show message according to add pre course function
if (success == 2)
{
MessageBox.Show("Action successfully completed.", "Success!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else if (success == 0)
{
MessageBox.Show("The course " + course + " already has " + preCourse + " as pre course!", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MessageBox.Show("The course " + preCourse + " has " + course + " as pre course!", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void Test_add_pre_course()
{
//Add pre course
//0 - already exists
//1 - opposite exists
//2 - operation successfull
//Add brand new courses
SqlWorker.addCourse(course1, lecturerID, practitionerID, LectureDuration, PracticeDuration, LabDuration, true);
SqlWorker.addCourse(course2, lecturerID, practitionerID, LectureDuration, PracticeDuration, LabDuration, true);
//Set course1 as pre course of course2
Assert.IsTrue(SqlWorker.addPreCourse(course1, course2) == 2);
//Try again
Assert.IsTrue(SqlWorker.addPreCourse(course1, course2) == 0);
//Try to set the opposite
Assert.IsTrue(SqlWorker.addPreCourse(course2, course1) == 1);
SqlWorker.ExecuteQueries("Delete from Courses where CourseName='" + course1 + "' or CourseName='" + course2 + "'");
SqlWorker.ExecuteQueries("Delete from PreCourses where PreCourse='" + course1 + "' and course='" + course2 + "'");
}