public ActionResult dashboard()
{
List <programListViewModel> classList = new List <programListViewModel>();
List <ClassModel> classes = db.classmodel.ToList();
List <StudentModels> students = db.studentModels.ToList();
List <CourseModels> courses = db.coursemodels.ToList();
List <ClassTaskJoinModel> tasks = db.classTask.ToList();
foreach (ClassModel _class in classes)
{
programListViewModel _thisClass = new programListViewModel();
_thisClass.studentCount = 0;
_thisClass.courseCount = 0;
_thisClass.taskCount = 0;
foreach (StudentModels student in students)
{
if (student.class_Id == _class.class_Id)
{
_thisClass.studentCount += 1;
}
}
foreach (CourseModels course in courses)
{
if (course.program_Id == _class.program_id)
{
_thisClass.courseCount += 1;
}
}
foreach (ClassTaskJoinModel _task in tasks)
{
if (_task.class_id == _class.class_Id)
{
_thisClass.taskCount += 1;
}
}
_thisClass._class = _class;
_thisClass.program = db.programModels.Find(_class.program_id);
classList.Add(_thisClass);
}
return(View(classList));
}
public ActionResult Index(string status)
{
if (this.User.IsInRole("Student"))
{
return(RedirectToAction("studentIndex", "Upload"));
}
List <programListViewModel> listViewModel = new List <programListViewModel>();
courseListViewModel courseModel = new courseListViewModel();
programListViewModel programListView = new programListViewModel();
List <GradeBookModel> grades = db.gradeBookModel.ToList();
List <ClassTaskJoinModel> joinTask = db.classTask.ToList();
List <ClassModel> classes = db.classmodel.ToList();
List <ProgramModels> programs = db.programModels.ToList();
List <CourseModels> courses = db.coursemodels.ToList();
foreach (ClassModel _class in classes)
{
programListView = new programListViewModel();
programListView._class = _class;
foreach (ProgramModels program in programs)
{
if (program.program_Id == _class.program_id)
{
programListView.program = program;
programListView.courses = new List <courseListViewModel>();
foreach (CourseModels course in courses)
{
courseModel = new courseListViewModel();
if (course.program_Id == program.program_Id)
{
courseModel.course = course;
courseModel.tasks = new List <taskListViewModel>();
foreach (ClassTaskJoinModel classTask in joinTask)
{
taskListViewModel newTask = new taskListViewModel();
newTask.grades = new List <GradeBookModel>();
if (classTask.class_id == _class.class_Id)
{
TaskModel task = db.taskModel.Find(classTask.task_id);
if (task.course_Id == course.course_Id)
{
task.TaskTypeModels = db.TaskTypeModels.Find(task.taskType_Id);
newTask.task = task;
foreach (GradeBookModel grade in grades)
{
if (grade.class_Id == _class.class_Id)
{
if (grade.task_Id == task.task_Id)
{
grade.StudentModels = db.studentModels.Find(grade.student_Id);
newTask.grades.Add(grade);
}
}
}
newTask.grades = newTask.grades.OrderBy(x => x.StudentModels.lName).ToList();
courseModel.tasks.Add(newTask);
}
}
}
courseModel.tasks = courseModel.tasks.OrderBy(x => x.task.TaskTypeModels.taskType).ToList();
programListView.courses.Add(courseModel);
}
}
listViewModel.Add(programListView);
}
}
}
return(View(listViewModel));
}
