public async Task <ActionResult> WebProdGroupRefListSelect(jQueryDataTableParamModel Params)
{
var list = (await GlobalVariableOpService.GetProdGroupRefs()).lookupParameters;
var _filtered = new List <LookupParameters>();
if (!string.IsNullOrEmpty(Params.sSearch))
{
Params.sSearch = Params.sSearch.ToLower();
}
if (!string.IsNullOrEmpty(Params.sSearch))
{
_filtered = list.Where(p => (!string.IsNullOrEmpty(p.Descp) ? p.Descp : string.Empty).ToLower().Contains(Params.sSearch.ToLower()) ||
(!string.IsNullOrEmpty(p.SelectedProductGroup) ? p.SelectedProductGroup : string.Empty).ToLower().Contains(Params.sSearch.ToLower()) ||
(!string.IsNullOrEmpty(p.UserId) ? p.UserId : string.Empty).ToLower().Contains(Params.sSearch.ToLower()) ||
(!string.IsNullOrEmpty(p.LastUpdated) ? p.LastUpdated : string.Empty).ToLower().Contains(Params.sSearch.ToLower())).ToList();
_filtered = _filtered.Skip(Params.iDisplayStart).Take(Params.iDisplayLength).ToList();
}
else
{
_filtered = list.Skip(Params.iDisplayStart).Take(Params.iDisplayLength).ToList();
}
return(Json(new
{
sEcho = Params.sEcho,
iTotalRecords = list.Count(),
iTotalDisplayRecords = list.Count(),
aaData = _filtered.Select(p => new object[] { null, p.SelectedProductGroup, p.Descp, p.LastUpdated, p.UserId, p.ProductCode, p.ProductName, p.SelectedProductCategory, p.SelectedProductType })
}, JsonRequestBehavior.AllowGet));
}
