Step 1: Given a file of data, read the data and parse it based on a fixed given field headers. To download the file, select the following link:
Eliminate the last column (Pig-Latin) in the data file.
The file is a comma delimited file with the following record structure:
· FirstName – Character – Size (12)
· LastName – Character – Size (16)
· Company – Character – Size (32)
· Address – Character – Size (32)
· City – Character – Size (24)
· County – Character – Size (24)
· State – Character – Size (2)
· ZIP – Number – Size (5)
· Phone – Character – Size (12)
· Fax – Character – Size (12)
· Email – Character – Size (32)
· Web – Character – Size (42)
Step 2: Write a complete C# program in console mode to load the data file as a sequential file using C# System.IO library into an ArrayList data structure (using the System.Collection library) Store each line in the file as a separate record.
Step 3: After the file is loaded into the ArrayList, sort the data in ascending order based on the LastName field. Print the following fields:
· First name
· Last name
· Company
Step 4: Sort the data in descending order based on the ZIP field, and print the following fields:
· First name
· Last name
· Company
· ZIP
Step 5: Print the record (all fields) for everyone that is in the state “NY.”
Step 6: Submit the source code for the solution and the output for the 3 lists that are specified below. You can use any appropriate algorithm in the solution.
· Sorted data based on last name
· Sorted data based on ZIP
· Everyone in the state of NY