private void button5_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count != 0) { MySqlOperations.Delete(MySqlQueries.Delete_Pribytiya, dataGridView1.SelectedRows[0].Cells[0].Value.ToString()); MySqlOperations.Select_DataGridView(MySqlQueries.Select_Pribytiya_Kartochki, dataGridView1, ID); } }
private void Delete_String() { if (identify == "othody") { for (int i = 0; i < dataGridView1.SelectedRows.Count; i++) { MySqlOperations.Delete(MySqlQueries.Delete_Othody, dataGridView1.SelectedRows[i].Cells[0].Value.ToString()); } MySqlOperations.Select_DataGridView(MySqlQueries.Select_Othody, dataGridView1); } else if (identify == "sotrudniki") { for (int i = 0; i < dataGridView1.SelectedRows.Count; i++) { MySqlOperations.Delete(MySqlQueries.Delete_Sotrudniki, dataGridView1.SelectedRows[i].Cells[0].Value.ToString()); } MySqlOperations.Select_DataGridView(MySqlQueries.Select_Sotrudniki, dataGridView1); } else if (identify == "otdely") { for (int i = 0; i < dataGridView1.SelectedRows.Count; i++) { MySqlOperations.Delete(MySqlQueries.Delete_Otdely, dataGridView1.SelectedRows[i].Cells[0].Value.ToString()); } MySqlOperations.Select_DataGridView(MySqlQueries.Select_Otdely, dataGridView1); } else if (identify == "organizacii") { for (int i = 0; i < dataGridView1.SelectedRows.Count; i++) { MySqlOperations.Delete(MySqlQueries.Delete_Organizacii, dataGridView1.SelectedRows[i].Cells[0].Value.ToString()); } MySqlOperations.Select_DataGridView(MySqlQueries.Select_Organizacii, dataGridView1); } else if (identify == "kartochka") { for (int i = 0; i < dataGridView1.SelectedRows.Count; i++) { MySqlOperations.Delete(MySqlQueries.Delete_Kartochka, dataGridView1.SelectedRows[i].Cells[0].Value.ToString()); } MySqlOperations.Select_DataGridView(MySqlQueries.Select_Kartochka, dataGridView1); } else if (identify == "ubytiya") { for (int i = 0; i < dataGridView1.SelectedRows.Count; i++) { MySqlOperations.Delete(MySqlQueries.Delete_Ubytiya, dataGridView1.SelectedRows[i].Cells[0].Value.ToString()); } MySqlOperations.Select_DataGridView(MySqlQueries.Select_Kartochka, dataGridView1); } else if (identify == "pribytiya") { for (int i = 0; i < dataGridView1.SelectedRows.Count; i++) { MySqlOperations.Delete(MySqlQueries.Delete_Pribytiya, dataGridView1.SelectedRows[i].Cells[0].Value.ToString()); } MySqlOperations.Select_DataGridView(MySqlQueries.Select_Kartochka, dataGridView1); } }
private void toolStripMenuItem2_Click(object sender, EventArgs e) { if (MessageBox.Show("Вы точно хотите удалить карточку(-и)?", "Вопрос", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { for (int i = 0; i < dataGridView1.SelectedRows.Count; i++) { MySqlOperations.Delete(MySqlQueries.Delete_Kartochka, dataGridView1.SelectedRows[i].Cells[0].Value.ToString()); } MySqlOperations.Select_DataGridView(MySqlQueries.Select_Kartochka_Otdela, dataGridView1, ID); } }