Question: Please look at the following project description and post a solution of the code (in C#), web app screens and anything else important to your
Please look at the following project description and post a solution of the code (in C#), web app screens and anything else important to your solution!
Here are information needed from the files (refer to the project description!
Asset class - firm map:

Firm Info:

Project Description: Develop a web page that accepts 2 file inputs. The file can be in any format (.csv or .xlsx), sample files are provided herewith. Details of what the file contains is explained below: File 1: Firm Info.xlsx Contains information on the Names of the Firms and the associated Firm IDs File 2: Asset Class - Firm Map.xlsx Contains details on Asset Classes that the Firms (Firms Ids) are interested in. Parse the information in the files and represent the interested Firm-Asset Class Map in a tabular format. HTML Table: The column headers will be the Asset Class Names arranged in alphabetically ascending order and the left row should have the Firm Names arranged in alphabetically ascending order. Assign an 'X'in the Firm Name - Asset Class intersecting cell if that Firm is interested in that asset class (determined from the information in File 2: Asset Class - Firm Map.xlsx). For Eg, if Firm 1 is interested in Ags asset class and Firm 2 is interested in BTC and EQ asset class then you will represent that as below: BTC EQ AGS X Firm1 Firm2 X X This table that depicts the interested Firm-Asset Class Map should be on the same page, below the aforesaid Input File block. Languages/ Web Technologies/ Frameworks: ASP.NET (MVC), C# Above are the preferred languages but you can use whatever you are comfortable with. Output Deliverables: Zip the Project Code Snapshots of the Webpage A D E F 1 2 3 4 5 6 7 8 9 10 11 12 13 gggEEEEEEEEEEEUU duda 14 15 16 17 18 19 20 21 22 23 24 25 26 27 Asset Class ID Asset Class Name Interested Firms (ID) AC0001 A0007 ACO001 B0006 AC0001 EQ B0007 AC0002 IR A0007 AC0003 BTC A0001 ACO003 BTC A0007 AC0003 BTC A0003 AC0003 BTC A0006 AC0003 BTC A0005 AC0003 BTC B0002 AC0003 BTC B0003 ACO003 BTC B0004 AC0003 BTC B0005 AC0003 BTC B0006 AC0003 BTC B0007 AC0004 NG A0007 AC0005 CL A0001 AC0005 CL A0007 AC0005 CL A0003 ACO005 CL A0006 AC0005 CL B0003 ACO005 CL B0004 ACO005 CL B0005 AC0005 CL B0006 AC0005 CL B0007 ACOODS Metals A0007 ACO007 Electricity A0001 ACO007 Electricity A0007 ACOOO7 Electricity BOODS ACO007 Electricity B0006 ACO007 Electricity B0007 ACO008 Coal A0001 AC0008 Coal A0007 AC0008 Coal A0003 AC0008 Coal B0004 AC0008 Coal B0005 AC0008 Coal B0006 AC0008 Coal B0007 AC0009 Ags A0001 AC0009 Ags A0007 AC0009 Ags A0003 AC0009 Ags A0006 AC0009 Ags A0005 AC0009 Ags A0004 AC0009 Ags B0001 AC0009 Ags B0002 AC0009 Ags B0003 AC0009 Ags B0004 AC0009 Ags BOODS AC0009 Ags B0006 AC0009 Ags B0007 AC0010 FX A0007 AC0010 FX B0007 28 29 30 31 32 33 35 36 37 38 30 45 46 50 51 52 53 54 55 56 57 58 90 D B Firm Name ABC1 ABC2 ABC3 ABC4 ABC5 ABC6 1 Firm ID 2 A0007 3 A0001 4 A0003 5 A0006 6 A0005 7 A0004 8 A0002 9 B0001 10 B0002 11 B0003 12 B0004 13 B0005 14 B0006 15 B0007 16 ABC7 XYZ1 XYZ2 XYZ3 XYZ4 XYZ5 XYZ6 |XYZ7 17 18 19 20 Project Description: Develop a web page that accepts 2 file inputs. The file can be in any format (.csv or .xlsx), sample files are provided herewith. Details of what the file contains is explained below: File 1: Firm Info.xlsx Contains information on the Names of the Firms and the associated Firm IDs File 2: Asset Class - Firm Map.xlsx Contains details on Asset Classes that the Firms (Firms Ids) are interested in. Parse the information in the files and represent the interested Firm-Asset Class Map in a tabular format. HTML Table: The column headers will be the Asset Class Names arranged in alphabetically ascending order and the left row should have the Firm Names arranged in alphabetically ascending order. Assign an 'X'in the Firm Name - Asset Class intersecting cell if that Firm is interested in that asset class (determined from the information in File 2: Asset Class - Firm Map.xlsx). For Eg, if Firm 1 is interested in Ags asset class and Firm 2 is interested in BTC and EQ asset class then you will represent that as below: BTC EQ AGS X Firm1 Firm2 X X This table that depicts the interested Firm-Asset Class Map should be on the same page, below the aforesaid Input File block. Languages/ Web Technologies/ Frameworks: ASP.NET (MVC), C# Above are the preferred languages but you can use whatever you are comfortable with. Output Deliverables: Zip the Project Code Snapshots of the Webpage A D E F 1 2 3 4 5 6 7 8 9 10 11 12 13 gggEEEEEEEEEEEUU duda 14 15 16 17 18 19 20 21 22 23 24 25 26 27 Asset Class ID Asset Class Name Interested Firms (ID) AC0001 A0007 ACO001 B0006 AC0001 EQ B0007 AC0002 IR A0007 AC0003 BTC A0001 ACO003 BTC A0007 AC0003 BTC A0003 AC0003 BTC A0006 AC0003 BTC A0005 AC0003 BTC B0002 AC0003 BTC B0003 ACO003 BTC B0004 AC0003 BTC B0005 AC0003 BTC B0006 AC0003 BTC B0007 AC0004 NG A0007 AC0005 CL A0001 AC0005 CL A0007 AC0005 CL A0003 ACO005 CL A0006 AC0005 CL B0003 ACO005 CL B0004 ACO005 CL B0005 AC0005 CL B0006 AC0005 CL B0007 ACOODS Metals A0007 ACO007 Electricity A0001 ACO007 Electricity A0007 ACOOO7 Electricity BOODS ACO007 Electricity B0006 ACO007 Electricity B0007 ACO008 Coal A0001 AC0008 Coal A0007 AC0008 Coal A0003 AC0008 Coal B0004 AC0008 Coal B0005 AC0008 Coal B0006 AC0008 Coal B0007 AC0009 Ags A0001 AC0009 Ags A0007 AC0009 Ags A0003 AC0009 Ags A0006 AC0009 Ags A0005 AC0009 Ags A0004 AC0009 Ags B0001 AC0009 Ags B0002 AC0009 Ags B0003 AC0009 Ags B0004 AC0009 Ags BOODS AC0009 Ags B0006 AC0009 Ags B0007 AC0010 FX A0007 AC0010 FX B0007 28 29 30 31 32 33 35 36 37 38 30 45 46 50 51 52 53 54 55 56 57 58 90 D B Firm Name ABC1 ABC2 ABC3 ABC4 ABC5 ABC6 1 Firm ID 2 A0007 3 A0001 4 A0003 5 A0006 6 A0005 7 A0004 8 A0002 9 B0001 10 B0002 11 B0003 12 B0004 13 B0005 14 B0006 15 B0007 16 ABC7 XYZ1 XYZ2 XYZ3 XYZ4 XYZ5 XYZ6 |XYZ7 17 18 19 20
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
