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