// 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(); }