// Calculate average salary of employees having the specified supervisor
static decimal AverageSalary(Context context, string supervisor)
{
var avg = context.Employees
.Where(m => m.Supervisor.Name.Equals(supervisor));
return avg.Average(m => m.Position.Salary);
}
// Remove all employees occupying the specified position and the position itself
static void RemovePosition(Context context, string position)
{
var s = context.Positions
.Where(m => m.Name.Equals(position));
foreach (var item in s)
{
context.Positions.Remove(item);
}
}
// Change salary of all employees holding the specified position by delta
static void ChangeSalary(Context context, string position, decimal delta)
{
var selectedEmployees = context.Employees
.Where(m => m.Position.Equals(position));
foreach (var pos in selectedEmployees)
{
pos.Position.Salary += delta;
}
}
static void Main(string[] args)
{
using (var c = new Context())
{
ChangeSalary(c, "Engineer", 3000);
c.Employees.ToList();
c.SaveChanges();
}
//ShowEmployees(data);
}
static IQueryable<EmployeeRecord> LoadEmployeesFromDB(Context context)
{
throw new NotImplementedException();
}