//remove all tasks that have already been aggregated from the task table
public static void PurgeAllAggregatedTasks()
{
SatyamTaskTableAccess taskDB = new SatyamTaskTableAccess();
//List<int> IDList = taskDB.getAllIDs();
List <SatyamTaskTableEntry> taskList = taskDB.getAllEntries();
SatyamAggregatedResultsTableAccess aggDB = new SatyamAggregatedResultsTableAccess();
List <int> AggIDList = aggDB.getAllTaskIDs();
//List<SatyamAggregatedResultsTableEntry> aggEntreis = aggDB.getAllEntries();
foreach (SatyamTaskTableEntry t in taskList)
{
int id = t.ID;
if (!AggIDList.Contains(id))
{
continue;
}
//int LatestNumberAggregated = aggDB.getLatestNoResultsAggregatedByTaskID(id);
//int MinResults = TaskConstants.getMinResultsByTemplate(t.JobTemplateType);
//if(LatestNumberAggregated >= MinResults)
//{
taskDB.DeleteEntry(id);
//}
}
aggDB.close();
taskDB.close();
}
public static void Run([TimerTrigger("0 */1 * * * *")] TimerInfo myTimer, TraceWriter log)
{
DateTime start = DateTime.Now;
SatyamTaskTableAccess taskDB = new SatyamTaskTableAccess();
List <int> IDList = taskDB.getAllIDs();
taskDB.close();
SatyamAggregatedResultsTableAccess aggDB = new SatyamAggregatedResultsTableAccess();
List <int> AggIDList = aggDB.getAllTaskIDs();
aggDB.close();
foreach (int id in IDList)
{
if (AggIDList.Contains(id))
{
taskDB = new SatyamTaskTableAccess();
taskDB.DeleteEntry(id);
taskDB.close();
if ((DateTime.Now - start).TotalSeconds > 280)
{
break;
}
}
}
}
