Ejemplo n.º 1
0
        static void Main(string[] args)
        {
            StudentSystemDBContext context = new StudentSystemDBContext();
            //IEnumerable<Student> students = context.Students;
            //foreach (var student in students)
            //{
            //    Console.WriteLine($"{student.Name}");
            //    foreach (var homework in student.Homeworks)
            //    {
            //        Console.WriteLine($"{homework.Content},{homework.ContentType}");
            //    }
            //}

            //IEnumerable<Cours> courses = context.Courses;
            //foreach (var cours in courses.OrderBy(cours => cours.StartDate).ThenBy(c => c.EndDate))
            //{
            //    Console.WriteLine($"{cours.Name}, {cours.Description}");
            //    foreach (var resours in cours.Resourses)
            //    {
            //        Console.WriteLine($"{resours.Name}, {resours.ResourceType}, {resours.URL}");
            //    }
            //}

            //IEnumerable<Cours> courses = context.Courses
            //    .Where(c => c.Resourses.Count() > 5)
            //    .OrderByDescending(c => c.Resourses.Count())
            //    .ThenByDescending(c => c.StartDate);

            //foreach (var cours in courses)
            //{
            //    Console.WriteLine($"{cours.Name}, {cours.Resourses.Count()}");

            //}

            //IEnumerable<Cours> courses = context.Courses.Where(c => c.StartDate < DateTime.Now && c.EndDate > DateTime.Now);
            //foreach (var cours in courses)
            //{
            //    Console.WriteLine($"{cours.Name}, {cours.Students.Count()}");
            //}

            IEnumerable <Student> students = context.Students;

            foreach (var student in students.OrderBy(s => s.Courses.Max()))
            {
                decimal        totalPrice = 0.0M;
                List <decimal> avg        = new List <decimal>();
                foreach (var cours in student.Courses)
                {
                    totalPrice += cours.Price;
                    avg.Add(cours.Price);
                }

                Console.WriteLine($"{student.Name}, {student.Courses.Count()}, {totalPrice}, {avg.Average()}");
            }
        }
Ejemplo n.º 2
0
        private static void CoursesOnAGivenDate(StudentSystemDBContext context)
        {
            var date = context.Courses.Select(s => s.StartDate).OrderBy(x => x).Skip(2).FirstOrDefault();

            Console.WriteLine("Given date:" + date.ToString("dd/MM/yyyy"));
            var courses = context.Courses.Where(x => x.StartDate <date && x.EndDate> date).ToList();

            foreach (var course in courses.OrderByDescending(x => x.Students.Count).ThenByDescending(d => d.EndDate - d.StartDate))
            {
                Console.WriteLine($"Course name: {course.Name} Start: {course.StartDate.ToString("dd/MM/yyyy")} End: {course.EndDate.ToString("dd/MM/yyyy")} Duration {(course.EndDate - course.StartDate).Days} days Enrolled: {course.Students.Count}");
            }
        }
Ejemplo n.º 3
0
        private static void ListCoursesWithMoreThan5Resources(StudentSystemDBContext context)
        {
            var courses = context.Courses
                          .Where(x => x.Resources.Count > 5)
                          .OrderByDescending(j => j.Resources.Count)
                          .ThenByDescending(sd => sd.StartDate)
                          .ToList();

            foreach (var course in courses)
            {
                Console.WriteLine($"Course name: {course.Name} | Resource count: {course.Resources.Count}");
            }
        }
Ejemplo n.º 4
0
        private static void StudentStats(StudentSystemDBContext context)
        {
            var students = context.Students
                           .OrderByDescending(x => x.Courses.Sum(z => z.Price))
                           .ThenByDescending(c => c.Courses.Count)
                           .ThenBy(s => s.Name)
                           .ToList();

            Console.WriteLine($"Total students: {students.Count}");
            foreach (var student in students)
            {
                Console.WriteLine($"Name: {student.Name}, Courses: {student.Courses.Count}, Price: {student.Courses.Sum(x => x.Price)}, Average: {student.Courses.Average(a => a.Price)}");
            }
        }
Ejemplo n.º 5
0
        private static void ListAllCoursesWithResources(StudentSystemDBContext context)
        {
            var courses = context.Courses.ToList();

            foreach (var course in courses.OrderBy(x => x.StartDate).ThenByDescending(z => z.EndDate))
            {
                Console.WriteLine($"Course name: {course.Name}");
                Console.WriteLine($"Description: {course.Description}");
                Console.WriteLine("Resources:");
                foreach (var res in course.Resources)
                {
                    Console.WriteLine($"Name: {res.Name}, Type: {res.ResourceType}, Url: {res.URL}");
                }
            }
        }
Ejemplo n.º 6
0
        private static void ListAllStudentsAndHw(StudentSystemDBContext context)
        {
            var students = context.Students.ToList();

            foreach (var student in students)
            {
                Console.WriteLine($"Student name: {student.Name}");
                Console.WriteLine("Homework:");
                foreach (var hw in student.Homework)
                {
                    Console.WriteLine($"{hw.Content} - {hw.ContentType}");
                }
                Console.WriteLine(new string('-', 20));
            }
        }
Ejemplo n.º 7
0
        static void Main(string[] args)
        {
            Stopwatch stopwatch = new Stopwatch();

            stopwatch.Start();
            Console.WriteLine($"Started....");

            var context = new StudentSystemDBContext();

            context.Database.Initialize(true);//Read description first

            stopwatch.Stop();
            Console.WriteLine($"Finished!\nTime elapsed: {stopwatch.Elapsed.TotalMilliseconds} milliseconds");
            //Exercise 1 and 2:
            //The data in the seed method in the Configuration seeds the database with random data,
            //since the data is randomly generated it is 99.9 % sure that it will add it rather
            //then update it since the chances of dublicate values is slim to none.
            //If you don't want the random data you can always hardcore some data in the generator methods in Configuration.cs,
            //either way everything works with the data generation AddorUpdate


            //Exercise 3

            ////3.1
            //ListAllStudentsAndHw(context);

            ////3.2
            //ListAllCoursesWithResources(context);

            ////3.3
            //ListCoursesWithMoreThan5Resources(context);

            ////3.4
            //CoursesOnAGivenDate(context);

            ////3.5
            //StudentStats(context);

            //Exercise 4
            //You can take a look at Resource.cs License.cs and The Migration file.
            //There is also a handy diagram picture in the files.
        }