Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- static void Main()
- {
- var db = new SoftUniContext();
- using (db)
- {
- var emps = db.Employees
- .Where(e => e.EmployeesProjects.Any(
- ep => ep.Project.StartDate.Year >= 2001 &&
- ep.Project.StartDate.Year <= 2003))
- .Take(30)
- .Select(e => new
- {
- Name = $"{e.FirstName} {e.LastName}",
- ManagerName = $"{e.Manager.FirstName} {e.Manager.LastName}",
- Projects = e.EmployeesProjects.Select(ep => new {
- ep.Project.Name,
- ep.Project.StartDate,
- ep.Project.EndDate})
- })
- .ToList();
- foreach (var emp in emps)
- {
- Console.WriteLine($"{emp.Name} - Manager: {emp.ManagerName}");
- foreach (var pr in emp.Projects)
- {
- Console.Write($"--{pr.Name} - {pr.StartDate.ToString("M/d/yyyy h:mm:ss tt", CultureInfo.InvariantCulture)} - ");
- if (pr.EndDate == null)
- {
- Console.WriteLine("not finished");
- }
- else
- {
- Console.WriteLine(pr.EndDate.Value.ToString("M/d/yyyy h:mm:ss tt", CultureInfo.InvariantCulture));
- }
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement