public IEnumerable <StudentClass> GetStudents()
{
List <StudentClass> students = new List <Models.StudentClass>();
var selectStudents = from s in db.Students
join c in db.tblCountries on s.Country equals c.Id
select new {
s.StudentID, s.City, s.Class, s.Email, s.EnrollYear, s.Name, CountryName = c.Name, c.Id
};
foreach (var item in selectStudents)
{
StudentClass student = new Models.StudentClass
{
StudentID = item.StudentID,
Name = item.Name,
City = item.City,
Class = item.Class,
Email = item.Email,
EnrollYear = item.EnrollYear,
AssociatedCountry = new Country {
Id = item.Id, Name = item.CountryName
}
};
students.Add(student);
}
return(students);
}
public ActionResult MyClasses(int StudentId)
{
ViewData["id"] = StudentId;
List <DataProcessor.StudentClass> studentClasses = studentClassProcessor.StudentClasses(sqlConnection, StudentId);
//BUT you can also create an MVC data model, which decouples the requierment of a DLL (could switch to a XML or JSON file later!)
Models.StudentClass classes;
List <Models.StudentClass> myclasses = new List <Models.StudentClass>();
foreach (var row in studentClasses)
{
classes = new Models.StudentClass(row.ClassID, row.ClassName, row.ClassDate, row.ClassDescription, row.StudentID, row.StudentName, row.StudentEmail);
myclasses.Add(classes);
}
return(View(myclasses));
}
