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