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