public async Task <DelinquentAcctsTresholdLimit> GetThresholdLmtCollection(int offSet, Int64 noOfRecs, Int64 tOtalNoOfRecs, string sSearch) { using (var cardtrendentities = new pdb_ccmsContext(_connectionString)) { DelinquentAcctsTresholdLimit delinquentAcctsTresholdLimit = new DelinquentAcctsTresholdLimit(); var parameters = new object[] { Common.Helpers.Common.GetIssueNo(), offSet, noOfRecs, sSearch }; var paramNameList = new[] { "@IssNo", "@OffSet", "@RecordsCnt", "@SearchText" }; var outPutParameter = new object[] { new ColumnInfo { FieldName = "@TotalRecs", DataType = "int" } }; var paramCollection = BuildParameterListWithOutPutAndRrn(parameters, outPutParameter, paramNameList); var transactionResults = await cardtrendentities.Database.SqlQuery <DelinquentAcctsTresholdLimitDTO>(BuildSqlCommand("WebDelinquentAcctsTresholdLimit", paramCollection), paramCollection.ToArray()).ToListAsync(); var resultCode = paramCollection.Where(x => x.ParameterName == "@TotalRecs").FirstOrDefault().Value; delinquentAcctsTresholdLimit.delinquentAcctsTresholdLimits = transactionResults; delinquentAcctsTresholdLimit.tOtalNoOfRecs = Convert.ToInt64(resultCode); return(delinquentAcctsTresholdLimit); } }
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> 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> SaveUserAccess(UserAccessDTO userAccess, bool isUpdate = false) { using (var cardtrendentities = new pdb_ccmsContext(_connectionString)) { var parameters = new object[] { Common.Helpers.Common.GetIssueNo(), userAccess.AccessInd, userAccess.Sts, userAccess.UserId, userAccess.Name, userAccess.ContactNo, userAccess.EmailAddr, userAccess.Title, userAccess.DeptId, userAccess.PrivilegeCd, userAccess.CreateBy, userAccess.Password, userAccess.ChangePassInd, isUpdate ? "U" : "N" }; var paramNameList = new[] { "@IssNo", "@AccessInd", "@Sts", "@UserId", "@Name", "@ContactNo", "@EmailAddr", "@Title", "@DeptId", "@PrivilegeCd", "@CreatedBy", "@Pw", "@ChangePassInd", "@Flag" }; var paramCollection = BuildParameterListWithRrn(parameters, paramNameList); var result = await cardtrendentities.Database.ExecuteSqlCommandAsync(BuildSqlCommandWithRrn("WebUserAccessMaint", paramCollection), paramCollection.ToArray()); var resultCode = paramCollection.Where(x => x.ParameterName == "@RETURN_VALUE").FirstOrDefault().Value; return(Convert.ToInt32(resultCode)); } }
public async Task <int> StatusSave(ChangeStatusDTO changeStatusDto, string userId) { using (var cardtrendentities = new pdb_ccmsContext(_connectionString)) { var parameters = new object[] { Common.Helpers.Common.GetIssueNo(), changeStatusDto.AcctNo, changeStatusDto.CardNo, changeStatusDto.MerchAcctNo, changeStatusDto.BusnLocation, changeStatusDto.AppcId, changeStatusDto.EventType, changeStatusDto.Sts, changeStatusDto.ReasonCd, changeStatusDto.Remarks, userId }; var paramNameList = new[] { "@IssNo", "@AcctNo", "@CardNo", "@MerchAcctNo", "@BusnLocation", "@AppcId", "@EventType", "@Sts", "@ReasonCd", "@Descp", "@UserId" }; var paramCollection = BuildParameterListWithRrn(parameters, paramNameList); var result = await cardtrendentities.Database.ExecuteSqlCommandAsync(BuildSqlCommandWithRrn("WebChangeStatusMaint", paramCollection), paramCollection.ToArray()); var resultCode = paramCollection.Where(x => x.ParameterName == "@RETURN_VALUE").FirstOrDefault().Value; return(Convert.ToInt32(resultCode)); } }
public async Task <int> SaveBusnLocTerm(BusnLocTerminalDTO busnLocTerminal) { using (var cardtrendentities = new pdb_ccmsContext(_connectionString)) { var parameters = new object[] { Common.Helpers.Common.GetIssueNo(), busnLocTerminal.BusnLocation, busnLocTerminal.TermId, busnLocTerminal.TermType, busnLocTerminal.Status, busnLocTerminal.DeployDate, busnLocTerminal.SaleTerritory, busnLocTerminal.ReplacedByTermId, busnLocTerminal.ReplacedDate, busnLocTerminal.ReasonCd, busnLocTerminal.IPEK, busnLocTerminal.DeviceModel, busnLocTerminal.SerialNo, busnLocTerminal.Remarks, busnLocTerminal.UserId }; var paramNameList = new[] { "@AcqNo", "@BusnLocation", "@TermId", "@TermType", "@Sts", "@DeployDate", "@SaleTerritory", "@ReplacedByTermId", "@ReplacedDate", "@ReasonCd", "@IPEK", "@DeviceModel", "@SerialNo", "@Remarks", "@UserId" }; var paramCollection = BuildParameterListWithRrn(parameters, paramNameList); var result = await cardtrendentities.Database.ExecuteSqlCommandAsync(BuildSqlCommandWithRrn("WebBusnLocationTerminalMaint", paramCollection), paramCollection.ToArray()); var resultCode = paramCollection.Where(x => x.ParameterName == "@RETURN_VALUE").FirstOrDefault().Value; return(Convert.ToInt32(resultCode)); } }
public async Task <IList <SelectListItem> > GetUserAccessListSelect(string AccessInd = "I") { using (var cardtrendentities = new pdb_ccmsContext(_connectionString)) { var parameters = new object[] { Common.Helpers.Common.GetIssueNo(), AccessInd }; var paramNameList = new[] { "@IssNo", "@AccessInd" }; var paramCollection = BuildParameterList(parameters, paramNameList); var results = await cardtrendentities.Database.SqlQuery <UserAccessListDTO> (BuildSqlCommand("WebUserAccessListSelect", paramCollection), paramCollection.ToArray()) .ToListAsync(); var list = new List <SelectListItem>(); if (results.Count() > 0) { foreach (var refLib in results) { list.Add(new SelectListItem { Text = refLib.UserId, Value = refLib.UserId }); } } return(list); } }
public async Task <List <MerchProductPrizeDTO> > WebMerchProductPriceSearch(string busnLocation, string ProdCd, DateTime?EffDateFrom, DateTime?EffDateTo, bool isListSelect) { using (var cardtrendentities = new pdb_ccmsContext(_connectionString)) { var parameters = new object[] {}; string[] paramNameList; if (isListSelect) { parameters = new object[] { Common.Helpers.Common.GetIssueNo(), busnLocation }; paramNameList = new[] { "@AcqNo", "@BusnLocation" }; } else { parameters = new object[] { Common.Helpers.Common.GetIssueNo(), busnLocation, ProdCd, EffDateFrom, EffDateTo }; paramNameList = new[] { "@AcqNo", "@BusnLocation", "@ProdCd", "@EffDateFrom", "@EffDateTo" }; } var paramCollection = BuildParameterList(parameters, paramNameList); var result = await cardtrendentities.Database.SqlQuery <MerchProductPrizeDTO> (BuildSqlCommand(isListSelect ? "WebMerchProductPriceListSelect" : "WebMerchProductPriceSearch", paramCollection), paramCollection.ToArray()).ToListAsync(); return(result); } }
public async Task <int> SaveEventMaint(EventLoggerDTO _Logger, string module) { using (var cardtrendentities = new pdb_ccmsContext(_connectionString)) { var parameters = new object[] { module, _Logger.EventId, _Logger.EventType, _Logger.AcctNo, _Logger.ReferenceKey, _Logger.Descp, _Logger.ReasonCd , _Logger.Reminder, _Logger.RefDocument, _Logger.ClosedDate, _Logger.Status, _Logger.UserId }; var paramNameList = new[] { "@Module", "@EventId", "@EventType", "@AcctNo", "@RefKey", "@Descp", "@ReasonCd", "@ReminderDate", "@XrefDoc", "@ClsDate", "@Sts", "@UserId" }; var paramCollection = BuildParameterListWithRrn(parameters, paramNameList); var result = await cardtrendentities.Database.ExecuteSqlCommandAsync(BuildSqlCommandWithRrn("WebEventMaint", paramCollection), paramCollection.ToArray()); var resultCode = paramCollection.Where(x => x.ParameterName == "@RETURN_VALUE").FirstOrDefault().Value; return(Convert.ToInt32(resultCode)); } }
public async Task <CollPaymentHstList> GetCollPaymentHist(string acctNo, int offSet, Int64 NoOfRecs) { using (var cardtrendentities = new pdb_ccmsContext(_connectionString)) { CollPaymentHstList collPaymentHstList = new CollPaymentHstList(); var parameters = new object[] { Common.Helpers.Common.GetIssueNo(), acctNo, offSet, NoOfRecs }; var paramNameList = new[] { "@IssNo", "@AcctNo", "@OffSet", "@NoOfRecs" }; var outPutParameter = new object[] { new ColumnInfo { FieldName = "@TotalNoOfRecs", DataType = "bigint" } }; var paramCollection = BuildParameterListWithOutPut(parameters, outPutParameter, paramNameList); var resultLst = cardtrendentities.Database.SqlQuery <CollPaymentHistDTO>(BuildSqlCommand("WebDelinquentAcctPymtHistory", paramCollection), paramCollection.ToArray()); //var resultLst = await cardtrendentities.Database.SqlQuery<CollPaymentHistDT>(BuildSqlCommand("WebDelinquentAcctPymtHistory", paramCollection), paramCollection.ToArray()).ToListAsync(); var collPaymentHsts = await resultLst.ToListAsync(); var totalNoOfRecs = paramCollection.Where(x => x.ParameterName == "@TotalNoOfRecs").FirstOrDefault().Value; collPaymentHstList.CollPaymentHsts = collPaymentHsts; collPaymentHstList.TotalNoOfRecs = Convert.ToInt64(totalNoOfRecs); return(collPaymentHstList); } }
public async Task <IEnumerable <SelectListItem> > WebGetPymtTxnCd(string GlSettlementCd, string TxnCat) { using (var cardtrendentities = new pdb_ccmsContext(_connectionString)) { var parameters = new object[] { Common.Helpers.Common.GetIssueNo(), TxnCat, GlSettlementCd }; var paramNameList = new[] { "@IssNo", "@TxnCat", "@settleval" }; var paramCollection = BuildParameterList(parameters, paramNameList); var results = await cardtrendentities.Database.SqlQuery <TxnCodeDTO> (BuildSqlCommand("WebGetPymtTxnCd", paramCollection), paramCollection.ToArray()) .ToListAsync(); var list = new List <SelectListItem>(); if (results.Count() > 0) { foreach (var refLib in results) { list.Add(new SelectListItem { Text = refLib.Descp, Value = refLib.TxnCd.ToString() }); } } return(list); } }
public async Task <int> SaveCorporateAcct(CorporateDTO corporate, string func) { using (var cardtrendentities = new pdb_ccmsContext(_connectionString)) { var parameters = new[] { new SqlParameter("@IssNo", SqlDbType.SmallInt) { SqlValue = Common.Helpers.Common.GetIssueNo() }, new SqlParameter("@CorpCd", SqlDbType.VarChar) { SqlValue = (object)corporate.CorporateCode ?? DBNull.Value }, new SqlParameter("@CorpName", SqlDbType.NVarChar) { SqlValue = (object)corporate.CorporateName ?? DBNull.Value }, new SqlParameter("@TradeLimit", SqlDbType.Decimal) { SqlValue = corporate.TradeLimit }, new SqlParameter("@ComplexInd", SqlDbType.VarChar) { SqlValue = (object)corporate.ComplexAcctInd ?? DBNull.Value }, new SqlParameter("@InvBillInd", SqlDbType.VarChar) { SqlValue = (object)corporate.InvoiceCenter ?? DBNull.Value }, new SqlParameter("@PymtInd", SqlDbType.VarChar) { SqlValue = (object)corporate.PaymentCenter ?? DBNull.Value }, new SqlParameter("@PersonInCharge", SqlDbType.VarChar) { SqlValue = (object)corporate.PersonInCharge ?? DBNull.Value }, new SqlParameter("@UserFlag", SqlDbType.VarChar) { SqlValue = func }, new SqlParameter("@UserId", SqlDbType.VarChar) { SqlValue = (object)corporate.UserId ?? DBNull.Value }, new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt) { Direction = ParameterDirection.Output } }; await cardtrendentities.Database.ExecuteSqlCommandAsync("exec @RETURN_VALUE = WebCorpAcctMaint @IssNo,@CorpCd,@CorpName,@TradeLimit,@ComplexInd," + "@InvBillInd,@PymtInd,@PersonInCharge,@UserId,@UserFlag", parameters); var resultCode = parameters.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 <IList <GetUserTitleDto> > GetUserTitles() { using (var cardtrendentities = new pdb_ccmsContext(_connectionString)) { var results = await cardtrendentities.Database.SqlQuery <GetUserTitleDto>("SPOGetUserTitle").ToListAsync(); return(results); } }
public async Task <List <EventTypeDTO> > WebEventTypeListSelect() { using (var cardtrendentities = new pdb_ccmsContext(_connectionString)) { var results = await cardtrendentities.Database.SqlQuery <EventTypeDTO>("WebEventTypeListSelect").ToListAsync(); return(results); } }
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 ManualTxnDTO GetManualTxn(string settleId) { using (var cardtrendentities = new pdb_ccmsContext(_connectionString)) { var parameters = new object[] { Common.Helpers.Common.GetIssueNo(), settleId }; var paramNameList = new[] { "@AcqNo", "@SettleId" }; var paramCollection = BuildParameterList(parameters, paramNameList); var result = cardtrendentities.Database.SqlQuery <ManualTxnDTO>(BuildSqlCommand("WebGetManualTxn", paramCollection), paramCollection.ToArray()).FirstOrDefault(); return(result); } }
public async Task <int> DeleteMerchManualTransaction(string batchId, string settleId, string txnId, string detailTxnId) { using (var cardtrendentities = new pdb_ccmsContext(_connectionString)) { var parameters = new object[] { Common.Helpers.Common.GetIssueNo(), batchId, settleId, txnId, detailTxnId }; var paramNameList = new[] { "@AcqNo", "@BatchId", "@SettleId", "@TxnId", "@DetailTxnId" }; var paramCollection = BuildParameterListWithRrn(parameters, paramNameList); var result = await cardtrendentities.Database.ExecuteSqlCommandAsync(BuildSqlCommandWithRrn("WebMerchManualTxnDelete", paramCollection), paramCollection.ToArray()); var resultCode = paramCollection.Where(x => x.ParameterName == "@RETURN_VALUE").FirstOrDefault().Value; return(Convert.ToInt32(resultCode));; } }
public async Task <List <EventTypeDTO> > WebEventTypeSelect(string eventTypeId) { using (var cardtrendentities = new pdb_ccmsContext(_connectionString)) { var parameters = new object[] { eventTypeId }; var paramNameList = new[] { "@EventTypeId" }; var paramCollection = BuildParameterList(parameters, paramNameList); var results = await cardtrendentities.Database.SqlQuery <EventTypeDTO> (BuildSqlCommand("WebEventTypeSelect", paramCollection), paramCollection.ToArray()).ToListAsync(); return(results); } }
public async Task <List <CollectionFollowUpDTO> > GetCollFollowUp(string eventId) { using (var cardtrendentities = new pdb_ccmsContext(_connectionString)) { var parameters = new object[] { Common.Helpers.Common.GetIssueNo(), eventId }; var paramNameList = new[] { "@IssNo", "@EventId" }; var paramCollection = BuildParameterList(parameters, paramNameList); var result = await cardtrendentities.Database.SqlQuery <CollectionFollowUpDTO>(BuildSqlCommand("WebDelinquentAcctCollFollowupList", paramCollection), paramCollection.ToArray()).ToListAsync(); return(result); } }
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 <List <CollAgeingHistDTO> > GetCollAgeingHistory(string AcctNo) { using (var cardtrendentities = new pdb_ccmsContext(_connectionString)) { var parameters = new object[] { AcctNo, DBNull.Value }; var paramNameList = new[] { "@RefKey", "@RptDate" }; var paramCollection = BuildParameterList(parameters, paramNameList); var result = await cardtrendentities.Database.SqlQuery <CollAgeingHistDTO>(BuildSqlCommand("RptAcctAgeing", paramCollection), paramCollection.ToArray()).ToListAsync(); return(result); } }
public async Task <DelinquentAcctFinancialInfoDTO> GetCollFinancialInfo(string AcctNo) { using (var cardtrendentities = new pdb_ccmsContext(_connectionString)) { var parameters = new object[] { Common.Helpers.Common.GetIssueNo(), AcctNo }; var paramNameList = new[] { "@IssNo", "@AcctNo" }; var paramCollection = BuildParameterList(parameters, paramNameList); var result = await cardtrendentities.Database.SqlQuery <DelinquentAcctFinancialInfoDTO>(BuildSqlCommand("WebDelinquentAcctFinancialInfo", paramCollection), paramCollection.ToArray()).FirstOrDefaultAsync(); return(result); } }
public List <ManualTxnProductDTO> GetManualTxnProductList(string txnId) { using (var cardtrendentities = new pdb_ccmsContext(_connectionString)) { var parameters = new object[] { Common.Helpers.Common.GetIssueNo(), txnId }; var paramNameList = new[] { "@AcqNo", "@TxnId" }; var paramCollection = BuildParameterList(parameters, paramNameList); var result = cardtrendentities.Database.SqlQuery <ManualTxnProductDTO> (BuildSqlCommand("WebMerchManualTxnDetailListSelect", paramCollection), paramCollection.ToArray()).ToList(); return(result); } }
public async Task <EServiceDTO> iFrameMerchGeneralInfoSelect(string busnLocation) { using (var cardtrendentities = new pdb_ccmsContext(_connectionString)) { var parameters = new object[] { busnLocation }; var paramNameList = new[] { "@SAPNo" }; var paramCollection = BuildParameterList(parameters, paramNameList); var result = await cardtrendentities.Database.SqlQuery <EServiceDTO> (BuildSqlCommand("iFrameMerchGeneralInfoSelect", paramCollection), paramCollection.ToArray()).FirstOrDefaultAsync(); return(result); } }
public async Task <List <FraudCaseDTO> > FtFraudCaseList() { using (var cardtrendentities = new pdb_ccmsContext(_connectionString)) { var parameters = new object[] { Common.Helpers.Common.GetIssueNo() }; var paramNameList = new[] { "@IssNo" }; var paramCollection = BuildParameterList(parameters, paramNameList); var fraudCases = await cardtrendentities.Database.SqlQuery <FraudCaseDTO>(BuildSqlCommand("WebFraudCaseList", paramCollection), paramCollection.ToArray()).ToListAsync(); return(fraudCases); } }
public List <UserAccessLevelDTO> WebGetUserAccessModuleList(string userId, string level) { using (var cardtrendentities = new pdb_ccmsContext(_connectionString)) { var parameters = new object[] { Common.Helpers.Common.GetIssueNo(), userId, level }; var paramNameList = new[] { "@IssNo", "@UserId", "@Lvl" }; var paramCollection = BuildParameterList(parameters, paramNameList); var result = cardtrendentities.Database.SqlQuery <UserAccessLevelDTO>(BuildSqlCommand("WebUserAccessLevelListSelect", paramCollection), paramCollection.ToArray()).ToList(); return(result); } }
public async Task <IList <ProdGroupRefDTO> > WebProdGroupRefs() { using (var cardtrendentities = new pdb_ccmsContext(_connectionString)) { var parameters = new object[] { Common.Helpers.Common.GetIssueNo() }; var paramNameList = new[] { "@IssNo" }; var paramCollection = BuildParameterList(parameters, paramNameList); var results = await cardtrendentities.Database.SqlQuery <ProdGroupRefDTO> (BuildSqlCommand("WebProdGroupRefListSelect", paramCollection), paramCollection.ToArray()).ToListAsync(); return(results); } }
public async Task <List <MultiPaymentGLCodeDTO> > GetGLCode(string adjTxnCode) { using (var cardtrendentities = new pdb_ccmsContext(_connectionString)) { var parameters = new object[] { adjTxnCode }; var paramNameList = new[] { "@TxnCd" }; var paramCollection = BuildParameterList(parameters, paramNameList); var multiPaymentGLCodes = await cardtrendentities.Database.SqlQuery <MultiPaymentGLCodeDTO> (BuildSqlCommand("WebGetGlCode", paramCollection), paramCollection.ToArray()).ToListAsync(); return(multiPaymentGLCodes); } }
public async Task <List <MerchantMultiTxnAdjustmentDTO> > MerchantMultiTxnAdjustmentListSelect() { using (var cardtrendentities = new pdb_ccmsContext(_connectionString)) { var parameters = new object[] { Common.Helpers.Common.GetIssueNo() }; var paramNameList = new[] { "@IssNo" }; var paramCollection = BuildParameterList(parameters, paramNameList); var txnAdjustments = await cardtrendentities.Database.SqlQuery <MerchantMultiTxnAdjustmentDTO> (BuildSqlCommand("WebMerchantMultiTxnAdjustmentListSelect", paramCollection), paramCollection.ToArray()).ToListAsync(); return(txnAdjustments); } }