public ActionResult aggregateRatings()
{
var userId = User.Identity.GetUserId();
EducationForAll db = new EducationForAll();
var instructorId = db.Instructors.Where(x => x.user_id == userId).Select(x => x.InstructorId).FirstOrDefault();
var courseList = db.Courses.Where(x => x.InstructorUser_id == instructorId).Select(x => x.CourseName).ToList();
aggregateRatings rating = new aggregateRatings();
rating.courseList = courseList;
return(View(rating));
}
public ActionResult aggregateRatings1(WebApplication1.Models.aggregateRatings agrremodel, string submitButton)
{
if (submitButton == "ShowRatingsStatistics")
{
EducationForAll db = new EducationForAll();
aggregateRatings rating = new aggregateRatings();
var courseId = db.Courses.Where(x => x.CourseName == agrremodel.selectedCourse).FirstOrDefault();
var reviewList = db.Reviews.Where(x => x.CourseId == courseId.CourseId).Select(x => x.ReviewStar).ToList();
int highestRatings = reviewList.Max();
int lowestRatings = reviewList.Min();
double averageRatings = reviewList.Average();
rating.highestRating = highestRatings;
rating.lowestRating = lowestRatings;
rating.averagerating = Math.Round(averageRatings);
rating.selectedCourse = agrremodel.selectedCourse;
ViewBag.rating = rating;
return(View());
}
else
{
int count1 = 0;
int count2 = 0;
int count3 = 0;
int count4 = 0;
int count5 = 0;
EducationForAll db = new EducationForAll();
var courseId = db.Courses.Where(x => x.CourseName == agrremodel.selectedCourse).FirstOrDefault();
var reviewList = db.Reviews.Where(x => x.CourseId == courseId.CourseId).Select(x => x.ReviewStar).ToList();
foreach (var review in reviewList)
{
if (review == 1)
{
count1++;
}
if (review == 2)
{
count2++;
}
if (review == 3)
{
count3++;
}
if (review == 4)
{
count4++;
}
if (review == 5)
{
count5++;
}
}
List <DataPoint> dataPoints = new List <DataPoint>();
dataPoints.Add(new DataPoint("Rating 1", count1));
dataPoints.Add(new DataPoint("Rating 2", count2));
dataPoints.Add(new DataPoint("Rating 3", count3));
dataPoints.Add(new DataPoint("Rating 4", count4));
dataPoints.Add(new DataPoint("Rating 5", count5));
TempData["doc"] = dataPoints;
return(RedirectToAction("ViewGraph", "Instructor"));
}
}