public ActionResult Index() { if (User.Identity.Name != "*****@*****.**") { return(RedirectToAction("Index", "Home")); } PendingViewModel pvm = new PendingViewModel(); CategoryRepository rep = new CategoryRepository(Properties.Settings.Default.ConStr); pvm.Categories = rep.GetCategories(); return(View(pvm)); }
// // GET: /Hazmat/Pending public ActionResult Pending() { PendingViewModel pendingViewModel = new PendingViewModel(); // Check for shipments created manually pending shipping List <PendingItems> pendingItems = hazmatRepository.GetHazmatPendingShipping().ToList(); List <HazmatInfo> pending = hazmatRepository.GetHazmatInfoPendingShipping().ToList(); pendingViewModel.PendingItems = pendingItems; List <HazmatLocation> receivers = (from item in pending.GroupBy(r => r.ToBU).Select(grp => grp.First()) let receiver = new HazmatLocation() select hazmatRepository.GetLocationById(item.ToBU)).ToList(); pendingViewModel.Receivers = receivers; //To get a distinct result, group by first found items List <HazmatLocation> shippers = (from item in pending.GroupBy(s => s.FromBU).Select(grp => grp.First()) let shipper = new HazmatLocation() select hazmatRepository.GetLocationById(item.FromBU)).ToList(); pendingViewModel.Shippers = shippers; ViewBag.Shippers = shippers; ViewBag.Receivers = receivers; ViewBag.PendingCount = pending.Count(); return(View("Pending", pendingViewModel)); }
public ActionResult Pending() { ViewBag.isSearchAboutEmployee = false; ViewBag.LoggedUser = LoggedUser; var requestsModel = DB.GATE_MaterialRequest .WithTreeSecurity(LoggedUser.EmployeeId, false) .Where( req => req.OrderStatusId != OrderStatus.Cancelled && req.OrderStatusId != OrderStatus.Complete) .OrderBy(req => req.ConcernedEmployee.EntryDate) .AsEnumerable() .Select(p => new RequestViewModel(p)) //.Select(RequestViewModel.ContructorForEF); //.Select(p => new RequestViewModel.ContructorForEF); .OrderBy(req => req.TodoPriority) .ThenBy(req => req.ConcernedEmployee.EntryDate); SearchViewModel searchModel = new SearchViewModel(DB.EmployeeStatus, DB.EmployeeTypes, DB.GATE_OrderStatus); TableViewModel tableModel = new TableViewModel(DB.Packages, requestsModel); //To use 76 for Page, set PageNum = 1 in line 60 PendingViewModel pendingModel = new PendingViewModel(searchModel, tableModel); //Reset session variable Session["SelectedEmployeeId"] = null; return View(pendingModel); }