public List <Buyer> GetFullList()
{
using (var context = new Sushi_barContext())
{
return(context.Buyer.ToList());
}
}
public List <Employee> GetFullList()
{
using (var context = new Sushi_barContext())
{
return(context.Employee.ToList());
}
}
public List <Menu> GetFullList()
{
using (var context = new Sushi_barContext())
{
return(context.Menu.ToList());
}
}
public OrdersMeni GetElement(int menuid, int orderid)
{
using (var context = new Sushi_barContext())
{
return(context.OrdersMeni.FirstOrDefault(rec => rec.MenuId == menuid && rec.OrdersId == orderid) ?? throw new Exception("OrdersMeni not found"));
}
}
public List <OrdersMeni> GetFullList()
{
using (var context = new Sushi_barContext())
{
return(context.OrdersMeni.ToList());
}
}
public Buyer GetElement(int id)
{
using (var context = new Sushi_barContext())
{
return(context.Buyer.FirstOrDefault(rec => rec.Id == id) ?? throw new Exception("Buyer not found"));
}
}
public Employee GetElement(int id)
{
using (var context = new Sushi_barContext())
{
return(context.Employee.FirstOrDefault(rec => rec.Id == id) ?? throw new Exception("Employee not found"));
}
}
public void Insert(Menu model)
{
using (var context = new Sushi_barContext())
{
context.Menu.Add(model);
context.SaveChanges();
}
}
public void Insert(Employee model)
{
using (var context = new Sushi_barContext())
{
context.Employee.Add(model);
context.SaveChanges();
}
}
public void Insert(OrdersMeni model)
{
using (var context = new Sushi_barContext())
{
context.OrdersMeni.Add(model);
context.SaveChanges();
}
}
public void Insert(Buyer model)
{
using (var context = new Sushi_barContext())
{
context.Buyer.Add(model);
context.SaveChanges();
}
}
public void Delete(int id)
{
using (var context = new Sushi_barContext())
{
Buyer element = context.Buyer.FirstOrDefault(rec => rec.Id == id);
if (element != null)
{
context.Buyer.Remove(element);
context.SaveChanges();
}
else
{
throw new Exception("Buyer not found");
}
}
}
public void Delete(int menuid, int orderid)
{
using (var context = new Sushi_barContext())
{
OrdersMeni element = context.OrdersMeni.FirstOrDefault(rec => rec.MenuId == menuid && rec.OrdersId == orderid);
if (element != null)
{
context.OrdersMeni.Remove(element);
context.SaveChanges();
}
else
{
throw new Exception("OrdersMeni not found");
}
}
}
public void Update(Employee model)
{
using (var context = new Sushi_barContext())
{
var element = context.Employee.FirstOrDefault(rec => rec.Id == model.Id);
if (element != null)
{
element.Fio = model.Fio;
element.Post = model.Post;
context.SaveChanges();
}
else
{
Insert(model);
}
}
}
public void Update(Orders model)
{
using (var context = new Sushi_barContext())
{
var element = context.Orders.FirstOrDefault(rec => rec.Id == model.Id);
if (element != null)
{
element.Employeeid = model.Employeeid;
element.Buyerid = model.Buyerid;
context.SaveChanges();
}
else
{
Insert(model);
}
}
}
public void Update(Buyer model)
{
using (var context = new Sushi_barContext())
{
var element = context.Buyer.FirstOrDefault(rec => rec.Id == model.Id);
if (element != null)
{
element.NameBuyer = model.NameBuyer;
element.NumberBuyer = model.NumberBuyer;
context.SaveChanges();
}
else
{
Insert(model);
}
}
}
public void Update(Menu model)
{
using (var context = new Sushi_barContext())
{
var element = context.Menu.FirstOrDefault(rec => rec.Id == model.Id);
if (element != null)
{
element.Price = model.Price;
element.Name = model.Name;
element.Volume = model.Volume;
element.Gram = model.Gram;
context.SaveChanges();
}
else
{
Insert(model);
}
}
}
