예제 #1
0
        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);
            }
        }
예제 #2
0
        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);
        }