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 List <Students> ReadAllStudent()
{
List <Students> students = new List <Students>();
using (Kita1205GradesEntities gradesEntities = new Kita1205GradesEntities())
{
students = (from s in gradesEntities.Students
select s).ToList();
}
return(students);
}
public List <Grades> ReadAllGrades()
{
List <Grades> grades = new List <Grades>();
using (Kita1205GradesEntities gradesEntities = new Kita1205GradesEntities())
{
grades = (from g in gradesEntities.Grades
select g).ToList();
}
return(grades);
}
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();
}
}
public void UpdateCoursesMaxGrade()
{
int maxGrade = 0;
List <int> maxGrades = 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)
{
//start with maximal grade = 0
maxGrade = 0;
foreach (var c in CourseGroup)
{
if (c.Grades1 > maxGrade)
{
maxGrade = (int)c.Grades1;
}
}
maxGrades.Add(maxGrade);
}
List <Courses> courses = (from c in gradesEntities.Courses
select c).ToList();
for (int i = 0; i < maxGrades.Count; i++)
{
courses[i].Highest_Grade = (int)maxGrades[i];
gradesEntities.SaveChanges();
}
gradesEntities.SaveChanges();
}
}