GradeManager.cs

using Individuellt_databasprojekt.Data;
using Microsoft.EntityFrameworkCore;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Individuellt_databasprojekt
{
    public class GradeManager
    {
        public static void DisplayGradesFromLastMonth()
        {
            using (var context = new SchoolContext())
            {
                DateTime lastMonth = DateTime.Now.AddDays(-30); 

                
                var grades = context.Grades
                    .Include(g => g.Student) 
                    .Include(g => g.Course)
                    .Include(g => g.Staff)
                    .Where(g => g.Date.ToDateTime(TimeOnly.MinValue) > lastMonth) 
                    .ToList();

                if (!grades.Any())
                {
                    Console.WriteLine("No grades set in the last month.");
                }
                else
                {
                    foreach (var grade in grades)
                    {
                        Console.WriteLine($"{grade.Student.FirstName} {grade.Student.LastName} - " +
                                          $"{grade.Course.CourseName}: {grade.Value}. " +
                                          $"Graded on {grade.Date:yyyy-MM-dd}");
                    }
                }
            }

            Console.WriteLine("\nPress any key to continue...");
            Console.ReadLine();
            Console.Clear();
        }


        //Show all active courses 
        public static void DisplayActiveCourses()
        {
            using (var context = new SchoolContext())
            {
                
                var activeCourses = context.Courses
                    .Where(c => c.IsActive)
                    .ToList();

                if (activeCourses.Any())
                {
                    Console.WriteLine("List of active courses:");
                    foreach (var course in activeCourses)
                    {
                        Console.WriteLine($"Course ID: {course.CourseId}, Name: {course.CourseName}");
                    }
                }
                else
                {
                    Console.WriteLine("No active courses found.");
                }
            }

            Console.WriteLine("\nPress any key to continue...");
            Console.ReadLine();
            Console.Clear();
        }

    }
}