private static void StudentsAndHomeworks(StudySystemContext context) { foreach (var student in context.Students) { Console.WriteLine($"{student.Name} write =>"); foreach (var content in student.Homeworks) { Console.WriteLine($"{content.Content} => {content.ContentType}"); } } }
private static void AllCourseWithMoreThan5Res(StudySystemContext context) { var courses = context.Courses.Where(course => course.Resources.Count > 5) .OrderByDescending(course => course.Resources.Count) .ThenByDescending(course => course.StartDate); foreach (var course in courses) { Console.WriteLine($"{course.Name} - {course.Resources.Count}"); } }
private static void AllCurseWithResource(StudySystemContext context) { var courses = context.Courses.OrderBy(course => course.StartDate).ThenByDescending(course => course.EndDate); foreach (var course in courses) { Console.WriteLine($"{course.Name} {course.Description}"); foreach (var resource in course.Resources) { Console.WriteLine($"--{resource.Name} {resource.Type} {resource.Url}"); } } }
private static void AllCourseInfo(StudySystemContext context) { var students = context.Students .OrderByDescending(student => student.Courses.Sum(course => course.Price)) .ThenByDescending(student => student.Courses.Count) .ThenBy(student => student.Name); foreach (var student in students) { if (student.Courses.Count != 0) { Console.WriteLine( $"{student.Name} - {student.Courses.Count} - {student.Courses.Sum(course => course.Price)} - {student.Courses.Average(course => course.Price)}"); } } }
static void Main(string[] args) { var context = new StudySystemContext(); context.Database.Initialize(true); //3.1 //StudentsAndHomeworks(context); //3.2 //AllCurseWithResource(context); //3.3 //AllCourseWithMoreThan5Res(context); //3.5 //AllCourseInfo(context); }