Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This is for C# Programming, you have to use the exact interface. Im having trouble with the coding, can someone please help me! The first

This is for C# Programming, you have to use the exact interface. Im having trouble with the coding, can someone please help me!

The first assignment was....

Create a program that will calculate employees monthly gross pay as follows:

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

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

I have already completed this assignment now I need help with a similiar one with the interface below.

New Assignment

Create a windows program that will calculate employees monthly gross pay as follows:

Program will use the same rules as the 2 projects in CIS2342(see above) with 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:

image text in transcribed

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:

image text in transcribed

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

The summary button displays the following form:

image text in transcribed

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.

image text in transcribed

.

tblEmployees tblSales tblMonths fldEmployeeld fldMonthName fldMonthNumber fldSalesEmployee 9 fldsalesMonth fldEmployeeLastName fldEmployeeFirstName fldEmployeeSalary fldEmployeeType ldSalesSales fldSalesPay

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle Database Foundations Technology Fundamentals For IT Success

Authors: Bob Bryla

1st Edition

0782143725, 9780782143720

More Books

Students also viewed these Databases questions

Question

Do they appear to be stressed out?

Answered: 1 week ago

Question

4 How the market system adjusts to change and promotes progress.

Answered: 1 week ago