Categories
C#: Employees Management
Date
Author
Given a list of data, implement the following 3 methods using LINQ in a class that allows for managing employees:
- AverageAgeForEachCompany – calculates the average age of employees for each unique company and returns the results as a Dictionary<string, int> sorted by key, where Key[string] is the unique company name, and Value[int] is the average age of employees in this company. The average age is rounded to the nearest whole number.
- CountOfEmployeesForEachCompany – calculates the count of employees for each unique company and returns the results as a Dictionary<string, int> sorted by key, where Key[string] is the unique company name, and Value[int] is the count of employees in this company.
- OldestAgeForEachCompany – finds the oldest aged employee for each unique company and returns the results as a Dictionary<string, Employee> sorted by key, where Key[string] is the unique company name, and Value[Employee] is the oldest employee in this company.
Here is the description of the Employee class:
- FirstName [string] – the first name of the employee.
- LastName[string] – the last name of the employee.
- Company [string] – the company of the employee.
- Age [int] – the age of the employee.
Your implementation of the class will be tested by a stubbed code on several input files. The input file contains parameters for the function calls (i.e., the employee data). The functions will be called with those parameters, and the result of their executions will be printed to the standard output by the stubbed code.
Input Format For Custom Testing
The first line contains an integer, n, denoting the number of employees on which operations have to be performed.
Each line i of the n subsequent lines (where 0 ≤ i < n) contains space-separated strings, such that the first of them is the first name of the employee, the second is the last name of the employee, the third is the company of the employee, and the fourth is the age of the employee, respectively.
Sample Case 0
Sample Input For Custom Testing
12 Ainslee Ginsie Galaxy 28 Libbey Apdell Starbucks 44 Illa Stebbings Berkshire 49 Laina Sycamore Berkshire 20 Abbe Parnell Amazon 20 Ludovika Reveley Berkshire 30 Rene Antos Galaxy 44 Vinson Beckenham Berkshire 45 Reed Lynock Amazon 41 Wyndham Bamfield Berkshire 34 Loraine Sappson Amazon 49 Abbe Antonutti Starbucks 47
Sample Output
The average age for company Amazon is 37 The average age for company Berkshire is 36 The average age for company Galaxy is 36 The average age for company Starbucks is 46 The count of employees for company Amazon is 3 The count of employees for company Berkshire is 5 The count of employees for company Galaxy is 2 The count of employees for company Starbucks is 2 The oldest employee of company Amazon is Loraine Sappson having age 49 The oldest employee of company Berkshire is Illa Stebbings having age 49 The oldest employee of company Galaxy is Rene Antos having age 44 The oldest employee of company Starbucks is Abbe Antonutti having age 47
Explanation
Here, 12 employees are presented with their details (first name, last name, company name, and age). Then, based on that data, the 3 methods are called: AverageAgeForEachCompany, CountOfEmployeesForEachCompany, and OldestAgeForEachCompany. The result obtained from these 3 function calls is printed to the standard output.
Sample Case 1
Sample Input For Custom Testing
12 Sybila Fulle Kimberly 24 Scarface Stork Tesla 22 Ashli Crosseland Kimberly 36 Allene Stebbings Galaxy 19 Valentin Harbert Amazon 28 Gracie Pappin Tesla 44 Sadye Orcott Rockwell 30 Timoteo Pook Amazon 35 Marris Apdell Rockwell 43 Pen Ghilardini Rockwell 38 Bern Aizikov Rockwell 20 Sela Farrier Amazon 47
Sample Output
The average age for company Amazon is 37 The average age for company Galaxy is 19 The average age for company Kimberly is 30 The average age for company Rockwell is 33 The average age for company Tesla is 33 The count of employees for company Amazon is 3 The count of employees for company Galaxy is 1 The count of employees for company Kimberly is 2 The count of employees for company Rockwell is 4 The count of employees for company Tesla is 2 The oldest employee of company Amazon is Sela Farrier having age 47 The oldest employee of company Galaxy is Allene Stebbings having age 19 The oldest employee of company Kimberly is Ashli Crosseland having age 36 The oldest employee of company Rockwell is Marris Apdell having age 43 The oldest employee of company Tesla is Gracie Pappin having age 44
Explanation
Here, 12 employees are presented with their details (first name, last name, company name, and age). Then, based on that data, the 3 methods are called: AverageAgeForEachCompany, CountOfEmployeesForEachCompany, and OldestAgeForEachCompany. The result obtained from these 3 function calls is printed to the standard output.
SOLUTION:
using System;
using System.Collections.Generic;
using System.Linq;
namespace Solution
{
public class Solution
{
public static Dictionary<string, int> AverageAgeForEachCompany(List<Employee> employees)
{
var result = employees.GroupBy(e => e.Company)
.ToDictionary(g => g.Key, g => (int)Math.Round(g.Average(e => e.Age)));
return result;
}
public static Dictionary<string, int> CountOfEmployeesForEachCompany(List<Employee> employees)
{
var result = employees.GroupBy(e => e.Company)
.ToDictionary(g => g.Key, g => g.Count());
return result;
}
public static Dictionary<string, Employee> OldestAgeForEachCompany(List<Employee> employees)
{
var result = employees.GroupBy(e => e.Company)
.ToDictionary(g => g.Key, g => g.OrderByDescending(e => e.Age).First());
return result;
}
public static void Main()
{
int countOfEmployees = int.Parse(Console.ReadLine());
var employees = new List<Employee>();
for (int i = 0; i < countOfEmployees; i++)
{
string str = Console.ReadLine();
string[] strArr = str.Split(' ');
employees.Add(new Employee
{
FirstName = strArr[0],
LastName = strArr[1],
Company = strArr[2],
Age = int.Parse(strArr[3])
});
}
var sortedCompanies = employees.Select(e => e.Company).Distinct().OrderBy(c => c);
var averageAges = AverageAgeForEachCompany(employees);
var counts = CountOfEmployeesForEachCompany(employees);
var oldestEmployees = OldestAgeForEachCompany(employees);
foreach (var company in sortedCompanies)
{
Console.WriteLine($"The average age for company {company} is {averageAges[company]}");
}
foreach (var company in sortedCompanies)
{
Console.WriteLine($"The count of employees for company {company} is {counts[company]}");
}
foreach (var company in sortedCompanies)
{
var employee = oldestEmployees[company];
Console.WriteLine($"The oldest employee of company {company} is {employee.FirstName} {employee.LastName} having age {employee.Age}");
}
}
}
public class Employee
{
public string FirstName { get; set; }
public string LastName { get; set; }
public int Age { get; set; }
public string Company { get; set; }
}
}