public ActionResult IndexData(DeletedDafIndexModel model)
{
TryUpdateModel(model, "Filter");
var filter = model;
var source = QueryDetails();
var filtered = from a in source
where filter.SerId == null || filter.SerId == a.AgencyGroupId
where filter.AgencyId == null || filter.AgencyId == a.AgencyId
where filter.ClientId == null || a.ClientId == filter.ClientId
where filter.FirstName == null || a.ClientFirstName.Trim() == filter.FirstName.Trim()
where filter.LastName == null || a.ClientLastName.Trim() == filter.LastName.Trim()
where filter.Status == null || a.StatusId == (int?)filter.Status
where filter.DeletedFrom == null || a.DeletedAt >= filter.DeletedFrom
where filter.DeletedTo == null || a.DeletedAt < filter.DeletedTo
where filter.Search == null ||
(a.ClientName).Contains(filter.Search) ||
(a.EvaluatorName).Contains(filter.Search)
select new DeletedDafListRowModel
{
DeletedAt = a.DeletedAt,
DafId = a.Id,
ClientId = a.ClientId,
ClientName = a.ClientName,
StatusName = a.StatusName,
CreatedAt = a.CreatedAt,
UpdatedAt = a.UpdatedAt,
Updated = a.UpdatedAt,
EvaluatorName = a.EvaluatorName
};
var result = new CC.Web.Models.jQueryDataTableResult()
{
aaData = filtered.OrderByField(model.sSortCol_0, model.sSortDir_0 == "asc").Skip(model.iDisplayStart).Take(model.iDisplayLength),
sEcho = model.sEcho,
iTotalRecords = source.Count(),
iTotalDisplayRecords = filtered.Count()
};
return(this.MyJsonResult(result));
}
// GET: DeletedDaf
public ActionResult Index()
{
var model = new DeletedDafIndexModel();
return(View(model));
}
