//Выход с формы удаления мастеров 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(); } } } }