public static List<DTO.OrderDTO> GetOrders() { PapaBobDbEntities db = new PapaBobDbEntities(); var dbOrders = db.Orders.Where(p => p.Completed == false); var dtoOrders = new List<DTO.OrderDTO>(); foreach (var dbOrder in dbOrders) { var dtoOrder = new DTO.OrderDTO(); dtoOrder.OrderId = dbOrder.OrderId; dtoOrder.Size = dbOrder.Size; dtoOrder.Crust = dbOrder.Crust; dtoOrder.Sausage = dbOrder.Sausage; dtoOrder.Onions = dbOrder.Onions; dtoOrder.Pepperoni = dbOrder.Pepperoni; dtoOrder.GreenPeppers = dbOrder.GreenPeppers; dtoOrder.Name = dbOrder.Name; dtoOrder.Address = dbOrder.Address; dtoOrder.Zip = dbOrder.Zip; dtoOrder.Phone = dbOrder.Phone; dtoOrder.Payment = dbOrder.Payment; dtoOrder.Completed = dbOrder.Completed; dtoOrder.TotalCost = dbOrder.TotalCost; dtoOrders.Add(dtoOrder); } return dtoOrders; }
public static DTO.PricesDTO getPrices() { PapaBobDbEntities db = new PapaBobDbEntities(); var prices = db.PizzaPrices.First(); var dtoPrices = converDTOPrices(prices); return dtoPrices; }
public static void CompleteOrder(Guid orderId) { PapaBobDbEntities db = new PapaBobDbEntities(); var dbOrder = db.Orders.Where(p => p.OrderId == orderId).FirstOrDefault(); dbOrder.Completed = true; db.SaveChanges(); }
public static void AddOrder(DTO.OrderDTO newOrder) { PapaBobDbEntities db = new PapaBobDbEntities(); var dbOrders = db.Orders; var dtoOrder = convertToOrder(newOrder); dbOrders.Add(dtoOrder); db.SaveChanges(); }