petarkobakov

Adding a New Address and Updating Employee

Feb 25th, 2021
105
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.92 KB | None | 0 0
  1. public static string AddNewAddressToEmployee(SoftUniContext context)
  2. {
  3.  
  4.  
  5.  
  6. var nakov = context.Employees.FirstOrDefault(e=>e.LastName == "Nakov");
  7. nakov.Address = new Address
  8. {
  9. AddressText = "Vitosha 15",
  10. TownId = 4,
  11. };
  12.  
  13. context.SaveChanges();
  14.  
  15. var addresses = context.Employees
  16. .Select(e => new
  17. {
  18. e.Address.AddressText,
  19. e.Address.AddressId
  20. })
  21. .OrderByDescending(a=>a.AddressId)
  22. .Take(10)
  23. .ToList();
  24.  
  25. var sb = new StringBuilder();
  26.  
  27. foreach (var currentAddress in addresses)
  28. {
  29. sb.AppendLine($"{currentAddress.AddressText}");
  30. }
  31.  
  32. return sb.ToString().Trim();
  33.  
  34. }
Advertisement
Add Comment
Please, Sign In to add comment