Sales report to program in VS 2012 Pro

Question

A menu driven program is required that will allow the user either produce a sales report on the console, search a sales file do some data analysis. The program will take its input from the comma delimited sequential file "sales.dat" with the record structure outlined below.

SALES.TXT record structure

Field Name	Type
salesPersonNumber	Integer
salesPersonName	String
totalSales	Double

This is an example of its contents:
1,Pat Ryan,280
2,Mary Smith,300
3,Tom Lynch,20

Menu Format

Menu

1. Sales Report
2. Search for a Salesperson
3. Sale Analysis
4. Exit

The user shall be able to create report, search and do sale analysis as often as they like. The program will terminate when exit is selected.
Sales Report
The report will have the format and contents as outlined below.
For each salesperson your program will calculate the commission due using the criteria in Table 1.

Table 1

Sale amount	Commission
Less than 1000	5%
Between 1000 and 1999	10%
Between 2000 and 2999	15%
Greater than 2999	20%

Example report for the sample data file

Sales Report

Salesperson number Name Sales commission
1 P.R 280.00 14.00
2 M.S. 300.00 15.00
3 T.L 20.00 1.00
Total Sales €600.00
Average Sales €200.00
Total Commission €30.00
Average Commission €10.00
Top SalesPerson 2
End-of-Report


Search
Allow the user enter a player number, the program will then search the file, and display the players name, and the score for chosen player. If the player is not found display a message stating "No match found".
Example dialogue
Enter Salesperson Number: 2
Name : Mary Smith
Sales : 300



Sales Analysis
A report showing the number of salespeople that sell in the above ranges is required. Use an array to store the number in each range.

Range Number in this range
0-399 3
400-599 0
600-699 0
700-999 0
1000 and over 0