private void button6_Click(object sender, EventArgs e)
{
if (DGVIEWBlydo.RowCount != 0)
{
int iddel = Convert.ToInt32(DGVIEWBlydo[0, DGVIEWBlydo.CurrentCell.RowIndex].Value);
Form_InformDelete form = new Form_InformDelete();
form.ShowDialog();
this.OnLoad(e);
int prava = form.pravo;
if (prava == 1)
{
string quest = $"DELETE FROM Блюда WHERE ID_блюда = {iddel}";
db.connect.Open();
OleDbCommand dataCommander = new OleDbCommand(quest, db.connect);
dataCommander.ExecuteNonQuery();
OleDbDataAdapter dataAdapter = new OleDbDataAdapter(db.selectBlydo, db.connect);
DataSet ds = new DataSet();
dataAdapter.Fill(ds);
db.connect.Close();
DGVIEWBlydo.DataSource = ds.Tables[0].DefaultView;
DGVIEWBlydo.Columns[0].Visible = false;
}
}
}
private void button3_Click(object sender, EventArgs e)
{
if (DGVIEWBlydo.RowCount != 0)
{
Form_InformDelete form = new Form_InformDelete();
form.ShowDialog();
this.OnLoad(e);
int prava = form.pravo;
if (prava == 1)
{
int iddel = Convert.ToInt32(DGVIEWSostav[0, DGVIEWSostav.CurrentCell.RowIndex].Value);
string quest = $"DELETE FROM СоставБлюд WHERE ID_зап = {iddel}";
db.connect.Open();
OleDbCommand dataCommander = new OleDbCommand(quest, db.connect);
dataCommander.ExecuteNonQuery();
DGSostav(idblydo);
DGVIEWSostav.Columns[0].Visible = false;
}
}
}
