private static void AddingNewAddress(SoftuniContext context)//6 { //option 1 Address address = new Address(); address.AddressText = "Vitoshka 15"; address.AddressID = 4; context.Addresses.Add(address); context.SaveChanges(); Employee emp = context.Employees.FirstOrDefault(e => e.LastName == "Nakov"); emp.Address = address; context.SaveChanges(); var addresses = context.Employees.OrderByDescending(e => e.AddressID) .Take(10) .ToList(); //option 2 // Address newAddress = new Address() // { // AddressText = "Vitoshka 15", // TownID = 4 // }; // Employee employee = null; // employee = context.Employees // .Where(e => e.LastName == "Nakov") // .FirstOrDefault(); // employee.Address = newAddress; // context.SaveChanges(); // List<string> employeesNewAddress = context.Employees // .OrderByDescending(e => e.AddressID) // .Take(10) // .Select(e => e.Address.AddressText) // .ToList(); // foreach (var oneAddress in employeesNewAddress) // { // Console.WriteLine(oneAddress); // } }
}//14 private static void DeleteProjectById(SoftuniContext context)//15 { var project = context.Projects.Find(2); foreach (var oneEmployee in project.Employees) { oneEmployee.Projects.Remove(project); } context.Projects.Remove(project); context.SaveChanges(); List <Project> projects = context.Projects .Take(10) .ToList(); foreach (var oneProject in projects) { Console.WriteLine(oneProject.Name); } }//15
}//15 private static void RemoveTowns(SoftuniContext context)//16 {// to do check Console.Write("Enter town to delete: "); string town = Console.ReadLine(); Town tn = context.Towns .Where(t => t.Name == town) .FirstOrDefault(); List <Address> addrs = context.Addresses .Where(a => a.Town.Name == town) .ToList(); context.Towns.Remove(tn); foreach (Address a in addrs) { List <Employee> empls = context.Employees .Where(e => e.AddressID == a.AddressID) .ToList(); foreach (Employee e in empls) { e.AddressID = null; } context.Addresses.Remove(a); } context.SaveChanges(); if (addrs.Count == 1) { Console.WriteLine($"{addrs.Count} " + $"address in {town} was deleted"); } else { Console.WriteLine($"{addrs.Count} " + $"addresses in {town} were deleted"); } }//16