/// <summary> /// Gets all orders stored in the database. /// </summary> /// <returns>List of ExpandedOrderVMs.</returns> public List <ExpandedOrderVM> AllOrders() { try { TimeZoneInfo tZone = TimeZoneInfo.FindSystemTimeZoneById("Romance Standard Time"); using (var db = new VideoDB()) { List <ExpandedOrderVM> allOrders = new List <ExpandedOrderVM>(); foreach (var order in db.Orders) { if (order.Active) { var tempOrder = new ExpandedOrderVM() { FirstName = order.User.FirstName, SurName = order.User.SurName, Email = order.User.Email, Order = new OrderVM() { OrderNr = order.OrderNr, Date = TimeZoneInfo.ConvertTimeFromUtc(order.Date, tZone) .ToString("dd.MM.yyyy HH:mm:ss") } }; List <OrdreLinjeVM> list = new List <OrdreLinjeVM>(); foreach (var line in order.OrderLines) { if (line.Active) { var orderLineVM = new OrdreLinjeVM { Title = line.Film.Title, Price = line.Price }; list.Add(orderLineVM); } } tempOrder.Order.OrderLines = list; int totalPrice = 0; foreach (var item in order.OrderLines) { totalPrice += item.Price; } tempOrder.Order.TotalPrice = totalPrice; allOrders.Add(tempOrder); } } return(allOrders); } } catch (Exception e) { new ErrorLogRepository().CreateError("Oblig1.DAL.OrderRepository.AllOrders()", null, e); //Returns empty list return(new List <ExpandedOrderVM>()); } }
public List <ExpandedOrderVM> AllOrders() { var expectedList = new List <ExpandedOrderVM>(); var expandedOrder = new ExpandedOrderVM() { FirstName = "Ola", SurName = "Nordmann", Email = "*****@*****.**", }; var expandedOrder2 = new ExpandedOrderVM() { FirstName = "Tore", SurName = "Sagen", Email = "*****@*****.**", }; OrderVM order = new OrderVM() { OrderNr = 0, Date = new DateTime(DateTime.Today.Year, DateTime.Today.Month, DateTime.Today.Day, 10, 40, 00).ToString() }; OrderVM order2 = new OrderVM() { OrderNr = 1, Date = new DateTime(DateTime.Today.Year, DateTime.Today.Month, DateTime.Today.Day, 10, 20, 00).ToString() }; OrdreLinjeVM orderline = new OrdreLinjeVM() { Price = 49, Title = "Mad Max" }; OrdreLinjeVM orderline2 = new OrdreLinjeVM() { Price = 99, Title = "Tomb Raider" }; OrdreLinjeVM orderline3 = new OrdreLinjeVM() { Price = 129, Title = "Kontiki" }; List <OrdreLinjeVM> orderlines = new List <OrdreLinjeVM>(); List <OrdreLinjeVM> orderlines2 = new List <OrdreLinjeVM>(); orderlines.Add(orderline); orderlines.Add(orderline3); orderlines2.Add(orderline); orderlines2.Add(orderline2); orderlines2.Add(orderline3); expandedOrder.Order = order; expandedOrder.Order.OrderLines = orderlines; expandedOrder.Order.TotalPrice = 49 + 129; expandedOrder2.Order = order2; expandedOrder2.Order.OrderLines = orderlines2; expandedOrder2.Order.TotalPrice = 49 + 99 + 129; expectedList.Add(expandedOrder); expectedList.Add(expandedOrder2); return(expectedList); }