private void button1_Click(object sender, EventArgs e)
{
if (TProdyct.Text.Length != 0 && TKol.Text.Length != 0 && TIzmeren.Text.Length != 0)
{
Form_InformAdd form = new Form_InformAdd();
form.ShowDialog();
this.OnLoad(e);
int prava = form.pravo;
if (prava == 1)
{
int idprod = getProdict(TProdyct.SelectedItem.ToString());
int idediz = getizmer(TIzmeren.SelectedItem.ToString());
string quest = "INSERT INTO Склад (ID_продукта, ID_ЕдИзмерний, Количество) VALUES('" + idprod + "','" + idediz + "','" + TKol.Text + "')";
db.connect.Open();
OleDbCommand dataAdapter = new OleDbCommand(quest, db.connect);
dataAdapter.ExecuteNonQuery();
db.connect.Close();
Form_Add formadd = new Form_Add();
formadd.ShowDialog();
}
}
else
{
using (Form_Add_PoleNo form = new Form_Add_PoleNo())
{
form.ShowDialog();
this.OnLoad(e);
}
}
}
private void button1_Click(object sender, EventArgs e)
{
if (TName.Text.Length != 0 && TKategor.Text.Length != 0 && TGod.Text.Length != 0 && TCena.Text.Length != 0 && TVes.Text.Length != 0)
{
Form_InformAdd form = new Form_InformAdd();
form.ShowDialog();
this.OnLoad(e);
int prava = form.pravo;
if (prava == 1)
{
int idkategor = getKategor(TKategor.SelectedItem.ToString());
string quest = "INSERT INTO Блюда (Название, Вес_порции, Цена, СрокГодности, ID_категор) VALUES('" + TName.Text + "','" + TVes.Text + "','" + TCena.Text + "','" + TGod.Text + "','" + idkategor + "')";
db.connect.Open();
OleDbCommand dataAdapter = new OleDbCommand(quest, db.connect);
dataAdapter.ExecuteNonQuery();
db.connect.Close();
Form_Add formadd = new Form_Add();
formadd.ShowDialog();
}
}
else
{
using (Form_Add_PoleNo form = new Form_Add_PoleNo())
{
form.ShowDialog();
this.OnLoad(e);
}
}
}
private void button1_Click(object sender, EventArgs e)
{
if (TKol.Text.Length != 0)
{
getProdict(idprodict);
getBlydocount(idprodict);
getSclad(e);
}
else
{
using (Form_Add_PoleNo form = new Form_Add_PoleNo())
{
form.ShowDialog();
this.OnLoad(e);
}
}
}
private void button1_Click(object sender, EventArgs e)
{
if (TName.Text.Length != 0 && TKategor.Text.Length != 0 && TGod.Text.Length != 0 && TCena.Text.Length != 0 && TVes.Text.Length != 0)
{
int idediz = getKatalog(TKategor.SelectedItem.ToString());
string quest = $"UPDATE Блюда SET Название = '{TName.Text}', Вес_порции = '{TVes.Value}', Цена = '{TCena.Text}' WHERE ID_блюда = {id}";
db.connect.Open();
OleDbCommand dataAdapter = new OleDbCommand(quest, db.connect);
dataAdapter.ExecuteNonQuery();
db.connect.Close();
Form_Add w = new Form_Add();
w.Show();
}
else
{
using (Form_Add_PoleNo form = new Form_Add_PoleNo())
{
form.ShowDialog();
this.OnLoad(e);
}
}
}
private void button1_Click(object sender, EventArgs e)
{
if (TProdyct.Text.Length != 0 && TKol.Text.Length != 0 && TIzmeren.Text.Length != 0)
{
int idprod = getProdict(TProdyct.SelectedItem.ToString());
int idediz = getizmer(TIzmeren.SelectedItem.ToString());
string quest = $"UPDATE Склад SET ID_продукта = '{idprod}', ID_ЕдИзмерний = '{idediz}', Количество = '{TKol.Text}' WHERE ID_записи = {id}";
db.connect.Open();
OleDbCommand dataAdapter = new OleDbCommand(quest, db.connect);
dataAdapter.ExecuteNonQuery();
db.connect.Close();
Form_Add w = new Form_Add();
w.Show();
}
else
{
using (Form_Add_PoleNo form = new Form_Add_PoleNo())
{
form.Show();
}
}
}
private void button1_Click(object sender, EventArgs e)
{
if (TKol.Text.Length != 0 && TProdyct.Text.Length != 0)
{
int idprodict = getProdict(TProdyct.SelectedItem.ToString());
string quest = $"UPDATE Меню SET ID_блюд = '{idprodict}', Дата = '{dateTimePicker1.Value.ToShortDateString()}', Количество = '{TKol.Text}' WHERE ID_запМеню = {id}";
db.connect.Open();
OleDbCommand dataAdapter = new OleDbCommand(quest, db.connect);
dataAdapter.ExecuteNonQuery();
db.connect.Close();
Form_Add w = new Form_Add();
w.Show();
}
else
{
using (Form_Add_PoleNo form = new Form_Add_PoleNo())
{
form.ShowDialog();
this.OnLoad(e);
}
}
}
