private void DeleteComputerButton_Click(object sender, EventArgs e)
{
string queryString = "DELETE FROM dbo.PC_O WHERE Id_WorkPlace = '{0}'";
string queryStateString = "DELETE FROM dbo.State WHERE Id_WorkPlace = '{0}'";
string queryMoneyString = "DELETE FROM dbo.workPlace_Receips WHERE Id_WorkPlace = '{0}'";
SqlConnection sqlConnection = new SqlConnection(connectionString);
var ID = ComputersDataGridView.Rows[ComputersDataGridView.SelectedCells[0].RowIndex].Cells[0].Value;
string deleteFormat = string.Format(queryString, ID);
string deleteStateFormat = string.Format(queryStateString, ID);
string deleteMoneyFormat = string.Format(queryMoneyString, ID);
Sure_Form sure_Form = new Sure_Form();
if (sure_Form.ShowDialog() == DialogResult.Yes)
{
sqlConnection.Open();
SqlCommand deleteCommand = new SqlCommand(deleteFormat, sqlConnection);
deleteCommand.ExecuteNonQuery();
sqlConnection.Close();
sqlConnection.Open();
SqlCommand deleteStateCommand = new SqlCommand(deleteStateFormat, sqlConnection);
deleteStateCommand.ExecuteNonQuery();
sqlConnection.Close();
sqlConnection.Open();
SqlCommand deleteMoneyCommand = new SqlCommand(deleteMoneyFormat, sqlConnection);
deleteMoneyCommand.ExecuteNonQuery();
sqlConnection.Close();
}
}
private void DeleteButton_Click(object sender, EventArgs e)
{
Sure_Form sure_Form = new Sure_Form();
if (sure_Form.ShowDialog() == DialogResult.Yes)
{
string queryString = "DELETE FROM dbo.Workers WHERE lastName = N'{0}'";
SqlConnection sqlConnection = new SqlConnection(connectionString);
sqlConnection.Open();
string deleteFormat = string.Format(queryString, SearchTextBox.Text);
SqlCommand sqlCommand = new SqlCommand(deleteFormat, sqlConnection);
sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
}
}
private void DeletePS_Button_Click(object sender, EventArgs e)
{
Sure_Form sure_Form = new Sure_Form();
if (sure_Form.ShowDialog() == DialogResult.Yes)
{
string deleteString = "DELETE FROM dbo.state_of_PS WHERE PS = N'{0}'";
SqlConnection sqlConnection = new SqlConnection(connectionString);
string deleteFormat = string.Format(deleteString, PS_ComboBox.Text);
sqlConnection.Open();
SqlCommand sqlCommand = new SqlCommand(deleteFormat, sqlConnection);
sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
}
}
