public void Add(OrderList order) { using (var db = new OrderDB()) { db.Order.Add(order); db.SaveChanges(); } }
public void Update(OrderList order) { using (var db = new OrderDB()) { db.Order.Attach(order); db.Entry(order).State = EntityState.Modified; order.ListOfDetails.ForEach(detail => db.Entry(detail).State = EntityState.Modified); db.SaveChanges(); } }
public void Delete(string orderId) { using (var db = new OrderDB()) { var order = db.Order.Include("ListOfDetails").SingleOrDefault(o => o.OrderId == orderId); //db.DetailsList.RemoveRange(order.ListOfDetails); db.Order.Remove(order); db.SaveChanges(); } }