public IEnumerable <IFRSReport> GetAllRunDate()
{
//var connectionString = ConfigurationManager.ConnectionStrings["FintrakDBConnection"].ConnectionString;
var connectionString = IFRSContext.GetDataConnection();
var ifrsreports = new List <IFRSReport>();
using (var con = new System.Data.SqlClient.SqlConnection(connectionString))
{
var cmd = new SqlCommand("spp_ifrs_report_rundates", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var report = new IFRSReport();
if (reader["RunDate"] != DBNull.Value)
{
report.RunDate = DateTime.Parse(reader["RunDate"].ToString());
}
ifrsreports.Add(report);
}
con.Close();
}
return(ifrsreports);
}
protected override IEnumerable <InvestmentOthersECL> GetEntities(IFRSContext entityContext)
{
var query = from a in entityContext.InvestmentOthersECLSet
select a;
return(query.ToFullyLoaded().OrderBy(a => a.period).GroupBy(a => a.RefNo).Select(a => a.First()));
}
public IEnumerable <BondComputation> GetBondPeriodicScheduleRefNos(string bondComputationRefNo)
{
IFRSContext entityContext = new IFRSContext();
var query = entityContext.BondComputationSet.AsQueryable().Where(r => r.RefNo == bondComputationRefNo);
return(query.ToFullyLoaded());
}
public IEnumerable <string> GetDistinctBondComputationRefNos()
{
IFRSContext entityContext = new IFRSContext();
var query = (entityContext.BondComputationSet.Select <BondComputation, string>(r => r.RefNo)).Distinct();
return(query.ToFullyLoaded());
}
public IEnumerable <LoanSchedule> GetLoanScheduleRefNos(string loanScheduleRefNo)
{
IFRSContext entityContext = new IFRSContext();
var query = entityContext.LoanScheduleSet.AsQueryable().Where(r => r.RefNo == loanScheduleRefNo);
return(query.ToFullyLoaded());
}
public IEnumerable <string> GetDistinctLoanScheduleRefNos()
{
IFRSContext entityContext = new IFRSContext();
var query = (entityContext.LoanScheduleSet.Select <LoanSchedule, string>(r => r.RefNo)).Distinct();
return(query.ToFullyLoaded());
}
public IEnumerable <TBillsComputationResult> GetTBillsComputationResultRefNos(string tBillsComputationResultClassification)
{
IFRSContext entityContext = new IFRSContext();
var query = entityContext.TBillsComputationResultSet.AsQueryable().Where(r => r.Classification == tBillsComputationResultClassification);
return(query.ToFullyLoaded());
}
public IEnumerable <IndividualSchedule> GetIndividualSchedules()
{
using (IFRSContext entityContext = new IFRSContext())
{
var query = entityContext.IndividualScheduleSet.AsQueryable().Where(r => r.Processed == false);
return(query.ToFullyLoaded());
}
}
public IEnumerable <RawLoanDetails> GetIndividualImpairments(string refNo)
{
using (IFRSContext entityContext = new IFRSContext())
{
var query = entityContext.LoanDetailsSet.AsQueryable().Where(r => r.RefNo == refNo);
return(query.ToFullyLoaded());
}
}
public IEnumerable <string> GetRiskRatingCode()
{
using (IFRSContext entityContext = new IFRSContext())
{
var query = (entityContext.CreditRiskRatingSet.Select <CreditRiskRating, string>(r => r.Code)).Distinct();
return(query.ToFullyLoaded());
}
}
public IEnumerable <string> GetDistinctRefNos()
{
using (IFRSContext entityContext = new IFRSContext())
{
var query = (entityContext.LoanPryDataSet.Select <LoanPry, string>(r => r.RefNo)).Distinct();
return(query.ToFullyLoaded());
}
}
public IEnumerable <string> GetDistinctSector()
{
using (IFRSContext entityContext = new IFRSContext())
{
var query = (entityContext.IfrsCustomerAccountSet.Select <IfrsCustomerAccount, string>(r => r.Sector)).Distinct();
return(query.ToFullyLoaded());
}
}
protected override SectorialRegressedLGD GetEntity(IFRSContext entityContext, int id)
{
var query = (from e in entityContext.Set <SectorialRegressedLGD>()
where e.SectorialRegressedLGDId == id
select e);
var results = query.FirstOrDefault();
return(results);
}
protected override MacroEconomicHistorical GetEntity(IFRSContext entityContext, int id)
{
var query = (from e in entityContext.Set <MacroEconomicHistorical>()
where e.MacroEconomicHistoricalId == id
select e);
var results = query.FirstOrDefault();
return(results);
}
protected override PitFormular GetEntity(IFRSContext entityContext, int id)
{
var query = (from e in entityContext.Set <PitFormular>()
where e.PitFormularId == id
select e);
var results = query.FirstOrDefault();
return(results);
}
protected override LifeTimePDClassification GetEntity(IFRSContext entityContext, int id)
{
var query = (from e in entityContext.Set <LifeTimePDClassification>()
where e.LifeTimePDClassificationId == id
select e);
var results = query.FirstOrDefault();
return(results);
}
protected override TrialBalance GetEntity(IFRSContext entityContext, int id)
{
var query = (from e in entityContext.Set <TrialBalance>()
where e.TrialBalanceId == id
select e);
var results = query.FirstOrDefault();
return(results);
}
protected override UnquotedEquityFairvalueResult GetEntity(IFRSContext entityContext, int id)
{
var query = (from e in entityContext.Set <UnquotedEquityFairvalueResult>()
where e.UnquotedEquityFairvalueResultId == id
select e);
var results = query.FirstOrDefault();
return(results);
}
protected override MarkovMatrix GetEntity(IFRSContext entityContext, int id)
{
var query = (from e in entityContext.Set <MarkovMatrix>()
where e.MarkovMatrixId == id
select e);
var results = query.FirstOrDefault();
return(results);
}
protected override ForecastedMacroeconimcsSensitivity GetEntity(IFRSContext entityContext, int id)
{
var query = (from e in entityContext.Set <ForecastedMacroeconimcsSensitivity>()
where e.ForecastedMacroeconimcsSensitivityId == id
select e);
var results = query.FirstOrDefault();
return(results);
}
protected override PlacementComputationResult GetEntity(IFRSContext entityContext, int id)
{
var query = (from e in entityContext.Set <PlacementComputationResult>()
where e.Id == id
select e);
var results = query.FirstOrDefault();
return(results);
}
protected override GLAdjustment GetEntity(IFRSContext entityContext, int id)
{
var query = (from e in entityContext.Set <GLAdjustment>()
where e.GLAdjustmentId == id
select e);
var results = query.FirstOrDefault();
return(results);
}
protected override MonthlyDiscountFactorBond GetEntity(IFRSContext entityContext, int MonthlyDiscountFactorBond_Id)
{
var query = (from e in entityContext.Set <MonthlyDiscountFactorBond>()
where e.MonthlyDiscountFactorBond_Id == MonthlyDiscountFactorBond_Id
select e);
var results = query.FirstOrDefault();
return(results);
}
protected override ForeignEADExchangeRate GetEntity(IFRSContext entityContext, int id)
{
var query = (from e in entityContext.Set <ForeignEADExchangeRate>()
where e.ForeignEADExchangeRateId == id
select e);
var results = query.FirstOrDefault();
return(results);
}
protected override MacrovariableEstimate GetEntity(IFRSContext entityContext, int id)
{
var query = (from e in entityContext.Set <MacrovariableEstimate>()
where e.MacrovariableEstimate_Id == id
select e);
var results = query.FirstOrDefault();
return(results);
}
protected override ProbabilityWeighted GetEntity(IFRSContext entityContext, int id)
{
var query = (from e in entityContext.Set <ProbabilityWeighted>()
where e.ProbabilityWeighted_Id == id
select e);
var results = query.FirstOrDefault();
return(results);
}
protected override TransactionDetail GetEntity(IFRSContext entityContext, int id)
{
var query = (from e in entityContext.Set <TransactionDetail>()
where e.TransactionDetailId == id
select e);
var results = query.FirstOrDefault();
return(results);
}
protected override LocalBondSpread GetEntity(IFRSContext entityContext, int id)
{
var query = (from e in entityContext.Set <LocalBondSpread>()
where e.ID == id
select e);
var results = query.FirstOrDefault();
return(results);
}
protected override LoanPry GetEntity(IFRSContext entityContext, int id)
{
var query = (from e in entityContext.Set <LoanPry>()
where e.PryId == id
select e);
var results = query.FirstOrDefault();
return(results);
}
protected override FairValueBasisMap GetEntity(IFRSContext entityContext, int id)
{
var query = (from e in entityContext.Set <FairValueBasisMap>()
where e.FairValueBasisMapId == id
select e);
var results = query.FirstOrDefault();
return(results);
}
