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