// GET: Students/Create
public ActionResult Create()
{
ViewBag.DepartmentId = new SelectList(_departmentBusiness.GetAll(), "DepartmentId", "DeptName");
ViewBag.SemesterId = new SelectList(_semesterBusiness.GetAll(), "SemesterId", "SemesterName");
ViewBag.SeassonId = new SelectList(_seassonBusiness.GetAll(), "SeassonId", "SeassonName");
return(View());
}
public JsonResult GetAllSmesterResultByStudentId(int studentId)
{
List <dynamic> result = new List <dynamic>();
var semesters = _semesterBusiness.GetAll();
foreach (var semester in semesters)
{
dynamic cgpa;
float sumOfSgpa = 0;
int increment = 0;
dynamic totalGpa = 0;
var sumOfsubGpa = (float)_studentResultBusiness
.GetAll()
.Where(x => x.StudentId == studentId && x.Student.Semester.SemesterId == semester.SemesterId).Sum(x => x.Gpa);
var totalcourse =
_studentResultBusiness
.GetAll()
.Where(x => x.StudentId == studentId && x.Student.Semester.SemesterId == semester.SemesterId).Select(x => x.CourseId).Count();
if (sumOfsubGpa > 0)
{
increment++;
cgpa = sumOfsubGpa / totalcourse;
sumOfSgpa += cgpa;
}
else
{
cgpa = "Yet to complete";
}
if (increment == 8)
{
totalGpa = sumOfSgpa / 8;
}
else
{
totalGpa = "Yet To Complete";
}
string studentName =
_studentBusiness.GetAll()
.Where(x => x.StudentId == studentId)
.Select(x => x.StudentName)
.FirstOrDefault();
var demo = new { semester = semester.SemesterName, cgpa = cgpa, studentName = studentName, totalGpa = totalGpa };
result.Add(demo);
}
return(Json(result, JsonRequestBehavior.AllowGet));
}