public async Task <ActionResult> ftCardHolderList(jQueryDataTableParamModel Params, string _AcctNo, bool isExport = false) { //byte[] Bytes; var _filtered = new List <CardHolderInfoModel>(); var list = (await CardHolderService.GetCardHolders(_AcctNo)).cardHolderInfos; if (!string.IsNullOrEmpty(Params.sSearch)) { Params.sSearch = Params.sSearch.ToLower(); } if (!string.IsNullOrEmpty(Params.sSearch)) { _filtered = list.Where(p => (!string.IsNullOrEmpty(p.CardNo) ? p.CardNo : string.Empty).ToLower().Contains(Params.sSearch) || (!string.IsNullOrEmpty(p.EmbossName) ? p.EmbossName : string.Empty).Contains(Params.sSearch) || (!string.IsNullOrEmpty(p.SelectedCurrentStatus) ? p.SelectedCurrentStatus : string.Empty).Contains(Params.sSearch) || (!string.IsNullOrEmpty(p.CardExpiry) ? p.CardExpiry : string.Empty).Contains(Params.sSearch) || (!string.IsNullOrEmpty(p.XRefCardNo) ? p.XRefCardNo : string.Empty).Contains(Params.sSearch) || (!string.IsNullOrEmpty(p.SelectedCardType) ? p.SelectedCardType : string.Empty).Contains(Params.sSearch) || (!string.IsNullOrEmpty(p.SelectedPINInd) ? p.SelectedPINInd : string.Empty).Contains(Params.sSearch) || (!string.IsNullOrEmpty(p.vehRegNo) ? p.vehRegNo : string.Empty).Contains(Params.sSearch) || (!string.IsNullOrEmpty(p.DriverCd) ? p.DriverCd : string.Empty).Contains(Params.sSearch) || (!string.IsNullOrEmpty(p.FullName) ? p.FullName : string.Empty).Contains(Params.sSearch) || (!string.IsNullOrEmpty(p.BlockedDate) ? p.BlockedDate : string.Empty).Contains(Params.sSearch) || (!string.IsNullOrEmpty(p.TerminatedDate) ? p.TerminatedDate : string.Empty).Contains(Params.sSearch) || (!string.IsNullOrEmpty(p.SelectedCostCentre) ? p.SelectedCostCentre : string.Empty).Contains(Params.sSearch)).ToList(); _filtered = _filtered.Skip(Params.iDisplayStart).Take(Params.iDisplayLength).ToList(); } else { _filtered = list.Skip(Params.iDisplayStart).Take(Params.iDisplayLength).ToList(); } var xx = from x in _filtered select new { x.CardNo, x.EmbossName }; if (isExport) { var toExport = new List <string[]>(); var Header = list.First().ExcelHeader; foreach (var item in list) { toExport.Add(item.ExcelBody()); } var ExcelPkg = Common.CommonHelpers.CreateExcel(Header, toExport, "CardsList-" + _AcctNo); return(File(ExcelPkg.GetAsByteArray(), "application/vnd.ms-excel", string.Format("List of Cards-{0}.xlsx", _AcctNo))); } return(Json(new { sEcho = Params.sEcho, iTotalRecords = list.Count, iTotalDisplayRecords = list.Count, aaData = _filtered.Select(x => new object[] { x.CardNo, x.EmbossName, x.SelectedCurrentStatus, x.CardExpiry, x.SelectedCardType, x.SelectedPINInd, x.vehRegNo, x.DriverCd, x.FullName, x.BlockedDate, x.TerminatedDate, x.SelectedCostCentre }), }, JsonRequestBehavior.AllowGet)); }