public static string DeleteProjectById(SoftuniContext context)
{
StringBuilder result = new StringBuilder();
var project = context.Projects.Find(2);
var employees = project.Employees;
foreach (Employee employee in employees)
{
employee.Projects.Remove(project);
}
context.SaveChanges();
context.Projects.Remove(project);
context.SaveChanges();
var projects = context.Projects.Take(10).Select(project1 => project1.Name);
foreach (string proj in projects)
{
result.AppendLine(proj);
}
return(result.ToString());
}
public static string IncreaseSalaries(SoftuniContext context)
{
StringBuilder result = new StringBuilder();
var employees = context.Employees.Where(employee =>
employee.Department.Name == "Engineering" ||
employee.Department.Name == "Tool Design" ||
employee.Department.Name == "Marketing" ||
employee.Department.Name == "Information Services");
foreach (var employee in employees)
{
employee.Salary *= 1.12m;
result.AppendLine($"{employee.FirstName} {employee.LastName} (${employee.Salary})");
}
context.SaveChanges();
return(result.ToString());
}
public static string AddingNewAddressAndUpdatingEmployee(SoftuniContext context)
{
StringBuilder result = new StringBuilder();
var address = new Address()
{
AddressText = "Vitoshka 15", TownID = 4
};
var nakovEmployee = context.Employees.First(employee => employee.LastName == "Nakov");
nakovEmployee.Address = address;
context.SaveChanges();
var employeeAddresses = context.Employees
.OrderByDescending(employee => employee.Address.AddressID)
.Take(10)
.Select(employee => employee.Address.AddressText);
foreach (string employeeAddress in employeeAddresses)
{
result.AppendLine(employeeAddress);
}
return(result.ToString());
}
