public void UpdateCoursesNumOfStudents() { List <int> numOfStudents = new List <int>(); using (Kita1205GradesEntities gradesEntities = new Kita1205GradesEntities()) { var allCoursesGrouped = (from g in gradesEntities.Grades group g by g.Course_ID).ToList(); foreach (var CourseGroup in allCoursesGrouped) { numOfStudents.Add(CourseGroup.Count()); } List <Courses> courses = (from c in gradesEntities.Courses select c).ToList(); for (int i = 0; i < numOfStudents.Count; i++) { courses[i].Num_Of_Students = numOfStudents[i]; gradesEntities.SaveChanges(); } gradesEntities.SaveChanges(); } }
public void UpdateCoursesAvgGrade() { int average = 0; List <double> avg_s = new List <double>(); using (Kita1205GradesEntities gradesEntities = new Kita1205GradesEntities()) { var allCoursesGrouped = (from g in gradesEntities.Grades group g by g.Course_ID).ToList(); foreach (var CourseGroup in allCoursesGrouped) { //starting the count of grades average = 0; //Console.WriteLine("Course Group: {0}", CourseGroup.Key); //Each group has a key foreach (var c in CourseGroup) // Each group has inner collection { //Console.WriteLine("Course Grade: {0}", c.Grades1); average += (int)c.Grades1; } avg_s.Add(average / CourseGroup.Count()); //Console.WriteLine($"Average is: {average / CourseGroup.Count()}"); //Console.WriteLine(); } List <Courses> courses = (from c in gradesEntities.Courses select c).ToList(); for (int i = 0; i < avg_s.Count; i++) { courses[i].Avg_Grade = (decimal)avg_s[i]; gradesEntities.SaveChanges(); } gradesEntities.SaveChanges(); } }