public ActionResult LatestUserQuestionLogs()
{
var dbContext = new NaturalDateTimeContext();
var latestUserQuestionLogs = dbContext.QuestionLogCache.LatestUserQuestionLogs.OrderByDescending(x => x.UtcTime);
var questionLogResultSet = new QuestionLogResultSet(NaturalDateTimeContext.MaxCacheEntries, latestUserQuestionLogs);
return Json(questionLogResultSet, JsonRequestBehavior.AllowGet);
}
public ActionResult QuestionLogEntries(int page, int pageSize, bool showBotRequests)
{
var dbContext = new NaturalDateTimeContext();
IQueryable<QuestionLog> questionsLogQuery = dbContext.QuestionLog;
if(!showBotRequests)
questionsLogQuery = questionsLogQuery.Where(x => !x.IsBot).AsQueryable();
var total = questionsLogQuery.Count();
var questionLogs = questionsLogQuery.OrderByDescending(x => x.Id).Skip((page - 1) * pageSize).Take(pageSize).ToList();
var questionLogResultSet = new QuestionLogResultSet(total, questionLogs);
return Json(questionLogResultSet, JsonRequestBehavior.AllowGet);
}
