static void Main(string[] args)
{
var db = new SoftUniContext();
var projectId = 2;
using (db)
{
var empProject = db.EmployeesProjects
.Where(p => p.ProjectId == projectId);
foreach (var p in empProject)
{
db.EmployeesProjects.Remove(p);
}
var project = db.Projects.Find(2);
db.Remove(project);
db.SaveChanges();
var projectsResult = db.Projects
.Take(10)
.Select(p => p.Name);
foreach (var p in projectsResult)
{
Console.WriteLine(p);
}
}
}
public static string DeleteProjectById(SoftUniContext context)
{
StringBuilder sb = new StringBuilder();
const int ProjectToBeDeletedId = 2;
Project projectToBeDeleted = context.Projects.Find(ProjectToBeDeletedId);
List <EmployeeProject> employeeProjectsToBeDeleted = context
.EmployeesProjects
.Where(e => e.Project.ProjectId == ProjectToBeDeletedId)
.ToList();
context.EmployeesProjects.RemoveRange(employeeProjectsToBeDeleted);
context.SaveChanges();
context.Remove(projectToBeDeleted);
context.SaveChanges();
foreach (string projectName in context.Projects.Select(p => p.Name).Take(10))
{
Console.WriteLine(projectName);
}
return(sb.ToString());
}
static void Main()
{
string townInput = Console.ReadLine();
using (SoftUniContext context = new SoftUniContext())
{
var town = context.Towns.FirstOrDefault(t => t.Name == townInput);
var addresses = context.Addresses.Where(a => a.TownId == town.TownId).ToArray();
int deletedAddresses = addresses.Length;
foreach (var a in addresses)
{
var employees = context.Employees.Where(e => e.AddressId == a.AddressId);
foreach (var e in employees)
{
e.AddressId = null;
}
}
context.RemoveRange(addresses);
context.Remove(town);
context.SaveChanges();
string address = deletedAddresses == 1 ? "address" : "addresses";
string wasOrWere = deletedAddresses == 1 ? "was" : "were";
Console.WriteLine($"{deletedAddresses} {address} in {townInput} {wasOrWere} deleted");
}
}
public static string DeleteProjectById(SoftUniContext context)
{
StringBuilder output = new StringBuilder();
var projectToDelete = context.Projects.First(p => p.ProjectId == 2);
var employeeProjectsRecords = context.EmployeesProjects.Where(ep => ep.ProjectId == 2);
context.RemoveRange(employeeProjectsRecords);
context.SaveChanges();
context.Remove(projectToDelete);
context.SaveChanges();
var projectsNames = context.Projects.Take(10).Select(p => p.Name).ToList();
foreach (var projectName in projectsNames)
{
output.AppendLine(projectName);
}
return(output.ToString().TrimEnd());
}
private static void RemoveTown(SoftUniContext context, int townId)
{
var town = context.Towns
.Find(townId);
context.Remove(town);
}
static void Main()
{
using (SoftUniContext context = new SoftUniContext())
{
string townName = Console.ReadLine();
Town town = context.Towns.FirstOrDefault(t => t.Name == townName);
List <Address> addresses = context.Addresses
.Include(a => a.Employees)
.Where(a => a.TownId == town.TownId)
.ToList();
addresses.ForEach(a =>
{
a.Employees.ToList().ForEach(e => e.AddressId = null);
a.Employees.Clear();
});
context.RemoveRange(addresses);
context.Remove(town);
context.SaveChanges();
Console.WriteLine("{0} address in {1} was deleted", addresses.Count(), townName);
//ss
}
}
public static string RemoveTown(SoftUniContext context)
{
var sb = new StringBuilder();
using (context)
{
var employees = context.Employees.Where(x => x.Address.Town.Name == "Snohomish");
foreach (var employee in employees)
{
employee.AddressId = null;
}
var town = context.Towns.FirstOrDefault(x => x.Name == "Snohomish");
var adresses = context.Addresses.Where(x => x.Town.Name == "Snohomish");
int count = adresses.Count();
context.Addresses.RemoveRange(adresses);
context.Remove(town);
context.SaveChanges();
sb.AppendLine($"{count} addresses in Kent were deleted");
}
return(sb.ToString().TrimEnd());
}
static void Main()
{
//var result = GetTownData();
//
//foreach (var item in result)
//{
// Console.WriteLine(item);
//}
//using var db = new SoftUniContext();
//
//var result = db.Employees
// //.Select(e => new { Name = e.FirstName + " " + e.LastName, Department = e.Department.Name })
// .Select(e => new EmployeeResultModel { Name = e.FirstName + " " + e.LastName, Department = e.Department.Name })
// .Skip(5)
// .Take(10)
// .ToList();
//
//foreach (var item in result)
//{
// Console.WriteLine($"{item.Name} {item.Department}");
//}
using var db = new SoftUniContext();
//var town = new Town { Name = "New Town" };
//town.Addresses.Add(new Addresses { AddressText = "Rio" });
//db.Add(town);
//var town = new Town { TownId = 33, Name = "Even Newer Town" };
//
//db.Update(town);
//var town = db.Towns.Find(33);
//
//town.Name = "Old Town";
//db.Towns.Remove(new Town { TownId = 33 });
//var town = db.Towns.Find(33);
var town = db.Towns
.Select(t => new { t.TownId, Addresses = t.Addresses.Select(a => a.AddressId) })
.FirstOrDefault(t => t.TownId == 33);
foreach (var item in town.Addresses)
{
db.Addresses.Remove(new Addresses {
AddressId = item
});
}
db.Remove(new Town {
TownId = town.TownId
});
db.SaveChanges();
}
static void Main()
{
using (SoftUniContext context = new SoftUniContext())
{
Project project = context.Projects.Find(2);
IEnumerable <EmployeesProject> employeesProjects = context.EmployeesProjects.Where(ep => ep.ProjectId == 2);
context.RemoveRange(employeesProjects);
context.Remove(project);
context.SaveChanges();
context.Projects.Take(10).ToList().ForEach(p => Console.WriteLine(p.Name));
}
}
public static void Main(string[] args)
{
using (var db = new SoftUniContext())
{
var projectToBeDeleted = db.Projects.FirstOrDefault(p => p.ProjectId == 2);
db.RemoveRange(db.EmployeesProjects
.Where(ep => ep.ProjectId == 2));
db.Remove(projectToBeDeleted);
db.SaveChanges();
db.Projects
.Select(p => p.Name)
.Take(10)
.ToList()
.ForEach(p => FileWriter.WriteLine($"{p}"));
}
}
static void Main(string[] args)
{
using (SoftUniContext db = new SoftUniContext())
{
var projectToDelete = db.Projects.FirstOrDefault(p => p.ProjectId == 2);
db.RemoveRange(db.EmployeesProjects
.Where(ep => ep.ProjectId == 2));
db.Remove(projectToDelete);
db.SaveChanges();
using (StreamWriter Writer = new StreamWriter(@"..\..\..\result.txt"))
{
foreach (var project in db.Projects.Take(10))
{
Writer.WriteLine($"{project.Name}");
}
}
}
}
public static void Main()
{
SoftUniContext db = new SoftUniContext();
using (db)
{
const int ProjectToBeDeletedId = 2;
Project projectToBeDeleted = db.Projects.Find(ProjectToBeDeletedId);
List <EmployeeProject> employeeProjectsToBeDeleted = db.EmployeesProjects.Where(ep => ep.Project.ProjectId == ProjectToBeDeletedId).ToList();
db.EmployeesProjects.RemoveRange(employeeProjectsToBeDeleted);
db.SaveChanges();
db.Remove(projectToBeDeleted);
db.SaveChanges();
foreach (string projectName in db.Projects.Select(p => p.Name).Take(10))
{
Console.WriteLine(projectName);
}
}
}