/// <summary>
/// Get List of Bank's
/// </summary>
/// <returns>List of Banks</returns>
public JsonResult GetBank()
{
Ctx ctx = Session["ctx"] as Ctx;
StatementOperations obj = new StatementOperations();
return(Json(JsonConvert.SerializeObject(obj.GetBank(ctx)), JsonRequestBehavior.AllowGet));
}
/// <summary>
/// Get Total conciled or Unconciled Amount
/// </summary>
/// <param name="_cmbBankAccount">C_BankAccount_ID</param>
/// <param name="_txtSearch">Search Text</param>
/// <param name="_currencyID">C_Currency_ID</param>
/// <param name="_searchRequest">Search Request</param>
/// <returns>List</returns>
public JsonResult LoadConciledOrUnConciledStatements(int _cmbBankAccount, string _txtSearch, int _currencyID, bool _searchRequest)
{
string retJSON = "";
if (Session["ctx"] != null)
{
Ctx ctx = Session["ctx"] as Ctx;
StatementOperations obj = new StatementOperations();
retJSON = JsonConvert.SerializeObject(obj.LoadConciledOrUnConciledStatements(ctx, _cmbBankAccount, _txtSearch, _currencyID, _searchRequest));
}
return(Json(retJSON, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// Get Invoice PaySchedule list
/// </summary>
/// <param name="seltdInvoice">C_Invoice_ID</param>
/// <param name="accountID">C_BankAccount_ID</param>
/// <param name="statemtDate">Statement Date</param>
/// <returns>Invoice PaySchedule list</returns>
public JsonResult GetInvPaySchedule(int seltdInvoice, int accountID, DateTime?statemtDate)
{
string retJSON = "";
if (Session["ctx"] != null)
{
Ctx ctx = Session["ctx"] as Ctx;
StatementOperations obj = new StatementOperations();
retJSON = JsonConvert.SerializeObject(obj.GetInvPaySchedule(ctx, seltdInvoice, accountID, statemtDate));
}
return(Json(retJSON, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// To get the data for "Matching Base" Based on List
/// </summary>
/// <returns>List of Matching Base ID and Name</returns>
public JsonResult getMatchRecData()
{
string retJSON = "";
if (Session["ctx"] != null)
{
Ctx ctx = Session["ctx"] as Ctx;
StatementOperations obj = new StatementOperations();
retJSON = JsonConvert.SerializeObject(obj.getMatchBaseData(ctx));
}
return(Json(retJSON, JsonRequestBehavior.AllowGet));
}
public JsonResult CheckFormPaymentCondition(int _paymentID, decimal _amount)
{
string retJSON = "";
if (Session["ctx"] != null)
{
Ctx ctx = Session["ctx"] as Ctx;
StatementOperations obj = new StatementOperations();
retJSON = JsonConvert.SerializeObject(obj.CheckFormPaymentCondition(ctx, _paymentID, _amount));
}
return(Json(retJSON, JsonRequestBehavior.AllowGet));
}
public JsonResult CheckFormPrepayCondition(int _orderID, decimal _amount, int _currencyId, int _formBPartnerID)
{
string retJSON = "";
if (Session["ctx"] != null)
{
Ctx ctx = Session["ctx"] as Ctx;
StatementOperations obj = new StatementOperations();
retJSON = JsonConvert.SerializeObject(obj.CheckFormPrepayCondition(ctx, _orderID, _amount, _currencyId, _formBPartnerID, DateTime.Now));
}
return(Json(retJSON, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// Get Payment Amounts
/// </summary>
/// <param name="_dragSourceID">C_Payment_ID</param>
/// <param name="_dragDestinationID">C_Payment_ID or Zero</param>
/// <param name="_listToCheck">true or false</param>
/// <param name="_amount">Amount</param>
/// <param name="statmtDate">Statement Date</param>
/// <param name="accountID">C_BankAccount_ID</param>
/// <returns>List</returns>
public JsonResult CheckPaymentCondition(int _dragSourceID, int _dragDestinationID, string _listToCheck, decimal _amount, DateTime?statmtDate, int accountID)
{
string retJSON = "";
if (Session["ctx"] != null)
{
Ctx ctx = Session["ctx"] as Ctx;
StatementOperations obj = new StatementOperations();
retJSON = JsonConvert.SerializeObject(obj.CheckPaymentCondition(ctx, _dragSourceID, _dragDestinationID, _amount, statmtDate, accountID));
}
return(Json(retJSON, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// Get Bank Statement Line Data
/// </summary>
/// <param name="_bankStatementLineID">C_BankStatementLine_ID</param>
/// <param name="trxType">Transaction Type</param>
/// <param name="payment_ID">Payment ID</param>
/// <param name="_statementDt">Statement Date</param>
/// <returns>List</returns>
public JsonResult GetStatementLine(int _bankStatementLineID, string trxType, int payment_ID, DateTime?_statementDt)
{
string retJSON = "";
if (Session["ctx"] != null)
{
Ctx ctx = Session["ctx"] as Ctx;
StatementOperations obj = new StatementOperations();
retJSON = JsonConvert.SerializeObject(obj.GetStatementLine(ctx, _bankStatementLineID, trxType, payment_ID, _statementDt));
}
return(Json(retJSON, JsonRequestBehavior.AllowGet));
}
public JsonResult MatchByDrag(int _dragPaymentID, int _dragStatementID)
{
string retJSON = "";
if (Session["ctx"] != null)
{
Ctx ctx = Session["ctx"] as Ctx;
StatementOperations obj = new StatementOperations();
retJSON = JsonConvert.SerializeObject(obj.MatchByDrag(ctx, _dragPaymentID, _dragStatementID, DateTime.Now));
}
return(Json(retJSON, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// Get the Amount
/// </summary>
/// <param name="_dragSourceID">C_CashLine_ID</param>
/// <param name="_dragDestinationID">C_CashLine_ID</param>
/// <param name="_amount">Amount</param>
/// <param name="_currencyId">C_Currency_ID</param>
/// <param name="_formBPartnerID">C_BPartner_ID</param>
/// <param name="stateDate">Statement Date</param>
/// <returns>List</returns>
public JsonResult CheckContraCondition(int _dragSourceID, int _dragDestinationID, decimal _amount, int _currencyId, int _formBPartnerID, DateTime?stateDate)
{
string retJSON = "";
if (Session["ctx"] != null)
{
Ctx ctx = Session["ctx"] as Ctx;
StatementOperations obj = new StatementOperations();
retJSON = JsonConvert.SerializeObject(obj.CheckContraCondition(ctx, _dragSourceID, _dragDestinationID, _amount, _currencyId, _formBPartnerID, stateDate));
}
return(Json(retJSON, JsonRequestBehavior.AllowGet));
}
public JsonResult LoadStatements(int _cmbBankAccount, int _statementPageNo, int _PAGESIZE, bool _SEARCHREQUEST, string _txtSearch)
{
string retJSON = "";
if (Session["ctx"] != null)
{
Ctx ctx = Session["ctx"] as Ctx;
StatementOperations obj = new StatementOperations();
retJSON = JsonConvert.SerializeObject(obj.LoadStatements(ctx, _cmbBankAccount, _statementPageNo, _PAGESIZE, _SEARCHREQUEST, _txtSearch));
}
return(Json(retJSON, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// To load payments against selected account
/// </summary>
/// <param name="_accountID">Bank Account ID</param>
/// <param name="_paymentPageNo">Page Number</param>
/// <param name="_PAGESIZE">Page Size</param>
/// <param name="_paymentMethodID">Payment Method ID</param>
/// <param name="_transactionType">Transaction Type</param>
/// <param name="statementDate">Statement Date</param>
/// <returns>List of Payments</returns>
public JsonResult LoadPayments(int _accountID, int _paymentPageNo, int _PAGESIZE, int _paymentMethodID, string _transactionType, DateTime?statementDate)
{
string retJSON = "";
if (Session["ctx"] != null)
{
Ctx ctx = Session["ctx"] as Ctx;
StatementOperations obj = new StatementOperations();
retJSON = JsonConvert.SerializeObject(obj.LoadPayments(ctx, _accountID, _paymentPageNo, _PAGESIZE, _paymentMethodID, _transactionType, statementDate));
}
return(Json(retJSON, JsonRequestBehavior.AllowGet));
}
public JsonResult DeleteStatement(string _statementLinesList, int _statementLineID)
{
string retJSON = "";
if (Session["ctx"] != null)
{
Ctx ctx = Session["ctx"] as Ctx;
StatementOperations obj = new StatementOperations();
retJSON = JsonConvert.SerializeObject(obj.DeleteStatement(ctx, _statementLinesList, _statementLineID));
}
return(Json(retJSON, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// Get Statement Date from Bank Statement window
/// </summary>
/// <param name="bankAcct">C_BankAccount_ID</param>
/// <returns>Statement Date</returns>
public JsonResult GetStatementDate(int bankAcct)
{
string retJSON = "";
if (Session["ctx"] != null)
{
Ctx ctx = Session["ctx"] as Ctx;
StatementOperations obj = new StatementOperations();
retJSON = JsonConvert.SerializeObject(obj.GetStatementDate(ctx, bankAcct));
}
return(Json(retJSON, JsonRequestBehavior.AllowGet));
}
public JsonResult CheckScheduleTotal(string _listToCheck, decimal _amount, int _currencyId, int _destinationID)
{
string retJSON = "";
if (Session["ctx"] != null)
{
Ctx ctx = Session["ctx"] as Ctx;
StatementOperations obj = new StatementOperations();
retJSON = JsonConvert.SerializeObject(obj.CheckScheduleTotal(ctx, _listToCheck, _amount, _currencyId, _destinationID));
}
return(Json(retJSON, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// Get Amount and Date
/// </summary>
/// <param name="recordID">Record ID</param>
/// <param name="bnkAct_Id">C_BankAccount_ID</param>
/// <param name="transcType">Tansaction Type</param>
/// <param name="stmtDate">Statement Date</param>
/// <returns>LIst</returns>
public JsonResult GetConvtAmount(string recordID, int bnkAct_Id, string transcType, DateTime?stmtDate)
{
string retJSON = "";
if (Session["ctx"] != null)
{
Ctx ctx = Session["ctx"] as Ctx;
StatementOperations obj = new StatementOperations();
retJSON = JsonConvert.SerializeObject(obj.GetConvtAmount(ctx, recordID, bnkAct_Id, transcType, stmtDate));
}
return(Json(retJSON, JsonRequestBehavior.AllowGet));
}
public JsonResult InsertData(List <StatementProp> _formData)
{
string retJSON = "";
if (Session["ctx"] != null)
{
Ctx ctx = Session["ctx"] as Ctx;
StatementOperations obj = new StatementOperations();
retJSON = JsonConvert.SerializeObject(obj.InsertData(ctx, _formData));
}
return(Json(retJSON, JsonRequestBehavior.AllowGet));
}
