public async Task <JsonResult> ftMultipleAdjMaint(TxnAdjustment _MultipleTxn)
{
_MultipleTxn.UserId = GetUserId;
var _SaveMultiAdj = await MultipleTxnOpService.SaveftMultipleAdjMaint(_MultipleTxn);
return(Json(new { resultCd = _SaveMultiAdj, batchId = _SaveMultiAdj.returnValue.BatchId, rcptNo = _SaveMultiAdj.returnValue.RetCd, chequeNo = _SaveMultiAdj.returnValue.ChequeNo }, JsonRequestBehavior.AllowGet));
}
/*************************************
* Created by: Tuan Tran
* Created on: Mar 5, 2017
* Function: SaveWebMultiPaymentMaint
* Purpose: SaveWebMultiPaymentMaint
* Inputs: TxnAdjustmentDTO
* Returns: SaveAcctSignUpResponse
*************************************/
public async Task <SaveAcctSignUpResponse> SaveWebMultiPaymentMaint(TxnAdjustment txnAdjustmentModel)
{
Logger.Info("Invoking SaveWebMultiPaymentMaint function");
var response = new SaveAcctSignUpResponse()
{
Status = ResponseStatus.Failure,
};
try
{
using (var scope = Container.BeginLifetimeScope())
{
var multiPaymentOpDAO = scope.Resolve <IMultiPaymentOpDAO>();
var controlDAO = scope.Resolve <IControlDAO>();
var txnAdjustment = Mapper.Map <TxnAdjustment, TxnAdjustmentDTO>(txnAdjustmentModel);
var result = await multiPaymentOpDAO.WebMultiPaymentMaint(txnAdjustment);
var message = await controlDAO.GetMessageCode(result.Flag);
response.desp = message.Descp;
response.flag = message.Flag;
response.returnValue.BatchId = result.paraOut.BatchId;
}
response.Status = ResponseStatus.Success;
}
catch (Exception ex)
{
string msg = string.Format("Error in SaveWebMultiPaymentMaint: detail:{0}", ex.Message);
Logger.Error(msg, ex);
response.Status = ResponseStatus.Exception;
response.flag = 1;
response.Message = msg;
}
return(response);
}
public async Task <JsonResult> ftMultipleAdjMaint(TxnAdjustment _MultipleTxn)
{
var txnAdjustmentObj = Mapper.Map <TxnAdjustmentDTO>(_MultipleTxn);
var _SaveMultiAdj = await MerchMultitxnAdjustmentService.SaveMerchantMultiTxnAdjustmentMaint(txnAdjustmentObj, GetUserId);
return(Json(new { resultCd = _SaveMultiAdj, batchId = _SaveMultiAdj.returnValue.BatchId, rcptNo = _SaveMultiAdj.returnValue.RetCd }, JsonRequestBehavior.AllowGet));
}
public async Task <MsgRetriever> DelTxnAdjustment(TxnAdjustment _TxnAdjustment)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
try
{
await objDataEngine.InitiateConnectionAsync();
SqlParameter[] Parameters = new SqlParameter[5];
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = String.IsNullOrEmpty(_TxnAdjustment.TxnId) ? new SqlParameter("@TxnId", DBNull.Value) : new SqlParameter("@TxnId", _TxnAdjustment.TxnId);
Parameters[2] = String.IsNullOrEmpty(_TxnAdjustment._CardnAccNo.AccNo) ? new SqlParameter("@AcctNo", DBNull.Value) : new SqlParameter("@AcctNo", _TxnAdjustment._CardnAccNo.AccNo);
Parameters[3] = String.IsNullOrEmpty(_TxnAdjustment._CardnAccNo.CardNo) ? new SqlParameter("@CardNo", DBNull.Value) : new SqlParameter("@CardNo", _TxnAdjustment._CardnAccNo.CardNo);
Parameters[4] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[4].Direction = ParameterDirection.ReturnValue;
var Cmd = await objDataEngine.ExecuteWithReturnValueAsync("WebTxnAdjustmentDelete", CommandType.StoredProcedure, Parameters);
var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
var Descp = await GetMessageCode(Result);
return(Descp);
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <JsonResult> ftMultiplePaymentMaint(TxnAdjustment _MultipleTxn)
{
_MultipleTxn.SelectedTxnCd = _MultipleTxn.SelectedTxnCode;
_MultipleTxn.UserId = GetUserId;
var _saveMultiAdj = await MultiPaymentOpService.SaveWebMultiPaymentMaint(_MultipleTxn);
var BatchId = _saveMultiAdj.returnValue.BatchId;
return(Json(new { resultCd = _saveMultiAdj, batchId = BatchId }, JsonRequestBehavior.AllowGet));
}
public async Task <ActionResult> GetAdjDropDown()
{
var _Payment = new TxnAdjustment
{
Owner = (await UserAccessService.GetUserAccessListSelect()).RefLibLst,
AdjTxnCode = await BaseService.WebGetTxnCode("I", "AdjustTxnCategoryMapInd", "Y"),
PaymentType = await BaseService.GetRefLib("TxnShortDesc", null, "2")
};
return(Json(new { Selects = _Payment, Model = new MultiPayment() }, JsonRequestBehavior.AllowGet));
}
public async Task <MsgRetriever> SaveTxnAdjustment(TxnAdjustment _TxnAdjustment)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
try
{
await objDataEngine.InitiateConnectionAsync();
SqlParameter[] Parameters = new SqlParameter[19];
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = String.IsNullOrEmpty(_TxnAdjustment.TxnId) ? new SqlParameter("@TxnId", DBNull.Value) : new SqlParameter("@TxnId", _TxnAdjustment.TxnId);
Parameters[2] = String.IsNullOrEmpty(_TxnAdjustment._CardnAccNo.AccNo) ? new SqlParameter("@AcctNo", DBNull.Value) : new SqlParameter("@AcctNo", _TxnAdjustment._CardnAccNo.AccNo);
Parameters[3] = String.IsNullOrEmpty(_TxnAdjustment._CardnAccNo.CardNo) ? new SqlParameter("@CardNo", DBNull.Value) : new SqlParameter("@CardNo", _TxnAdjustment._CardnAccNo.CardNo);
Parameters[4] = String.IsNullOrEmpty(_TxnAdjustment.SelectedTxnCd) ? new SqlParameter("@TxnCd", DBNull.Value) : new SqlParameter("@TxnCd", _TxnAdjustment.SelectedTxnCd);
Parameters[5] = new SqlParameter("@TxnDate", ConvertDatetimeDB(_TxnAdjustment.TxnDate));
Parameters[6] = String.IsNullOrEmpty(_TxnAdjustment.DueDate) ? new SqlParameter("@DueDate", DBNull.Value) : new SqlParameter("@DueDate", ConvertDatetimeDB(_TxnAdjustment.DueDate));
Parameters[7] = new SqlParameter("@TxnAmt", ConvertDecimalToDb(_TxnAdjustment.TotAmnt));
Parameters[8] = new SqlParameter("@Pts", ConvertDecimalToDb(_TxnAdjustment.Totpts));
Parameters[9] = String.IsNullOrEmpty(_TxnAdjustment.Descp) ? new SqlParameter("@Descp", DBNull.Value) : new SqlParameter("@Descp", _TxnAdjustment.Descp);
Parameters[10] = String.IsNullOrEmpty(_TxnAdjustment.AppvCd) ? new SqlParameter("@AppvCd", DBNull.Value) : new SqlParameter("@AppvCd", _TxnAdjustment.AppvCd);
Parameters[11] = new SqlParameter("@CheqNo", ConvertLongToDb(_TxnAdjustment.ChequeNo));
Parameters[12] = String.IsNullOrEmpty(_TxnAdjustment.SelectedSts) ? new SqlParameter("@Sts", DBNull.Value) : new SqlParameter("@Sts", _TxnAdjustment.SelectedSts);
Parameters[13] = new SqlParameter("@RcptNo", SqlDbType.BigInt);
Parameters[13].Direction = ParameterDirection.Output;
Parameters[14] = new SqlParameter("@RetCd", SqlDbType.BigInt);
Parameters[14].Direction = ParameterDirection.Output;
Parameters[15] = String.IsNullOrEmpty(System.Web.HttpContext.Current.User.Identity.Name) ? new SqlParameter("@UserId", DBNull.Value) : new SqlParameter("@UserId", System.Web.HttpContext.Current.User.Identity.Name);
Parameters[16] = String.IsNullOrEmpty(_TxnAdjustment.SelectedOwner) ? new SqlParameter("@Owner", DBNull.Value) : new SqlParameter("@Owner", _TxnAdjustment.SelectedOwner);
Parameters[17] = String.IsNullOrEmpty(_TxnAdjustment.DeftBusnLocation) ? new SqlParameter("@Dealer", DBNull.Value) : new SqlParameter("@Dealer", _TxnAdjustment.DeftBusnLocation);
Parameters[18] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[18].Direction = ParameterDirection.ReturnValue;
var Cmd = await objDataEngine.ExecuteWithReturnValueAsync("WebTxnAdjustmentMaint", CommandType.StoredProcedure, Parameters);
var Result = ConvertInt(Cmd.Parameters["@RETURN_VALUE"].Value);
this.RcptNo = ConvertInt(Cmd.Parameters[13].Value);
this.RetCd = ConvertInt(Cmd.Parameters[14].Value);
var Descp = await GetMessageCode(Result);
return(Descp);
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <ActionResult> GetDropDown()
{
var _Payment = new TxnAdjustment
{
TxnCode = await BaseService.GetPymtTxnCd("Pymt", null),
Owner = (await UserAccessService.GetUserAccessListSelect()).RefLibLst,
IssueingBank = await BaseService.GetRefLib("Bank"),
PaymentType = await BaseService.GetRefLib("TxnShortDesc", null, "10"),
GLSettlement = await BaseService.GetRefLib("GLSettlement")
};
var multipayment = new MultiPayment();
multipayment.ChequeAmt = "0";
return(Json(new { Selects = _Payment, Model = multipayment }, JsonRequestBehavior.AllowGet));
}
public async Task <TxnAdjustment> WebMerchantMultiTxnAdjustmentSelect(string InvoiceNo, string BatchId)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
try
{
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[3];
Parameters[0] = new SqlParameter("@OrigBatchId", BatchId);
Parameters[1] = new SqlParameter("@IssNo", GetIssNo);
Parameters[2] = String.IsNullOrEmpty(InvoiceNo) ? new SqlParameter("@InvoiceNo", DBNull.Value) : new SqlParameter("@InvoiceNo", InvoiceNo);
var execResult = await objDataEngine.ExecuteCommandAsync("WebMerchantMultiTxnAdjustmentSelect", CommandType.StoredProcedure, Parameters);
var _Adj = new TxnAdjustment();
var txnList = new List <MultipleTxnRecord>();
while (execResult.Read())
{
_Adj.SelectedTxnCd = Convert.ToString(execResult["TxnCd"]);
_Adj.SelectedTxnType = Convert.ToString(execResult["Txn Type"]);
_Adj.TxnDate = DateConverter(execResult["TxnDate"]);
_Adj.ChequeAmt = ConverterDecimal(execResult["Cheque Amt"]);
_Adj.SelectedOwner = Convert.ToString(execResult["Owner"]);
_Adj.SelectedSts = Convert.ToString(execResult["Sts"]);
_Adj.GroupingBatchId = Convert.ToString(execResult["Grouping BatchId"]);
_Adj.BatchId = Convert.ToString(execResult["BatchId"]);
_Adj.InvoiceNo = Convert.ToString(execResult["Invoice No"]);
_Adj.SelectedSts = Convert.ToString(execResult["Approval Status"]);
_Adj.StsDescp = Convert.ToString(execResult["Approval Desc"]);
txnList.Add(new MultipleTxnRecord
{
TxnAmt = ConverterDecimal(execResult["Amt"]),
MerchantAcctNo = Convert.ToString(execResult["Merchant No"]),
AcctName = Convert.ToString(execResult["Merchant Name"]),
TxnId = Convert.ToString(execResult["Ids"]),
Descp = Convert.ToString(execResult["Description"])
});
}
if (txnList.Any())
{
_Adj.MultipleTxnRecord = txnList;
}
return(_Adj);
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <TxnAdjustment> GetTxnAdjustmentDetail(TxnAdjustment _TxnAdjustment)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
try
{
await objDataEngine.InitiateConnectionAsync();
SqlParameter[] Parameters = new SqlParameter[2];
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = String.IsNullOrEmpty(_TxnAdjustment.TxnId) ? new SqlParameter("@TxnId", DBNull.Value) : new SqlParameter("@TxnId", _TxnAdjustment.TxnId);
var execResult = await objDataEngine.ExecuteCommandAsync("WebTxnAdjustmentSelect", CommandType.StoredProcedure, Parameters);
var _GetTxnAdjustmentDetail = new TxnAdjustment();
_GetTxnAdjustmentDetail._CardnAccNo = new CardnAccNo();
while (execResult.Read())
{
_GetTxnAdjustmentDetail.TxnId = Convert.ToString(execResult["TxnId"]);
_GetTxnAdjustmentDetail.TxnDate = DateConverter(execResult["TxnDate"]);
_GetTxnAdjustmentDetail.DueDate = DateConverter(execResult["DueDate"]);
_GetTxnAdjustmentDetail.SelectedTxnCd = Convert.ToString(execResult["TxnCd"]);
_GetTxnAdjustmentDetail._CardnAccNo.CardNo = Convert.ToString(execResult["CardNo"]);
_GetTxnAdjustmentDetail.TotAmnt = ConverterDecimal(execResult["TxnAmt"]);
_GetTxnAdjustmentDetail.Totpts = ConverterDecimal(execResult["Pts"]);
_GetTxnAdjustmentDetail.Descp = Convert.ToString(execResult["Descp"]);
_GetTxnAdjustmentDetail.AppvCd = Convert.ToString(execResult["AppvCd"]);
_GetTxnAdjustmentDetail.SelectedSts = Convert.ToString(execResult["Sts"]);
_GetTxnAdjustmentDetail.UserId = Convert.ToString(execResult["UserId"]);
_GetTxnAdjustmentDetail.WithHeldUnsettleId = ConvertInt(execResult["WithheldUnsettleId"]);
_GetTxnAdjustmentDetail.CreationDate = DateConverter(execResult["CreationDate"]);
_GetTxnAdjustmentDetail.SelectedOwner = Convert.ToString(execResult["Owner"]);
}
;
//if (string.IsNullOrEmpty(_GetTxnAdjustmentDetail.SelectedSts))
//{
// _GetTxnAdjustmentDetail.SelectedSts = "H";
//}
return(_GetTxnAdjustmentDetail);
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <MsgRetriever> WebMerchantMultiTxnAdjustmentMaint(TxnAdjustment _MultiPayment)
{
var objDataEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Maint);
try
{
await objDataEngine.InitiateConnectionAsync();
DataTable dt = new DataTable();
dt.Columns.Add("Acctno", typeof(long));
dt.Columns.Add("Cardno");
dt.Columns.Add("TxnAmt", typeof(decimal));
dt.Columns.Add("Descp");
dt.Columns.Add("InvoiceNo");
dt.Columns.Add("AppvCd");
dt.Columns.Add("DeftBusnlocation");
dt.Columns.Add("DeftTermId");
dt.Columns.Add("Owner");
dt.Columns.Add("Sts");
dt.Columns.Add("TxnDate");
dt.Columns.Add("DueDate");
dt.Columns.Add("TxnCd");
dt.Columns.Add("TxnId");
foreach (var item in _MultiPayment.MultipleTxnRecord)
{
DataRow dr = dt.NewRow();
dr["DeftBusnlocation"] = item.MerchantAcctNo;
if (!string.IsNullOrEmpty(item.TxnAmt))
{
dr["TxnAmt"] = ConvertDecimalToDb(item.TxnAmt);
}
else
{
dr["TxnAmt"] = DBNull.Value;
}
if (String.IsNullOrEmpty(item.Descp))
{
dr["Descp"] = DBNull.Value;
}
else
{
dr["Descp"] = item.Descp;
}
//dr["ChequeNo"] = _MultiPayment.CheqNo;
//dr["Owner"] = _MultiPayment.SelectedOwner;
dr["TxnCd"] = _MultiPayment.SelectedTxnCd;
dr["TxnDate"] = ConvertDatetimeDB(_MultiPayment.TxnDate);
dr["DueDate"] = ConvertDatetimeDB(_MultiPayment.DueDate);
dr["Owner"] = _MultiPayment.SelectedOwner;
if (String.IsNullOrEmpty(_MultiPayment.InvoiceNo))
{
dr["InvoiceNo"] = DBNull.Value;
}
else
{
dr["InvoiceNo"] = _MultiPayment.InvoiceNo;
}
if (String.IsNullOrEmpty(item.TxnId))
{
dr["TxnId"] = DBNull.Value;
}
else
{
dr["TxnId"] = item.TxnId;
}
dt.Rows.Add(dr);
}
SqlParameter[] Parameters = new SqlParameter[10];
SqlCommand cmd = new SqlCommand();
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = new SqlParameter("@UserId", GetUserId);
Parameters[2] = new SqlParameter("@Adjustment", dt);
Parameters[3] = new SqlParameter("@CheqAmt", ConvertDecimalToDb(_MultiPayment.ChequeAmt));
Parameters[4] = String.IsNullOrEmpty(_MultiPayment.InvoiceNo) ? new SqlParameter("@RcptNo", DBNull.Value) : new SqlParameter("@RcptNo", _MultiPayment.InvoiceNo);
Parameters[5] = String.IsNullOrEmpty(_MultiPayment.BatchId) ? new SqlParameter("@BatchId", DBNull.Value) : new SqlParameter("@BatchId", _MultiPayment.BatchId);
Parameters[6] = new SqlParameter("@RetCd", SqlDbType.VarChar, 25);
Parameters[6].Direction = ParameterDirection.Output;
Parameters[7] = String.IsNullOrEmpty(_MultiPayment.SelectedOwner) ? new SqlParameter("@Owner", DBNull.Value) : new SqlParameter("@Owner", _MultiPayment.SelectedOwner);
Parameters[8] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[8].Direction = ParameterDirection.ReturnValue;
Parameters[9] = new SqlParameter("@BatchOut", SqlDbType.VarChar, 25);
Parameters[9].Direction = ParameterDirection.Output;
//// Parameters[2].SqlDbType = SqlDbType.Structured
//Parameters[5] = new SqlParameter("@RefKey", _MultiPayment.RefId);
//Parameters[6] = new SqlParameter("@ChequeNo", _MultiPayment.ChequeNo);
//Parameters[7] = new SqlParameter("@TxnCd", _MultiPayment.SelectedTxnCode);
//Parameters[8] = new SqlParameter("@TxnDate", DateConverterDB(_MultiPayment.TxnDate));
//Parameters[9] = new SqlParameter("@DueDate", DateConverterDB(_MultiPayment.DueDate));
//Parameters[10] = String.IsNullOrEmpty(_MultiPayment.SlipNo) ? new SqlParameter("@SlipNo", DBNull.Value) : new SqlParameter("@SlipNo", _MultiPayment.SlipNo);
//Parameters[11] = new SqlParameter("@IssueingBankCd", _MultiPayment.SelectedIssueingBank);
//Parameters[12] = new SqlParameter("@Owner", _MultiPayment.SelectedOwner);
//Parameters[13] = new SqlParameter("@Batch", SqlDbType.VarChar, 25);
//Parameters[13].Direction = ParameterDirection.Output;
//Parameters[14] = String.IsNullOrEmpty(_MultiPayment.SelectedGLSettlement) ? new SqlParameter("@SettleVal", DBNull.Value) : new SqlParameter("@SettleVal", _MultiPayment.SelectedGLSettlement);
//Parameters[15] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
//Parameters[15].Direction = ParameterDirection.ReturnValue;
var Cmd = await objDataEngine.ExecuteWithReturnValueAsync("WebMerchantMultiTxnAdjustmentMaint", CommandType.StoredProcedure, Parameters);
var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
this.RetCd = Convert.ToString(Cmd.Parameters["@RetCd"].Value);
this.BatchId = Convert.ToString(Cmd.Parameters["@BatchOut"].Value);
var Descp = await GetMessageCode(Result);
return(Descp);
}
finally
{
objDataEngine.CloseConnection();
}
}
public MultipleTxnOpResponse()
{
txtAdjustments = new List <TxnAdjustment>();
txnAdjustment = new TxnAdjustment();
}
public MerchMultitxnAdjustmentResponse()
{
txtAdjustments = new List <TxnAdjustment>();
txnAdjustmentDetail = new TxnAdjustment();
multiPaymentGLCodes = new List <MultiPayment>();
}
public async Task <MsgRetriever> ftMultipleAdjMaint(TxnAdjustment _MultipleTxn)
{
var objDataEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Maint);
try
{
objDataEngine.InitiateConnection();
DataTable dt = new DataTable();
dt.Columns.Add("Acctno");
dt.Columns.Add("Cardno", typeof(string));//
dt.Columns.Add("TxnAmt");
dt.Columns.Add("Descp");
dt.Columns.Add("InvoiceNo");
dt.Columns.Add("AppvCd");
dt.Columns.Add("DeftBusnLocation");
dt.Columns.Add("DeftTermId");
dt.Columns.Add("Owner");
dt.Columns.Add("Sts");
dt.Columns.Add("TxnDate");
dt.Columns.Add("DueDate");
dt.Columns.Add("TxnCd");
dt.Columns.Add("TxnId");
//dt.Columns.Add("TxnId")
foreach (var item in _MultipleTxn.MultipleTxnRecord)
{
DataRow dr = dt.NewRow();
dr["Acctno"] = item.AcctNo;
dr["Cardno"] = item.CardNo;
if (!string.IsNullOrEmpty(item.TxnAmt))
{
dr["TxnAmt"] = ConvertDecimalToDb(item.TxnAmt);
}
else
{
dr["TxnAmt"] = DBNull.Value;
}
dr["Descp"] = item.TxnDescp;
dr["InvoiceNo"] = item.InvoiceNo;
dr["AppvCd"] = item.AppvCd;
dr["DeftBusnLocation"] = item.DeftBusnLocation;
dr["DeftTermId"] = item.DeftTermId;
dr["Owner"] = _MultipleTxn.SelectedOwner;
dr["Sts"] = item.SelectedSts;
dr["TxnDate"] = ConvertDatetimeDB(_MultipleTxn.TxnDate);
dr["DueDate"] = DBNull.Value;
dr["TxnCd"] = _MultipleTxn.SelectedAdjTxnCode;
dr["TxnId"] = item.TxnId;
//dr["RcptNo"] = DBNull.Value;
dt.Rows.Add(dr);
}
SqlParameter[] Parameters = new SqlParameter[11];
SqlCommand cmd = new SqlCommand();
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
//Parameters[1] = !string.IsNullOrEmpty(_MultipleTxn.CheqNo) ? new SqlParameter("@CheqNo", _MultipleTxn.CheqNo) : new SqlParameter("@CheqNo", DBNull.Value);
Parameters[1] = !string.IsNullOrEmpty(_MultipleTxn.ChequeAmt) ? new SqlParameter("@CheqAmt", ConvertDecimalToDb(_MultipleTxn.ChequeAmt)) : new SqlParameter("@CheqAmt", DBNull.Value);
Parameters[2] = new SqlParameter("@UserId", GetUserId);
Parameters[3] = new SqlParameter("@Adjustment", dt);
Parameters[4] = String.IsNullOrEmpty(_MultipleTxn.ChequeNo) ? new SqlParameter("@RcptNo", DBNull.Value) : new SqlParameter("@RcptNo", _MultipleTxn.ChequeNo);//
//Parameters[5] = new SqlParameter("@RcptNo", SqlDbType.VarChar, 19);
//Parameters[5].Direction = ParameterDirection.Output;
Parameters[5] = new SqlParameter("@Batch", SqlDbType.VarChar, 25);
Parameters[5].Direction = ParameterDirection.Output;
Parameters[6] = new SqlParameter("@RetCd", SqlDbType.Int);
Parameters[6].Direction = ParameterDirection.Output;
Parameters[7] = new SqlParameter("@RcptOut", SqlDbType.Int);
Parameters[7].Direction = ParameterDirection.Output;
Parameters[8] = string.IsNullOrEmpty(_MultipleTxn.BatchId) ? new SqlParameter("@BatchId", DBNull.Value) : new SqlParameter("@BatchId", _MultipleTxn.BatchId);
Parameters[9] = string.IsNullOrEmpty(_MultipleTxn.SelectedOwner) ? new SqlParameter("@Owner", DBNull.Value) : new SqlParameter("@Owner", _MultipleTxn.SelectedOwner);
Parameters[10] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[10].Direction = ParameterDirection.ReturnValue;
var Cmd = await objDataEngine.ExecuteWithReturnValueAsync("WebMultiTxnAdjustmentMaint", CommandType.StoredProcedure, Parameters);
var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
this.BatchId = Convert.ToString(Cmd.Parameters["@Batch"].Value);
this.RetCd = ConvertInt(Cmd.Parameters["@RetCd"].Value);
this.ChequeNo = ConvertInt(Cmd.Parameters["@RcptOut"].Value);
var Descp = await GetMessageCode(Result);
return(Descp);
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <TxnAdjustment> WebMultiTxnAdjustmentSelect(string BatchId, TxnAdjustment _Txn)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
try
{
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[3];
Parameters[0] = new SqlParameter("@BatchId", BatchId);
Parameters[1] = new SqlParameter("@IssNo", GetIssNo);
Parameters[2] = String.IsNullOrEmpty(_Txn.ChequeNo) ? new SqlParameter("@Rrn", DBNull.Value) : new SqlParameter("@Rrn", _Txn.ChequeNo);
var execResult = await objDataEngine.ExecuteCommandAsync("WebMultiTxnAdjustmentSelect", CommandType.StoredProcedure, Parameters);
var _Adj = new TxnAdjustment();
var txnList = new List <MultipleTxnRecord>();
while (execResult.Read())
{
_Adj.TxnDate = DateConverter(execResult["Txn Date"]);
_Adj.ChequeAmt = ConverterDecimal(execResult["Cheque Amt"]);
_Adj.ChequeNo = Convert.ToString(execResult["ChequeNo"]);
_Adj.BillingTxnAmt = Convert.ToString(execResult["Billing Amount"]);
_Adj.UserId = Convert.ToString(execResult["User Id"]);
_Adj.WithHeldUnsettleId = ConvertInt(execResult["WU Id"]);
_Adj.CreationDate = Convert.ToString(execResult["Creation Date"]);
_Adj.BatchId = Convert.ToString(execResult["BatchId"]);
_Adj.SelectedOwner = Convert.ToString(execResult["Owner"]);
_Adj.SelectedSts = Convert.ToString(execResult["Sts"]);
//_Adj.SelectedPaymentType = Convert.ToString(execResult["PymtType"]);
_Adj.SelectedAdjTxnCode = Convert.ToString(execResult["TxnCd"]);
//_Adj.SelectedAdjTxnCode = Convert.ToString(execResult["TxnCd"]);
_Adj.SelectedTxnType = Convert.ToString(execResult["Txn Type"]);
_Adj.SelectedPaymentType = Convert.ToString(execResult["PymtType"]);
//_Adj.SelectedAdjTxnCode = Request.QueryString["TxnCd"];
//_Adj.ShortDescp = Convert.ToString(execResult["ShortDescp"]);
txnList.Add(new MultipleTxnRecord
{
AcctNo = ConvertInt(execResult["Account No"]),
CardNo = Convert.ToString(execResult["Card No"]),
TxnAmt = ConverterDecimal(execResult["Txn Amount"]),
TxnDescp = Convert.ToString(execResult["Txn Description"]),
AppvCd = Convert.ToString(execResult["AppvCd"]),
DeftBusnLocation = Convert.ToString(execResult["Dealer"]),
DeftTermId = Convert.ToString(execResult["TermId"]),
SelectedOwner = Convert.ToString(execResult["Owner"]),
SelectedStsDescp = Convert.ToString(execResult["Status"]),
SelectedSts = Convert.ToString(execResult["Sts"]),
TxnId = Convert.ToString(execResult["TxnId"]),
AcctName = Convert.ToString(execResult["AccountName"])
});
}
if (txnList.Any())
{
_Adj.MultipleTxnRecord = txnList;
}
return(_Adj);
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <JsonResult> WebMultiTxnAdjustmentSelect(string BatchId, TxnAdjustment _Txn)
{
var txnList = (await MultipleTxnOpService.GetMultiTxnAdjustmentSelect(BatchId, _Txn.ChequeNo)).txnAdjustment;
return(Json(new { list = txnList }, JsonRequestBehavior.AllowGet));
}
public ActionResult Index()
{
var info = new TxnAdjustment();
return(View(info));
}
