public ActionResult Index(LogFilter filter)
{
// INIT
DBEntities context = COREobject.i.Context;
filter.Fill(context);
int perPage = 20;
int page = Request.Form.AllKeys.Contains("page") ? Convert.ToInt32(Request.Form["page"]) - 1 : 0;
page = page >= 0 ? page : 0;
var allItems = context.LogItems.Where(
i =>
i.ParentLogItemId == null &&
(filter.LevelId == -1 || i.LogLevel == filter.LevelId) &&
(filter.UserName == "All" || i.UserName == filter.UserName) &&
(filter.Server == "All" || i.Server == filter.Server) &&
(filter.SourceId == -1 || i.Source == filter.SourceId) &&
(filter.ApplicationName == "All" || i.Application == filter.ApplicationName) &&
(filter.BlockName == "All" || i.BlockName == filter.BlockName) &&
(filter.ActionName == "All" || i.ActionName == filter.ActionName) &&
(i.Timestamp > filter.TimeSince && i.Timestamp < filter.TimeTo) &&
(string.IsNullOrEmpty(filter.Message) || i.Message.ToLower().Contains(filter.Message.ToLower()))
).OrderByDescending(i => i.Timestamp).Take(100).Select(i =>
new {
Id = i.Id,
Timestamp = i.Timestamp,
LogLevel = i.LogLevel,
UserName = i.UserName,
Server = i.Server,
Source = i.Source,
Application = i.Application,
BlockName = i.BlockName,
ActionName = i.ActionName,
Message = i.Message
}
);
ViewData["perPage"] = perPage;
ViewData["page"] = page + 1;
ViewData["total"] = allItems.Count();
filter.ResultItems = allItems.Skip(page * perPage).Take(perPage).ToList().Select(i =>
new LogItem
{
Id = i.Id,
Timestamp = i.Timestamp,
LogLevel = i.LogLevel,
UserName = i.UserName,
Server = i.Server,
Source = i.Source,
Application = i.Application,
BlockName = i.BlockName,
ActionName = i.ActionName,
Message = i.Message
}).ToList();
return(View(filter));
}