problem7 ef databasefirst

           // 07
            string ifNull = "not finished";
            string formatTime = "M/d/yyyy h:mm:ss tt";
            var employees = softuni.Employees.Where(e => e.EmployeeProjects.Any(p =>
                    p.Project.StartDate.Year >= 2001 && p.Project.StartDate.Year <= 2003))
                .Take(30)
                .Select(e => new
                {
                    name = $"{e.FirstName} {e.LastName}",
                    managerName = $"{e.Manager.FirstName} {e.Manager.LastName}",
                    projects = e.EmployeeProjects.Select(ep => new
                    {
                        ep.Project.Name,
                        ep.Project.StartDate,
                        ep.Project.EndDate
                    })
                })
                .ToArray();

            foreach (var em in employees)
            {

                Console.WriteLine($"{em.name} - Manager: {em.managerName}");
                foreach (var p in em.projects)
                {

                    string endTime = p.EndDate.HasValue ? p.EndDate.Value.ToString(formatTime) : ifNull;
                    Console.WriteLine($"--{p.Name} - {p.StartDate.ToString(formatTime)} - {endTime}");
                }
            }