public async Task <ActionResult> WebMerchTxnSearch(jQueryDataTableParamModel Params, TxnSearchModel Model, bool isDownload)
{
TxnSearchMaint _Maint = new TxnSearchMaint();
var _filtered = new List <MerchPostedTxnSearch>();
var list = (await TransactionSearchService.GetMerchTransactionSearch(Model.BusnLocation, Model.MerchAcctNo, Model.SelectedMerchTxnCd, Model.MerchFromDate, Model.MerchToDate, Model.SelectedTxnCategory)).merchPostedTxnSearches;
if (!string.IsNullOrEmpty(Params.sSearch))
{
Params.sSearch = Params.sSearch.ToLower();
}
if (!isDownload)
{
_filtered = list.Skip(Params.iDisplayStart).Take(Params.iDisplayLength).ToList();
return(Json(new
{
sEcho = Params.sEcho,
iTotalRecords = list.Count(),
iTotalDisplayRecords = list.Count(),
aaData = _filtered.Select(x => new object[] { null, x.SelectedDealer, x.TermBatch, x.TxnDate, x.cardNo, x.TxnDesp, x.TxnAmt, x.TermId,
x.AuthNo, x.AuthCardNo, x.PrcsDate, x.TxnId, x.ProductDescp, x.ProductQty, x.ProductAmt, x.VATAmt, x.BaseAmt, x.VATCd, x.VATRate, })
}, JsonRequestBehavior.AllowGet));
}
else
{
var title = "Transaction search | Merchant";
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, title);
return(File(ExcelPkg.GetAsByteArray(), "application/vnd.ms-excel", title + ".xlsx"));
}
}