public ActionResult Dashboard(string searchBy, string search, string sortBy, int?page)
{
// ViewBag.SortReportType = string.IsNullOrEmpty(sortBy) ? "Report desc" : "";
ViewBag.SortReportType = sortBy == "ReportType" ? "Report desc" : "ReportType";
ViewBag.SortNoiseType = sortBy == "ResComm Type" ? "ResComm desc" : "ResComm Type";
ViewBag.SortDayDetail = sortBy == "DayDetail" ? "Day desc" : "DayDetail";
ViewBag.SortWeekDetail = sortBy == "WeekDetail" ? "Week desc" : "WeekDetail";
NoisePollutionModel model;
if (searchBy == "eformRef")
{
model = new NoisePollutionModel(_context.SearchByEformReference(search), page);
}
else if (searchBy == "civicaRef")
{
model = new NoisePollutionModel(_context.SearchByCivicaReference(search), page);
}
else if (searchBy == "uprn")
{
model = new NoisePollutionModel(_context.SearchByUPRN(search), page);
}
else
{
model = new NoisePollutionModel(_context.SelectAll(), page);
}
var rows = _context.SelectAll();
switch (sortBy)
{
case "Report desc":
rows = rows.OrderBy(r => r.REPORT_TYPE).ToList();
model = new NoisePollutionModel(rows, 1);
break;
case "ResComm desc":
rows = rows.OrderBy(r => r.RESIDENTIAL_COMMERCIAL).ToList();
model = new NoisePollutionModel(rows, 1);
break;
case "Day desc":
rows = rows.OrderBy(r => r.DAYTIME_EVENING).ToList();
model = new NoisePollutionModel(rows, 1);
break;
case "Week desc":
rows = rows.OrderBy(r => r.WEEKEND_WEEKDAY).ToList();
model = new NoisePollutionModel(rows, 1);
break;
}
return(View(model));
}
public ActionResult FailedRecords(int?page)
{
var model = new NoisePollutionModel(_context.SelectAllFailedRecords(), page);
return(View(model));
}
