private void btnDelete_Click(object sender, EventArgs e)
        {
            PatientDBOper mdbo = new PatientDBOper();

            string patnic = txtpatinic.Text.Trim();

            mdbo.deletepatient(patnic);

            MessageBox.Show("Patient Details Deleted Successfully", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
        }
        private void btnSubmit_Click(object sender, EventArgs e)
        {
            string nic      = txtpatinic.Text.Trim();
            string fname    = txtpatifn.Text.Trim();
            string lname    = txtptiln.Text.Trim();
            string addline1 = txtaddli1.Text.Trim();
            string street   = txtstre.Text.Trim();
            string city     = txtcity.Text.Trim();
            string front_office_clerksId = cmbfronoffid.Text.Trim();
            string doctors_nic           = cmbdocnic.Text;
            bool   is_paid         = checkispaid.Checked;
            float  reg_fee         = float.Parse(txtrefee.Text.Trim());
            string appoinment_date = datetpic.Text;


            Patient patient = new Patient(nic, fname, lname, addline1, street, city, front_office_clerksId, doctors_nic, is_paid, reg_fee, appoinment_date);

            PatientDBOper pdbo = new PatientDBOper();


            pdbo.resgisterPatient(patient);
            MessageBox.Show("Successfully Registered the Patient", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
        }