Advertisement
StoyanGrigorov

3.4

Mar 8th, 2017
179
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.79 KB | None | 0 0
  1.         private static void CoursesOnAGivenDate(StudentSystemDBContext context)
  2.         {
  3.             var date = context.Courses.Select(s => s.StartDate).OrderBy(x => x).Skip(2).FirstOrDefault();
  4.             Console.WriteLine("Given date:" + date.ToString("dd/MM/yyyy"));
  5.             var courses = context.Courses.Where(x => x.StartDate < date && x.EndDate > date).ToList();
  6.  
  7.             foreach (var course in courses.OrderByDescending(x => x.Students.Count).ThenByDescending(d => d.EndDate - d.StartDate))
  8.             {
  9.                 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}");
  10.             }
  11.         }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement