The Charity Event Analyzer

Using Visual Studio C# to write this program

Suppose a local charity needs your help to analyze data for a charity event.

The event sells a set of tickets per table. Each table has a sponsor that will attend the event and the sponsor will recruit other people to attend.

The room has 4 tables. Each table has a different number of seats and cost per seat. Here are the tables:

Table	Seats	Cost Per Seat
1	5	120
2	5	120
3	7	100
4	7	100

The event organizer has been keeping the following data in a file called attendees.csv . It contains people a

Table,Perons,Role,Paid

1,Sammy Sosa,S,Y

1,Ryan Dempster,A ,N

1,Aramis Ramiex,A ,N

1,Carlos Zambrano,A ,Y

2,Dusty Baker,S,Y

2,Ron Santo,A ,Y

2,Scott Wliailms,A ,Y

2,Enrique Wilson,A ,Y

2,Ernie Banks,A ,Y

3,Matt Lawton,S,N

3,Will Ohamn,A ,N

3,Chad Fox,A ,N

3,Gary Matthews,A ,N

4,Jaun Lopez,S,Y

4,Kerry Wood,A ,Y

4, Kerry Wood a,A ,Y

4,Adam GreenBurg,A ,Y

4, Adam GreenBurg,A ,N

4,Jody Gerut,A ,Y

Table,Perons,Role,Paid

1,Sammy Sosa,S,Y

1,Ryan Dempster,A ,N

1,Aramis Ramiex,A ,N

1,Carlos Zambrano,A ,Y

2,Dusty Baker,S,Y

2,Ron Santo,A ,Y

2,Scott Wliailms,A ,Y

2,Enrique Wilson,A ,Y

2,Ernie Banks,A ,Y

3,Matt Lawton,S,N

3,Will Ohamn,A ,N

3,Chad Fox,A ,N

3,Gary Matthews,A ,N

4,Jaun Lopez,S,Y

4,Kerry Wood,A ,Y

4, Kerry Wood a,A ,Y

4,Adam GreenBurg,A ,Y

4, Adam GreenBurg,A ,N

4,Jody Gerut,A ,Y

For example,

Sammy Sosa is at table 1, he is a sponsor, and has paid

Ernie Banks is at table2, he is an attendee, and has paid

Gary Matthews is at table 3, he is an attendee, and has NOT paid

Jaun Lopez is at table 4, he is a sponsor, and has paid

What to do.

1.Determine an OO design for the system.

2.Read the attendees.csv file and create whatever objects you need.

3.Prompt the user for a table number and output the number of seats available, the table seat cost. Then output each person that will be attending (see below). Finish with some overall information about the table (see below).

Welcome to our Charity Table Stats ... Enter Table Number or Q to quit-> g Illegal Table number:8 ... try again Enter Table Number or Q to quit-> Information about Table:3 --- Table Number:3 NSeats:7 Cost: 100 --- Person: Matt Lawton Role:S Paid:N - Person:Will Ohamn Role: A Paid:N -- Person: Chad Fox Role:A Paid:N --- Person: Gary Matthews Role: A Paid:N - - - - - - - - - - - - - - - - - - - - - - - - Total Seats Paid: 0 Total Not Paid:4 Money Collected:0 Money Owed:400 Number Seats In Table:7 Seats Available:3 Enter Table Number or to quit->