/// <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);
}
