public static string GetEmployeesFullInfo(SoftuniContext context)
{
StringBuilder result = new StringBuilder();
IEnumerable <Employee> employees = context.Employees;
foreach (Employee employee in employees)
{
result.AppendLine($"{employee.FirstName} {employee.LastName} {employee.MiddleName} {employee.JobTitle} {employee.Salary.ToString().Replace(",", ".")}");
}
return(result.ToString());
}
public static string EmployeesWithSalaryOver(SoftuniContext context)
{
StringBuilder result = new StringBuilder();
var employees = context.Employees
.Where(x => x.Salary > 50000)
.Select(em => em.FirstName);
foreach (var employee in employees)
{
result.AppendLine(employee);
}
return(result.ToString());
}
public static string EmployeeWithIdSortedByProjectNames(SoftuniContext context)
{
StringBuilder result = new StringBuilder();
Employee employee = context.Employees.Find(147);
IEnumerable <Project> projects = employee.Projects.OrderBy(project => project.Name);
result.AppendLine($"{employee.FirstName} {employee.LastName} {employee.JobTitle}");
foreach (var project in projects)
{
result.AppendLine(project.Name);
}
return(result.ToString());
}
public static string FindEmployeesByFirstNameStartingWith(SoftuniContext context)
{
StringBuilder result = new StringBuilder();
string pattern = "SA";
var employeesByNamePattern = context.Employees
.Where(employee => employee.FirstName.StartsWith(pattern));
foreach (var employeeByPattern in employeesByNamePattern)
{
result.AppendLine($"{employeeByPattern.FirstName} {employeeByPattern.LastName} " +
$"- {employeeByPattern.JobTitle} - (${employeeByPattern.Salary})");
}
return(result.ToString());
}
public static string FindLatestNProjects(SoftuniContext context)
{
StringBuilder result = new StringBuilder();
var latestStartedProjects =
context.Projects.OrderByDescending(project => project.StartDate)
.Take(10)
.OrderBy(project => project.Name);
foreach (var latestStartedProject in latestStartedProjects)
{
result.AppendLine($"{latestStartedProject.Name} {latestStartedProject.Description} {latestStartedProject.StartDate} {latestStartedProject.EndDate}");
}
return(result.ToString());
}
public static string AddressesByTownName(SoftuniContext context)
{
StringBuilder result = new StringBuilder();
var addresses =
context.Addresses
.OrderByDescending(address => address.Employees.Count)
.ThenBy(address => address.Town.Name)
.Take(10);
foreach (Address address in addresses)
{
result.AppendLine($"{address.AddressText}, {address.Town.Name} - {address.Employees.Count} employees");
}
return(result.ToString());
}
public static string EmployeesFromSeattle(SoftuniContext context)
{
StringBuilder result = new StringBuilder();
var employees = context.Employees
.Where(employee => employee.Department.Name == "Research and Development")
.OrderBy(employee => employee.Salary)
.ThenByDescending(employee => employee.FirstName);
foreach (var employee in employees)
{
result.AppendLine($"{employee.FirstName} {employee.LastName} " +
$"from {employee.Department.Name} - ${employee.Salary:F2}");
}
result.Replace(",", ".");
return(result.ToString());
}
public static string IncreaseSalaries(SoftuniContext context)
{
StringBuilder result = new StringBuilder();
var employees = context.Employees.Where(employee =>
employee.Department.Name == "Engineering" ||
employee.Department.Name == "Tool Design" ||
employee.Department.Name == "Marketing" ||
employee.Department.Name == "Information Services");
foreach (var employee in employees)
{
employee.Salary *= 1.12m;
result.AppendLine($"{employee.FirstName} {employee.LastName} (${employee.Salary})");
}
context.SaveChanges();
return(result.ToString());
}
public static string DepartmentsWithMoreThanNemployees(SoftuniContext context)
{
StringBuilder result = new StringBuilder();
IEnumerable <Department> departments = context
.Departments.Where(department => department.Employees.Count > 5)
.OrderBy(department => department.Employees.Count);
foreach (Department department in departments)
{
result.AppendLine($"{department.Name} {department.Employee.FirstName}");
foreach (Employee employee in department.Employees)
{
result.AppendLine($"{employee.FirstName} {employee.LastName} {employee.JobTitle}");
}
}
return(result.ToString());
}
public static string FindEmployeesInPeriod(SoftuniContext context)
{
StringBuilder result = new StringBuilder();
var employees = context.Employees
.Where(employee => employee.Projects
.Count(project => project.StartDate.Year >= 2001 && project.StartDate.Year <= 2003) > 0).Take(30);
foreach (var employee in employees)
{
result.AppendLine($"{employee.FirstName} {employee.LastName} {employee.Employee1.FirstName}");
foreach (Project project in employee.Projects)
{
result.AppendLine($"--{project.Name} {project.StartDate} {project.EndDate}");
}
}
return(result.ToString());
}
static void Main(string[] args)
{
SoftuniContext context = new SoftuniContext();
string result;
//result = GetEmployeesFullInfo(context);
//result = EmployeesWithSalaryOver(context);
//result = EmployeesFromSeattle(context);
//result = AddingNewAddressAndUpdatingEmployee(context);
//result = DeleteProjectById(context);
//result = FindEmployeesInPeriod(context);
//result = AddressesByTownName(context);
//result = EmployeeWithIdSortedByProjectNames(context);
//result = DepartmentsWithMoreThanNemployees(context);
//result = FindLatestNProjects(context);
//result = IncreaseSalaries(context);
result = FindEmployeesByFirstNameStartingWith(context);
Console.WriteLine(result);
}
public static string DeleteProjectById(SoftuniContext context)
{
StringBuilder result = new StringBuilder();
var project = context.Projects.Find(2);
var employees = project.Employees;
foreach (Employee employee in employees)
{
employee.Projects.Remove(project);
}
context.SaveChanges();
context.Projects.Remove(project);
context.SaveChanges();
var projects = context.Projects.Take(10).Select(project1 => project1.Name);
foreach (string proj in projects)
{
result.AppendLine(proj);
}
return(result.ToString());
}
public static string AddingNewAddressAndUpdatingEmployee(SoftuniContext context)
{
StringBuilder result = new StringBuilder();
var address = new Address()
{
AddressText = "Vitoshka 15", TownID = 4
};
var nakovEmployee = context.Employees.First(employee => employee.LastName == "Nakov");
nakovEmployee.Address = address;
context.SaveChanges();
var employeeAddresses = context.Employees
.OrderByDescending(employee => employee.Address.AddressID)
.Take(10)
.Select(employee => employee.Address.AddressText);
foreach (string employeeAddress in employeeAddresses)
{
result.AppendLine(employeeAddress);
}
return(result.ToString());
}