private void btnSubmit_Click(object sender, EventArgs e)
 {
     try
     {
         if (dataGridView1.Rows.Count <= 0)
         {
             return;
         }
         if (!MyMSB.Show("តើអ្នកពិតជាចង់រក្សាទុកមែនទេ?", "1", true))
         {
             return;
         }
         StoreProcedure.spd_insert_tp(dataGridView1);
         dataGridView1.Rows.Clear();
         MyMSB.Show("ការរក្សាទុកបានជោគជ័យ", "1", false);
         this.fun_getAllPatientServiceTableAdapter.Fill(this.dentistDataSet.fun_getAllPatientService, int.Parse(GlobalVariable._Pat_id));
         btnNext.PerformClick();
     }
     catch (Exception t)
     {
         GlobalMethod.HandleException("frm_doc_treatment + btnSubmit_Click :" + t.Message + t.StackTrace);
     }
 }
 private void btnSubmit_Click(object sender, EventArgs e)
 {
     try
     {
         if (dgvMed1.Rows.Count <= 0)
         {
             return;
         }
         if (!MyMSB.Show("តើអ្នកពិតជាចង់រក្សាទុកមែនទេ?", "1", true))
         {
             return;
         }
         StoreProcedure.spd_insert_prescription(dgvMed1);
         StoreProcedure.sp_prescript(dgvMed1);
         dgvMed1.Rows.Clear();
         MyMSB.Show("ការរក្សាទុកបានជោគជ័យ", "1", false);
         this.fun_getPrescriptionByPatIDTableAdapter.Fill(this.dentistDataSet.fun_getPrescriptionByPatID, int.Parse(GlobalVariable._Pat_id));
         btnBack.PerformClick();
     }
     catch (Exception t)
     {
         GlobalMethod.HandleException("frm_patient_prescription + btnSubmit_Click :" + t.Message + t.StackTrace);
     }
 }