public bool ProcessMacroRunTask()
{
var macroId = 0;
try
{
var macro = Queries.MacroRegister();
var dt = DataAccess.i.GetData(macro);
if (dt.Rows.Count == 0)
{
Log4Net.Log.Info($"No new pending Macro");
return(true);
}
else
{
Log4Net.Log.Info($"Found Macro to RUN");
}
var affId = (long)dt.Rows[0]["AffiliateId"];
macroId = (int)dt.Rows[0]["Id"];
//var qry = Queries.UpdateIntTableServiceId("CalibrationRunMacroAnalysis", this.serviceId, macroId);
//DataAccess.i.ExecuteQuery(qry);
var qry = Queries.MacroRegisterUpdate(macroId, 4, "Processing");
DataAccess.i.ExecuteQuery(qry);
try
{
var macroP = new Macro_Processor();
macroP.ProcessMacro(macroId, affId);
qry = Queries.MacroRegisterUpdate(macroId, 5, "Completed");
DataAccess.i.ExecuteQuery(qry);
}
catch (Exception ex)
{
Log4Net.Log.Info("At Macro");
Log4Net.Log.Error(ex);
Log4Net.Log.Error(ex.ToString());
Log4Net.Log.Error(ex.StackTrace);
qry = Queries.MacroRegisterUpdate(macroId, 10, ex.ToString());
DataAccess.i.ExecuteQuery(qry);
}
}
catch (Exception ex)
{
Log4Net.Log.Info("At Macro");
Log4Net.Log.Error(ex);
var qry = Queries.MacroRegisterUpdate(macroId, 10, ex.ToString());
DataAccess.i.ExecuteQuery(qry);
}
return(true);
}
