Create a windows program that will calculate employees monthly gross pay as follows: use C# programming

Inputs:

Name

Annual Salary

Monthly Sales

Keeps asking for additional inputs and creating the outputs until an empty name is entered.

Outputs:

Name

Monthly Base Pay (Salary / 12)

Commission calculated as follows:

Subtract 10 * Monthly Base Pay from Monthly Sales giving Net Sales

If the Net Sales is <= 0, then the Commission is 0

Otherwise the First $10,000 in Net Sales is commissioned at 5%

The next $15,000 in Net Sales is commissioned at 10%

The next $25,000 in Net Sales is commissioned at 15%

Any Net Sales over $50,000 is commissioned at 20%

Gross Pay (Monthly Base Pay + Commission).

If any of the inputs are unreasonable, tell user with a message and force reentry of the data (e.g. Negative Sales, Annual Salary > $120,000 or < $12,000, if not 0).

The following additions:

Employees who are Managers, get commission on the total sales of all the sales reps

The sales are not lowered by the salary.

The percentages are of the sales rep and the breakpoints are ten times the sales reps (e.g. if the sales rep first break point is at 50,000, then the managers is at 500,000.

Employees who are support get commissioned like managers, but they get 0.1 of what a manager gets.

You should create a class that saves the following information for an employee:

Last Name

First Name

Annual Salary

Type (Sales Rep, Manager, Support)

High Cost flag

When money information on the form changes, then the gross pay should be cleared.

The items shown in Cyan are not modifiable by entering data for this record, but may be modifiable at other times (e.g. the Last and First Name need to be modified for a new record).

Use a database to hold the data (I have attached an MS Access database that you can use). The relationship window is shown below:

fldEmployeeId is automatically generated.

fldEmployeeSalary, fldSalesSales, and fldSalesPay are currency

fldSalesMonth and fldMonthNumber are short integers between 1 and 12 (you can also figure out the month if it is in a combobox by adding 1 to the selectedIndex property).

All other fields are strings.

The database has 3 employees, 2 sales reps (Adam Ant, Tom Thumb) and one boss (The Boss) already included.

You need a form that looks something like this:

The form should show the different employees and their pay for various months.

The summary button displays the following form:

Do as much of this as you can. Start with the ability to display the various employees, then add new employees, then develop the summary form.

Use the Visual Studio help to see how the various database related components work.

On the bindingNavigator (the object at the top of the main form), I have added a save button, I am also including the bitmap for that button in the project. (If you wish you can use regular buttons instead of the bindingNavigator tool, but then you need to handle the record change code yourself).

The following is the PayCalcDataSet designer view for the main form. Note that I have created multiple additional queries.