public bool SaveDish(int id_dish, string name_dish, int?id_selection, bool availability, string price1, string price2) //сохранение изменений
{
decimal rub = decimal.Parse(price1);
decimal kop = decimal.Parse(price2) * decimal.Parse((0.01).ToString());
var dish = db.list_of_dishes.FirstOrDefault(w => w.id_dish == id_dish);
if ((name_dish != "") && (price != 0) && (id_selection != null))
{
if (dish == null)
{
dish = new list_of_dishes();
dish.id_dish = id_dish;
}
dish.name_dish = employee.Savestring(name_dish);
dish.id_selection = id_selection;
dish.availability = availability;
dish.price = rub + kop;
db.list_of_dishes.AddOrUpdate(dish);
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
public bool DeleteStock(int id) //возврат акции, информацию о которой необходимо удалить
{
try
{
var emp = db.stocks.First(w => w.id_stock == id);
db.stocks.Remove(emp);
db.SaveChanges();
return(true);
}
catch { return(false); }
}
public bool DeleteEmp(int id, employee empl) //возврат сотрудника, информацию о котором необходимо удалить
{
try
{
if (id != empl.id_employee)
{
var emp = db.employee.First(w => w.id_employee == id);
db.employee.Remove(emp);
db.SaveChanges();
}
return(true);
}
catch { return(false); }
}
public int SaveOrd(int id_emp, int id_tab) //сохранение информации о заказе
{
orders ord = new orders();
ord.id_employee = db.employee.First(p => p.id_employee == id_emp).id_employee;
ord.id_table = id_tab;
ord.time_order = DateTime.Now.TimeOfDay;
var stock = new List <stocks>();
if (db.stocks.Where(p => p.start_time < p.end_time) != null)
{
stock = db.stocks.Where(p => p.start_time <= ord.time_order && p.end_time >= ord.time_order).ToList();
}
if (db.stocks.Where(p => p.start_time > p.end_time) != null)
{
stock.AddRange(db.stocks.Where(p => (p.start_time > p.end_time) && ((p.start_time >= ord.time_order) || (p.end_time >= ord.time_order))).ToList());
}
if (stock.Count != 0)
{
var discount = stock.Min(p => p.discount);
ord.id_stock = db.stocks.First(p => p.discount == discount).id_stock;
}
else
{
ord.id_stock = null;
}
db.orders.Add(ord);
db.SaveChanges();
foreach (content_orders i in ListDishesinOrd)
{
var content = new content_orders();
content.id_content_order = i.id_content_order;
content.id_order = ord.id_order;
content.id_dish = db.list_of_dishes.First(p => p.id_dish == i.id_dish).id_dish;
content.count_dish = i.count_dish;
db.content_orders.Add(content);
db.SaveChanges();
}
return(ord.id_order);
}
public void EditContOrd(int id_cont, int count) //изменение конечного списка заказа (в случае возврата блюда)
{
var edit = db.content_orders.First(p => p.id_content_order == id_cont);
if (count != 0)
{
edit.count_dish = count;
db.content_orders.AddOrUpdate(edit);
}
else
{
db.content_orders.Remove(edit);
}
db.SaveChanges();
}