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)); }