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