public async Task <ActionResult> ftGetPukalAcctBatchList(jQueryDataTableParamModel Params, string refCd, string AcctOfficeCd, int cycStmtId)
{
var _filtered = new List <PukalAcctBatchList>();
var list = (await PukalAcctOpService.GetPukalAccounts(refCd, AcctOfficeCd, cycStmtId)).pukalPayments;
if (!string.IsNullOrEmpty(Params.sSearch))
{
_filtered = list.Where(p => p.BatchId.ToString().Contains(Params.sSearch) ||
p.RefCd.ToString().Contains(Params.sSearch) ||
p.ChequeNo.ToString().Contains(Params.sSearch) ||
p.AreaCode.ToString().Contains(Params.sSearch) ||
p.ChequeAmt.ToString().Contains(Params.sSearch) ||
p.Owner.ToString().Contains(Params.sSearch) ||
p.SlipNo.ToString().Contains(Params.sSearch) ||
p.IssBank.ToString().Contains(Params.sSearch)
).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(x => new object[] { x.BatchId, x.RefCd, x.AreaCode, x.ChequeNo, x.ChequeAmt, x.SlipNo, x.IssBank, x.CreationDate, x.StatementDate, x.StsDescp, x.Owner })
}, JsonRequestBehavior.AllowGet));
}
public async Task <ActionResult> ftGetPukalSedutView(jQueryDataTableParamModel Params, string refCd, string acctOfficeCd, string Sts)
{
var _filtered = new List <WebPukalSedutList>();
var list = (await PukalAcctOpService.GetPukalSeduts(refCd, acctOfficeCd, Sts)).pukalSeduts;
if (!string.IsNullOrEmpty(Params.sSearch))
{
_filtered = list.Where(p => p.AcctNo.ToString().ToLower().Contains(Params.sSearch.ToLower()) ||
p.ActivationDate.ToString().ToLower().Contains(Params.sSearch.ToLower()) ||
p.CompanyName.ToString().ToLower().Contains(Params.sSearch.ToLower()) ||
p.PukalAmt.ToString().ToLower().Contains(Params.sSearch.ToLower()) ||
p.Status.ToString().ToLower().Contains(Params.sSearch.ToLower()) ||
p.UserId.ToString().ToLower().Contains(Params.sSearch.ToLower()) ||
p.StmtDate.ToString().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(x => new object[] { x.AcctNo, x.CompanyName, x.ActivationDate, x.TerminationDate, x.PukalAmt, x.StmtDate, x.Status, x.UserId })
}, JsonRequestBehavior.AllowGet));
}
public async Task <JsonResult> GetWebTxnPukalPaymentSelect(long batchId, string refCd, string AcctOfficeCd, int cycStmtId)
{
var _SaveMultiAdj = (await PukalAcctOpService.GetPukalAcctBatches(batchId, refCd, AcctOfficeCd, cycStmtId)).pukalAcctBatches;
return(Json(new { list = _SaveMultiAdj }, JsonRequestBehavior.AllowGet));
}
