//Выход с формы удаления мастеров
        private void buttonCancel_Click(object sender, EventArgs e)
        {
            FormViewMasters viewMasters = new FormViewMasters();

            viewMasters.Show();
            this.Close();
        }
        //Открытие формы просмотра мастеров
        private void buttonShowMasters_Click(object sender, EventArgs e)
        {
            FormViewMasters viewMasters = new FormViewMasters();

            viewMasters.Show();
            this.Hide();
        }
 private void buttonDel_Click(object sender, EventArgs e)
 {
     //Проверка на ввод ID мастера
     if (textBoxEnterID.Text == "")
     {
         DialogResult result = MessageBox.Show("Введите ID мастера которого хотите удалить", "Внимание!", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.DefaultDesktopOnly);
         if (result == DialogResult.OK)
         {
             textBoxEnterID.Focus();
         }
     }
     //Выполнение удаления мастера, если он введен
     else
     {
         using (SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-KU11OGM\SQLEXPRESS;Initial Catalog=Workshop;Integrated Security=True"))
         {
             try
             {
                 int IDMaster = Convert.ToInt32(textBoxEnterID.Text);
                 con.Open();
                 SqlCommand cmdMasters          = con.CreateCommand();
                 SqlCommand cmdPassportMasters  = con.CreateCommand();
                 SqlCommand cmdEducationMasters = con.CreateCommand();
                 //Удаление данных мастера
                 cmdMasters.CommandText          = "DELETE FROM [Masters] WHERE MasterID = '" + IDMaster + "'";
                 cmdPassportMasters.CommandText  = "DELETE FROM [MastersPassportData] WHERE MasterID = '" + IDMaster + "'";
                 cmdEducationMasters.CommandText = "DELETE FROM [MastersEducation] WHERE MasterID = '" + IDMaster + "'";
                 //Подверждение удаления мастера
                 DialogResult result = MessageBox.Show("Удалить мастера?", "Удаление мастера", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.DefaultDesktopOnly);
                 if (result == DialogResult.Yes)
                 {
                     cmdPassportMasters.ExecuteNonQuery();
                     cmdEducationMasters.ExecuteNonQuery();
                     cmdMasters.ExecuteNonQuery();
                     FormViewMasters viewMasters = new FormViewMasters();
                     viewMasters.Show();
                     this.Close();
                 }
             }
             catch (Exception ex)
             {
                 MessageBox.Show(Convert.ToString(ex));
             }
             finally
             {
                 con.Close();
             }
         }
     }
 }
 private void buttonAdd_Click(object sender, EventArgs e)
 {
     // Проверка на заполнение всех данных
     if (textBoxSurname.Text == "" || textBoxDataSNILS.Text == "" || textBoxName.Text == "" || textBoxSpecialization.Text == "" || textBoxPasportNomber.Text == "" || textBoxPassportIssued.Text == "" || textBoxRegistredAt.Text == "" || textBoxPassportSeries.Text == "" || textBoxTelephone.Text == "" || comboBoxFormEducation.Text == "" || comboBoxKindOfEducation.Text == "" || textBoxPassword.Text == "" || textBoxMail.Text == "")
     {
         buttonAdd.Enabled = false;
         MessageBox.Show("Заполните все данные");
     }
     if (dateTimePickerDateStartEducation.Value == dateTimePickerDateEndEducation.Value)
     {
         MessageBox.Show("Начало обучения не может совпадать с его окончанием");
     }
     else
     {
         using (SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-KU11OGM\SQLEXPRESS;Initial Catalog=Workshop;Integrated Security=True"))
         {
             try
             {
                 con.Open();
                 SqlCommand cmdMasters          = con.CreateCommand();
                 SqlCommand cmdPassportMasters  = con.CreateCommand();
                 SqlCommand cmdEducationMasters = con.CreateCommand();
                 //Добавление данных в таблицу Masters
                 cmdMasters.CommandText = "insert into [Masters] values ('" + Data.ValueIDMaster + "','" + textBoxSurname.Text + "','" + textBoxName.Text + "','" + textBoxPatronymic.Text + "','" + dateTimePickerDateOfBirth.Value + "','" + textBoxDataSNILS.Text + "','" + textBoxSpecialization.Text + "','" + textBoxMail.Text + "','" + textBoxTelephone.Text + "','" + textBoxPassword.Text + "','" + DateTime.Now + "')";
                 //Добавление данных в таблицу MastersPasportData
                 cmdPassportMasters.CommandText = "insert into [MastersPassportData] values ('" + Data.ValueIDMaster + "', '" + textBoxPassportSeries.Text + "','" + textBoxPasportNomber.Text + "','" + dateTimePickerExtraditionDate.Value + "','" + textBoxPassportIssued.Text + "','" + textBoxRegistredAt.Text + "')";
                 //Добавление данных в таблицу MastersEduccation
                 cmdEducationMasters.CommandText = "insert into [MastersEducation] values ('" + Data.ValueIDMaster + "','" + comboBoxKindOfEducation.Text + "','" + comboBoxFormEducation.Text + "','" + dateTimePickerDateStartEducation.Value + "','" + dateTimePickerDateEndEducation.Value + "')";
                 cmdMasters.ExecuteNonQuery();
                 cmdPassportMasters.ExecuteNonQuery();
                 cmdEducationMasters.ExecuteNonQuery();
                 FormViewMasters viewMasters = new FormViewMasters();
                 viewMasters.Show();
                 this.Close();
             }
             catch (Exception ex)
             {
                 MessageBox.Show(Convert.ToString(ex));
             }
             finally
             {
                 con.Close();
             }
         }
     }
 }