NOTE: You will need a method public static string GetEmployeesFullInformation(SoftUniContext context) and a public StartUp class.

Now we can use SoftUniContext to extract data from our database. Your first task is to extract all employees and return their first, last, and middle name, their job title, and salary, rounded to 2 symbols after the decimal separator, all of those separated with a space. Order them by employee id.

Output
Guy Gilbert R Production Technician 12500.00
Kevin Brown F Marketing Assistant 13500.00
…

NOTE: You will need a method public static string GetEmployeesWithSalaryOver50000(SoftUniContext context) and a public StartUp class.

Your task is to extract all employees with salaries over 50000. Return their first names and salaries in format “{firstName} - {salary}”. Salary must be rounded to 2 symbols, after the decimal separator. Sort them alphabetically by the first name.

Output
Brian - 72100.00
Dylan - 50500.00
…

NOTE: You will need a method public static string GetEmployeesFromResearchAndDevelopment(SoftUniContext context) and a public StartUp class.

Extract all employees from the "Research and Development" department. Order them by salary (in ascending order), then by first name (in descending order). Return only their first name, last name, department name, and salary rounded to 2 symbols, after the decimal separator in the format shown below:

Output
Gigi Matthew from Research and Development - $40900.00
Diane Margheim from Research and Development - $40900.00
…

NOTE: You will need a method public static string AddNewAddressToEmployee(SoftUniContext context) and a public StartUp class.

Create a new address with the text "Vitoshka 15" and TownId 4. Set that address to the employee with last name "Nakov".
Then order by descending all the employees by their Address’ Id, take 10 rows and from them, take the AddressText. Return the results each on a new line:

Output
Vitoshka 15
163 Nishava Str, ent A, apt. 1
…

After this restore your database for the tasks ahead!

Hints Create the address and find the employee with last name equal to "Nakov" in order to assign the address to him.

NOTE: You will need a method public static string GetEmployeesInPeriod(SoftUniContext context) and a public StartUp class.

Find the first 10 employees who have projects started in the period 2001 - 2003 (inclusive). Print each employee's first name, last name, manager’s first name, and last name. Then return all of their projects in the format "-- - - ", each on a new row. If a project has no end date, print "not finished" instead.

Use date format: "M/d/yyyy h:mm:ss tt".

Output
Guy Gilbert - Manager: Jo Brown
--Half-Finger Gloves - 6/1/2002 12:00:00 AM - 6/1/2003 12:00:00 AM
--Racing Socks - 11/22/2005 12:00:00 AM - not finished
…

NOTE: You will need a method public static string GetAddressesByTown(SoftUniContext context) and a public StartUp class.

Find all addresses, ordered by the number of employees who live there (descending), then by town name (ascending), and finally by address text (ascending). Take only the first 10 addresses. For each address return it in the format ", - employees".

Output
163 Nishava Str, ent A, apt. 1, Sofia - 3 employees
7726 Driftwood Drive, Monroe - 2 employees
…

NOTE: You will need a method public static string GetEmployee147(SoftUniContext context) and a public StartUp class.

Get the employee with id 147. Return only his/her first name, last name, job title, and projects (print only their names). The projects should be ordered by name (ascending). Format of the output.

Output
Linda Randall - Production Technician
HL Touring Handlebars
…

NOTE: You will need a method public static string GetDepartmentsWithMoreThan5Employees(SoftUniContext context) and a public StartUp class.

Find all departments with more than 5 employees. Order them by employee count (ascending), then by department name (alphabetically).
For each department, print the department name and the manager’s first and last name on the first row.
Then print the first name, the last name and the job title of every employee on a new row.
Order the employees by first name (ascending), then by last name (ascending).
Format of the output: For each department print it in the format " - " and for each employee print it in the format " - ".

Output
Engineering – Terri Duffy
Gail Erickson - Design Engineer
Jossef Goldberg - Design Engineer
…

NOTE: You will need a method public static string GetLatestProjects(SoftUniContext context) and a public StartUp class.

Write a program that returns information about the last 10 started projects. Sort them by name lexicographically and return their name, description and start date, each on a new row. Format of the output

Use date format: "M/d/yyyy h:mm:ss tt".

Output
All-Purpose Bike Stand
Research, design, and development of All-Purpose Bike Stand. Perfect all-purpose bike stand for working on your bike at home. Quick-adjusting clamps and steel construction.
9/1/2005 12:00:00 AM
…

NOTE: You will need a method public static string IncreaseSalaries(SoftUniContext context) and a public StartUp class.

Write a program that increases salaries of all employees that are in the Engineering, Tool Design, Marketing, or Information Services department by 12%. Then return first name, last name, and salary (2 symbols after the decimal separator) for those employees whose salary was increased. Order them by first name (ascending), then by last name (ascending). Format of the output.

Output
Ashvini Sharma ($36400.00)
Dan Bacon ($30688.00)
…

NOTE: You will need a method public static string GetEmployeesByFirstNameStartingWithSa(SoftUniContext context) and public StartUp class.

Write a program that finds all employees whose first name starts with "Sa". Return their first, last name, their job title, and salary rounded to 2 symbols after the decimal separator in the format given in the example below. Order them by first name, then by last name (ascending).

Find a way to make your query case-insensitive

Output
Sairaj Uddin - Scheduling Assistant - ($16000.00)
Samantha Smith - Production Technician - ($14000.00)
…

NOTE: You will need a method public static string DeleteProjectById(SoftUniContext context) and a public StartUp class.

Let's delete the project with id 2. Then, take 10 projects and return their names, each on a new line. Remember to restore your database after this task.

Output
Classic Vest
Full-Finger Gloves
…

Hints If we try to delete the project directly we'll get an exception: C# The project is referenced by the junction (many-to-many) table EmployeesProjects. Therefore we cannot safely delete it. First, we need to remove any references to that row in the Projects table.

This is done by removing the project from all employees who reference it.

NOTE: You will need a method public static string RemoveTown(SoftUniContext context) and a public StartUp class.

Write a program that deletes a town with the name "Seattle". Also, delete all addresses that are in that town.
Return the number of addresses that were deleted in the format "{count} addresses in Seattle were deleted".

There will be employees living at those addresses, which will be a problem when trying to delete the addresses. So, start by setting the AddressId of each employee for the given address to null. After all of them are set to null, you may safely remove all the addresses from the context Addresses and finally remove the given town.

Output
44 addresses in Seattle were deleted