public OrderDetail Get(int id_order, int id_item)
{
using (SQliteDBContext context = new SQliteDBContext())
{
return(context.OrderDetails.Where(o => o.ItemID == id_item && o.OrderID == id_order).First());
}
}
public void Create(OrderDetail entity)
{
using (SQliteDBContext context = new SQliteDBContext())
{
context.OrderDetails.Add(entity);
context.SaveChangesAsync();
}
}
public void Delete(int id_order, int id_item)
{
using (SQliteDBContext context = new SQliteDBContext())
{
var orderDetail = context.OrderDetails.Where(o => o.ItemID == id_item && o.OrderID == id_order).First();
context.OrderDetails.Remove(orderDetail);
context.SaveChangesAsync();
}
}
public ItemData()
{
context = new SQliteDBContext();
}
public List <OrderDetail> GetALL()
{
SQliteDBContext context = new SQliteDBContext();
return(context.OrderDetails.ToList());
}
public CategoryData()
{
context = new SQliteDBContext();
}
