public jQueryDataTableResult <object> GetPreviewData(Guid id, jQueryDataTableParamModel jq) { var result = new jQueryDataTableResult <object>(); using (var _db = getDbContext()) { var source = PreviewQuery(id, _db); var filtered = source; foreach (var s in (jq.sSearch ?? "").Split(new char[] { ' ' }).Where(f => !string.IsNullOrEmpty(f))) { filtered = filtered.Where(this.GetSearchFilter(s)); } var sorted = filtered.OrderByField(this.columns.ToArray()[jq.iSortCol_0].sName, jq.sSortDir_0 == "asc"); var aaData = sorted.Skip(jq.iDisplayStart).Take(jq.iDisplayLength) .ToList().Select(f => this.ToArray(f)); result.iTotalDisplayRecords = filtered.Count(); result.iTotalRecords = source.Count(); result.aaData = aaData; return(result); } }
public ActionResult Audit(int id, HistoryDataTablesModel param) { var source = DafRepository.QueryHistory(id); var filtered = source; if (!string.IsNullOrEmpty(param.FieldName)) { filtered = filtered.Where(f => f.FieldName.Contains(param.FieldName)); } if (param.fromDate.HasValue) { filtered = filtered.Where(f => f.UpdateDate >= param.fromDate); } if (param.toDate.HasValue) { filtered = filtered.Where(f => f.UpdateDate < param.toDate); } var ordered = filtered.OrderByField(param.sSortCol_0, param.sSortDir_0 == "asc"); var result = new jQueryDataTableResult { aaData = ordered.Skip(param.iDisplayStart).Take(param.iDisplayLength), iTotalDisplayRecords = filtered.Count(), iTotalRecords = source.Count(), sEcho = param.sEcho }; return(this.MyJsonResult(result)); }
public JsonResult PreviewData(Guid id, CC.Web.Models.jQueryDataTableParamModel jq) { CheckImportIdPermissions(id); using (var db = new ccEntities()) { var HomeCareEntitledPeriods = db.HomeCareEntitledPeriods; var ImportHceps = db.ImportHceps; var q = PreviewDataQuery(id, db, HomeCareEntitledPeriods, ImportHceps); var filtered = q; var sorted = filtered.OrderByDescending(f => f.Errors.Count()); if (jq.iSortCol_0 != 1) { sorted = filtered.OrderByField(Request["mDataProp_" + jq.iSortCol_0], jq.sSortDir_0 == "asc"); } if (Request["iSortCol_1"] != null && jq.iSortCol_0 != 1) { sorted = sorted.ThenByField(Request["mDataProp_" + Request["iSortCol_1"]], Request["sSortDir_1"] == "asc"); } if (Request["iSortCol_2"] != null && jq.iSortCol_0 != 1) { sorted = sorted.ThenByField(Request["mDataProp_" + Request["iSortCol_2"]], Request["sSortDir_2"] == "asc"); } var result = new jQueryDataTableResult() { sEcho = jq.sEcho, iTotalDisplayRecords = filtered.Count(), iTotalRecords = q.Count(), aaData = sorted.Skip(jq.iDisplayStart).Take(jq.iDisplayLength).ToList() }; return(this.MyJsonResult(result, JsonRequestBehavior.AllowGet)); } }
public JsonResult IndexData(jQueryDataTableParamModel model) { var source = db.Files.Where(f => f.IsLandingPage); var sSortCol_0 = Request["mDataProp_" + model.iSortCol_0]; var bSortAsc_0 = model.sSortDir_0 == "asc"; var sorted = source.OrderByField(sSortCol_0, bSortAsc_0).Skip(model.iDisplayStart).Take(model.iDisplayLength); var result = new jQueryDataTableResult { sEcho = model.sEcho, aaData = sorted.ToList(), iTotalRecords = sorted.Count(), iTotalDisplayRecords = sorted.Count() }; return(this.MyJsonResult(result)); }
public JsonResult Data(jQueryDataTableParamModel model) { var ShowFundStatusColumn = Permissions.CanSeeProgramField; var q = from c in db.Clients.Where(Permissions.ClientsFilter) from a in c.ClientHcStatuses where a.ClientId == model.ClientId select new { a.Id, a.StartDate, HcStatusName = a.HcStatus.Name, ApprovalStatusName = a.ApprovalStatus.Name, FundStatusName = a.FundStatus.Name }; var result = new jQueryDataTableResult { sEcho = model.sEcho, }; if (ShowFundStatusColumn) { result.aaData = q.ToList(); } else { result.aaData = q.Select(f => new { f.Id, f.StartDate, f.HcStatusName, f.ApprovalStatusName, FundStatusName = (string)null }).ToList(); } result.iTotalRecords = result.iTotalDisplayRecords = q.Count(); return(this.MyJsonResult(result)); }
public ActionResult Audit(int id, HistoryDataTablesModel param) { var source = from h in db.Histories where h.ReferenceId == id where h.TableName == "DAF" select new CC.Data.Models.HistoryRowModel { UpdateDate = h.UpdateDate, UpdatedBy = (h.User.FirstName + " " + h.User.LastName) ?? (h.User.UserName), FieldName = h.FieldName, OldValue = h.OldValue, NewValue = h.NewValue }; var filtered = source; if (!string.IsNullOrEmpty(param.FieldName)) { filtered = filtered.Where(f => f.FieldName.Contains(param.FieldName)); } if (param.fromDate.HasValue) { filtered = filtered.Where(f => f.UpdateDate >= param.fromDate); } if (param.toDate.HasValue) { filtered = filtered.Where(f => f.UpdateDate < param.toDate); } var ordered = filtered.OrderByField(param.sSortCol_0, param.sSortDir_0 == "asc"); var result = new jQueryDataTableResult { aaData = ordered.Skip(param.iDisplayStart).Take(param.iDisplayLength), iTotalDisplayRecords = filtered.Count(), iTotalRecords = source.Count(), sEcho = param.sEcho }; return(this.MyJsonResult(result)); }