A Stationery supplier “Adwaat Al Maktabiyah” needs a program to display sales as per regions and add the sales to the file called sales.txt. The files Personal Details.txt and Sales.txt have been provided. You may download and use them in your program. They are as shown below: PersonalDetails.txt Id First name Last Name Region E111 Alvin Jones East C121 Blake Kivell Central C253 Edda Jardine Central Sales.txt Rep_Id OrderDate Region Item Units UnitCost E111 1/6/2020 East Pencil 95 1.99 C121 1/23/2020 Central Binder 50 19.99 C253 2/9/2020 Central Pencil 36 4.99 Note: - Use structures in the coding and declare structure array as public as shown below. The question 7 doesn’t need arrays. Structure personaldetails Dim rid As String ' Employee id Dim fn As String 'First name Dim ln As String 'Last name Dim rn As String ' Region he belongs to End Structure Structure Regionalsales Dim id As String 'employee id Dim od As Date 'Order Date Dim region As String 'order region Dim item As String ' product name Dim unit As Integer ' Quantity of items Dim unitcost As Double ' price of a unit End Structure Public pd(perdet.Count - 1) As personaldetails Public rs(sales.Count - 1) As Regionalsales Public reg As String 1. Design the following forms. a. Add Label with the text “Adwaat AL Maktabiyah”. 3 Mark i. Dock: Top ii. Autosize: False iii. TextAlign: Middle, Center b. Add a button and button text as “Add New Order”. 1 Mark c. Add a button and text as “Exit Application”. 1 Mark d. Add a datagridview and name it dgv1. 1 Mark e. Add formText as Your Id. 0.5 Mark f. Save the with the name mainform.vb. 0.5 Mark

A Stationery supplier “Adwaat Al Maktabiyah” needs a program to display sales as per regions and add the sales to the file called sales.txt. The files Personal Details.txt and Sales.txt have been provided. You may download and use them in your program. They are as shown below: PersonalDetails.txt Id First name Last Name Region E111 Alvin Jones East C121 Blake Kivell Central C253 Edda Jardine Central Sales.txt Rep_Id OrderDate Region Item Units UnitCost E111 1/6/2020 East Pencil 95 1.99 C121 1/23/2020 Central Binder 50 19.99 C253 2/9/2020 Central Pencil 36 4.99 Note: - Use structures in the coding and declare structure array as public as shown below. The question 7 doesn’t need arrays. Structure personaldetails Dim rid As String ' Employee id Dim fn As String 'First name Dim ln As String 'Last name Dim rn As String ' Region he belongs to End Structure Structure Regionalsales Dim id As String 'employee id Dim od As Date 'Order Date Dim region As String 'order region Dim item As String ' product name Dim unit As Integer ' Quantity of items Dim unitcost As Double ' price of a unit End Structure Public pd(perdet.Count - 1) As personaldetails Public rs(sales.Count - 1) As Regionalsales Public reg As String 1. Design the following forms. a. Add Label with the text “Adwaat AL Maktabiyah”. 3 Mark i. Dock: Top ii. Autosize: False iii. TextAlign: Middle, Center b. Add a button and button text as “Add New Order”. 1 Mark c. Add a button and text as “Exit Application”. 1 Mark d. Add a datagridview and name it dgv1. 1 Mark e. Add formText as Your Id. 0.5 Mark f. Save the with the name mainform.vb. 0.5 Mark