Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public static string GetEmployeesInPeriod(SoftUniContext context)
- {
- StringBuilder sb = new StringBuilder();
- var employeesProjects = context.Employees
- .Where(e => e.EmployeesProjects
- .Any(ep => ep.Project.StartDate.Year >= 2001 && ep.Project.StartDate.Year <= 2003))
- .Take(10)
- .Select(e => new
- {
- e.FirstName,
- e.LastName,
- ManagerFirstName = e.Manager.FirstName,
- ManagerLastName = e.Manager.LastName,
- Projects = e.EmployeesProjects
- .Select(ep => ep.Project)
- })
- .ToList();
- foreach (var ep in employeesProjects)
- {
- sb.AppendLine($"{ep.FirstName} {ep.LastName} – Manager: {ep.ManagerFirstName} {ep.ManagerLastName}");
- foreach (var project in ep.Projects)
- {
- if (project.EndDate == null)
- {
- sb.AppendLine($"--{project.Name} - {project.StartDate.ToString("M/d/yyyy h:mm:ss tt")} - not finished");
- }
- else
- {
- sb.AppendLine($"--{project.Name} - {project.StartDate.ToString("M/d/yyyy h:mm:ss tt")} - {((DateTime)(project.EndDate)).ToString("M/d/yyyy h:mm:ss tt")}");//project.EndDate.Value.ToString("M/d/yyyy h:mm:ss tt") also works locally, but not in Judge!
- }
- }
- }
- return sb.ToString().TrimEnd();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement