public IEnumerable <Item> GetAllItems()
{
using (OrderSystemEntitiesCtx entities = new OrderSystemEntitiesCtx())
{
return(entities.Items.ToList());
}
}
public Extra GetExtra(int ExtraID)
{
using (OrderSystemEntitiesCtx entities = new OrderSystemEntitiesCtx())
{
return(entities.Extras.FirstOrDefault(e => e.ExtraID == ExtraID));
}
}
public Item GetItem(int ItemID)
{
using (OrderSystemEntitiesCtx entities = new OrderSystemEntitiesCtx())
{
return(entities.Items.FirstOrDefault(i => i.ItemID == ItemID));
}
}
public IHttpActionResult CompleteOrder(OrderReadModel OrderItem) //give it a read model
{
IHttpActionResult newOrder;
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var listOfOrderItemIDs = this.addOrderItems(OrderItem);
using (OrderSystemEntitiesCtx entities = new OrderSystemEntitiesCtx())
{
Order currentOrder = new Order()
{
CustomerID = OrderItem.CustomerID,
Completed = true,
Cancelled = false,
TotalPrice = OrderItem.TotalPrice,
Tax = OrderItem.TotalPrice - OrderItem.Price,
Date = DateTime.Now,
MonthYear = string.Format("{0:MMMM yyyy}", DateTime.Now)
};
entities.Orders.Add(currentOrder);
entities.SaveChanges();
newOrder = CreatedAtRoute("GetOrder", new
{
OrderID = currentOrder.OrderID
}, currentOrder);
this.addOrderDetails(listOfOrderItemIDs, currentOrder.OrderID);
}
return(newOrder);
}
public List <int> addOrderItems(OrderReadModel OrderItem)
{
IHttpActionResult newOrderItem;
List <int> listOfOrderItemIDs = new List <int>();
using (OrderSystemEntitiesCtx entities = new OrderSystemEntitiesCtx())
{
//for each item
foreach (var item in OrderItem.Items)
{
foreach (var extra in item.ExtraItems)
{
OrderItem currentOrderItem = new OrderItem()
{
ItemID = item.ItemID,
ExtraID = extra.ExtraID
};
OrderItem createdOrderItem = entities.OrderItems.Add(currentOrderItem);
entities.SaveChanges();
newOrderItem = CreatedAtRoute("GetOrderItem", new
{
OrderItemID = currentOrderItem.OrderItemID
}, currentOrderItem);
listOfOrderItemIDs.Add(createdOrderItem.OrderItemID);
}
}
}
return(listOfOrderItemIDs);
}
public OrderItem GetOrderItemByOrderID(int OrderItemID)
{
using (OrderSystemEntitiesCtx entities = new OrderSystemEntitiesCtx())
{
return(entities.OrderItems.FirstOrDefault(o => o.OrderItemID == OrderItemID));
}
}
public Order GetOrderByCustomerID(int CustomerID)
{
using (OrderSystemEntitiesCtx entities = new OrderSystemEntitiesCtx())
{
return(entities.Orders.FirstOrDefault(o => o.CustomerID == CustomerID));
}
}
public IEnumerable <Order> GetAllOrders()//give it a read model
{
using (OrderSystemEntitiesCtx entities = new OrderSystemEntitiesCtx())
{
return(entities.Orders.ToList());
}
}
public Customer GetCustomer(int CustomerID)
{
using (OrderSystemEntitiesCtx entities = new OrderSystemEntitiesCtx())
{
return(entities.Customers.FirstOrDefault(c => c.CustomerID == CustomerID));
}
}
public IEnumerable <Customer> GetAllCustomers()
{
using (OrderSystemEntitiesCtx entities = new OrderSystemEntitiesCtx())
{
return(entities.Customers.ToList());
}
}
public IEnumerable <Extra> GetExtrasByID(int ItemID)
{
using (var entities = new OrderSystemEntitiesCtx())
{
var listOfItemIDs = entities.ItemExtras.Where(ie => ie.ItemId == ItemID).Select(x => x.ExtraId).ToList();
return(entities.Extras.Where(e => listOfItemIDs.Contains(e.ExtraID)).ToList());
}
}
public void addOrderDetails(List <int> OrderItemIDs, int OrderID)
{
using (OrderSystemEntitiesCtx entities = new OrderSystemEntitiesCtx())
{
foreach (var item in OrderItemIDs)
{
OrderDetail currentOrderDetail = new OrderDetail()
{
OrderID = OrderID,
OrderItemID = item
};
OrderDetail createdOrderDetail = entities.OrderDetails.Add(currentOrderDetail);
}
entities.SaveChanges();
}
}
public IHttpActionResult AddCustomer(Customer Customer)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
using (OrderSystemEntitiesCtx entities = new OrderSystemEntitiesCtx())
{
entities.Customers.Add(Customer);
entities.SaveChanges();
return(CreatedAtRoute("GetCustomer", new
{
CustomerID = Customer.CustomerID
}, Customer));
}
}
public List <ItemHistoryReadModel> GetOrderItemHistory()
{
List <ItemHistoryReadModel> itemHistory = new List <ItemHistoryReadModel>();
List <Order> allOrders = new List <Order>();
using (OrderSystemEntitiesCtx entities = new OrderSystemEntitiesCtx())
{
try
{
allOrders = entities.Orders.ToList();
foreach (var order in allOrders)
{
ItemHistoryReadModel currentReadModel = new ItemHistoryReadModel();
List <Item> allItems = new List <Item>();
List <int> allOrderItemIDs = new List <int>();
List <int> allItemIDs = new List <int>();
allOrderItemIDs = entities.OrderDetails.Where(od => od.OrderID == order.OrderID).Select(x => x.OrderItemID).ToList();
foreach (var id in allOrderItemIDs)
{
Debug.WriteLine("itemid " + id);
OrderItem currentOrderItem = entities.OrderItems.FirstOrDefault(i => i.OrderItemID == id);
allItemIDs.Add(currentOrderItem.ItemID);
}
foreach (var id in allItemIDs)
{
Item currentItem = entities.Items.FirstOrDefault(i => i.ItemID == id);
allItems.Add(currentItem);
currentReadModel.ItemID = currentItem.ItemID;
currentReadModel.Name = currentItem.Name;
currentReadModel.Price = currentItem.Price;
currentReadModel.Extras = true;
currentReadModel.Date = order.Date;
currentReadModel.MonthYear = order.MonthYear;
itemHistory.Add(currentReadModel);
}
}
}
catch (Exception exc)
{
Console.WriteLine(exc.GetType());
Debug.WriteLine(exc.GetType());
}
}
return(itemHistory);
}
public List <OrderHistoryReadModel> GetOrderHistory()
{
List <OrderHistoryReadModel> orderHistory = new List <OrderHistoryReadModel>();
List <Order> allOrders = new List <Order>();
using (OrderSystemEntitiesCtx entities = new OrderSystemEntitiesCtx())
{
allOrders = entities.Orders.ToList();
foreach (var order in allOrders)
{
OrderHistoryReadModel currentReadModel = new OrderHistoryReadModel();
List <Item> allItems = new List <Item>();
List <int> allOrderItemIDs = new List <int>();
List <int> allItemIDs = new List <int>();
allOrderItemIDs = entities.OrderDetails.Where(od => od.OrderID == order.OrderID).Select(x => x.OrderItemID).ToList();
foreach (var id in allOrderItemIDs)
{
Debug.WriteLine("itemid " + id);
//allItemIDs = entities.OrderItems.Where(od => od.OrderItemID == id).Select(x => x.ItemID).ToList();
OrderItem currentOrderItem = entities.OrderItems.FirstOrDefault(i => i.OrderItemID == id);
allItemIDs.Add(currentOrderItem.ItemID);
}
foreach (var id in allItemIDs)
{
// allItemIDs = entities.OrderItems.Where(od => od.OrderItemID == id).Select(x => x.ItemID).ToList();
Item currentItem = entities.Items.FirstOrDefault(i => i.ItemID == id);
allItems.Add(currentItem);
}
currentReadModel.OrderID = order.OrderID;
currentReadModel.CustomerID = order.CustomerID;
currentReadModel.Completed = order.Completed;
currentReadModel.Cancelled = order.Cancelled;
currentReadModel.TotalPrice = order.TotalPrice;
currentReadModel.Date = order.Date;
currentReadModel.MonthYear = order.MonthYear;
currentReadModel.Items = allItems;
orderHistory.Add(currentReadModel);
}
}
return(orderHistory);
}
