public ActionResult Index(string sortOrder, string active, string currentSearch = null) { ViewBag.Requests = sortOrder == "requests_desc" ? "requests_asc" : "requests_desc"; ViewBag.ReviewsNeeded = sortOrder == "revs_needed" ? "revs_needed_desc" : "revs_needed"; ViewBag.Vendor = sortOrder == "Vendor" ? "vendor_desc" : "Vendor"; ViewBag.Codes = sortOrder == "codes" ? "codes_desc" : "codes"; ViewBag.SearchBox = currentSearch; if (String.IsNullOrEmpty(sortOrder)) { sortOrder = "requests_desc"; } if (String.IsNullOrEmpty(active)) { active = "all"; } CampaignIndexViewModel IndexView = new CampaignIndexViewModel(sortOrder, currentSearch, active); var reviewsCheckedTime = (from t in db.TaskLog where t.TaskDescription.Equals("DailyLimitsReset") orderby t.SuccessDatestamp descending select t.SuccessDatestamp).First(); ViewBag.DateStamp = reviewsCheckedTime; return View(IndexView); }
public AdminDashboardViewModel() { OpenCampaigns = (from a in db.Campaigns where a.OpenCampaign.Equals(true) select a).Count(); ClosedCampaigns = (from b in db.Campaigns where b.OpenCampaign.Equals(false) select b).Count(); Customers = (from c in db.Customers select c).Count(); UnqualifiedCustomers = (from d in db.Customers where d.Qualified.Equals(false) select d).Count(); Vendors = (from e in db.Vendors select e).Count(); var _cust = (from f in db.Customers where f.Qualified.Equals(true) orderby f.Reviews.Count() descending select f).Take(5).ToList(); TopReviewers = new CustomerIndexViewModel(_cust); var _topvendors = (from g in db.Campaigns orderby g.Reviews.Count() descending select g.Vendor).Take(5).ToList(); TopVendors = new VendorIndexViewModel(_topvendors); var _topcamps = (from h in db.Campaigns where h.OpenCampaign.Equals(true) orderby h.Reviews.Count() descending select h).Take(5).ToList(); TopActiveCampaigns = new CampaignIndexViewModel(_topcamps); ActiveRequests = (from i in db.ItemRequests where i.ActiveRequest.Equals(true) select i).Count(); CodesNeeded = (from j in db.Reviews where j.Reviewed.Equals(false) where j.DiscountCode.Equals(null) select j).Count(); TotalReviewsDone = (from j in db.Reviews where j.Reviewed.Equals(true) select j).Count(); //Notifications count for today DateTime today = DateTime.Now.Date; NotificationsToday = (from n in db.NotificationLog where n.LogTimestamp > today select n).Count(); }
public SingleVendorViewModel(Vendor vendor) { Vendor = vendor; vendorsummary = new List<VendorSummaryViewModel> { }; vendorsummary.Add(new VendorSummaryViewModel(vendor)); var _camps = (from c in db.Campaigns where c.VendorID.Equals(vendor.VendorId) select c).ToList(); vendorcampaigns = new CampaignIndexViewModel(_camps); }