public ActionResult Index()
{
var vwModel = new LogReadViewModel();
SetViewData();
SetDefaults(vwModel);
return(View(vwModel));
}
private void QueryDatabase(int?page, LogReadViewModel vwModel)
{
if (vwModel.Description == null && vwModel.TimeFrom == DateTime.MinValue && vwModel.TimeTo == DateTime.MinValue)
{
return;
}
ViewBag.OnePageOfLogs = new List <LogReadViewModel>().ToPagedList(1, 1);
var dbModel = new List <EventLogModel>();
if (Session["dbModel"] == null)
{
dbModel = new EventLogRepository(connection).SelectListBetween(vwModel.TimeFrom, vwModel.TimeTo);
Session["dbModel"] = dbModel;
}
else
{
dbModel = (List <EventLogModel>)Session["dbModel"];
vwModel.TimeFrom = new DateTime(vwModel.TimeFrom.Year, vwModel.TimeFrom.Month, vwModel.TimeFrom.Day);
}
//Filter TaskCategory
if (vwModel.TaskCategory > 0)
{
dbModel = dbModel.Where(x => x.TaskCategory == vwModel.TaskCategory).ToList();
}
//Filter Description
if (vwModel.Description != null)
{
dbModel = dbModel.Where(x => x.Description.Contains(vwModel.Description)).ToList();
}
Mapper.Initialize(cfg => cfg.CreateMap <EventLogModel, LogReadViewModel>());
var vwModel2 = Mapper.Map <List <LogReadViewModel> >(dbModel);
var pageNumber = page ?? 1;
var onePageOfLogs = vwModel2.ToPagedList(pageNumber, 25);
ViewBag.OnePageOfLogs = onePageOfLogs;
}
private void SetDefaults(LogReadViewModel vwModel)
{
vwModel.TimeFrom = DateTime.Now;
vwModel.TimeTo = DateTime.Now;
ViewBag.OnePageOfLogs = new List <LogReadViewModel>().ToPagedList(1, 1);
}
public ActionResult Post(LogReadViewModel vwModel, int?page)
{
QueryDatabase(page, vwModel);
SetViewData();
return(View("Index", vwModel));
}
