In C#

Data and layout file structure

Inside each of the data files is 102 lines of information. The first and last lines are just a header and footer that dont contain a relevant record. Each of the other 100 lines contains one record each. These records each have 150 fields separated by | . The final field is just a field indicating the end of a record.

The data layout file has one field name per line corresponding to each of the 150 fields that each record in the data files have. These field names and the fields in the data files are all in the same order.

For this assignment you can have all of your code in the Program class if you choose to. You will need to give the user the choice of reading in all of DataFile1, 2, or 3. The data in the chosen file should be read in and converted to the JSON format. Its important to note that the data files only have the values of each field, the DataFieldsLayout file contains the name of each field. The JSON formatted data then needs to be written out to a valid JSON file. The code that converts the data to the JSON format must be written by you. Do not use a serializer or 3rd party framework like Newtonsoft.Json.

Make sure your project meets the following requirements:

File I/O Reading

The field names are read in from the DataFieldsLayout file and stored in a variable.

The data fields are able to be read in from at least one of the DataFile files and stored in a variable.

File I/O Writing

All relevant data from a DataFile is written out to a single file.

JSON

Records are converted to valid JSON and written to a valid JSON file. (ex. The file extension should be .json and not .txt).

User Input

The user is able to select which of the three data files they would like to process.

Extra Information

Tips and hints:

Each line of the data files is a separate record made up of key:value pairs.

Figuring out how to convert one record into JSON and then repeating that process for each record will be easier than trying to just lump convert the whole data set.

Test your JSON using the JSON validator found here.

This is an array of data, make sure that your output JSON file accurately represents this fact. The data should not just be a bunch of JSON objects in a file with no structure.

Go back through your code and check for the following:

All variables and methods are named appropriately.

Member variables should have either protected or private access.

Anytime the user is asked for input the expected input is made clear to the user.

Any information being output to the user should be clear and concise.

Make sure nothing accesses an object that doesnt exist.

DataFieldsLayout.txt

DUNS DUNS+4 CAGE CODE DODAAC SAM EXTRACT CODE PURPOSE OF REGISTRATION REGISTRATION DATE EXPIRATION DATE LAST UPDATE DATE ACTIVATION DATE LEGAL BUSINESS NAME DBA NAME COMPANY DIVISION DIVISION NUMBER SAM ADDRESS 1 SAM ADDRESS 2 SAM CITY SAM PROVINCE OR STATE SAM ZIP/POSTAL CODE SAM ZIP CODE +4 SAM COUNTRY CODE SAM CONGRESSIONAL DISTRICT BUSINESS START DATE FISCAL YEAR END CLOSE DATE CORPORATE URL ENTITY STRUCTURE STATE OF INCORPORATION COUNTRY OF INCORPORATION BUSINESS TYPE COUNTER BUS TYPE PRIMARY NAICS NAICS CODE COUNTER NAICS CODE PSC CODE COUNTER PSC CODE CREDIT CARD USAGE CORRESPONDENCE FLAG MAILING ADDRESS LINE 1 MAILING ADDRESS LINE 2 MAILING ADDRESS CITY MAILING ADDRESS ZIP/POSTAL CODE MAILING ADDRESS ZIP CODE +4 MAILING ADDRESS COUNTRY MAILING ADDRESS STATE OR PROVINCE GOVT BUS POC FIRST NAME GOVT BUS POC MIDDLE INITIAL GOVT BUS POC LAST NAME GOVT BUS POC TITLE GOVT BUS POC ST ADD 1 GOVT BUS POC ST ADD 2 GOVT BUS POC CITY GOVT BUS POC ZIP/POSTAL CODE GOVT BUS POC ZIP CODE +4 GOVT BUS POC COUNTRY CODE GOVT BUS POC STATE OR PROVINCE GOVT BUS POC U.S. PHONE GOVT BUS POC U.S. PHONE EXT GOVT BUS POC NON-U.S. PHONE GOVT BUS POC FAX U.S. ONLY GOVT BUS POC EMAIL ALT GOVT BUS POC FIRST NAME ALT GOVT BUS POC MIDDLE INITIAL ALT GOVT BUS POC LAST NAME ALT GOVT BUS POC TITLE ALT GOVT BUS POC ST ADD 1 ALT GOVT BUS POC ST ADD 2 ALT GOVT BUS POC CITY ALT GOVT BUS POC ZIP/POSTAL CODE ALT GOVT BUS POC ZIP CODE +4 ALT GOVT BUS POC COUNTRY CODE ALT GOVT BUS POC STATE OR PROVINCE ALT GOVT BUS POC U.S. PHONE ALT GOVT BUS POC U.S. PHONE EXT ALT GOVT BUS POC NON-U.S. PHONE ALT GOVT BUS POC FAX U.S. ONLY ALT GOVT BUS POC EMAIL PAST PERF POC POC FIRST NAME PAST PERF POC POC MIDDLE INITIAL PAST PERF POC POC LAST NAME PAST PERF POC POC TITLE PAST PERF POC ST ADD 1 PAST PERF POC ST ADD 2 PAST PERF POC CITY PAST PERF POC ZIP/POSTAL CODE PAST PERF POC ZIP CODE +4 PAST PERF POC COUNTRY CODE PAST PERF POC STATE OR PROVINCE PAST PERF POC U.S. PHONE PAST PERF POC U.S. PHONE EXT PAST PERF POC NON-U.S. PHONE PAST PERF POC FAX U.S. ONLY PAST PERF POC EMAIL ALT PAST PERF POC FIRST NAME ALT PAST PERF POC MIDDLE INITIAL ALT PAST PERF POC LAST NAME ALT PAST PERF POC TITLE ALT PAST PERF POC ST ADD 1 ALT PAST PERF POC ST ADD 2 ALT PAST PERF POC CITY ALT PAST PERF POC ZIP/POSTAL CODE ALT PAST PERF POC ZIP CODE +4 ALT PAST PERF POC COUNTRY CODE ALT PAST PERF POC STATE OR PROVINCE ALT PAST PERF POC U.S. PHONE ALT PAST PERF POC U.S. PHONE EXT ALT PAST PERF POC NON-U.S. PHONE ALT PAST PERF POC FAX U.S. ONLY ALT PAST PERF POC EMAIL ELEC BUS POC FIRST NAME ELEC BUS POC MIDDLE INITIAL ELEC BUS POC LAST NAME ELEC BUS POC TITLE ELEC BUS POC ST ADD 1 ELEC BUS POC ST ADD 2 ELEC BUS POC CITY ELEC BUS POC ZIP/POSTAL CODE ELEC BUS POC ZIP CODE +4 ELEC BUS POC COUNTRY CODE ELEC BUS POC STATE OR PROVINCE ELEC BUS POC U.S. PHONE ELEC BUS POC U.S. PHONE EXT ELEC BUS POC NON-U.S. PHONE ELEC BUS POC FAX U.S. ONLY ELEC BUS POC EMAIL ALT ELEC POC BUS POC FIRST NAME ALT ELEC POC BUS POC MIDDLE INITIAL ALT ELEC POC BUS POC LAST NAME ALT ELEC POC BUS POC TITLE ALT ELEC POC BUS ST ADD 1 ALT ELEC POC BUS ST ADD 2 ALT ELEC POC BUS CITY ALT ELEC POC BUS ZIP/POSTAL CODE ALT ELEC POC BUS ZIP CODE +4 ALT ELEC POC BUS COUNTRY CODE ALT ELEC POC BUS STATE OR PROVINCE ALT ELEC POC BUS U.S. PHONE ALT ELEC POC BUS U.S. PHONE EXT ALT ELEC POC BUS NON-U.S. PHONE ALT ELEC POC BUS FAX U.S. ONLY ALT ELEC POC BUS EMAIL NAICS EXCEPTION COUNTER NAICS EXCEPTION STRING DELINQUENT FEDERAL DEBT FLAG EXCLUSION STATUS FLAG SBA BUSINESS TYPES COUNTER SBA BUSINESS TYPES STRING NO PUBLIC DISPLAY FLAG DISASTER RESPONSE COUNTER DISASTER RESPONSE STRING END OF RECORD INDICATOR

DataFile1, 2 and 3 are to large to post. I am including a screenshot of one as an example as to what is in all of them. As long as the code can accomidate the example file, incorporate it how you wish.