// GET public IActionResult Index(string dateMin, string dateMax, DeviceEnum deviceName, string productionLine, StationCategoryEnum stationCategory, RFIDStationNameEnum rfidStation) { SiteDetailsViewModel model = new SiteDetailsViewModel { DateMin = dateMin, DateMax = dateMax, DeviceName = deviceName, ProductionLine = productionLine, StationCategory = stationCategory, RfidStationName = rfidStation }; return(View(model)); }
public ActionResult Details(string id) { _dataContext.Categories.ToList(); var hostSite = _dataContext.HostSites .Include(m => m.Articles) .Where(m => m.UrlFriendlyName == id) .Where(m => m.IsActive) .Single(); hostSite.Articles = hostSite.Articles.Where(a => a.IsPublished).ToList(); // TODO: Move the following filter execution from C# to the database var selectedTagValues = _dataContext.HostSiteToHostSiteTagValues .Where(m => m.HostSiteId == hostSite.Id) .Select(m => m.HostSiteTagValue) .OrderBy(m => m.SortOrder) .ThenBy(m => m.Name) .ToList(); var distinctHostSiteTags = selectedTagValues.Select(m => m.HostSiteTagId).Distinct(); var hostSiteTags = _dataContext.HostSiteTags .Include(m => m.HostSiteTagValues) .ToList() .Where(m => distinctHostSiteTags.Any(d => d == m.Id)) .OrderBy(m => m.SortOrder) .ThenBy(m => m.Name); var model = new SiteDetailsViewModel { HostSite = hostSite, HostSiteTags = hostSiteTags, HostSiteTagValues = selectedTagValues }; return View(model); }