public void Update(Order order) { using (var db = new OrderDB()) { db.Order.Attach(order); db.Entry(order).State = EntityState.Modified; List <OrderDetails> odl = GetAllOrderDetails(); foreach (OrderDetails details in order.orderDetails) { bool exist = false; foreach (OrderDetails detailed in odl) { if (detailed.ID == details.ID) { exist = true; break; } } db.Entry(details).State = EntityState.Modified; if (!exist) { db.OrderDetail.Add(details); } } //order.orderDetails.ForEach( // item => db.Entry(item).State = EntityState.Modified); db.SaveChanges(); } }
public void Add(Order order) { using (var db = new OrderDB()) { db.Order.Add(order); db.SaveChanges(); } }
public void DeleteDetail(String Id) { using (var db = new OrderDB()) { var orderdetail = db.OrderDetail.SingleOrDefault(o => o.ID == Id); db.OrderDetail.Remove(orderdetail); db.SaveChanges(); } }
public void Delete(String orderId) { using (var db = new OrderDB()) { var order = db.Order.Include("Items").SingleOrDefault(o => o.Id == orderId); db.OrderDetail.RemoveRange(order.Details); db.Order.Remove(order); db.SaveChanges(); } }
public void Update(Order order) { using (var db = new OrderDB()) { db.Order.Attach(order); db.Entry(order).State = EntityState.Modified; order.Details.ForEach( item => db.Entry(item).State = EntityState.Modified); db.SaveChanges(); } }