Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public static string GetDepartmentsWithMoreThan5Employees(SoftUniContext context)
- {
- var neededDepartments = context.Departments
- .Where(x => x.Employees.Count > 5)
- .OrderBy(x => x.Employees.Count)
- .ThenBy(x => x.Name)
- .Select(y => new
- {
- departmentName = y.Name,
- managerFirstName = y.Manager.FirstName,
- managerLastName = y.Manager.LastName,
- employees = y.Employees
- .Select(z => new
- {
- employeeFirstName = z.FirstName,
- employeeLastName = z.LastName,
- employeeJobTitle = z.JobTitle,
- })
- .OrderBy(z => z.employeeFirstName)
- .ThenBy(z => z.employeeLastName)
- .ToList()
- })
- .ToList();
- StringBuilder sb = new StringBuilder();
- foreach (var department in neededDepartments)
- {
- sb.AppendLine($"{department.departmentName} - {department.managerFirstName} {department.managerLastName}");
- foreach (var employee in department.employees)
- {
- sb.AppendLine($"{employee.employeeFirstName} {employee.employeeLastName} - {employee.employeeJobTitle}");
- }
- }
- return sb.ToString().TrimEnd();
- }
Advertisement
RAW Paste Data
Copied
Advertisement