private void button2_Click(object sender, EventArgs e)
{
using (Restaurant_businessEntities rb = new Restaurant_businessEntities(s))
{
company company = rb.company.Where(x => x.index_company == maskedTextIndexCompany.Text).FirstOrDefault();
if (company == null)
{
MessageBox.Show("Ошибка");
}
else
{
rb.company.Where(x => x.index_company == maskedTextIndexCompany.Text).FirstOrDefault().name = textNameCompany.Text;
rb.company.Where(x => x.index_company == maskedTextIndexCompany.Text).FirstOrDefault().index_company = maskedTextIndexCompany.Text;
rb.SaveChanges();
MessageBox.Show("Запись изменена");
}
}
}
private void button10_Click(object sender, EventArgs e)
{
using (Restaurant_businessEntities rb = new Restaurant_businessEntities(s))
{
try
{
company company = rb.company.Where(x => x.name == CompanuAgent.Text).FirstOrDefault();
if (company == null)
{
label19.Text = "";
MessageBox.Show("нет такой компании");
}
else
{
label19.Text = Convert.ToString(company.id);
}
}
catch
{
MessageBox.Show("Ошибка");
}
}
}
private void button2_Click_1(object sender, EventArgs e)
{
string str = Tabls.Text;
if (str == "Агент")
{
using (Restaurant_businessEntities rb = new Restaurant_businessEntities(s))
{
try
{
int a = Convert.ToInt32(numericUpDownMain.Value);
List <agent> lists = rb.agent.ToList();
agent agent = rb.agent.Where(x => x.id == a).FirstOrDefault();
if (agent == null)
{
MessageBox.Show("Нет такого значения");
}
else
{
rb.agent.Remove(agent);
rb.SaveChanges();
}
}
catch
{
MessageBox.Show("Нет прав");
}
}
}
else if (str == "Компания")
{
using (Restaurant_businessEntities rb = new Restaurant_businessEntities(s))
{
company company = rb.company.Where(x => x.id == numericUpDownMain.Value).FirstOrDefault();
if (company == null)
{
MessageBox.Show("Нет такого значения");
}
else
{
rb.company.Remove(company);
rb.SaveChanges();
}
}
}
else if (str == "Заказ")
{
using (Restaurant_businessEntities rb = new Restaurant_businessEntities(s))
{
order order = rb.order.Where(x => x.id == numericUpDownMain.Value).FirstOrDefault();
if (order == null)
{
MessageBox.Show("Нет такого значения");
}
else
{
rb.order.Remove(order);
rb.SaveChanges();
}
}
}
else if (str == "Продукт")
{
using (Restaurant_businessEntities rb = new Restaurant_businessEntities(s))
{
product product = rb.product.Where(x => x.id == numericUpDownMain.Value).FirstOrDefault();
if (product == null)
{
MessageBox.Show("Нет такого значения");
}
else
{
rb.product.Remove(product);
rb.SaveChanges();
}
}
}
//Агент
}