private void TeacherForm_Load(object sender, EventArgs e)
        {
            clsTeacher objTeacher = new clsTeacher();

            ComboBox[] cmb = new ComboBox[] { cmbSuburbID, cmbSuburbName, cmbPostCode, cmbSkill };
            objTeacher.Load(cmb);
            objTeacher.ViewAll(dgvTeacher);
        }
        private void mnuDelete_Click(object sender, EventArgs e)
        {
            if (!clsValidation.ValidateTextBoxForNumeric(txtTeacherID))
            {
                txtTeacherID.Focus();
                return;
            }
            clsTeacher objTeacher = new clsTeacher(Convert.ToInt32(txtTeacherID.Text));

            objTeacher.Delete();
            MessageBox.Show("Teacher record successfully deleted");
            objTeacher.ViewAll(dgvTeacher);
        }
        private void mnuViewAll_Click(object sender, EventArgs e)
        {
            clsTeacher objTeacher = new clsTeacher();

            objTeacher.ViewAll(dgvTeacher);
        }
        private void mnuAdd_Click(object sender, EventArgs e)
        {
            #region ValidationArea
            if (!clsValidation.ValidateTextBox(txtTeacherFirstName))
            {
                txtTeacherFirstName.Focus();
                return;
            }
            if (!clsValidation.ValidateForAlphabet(txtTeacherFirstName))
            {
                txtTeacherFirstName.Focus();
                return;
            }
            if (!clsValidation.ValidateNameFormat(txtTeacherFirstName))
            {
                txtTeacherFirstName.Focus();
                return;
            }
            if (!clsValidation.ValidateTextBox(txtTeacherLastName))
            {
                txtTeacherLastName.Focus();
                return;
            }
            if (!clsValidation.ValidateForAlphabet(txtTeacherLastName))
            {
                txtTeacherLastName.Focus();
                return;
            }
            if (!clsValidation.ValidateNameFormat(txtTeacherLastName))
            {
                txtTeacherLastName.Focus();
                return;
            }
            if (!clsValidation.ValidateDate(dtpDateOfBirth))
            {
                return;
            }
            if (!clsValidation.ValidateRadioButton(rdbMale, rdbFemale))
            {
                return;
            }
            if (!clsValidation.ValidateTextBox(txtTeacherStreetAddress))
            {
                txtTeacherStreetAddress.Focus();
                return;
            }
            if (!clsValidation.ValidateStreetAddress(txtTeacherStreetAddress))
            {
                txtTeacherStreetAddress.Focus();
                return;
            }
            if (!clsValidation.ValidateComboBox(cmbSuburbName))
            {
                return;
            }
            //if (!clsValidation.ValidateTextBox(txtTeacherPostCode))
            //{
            //    txtTeacherPostCode.Focus();
            //    return;
            //}
            //if (!clsValidation.ValidateTextBoxForNumeric(txtTeacherPostCode))
            //{
            //    txtTeacherPostCode.Focus();
            //    return;
            //}
            //if (!clsValidation.ValidatePostCode(txtTeacherPostCode.Text))
            //{
            //    txtTeacherPostCode.Focus();
            //    return;
            //}
            if (!clsValidation.ValidateTextBox(txtTeacherPhoneNum))
            {
                txtTeacherPhoneNum.Focus();
                return;
            }
            if (!clsValidation.ValidatePhoneNumber(txtTeacherPhoneNum))
            {
                txtTeacherPhoneNum.Focus();
                return;
            }
            if (!clsValidation.ValidateTextBox(txtTeacherEmail))
            {
                txtTeacherEmail.Focus();
                return;
            }
            if (!clsValidation.ValidateEmail(txtTeacherEmail))
            {
                txtTeacherEmail.Focus();
                return;
            }
            if (!clsValidation.ValidateDate(dtpCommencementDate))
            {
                return;
            }
            if (!clsValidation.ValidateDateStartVsEnd(dtpDateOfBirth, dtpCommencementDate))
            {
                return;
            }
            if (!clsValidation.ValidateComboBox(cmbTeacherDepartment))
            {
                return;
            }
            //if (!clsValidation.ValidateTextBox(txtTeacherSkills))
            //{
            //    txtTeacherSkills.Focus();
            //    return;
            //}
            //if (!clsValidation.ValidateForAlphabet(txtTeacherSkills))
            //{
            //    txtTeacherSkills.Focus();
            //    return;
            //}
            if (!clsValidation.ValidateRadioButton(rdbASYes, rdbASNo))
            {
                return;
            }
            #endregion

            string genderText = String.Empty;
            if (rdbMale.Checked)
            {
                genderText = "M";
            }
            else if (rdbFemale.Checked)
            {
                genderText = "F";
            }
            string leaveText = String.Empty;
            if (rdbASYes.Checked)
            {
                leaveText = "Yes";
            }
            else if (rdbASNo.Checked)
            {
                leaveText = "No";
            }
            clsTeacher objTeacher = new clsTeacher(txtTeacherFirstName.Text,
                                                   txtTeacherLastName.Text, genderText, dtpDateOfBirth.Value.ToString("yyyy-MM-dd"), txtTeacherStreetAddress.Text,
                                                   Convert.ToInt32(cmbSuburbID.Text), cmbPostCode.Text, txtTeacherPhoneNum.Text, txtTeacherEmail.Text,
                                                   dtpCommencementDate.Value.ToString("yyyy-MM-dd"), cmbTeacherDepartment.Text, leaveText);
            objTeacher.Add();
            MessageBox.Show("Teacher record successfully added!");
            objTeacher.ViewAll(dgvTeacher);
        }