public ActionResult SaveResult(StudentResultViewModel aStudentResultViewModel)
{
IEnumerable <Student> students = aStudentManager.GetAllStudent();
ViewBag.studentList = new SelectList(students, "Id", "RegNo");
List <Course> courses = new List <Course>();
ViewBag.courseList = new SelectList(courses, "Id", "Name");
string msg = aStudentManager.SaveResult(aStudentResultViewModel);
ViewBag.message = msg;
ModelState.Clear();
return(View(new StudentResultViewModel()));
}
public JsonResult GetResultByStudentId(Student student)
{
var studentEnrollCourseByStudentId = (from enrollCourse in db.CourseEnrolls
join courseN in db.Courses on enrollCourse.CourseId equals courseN.Id
where enrollCourse.StudentId == student.Id
select new
{
Id = courseN.Id,
Code = courseN.Code,
Name = courseN.Name
}).ToList();
List <StudentResultViewModel> aResultViewModels = new List <StudentResultViewModel>();
foreach (var data in studentEnrollCourseByStudentId)
{
StudentResultViewModel resultViewModel = new StudentResultViewModel();
resultViewModel.CourseCode = data.Code;
resultViewModel.Name = data.Name;
int courseId = data.Id;
var gradeLetterFind = (from studentR in db.StudentResults
join gradeLetter in db.Grades on studentR.GradeId equals gradeLetter.Id
where studentR.StudentId == student.Id && studentR.CourseId == courseId
select new
{
Name = gradeLetter.Name
}).FirstOrDefault();
if (gradeLetterFind == null)
{
resultViewModel.Grade = "Not Graded Yet";
}
else
{
resultViewModel.Grade = gradeLetterFind.Name;
}
aResultViewModels.Add(resultViewModel);
}
return(Json(aResultViewModels));
}
