public ActionResult Index(PurchaseOrderListDTO purchaseOrderListDTO)
 {
     if (Session["existinguser"] != null)
     {
         LoginDTO currentUser = (LoginDTO)Session["existinguser"];
         if (currentUser.RoleId != (int)Enums.Roles.StoreClerk && currentUser.RoleId != (int)Enums.Roles.StoreSupervisor && currentUser.RoleId != (int)Enums.Roles.StoreManager)
         {
             return(RedirectToAction("RedirectToClerkOrDepartmentView", "Login"));
         }
         if (purchaseOrderListDTO.FromDate != null && purchaseOrderListDTO.ToDate != null)
         {
             purchaseOrderListDTO.PurchaseOrders = PurchaseOrderService.Instance.getAllPurchaseOrders()
                                                   .Where(x => x.OrderDateTime.Date >= purchaseOrderListDTO.FromDate.Date &&
                                                          x.OrderDateTime.Date <= purchaseOrderListDTO.ToDate.Date)
                                                   .OrderByDescending(x => x.OrderDateTime);
         }
         else
         {
             purchaseOrderListDTO.PurchaseOrders = PurchaseOrderService.Instance.getAllPurchaseOrders()
                                                   .OrderByDescending(x => x.OrderDateTime);
         }
         return(View(purchaseOrderListDTO));
     }
     return(RedirectToAction("Index", "Login"));
 }
        public async Task <List <PurchaseOrderListDTO> > ListPurchaseOrders(Guid supplierId)
        {
            var supplierIdParam = GetParameter(Resources.SupplierIdParameterName, supplierId);
            var poReader        = GetDataReader(Resources.GetPurchaseOrdersBySupplierProc, new List <DbParameter> {
                supplierIdParam
            });

            if (!poReader.HasRows)
            {
                throw new Exception(string.Format(Resources.NoPurchaseOrdersForSupplierErrorMessage, supplierId));
            }

            var purchaseOrders = new List <PurchaseOrderListDTO>();

            while (await poReader.ReadAsync())
            {
                var purchaseOrderLI = new PurchaseOrderListDTO
                {
                    Id          = poReader.GetGuid(0),
                    Number      = poReader.GetString(1),
                    CreatedDate = poReader.GetDateTime(2)
                };

                purchaseOrders.Add(purchaseOrderLI);
            }

            await poReader.CloseAsync();

            return(purchaseOrders);
        }
 public ActionResult Index()
 {
     if (Session["existinguser"] != null)
     {
         LoginDTO currentUser = (LoginDTO)Session["existinguser"];
         if (currentUser.RoleId != (int)Enums.Roles.StoreClerk && currentUser.RoleId != (int)Enums.Roles.StoreSupervisor && currentUser.RoleId != (int)Enums.Roles.StoreManager)
         {
             return(RedirectToAction("RedirectToClerkOrDepartmentView", "Login"));
         }
         PurchaseOrderListDTO purchaseOrders = new PurchaseOrderListDTO();
         purchaseOrders.PurchaseOrders = PurchaseOrderService.Instance.getAllPurchaseOrders();
         return(View(purchaseOrders));
     }
     return(RedirectToAction("Index", "Login"));
 }