public IEnumerable<Int32> LoadIncidentYears()
{
using (var context = new HoneyBadgerEntities())
{
var stateDisasters = from sd in context.StateDisasterViews
select sd;
if (stateDisasters.Count()>0)
return stateDisasters.Select<StateDisasterView, Int32>(x =>x.DisasterYear).Distinct().OrderBy(x=>x).ToList();
}
//defaults to last threee calendar years if no disaster data is found in database
return new List<Int32> { DateTime.Now.Year - 2, DateTime.Now.Year - 1, DateTime.Now.Year };
}
public ActionResult Index()
{
HoneyBadgerSvc service = new HoneyBadgerSvc();
HomeLookupViewModel model = new HomeLookupViewModel();
model.IncidentYears = service.LoadIncidentYears();
model.IncidentTypes = service.LoadIncidentTypes();
return View(model);
}