private void EnrolmentForm_Load(object sender, EventArgs e)
{
clsEnrolment objEnrolment = new clsEnrolment();
ComboBox[] cmb = new ComboBox[] { cmbStudentID, cmbStudentName, cmbCourseID, cmbCourseName, cmbSemester };
//Doesn't include the other combo boxes because they are fixed values.
objEnrolment.Load(cmb);
objEnrolment.ViewAll(dgvEnrolment);
}
private void mnuDelete_Click(object sender, EventArgs e)
{
if (!clsValidation.ValidateTextBoxForNumeric(txtEnrolmentID))
{
txtEnrolmentID.Focus();
return;
}
clsEnrolment objEnrolment = new clsEnrolment(Convert.ToInt32(txtEnrolmentID.Text));
objEnrolment.Delete();
MessageBox.Show("Enrolment record successfully deleted");
objEnrolment.ViewAll(dgvEnrolment);
}
private void btnSearch_Click(object sender, EventArgs e)
{
if (!clsValidation.ValidateTextBoxForNumeric(txtEnrolmentID))
{
txtEnrolmentID.Focus();
return;
}
clsEnrolment objEnrolment = new clsEnrolment(Convert.ToInt32(txtEnrolmentID.Text));
bool valid = objEnrolment.Search();
if (valid)
{
cmbStudentID.Text = objEnrolment.StudentID.ToString();
cmbStudentName.Text = objEnrolment.StudentFirstName + " " + objEnrolment.StudentLastName;
cmbCourseID.Text = objEnrolment.CourseID.ToString();
cmbCourseName.Text = objEnrolment.CourseName;
dtpEnrolmentDate.Value = DateTime.Parse(objEnrolment.EnrolmentDate);
dtpExpectedEndDate.Value = DateTime.Parse(objEnrolment.ExpectedEndDate);
if (objEnrolment.CourseDelivery == "FaceToFace")
{
rdbFaceToFace.Checked = true;
}
else if (objEnrolment.CourseDelivery == "Online")
{
rdbOnline.Checked = true;
}
txtAmountDue.Text = objEnrolment.AmountDue.ToString();
dtpPaymentDueDate.Value = DateTime.Parse(objEnrolment.PaymentDueDate);
cmbPaymentMethod.Text = objEnrolment.PaymentMethod;
cmbPaymentStatus.Text = objEnrolment.PaymentStatus;
if (objEnrolment.DatePaid != "")
{
dtpDatePaid.Value = DateTime.Parse(objEnrolment.DatePaid);
}
else
{
dtpDatePaid.Format = DateTimePickerFormat.Custom;
dtpDatePaid.CustomFormat = " ";
}
cmbStudyStatus.Text = objEnrolment.StudyStatus;
}
}
private void mnuViewAll_Click(object sender, EventArgs e)
{
clsEnrolment objEnrolment = new clsEnrolment();
objEnrolment.ViewAll(dgvEnrolment);
}
private void mnuAdd_Click(object sender, EventArgs e)
{
#region ValidationArea
if (!clsValidation.ValidateComboBox(cmbStudentID))
{
return;
}
if (!clsValidation.ValidateComboBox(cmbCourseID))
{
return;
}
if (!clsValidation.ValidateDate(dtpEnrolmentDate))
{
return;
}
if (!clsValidation.ValidateDate(dtpExpectedEndDate))
{
return;
}
if (!clsValidation.ValidateDateStartVsEnd(dtpEnrolmentDate, dtpExpectedEndDate))
{
return;
}
if (!clsValidation.ValidateRadioButton(rdbFaceToFace, rdbOnline))
{
return;
}
string courseDelText = String.Empty;
if (rdbFaceToFace.Checked)
{
courseDelText = "FaceToFace";
}
else if (rdbOnline.Checked)
{
courseDelText = "Online";
}
if (!clsValidation.ValidateDateStartVsEnd(dtpEnrolmentDate, dtpPaymentDueDate))
{
return;
}
if (!clsValidation.ValidateDateStartVsEnd(dtpPaymentDueDate, dtpExpectedEndDate))
{
return;
}
if (!clsValidation.ValidateTextBox(txtAmountDue))
{
txtAmountDue.Focus();
return;
}
if (!clsValidation.ValidateTextBoxForNumeric(txtAmountDue))
{
txtAmountDue.Focus();
return;
}
if (!clsValidation.ValidateDate(dtpPaymentDueDate))
{
return;
}
if (!clsValidation.ValidateComboBox(cmbPaymentMethod))
{
return;
}
if (!clsValidation.ValidateComboBox(cmbPaymentStatus))
{
return;
}
if (!clsValidation.ValidateDate(dtpDatePaid))
{
return;
}
if (!clsValidation.ValidateComboBox(cmbStudyStatus))
{
cmbStudyStatus.Focus();
return;
}
#endregion
clsEnrolment objEnrolment = new clsEnrolment(Convert.ToInt32(cmbStudentID.Text), Convert.ToInt32(cmbCourseID.Text),
dtpEnrolmentDate.Value.ToString("yyyy-MM-dd"), dtpExpectedEndDate.Value.ToString("yyyy-MM-dd"), courseDelText,
Convert.ToInt32(txtAmountDue.Text), dtpPaymentDueDate.Value.ToString("yyyy-MM-dd"), cmbPaymentMethod.Text,
cmbPaymentStatus.Text, dtpDatePaid.Value.ToString("yyyy-MM-dd"), cmbStudyStatus.Text);
objEnrolment.Add();
MessageBox.Show("Enrolment record successfully added!");
objEnrolment.ViewAll(dgvEnrolment);
}
