protected void DeleteOldResults()
{
List <Result> allResults = new List <Result>();
ResultModel m = new ResultModel();
allResults = m.GetAllResults();
string status = "";
string resString = "";
DateTime deleteDate = DateTime.Now.AddDays(-7);
foreach (Result r in allResults)
{
if (r.DateSearched < deleteDate)
{
status = m.DeleteResult(r.ID);
resString = resString + r.ID.ToString() + ",";
}
else if (r.Triggers == "" || r.Triggers == null)
{
status = m.DeleteResult(r.ID);
resString = resString + r.ID.ToString() + ",";
}
}
DeleteFromUsers(resString);
}
protected void btnDeleteDuplicates_Click(object sender, EventArgs e)
{
List <Result> allResults = new List <Result>();
ResultModel m = new ResultModel();
allResults = m.GetAllResults();
string status = "";
foreach (Result r in allResults)
{
if (HasDuplicates(r.ID))
{
status = m.DeleteResult(r.ID);
}
}
}
protected void btnDeleteBlank_Click(object sender, EventArgs e)
{
List <Result> allResults = new List <Result>();
ResultModel m = new ResultModel();
allResults = m.GetAllResults();
string status = "";
foreach (Result r in allResults)
{
if (r.Triggers == "" || r.Triggers == null)
{
status = m.DeleteResult(r.ID);
}
}
lblStatus.Text = status;
}
protected void btnDeleteDays_Click(object sender, EventArgs e)
{
List <Result> allResults = new List <Result>();
ResultModel m = new ResultModel();
allResults = m.GetAllResults();
int days = Convert.ToInt32(txtDays.Text);
string status = "";
DateTime deleteDate = DateTime.Now.AddDays(-days);
foreach (Result r in allResults)
{
if (r.DateSearched < deleteDate)
{
status = m.DeleteResult(r.ID);
}
}
lblStatus.Text = status;
}
protected void btnDelete_Click(object sender, EventArgs e)
{
ResultModel rMod = new ResultModel();
List <Result> allDem = new List <Result>();
allDem = rMod.GetAllResults();
List <int> toDel = new List <int>();
foreach (Result re in allDem)
{
if (re.Triggers == "False;")
{
int curId = re.ID;
toDel.Add(curId);
}
} //Foreach
foreach (int num in toDel)
{
rMod.DeleteResult(num);
} //Foreach
} // btnDelete