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