//Method for submit the add & update subject form
        private void btnAddSubject_Click_1(object sender, EventArgs e)
        {
            // Set changed botton of text to submit text if addSubject form change to update form
            if (isformValid())
            {
                //get value from input field
                s.ID            = lblIndex.Text;
                s.OfferSemester = dropOffSem.Text.Trim();
                s.OfferYear     = dropOffYear.Text.Trim();
                s.SubCode       = txtSubCode.Text.Trim();
                s.SubName       = txtSubName.Text.Trim();
                s.NumLecHr      = numLecHr.Value.ToString().Trim();
                s.NumTuteHr     = numTuteHr.Value.ToString().Trim();
                s.NumLabHr      = numLabHr.Value.ToString().Trim();
                s.NumEveHr      = numEveHr.Value.ToString().Trim();

                //Submit the add subject form
                if (btnAddSubject.Text == "Submit")
                {
                    // call chkSubID method(check lecturer id alredy in db)
                    bool exist = s.chkSubID(txtSubCode.Text.Trim());

                    //inserting data in to database using insertSubject method
                    if (exist == true)
                    {
                        bool success = s.insertSubject(s);

                        if (success == true)
                        {
                            MessageBox.Show("Subject was added Successfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        }
                        else
                        {
                            MessageBox.Show("Somthing went Worng!\n\nCannot insert the value!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Error);
                        }
                    }
                }

                //Submit the update subject form
                if (btnAddSubject.Text == "Update")
                {
                    //inserting data in to database using insertSubject method
                    bool success = s.updateSubject(s);

                    if (success == true)
                    {
                        MessageBox.Show("Update successful", "Informtion", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        this.Close();
                    }
                    else
                    {
                        MessageBox.Show("Update Failed", "Informtion", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    }
                }
            }
        }