Visual Basic, VB.Net Learn how to work with data storage elements - arrays, structures, LINQ. Programming Project One will work with Recruiting Activities data that is stored as csv records in a text file. This file must be placed in the projects bin/Debug folder. Format of each record: Employee Id String (S1304-0997) - First letter S (staff), F (faculty), A (administration) - Next 4 numbers Identify the department - Last 4 numbers Employee Activity Name - String Location String Date Date Number of Students Integer Cost of Activity - Decimal Sample Data (Store in a text file, Activities.txt): S1306-1012,MGM Jag Days,Shelby Hall,01/16/2023,38,19.00 F1304-0998,MGM Jag Days,Shelby Hall,01/16/2023,38,0.0 F1304-0204,MGM Jag Days,Shelby Hall,01/16/2023,38,0.0 S1306-1012,Davidson Jag Days,Shelby Hall,02/23/2023,44,22.00 F1304-0998,MCPSS College & Career Fair,Mitchell Center,09/12/2022,950,725.00 S1306-1012,USA Day,Shelby Hall,04/22/2023,450,225.00 A1306-0998,Spanish Fort HS Class Visit,Spanish Fort High School,10/10/2022,85,22.50 S1306-1012,Satsuma HS Career Fair,Satsuma High School,10/12/2022,122,76.00 S1306-1012,Baker HS Class Visit,Baker High School,02/22/2023,66,40.00 S1306-1012,Gulf Shores HS Career Fair,Gulf Shores High School,03/14/2023,74,88.75 Project Requirements: Create the text file and name it Activities.txt. Be sure it is located in the projects bin/Debug folder. Create a UDT (User Defined Type) Structure, Activity, that will define the format for each record. Create a class-level string array, strActivities, to hold the records that are stored in the text file, Activities.txt. Populate this array from the text file. Create a class-level structure array, activities, to hold the records after they have been divided into separate fields using the structure Activity. Set the array size using the size of string array strActivities. 1 Load Event: Using the strActivities array, populate the activities array. 2 Generate Master Stats Query Report (LINQ) List all activities in ascending descending Date order. The query result should include: Activity Name, Activity Date, Number of Students and Cost of Activity. The accumulated number of students and cost are to be displayed at bottom of this report (Hint: Handle this at display time; not as part of the query). The output should be displayed in a well-formatted form. An acceptable example is shown below: 3 Employee Query Report (LINQ) The user will enter an EmployeeId. A query will be used to search and locate all activities that the specified employee has/will participate in. Include the activity name, date and location in the query results. If matching records are found for the employeeId, display the query results. (Example shown on first image below.) If no records are found for the employee with the given employeeId, a message should be displayed indicated so. (Example shown on second image below.) The output should be displayed in a well-formatted form. An acceptable example is shown below. 4 Activity List Query Report (LINQ) List all activities that will be participated in. Only list each activity once (remove any duplicates). Order the results in ascending activity name order (in alphabetical order). Results should include only the activity name. The output should be displayed in a well-formatted form. An acceptable example is shown below: 5 By Department Query Report (LINQ) Use a LINQ to list all activities by department (the first numeric portion of the employeeId). The activities should also be placed in alphabetic activity order within each department. The query results should include the department number, employeeId, activity name, and activity date. When generating the output, the report should include a subheading that identifies the current department number (Shown next to the black arrow in the images below.) To code this correctly, you CANNOT code the literal numeric values into your code; i.e. You cant use the values 1304 & 1306 or a count of current records in the code. You need to write the code so it will work if new records are added to or deleted from the file Note: I think this is the most challenging portion of this project. Im challenging you to develop a solution to a problem that I havent shown you before. You will need to be the problem-solver here rather than just a follower. The output should be displayed in a well-formatted form. An acceptable example is shown below. 6 Create Sorted File (LINQ): Use a LINQ to generate a sorted version of the input file. The new file should contain all records from the original file. The records should be placed in Descending Number of Students order. Once the query results have been created, list the query results records in the output listbox. Finally, create a new file named SortedActivities.txt from the query results. Clear Button Click Event: When this button is clicked, the contents of the listbox should be cleared. Exit Button Click Event: When the user clicks on this button, the program will end. The program should be written using the concepts that are covered in the textbook in chapters 1 7.3 (the material that we are working on.)