private void numericUpDown1_ValueChanged(object sender, EventArgs e)
{
using (Restaurant_businessEntities rb = new Restaurant_businessEntities(s))
{
agent agent = rb.agent.Where(x => x.id == numericIDAgent.Value).FirstOrDefault();
if (agent == null)
{
MessageBox.Show("Ошибка");
}
else
{
fnameAgent.Text = agent.lastmane;
nameAgent.Text = agent.firstname;
onameAgent.Text = agent.midname;
label19.Text = Convert.ToString(agent.id_company);
CompanuAgent.Text = rb.company.Find(Convert.ToInt32(label19.Text)).name;
}
}
}
private void button5_Click(object sender, EventArgs e)
{
using (Restaurant_businessEntities rb = new Restaurant_businessEntities(s))
{
agent agent = rb.agent.Where(x => x.id == numericIDAgent.Value).FirstOrDefault();
if (agent == null)
{
MessageBox.Show("Ошибка");
}
else
{
rb.agent.Where(x => x.id == numericIDAgent.Value).FirstOrDefault().lastmane = fnameAgent.Text;
rb.agent.Where(x => x.id == numericIDAgent.Value).FirstOrDefault().firstname = nameAgent.Text;
rb.agent.Where(x => x.id == numericIDAgent.Value).FirstOrDefault().midname = onameAgent.Text;
rb.SaveChanges();
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();
}
}
}
//Агент
}