public bool ProcessCalibrationRunTask()
{
try
{
var cali = Queries.CalibrationBehavioural();
var dt = DataAccess.i.GetData(cali);
if (dt.Rows.Count > 0)
{
var qry = "";
var caliId = Guid.NewGuid();
try
{
var affId = (long)dt.Rows[0]["AffiliateId"];
caliId = (Guid)dt.Rows[0]["Id"];
//qry = Queries.UpdateGuidTableServiceId("CalibrationRunEadBehaviouralTerms", this.serviceId, caliId);
//var resp = DataAccess.i.ExecuteQuery(qry);
//if (resp == 0)
//{
// Log4Net.Log.Info($"Another service has picked Behavioural Calibration with ID {caliId.ToString()}.");
// return true;
//}
qry = Queries.CalibrationRegisterUpdate(caliId.ToString(), 4, "Processing", "CalibrationRunEadBehaviouralTerms");
DataAccess.i.ExecuteQuery(qry);
var ead_bahavioural = new CalibrationInput_EAD_Behavioural_Terms_Processor();
ead_bahavioural.ProcessCalibration(caliId, affId);
qry = Queries.CalibrationRegisterUpdate(caliId.ToString(), 5, "Completed", "CalibrationRunEadBehaviouralTerms");
DataAccess.i.ExecuteQuery(qry);
}
catch (Exception ex)
{
Log4Net.Log.Info("At Calibration");
Log4Net.Log.Error(ex.ToString());
qry = Queries.CalibrationRegisterUpdate(caliId.ToString(), 10, ex.ToString(), "CalibrationRunEadBehaviouralTerms");
DataAccess.i.ExecuteQuery(qry);
}
}
else
{
Log4Net.Log.Info("No new Calibration found!");
}
cali = Queries.CalibrationCCF();
dt = DataAccess.i.GetData(cali);
if (dt.Rows.Count > 0)
{
var qry = "";
var caliId = Guid.NewGuid();
try
{
var affId = (long)dt.Rows[0]["AffiliateId"];
caliId = (Guid)dt.Rows[0]["Id"];
qry = Queries.UpdateGuidTableServiceId("CalibrationRunEadCcfSummary", this.serviceId, caliId);
var resp = DataAccess.i.ExecuteQuery(qry);
if (resp == 0)
{
Log4Net.Log.Info($"Another service has picked CCF Calibration with ID {caliId.ToString()}.");
return(true);
}
qry = Queries.CalibrationRegisterUpdate(caliId.ToString(), 4, "Processing", "CalibrationRunEadCcfSummary");
DataAccess.i.ExecuteQuery(qry);
var ead_ccf = new CalibrationInput_EAD_CCF_Summary_Processor();
ead_ccf.ProcessCalibration(caliId, affId);
qry = Queries.CalibrationRegisterUpdate(caliId.ToString(), 5, "Completed", "CalibrationRunEadCcfSummary");
DataAccess.i.ExecuteQuery(qry);
}
catch (Exception ex)
{
Log4Net.Log.Info("At Calibration");
Log4Net.Log.Error(ex.ToString());
qry = Queries.CalibrationRegisterUpdate(caliId.ToString(), 10, ex.ToString(), "CalibrationRunEadCcfSummary");
DataAccess.i.ExecuteQuery(qry);
}
}
cali = Queries.CalibrationHaircut();
dt = DataAccess.i.GetData(cali);
if (dt.Rows.Count > 0)
{
var qry = "";
var caliId = Guid.NewGuid();
try
{
var affId = (long)dt.Rows[0]["AffiliateId"];
caliId = (Guid)dt.Rows[0]["Id"];
qry = Queries.UpdateGuidTableServiceId("CalibrationRunLgdHairCut", this.serviceId, caliId);
var resp = DataAccess.i.ExecuteQuery(qry);
if (resp == 0)
{
Log4Net.Log.Info($"Another service has picked Haircut Calibration with ID {caliId.ToString()}.");
return(true);
}
qry = Queries.CalibrationRegisterUpdate(caliId.ToString(), 4, "Processing", "CalibrationRunLgdHairCut");
DataAccess.i.ExecuteQuery(qry);
var lgd_haircut = new CalibrationInput_LGD_Haricut_Processor();
lgd_haircut.ProcessCalibration(caliId, affId);
qry = Queries.CalibrationRegisterUpdate(caliId.ToString(), 5, "Completed", "CalibrationRunLgdHairCut");
DataAccess.i.ExecuteQuery(qry);
}
catch (Exception ex)
{
Log4Net.Log.Error(ex.ToString());
qry = Queries.CalibrationRegisterUpdate(caliId.ToString(), 10, ex.ToString(), "CalibrationRunLgdHairCut");
DataAccess.i.ExecuteQuery(qry);
}
}
cali = Queries.CalibrationRecovery();
dt = DataAccess.i.GetData(cali);
if (dt.Rows.Count > 0)
{
var qry = "";
var caliId = Guid.NewGuid();
try
{
var affId = (long)dt.Rows[0]["AffiliateId"];
caliId = (Guid)dt.Rows[0]["Id"];
qry = Queries.UpdateGuidTableServiceId("CalibrationRunLgdRecoveryRate", this.serviceId, caliId);
var resp = DataAccess.i.ExecuteQuery(qry);
if (resp == 0)
{
Log4Net.Log.Info($"Another service has picked Recovery Rate Calibration with ID {caliId.ToString()}.");
return(true);
}
qry = Queries.CalibrationRegisterUpdate(caliId.ToString(), 4, "Processing", "CalibrationRunLgdRecoveryRate");
DataAccess.i.ExecuteQuery(qry);
var lgd_recoveryR = new CalibrationInput_LGD_RecoveryRate_Processor();
lgd_recoveryR.ProcessCalibration(caliId, affId);
qry = Queries.CalibrationRegisterUpdate(caliId.ToString(), 5, "Completed", "CalibrationRunLgdRecoveryRate");
DataAccess.i.ExecuteQuery(qry);
}
catch (Exception ex)
{
Log4Net.Log.Error(ex.ToString());
qry = Queries.CalibrationRegisterUpdate(caliId.ToString(), 10, ex.ToString(), "CalibrationRunLgdRecoveryRate");
DataAccess.i.ExecuteQuery(qry);
}
}
cali = Queries.CalibrationPD();
dt = DataAccess.i.GetData(cali);
if (dt.Rows.Count > 0)
{
var qry = "";
var caliId = Guid.NewGuid();
try
{
var affId = (long)dt.Rows[0]["AffiliateId"];
caliId = (Guid)dt.Rows[0]["Id"];
qry = Queries.UpdateGuidTableServiceId("CalibrationRunPdCrDrs", this.serviceId, caliId);
var resp = DataAccess.i.ExecuteQuery(qry);
if (resp == 0)
{
Log4Net.Log.Info($"Another service has picked PD CR DR Calibration with ID {caliId.ToString()}.");
return(true);
}
qry = Queries.CalibrationRegisterUpdate(caliId.ToString(), 4, "Processing", "CalibrationRunPdCrDrs");
DataAccess.i.ExecuteQuery(qry);
var pd_cr_dr = new CalibrationInput_PD_CR_RD_Processor();
pd_cr_dr.ProcessCalibration(caliId, affId);
qry = Queries.CalibrationRegisterUpdate(caliId.ToString(), 5, "Completed", "CalibrationRunPdCrDrs");
DataAccess.i.ExecuteQuery(qry);
}catch (Exception ex)
{
Log4Net.Log.Error(ex);
qry = Queries.CalibrationRegisterUpdate(caliId.ToString(), 10, ex.ToString(), "CalibrationRunPdCrDrs");
DataAccess.i.ExecuteQuery(qry);
}
}
}catch (Exception ex)
{
Log4Net.Log.Info("At Calibration");
Log4Net.Log.Error(ex.ToString());
var x = 0;
}
return(true);
}
