public void addOrderItem(OrderItem orderItem)
{
using (var context = new ProductCatalogEntities_Orders())
{
context.OrderItems.Add(orderItem);
context.SaveChanges();
}
}
public Order getOrder(int orderId)
{
using (var context = new ProductCatalogEntities_Orders())
{
Order orderRecord = (from p in context.Orders
where p.OrderID == orderId
select p).FirstOrDefault <Order>();
return(orderRecord);
}
}
public Product getProduct(int productID)
{
using (var context = new ProductCatalogEntities_Orders())
{
Product product = (from p in context.Products
where p.Id == productID
select p).FirstOrDefault <Product>();
return(product);
}
}
public int addOrder(Order order)
{
using (var context = new ProductCatalogEntities_Orders())
{
context.Orders.Add(order);
context.SaveChanges();
}
return(order.OrderID);
}
public void removeOrderItem(int orderItemId)
{
using (var context = new ProductCatalogEntities_Orders())
{
OrderItem item = (from o in context.OrderItems
where o.Id == orderItemId
select o).FirstOrDefault <OrderItem>();
context.OrderItems.Remove(item);
context.SaveChanges();
}
}
public void ProcessOrder(Order order)
{
using (var context = new ProductCatalogEntities_Orders())
{
Order orderRecord = (from p in context.Orders
where p.OrderID == order.OrderID
select p).FirstOrDefault <Order>();
orderRecord.CustomerName = order.CustomerName;
orderRecord.OrderTotal = order.OrderTotal;
orderRecord.Status = "Processed";
context.SaveChanges();
}
}