public List <PDI_StatisticalInputs> Get_PDI_StatisticalInputs()
{
var dt = DataAccess.i.GetData(PD_Queries.Get_statisticalInputsQuery(this._eclId, this._eclType));
var data = new List <PDI_StatisticalInputs>();
foreach (DataRow dr in dt.Rows)
{
var itm = DataAccess.i.ParseDataToObject(new PDI_StatisticalInputs(), dr);
data.Add(itm);
}
return(data);
}
public List <PDI_SnPCummlativeDefaultRate> Get_PDI_SnPCummlativeDefaultRate()
{
var dt = DataAccess.i.GetData(PD_Queries.Get_snpCummulativeDefaultRateQuery(this._eclId, this._eclType));
var data = new List <PDI_SnPCummlativeDefaultRate>();
foreach (DataRow dr in dt.Rows)
{
var itm = DataAccess.i.ParseDataToObject(new PDI_SnPCummlativeDefaultRate(), dr);
data.Add(itm);
}
return(data);
}
//public List<PDI_MacroEcoBest> Get_PDI_MacroEcoBest()
//{
// return new List<PDI_MacroEcoBest>();
//}
//public List<PDI_MacroEcoDownturn> Get_PDI_MacroEcoDownturn()
//{
// return new List<PDI_MacroEcoDownturn>();
//}
//public List<PDI_MacroEcoOptimisit> Get_PDI_MacroEcoOptimisit()
//{
// return new List<PDI_MacroEcoOptimisit>();
//}
public List <PdInputAssumptionNonInternalModels> Get_PDI_NonInternalModelInputs(int MonthId = 0)
{
var dt = DataAccess.i.GetData(PD_Queries.Get_nonInternalmodelInputQuery(this._eclId, this._eclType, MonthId));//(this._eclId)); ;
var data = new List <PdInputAssumptionNonInternalModels>();
foreach (DataRow dr in dt.Rows)
{
var itm = DataAccess.i.ParseDataToObject(new PdInputAssumptionNonInternalModels(), dr);
data.Add(itm);
}
return(data);
}
public List <PDI_Assumptions> Get_PDI_Assumptions()
{
var dt = DataAccess.i.GetData(PD_Queries.Get_pdInputAssumptionsQuery(this._eclId, this._eclType));
var data = new List <PDI_Assumptions>();
foreach (DataRow dr in dt.Rows)
{
var itm = DataAccess.i.ParseDataToObject(new PDI_Assumptions(), dr);
itm.PdGroup = PDInputs.GetPDAssumptionEnum(int.Parse(dr["PdGroup"].ToString()));
data.Add(itm);
}
return(data);
}
public List <PDI_MacroEconomics> Get_PDI_MacroEconomics()
{
var dt = DataAccess.i.GetData(PD_Queries.Get_macroEconomicsQuery(this._eclId, this._eclType));
var data = new List <PDI_MacroEconomics>();
//Log4Net.Log.Info($"**************************");
foreach (DataRow dr in dt.Rows)
{
var itm = DataAccess.i.ParseDataToObject(new PDI_MacroEconomics(), dr);
//Log4Net.Log.Info($"{itm.Date},{itm.MacroEconomicVariableId},{itm.BestEstimateMacroEconomicValue},{itm.OptimisticMacroEconomicValue},{itm.DownturnMacroEconomicValue}");
data.Add(itm);
}
return(data);
}
public List <PDI_ETI_NPL> Get_PDI_ETI_NPL()
{
var dt = DataAccess.i.GetData(PD_Queries.Get_etiNplQuery(this._eclId, this._eclType));
var data = new List <PDI_ETI_NPL>();
foreach (DataRow dr in dt.Rows)
{
var o = DataAccess.i.ParseDataToObject(new MacroResult_IndexData(), dr);
var itm = new PDI_ETI_NPL();
itm.Series = o.BfNpl;
itm.Date = GetPeriodDate(o.Period);
data.Add(itm);
}
return(data);
}
public List <PDI_HistoricIndex> Get_PDI_HistoricIndex()
{
var dt = DataAccess.i.GetData(PD_Queries.Get_historicIndexQuery(this._eclId, this._eclType));
var data = new List <PDI_HistoricIndex>();
foreach (DataRow dr in dt.Rows)
{
var o = DataAccess.i.ParseDataToObject(new MacroResult_IndexData(), dr);
var itm = new PDI_HistoricIndex();
itm.Actual = o.Index;
itm.Standardised = o.StandardIndex;
itm.Date = GetPeriodDate(o.Period);
data.Add(itm);
}
data = data.OrderBy(o => o.Date).ToList();
return(data);//.Take(32).ToList();
}
