public IActionResult SaveThis(string year) { dynamic mymodel = new ExpandoObject(); if (year != null) { SavedYears savedYear = new SavedYears(); savedYear.savedYear = int.Parse(year); var Years = dbContext.Years.ToList(); Boolean found = false; foreach (SavedYears savedyear in Years) { if (savedyear.savedYear == int.Parse(year)) { found = true; } } if (found == false) { dbContext.Years.Add(savedYear); dbContext.SaveChanges(); } } List <SavedYears> yearsToShow = dbContext.Years.ToList(); List <Report> reports = new List <Report>(); for (int i = 0; i < yearsToShow.Count(); i++) { reports.Add(getRawResults(yearsToShow[i].savedYear)); } mymodel.reports = reports; return(View(mymodel)); }
public IActionResult DeleteThis(string year) { dynamic mymodel = new ExpandoObject(); if (year != null) { SavedYears years = dbContext.Years.Where(p => p.savedYear == int.Parse(year)).FirstOrDefault(); dbContext.Years.Remove(years); dbContext.SaveChanges(); } mymodel.year = year; return(View(mymodel)); }