public async Task <int> SavePersonInfo(PersonalInfoDTO personalInfoDto, string entityId) { using (var cardtrendentities = new pdb_ccmsContext(_connectionString)) { IssMessageDTO issMessage = new IssMessageDTO(); var parameters = new object[] { Common.Helpers.Common.GetIssueNo(), personalInfoDto.EntityId, personalInfoDto.Title, personalInfoDto.FirstName, personalInfoDto.LastName, personalInfoDto.NewIcType, personalInfoDto.NewIc, personalInfoDto.OldIcType, personalInfoDto.OldIc, personalInfoDto.Gender, personalInfoDto.DOB, NumberExtensions.ConvertDecimalToDb(personalInfoDto.IncomeBK), personalInfoDto.Occupation, personalInfoDto.DeptId, personalInfoDto.DrivingLic }; var paramNameList = new[] { "@IssNo", "@EntityId", "@Title", "@FirstName", "@LastName", "@NewIcType", "@NewIc", "@OldIcType", "@OldIc", "@Gender", "@DOB", "@Income", "@Occupation", "@DeptId", "@DrivingLic" }; var paramCollection = BuildParameterListWithRrn(parameters, paramNameList); var result = await cardtrendentities.Database.ExecuteSqlCommandAsync(BuildSqlCommandWithRrn("WebEntityMaint", paramCollection), paramCollection.ToArray()); var resultCode = paramCollection.Where(x => x.ParameterName == "@RETURN_VALUE").FirstOrDefault().Value; return(Convert.ToInt32(resultCode)); } }
public async Task <int> SaveFinancialInfo(CardHolderInfoDTO finInfo, string cardNo) { using (var cardtrendentities = new pdb_ccmsContext(_connectionString)) { IssMessageDTO issMessage = new IssMessageDTO(); var parameters = new object[] { Common.Helpers.Common.GetIssueNo(), cardNo, finInfo.TxnLimit, finInfo.LitLimit, (object)Convert.ToInt32(finInfo.PINExceedCnt) ?? null, finInfo.PINAttempted, finInfo.PinTriedUpdDate, finInfo.PushAlertInd, finInfo.LocationInd, finInfo.LocationCheckFlag, finInfo.LocationMaxCnt, finInfo.LocationMaxAmt, finInfo.FuelCheckFlag, finInfo.FuelLitPerKM }; var paramNameList = new[] { "@IssNo", "@CardNo", "@TxnLimit", "@LitLimit", "@PinExceedCnt", "@PinAttempted", "@PinTriedUpdDate", "@PushAlertInd", "@LocationInd", "@LocationCheckFlag", "@LocationMaxCnt", "@LocationMaxAmt", "@FuelCheckFlag", "@FuelLitPerKM" }; var paramCollection = BuildParameterListWithRrn(parameters, paramNameList); var result = await cardtrendentities.Database.ExecuteSqlCommandAsync(BuildSqlCommandWithRrn("WebCardFinInfoMaint", paramCollection), paramCollection.ToArray()); var resultCode = paramCollection.Where(x => x.ParameterName == "@RETURN_VALUE").FirstOrDefault().Value; return(Convert.ToInt32(resultCode)); } }
public async Task <IssMessageDTO> SaveCardReplacement(CardReplacementDTO cardReplacement, string userId) { using (var cardtrendentities = new pdb_ccmsContext(_connectionString)) { IssMessageDTO issMessage = new IssMessageDTO(); var parameters = new[] { new SqlParameter("@IssNo", SqlDbType.SmallInt) { SqlValue = Common.Helpers.Common.GetIssueNo() }, new SqlParameter("@CardNo", SqlDbType.VarChar) { SqlValue = (object)cardReplacement.PrevCardNo ?? DBNull.Value }, new SqlParameter("@NewCardNo", SqlDbType.VarChar, 19) { Direction = ParameterDirection.Output }, new SqlParameter("@ExpiryDate", SqlDbType.VarChar) { SqlValue = (object)NumberExtensions.ConvertDatetimeDB(cardReplacement.CardExpiry.ToString()) ?? DBNull.Value }, new SqlParameter("@FeeCd", SqlDbType.VarChar) { SqlValue = (object)cardReplacement.FeeCd ?? DBNull.Value }, new SqlParameter("@ReasonCd", SqlDbType.VarChar) { SqlValue = (object)cardReplacement.RsCode ?? DBNull.Value }, new SqlParameter("@Remarks", SqlDbType.VarChar) { SqlValue = (object)cardReplacement.Remarks ?? DBNull.Value }, new SqlParameter("@UserId", SqlDbType.VarChar) { SqlValue = userId }, new SqlParameter("@CardMedia", SqlDbType.Int) { SqlValue = (object)cardReplacement.CardMedia ?? DBNull.Value }, new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt) { Direction = ParameterDirection.Output } }; await cardtrendentities.Database.ExecuteSqlCommandAsync("exec @RETURN_VALUE = WebCardReplacementMaint @IssNo,@CardNo,@NewCardNo OUT,@ExpiryDate,@FeeCd," + "@ReasonCd,@Remarks,@UserId,@CardMedia", parameters); var resultCode = parameters.Where(x => x.ParameterName == "@RETURN_VALUE").FirstOrDefault().Value; var newCardNo = parameters.Where(x => x.ParameterName == "@NewCardNo").FirstOrDefault().Value; issMessage.Flag = Convert.ToInt32(resultCode); issMessage.paraOut.NewcardNo = Convert.ToString(newCardNo); return(issMessage); } }
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)); } }
public async Task <List <NtfyEventConfDTO> > WebNtfyEventConfSelect(string planId) { using (var cardtrendentities = new pdb_ccmsContext(_connectionString)) { IssMessageDTO issMessage = new IssMessageDTO(); var parameters = new object[] { planId }; var paramNameList = new[] { "@EventScheduleId" }; var paramCollection = BuildParameterList(parameters, paramNameList); var results = await cardtrendentities.Database.SqlQuery <NtfyEventConfDTO>(BuildSqlCommand("WebNtfyEventConfSelect", paramCollection), paramCollection.ToArray()).ToListAsync(); return(results); } }
public async Task <int> SaveGeneralInfo(CardHolderInfoDTO cardHolder, string userId) { using (var cardtrendentities = new pdb_ccmsContext(_connectionString)) { IssMessageDTO issMessage = new IssMessageDTO(); var parameters = new object[] { Common.Helpers.Common.GetIssueNo(), (object)Convert.ToInt64(cardHolder.CardNo) ?? null, cardHolder.EmbName, cardHolder.Sts, cardHolder.TerminatedDate == DateTime.MinValue?null:cardHolder.TerminatedDate, cardHolder.VehRegsNo, cardHolder.DriverCd, cardHolder.SKDSInd, cardHolder.SKDSQuota, cardHolder.SKDSNo, cardHolder.DialogueInd, cardHolder.PINInd, cardHolder.OdometerInd, cardHolder.AcctNo, cardHolder.PushAlertInd, cardHolder.AnnlFeeCd, cardHolder.JoiningFeeCd, cardHolder.RenewalInd, userId, cardHolder.PrimaryCard, cardHolder.Model, cardHolder.CostCentre, cardHolder.BranchCd, cardHolder.DivisionCd, cardHolder.DeptCd, cardHolder.ProdGroup }; var paramNameList = new[] { "@IssNo", "@CardNo", "@EmbName", "@Sts", "@TerminatedDate", "@VehRegsNo", "@DriverCd", "@SKDSInd", "@SKDSQuota", "@SKDSNo", "@DialogueInd", "@PINInd", "@OdometerInd", "@AcctNo", "@PushAlertInd", "@AnnlFee", "@JoiningFee", "@RenewalInd", "@UserId", "@PrimaryCard", "@VehModel", "@CostCentre", "@BranchCd", "@DivisionCd", "@DeptCd", "@ProductGroup" }; var paramCollection = BuildParameterListWithRrn(parameters, paramNameList); var result = await cardtrendentities.Database.ExecuteSqlCommandAsync(BuildSqlCommandWithRrn("WebCardGeneralInfoMaint", paramCollection), paramCollection.ToArray()); var resultCode = paramCollection.Where(x => x.ParameterName == "@RETURN_VALUE").FirstOrDefault().Value; return(Convert.ToInt32(resultCode)); } }
public async Task <int> DeleteLocationAcceptance(string accountNo, string busnLocation, string cardNo, string userId) { using (var cardtrendentities = new pdb_ccmsContext(_connectionString)) { IssMessageDTO issMessage = new IssMessageDTO(); var parameters = new object[] { Common.Helpers.Common.GetIssueNo(), accountNo, cardNo, busnLocation, userId }; var paramNameList = new[] { "@IssNo", "@AcctNo", "@CardNo", "@BusnLocation", "@UserId" }; var paramCollection = BuildParameterListWithRrn(parameters, paramNameList); var result = await cardtrendentities.Database.ExecuteSqlCommandAsync(BuildSqlCommandWithRrn("WebLocationAcceptanceDelete", paramCollection), paramCollection.ToArray()); var resultCode = paramCollection.Where(x => x.ParameterName == "@RETURN_VALUE").FirstOrDefault().Value; return(Convert.ToInt32(resultCode)); } }
public async Task <int> WebRefMaint(string refType, string refCd, string refNo, string refId, string descp, string flag) { using (var cardtrendentities = new pdb_ccmsContext(_connectionString)) { IssMessageDTO issMessage = new IssMessageDTO(); var parameters = new object[] { Common.Helpers.Common.GetIssueNo(), refType, refCd, refNo, refId, descp, flag }; var paramNameList = new[] { "@IssNo", "@RefType", "@RefCd", "@RefNo", "@RefId", "@Descp", "@Flag" }; var paramCollection = BuildParameterListWithRrn(parameters, paramNameList); var result = await cardtrendentities.Database.ExecuteSqlCommandAsync (BuildSqlCommandWithRrn("WebRefMaint", paramCollection), paramCollection.ToArray()); var resultCode = paramCollection.Where(x => x.ParameterName == "@RETURN_VALUE").FirstOrDefault().Value; return(Convert.ToInt32(resultCode)); } }
public async Task <IssMessageDTO> SaveMerchManualTxnProduct(MerchManualTxnDTO manualSlipEntry) { using (var cardtrendentities = new pdb_ccmsContext(_connectionString)) { IssMessageDTO issMessage = new IssMessageDTO(); var parameters = new object[] { Common.Helpers.Common.GetIssueNo(), manualSlipEntry.SettleId, manualSlipEntry.TxnId, manualSlipEntry.TxnDetailId, manualSlipEntry.ProdCd, manualSlipEntry.Quantity, manualSlipEntry.ProdAmt, manualSlipEntry.Description, manualSlipEntry.UnitPrice, manualSlipEntry.UserId, manualSlipEntry.VATAmt, manualSlipEntry.VATCd }; var paramNameList = new[] { "@AcqNo", "@SettleId", "@TxnId", "@TxnDetailId", "@ProdCd", "@Qty", "@AmtPts", "@Descp", "@UnitPrice", "@UserId", "@VATAmt", "@VATCd" }; var outPutParameter = new object[] { new ColumnInfo { FieldName = "@oTxnDetailId", DataType = "varchar", ColLength = 19 } }; var paramCollection = BuildParameterListWithOutPutAndRrn(parameters, outPutParameter, paramNameList); var result = await cardtrendentities.Database.ExecuteSqlCommandAsync (BuildSqlCommandWithRrn("WebMerchManualTxnDetailMaint", paramCollection), paramCollection.ToArray()); var resultCode = paramCollection.Where(x => x.ParameterName == "@RETURN_VALUE").FirstOrDefault().Value; var oTxnDetailId = paramCollection.Where(x => x.ParameterName == "@oTxnDetailId").FirstOrDefault().Value; issMessage.Flag = Convert.ToInt32(resultCode); issMessage.paraOut.TxnDetailId = Convert.ToString(oTxnDetailId); return(issMessage); } }
public async Task <IssMessageDTO> SaveBusnLocationGeneralInfo(MerchGeneralInfoDTO merch) { using (var cardtrendentities = new pdb_ccmsContext(_connectionString)) { IssMessageDTO issMessage = new IssMessageDTO(); var parameters = new[] { new SqlParameter("@Func", SqlDbType.VarChar) { SqlValue = Common.Helpers.Common.GetIssueNo() }, new SqlParameter("@AcqNo", SqlDbType.SmallInt) { SqlValue = Common.Helpers.Common.GetIssueNo() }, new SqlParameter("@AcctNo", SqlDbType.VarChar) { SqlValue = (object)merch.AcctNo ?? DBNull.Value }, new SqlParameter("@BusnLocation", SqlDbType.VarChar) { SqlValue = (object)merch.BusnLocation ?? DBNull.Value }, new SqlParameter("@BusnName", SqlDbType.VarChar) { SqlValue = (object)merch.BusnName ?? DBNull.Value }, new SqlParameter("@SiteId", SqlDbType.VarChar) { SqlValue = (object)merch.ReconAcct ?? DBNull.Value }, new SqlParameter("@AgreeNo", SqlDbType.VarChar) { SqlValue = (object)merch.AgreementNo ?? DBNull.Value }, new SqlParameter("@AgreeDate", SqlDbType.VarChar) { SqlValue = (object)merch.AgreementDate ?? DBNull.Value }, new SqlParameter("@PersonInChrg", SqlDbType.VarChar) { SqlValue = (object)merch.PersonInCharge ?? DBNull.Value }, new SqlParameter("@Ownership", SqlDbType.VarChar) { SqlValue = (object)merch.Ownership ?? DBNull.Value }, new SqlParameter("@Establishment", SqlDbType.VarChar) { SqlValue = (object)merch.Establishment ?? DBNull.Value }, new SqlParameter("@Sic", SqlDbType.VarChar) { SqlValue = (object)merch.Sic ?? DBNull.Value }, new SqlParameter("@Mcc", SqlDbType.VarChar) { SqlValue = (object)merch.Mcc ?? DBNull.Value }, new SqlParameter("@CoRegNo", SqlDbType.VarChar) { SqlValue = (object)merch.CoRegNo ?? DBNull.Value }, new SqlParameter("@CoRegName", SqlDbType.VarChar) { SqlValue = (object)merch.CoRegName ?? DBNull.Value }, new SqlParameter("@CoRegDate", SqlDbType.SmallDateTime) { SqlValue = (object)merch.CoRegDate ?? DBNull.Value }, new SqlParameter("@OwnershipTrsfDate", SqlDbType.Date) { SqlValue = (object)merch.OwnershipTrsfDate ?? DBNull.Value }, new SqlParameter("@OwnershipTo", SqlDbType.VarChar) { SqlValue = (object)merch.OwnershipTo ?? DBNull.Value }, new SqlParameter("@DBAName", SqlDbType.VarChar) { SqlValue = (object)merch.DBAName ?? DBNull.Value }, new SqlParameter("@DBARegion", SqlDbType.VarChar) { SqlValue = (object)merch.DBARegion ?? DBNull.Value }, new SqlParameter("@DBACity", SqlDbType.VarChar) { SqlValue = (object)merch.DBACity ?? DBNull.Value }, new SqlParameter("@DBAState", SqlDbType.VarChar) { SqlValue = (object)merch.DBAState ?? DBNull.Value }, new SqlParameter("@PayeeName", SqlDbType.VarChar) { SqlValue = (object)merch.PayeeName ?? DBNull.Value }, new SqlParameter("@AutoDebit", SqlDbType.Char, 1) { SqlValue = (object)merch.AutoDebitInd ?? DBNull.Value }, new SqlParameter("@BankName", SqlDbType.VarChar) { SqlValue = (object)merch.BankName ?? DBNull.Value }, new SqlParameter("@BankAcctType", SqlDbType.VarChar) { SqlValue = (object)merch.BankAcctType ?? DBNull.Value }, new SqlParameter("@BankAcctNo", SqlDbType.VarChar) { SqlValue = (object)merch.BankAcctNo ?? DBNull.Value }, new SqlParameter("@BankBranchCd", SqlDbType.VarChar) { SqlValue = (object)merch.BankBranchCd ?? DBNull.Value }, new SqlParameter("@Sts", SqlDbType.VarChar) { SqlValue = (object)merch.Sts ?? DBNull.Value }, new SqlParameter("@EntityId", SqlDbType.VarChar) { SqlValue = (object)merch.EntityId ?? DBNull.Value }, new SqlParameter("@TaxId", SqlDbType.VarChar) { SqlValue = (object)merch.TaxId ?? DBNull.Value }, new SqlParameter("@WithholdInd", SqlDbType.Char, 1) { SqlValue = (object)merch.WithholdingTaxInd ?? DBNull.Value }, new SqlParameter("@WithholdRate", SqlDbType.Money) { SqlValue = (object)merch.WithholdingTaxRate ?? DBNull.Value }, new SqlParameter("@CycNo", SqlDbType.TinyInt) { SqlValue = (object)merch.CycNo ?? DBNull.Value }, new SqlParameter("@UserId", SqlDbType.VarChar) { SqlValue = (object)merch.UserId ?? DBNull.Value }, new SqlParameter("@CreationDate", SqlDbType.DateTime) { SqlValue = (object)merch.CreationDate ?? DBNull.Value }, new SqlParameter("@ReasonCd", SqlDbType.VarChar) { SqlValue = (object)merch.ReasonCd ?? DBNull.Value }, new SqlParameter("@StmtPrint", SqlDbType.Char, 1) { SqlValue = (object)merch.StmtPrint ?? DBNull.Value }, new SqlParameter("@TopUpLimit", SqlDbType.Money) { SqlValue = (object)merch.TopUpLimit ?? DBNull.Value }, new SqlParameter("@AreaCd", SqlDbType.VarChar, 10) { SqlValue = (object)merch.AreaCd ?? DBNull.Value }, new SqlParameter("@oBusnLocation", SqlDbType.VarChar, 15) { Direction = ParameterDirection.Output }, new SqlParameter("@oEntityId", SqlDbType.VarChar, 19) { Direction = ParameterDirection.Output }, new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt) { Direction = ParameterDirection.Output } }; await cardtrendentities.Database.ExecuteSqlCommandAsync(TransactionalBehavior.DoNotEnsureTransaction, "exec @RETURN_VALUE = WebBusnLocationGeneralInfoMaint @Func,@AcqNo,@AcctNo,@BusnLocation,@BusnName" + ",@SiteId,@AgreeNo,@AgreeDate,@PersonInChrg,@Ownership" + ",@Establishment,@Sic,@Mcc,@CoRegNo,@CoRegName" + ",@CoRegDate,@OwnershipTrsfDate,@OwnershipTo,@DBAName,@DBARegion" + ",@DBACity,@DBAState,@PayeeName,@AutoDebit,@BankName" + ",@BankAcctType,@BankAcctNo,@BankBranchCd,@Sts,@EntityId" + ",@TaxId,@WithholdInd,@WithholdRate,@CycNo,@UserId,@CreationDate,@ReasonCd,@StmtPrint,@TopUpLimit,@AreaCd,@oBusnLocation OUT" + ",@oEntityId OUT", parameters); var resultCode = parameters.Where(x => x.ParameterName == "@RETURN_VALUE").FirstOrDefault().Value; var busnLocation = parameters.Where(x => x.ParameterName == "@oBusnLocation").FirstOrDefault().Value; var entityId = parameters.Where(x => x.ParameterName == "@oEntityId").FirstOrDefault().Value; issMessage.Flag = Convert.ToInt32(resultCode); issMessage.paraOut.BusnLocation = Convert.ToString(busnLocation); issMessage.paraOut.EntityId = Convert.ToString(entityId); return(issMessage); } }
public async Task <IssMessageDTO> SaveApplicantInfo(CardAppcInfoDTO cardAppcInfoDto, string applId, string appcid, string userId) { using (var cardtrendentities = new pdb_ccmsContext(_connectionString)) { IssMessageDTO issMessage = new IssMessageDTO(); var parameters = new[] { new SqlParameter("@IssNo", SqlDbType.SmallInt) { SqlValue = Common.Helpers.Common.GetIssueNo() }, new SqlParameter("@AcctNo", SqlDbType.VarChar) { SqlValue = (object)cardAppcInfoDto.AcctNo ?? DBNull.Value }, new SqlParameter("@ApplId", SqlDbType.VarChar, 19) { SqlValue = (object)applId ?? DBNull.Value }, new SqlParameter("@AppcId", SqlDbType.VarChar) { SqlValue = (object)appcid ?? DBNull.Value }, new SqlParameter("@PINInd", SqlDbType.Char, 1) { SqlValue = (object)cardAppcInfoDto.PINInd ?? DBNull.Value }, new SqlParameter("@CardType", SqlDbType.VarChar) { SqlValue = (object)cardAppcInfoDto.CardType ?? DBNull.Value }, new SqlParameter("@CardNo", SqlDbType.VarChar) { SqlValue = (object)cardAppcInfoDto.CardNo ?? DBNull.Value }, new SqlParameter("@DriverName", SqlDbType.VarChar) { SqlValue = (object)cardAppcInfoDto.DriverName ?? DBNull.Value }, new SqlParameter("@EmbName", SqlDbType.VarChar) { SqlValue = (object)cardAppcInfoDto.EmbName ?? DBNull.Value }, new SqlParameter("@VehRegsNo", SqlDbType.NVarChar, 16) { SqlValue = (object)cardAppcInfoDto.VehRegsNo ?? DBNull.Value }, new SqlParameter("@SKDSInd", SqlDbType.Char, 1) { SqlValue = (object)cardAppcInfoDto.SKDSInd ?? DBNull.Value }, new SqlParameter("@SKDSQuota", SqlDbType.Money) { SqlValue = (object)cardAppcInfoDto.SKDSQuota ?? DBNull.Value }, new SqlParameter("@SKDSNo", SqlDbType.VarChar) { SqlValue = (object)cardAppcInfoDto.SKDSNo ?? DBNull.Value }, new SqlParameter("@DialogueInd", SqlDbType.VarChar) { SqlValue = (object)cardAppcInfoDto.DialogueInd ?? DBNull.Value }, new SqlParameter("@VehModel", SqlDbType.VarChar) { SqlValue = (object)cardAppcInfoDto.Model ?? DBNull.Value }, new SqlParameter("@OdometerInd", SqlDbType.Char, 1) { SqlValue = (object)cardAppcInfoDto.OdometerInd ?? DBNull.Value }, new SqlParameter("@PushAlertInd", SqlDbType.Char, 1) { SqlValue = (object)cardAppcInfoDto.PushAlertInd ?? DBNull.Value }, new SqlParameter("@EntityId", SqlDbType.VarChar) { SqlValue = (object)cardAppcInfoDto.EntityId ?? DBNull.Value }, new SqlParameter("@Sts", SqlDbType.VarChar) { SqlValue = (object)cardAppcInfoDto.Sts ?? "P" }, new SqlParameter("@oAppcId", SqlDbType.VarChar, 19) { Direction = ParameterDirection.Output }, new SqlParameter("@oEntityId", SqlDbType.VarChar, 19) { Direction = ParameterDirection.Output }, new SqlParameter("@UserId", SqlDbType.VarChar) { SqlValue = (object)userId ?? DBNull.Value }, new SqlParameter("@AnnlFee", SqlDbType.VarChar) { SqlValue = (object)cardAppcInfoDto.AnnlFeeCd ?? DBNull.Value }, new SqlParameter("@JoiningFee", SqlDbType.VarChar) { SqlValue = (object)cardAppcInfoDto.JoiningFeeCd ?? DBNull.Value }, new SqlParameter("@PriCardNo", SqlDbType.BigInt) { SqlValue = DBNull.Value }, new SqlParameter("@ProdGroup", SqlDbType.VarChar) { SqlValue = (object)cardAppcInfoDto.ProdGroup ?? DBNull.Value }, new SqlParameter("@PriAppcId", SqlDbType.Int) { SqlValue = (object)cardAppcInfoDto.PriAppcId ?? DBNull.Value }, new SqlParameter("@CostCentre", SqlDbType.NVarChar) { SqlValue = (object)cardAppcInfoDto.CostCentre ?? DBNull.Value }, new SqlParameter("@BranchCd", SqlDbType.NVarChar) { SqlValue = (object)cardAppcInfoDto.BranchCd ?? DBNull.Value }, new SqlParameter("@DivisionCd", SqlDbType.NVarChar) { SqlValue = (object)cardAppcInfoDto.DivisionCd ?? DBNull.Value }, new SqlParameter("@DeptCd", SqlDbType.NVarChar) { SqlValue = (object)cardAppcInfoDto.DeptCd ?? DBNull.Value }, new SqlParameter("@CardMedia", SqlDbType.Int) { SqlValue = (object)cardAppcInfoDto.CardMedia ?? DBNull.Value }, new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt) { Direction = ParameterDirection.Output } }; await cardtrendentities.Database.ExecuteSqlCommandAsync("exec @RETURN_VALUE = WebAppcGeneralInfoMaint @IssNo,@AcctNo,@ApplId,@AppcId,@PINInd," + "@CardType,@CardNo,@DriverName,@EmbName,@VehRegsNo,@SKDSInd,@SKDSQuota,@SKDSNo,@DialogueInd,@VehModel,@OdometerInd," + "@PushAlertInd,@EntityId,@Sts,@oAppcId OUT,@oEntityId OUT,@UserId,@AnnlFee,@JoiningFee,@PriCardNo,@ProdGroup,@PriAppcId," + "@CostCentre,@BranchCd,@DivisionCd,@DeptCd,@CardMedia", parameters); var resultCode = parameters.Where(x => x.ParameterName == "@RETURN_VALUE").FirstOrDefault().Value; var appcId = parameters.Where(x => x.ParameterName == "@oAppcId").FirstOrDefault().Value; var oEntityId = parameters.Where(x => x.ParameterName == "@oEntityId").FirstOrDefault().Value; issMessage.Flag = Convert.ToInt32(resultCode); issMessage.paraOut.AppcId = Convert.ToString(appcId); issMessage.paraOut.EntityId = Convert.ToString(oEntityId); return(issMessage); } }
public async Task <IssMessageDTO> SaveFraud(FraudCustomerDetailsDTO fraudCustomerDetail, FraudCardDetailDTO fraudCardDetail, WebFraudDetailDTO webFraudDetail, string userId) { using (var cardtrendentities = new pdb_ccmsContext(_connectionString)) { IssMessageDTO issMessage = new IssMessageDTO(); string accountNo = null; if (fraudCardDetail.FraudCards.Count() > 0) { accountNo = fraudCardDetail.FraudCards[0].AcctNo; } DataTable dtCardNo = null; if (fraudCardDetail.FraudCards != null && fraudCardDetail.FraudCards.Count() > 0) { dtCardNo = new DataTable(); dtCardNo.Columns.Add("CardNo"); foreach (var itm in fraudCardDetail.FraudCards) { if (!String.IsNullOrEmpty(itm.SelectedCardNo)) { DataRow dr = dtCardNo.NewRow(); dr["CardNo"] = itm.SelectedCardNo; dtCardNo.Rows.Add(dr); } } } var parameters = new[] { new SqlParameter("@IssNo", SqlDbType.SmallInt) { SqlValue = Common.Helpers.Common.GetIssueNo() }, new SqlParameter("@EventID", SqlDbType.BigInt) { SqlValue = (object)fraudCustomerDetail.EventID ?? DBNull.Value }, new SqlParameter("@AcctNo", SqlDbType.BigInt) { SqlValue = (object)accountNo ?? DBNull.Value }, new SqlParameter("@CardNo", SqlDbType.Structured) { SqlValue = dtCardNo, TypeName = "FraudCardNumbers" }, new SqlParameter("@ReportedBy", SqlDbType.NVarChar) { SqlValue = (object)webFraudDetail.ReportedBy ?? DBNull.Value }, new SqlParameter("@ReportedVia", SqlDbType.NVarChar) { SqlValue = (object)webFraudDetail.ReportVia ?? DBNull.Value }, new SqlParameter("@IncidentDate", SqlDbType.DateTime) { SqlValue = (object)webFraudDetail.IncidentDate ?? DBNull.Value }, new SqlParameter("@EstimatedAmountDispute", SqlDbType.Money) { SqlValue = (object)webFraudDetail.DisputeAmt ?? DBNull.Value }, new SqlParameter("@NatureOfIncident", SqlDbType.VarChar) { SqlValue = (object)webFraudDetail.NatureOfIncident ?? DBNull.Value }, new SqlParameter("@IfOthers", SqlDbType.NVarChar) { SqlValue = (object)webFraudDetail.OtherNatureOfIncident ?? DBNull.Value }, new SqlParameter("@Description", SqlDbType.NVarChar) { SqlValue = (object)webFraudDetail.Descp ?? DBNull.Value }, new SqlParameter("@InvestigatedBy", SqlDbType.NVarChar) { SqlValue = (object)webFraudDetail.InvestigatedBy ?? DBNull.Value }, new SqlParameter("@InvestigateDate", SqlDbType.DateTime) { SqlValue = (object)webFraudDetail.InvestigationDate ?? DBNull.Value }, new SqlParameter("@InvestigateVenue", SqlDbType.NVarChar) { SqlValue = (object)webFraudDetail.InvestigationVenue ?? DBNull.Value }, new SqlParameter("@CaseBackground", SqlDbType.NVarChar) { SqlValue = (object)webFraudDetail.CaseBackGround ?? DBNull.Value }, new SqlParameter("@InvestigationProcess", SqlDbType.NVarChar) { SqlValue = (object)webFraudDetail.InvestigationProcess ?? DBNull.Value }, new SqlParameter("@Finding", SqlDbType.NVarChar) { SqlValue = (object)webFraudDetail.Findings ?? DBNull.Value }, new SqlParameter("@ActionTaken", SqlDbType.NVarChar) { SqlValue = (object)webFraudDetail.ActionTaken ?? DBNull.Value }, new SqlParameter("@RecommendationPlan", SqlDbType.NVarChar) { SqlValue = (object)webFraudDetail.Recommendation ?? DBNull.Value }, new SqlParameter("@Conclusion", SqlDbType.NVarChar) { SqlValue = (object)webFraudDetail.Conclusion ?? DBNull.Value }, new SqlParameter("@Status", SqlDbType.NVarChar) { SqlValue = (object)webFraudDetail.Sts ?? DBNull.Value }, new SqlParameter("@PreparedByName1", SqlDbType.NVarChar) { SqlValue = (object)webFraudDetail.PreparedByName1 ?? DBNull.Value }, new SqlParameter("@PreparedByPosition1", SqlDbType.NVarChar) { SqlValue = (object)webFraudDetail.PreparedByPosition1 ?? DBNull.Value }, new SqlParameter("@PreparedByName2", SqlDbType.NVarChar) { SqlValue = (object)webFraudDetail.PreparedByName2 ?? DBNull.Value }, new SqlParameter("@PreparedByPosition2", SqlDbType.NVarChar) { SqlValue = (object)webFraudDetail.PreparedByPosition2 ?? DBNull.Value }, new SqlParameter("@ReviewerName1", SqlDbType.NVarChar) { SqlValue = (object)webFraudDetail.ReviewerName1 ?? DBNull.Value }, new SqlParameter("@ReviewerPosition1", SqlDbType.NVarChar) { SqlValue = (object)webFraudDetail.ReviewerPosition1 ?? DBNull.Value }, new SqlParameter("@ReviewerName2", SqlDbType.NVarChar) { SqlValue = (object)webFraudDetail.ReviewerName2 ?? DBNull.Value }, new SqlParameter("@ReviewerPosition2", SqlDbType.NVarChar) { SqlValue = (object)webFraudDetail.ReviewerPosition2 ?? DBNull.Value }, new SqlParameter("@EndorsedByName1", SqlDbType.NVarChar) { SqlValue = (object)webFraudDetail.EndorsedByName1 ?? DBNull.Value }, new SqlParameter("@EndorsedByPosition1", SqlDbType.NVarChar) { SqlValue = (object)webFraudDetail.EndorsedByPosition1 ?? DBNull.Value }, new SqlParameter("@EndorsedByName2", SqlDbType.NVarChar) { SqlValue = (object)webFraudDetail.EndorsedByName2 ?? DBNull.Value }, new SqlParameter("@EndorsedByPosition2", SqlDbType.NVarChar) { SqlValue = (object)webFraudDetail.EndorsedByPosition2 ?? DBNull.Value }, new SqlParameter("@ApprovedByName1", SqlDbType.NVarChar) { SqlValue = (object)webFraudDetail.ApprovedByName1 ?? DBNull.Value }, new SqlParameter("@ApprovedByPosition1", SqlDbType.NVarChar) { SqlValue = (object)webFraudDetail.ApprovedByPosition1 ?? DBNull.Value }, new SqlParameter("@ApprovedByName2", SqlDbType.NVarChar) { SqlValue = (object)webFraudDetail.ApprovedByName2 ?? DBNull.Value }, new SqlParameter("@ApprovedByPosition2", SqlDbType.NVarChar) { SqlValue = (object)webFraudDetail.ApprovedByPosition2 ?? DBNull.Value }, new SqlParameter("@Remarks", SqlDbType.NVarChar) { SqlValue = (object)webFraudDetail.Remarks ?? DBNull.Value }, new SqlParameter("@UserID", SqlDbType.NVarChar) { SqlValue = userId }, new SqlParameter("@OutputID", SqlDbType.BigInt) { Direction = ParameterDirection.Output }, new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt) { Direction = ParameterDirection.Output } }; await cardtrendentities.Database.ExecuteSqlCommandAsync("exec @RETURN_VALUE = WebFraudIncidentReportMaint @IssNo,@EventID,@AcctNo,@CardNo,@ReportedBy," + "@ReportedVia,@IncidentDate,@EstimatedAmountDispute,@NatureOfIncident,@IfOthers,@Description," + "@InvestigatedBy,@InvestigateDate,@InvestigateVenue,@CaseBackground,@InvestigationProcess,@Finding," + "@ActionTaken,@RecommendationPlan,@Conclusion,@Status,@PreparedByName1,@PreparedByPosition1,@PreparedByName2," + "@PreparedByPosition2,@ReviewerName1,@ReviewerPosition1,@ReviewerName2,@ReviewerPosition2,@EndorsedByName1," + "@EndorsedByPosition1,@EndorsedByName2,@EndorsedByPosition2,@ApprovedByName1,@ApprovedByPosition1,@ApprovedByName2,@ApprovedByPosition2,@Remarks,@UserID,@OutputID OUT", parameters); var resultCode = parameters.Where(x => x.ParameterName == "@RETURN_VALUE").FirstOrDefault().Value; var eventId = parameters.Where(x => x.ParameterName == "@OutputID").FirstOrDefault().Value; return(new IssMessageDTO() { Flag = Convert.ToInt32(resultCode), paraOut = { BatchId = Convert.ToString(eventId) } }); } }
public async Task <IssMessageDTO> SaveMerchantMultiTxnAdjustmentMaint(TxnAdjustmentDTO adjustmentDetail, string userId) { using (var cardtrendentities = new pdb_ccmsContext(_connectionString)) { IssMessageDTO issMessage = new IssMessageDTO(); 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 adjustmentDetail.multipleTxnRecord) { DataRow dr = dt.NewRow(); dr["DeftBusnlocation"] = item.MerchantAcctNo; dr["TxnAmt"] = (object)NumberExtensions.ConvertDecimalToDb(item.TxnAmt) ?? DBNull.Value; dr["Descp"] = (object)item.Descp ?? DBNull.Value; dr["TxnCd"] = adjustmentDetail.TxnCd; dr["TxnDate"] = adjustmentDetail.TxnDate.ToShortDateString(); dr["DueDate"] = adjustmentDetail.DueDate == DateTime.MinValue ? DBNull.Value : NumberExtensions.ConvertDatetimeDB(adjustmentDetail.DueDate.ToShortDateString()); dr["Owner"] = adjustmentDetail.Owner; dr["InvoiceNo"] = (object)adjustmentDetail.InvoiceNo ?? DBNull.Value; dr["TxnId"] = (object)adjustmentDetail.TxnId ?? DBNull.Value; dt.Rows.Add(dr); } var parameters = new[] { new SqlParameter("@IssNo", SqlDbType.SmallInt) { SqlValue = Common.Helpers.Common.GetIssueNo() }, new SqlParameter("@CheqAmt", SqlDbType.Money) { SqlValue = NumberExtensions.ConvertDecimalToDb(adjustmentDetail.ChequeAmt) }, new SqlParameter("@UserId", SqlDbType.VarChar) { SqlValue = (object)userId ?? DBNull.Value }, new SqlParameter("@Adjustment", SqlDbType.Structured) { SqlValue = dt, TypeName = "Adjustment" }, new SqlParameter("@RetCd", SqlDbType.Int) { Direction = ParameterDirection.Output }, new SqlParameter("@RcptNo", SqlDbType.VarChar) { SqlValue = (object)adjustmentDetail.InvoiceNo ?? DBNull.Value }, new SqlParameter("@BatchId", SqlDbType.Int) { SqlValue = (object)adjustmentDetail.BatchId ?? DBNull.Value }, new SqlParameter("@BatchOut", SqlDbType.VarChar, 25) { Direction = ParameterDirection.Output }, new SqlParameter("@Owner", SqlDbType.VarChar) { SqlValue = (object)adjustmentDetail.Owner ?? DBNull.Value }, new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt) { Direction = ParameterDirection.Output } }; await cardtrendentities.Database.ExecuteSqlCommandAsync("exec @RETURN_VALUE = WebMerchantMultiTxnAdjustmentMaint @IssNo,@CheqAmt,@UserId,@Adjustment,@RetCd OUT," + "@RcptNo,@BatchId,@BatchOut OUT,@Owner", parameters); var resultCode = parameters.Where(x => x.ParameterName == "@RETURN_VALUE").FirstOrDefault().Value; ResourceManager myManager = new ResourceManager(typeof(CardTrend.Common.Resources.IssMessages)); issMessage.paraOut.BatchId = parameters.Where(x => x.ParameterName == "@BatchOut").FirstOrDefault().Value.ToString(); issMessage.paraOut.RetCd = parameters.Where(x => x.ParameterName == "@RetCd").FirstOrDefault().Value.ToString(); issMessage.Descp = myManager.GetString("Msg" + resultCode); issMessage.Flag = Convert.ToInt32(resultCode); return(issMessage); } }
public async Task <IssMessageDTO> SaveWebNtfyEvtConfMaint(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 = 0 }, 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)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 = WebNtfyEvtConfMaint @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); } }
public async Task <IssMessageDTO> WebMultiPaymentMaint(TxnAdjustmentDTO txtAdjustment) { using (var cardtrendentities = new pdb_ccmsContext(_connectionString)) { IssMessageDTO issMessage = new IssMessageDTO(); DataTable dt = new DataTable(); dt.Columns.Add("TxnId"); dt.Columns.Add("AcctNo", typeof(long)); dt.Columns.Add("PymtAmt", typeof(decimal)); dt.Columns.Add("Descp"); foreach (var item in txtAdjustment.multipleTxnRecord) { DataRow dr = dt.NewRow(); dr["AcctNo"] = item.AcctNo; if (!string.IsNullOrEmpty(item.TxnAmt)) { dr["PymtAmt"] = CardTrend.Common.Extensions.NumberExtensions.ConvertDecimalToDb(item.TxnAmt); } else { dr["PymtAmt"] = DBNull.Value; } dr["Descp"] = item.TxnDescp; dr["TxnId"] = item.TxnId; dt.Rows.Add(dr); } var parameters = new[] { new SqlParameter("@IssNo", SqlDbType.SmallInt) { SqlValue = Common.Helpers.Common.GetIssueNo() }, new SqlParameter("@BatchId", SqlDbType.Int) { SqlValue = txtAdjustment.BatchId }, new SqlParameter("@RefKey", SqlDbType.BigInt) { SqlValue = (object)txtAdjustment.RefId ?? DBNull.Value }, new SqlParameter("@ChequeNo", SqlDbType.BigInt) { SqlValue = (object)(Convert.ToUInt64(txtAdjustment.ChequeNo)) ?? DBNull.Value }, new SqlParameter("@TxnCd", SqlDbType.VarChar) { SqlValue = (object)Convert.ToString(txtAdjustment.TxnCd) ?? DBNull.Value }, new SqlParameter("@TxnDate", SqlDbType.Date) { SqlValue = (object)txtAdjustment.TxnDate ?? DBNull.Value }, new SqlParameter("@DueDate", SqlDbType.Date) { SqlValue = (object)txtAdjustment.DueDate ?? DBNull.Value }, new SqlParameter("@TtlPymt", SqlDbType.Money) { SqlValue = (object)Convert.ToDecimal(txtAdjustment.ChequeAmt) ?? DBNull.Value }, new SqlParameter("@SlipNo", SqlDbType.VarChar) { SqlValue = (object)txtAdjustment.SlipNo ?? DBNull.Value }, new SqlParameter("@IssueingBankCd", SqlDbType.VarChar) { SqlValue = (object)txtAdjustment.IssueingBank ?? DBNull.Value }, new SqlParameter("@Payment", SqlDbType.Structured) { SqlValue = dt, TypeName = "Payment" }, new SqlParameter("@Owner", SqlDbType.VarChar) { SqlValue = (object)txtAdjustment.Owner ?? DBNull.Value }, new SqlParameter("@UserId", SqlDbType.VarChar) { SqlValue = (object)txtAdjustment.UserId ?? DBNull.Value }, new SqlParameter("@SettleVal", SqlDbType.VarChar) { SqlValue = (object)txtAdjustment.SelectedGLSettlement ?? DBNull.Value }, new SqlParameter("@Batch", SqlDbType.VarChar, 20) { Direction = ParameterDirection.Output }, new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt) { Direction = ParameterDirection.Output } }; await cardtrendentities.Database.ExecuteSqlCommandAsync("exec @RETURN_VALUE = WebMultiPaymentMaint @IssNo,@BatchId,@RefKey,@ChequeNo,@TxnCd," + "@TxnDate,@DueDate,@TtlPymt,@SlipNo,@IssueingBankCd,@Payment,@Owner,@UserId,@SettleVal,@Batch OUT", parameters); var resultCode = parameters.Where(x => x.ParameterName == "@RETURN_VALUE").FirstOrDefault().Value; var batchId = parameters.Where(x => x.ParameterName == "@Batch").FirstOrDefault().Value; ResourceManager myManager = new ResourceManager(typeof(CardTrend.Common.Resources.IssMessages)); issMessage.Descp = myManager.GetString("Msg" + resultCode); issMessage.Flag = Convert.ToInt32(resultCode); issMessage.paraOut.BatchId = Convert.ToString(batchId); return(issMessage); } }