Пример #1
0
 //--------------------------------------------------------
 private void bttnOK_Click(object sender, EventArgs e)
 {
     if (bttnOK.Text == "Далее")
     {
         MySqlCommand cAdd = new MySqlCommand("INSERT INTO клиент(`Номер и серия паспорта`, ФИО, `Дата рождения`, СНИЛС, `Номер телефона`, `Адрес проживания`, `e-mail`) VALUES " +
                                              "('" + tbPassport.Text + "', '" + tbFN.Text + "', '" + datePickerBirthday.Text + "', '" + tbSNILS.Text + "', '" + tbNumbPhone.Text + "', '" + tbAdress.Text + "', '" + tbEMail.Text + "')", frmAuthorization.connection);
         if (cAdd.ExecuteNonQuery() == 1)
         {
             DialogResult = DialogResult.OK;
             string        passport = tbPassport.Text;
             frmAddRequest FAR      = new frmAddRequest(passport, UserID);
             FAR.bttnOK.Text        = "Добавить";
             FAR.labelPanelReq.Text = "Добавить заявку";
             FAR.labelPanelReq.Left = (ClientSize.Width - FAR.labelPanelReq.Width) / 2;
             FAR.ShowDialog();
         }
     }
     else if (bttnOK.Text == "Изменить")
     {
         MySqlCommand cChng = new MySqlCommand("UPDATE клиент SET `Номер и серия паспорта`= '" + tbPassport.Text + "', ФИО= '" + tbFN.Text + "', `Дата рождения`= '" + datePickerBirthday.Text + "', " +
                                               "СНИЛС= '" + tbSNILS.Text + "', `Номер телефона`= '" + tbNumbPhone.Text + "', `Адрес проживания`= '" + tbAdress.Text + "', `e-mail`= '" + tbEMail.Text + "' WHERE `Номер и серия паспорта`= '" + Passport + "'", frmAuthorization.connection);
         MySqlCommand cChng2 = new MySqlCommand("UPDATE заявка SET `Номер и серия паспорта`= '" + tbPassport.Text + "' WHERE `Номер и серия паспорта`= '" + Passport + "'", frmAuthorization.connection);
         if (cChng.ExecuteNonQuery() == 1)
         {
             cChng2.ExecuteNonQuery();
             DialogResult = DialogResult.OK;
         }
     }
 }
Пример #2
0
 /*
  * Add data
  */
 private void bttnAdd_Click(object sender, EventArgs e)
 {
     if (tabMenu.SelectedTab == pageClients)
     {
         try {
             frmAddRequest FAR = new frmAddRequest(dataTableClients.SelectedRows[0].Cells[0].Value.ToString(), UserID);
             FAR.bttnOK.Text        = "Добавить";
             FAR.labelPanelReq.Text = "Добавить заявку";
             FAR.labelPanelReq.Left = (ClientSize.Width - FAR.labelPanelReq.Width) / 2;
             FAR.ShowDialog();
             if (FAR.DialogResult == DialogResult.OK)
             {
                 bttnRefresh_Click(sender, e);
             }
         }
         catch {
             ErrorClient EC = new ErrorClient();
             EC.Show();
         }
     }
     else if (tabMenu.SelectedTab == pageRequests)
     {
         frmAddClient FAC = new frmAddClient(UserID, null);
         FAC.ShowDialog();
         if (FAC.DialogResult == DialogResult.OK)
         {
             bttnRefresh_Click(sender, e);
         }
     }
 }
Пример #3
0
 /*
  * Change data
  */
 private void bttnChange_Click(object sender, EventArgs e)
 {
     try {
         if (tabMenu.SelectedTab == pageClients)
         {
             frmAddClient FAC = new frmAddClient(dataTableClients.SelectedRows[0].Cells[0].Value.ToString(), UserID);
             FAC.tbPassport.Text         = dataTableClients.SelectedRows[0].Cells[0].Value.ToString();
             FAC.tbFN.Text               = dataTableClients.SelectedRows[0].Cells[1].Value.ToString();
             FAC.datePickerBirthday.Text = dataTableClients.SelectedRows[0].Cells[2].Value.ToString();
             FAC.tbSNILS.Text            = dataTableClients.SelectedRows[0].Cells[3].Value.ToString();
             FAC.tbNumbPhone.Text        = dataTableClients.SelectedRows[0].Cells[4].Value.ToString();
             FAC.tbAdress.Text           = dataTableClients.SelectedRows[0].Cells[5].Value.ToString();
             FAC.tbEMail.Text            = dataTableClients.SelectedRows[0].Cells[6].Value.ToString();
             FAC.ShowDialog();
             if (FAC.DialogResult == DialogResult.OK)
             {
                 bttnRefresh_Click(sender, e);
             }
         }
         else if (tabMenu.SelectedTab == pageRequests)
         {
             frmAddRequest FAR = new frmAddRequest(dataTableRequests.SelectedRows[0].Cells[0].Value.ToString(), UserID);
             FAR.cbNameAnalysis.Text    = dataTableRequests.SelectedRows[0].Cells[1].Value.ToString();
             FAR.datePickerRequest.Text = dataTableRequests.SelectedRows[0].Cells[4].Value.ToString();
             FAR.tbResult.Text          = dataTableRequests.SelectedRows[0].Cells[5].Value.ToString();
             FAR.bttnOK.Text            = "Подтвердить";
             FAR.labelPanelReq.Text     = "Подтвердить результат анализа";
             FAR.labelPanelReq.Left     = (ClientSize.Width - FAR.labelPanelReq.Width) / 2;
             FAR.ShowDialog();
             if (FAR.DialogResult == DialogResult.OK)
             {
                 bttnRefresh_Click(sender, e);
             }
         }
         else if (tabMenu.SelectedTab == pageServices)
         {
             frmAddServices FAS = new frmAddServices(dataTableServices.SelectedRows[0].Cells[0].Value.ToString());
             FAS.tbName.Text           = dataTableServices.SelectedRows[0].Cells[0].Value.ToString();
             FAS.tbPrice.Text          = dataTableServices.SelectedRows[0].Cells[1].Value.ToString();
             FAS.tbTerm.Text           = dataTableServices.SelectedRows[0].Cells[2].Value.ToString();
             FAS.tbRecommendation.Text = dataTableServices.SelectedRows[0].Cells[3].Value.ToString();
             FAS.bttnOK.Text           = "Изменить";
             FAS.labelPanelAdm.Text    = "Изменить данные услуги";
             FAS.labelPanelAdm.Left    = (ClientSize.Width - FAS.labelPanelAdm.Width) / 2;
             FAS.ShowDialog();
             if (FAS.DialogResult == DialogResult.OK)
             {
                 bttnRefresh_Click(sender, e);
             }
         }
     }
     catch {
         ErrorChangeData errorCD = new ErrorChangeData();
         errorCD.Show();
     }
 }