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