// This method copies the selected record from the available courses datagrid
// and copies it to the qualification courses table. Then it updates the
// qualification courses datagrid.
private void btnAddC_Click(object sender, EventArgs e)
{
try
{
// Store the current selected Combo value so that it
// can be selected after the process is finished.
var theQualificationID = cmbQualificationIDC.SelectedIndex;
//Select the selected Course ID from the Course datagrid
int rowSelected = dgvAvailableCoursesC.CurrentCell.RowIndex;
var selectedCourseIDNumber = dgvAvailableCoursesC.Rows[rowSelected].Cells[0].Value.ToString();
// Check that it is not already been added to the
// selected Qualification
var cidList = (from q in DB.Qualification_Courses
where q.QCode == cmbQualificationIDC.Text
select q.CID).ToList();
foreach (int c in cidList)
{
if (c == int.Parse(selectedCourseIDNumber))
{
MessageBox.Show("The selected course has already been added");
return;
}
}
// Use the selected Qualification Code and Course ID to
// create a new Qualification_Course record
var newQualificationCourse = new Qualification_Course();
newQualificationCourse.QCode = cmbQualificationIDC.SelectedValue.ToString();
newQualificationCourse.CID = int.Parse(selectedCourseIDNumber);
DB.Qualification_Courses.InsertOnSubmit(newQualificationCourse);
DB.SubmitChanges();
MessageBox.Show("Course added to Qualification");
updateData(updated);
// Recall the selected combo value
cmbQualificationIDC.SelectedIndex = theQualificationID;
}
catch (Exception Ex)
{
MessageBox.Show(Ex.Message);
}
}
// This method adds data to the Courses table
private void btnAddA_Click(object sender, EventArgs e)
{
try
{
// Indicate that this is the Add Tab for Error Message control
string theTab = "Add";
// Test that a valid course number has been entered
if (!ValidCourseID(txtCourseIDA.Text))
{
return;
}
// Test that a unique Course number has been entered
if (!validUniqueCourseNumber(txtCourseIDA.Text))
{
return;
}
// Test that a course name has been entered
if (!ValidCourseName(txtCourseNameA.Text, theTab))
{
return;
}
// Test that a year has been selected
if (!ValidYear(cmbYearA.Text))
{
return;
}
// Test that a semester has been selected
if (!ValidSemester(cmbSemesterA.Text))
{
return;
}
// Create a new Courses object and add its properties
var newCourse = new Course();
newCourse.CID = int.Parse(txtCourseIDA.Text.ToString());
newCourse.CName = txtCourseNameA.Text.Trim();
newCourse.Year = int.Parse(cmbYearA.SelectedItem.ToString());
newCourse.Semester = cmbSemesterA.SelectedItem.ToString();
newCourse.TID = int.Parse(cmbTeacherIDA.SelectedItem.ToString());
// Add the new course to the database
DB.Courses.InsertOnSubmit(newCourse);
DB.SubmitChanges();
// Create a new Qualification_Courses object and
// add its properties
var newQualCourse = new Qualification_Course();
newQualCourse.QCode = cmbQualificationCodeA.SelectedItem.ToString();
newQualCourse.CID = int.Parse(txtCourseIDA.Text.ToString());
// Add the new record to the database
DB.Qualification_Courses.InsertOnSubmit(newQualCourse);
DB.SubmitChanges();
lblCoursesMessageA.Text = "Course ID " + txtCourseIDA.Text + " added";
updateData(updated);
}
catch (Exception Ex)
{
MessageBox.Show(Ex.Message);
}
}