public List <StudentRequestsViewModel> GetStudentRequests()
{
List <StudentRequestsViewModel> studentRequests = new List <StudentRequestsViewModel>();
var vakL = from course in db.Course
orderby course.Vakcode
select course;
var cuL = from cu in db.CourseUser
join user in db.Users on cu.ApplicationUserId equals user.Id
join vak in db.Course on cu.CourseId equals vak.Id
orderby user.UserName
where cu.GoedGekeurd == false
select new { cuId = cu.Id, cId = vak.Id, titel = vak.Titel, vakCode = vak.Vakcode, RNum = user.UserName, naam = user.Naam, voorNaam = user.VoorNaam };
foreach (var vakI in vakL)
{
// StudentRequestsViewModel studReq = new StudentRequestsViewModel { cuId = -1, Titel = vakI.Titel, VakCode = vakI.Vakcode };
//studentRequests.Add(studReq);
var cuL2 = cuL.Where(c => c.cId.Equals(vakI.Id));
foreach (var res in cuL2)
{
StudentRequestsViewModel studReq = new StudentRequestsViewModel
{
RNum = res.RNum, cuId = res.cuId, VakCode = res.vakCode, Titel = res.titel, Naam = res.naam,
VoorNaam = res.voorNaam
};
studentRequests.Add(studReq);
}
}
return(studentRequests);
}
public ActionResult ViewStudentRequests(string studentNumber)
{
var requests = _context.Requests.Include(r => r.RequestStatus)
.Include(r => r.Category)
.Where(r => r.StudentNumber == studentNumber)
.ToList();
var viewModel = new StudentRequestsViewModel
{
Requests = requests
};
return(View("Requests", viewModel));
}
