public ViewResult GetResultDetails(string yearTerm, string studentId) { double runningCgpaForEachStudent = 0; var rdb = new StudentsResultDbContext(); var yterId = _db.YearTerms.Single(m => m.YearTermName.Equals(yearTerm)).Id; ViewData["ExmainationDetails"] = from c in _db.Courses join r in _db.Results on c.CourseCode equals r.CourseCode join g in _db.Grades on r.GradeId equals g.GradeId join y in _db.YearTerms on r.YearTermId equals y.Id join s in _db.StudentInformations on r.StudentId equals s.StudentId join d in _db.Departments on s.DepartmentId equals d.DepartmentId where r.YearTermId.Equals(yterId) where r.StudentId.Equals(studentId) select new ExaminationDetailsViewMode { CourseCode = c.CourseCode, CourseTitle = c.CoursTitle, Credit = c.Credit, GradePoint = g.GradePoint, LetterGrade = g.LetterGrade }; ViewBag.studentName = _db.StudentInformations.Single(m => m.StudentId.Equals(studentId)).Name; ViewBag.studentID = studentId; var countYearTerm = rdb.StudentResultDetails.Where(m => m.StudentId.Equals(studentId)).Select(m => m.YearTermName).Count(); var sum = rdb.StudentResultDetails.Where(m => m.StudentId.Equals(studentId)).Select(m => m.Cgpa).Sum(); if (sum != null) { var totalCgpa = sum.Value; var runningTotal = totalCgpa / countYearTerm; runningCgpaForEachStudent += runningTotal; } ViewData["runningCGPA"] = runningCgpaForEachStudent; return View(); }
public ViewResult GetStudentResult(string studentId) { DisplayDepartmentSelectList(); var d = new StudentsResultDbContext(); ViewBag.yearTerms = new SelectList(_db.YearTerms, "YearTermName", "YearTermName"); return View(d.StudentResultDetails.Where(x=>x.StudentId.Equals(studentId)).ToList()); }