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);
}
}
