/// <summary>
/// Get Data to Create Statement
/// </summary>
/// <param name="pageNo">Page No</param>
/// <param name="dates">Statement Date</param>
/// <param name="trxDatess">Transaction Date of Payment</param>
/// <param name="trxDatesUnions">Transaction Date for Cash Journa;</param>
/// <param name="cBPartnerIDs">Business Partner</param>
/// <param name="DocumentNos">Document No of Payment</param>
/// <param name="DocumentNoUnions">Document No of Cash Journal</param>
/// <param name="DepositSlips">Deposit Slip No</param>
/// <param name="AuthCodes">Authrization Code</param>
/// <param name="cBankAccountId">Check No</param>
/// <param name="cBankAccountId">Amount</param>
/// <param name="cBankAccountId">Bank Account</param>
/// <returns>Data in JSON Format</returns>
public JsonResult GetBankAccountsData(int pageNo, string dates, string trxDatess, string trxDatesUnions, string cBPartnerIDs, string DocumentNos, string DocumentNoUnions, string DepositSlips,
string AuthCodes, string CheckNos, string Amounts, int cBankAccountId)
{
var ctx = Session["ctx"] as Ctx;
CommonModel obj = new CommonModel();
string sql = GetBankAccountsDataSql(dates, trxDatess, trxDatesUnions, cBPartnerIDs, DocumentNos, DocumentNoUnions, DepositSlips, AuthCodes, CheckNos, Amounts, cBankAccountId);
var stValue = obj.GetAccountData(sql, pageNo, ctx);
return(Json(JsonConvert.SerializeObject(stValue), JsonRequestBehavior.AllowGet));
}
