private List <WReportItem> GetClosedWarrants(DateTime start, DateTime end)
{
List <WReportItem> results = new List <WReportItem>();
List <Warrant> closedWs = db.Warrants.Where(c => c.caseStatusID == 3 && c.resultDate >= start && c.resultDate <= end).OrderBy(c1 => c1.resultDate).ToList();
foreach (Warrant w in closedWs)
{
WReportItem i = new WReportItem();
i.tipstaffRecordID = w.tipstaffRecordID;
i.UniqueRecordID = w.UniqueRecordID;
i.DateCirculated = w.DateCirculated;
i.ClosedDate = w.resultDate;
i.respondents = w.Respondents;
i.NPO = w.NPO;
results.Add(i);
}
return(results);
}
private List <WReportItem> GetActiveWarrants()
{
List <WReportItem> results = new List <WReportItem>();
List <Warrant> activeWs = db.Warrants.Where(c => c.caseStatusID == 1 || c.caseStatusID == 2).ToList();
foreach (Warrant w in activeWs)
{
WReportItem i = new WReportItem();
i.tipstaffRecordID = w.tipstaffRecordID;
i.UniqueRecordID = w.UniqueRecordID;
i.DateCirculated = w.DateCirculated;
i.ClosedDate = null;
i.respondents = w.Respondents;
i.NPO = w.NPO;
results.Add(i);
}
return(results);
}
