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