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)); }