public static List <DTO.Order> GetOrders() { var db = new PapaBobsDbEntities(); var dbOrders = db.OrderEntities.ToList(); var dtoOrders = new List <DTO.Order>(); foreach (var dbOrder in dbOrders) { var dtoOrder = new DTO.Order(); dtoOrder.OrderId = dbOrder.OrderId; dtoOrder.Size = dbOrder.Size; dtoOrder.Crust = dbOrder.Crust; dtoOrder.Sausage = dbOrder.Sausage; dtoOrder.Pepperoni = dbOrder.Pepperoni; dtoOrder.Onions = dbOrder.Onions; dtoOrder.GreenPeppers = dbOrder.GreenPeppers; dtoOrder.TotalCost = dbOrder.TotalCost; dtoOrder.Name = dbOrder.Name; dtoOrder.Address = dbOrder.Address; dtoOrder.Zip = dbOrder.Zip; dtoOrder.Phone = dbOrder.Phone; dtoOrder.PaymentType = dbOrder.PaymentType; dtoOrder.Completed = dbOrder.Completed; dtoOrders.Add(dtoOrder); } return(dtoOrders); }
public static void CompleteOrder(Guid orderId) { var db = new PapaBobsDbEntities(); var order = db.OrderEntities.FirstOrDefault(p => p.OrderId == orderId); order.Completed = true; db.SaveChanges(); }
public static List <DTO.OrderDTO> GetOrders() { var db = new PapaBobsDbEntities(); var orders = db.Orders.Where(p => p.Completed == false).ToList(); var ordersDTO = convertToDTO(orders); return(ordersDTO); }
public static DTO.PizzaPriceDTO GetPizzaPrices() { var db = new PapaBobsDbEntities(); var prices = db.PizzaPrices.First(); var dto = convertToDTO(prices); return(dto); }
public static void CreateOrder(DTO.Order orderDTO) { var db = new PapaBobsDbEntities(); var order = converToEntity(orderDTO); db.OrderEntities.Add(order); db.SaveChanges(); }