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();
}
}