public ActionResult TermsContent(int year)
{
var viewmodel = new List <SchoolTermsViewModel>();
foreach (var entry in db.schools)
{
var school = entry;
var schoolTerms = new List <SchoolTerm>();
var terms = repository.GetSchoolTerms().Where(x => x.schoolid == school.id);
foreach (var term in terms)
{
var att = term.attendance_terms.SingleOrDefault(x => x.year == year);
SchoolTerm row;
if (att == null)
{
row = new SchoolTerm {
term = term.name, termid = term.id, year = year
};
}
else
{
row = att.ToModel();
}
schoolTerms.Add(row);
}
var model = new SchoolTermsViewModel
{
terms = schoolTerms,
schoolid = school.id,
schoolname = school.name
};
viewmodel.Add(model);
}
return(View(viewmodel));
}
public ActionResult Terms()
{
var year = DateTime.Now.Year;
var viewmodel = new AdminSchoolTermsViewModel();
viewmodel.yearList = new[] { year }.Union(db.attendance_terms.Select(x => x.year))
.Distinct()
.OrderByDescending(x => x)
.Select(x => new SelectListItem()
{
Text = x.ToString(), Value = x.ToString()
});
foreach (var entry in db.schools)
{
var school = entry;
var schoolTerms = new List <SchoolTerm>();
var terms = repository.GetSchoolTerms().Where(x => x.schoolid == school.id);
foreach (var term in terms)
{
var att = term.attendance_terms.SingleOrDefault(x => x.year == year);
SchoolTerm row;
if (att == null)
{
row = new SchoolTerm {
term = term.name, termid = term.id, year = year
};
}
else
{
row = att.ToModel();
}
schoolTerms.Add(row);
}
var model = new SchoolTermsViewModel
{
terms = schoolTerms,
schoolid = school.id,
schoolname = school.name
};
viewmodel.terms.Add(model);
}
return(View(viewmodel));
}
