CM-12 Project "pay4 -- input from file."

Project "pay4": Payroll Program, with input from file

DESCRIPTION:
Process the weekly payroll for each employee of a company.
For each employee, compute weekly pay amount and create a paycheck and a paystub. Also produce reports, as specified below.

For this revision ("pay4"), the input data will be read from a file. See Specifications for "pay1" and "pay2" for further details.

NEW BUTTONS:
Add the following new buttons:

OPEN: Open a text file (using a StreamReader object). The file name should be obtained from an Input Dialog Box ("pop-up").
READ: Read data for next employee (from next line of file, using CSV). Copy the (trimmed) strings into appropriate textboxes.

INPUT FROM FILE & TEXTBOXES:
For each employee, the following information is read from one line of a file, using CSV (Comma Separated Values). Each time the "READ" button is clicked, these strings should be extracted from the next line of the file, trimmed, and stored into the text properties of the corresponding TextBoxes.

ID number: a unique integer greater than zero
Pay rate: hourly pay rate, in $
Pay code: 1 (or less) indicates "nonexempt" -- overtime hours are paid time-and-a-half
Last Name of employee: (no punctuation allowed)
First Name of employee: (no punctuation allowed)

In addition to the textboxes for the above, there is also a textbox for the hours worked, which must be filled in by the user (before clicking the "PAY" button).

Hours: number of worked this week (to the nearest tenth).

The remaining specifications are the same as those for "pay1" and "pay2", as reproduced below (for your convenience).

OTHER BUTTONS:(Same as "pay1" & "pay2")

PAY

Produce a paystub and paycheck for this employee.

NEXT

Clear the output areas; also clear all inputs.

EXIT

Close the form.

CLEAR

Clear all input (textbox) and output (listbox) text.

REPORT

Produce the following report (in the same listbox as the "paystub", after clearing all I/O text):

the number of employees paid,
the total number of hours worked,
the average gross pay per hour,
the total payroll amount for all employees paid,
total Income Tax deductions.
total FICA deductions.

**PAYCHECK:**
Whatever National Bank Pay to the order of John Doe the amount of $ 319.50

OUTPUT:
When pay is computed for each employee, the program shall display a simulated paycheck, similar to the following.

Also display a report (or "pay stub"), that includes all of the information for this employee.
PAYSTUB:

Employee data: Employee ID: 9842 Last name: Doe First name: John Hourly rate: $ 10.00 Pay code: 1 This week's payroll data: Hours worked: 44.1 Gross pay: $ 461.50 Income tax: $ 68.15 FICA: $ 73.85 Net pay: $ 319.50

**PAYSTUB:**
Employee data: Employee ID: 9842 Last name: Doe First name: John Hourly rate: $ 10.00 Pay code: 1 This week's payroll data: Hours worked: 44.1 Gross pay: $ 461.50 Income tax: $ 68.15 FICA: $ 73.85 Net pay: $ 319.50

CALCULATIONS:

GROSS PAY: The gross pay amount shall be calculated from the pay rate and the hours worked.
If the "pay code" is greater than one (exempt from overtime pay), multiply the hours worked by the hourly pay rate. However, if the "pay code" is 1 (or less), then all hours over 40 (per week) are paid at "time-and-a-half" (i.e. 1.5 times the hourly rate).

DEDUCTIONS: Calculate Income Tax and FICA deductions, and subtract these from the net pay that appears on the paycheck. Use the "Single with no exemptions" table (5.5) for Income Tax, and use 15.3% of gross pay for the FICA amount.

NET PAY: Subtract the two deductions from gross-pay to obtain net-pay.

NOTE: This program is intended to be used by a "payroll clerk" to produce paychecks and paystubs for any number of employees from a weekly list of hours worked by each employee.

Version "pay2" adds include various "deductions", and also add one or more buttons to produce "reports", to be displayed in the same listbox that was used for "pay stub".

You will need to accumulate various counts, totals, and averages, such as the number of employees paid, the total number of hours worked, the total payroll amount for all employees paid, the average pay-per-hour, the percentage of non-exempt employees who who actually worked any overtime hours, etc., and other summary information, to be displayed in these reports.

Version "pay4" reads the employee data from a file (and copies the strings into the textboxes), rather than having the user input this data. Future versions will use arrays, to look up the employee data based on ID #.

MODULARIZE:

Be sure to modularize your code, so that tasks are performed only in subs and functions that are called by your event-handlers. Event handlers should do no input, nor output, nor computation.