public List <OrdersAndUserViewModel> GetOrdersByDate() { try { using (var context = new LunaContext()) { List <Order> orderList = context.Orders.Include("User").Include("OrderLine").OrderByDescending(o => o.OrderId).ToList(); List <OrdersAndUserViewModel> theList = new List <OrdersAndUserViewModel>(); foreach (var item in orderList) { OrdersAndUserViewModel m = new OrdersAndUserViewModel() { UserId = item.User.UserId, FirstName = item.User.FirstName, LastName = item.User.LastName, OrderId = item.OrderId, DateTime = item.OrderDate.ToString("dd/M/yyyy"), OrderCount = item.OrderLine.Count(), Status = item.Status }; theList.Add(m); } return(theList); } }catch (Exception e) { ErrorLog(e); return(null); } }
public void EditOrder_OK() { //Arrange var controller = setupController(); controller.Session["adminSession"] = true; List <OrdersAndUserViewModel> orders = new List <OrdersAndUserViewModel>(); OrdersAndUserViewModel order = new OrdersAndUserViewModel() { UserId = 1, FirstName = "Test", LastName = "Tester", OrderId = 2, DateTime = "28/10/2018", OrderCount = 3, Status = 0, }; orders.Add(order); orders.Add(order); orders.Add(order); //Act var resultat = (ViewResult)controller.EditOrders(); var resultatliste = (List <OrdersAndUserViewModel>)resultat.Model; //Assert Assert.AreEqual(resultat.ViewName, ""); for (var i = 0; i < resultatliste.Count; i++) { Assert.AreEqual(orders[i].UserId, resultatliste[i].UserId); Assert.AreEqual(orders[i].FirstName, resultatliste[i].FirstName); Assert.AreEqual(orders[i].LastName, resultatliste[i].LastName); Assert.AreEqual(orders[i].OrderId, resultatliste[i].OrderId); Assert.AreEqual(orders[i].DateTime, resultatliste[i].DateTime); Assert.AreEqual(orders[i].OrderCount, resultatliste[i].OrderCount); Assert.AreEqual(orders[i].Status, resultatliste[i].Status); } }
public List <OrdersAndUserViewModel> GetOrdersByDate() { List <OrdersAndUserViewModel> OrdersUsers = new List <OrdersAndUserViewModel>(); OrdersAndUserViewModel OrderUser = new OrdersAndUserViewModel { UserId = 1, FirstName = "Test", LastName = "Tester", OrderId = 2, DateTime = "28/10/2018", OrderCount = 3, Status = 0, }; OrdersUsers.Add(OrderUser); OrdersUsers.Add(OrderUser); OrdersUsers.Add(OrderUser); return(OrdersUsers); }