public int addNewOrder(Order newOrder) { using (var context = new MovieStoreEDM()) { context.Orders.Add(newOrder); context.SaveChanges(); return(newOrder.Id); } }
public void addOrderItem(OrderItem orderItem) { using (var context = new MovieStoreEDM()) { context.OrderItems.Add(orderItem); try { context.SaveChanges(); } catch { } } }
public void updateOrder(Order order) { using (var context = new MovieStoreEDM()) { Order orderRecord = (from p in context.Orders where p.Id == order.Id select p).FirstOrDefault <Order>(); orderRecord.Customer = order.Customer; orderRecord.Total = order.Total; orderRecord.Status = 0; context.SaveChanges(); } }