public static void Main(string[] args)
{
using (var context = new SoftUniContext())
{
var projToDelete = context.Projects.Find(2);
var empProjects = context.EmployeesProjects.Where(ep => ep.ProjectId == 2);
context.EmployeesProjects.RemoveRange(empProjects);
context.Projects.Remove(projToDelete);
context.SaveChanges();
var First10Projects = context.Projects
.Select(p => new
{
p.Name
})
.Take(10);
foreach (var proj in First10Projects)
{
Console.WriteLine(proj.Name);
}
}
}
public static void Main(string[] args)
{
using (var context = new SoftUniContext())
{
var townName = Console.ReadLine();
var adressesInTown = context.Addresses
.Where(a => a.Town.Name.Equals(townName)).ToArray();
var deletedAddresses = 0;
foreach (var address in adressesInTown)
{
var employeesOnAddress = context.Employees
.Where(e => e.Address.AddressId == address.AddressId);
foreach (var employee in employeesOnAddress)
{
employee.AddressId = null;
}
context.Addresses.Remove(address);
deletedAddresses++;
}
var town = context.Towns.FirstOrDefault(t => t.Name.Equals(townName));
context.Towns.Remove(town);
context.SaveChanges();
Console.WriteLine($"{deletedAddresses} address in {townName} was deleted");
}
}
public static void Main()
{
using (var context = new SoftUniContext())
{
string townName = Console.ReadLine();
context.Employees
.Where(e => e.Address.Town.Name == townName)
.ToList()
.ForEach(e => e.AddressId = null);
int addressesCount = context.Addresses
.Where(a => a.Town.Name == townName)
.Count();
context.Addresses
.Where(a => a.Town.Name == townName)
.ToList()
.ForEach(a => context.Addresses.Remove(a));
context.Towns
.Remove(context.Towns
.SingleOrDefault(t => t.Name == townName));
context.SaveChanges();
Console.WriteLine($"{addressesCount} {(addressesCount == 1 ? "address" : "addresses")} in {townName} {(addressesCount == 1 ? "was" : "were")} deleted");
}
}
static void Main(string[] args)
{
var departmentsSalariesToBeIncrease = new List <string>
{
"Engineering",
"Tool Design",
"Marketing",
"Information Services"
};
using (SoftUniContext db = new SoftUniContext())
{
var employees = db.Employees
.Where(e => departmentsSalariesToBeIncrease.Contains(e.Department.Name))
.OrderBy(e => e.FirstName)
.ThenBy(e => e.LastName)
.ToList();
employees.ForEach(e => e.Salary *= 1.12m);
db.SaveChanges();
using (StreamWriter Writer = new StreamWriter(@"..\..\..\result.txt"))
{
foreach (var emp in employees)
{
Writer.WriteLine($"{emp.FirstName} {emp.LastName} (${emp.Salary:f2})");
}
}
}
}
private static void P14_DeleteProjectById(SoftUniContext db)
{
var projectId = 2;
var employeesProjects = db.EmployeesProjects
.Where(e => e.ProjectId == projectId);
foreach (var employeesProject in employeesProjects)
{
db.EmployeesProjects.Remove(employeesProject);
}
var projectToRemove = db.Projects
.Find(projectId);
db.Projects.Remove(projectToRemove);
db.SaveChanges();
var projects = db.Projects
.Take(10)
.Select(p => p.Name);
foreach (var project in projects)
{
Console.WriteLine($"{project}");
}
}
public static string RemoveTown(SoftUniContext context, string townName)
{
var townForDelete = context.Towns
.FirstOrDefault(t => t.Name == townName);
var addressesInTown = context.Addresses
.Where(a => a.Town == townForDelete);
var employeesWithTheRelevantAddress = context.Employees
.Where(e => addressesInTown.Contains(e.Address));
foreach (var employee in employeesWithTheRelevantAddress)
{
employee.AddressId = null;
}
var removedAddresses = addressesInTown.Count();
context.Addresses.RemoveRange(addressesInTown);
context.Towns.Remove(townForDelete);
context.SaveChanges();
var result = $"{removedAddresses} addresses in {townName} were deleted";
return(result
.TrimEnd());
}
public static string RemoveTown(SoftUniContext context)
{
StringBuilder sb = new StringBuilder();
string townName = Console.ReadLine();
context.Employees
.Where(e => e.Address.Town.Name == townName)
.ToList()
.ForEach(e => e.AddressId = null);
int addressesCount = context.Addresses
.Where(a => a.Town.Name == townName)
.Count();
context.Addresses
.Where(a => a.Town.Name == townName)
.ToList()
.ForEach(a => context.Addresses.Remove(a));
context.Towns
.Remove(context.Towns
.SingleOrDefault(t => t.Name == townName));
context.SaveChanges();
Console.WriteLine($"{addressesCount} {(addressesCount == 1 ? "address" : "addresses")} in {townName} {(addressesCount == 1 ? "was" : "were")} deleted");
return(sb.ToString().TrimEnd());
}
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
}
}
static void Main(string[] args)
{
Address newAddress = new Address {
AddressText = "Vitoshka 15", TownId = 4
};
using (SoftUniContext context = new SoftUniContext())
{
Employee employee = context.Employees.FirstOrDefault(x => x.LastName == "Nakov");
employee.Address = newAddress;
context.SaveChanges();
var employees = context.Employees.OrderByDescending(x => x.Address.AddressId).Take(10).Select(x => new { AdressText = x.Address.AddressText });
using (StreamWriter writer = new StreamWriter("../ExerciseOutput.txt"))
{
foreach (var e in employees)
{
Console.WriteLine($"{e.AdressText}");
writer.WriteLine($"{e.AdressText}");
}
}
}
}
private static void RemoveTown(SoftUniContext db, string townName)
{
var townToDelete = db.Towns
.Where(x => x.Name == townName)
.FirstOrDefault();
var adressesToDelete = db.Addresses
.Where(x => x.Town == townToDelete);
int count = 0;
foreach (var employee in db.Employees)
{
foreach (var address in adressesToDelete)
{
if (employee.AddressId == address.AddressId)
{
employee.AddressId = null;
count++;
}
}
}
foreach (var address in adressesToDelete)
{
db.Addresses.Remove(address);
}
db.Towns.Remove(townToDelete);
db.SaveChanges();
Console.WriteLine($"{count} address in {townName} was deleted");
}
public static void Main()
{
using (var context = new SoftUniContext())
{
var employees = context.Employees
.Where(e => e.Department.Name == "Engineering" ||
e.Department.Name == "Tool Design" ||
e.Department.Name == "Marketing" ||
e.Department.Name == "Information Services")
.OrderBy(e => e.FirstName)
.ThenBy(e => e.LastName)
.ToArray();
using (var sr = new StreamWriter("..\\output.txt"))
{
foreach (var employee in employees)
{
employee.Salary += employee.Salary * 0.12m;
sr.WriteLine($"{employee.FirstName} {employee.LastName} (${employee.Salary:F2})");
}
}
context.SaveChanges();
}
}
private static string AddNewAddresAndUpdateEmployee(SoftUniContext db)
{
var address = new Address()
{
TownId = 4, AddressText = "Vitoshka 15"
};
db.Addresses.Add(address);
var employee = db.Employees
.FirstOrDefault(e => e.LastName == "Nakov");
employee.Address = address;
db.SaveChanges();
var result = db.Employees
.OrderByDescending(e => e.AddressId)
.Take(10)
.Select(e => e.Address.AddressText);
var sb = new StringBuilder();
foreach (var item in result)
{
sb.AppendLine(item);
}
return(sb.ToString().TrimEnd());
}
public static void Main()
{
const decimal IncreaseRate = 1.12m;
var departmentsToIncreaseSalaries = new List <string>()
{
"Engineering",
"Tool Design",
"Marketing",
"Information Services"
};
using (var db = new SoftUniContext())
{
var employees = db.Employees
.Where(e => departmentsToIncreaseSalaries.Contains(e.Department.Name))
.ToList();
foreach (var employee in employees.OrderBy(e => e.FirstName).ThenBy(e => e.LastName))
{
employee.Salary = employee.Salary * IncreaseRate;
db.SaveChanges();
Console.WriteLine($"{employee.FirstName} {employee.LastName} (${employee.Salary:F2})");
}
}
}
public static void Main(string[] args)
{
using (var context = new SoftUniContext())
{
var newAdress = new Address
{
AddressText = "Vitoshka 15",
TownId = 4,
};
var employee = context.Employees.FirstOrDefault(e => e.LastName.Equals("Nakov"));
employee.Address = newAdress;
context.SaveChanges();
var employeesAddresses = context.Employees
.OrderByDescending(e => e.AddressId)
.Take(10)
.Select(x => x.Address.AddressText)
.ToList();
using (StreamWriter sw = new StreamWriter("../Employees.txt"))
{
employeesAddresses.ForEach(x => sw.WriteLine(x));
}
}
}
public static string AddNewAddressToEmployee(SoftUniContext context)
{
var adress = new Address
{
AddressText = "Vitoshka 15",
TownId = 4
};
var employee = context.Employees
.FirstOrDefault(e => e.LastName == "Nakov");
employee.Address = adress;
context.SaveChanges();
var sb = new StringBuilder();
var EmployeesAdresses = context.Employees
.OrderByDescending(e => e.AddressId)
.Select(e => new
{
e.Address.AddressText
})
.Take(10)
.ToList();
return(sb.Append(String.Join(Environment.NewLine, EmployeesAdresses
.Select(ea => ea.AddressText)))
.ToString()
.TrimEnd());
}
public static string AddNewAddressToEmployee(SoftUniContext context)
{
StringBuilder sb = new StringBuilder();
var addres = new Address()
{
AddressText = "Vitoshka 15",
TownId = 4
};
Employee nakov = context.Employees
.FirstOrDefault(x => x.LastName == "Nakov");
nakov.Address = addres;
context.SaveChanges();
var employeeAdresses = context.Employees
.OrderByDescending(x => x.AddressId)
.Select(a => a.Address.AddressText)
.Take(10)
.ToList();
foreach (var address in employeeAdresses)
{
sb.AppendLine(address);
}
return(sb.ToString().TrimEnd());
}
public static string DeleteProjectById(SoftUniContext context, int Id)
{
var sb = new StringBuilder();
var project = context.Projects
.Find(Id);
var employeesProjects = context.EmployeesProjects
.Where(ep => ep.Project.ProjectId == project.ProjectId);
context.EmployeesProjects.RemoveRange(employeesProjects);
context.Projects.Remove(project);
context.SaveChanges();
var projectsToPrint = context.Projects
.Select(e => new
{
e.Name
})
.Take(10)
.ToList();
foreach (var projectToPrint in projectsToPrint)
{
sb.AppendLine(projectToPrint.Name);
}
return(sb
.ToString()
.TrimEnd());
}
private static void Main(string[] args)
{
using (var db = new SoftUniContext())
{
var address = new Address();
address.AddressText = "Vitoshka 15";
address.TownId = 4;
Employee employee = db.Employees.FirstOrDefault(e => e.LastName == "Nakov");
employee.Address = address;
db.SaveChanges();
var employees = db.Employees
.OrderByDescending(e => e.AddressId)
.Take(10)
.Select(e => new
{
e.Address.AddressText
})
.ToList();
foreach (var a in employees)
{
FileWriter.WriteLine(a.AddressText);
}
}
}
private void AddingNewAddressToEmployee(string addressText, int townId, string assignee)
{
using (var context = new SoftUniContext())
{
var address = context.Addresses.FirstOrDefault(a => a.AddressText == addressText);
if (address == null)
{
address = new Address()
{
AddressText = addressText,
TownId = townId
};
}
foreach (var employee in context.Employees.Where(e => e.LastName == assignee))
{
employee.Address = address;
}
context.SaveChanges();
this.PrintFirstTenAddresses(context);
}
}
public static void DeleteProjectById()
{
var dbContext = new SoftUniContext();
using (dbContext)
{
var project = dbContext.EmployeesProjects
.Where(ep => ep.ProjectId == 2)
.ToList();
dbContext.EmployeesProjects.RemoveRange(project);
var projectFromProjects = dbContext.Projects
.Where(p => p.ProjectId == 2)
.ToList();
dbContext.Projects.RemoveRange(projectFromProjects);
dbContext.SaveChanges();
var remainingProjects = dbContext.Projects
.Take(10)
.Select(p => p.Name)
.ToList();
foreach (var remainingProject in remainingProjects)
{
Console.WriteLine(remainingProject);
}
}
}
public static string AddNewAddressToEmployee(SoftUniContext context)
{
Address newAddress = new Address()
{
AddressText = "Vitoshka 15",
TownId = 4
};
Employee Nakov = context.Employees.FirstOrDefault(x => x.LastName == "Nakov");
Nakov.Address = newAddress;
newAddress.Employees.Add(Nakov);
context.SaveChanges();
StringBuilder sb = new StringBuilder();
var employees = context.Employees
.Select(x => new { x.Address.AddressText, x.AddressId })
.OrderByDescending(x => x.AddressId)
.Take(10);
foreach (var employee in employees)
{
sb.AppendLine(employee.AddressText);
}
return(sb.ToString().TrimEnd());
}
static void Main(string[] args)
{
using (var context = new SoftUniContext())
{
var address = new Address
{
AddressText = "Vitoshka 15",
TownId = 4
};
Employee employee = context.Employees
.FirstOrDefault(e => e.LastName == "Nakov");
employee.Address = address;
context.SaveChanges();
string[] employeesAddresses = context.Employees
.OrderByDescending(e => e.AddressId)
.Take(10)
.Select(e => e.Address.AddressText)
.ToArray();
using (var sw = new StreamWriter("../../../output.txt"))
{
foreach (string empAddress in employeesAddresses)
{
sw.WriteLine(empAddress);
}
}
}
}
private static void P06_AddingANewAddressAndUpdatingEmployee(SoftUniContext db)
{
var address = new Address
{
AddressText = "Vitoshka 15",
TownId = 4
};
db.Addresses.Add(address);
var wantedEmployee = db.Employees
.FirstOrDefault(e => e.LastName == "Nakov");
if (wantedEmployee != null)
{
wantedEmployee.Address = address;
db.SaveChanges();
}
var result = db.Employees
.OrderByDescending(e => e.AddressId)
.Take(10)
.Select(e => e.Address.AddressText);
foreach (var res in result)
{
Console.WriteLine(res);
}
}
public static string AddNewAddressToEmployee(SoftUniContext context)
{
var address = new Address
{
AddressText = "Vitoshka 15",
TownId = 4
};
var employee = context.Employees
.FirstOrDefault(e => e.LastName == "Nakov");
address.Employees.Add(employee);
employee.Address = address;
context.SaveChanges();
var employeesAddresses = context.Employees
.OrderByDescending(e => e.AddressId)
.Select(e => e.Address.AddressText)
.Take(10)
.ToList();
var result = new StringBuilder();
foreach (var addr in employeesAddresses)
{
result.AppendLine(addr);
}
return(result.ToString().TrimEnd());
}
public static void Main()
{
using (SoftUniContext context = new SoftUniContext())
{
try
{
EmployeeProject[] referenceTableRecordsToDelete = context.EmployeesProjects.Where(id => id.ProjectId == 2).ToArray();
context.EmployeesProjects.RemoveRange(referenceTableRecordsToDelete);
Project toDelete = context.Projects.Single(id => id.ProjectId == 2);
context.Projects.Remove(toDelete);
context.SaveChanges();
}
catch (System.Exception e)
{
System.Console.WriteLine(e.Message);
}
StringBuilder sb = new StringBuilder();
context.Projects
.Select(n => new
{
n.Name
})
.Take(10)
.ToList()
.ForEach(r => sb.AppendLine($"{r.Name}"));
FileCreator.CreateFile(sb.ToString());
}
}
static void Main(string[] args)
{
using (SoftUniContext context = new SoftUniContext())
{
var project = context.Projects.FirstOrDefault(p => p.ProjectId == 2);
var employeesProjects = context.EmployeesProjects.Where(x => x.ProjectId == 2);
context.EmployeesProjects.RemoveRange(employeesProjects);
context.Projects.Remove(project);
context.SaveChanges();
var projects = context.Projects.Take(10);
using (StreamWriter writer = new StreamWriter("../ExerciseOutput.txt"))
{
foreach (var p in projects)
{
Console.WriteLine($"{p.Name}");
writer.WriteLine($"{p.Name}");
}
}
}
}
static void Main(string[] args)
{
using (SoftUniContext context = new SoftUniContext())
{
var projects = context.EmployeesProjects
.Where(x => x.ProjectId == 2);
context.EmployeesProjects.RemoveRange(projects);
var project = context.Projects.Find(2);
context.Projects.Remove(project);
context.SaveChanges();
var proj = context.Projects.Take(10).ToArray();
using (StreamWriter sw = new StreamWriter("../Employees.txt"))
{
foreach (var p in proj)
{
sw.WriteLine(p.Name);
}
}
}
}
private static string AddNewAddressToEmployee(SoftUniContext context)
{
Address newAddress = new Address()
{
AddressText = "Vitoshka 15",
TownId = 4
};
context.Addresses.Add(newAddress);
Employee employeeNakov = context.Employees
.Where(e => e.LastName == "Nakov")
.FirstOrDefault();
employeeNakov.Address = newAddress;
context.SaveChanges();
string[] employeesAddresses = context.Employees
.OrderByDescending(e => e.AddressId)
.Select(e => e.Address.AddressText)
.Take(10)
.ToArray();
return(string.Join(Environment.NewLine, employeesAddresses));
}
public static string IncreaseSalaries(SoftUniContext context)
{
var departments = new string[] { "Engineering", "Tool Design", "Marketing", "Information Services" };
var employees = context.Employees
.Where(x => departments.Contains(x.Department.Name))
.OrderBy(x => x.FirstName)
.ThenBy(x => x.LastName)
.ToList();
foreach (var employee in employees)
{
employee.Salary *= 1.12m;
}
context.SaveChanges();
var sb = new StringBuilder();
foreach (var employee in employees)
{
sb.AppendLine($"{employee.FirstName} {employee.LastName} (${employee.Salary:F2})");
}
return(sb.ToString().TrimEnd());
}
static void Main(string[] args)
{
var context = new SoftUniContext();
using (context)
{
var address = new Address()
{
AddressText = "Vitoshka 15",
TownId = 4,
};
Employee employee = context.Employees
.FirstOrDefault(e => e.LastName == "Nakov");
employee.Address = address;
context.SaveChanges();
var addressTexts = context.Employees
.OrderByDescending(e => e.Address.AddressId)
.Take(10)
.Select(e => e.Address.AddressText)
.ToArray();
foreach (var addressText in addressTexts)
{
Console.WriteLine(addressText);
}
}
}