The programming project to be done for this chapter are:

$12-1$ Personnel Database

$12-2$ Display Employee Details based on Selection

$12-4$ Employee Search

These should be done in ONE application. The template for the application is provided: Assignment $7.$zip

Main Form $(10$ points$)$

Write the codes for the toolstrip menu item click

Show All Employees form when Show All Employees toolstrip menu item is clicked. Open the form in modal format. Hide the main form and show it only when the user is done with the Show All Employees form.

Search Employees form when Search Employees toolstrip menu item is clicked. Open the form in modal format. Hide the main form and show it only when the user is done with the Search Employees form.

$12-1$:$$

Creating the Personnel Database $(35$ points$)$

The personnel database $($mdf$)$ should have the following fields:

FieldData TypeLengthNull AllowedEmployeeIDKey, int$$NoLastNameString$50$NoFirstNameString$50$NoDepartmentString$50$NoTitleString$50$YesAnnualSalaryCurrency$$Yes

Here is the data for the database:

Add the Personnel Database as a data source to your project.

Adding a column to the table in Personnel TableAdapter $(10$ points$)$

In the Personnel TableAdapter, configure the Fill, Get$()$ SQL query to add a column to show FullName which is LastName, FirstName.$$

Employees Table Form $(25$ points$)$

In the$$ Employees Table form, use a datagridview$$to display all the employees showing only the following columns: EmployeeID, Full Name, Department. Format the datagridview as appropriate. Change the header text to ID$,$ Name, Department. Make sure that the column width is sufficient to display the entire column text $($you will need to change the autosizemode of the column$).$ Remove the Navigator.

Link the Show Details button to the Employee Details form $($details provided in $12-2).$

$12-2$: Display Employee Details based on Selection $(30$ points$)$

Use the form "Employee Details" to display the employee selected in the datagridview in $12-1$ to display the employee details with EmployeeID, FirstName, LastName, Department, Title, Salary. Note that you will have to change the properties of the controls in Employee Details to make them accessible. You will have to assign the appropriate values from the cells to the labels. Display salary in currency format.

$12-4$: Employee Search $(30$ points$)$

Use the form "Search Employees" to allow the user to search for all employees whose first or last name matches the search string. Display employee id$,$ last name, first name, department, title, salary in a datagridview. Note: you will need to create a SQL query in the dataset designer and use the new query to fill your datagridview on the form. Format the datagridview as appropriate. Change the header text and make sure that the column width is sufficient to display the entire column text $($you will need to change the autosizemode of the column$).$ Display salary in currency format.