// 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);
}
