public async Task <int> SaveTxn(List <string> liTxnId, string eventId, string acctNo, string cardNo, string isPostedDispute) { using (var cardtrendentities = new pdb_ccmsContext(_connectionString)) { IssMessageDTO issMessage = new IssMessageDTO(); DataTable dtFraudTxnDisputeViewModel = null; if (liTxnId != null && liTxnId.Count() > 0) { dtFraudTxnDisputeViewModel = new DataTable(); dtFraudTxnDisputeViewModel.Columns.Add("TxnId"); for (int i = 0; i < liTxnId.Count(); i++) { DataRow dr = dtFraudTxnDisputeViewModel.NewRow(); dr["TxnId"] = Convert.ToString(liTxnId[i]); dtFraudTxnDisputeViewModel.Rows.Add(dr); } } var parameters = new[] { new SqlParameter("@IssNo", SqlDbType.SmallInt) { SqlValue = Common.Helpers.Common.GetIssueNo() }, new SqlParameter("@EventID", SqlDbType.BigInt) { SqlValue = (object)NumberExtensions.ConvertLong(eventId) ?? DBNull.Value }, new SqlParameter("@AcctNo", SqlDbType.BigInt) { SqlValue = (object)acctNo ?? DBNull.Value }, new SqlParameter("@CardNo", SqlDbType.BigInt) { SqlValue = (object)cardNo ?? DBNull.Value }, new SqlParameter("@IND", SqlDbType.SmallInt) { SqlValue = (object)NumberExtensions.ConvertIntToDb(isPostedDispute) ?? DBNull.Value }, new SqlParameter("@TxnIdTable", SqlDbType.Structured) { SqlValue = dtFraudTxnDisputeViewModel, TypeName = "ReferencesTableType" }, new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt) { Direction = ParameterDirection.Output } }; await cardtrendentities.Database.ExecuteSqlCommandAsync("exec @RETURN_VALUE = WebFraudDisputeTxnMaint @IssNo,@EventID,@AcctNo,@CardNo,@IND," + "@TxnIdTable", parameters); var resultCode = parameters.Where(x => x.ParameterName == "@RETURN_VALUE").FirstOrDefault().Value; return(Convert.ToInt32(resultCode)); } }
protected override void Configure() { this.CreateMap <CardAppcInfoDTO, CardAppcInfoModel>() .ForMember(d => d.DialogueInd, m => m.Ignore()) .ForMember(d => d.SKDSNo, m => m.Ignore()) .ForMember(d => d.CardType, m => m.Ignore()) .ForMember(d => d.PinInd, m => m.Ignore()) .ForMember(d => d.JoiningFee, m => m.Ignore()) .ForMember(d => d.CostCentre, m => m.Ignore()) .ForMember(d => d.BranchCd, m => m.Ignore()) .ForMember(d => d.DeptCd, m => m.Ignore()) .ForMember(d => d.CardMedia, m => m.Ignore()) .ForMember(d => d.AppcId, m => m.MapFrom(src => NumberExtensions.ConvertLong(src.AppcId))) .ForMember(d => d.CardType, m => m.MapFrom(src => CustomMapperExtensions.MapIEnumerableToList(src.CardTypeLst))) .ForMember(d => d.CardNo, m => m.MapFrom(src => src.CardNo)) .ForMember(d => d.DriverName, m => m.MapFrom(src => src.DriverName)) .ForMember(d => d.SelectedSKDSNo, m => m.MapFrom(src => src.SKDSNo)) .ForMember(d => d.vehRegNo, m => m.MapFrom(src => src.VehRegsNo)) .ForMember(d => d.SelectedCurrentStatus, m => m.MapFrom(src => src.Sts)) .ForMember(d => d.SKDSInd, m => m.MapFrom(src => NumberExtensions.BoolConverter(src.SKDSInd))) .ForMember(d => d.SKDSQuota, m => m.MapFrom(src => src.SKDSQuota.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.SKDSQuota)) : "")) .ForMember(d => d.PushAlertInd, m => m.MapFrom(src => NumberExtensions.BoolConverter(src.PushAlertInd))) .ForMember(d => d.LitreLimit, m => m.MapFrom(src => src.LitLimit.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.LitLimit)) : "")) .ForMember(d => d.TxnLimit, m => m.MapFrom(src => src.TxnLimit.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.TxnLimit)) : "")) .ForMember(d => d.PINExceedCnt, m => m.MapFrom(src => src.PINExceedCnt.HasValue ? Convert.ToInt32(src.PINExceedCnt) : 0)) .ForMember(d => d.SelectedPinInd, m => m.MapFrom(src => src.PINInd)) .ForMember(d => d.OdometerReadingInd, m => m.MapFrom(src => NumberExtensions.BoolConverter(src.OdometerInd))) .ForMember(d => d.SelectedVehicleModel, m => m.MapFrom(src => src.Model)) .ForMember(d => d.EmbossName, m => m.MapFrom(src => src.EmbName)) .ForMember(d => d.SelectedCardType, m => m.MapFrom(src => src.CardType)) .ForMember(d => d.SelectedDialogueInd, m => m.MapFrom(src => src.DialogueInd)) .ForMember(d => d.SelectedCostCentre, m => m.MapFrom(src => src.CostCentre)) .ForMember(d => d.AcctNo, m => m.MapFrom(src => src.AcctNo)) .ForMember(d => d.PriAppcId, m => m.MapFrom(src => src.PriAppcId.HasValue? src.PriAppcId:0)) .ForMember(d => d.PrimaryCard, m => m.MapFrom(src => src.PrimaryCard)) .ForMember(d => d.SelectedJoining, m => m.MapFrom(src => src.JoiningFeeCd)) .ForMember(d => d.SelectedAnnualFee, m => m.MapFrom(src => src.AnnlFeeCd)) .ForMember(d => d.SelectedCardMedia, m => m.MapFrom(src => src.CardMedia)) .ForMember(d => d.SelectedBranchCd, m => m.MapFrom(src => src.BranchCd)) .ForMember(d => d.SelectedDivisionCode, m => m.MapFrom(src => src.DivisionCd)) .ForMember(d => d.SelectedDeptCd, m => m.MapFrom(src => src.DeptCd)) .ForMember(d => d.SelectedProductUtilization, m => m.MapFrom(src => src.ProdGroup)) .ForMember(d => d.BranchCd, m => m.MapFrom(src => CustomMapperExtensions.MapIEnumerableToList(src.BranchCdLst))) .ForMember(d => d.DivisionCode, m => m.MapFrom(src => CustomMapperExtensions.MapIEnumerableToList(src.DivisionCodeLst))) .ForMember(d => d.DeptCd, m => m.MapFrom(src => CustomMapperExtensions.MapIEnumerableToList(src.DeptCdLst))) ; this.CreateMap <CardAppcInfoModel, CardAppcInfoDTO>() .ForMember(d => d.DialogueInd, m => m.Ignore()) .ForMember(d => d.SKDSNo, m => m.Ignore()) .ForMember(d => d.CardType, m => m.Ignore()) .ForMember(d => d.CostCentre, m => m.Ignore()) .ForMember(d => d.BranchCd, m => m.Ignore()) .ForMember(d => d.DeptCd, m => m.Ignore()) .ForMember(d => d.CardMedia, m => m.Ignore()) .ForMember(d => d.AppcId, m => m.MapFrom(src => Convert.ToInt32(src.AppcId))) .ForMember(d => d.CardType, m => m.MapFrom(src => src.SelectedCardType)) .ForMember(d => d.SKDSNo, m => m.MapFrom(src => src.SelectedSKDSNo)) .ForMember(d => d.VehRegsNo, m => m.MapFrom(src => src.vehRegNo)) .ForMember(d => d.Sts, m => m.MapFrom(src => src.SelectedCurrentStatus)) .ForMember(d => d.SKDSInd, m => m.MapFrom(src => NumberExtensions.ConvertBoolDB(src.SKDSInd))) .ForMember(d => d.SKDSQuota, m => m.MapFrom(src => NumberExtensions.ConvertDecimalToDb(src.SKDSQuota))) .ForMember(d => d.PushAlertInd, m => m.MapFrom(src => NumberExtensions.ConvertBoolDB(src.PushAlertInd))) .ForMember(d => d.LitLimit, m => m.MapFrom(src => NumberExtensions.ConvertDecimalToDb(src.LitreLimit))) .ForMember(d => d.TxnLimit, m => m.MapFrom(src => NumberExtensions.ConvertDecimalToDb(src.TxnLimit))) .ForMember(d => d.PINExceedCnt, m => m.MapFrom(src => Convert.ToByte(src.PINExceedCnt))) .ForMember(d => d.PINInd, m => m.MapFrom(src => src.SelectedPinInd)) .ForMember(d => d.OdometerInd, m => m.MapFrom(src => NumberExtensions.ConvertBoolDB(src.OdometerReadingInd))) .ForMember(d => d.Model, m => m.MapFrom(src => src.SelectedVehicleModel)) .ForMember(d => d.EmbName, m => m.MapFrom(src => src.EmbossName)) .ForMember(d => d.CardType, m => m.MapFrom(src => src.SelectedCardType)) .ForMember(d => d.DialogueInd, m => m.MapFrom(src => src.SelectedDialogueInd)) .ForMember(d => d.CostCentre, m => m.MapFrom(src => src.SelectedCostCentre)) .ForMember(d => d.PriAppcId, m => m.MapFrom(src => src.PriAppcId)) .ForMember(d => d.PrimaryCard, m => m.MapFrom(src => src.PrimaryCard)) .ForMember(d => d.JoiningFeeCd, m => m.MapFrom(src => src.SelectedJoining)) .ForMember(d => d.AnnlFeeCd, m => m.MapFrom(src => src.SelectedAnnualFee)) .ForMember(d => d.CardMedia, m => m.MapFrom(src => src.SelectedCardMedia)) .ForMember(d => d.BranchCd, m => m.MapFrom(src => src.SelectedBranchCd)) .ForMember(d => d.DivisionCd, m => m.MapFrom(src => src.SelectedDivisionCode)) .ForMember(d => d.DeptCd, m => m.MapFrom(src => src.SelectedDeptCd)) .ForMember(d => d.ProdGroup, m => m.MapFrom(src => src.SelectedProductUtilization)) .ForMember(d => d.BranchCdLst, m => m.MapFrom(src => CustomMapperExtensions.MapIEnumerableToList(src.BranchCd))) .ForMember(d => d.DivisionCodeLst, m => m.MapFrom(src => CustomMapperExtensions.MapIEnumerableToList(src.DivisionCode))) .ForMember(d => d.DeptCdLst, m => m.MapFrom(src => CustomMapperExtensions.MapIEnumerableToList(src.DeptCd))) ; this.CreateMap <CardFinancialInfoModel, CardFinancialInfoDTO>() .ForMember(d => d.TxnLimit, m => m.MapFrom(src => NumberExtensions.ConvertDecimalToDb(src.txnLimit))) .ForMember(d => d.LitLimit, m => m.MapFrom(src => NumberExtensions.ConvertDecimalToDb(src.litLimit))) .ForMember(d => d.PinExceedCnt, m => m.MapFrom(src => NumberExtensions.ConvertIntToDb(src.PinAttempted))) .ForMember(d => d.PinAttempted, m => m.MapFrom(src => NumberExtensions.ConvertIntToDb(src.PinAttempted))) .ForMember(d => d.PinTriedUpdDate, m => m.MapFrom(src => NumberExtensions.DateConverterDB(src.PinTriedUpdDate))) ; this.CreateMap <CardFinancialInfoDTO, CardFinancialInfoModel>() .ForMember(d => d.txnLimit, m => m.MapFrom(src => src.TxnLimit.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", (src.TxnLimit))) : "")) .ForMember(d => d.litLimit, m => m.MapFrom(src => src.TxnLimit.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", (src.LitLimit))) : "")) .ForMember(d => d.PinExceedCnt, m => m.MapFrom(src => src.PinExceedCnt.HasValue ? Convert.ToInt32(src.PinExceedCnt) : 0)) .ForMember(d => d.PinAttempted, m => m.MapFrom(src => Convert.ToInt32(src.PinAttempted))) .ForMember(d => d.PinTriedUpdDate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.PinTriedUpdDate))) ; this.CreateMap <AccountCaoDTO, CreditAssesOperation>() .ForMember(d => d.TerritoryCd, m => m.Ignore()) .ForMember(d => d.RiskCategory, m => m.Ignore()) .ForMember(d => d.remarkHistory, m => m.Ignore()) .ForMember(d => d.AssesmtType, m => m.Ignore()) .ForMember(d => d.BankAcctType, m => m.Ignore()) .ForMember(d => d.BankName, m => m.Ignore()) .ForMember(d => d.DepositType, m => m.Ignore()) .ForMember(d => d.ReasonCd, m => m.Ignore()) .ForMember(d => d.PaymentMode, m => m.Ignore()) .ForMember(d => d.PaymentTerm, m => m.Ignore()) .ForMember(d => d.Quantitative, m => m.Ignore()) .ForMember(d => d.Qualitative, m => m.Ignore()) .ForMember(d => d.CreditLimit, m => m.MapFrom(src => src.CreditLimit.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.CreditLimit)) : "")) .ForMember(d => d.SelectedPaymentMode, m => m.MapFrom(src => !string.IsNullOrEmpty(src.PymtMode)? src.PymtMode : "0")) .ForMember(d => d.SelectedPaymentTerm, m => m.MapFrom(src => src.PymtTerms)) .ForMember(d => d.TxnAmtLimit, m => m.MapFrom(src => src.TxnAmtLimit.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.TxnAmtLimit)) : "")) .ForMember(d => d.TxnLitLimit, m => m.MapFrom(src => src.TxnLitLimit.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.TxnLitLimit)) : "")) .ForMember(d => d.SelectedTerritoryCd, m => m.MapFrom(src => src.SaleTerritory)) .ForMember(d => d.SelectedRiskCategry, m => m.MapFrom(src => string.IsNullOrEmpty(src.RiskCategory) ? "1" : src.RiskCategory)) .ForMember(d => d.SelectedAssesmtType, m => m.MapFrom(src => src.AssessmentType)) .ForMember(d => d.SecurityAmt, m => m.MapFrom(src => src.SecurityAmt.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.SecurityAmt)) : "")) .ForMember(d => d.DirectDebitInd, m => m.MapFrom(src => NumberExtensions.BoolConverter(src.DirectDebitInd))) .ForMember(d => d.SelectedDepositType, m => m.MapFrom(src => src.DepositType)) .ForMember(d => d.DepositExp, m => m.MapFrom(src => NumberExtensions.DateConverter(src.DepositExp))) .ForMember(d => d.SelectedBankAcctType, m => m.MapFrom(src => src.BankAcctType)) .ForMember(d => d.SelectedBankName, m => m.MapFrom(src => src.BankName)) //.ForMember(d => d.BankBranchCode, m => m.MapFrom(src => src.SAPRefNo)) .ForMember(d => d.DepositFromDate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.EffFromDate))) .ForMember(d => d.DepositToDate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.EffToDate))) .ForMember(d => d.BankAcctNo, m => m.MapFrom(src => src.BankAcctNo)) .ForMember(d => d.BankBranchCode, m => m.MapFrom(src => src.BGSerialNo)) .ForMember(d => d.DepositAmt, m => m.MapFrom(src => src.DepositAmt.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.DepositAmt)) : "")) .ForMember(d => d.ValidityDate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.ValidityDate))) .ForMember(d => d.NRID, m => m.MapFrom(src => NumberExtensions.DateConverter(src.NRID))) .ForMember(d => d.SelectedReasonCode, m => m.MapFrom(src => src.ReasonCd)) .ForMember(d => d.AppvUserIdQAOff, m => m.MapFrom(src => src.AppvUserId1)) .ForMember(d => d.SelectedAppvStsQAOff, m => m.MapFrom(src => src.AppvSts1)) .ForMember(d => d.AppvDateQAOff, m => m.MapFrom(src => NumberExtensions.DateConverter(src.AppvDate1))) .ForMember(d => d.AppvUserIdBackOff, m => m.MapFrom(src => src.AppvUserId2)) .ForMember(d => d.SelectedAppvStsBackOff, m => m.MapFrom(src => src.AppvSts2)) .ForMember(d => d.AppvDateBackOff, m => m.MapFrom(src => NumberExtensions.DateConverter(src.AppvDate2))) .ForMember(d => d.AppvUserIdEDP, m => m.MapFrom(src => src.AppvUserId4)) .ForMember(d => d.SelectedAppvStsEDP, m => m.MapFrom(src => src.AppvSts4)) .ForMember(d => d.AppvDateEDP, m => m.MapFrom(src => NumberExtensions.DateConverter(src.AppvDate4))) .ForMember(d => d.Txnid, m => m.MapFrom(src => src.TxnId)) .ForMember(d => d.Creationdt, m => m.MapFrom(src => NumberExtensions.DateConverter(src.CreationDate))) .ForMember(d => d.remarks, m => m.MapFrom(src => src.Remarks)) .ForMember(d => d.SelectedQuantitative, m => m.MapFrom(src => src.Quantitativerating)) .ForMember(d => d.SelectedQualitative, m => m.MapFrom(src => src.Qualitativerating)) .ForMember(d => d.ProposeCreditLimit, m => m.MapFrom(src => src.PropCreditLimit.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.PropCreditLimit)) : "")) .ForMember(d => d.RecommendCreditLimit, m => m.MapFrom(src => src.RecCreditLimit.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.RecCreditLimit)) : "")) .ForMember(d => d.ProposeSecurityAmt, m => m.MapFrom(src => src.PropSecurityAmt.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.PropSecurityAmt)) : "")) .ForMember(d => d.RecommendSecurityAmt, m => m.MapFrom(src => src.RecSecurityAmt.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.RecSecurityAmt)) : "")) .ForMember(d => d.DocPath, m => m.MapFrom(src => src.DocPath)) .ForMember(d => d.SelectedTradingArea, m => m.MapFrom(src => src.TradingArea)) //.ForMember(d => d.remarkHistory, m => m.MapFrom(s => CustomMapperExtensions.MapIEnumerableToList(s.remarkHistory))) ; this.CreateMap <CreditAssesOperation, AccountCaoDTO>() .ForMember(d => d.RiskCategory, m => m.Ignore()) .ForMember(d => d.BankAcctType, m => m.Ignore()) .ForMember(d => d.BankName, m => m.Ignore()) .ForMember(d => d.DepositType, m => m.Ignore()) .ForMember(d => d.ReasonCd, m => m.Ignore()) .ForMember(d => d.AcctNo, m => m.MapFrom(src => src.acctNo)) .ForMember(d => d.CreditLimit, m => m.MapFrom(src => NumberExtensions.ConvertDecimalToDb(src.CreditLimit))) .ForMember(d => d.PymtTerms, m => m.MapFrom(src => Convert.ToInt32(src.SelectedPaymentTerm))) .ForMember(d => d.TxnAmtLimit, m => m.MapFrom(src => NumberExtensions.ConvertDecimalToDb(src.TxnAmtLimit))) .ForMember(d => d.TxnLitLimit, m => m.MapFrom(src => NumberExtensions.ConvertDecimalToDb(src.TxnLitLimit))) .ForMember(d => d.SaleTerritory, m => m.MapFrom(src => src.SelectedTerritoryCd)) .ForMember(d => d.RiskCategory, m => m.MapFrom(src => src.SelectedRiskCategry)) .ForMember(d => d.AssessmentType, m => m.MapFrom(src => src.SelectedAssesmtType)) //.ForMember(d => d.SecurityAmt, m => m.MapFrom(src => src.SecurityAmt.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.SecurityAmt)) : "")) .ForMember(d => d.DirectDebitInd, m => m.MapFrom(src => NumberExtensions.ConvertBoolDB(src.DirectDebitInd))) .ForMember(d => d.DepositType, m => m.MapFrom(src => src.SelectedDepositType)) .ForMember(d => d.DepositExp, m => m.MapFrom(src => NumberExtensions.DateConverter(src.DepositExp))) .ForMember(d => d.BankAcctType, m => m.MapFrom(src => src.SelectedBankAcctType)) .ForMember(d => d.BankName, m => m.MapFrom(src => src.SelectedBankName)) .ForMember(d => d.BankAcctNo, m => m.MapFrom(src => src.BankAcctNo)) .ForMember(d => d.BankBranchCd, m => m.MapFrom(src => src.BankBranchCode)) .ForMember(d => d.DepositAmt, m => m.MapFrom(src => NumberExtensions.ConvertDecimalToDb(src.DepositAmt))) .ForMember(d => d.ValidityDate, m => m.MapFrom(src => NumberExtensions.DateConverterDB(src.ValidityDate))) .ForMember(d => d.NRID, m => m.MapFrom(src => NumberExtensions.DateConverterDB(src.NRID))) .ForMember(d => d.ReasonCd, m => m.MapFrom(src => src.SelectedReasonCode)) .ForMember(d => d.AppvUserId1, m => m.MapFrom(src => src.AppvUserIdQAOff)) .ForMember(d => d.AppvSts1, m => m.MapFrom(src => src.SelectedAppvStsQAOff)) .ForMember(d => d.AppvDate1, m => m.MapFrom(src => NumberExtensions.DateConverterDB(src.AppvDateQAOff))) .ForMember(d => d.AppvUserId2, m => m.MapFrom(src => src.AppvUserIdBackOff)) .ForMember(d => d.AppvSts2, m => m.MapFrom(src => src.SelectedAppvStsBackOff)) .ForMember(d => d.AppvDate2, m => m.MapFrom(src => NumberExtensions.DateConverterDB(src.AppvDateBackOff))) .ForMember(d => d.AppvUserId4, m => m.MapFrom(src => src.AppvUserIdEDP)) .ForMember(d => d.AppvSts4, m => m.MapFrom(src => src.SelectedAppvStsEDP)) .ForMember(d => d.AppvDate4, m => m.MapFrom(src => NumberExtensions.DateConverterDB(src.AppvDateEDP))) .ForMember(d => d.PymtMode, m => m.MapFrom(src => src.SelectedPaymentMode)) .ForMember(d => d.Remarks, m => m.MapFrom(src => src.remarks)) .ForMember(d => d.Quantitativerating, m => m.MapFrom(src => src.SelectedQuantitative)) .ForMember(d => d.Qualitativerating, m => m.MapFrom(src => src.SelectedQualitative)) .ForMember(d => d.PropCreditLimit, m => m.MapFrom(src => NumberExtensions.ConvertDecimalToDb(src.ProposeCreditLimit))) .ForMember(d => d.RecCreditLimit, m => m.MapFrom(src => NumberExtensions.ConvertDecimalToDb(src.RecommendCreditLimit))) .ForMember(d => d.PropSecurityAmt, m => m.MapFrom(src => NumberExtensions.ConvertDecimalToDb(src.ProposeSecurityAmt))) .ForMember(d => d.RecSecurityAmt, m => m.MapFrom(src => NumberExtensions.ConvertDecimalToDb(src.RecommendSecurityAmt))) .ForMember(d => d.DocPath, m => m.MapFrom(src => src.DocPath)) .ForMember(d => d.TradingArea, m => m.MapFrom(src => src.SelectedTradingArea)) ; this.CreateMap <WebSecDepRemarksDTO, RemarkHistory>() .ForMember(d => d.Content, m => m.MapFrom(src => src.RemarkHistory)) .ForMember(d => d.CreationDate, m => m.MapFrom(src => src.CreationDate)) .ForMember(d => d.UserId, m => m.MapFrom(src => src.CreatedBy)) ; this.CreateMap <AcctDepositInfoDTO, CreditAssesOperation>() .ForMember(d => d.TerritoryCd, m => m.Ignore()) .ForMember(d => d.RiskCategory, m => m.Ignore()) .ForMember(d => d.remarkHistory, m => m.Ignore()) .ForMember(d => d.AssesmtType, m => m.Ignore()) .ForMember(d => d.BankAcctType, m => m.Ignore()) .ForMember(d => d.BankName, m => m.Ignore()) .ForMember(d => d.DepositType, m => m.Ignore()) .ForMember(d => d.ReasonCd, m => m.Ignore()) .ForMember(d => d.PaymentMode, m => m.Ignore()) .ForMember(d => d.PaymentTerm, m => m.Ignore()) .ForMember(d => d.Quantitative, m => m.Ignore()) .ForMember(d => d.Qualitative, m => m.Ignore()) .ForMember(d => d.DirectDebitInd, m => m.MapFrom(src => NumberExtensions.BoolConverter(src.DirectDebitInd))) .ForMember(d => d.SelectedDepositType, m => m.MapFrom(src => src.DepositType)) .ForMember(d => d.SelectedBankAcctType, m => m.MapFrom(src => src.BankAcctType)) .ForMember(d => d.SelectedBankName, m => m.MapFrom(src => src.BankName)) .ForMember(d => d.BankAcctNo, m => m.MapFrom(src => src.BankAcctNo)) .ForMember(d => d.DepositAmt, m => m.MapFrom(src => src.DepositAmt.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.DepositAmt)) : "")) .ForMember(d => d.Txnid, m => m.MapFrom(src => src.TxnId)) .ForMember(d => d.Creationdt, m => m.MapFrom(src => src.CreationDate)) .ForMember(d => d.DepositFromDate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.DepositFromDate))) .ForMember(d => d.DepositToDate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.DepositToDate))) .ForMember(d => d.BgSerialNo, m => m.MapFrom(src => src.BGSerialNo)) .ForMember(d => d.SecurityAmt, m => m.MapFrom(src => src.SecurityDeposit.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.SecurityDeposit)) : "")) .ForMember(d => d.SAPRefNo, m => m.MapFrom(src => src.SAPRefNo)) .ForMember(d => d.ValidityDate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.ValidityDate))) ; }
/// <author> /// Tuan /// </author> /// <param date="1/03/2017"></param> /// <param name="ManualSlipEntryBatchDetailDTO"></param> /// <returns> string</returns> public async Task <IssMessageDTO> SaveManualSlipEntry(MerchManualTxnDTO merchmanualTxn) { using (var cardtrendentities = new pdb_ccmsContext(_connectionString)) { var parameters = new object[] { Common.Helpers.Common.GetIssueNo(), merchmanualTxn.TxnCd, merchmanualTxn.Dealer, merchmanualTxn.TerminalId, merchmanualTxn.SiteId, merchmanualTxn.SettleId , merchmanualTxn.TxnId, merchmanualTxn.ReceiptNo, merchmanualTxn.InvoiceNo, merchmanualTxn.Stan, merchmanualTxn.CardNo , merchmanualTxn.CardExpiry, merchmanualTxn.DriverCard, merchmanualTxn.AuthCardExp, NumberExtensions.ConvertIntToDb(merchmanualTxn.DriverCd), merchmanualTxn.TxnDate, NumberExtensions.ConvertIntToDb(merchmanualTxn.ArrayCount), merchmanualTxn.Quantity, merchmanualTxn.TotalAmt, merchmanualTxn.Description, merchmanualTxn.OdometerReading, merchmanualTxn.Rrn, merchmanualTxn.AuthNo, merchmanualTxn.Sts, merchmanualTxn.UserId, merchmanualTxn.VATNo }; var paramNameList = new[] { "@AcqNo", "@TxnCd", "@BusnLocation", "@TermId", "@SiteId", "@SettleId", "@TxnId", "@RcptNo", "@InvoiceNo", "@Stan", "@CardNo", "@CardExp", "@AuthCardNo", "@AuthCardExp", "@DriverCd", "@TxnDate", "@ArrayCnt", "@Qty", "@Amt", "@Descp", "@Odometer", "@Rrn", "@AuthNo", "@Sts", "@UserId", "@VATNo" }; var outPutParameter = new object[] { new ColumnInfo { FieldName = "@oTxnId", DataType = "varchar", ColLength = 19 }, new ColumnInfo { FieldName = "@oSettleId", DataType = "varchar", ColLength = 19 } }; var paramCollection = BuildParameterListWithOutPutAndRrn(parameters, outPutParameter, paramNameList); var result = await cardtrendentities.Database.ExecuteSqlCommandAsync (BuildSqlCommandWithRrn("WebMerchManualTxnMaint", paramCollection), paramCollection.ToArray()); var resultCode = paramCollection.Where(x => x.ParameterName == "@RETURN_VALUE").FirstOrDefault().Value; var txnId = paramCollection.Where(x => x.ParameterName == "@oTxnId").FirstOrDefault().Value; var settleId = paramCollection.Where(x => x.ParameterName == "@oSettleId").FirstOrDefault().Value; return(new IssMessageDTO() { Descp = string.Empty, Flag = Convert.ToInt32(resultCode), paraOut = new ReturnObject { TxnId = Convert.ToString(txnId), SettleId = Convert.ToString(settleId) } }); } }
public async Task <IssMessageDTO> SaveEventAcctConfMaint(NtfyEventConfDTO lookUpParameters) { using (var cardtrendentities = new pdb_ccmsContext(_connectionString)) { IssMessageDTO issMessage = new IssMessageDTO(); var dtNtfyEventTbl = new DataTable(); var dtNtfyEventRcptTbl = new DataTable(); dtNtfyEventTbl.Columns.Add("EvtNtfyDetailId"); dtNtfyEventTbl.Columns.Add("MinIntVal"); dtNtfyEventTbl.Columns.Add("MaxIntVal"); dtNtfyEventTbl.Columns.Add("MinMoneyVal"); dtNtfyEventTbl.Columns.Add("MaxMoneyVal"); dtNtfyEventTbl.Columns.Add("MinDateVal"); dtNtfyEventTbl.Columns.Add("MaxDateVal"); dtNtfyEventTbl.Columns.Add("MinTimeVal"); dtNtfyEventTbl.Columns.Add("MaxTimeVal"); dtNtfyEventTbl.Columns.Add("VarCharVal"); dtNtfyEventTbl.Columns.Add("PeriodType"); dtNtfyEventTbl.Columns.Add("PeriodInterval"); if (lookUpParameters.ProductItems != null) { foreach (var item in lookUpParameters.ProductItems) { DataRow dr = dtNtfyEventTbl.NewRow(); dr["EvtNtfyDetailId"] = item.EvtPlanDetailId; dr["MinIntVal"] = NumberExtensions.ConvertLongToDb(item.MinIntVal); dr["MaxIntVal"] = NumberExtensions.ConvertLongToDb(item.MaxIntVal); dr["MinMoneyVal"] = NumberExtensions.ConvertDecimalToDb(item.MinMoneyVal); dr["MaxMoneyVal"] = NumberExtensions.ConvertDecimalToDb(item.MaxMoneyVal); dr["MinDateVal"] = NumberExtensions.ConvertDatetimeDB(item.MinDateVal); dr["MaxDateVal"] = NumberExtensions.ConvertDatetimeDB(item.MaxDateVal); dr["MinTimeVal"] = item.MinTimeVal; dr["MaxTimeVal"] = item.MaxTimeVal; dr["VarCharVal"] = item.VarCharVal; dr["PeriodType"] = item.PeriodType; dr["PeriodInterval"] = item.PeriodInterval; dtNtfyEventTbl.Rows.Add(dr); } } dtNtfyEventRcptTbl.Columns.Add("EventRecipientId"); dtNtfyEventRcptTbl.Columns.Add("EventScheduleId"); dtNtfyEventRcptTbl.Columns.Add("ContactName"); dtNtfyEventRcptTbl.Columns.Add("ContactNo"); dtNtfyEventRcptTbl.Columns.Add("ChannelInd"); dtNtfyEventRcptTbl.Columns.Add("LangInd"); if (lookUpParameters.eventRcpts != null) { foreach (var item in lookUpParameters.eventRcpts) { DataRow dr = dtNtfyEventRcptTbl.NewRow(); dr["EventRecipientId"] = string.IsNullOrEmpty(item.Id.ToString()) ? (object)DBNull.Value : item.Id; dr["EventScheduleId"] = string.IsNullOrEmpty(lookUpParameters.EventScheduleId.ToString()) ? (object)DBNull.Value : lookUpParameters.EventScheduleId; dr["ContactName"] = string.IsNullOrEmpty(item.ContactName) ? (object)DBNull.Value : item.ContactName; dr["ContactNo"] = string.IsNullOrEmpty(item.ContactNo) ? (object)DBNull.Value : item.ContactNo; dr["ChannelInd"] = item.ChannelInd; dr["LangInd"] = string.IsNullOrEmpty(item.LangInd) ? (object)DBNull.Value : item.LangInd; dtNtfyEventRcptTbl.Rows.Add(dr); } } var parameters = new[] { new SqlParameter("@IssNo", SqlDbType.SmallInt) { SqlValue = Common.Helpers.Common.GetIssueNo() }, new SqlParameter("@EventSchId", SqlDbType.BigInt) { SqlValue = (object)lookUpParameters.EventScheduleId ?? DBNull.Value }, new SqlParameter("@NewEventSchId", SqlDbType.BigInt) { Direction = ParameterDirection.Output }, new SqlParameter("@EventTypeID", SqlDbType.BigInt) { SqlValue = (object)lookUpParameters.EventTypeId ?? DBNull.Value }, new SqlParameter("@EventPlanId", SqlDbType.BigInt) { SqlValue = (object)lookUpParameters.EventPlanId ?? DBNull.Value }, new SqlParameter("@ShortDescp", SqlDbType.NVarChar) { SqlValue = (object)lookUpParameters.ShortDescp ?? DBNull.Value }, new SqlParameter("@Scope", SqlDbType.VarChar) { SqlValue = (object)lookUpParameters.OwnerType ?? DBNull.Value }, new SqlParameter("@Sts", SqlDbType.VarChar) { SqlValue = (object)lookUpParameters.Sts ?? DBNull.Value }, new SqlParameter("@ParamInd", SqlDbType.BigInt) { SqlValue = string.Empty }, new SqlParameter("@RefTo", SqlDbType.VarChar) { SqlValue = (object)lookUpParameters.Refto ?? DBNull.Value }, new SqlParameter("@RefKey", SqlDbType.VarChar) { SqlValue = (object)lookUpParameters.Refkey ?? DBNull.Value }, new SqlParameter("@CntEvtOccur", SqlDbType.Int) { SqlValue = (object)lookUpParameters.MaxOccur ?? DBNull.Value }, new SqlParameter("@EvtOccurType", SqlDbType.VarChar) { SqlValue = (object)lookUpParameters.Frequency ?? DBNull.Value }, new SqlParameter("@UserId", SqlDbType.VarChar) { SqlValue = (object)lookUpParameters.UserId ?? DBNull.Value }, new SqlParameter("@ChannelInd", SqlDbType.BigInt) { SqlValue = (object)(NumberExtensions.ConvertIntToDb(lookUpParameters.EvtTypeChannelInd)) ?? DBNull.Value }, new SqlParameter("@DefaultInd", SqlDbType.Char) { SqlValue = (object)lookUpParameters.DefaultInd ?? DBNull.Value }, new SqlParameter("@NtfyEventTbl", SqlDbType.Structured) { SqlValue = dtNtfyEventTbl, TypeName = "NtfyEventTbl" }, new SqlParameter("@NtfyEventRcptTbl", SqlDbType.Structured) { SqlValue = dtNtfyEventRcptTbl, TypeName = "NtfyEventRcptTbl" }, new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt) { Direction = ParameterDirection.Output } }; await cardtrendentities.Database.ExecuteSqlCommandAsync("exec @RETURN_VALUE = WebEventAcctConfMaint @IssNo,@EventSchId,@NewEventSchId OUT,@EventTypeID,@EventPlanId," + "@ShortDescp,@Scope,@Sts,@ParamInd,@RefTo,@RefKey,@CntEvtOccur,@EvtOccurType,@UserId,@ChannelInd,@DefaultInd,@NtfyEventTbl,@NtfyEventRcptTbl", parameters); var resultCode = parameters.Where(x => x.ParameterName == "@RETURN_VALUE").FirstOrDefault().Value; var newEventSchId = parameters.Where(x => x.ParameterName == "@NewEventSchId").FirstOrDefault().Value; issMessage.Flag = Convert.ToInt32(resultCode); issMessage.paraOut.NewEventSchId = Convert.ToInt64(newEventSchId); return(issMessage); } }