private static void FindEmployeesByFirstName(SoftuniContext context)
{
var employees = context
.Employees.Where(e =>
e.Department.Name == "Engineering" ||
e.Department.Name == "Tool Design" ||
e.Department.Name == "Marketing" ||
e.Department.Name == "Information Services").ToList();
foreach (var employee in employees)
{
employee.Salary *= 1.12m;
}
context.SaveChanges();
foreach (var employee in employees)
{
Console.WriteLine($"{employee.FirstName} {employee.LastName} (${employee.Salary})");
}
}
private static void AddingNewAddressAndUpdatingEmployee(SoftuniContext context)
{
var address = new Address()
{
AddressText = "Vitoshka 15",
TownID = 4
};
var nakov = context.Employees.Where(e => e.LastName == "Nakov").FirstOrDefault();
nakov.Address = address;
context.SaveChanges();
var addresses = context.Employees
.OrderByDescending(e => e.AddressID)
.Select(e => e.Address.AddressText)
.Take(10);
foreach (var a in addresses)
{
Console.WriteLine(a);
}
}
