private void iTalk_Button_21_Click(object sender, EventArgs e)
{
String courseName = this.courseName_textBox.Text;
int yearTaught = this.yearTaught_checkedListBox.SelectedIndex + 1;
int semesterTaught = this.semesterTaught_checkedListBox.SelectedIndex + 1;
Semester semester;
String errorMsg = "";
if (courseName.Length == 0)
{
errorMsg += "\n-No course name was entered.";
}
if (yearTaught_checkedListBox.SelectedItems.Count == 0)
{
errorMsg += "\n-No year was choosen.";
}
if (semesterTaught_checkedListBox.SelectedItems.Count == 0)
{
errorMsg += "\n-No semester was choosen.";
}
if (errorMsg.Length > 0)
{
MessageBox.Show("The following errors occured:" + errorMsg);
return;
}
switch (semesterTaught)
{
case 1: semester = Semester.First;
break;
case 2: semester = Semester.Second;
break;
case 3: semester = Semester.Third;
break;
default: semester = Semester.First;
break;
}
SqlConnection connection = SQLConnection.GetSqlConnection();
if (connection == null)
{
MessageBox.Show("SQL connection hasn't been initialized or has been closed.");
return;
}
HeadOfDepartmentSQL sql = new HeadOfDepartmentSQL(connection);
//MessageBox.Show("Last Added Course ID= " + sql.GetLastAddedCourseID());
sql.AddNewCourse(new Course(sql.GetLastAddedCourseID(), courseName, yearTaught, semester, false));
this.Dispose();
}