public static string AddNewAddressToEmployee(SoftUniContext context) { var address = new Models.Address { AddressText = "Vitoshka 15", TownId = 4 }; var employee = context.Employees.First(e => e.LastName == "Nakov"); employee.Address = address; context.SaveChanges(); var addresses = context.Employees .Select(e => new { e.Address.AddressId, e.Address.AddressText }) .OrderByDescending(a => a.AddressId) .Take(10) .ToList(); StringBuilder sb = new StringBuilder(); foreach (var adr in addresses) { sb.AppendLine(adr.AddressText); } return(sb.ToString().TrimEnd()); }
//Task6 public static string AddNewAddressToEmployee(SoftUniContext context) { StringBuilder result = new StringBuilder(); var newAddress = new Models.Address { AddressText = "Vitoshka 15", TownId = 14 }; context.Addresses.Add(newAddress); var employeeToUpdate = context.Employees. FirstOrDefault(e => e.LastName == "Nakov"); employeeToUpdate.Address = newAddress; context.SaveChanges(); var addresses = context.Addresses .OrderByDescending(a => a.AddressId) .Select(a => a.AddressText) .Take(10); foreach (var address in addresses) { result.AppendLine(address); } return(result.ToString().TrimEnd()); }