Came accross this interview question for a backend C# developer position
Develop a .NET library assembly (DLL) for a system that handles the employee hierarchy, implemented as class Employees. This class has a constructor that takes a CSV string that contains all the employees from the company, the manager they report to, and the employee’s salary. Develop the library assembly that contains the code for the questions below. Make sure to provide unit tests for your code and an efficient solution.
Create a constructor that takes a CSV1 input string containing a list of employee info and validates the string. The first CSV column contains the id of the employee, the second one contains the id of the manager, and the third one contains the employee’s salary. The CEO of the company is the only employee that doesn't have a manager; in his case, the manager field will be empty. The list is not guaranteed to be sorted and can come in any random order. See the example below.
- Emplyee4,Employee2,500
- Employee3,Employee1,800
- Employee1,,1000
- Employee5,Employee1,500
- Employee2,Employee1,500
-
- The salaries in the CSV are valid integer numbers.
-
- One employee does not report to more than one manager.
-
- There is only one CEO, i.e. only one employee with no manager.
-
- There is no circular reference, i.e. a first employee reporting to a second employee that is also under the first employee. 5. There is no manager that is not an employee, i.e. all managers are also listed in the employee column.
Add an instance method that returns the salary budget from the specified manager. The salary budget from a manager is defined as the sum of the salaries of all the employees reporting (directly or indirectly) to a specified manager, plus the salary of the manager. See the example below.
- Input type: String
- Return type: long
1 In CSV (Comma Separated Values), each line corresponds to a row, and columns are separated by a comma.
Employee1 Employee2 Employee3 Employee4 Employee5 Input: Employee2 Result: 1800
Input: Employee3 Result: 500
Input: Employee1 Result: 3800
Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.
Please make sure to update tests as appropriate.