protected List <LifeTimeObject> GetScenarioRedfaultLifetimePdResult(ECL_Scenario _scenario)
{
var redefaultLifetimePd = new List <LifeTimeObject>();
switch (_scenario)
{
case ECL_Scenario.Best:
redefaultLifetimePd = FileSystemStorage <LifeTimeObject> .ReadCsvData(this._eclId, ECLStringConstants.i.PdRedefaultLifetimeBests_Table(this._eclType));
break;
case ECL_Scenario.Optimistic:
redefaultLifetimePd = FileSystemStorage <LifeTimeObject> .ReadCsvData(this._eclId, ECLStringConstants.i.PdRedefaultLifetimeOptimistics_Table(this._eclType));
break;
case ECL_Scenario.Downturn:
redefaultLifetimePd = FileSystemStorage <LifeTimeObject> .ReadCsvData(this._eclId, ECLStringConstants.i.PdRedefaultLifetimeDownturns_Table(this._eclType));
break;
default:
return(null);
}
Log4Net.Log.Info($"LGD_RedefaultLifetimePD - {_scenario}");
return(redefaultLifetimePd);
}
public List <LifeTimeObject> Get_LifetimePd_And_RedefaultLifetimePD_Result()
{
var lifetimePd = new List <LifeTimeObject>();
switch (_scenario)
{
case ECL_Scenario.Best:
lifetimePd = FileSystemStorage <LifeTimeObject> .ReadCsvData(this._eclId, ECLStringConstants.i.PdLifetimeBests_Table(this._eclType));
break;
case ECL_Scenario.Optimistic:
lifetimePd = FileSystemStorage <LifeTimeObject> .ReadCsvData(this._eclId, ECLStringConstants.i.PdLifetimeOptimistics_Table(this._eclType));
break;
case ECL_Scenario.Downturn:
lifetimePd = FileSystemStorage <LifeTimeObject> .ReadCsvData(this._eclId, ECLStringConstants.i.PdLifetimeDownturns_Table(this._eclType));
break;
default:
return(null);
}
return(lifetimePd);
}
public bool ProcessFrameworkResult(string filename, FrameworkParameters input)
{
try
{
var frameworkResult = FileSystemStorage <ResultDetailDataMore> .ReadCsvData(filename);
var c = new ResultDetailDataMore();
Type myObjOriginalType = c.GetType();
PropertyInfo[] myProps = myObjOriginalType.GetProperties();
var dt = new System.Data.DataTable();
for (int i = 0; i < myProps.Length; i++)
{
dt.Columns.Add(myProps[i].Name, myProps[i].PropertyType);
}
dt.Columns.Add($"{input.EclType}EclId", typeof(Guid));
//var lstContractNoLog = new List<string>();
foreach (var _d in frameworkResult)
{
//if (lstContractNoLog.Any(o => o == _d.ContractNo))
// continue;
//lstContractNoLog.Add(_d.ContractNo);
try { c.OriginalOutstandingBalance = 0.0; } catch { }
//(double)batchContracts.FirstOrDefault(o => o.ContractNo == c.ContractNo).OutstandingBalanceLCY; } catch { }
var Id = Guid.NewGuid();
dt.Rows.Add(new object[]
{
Id, _d.Stage, _d.Outstanding_Balance, _d.ECL_Best_Estimate, _d.ECL_Optimistic, _d.ECL_Downturn, _d.Impairment_ModelOutput,
_d.Overrides_Stage, _d.Overrides_TTR_Years, _d.Overrides_FSV, _d.Overrides_Overlay, _d.Overrides_ECL_Best_Estimate, _d.Overrides_ECL_Optimistic, _d.Overrides_ECL_Downturn, _d.Overrides_Impairment_Manual, _d.ContractNo, _d.AccountNo,
_d.CustomerNo, _d.Segment, _d.ProductType, _d.Sector, _d.OriginalOutstandingBalance, input.EclId
});
}
//Save to Report Detail
var r = DataAccess.i.ExecuteBulkCopy(dt, ECLStringConstants.i.EclFramworkReportDetail(input.EclType));
return(true);
}
catch (Exception ex)
{
Log4Net.Log.Error(ex);
return(false);
}
}
private List <EIRProjections> GetEirProjectionData()
{
var r = FileSystemStorage <EIRProjections> .ReadCsvData(this._eclId, ECLStringConstants.i.EadEirProjections_Table(this._eclType));
return(r);
}
public List <SicrInputs> GetSircInputResult()
{
var sicrData = FileSystemStorage <SicrInputs> .ReadCsvData(this._eclId, ECLStringConstants.i.PdMappings_Table(this._eclType));
return(sicrData);
}
internal List <PdMappings> GetPdMapping()
{
var pdMapping = FileSystemStorage <PdMappings> .ReadCsvData(this._eclId, ECLStringConstants.i.PdMappings_Table(this._eclType));
return(pdMapping);
}