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
