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
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
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

Transcribed Image Text: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:
First name Last Name Region
E111 Alvin
C121 Bake
C253 Ecda
Id
Region item
Units UnitCost
Rep_ld OrderDate
E111 1/6/2020 East
C121 1/23/2020 Central Binder 50
C253 2/9/2020 Central Pencil 36
Jones
East
Pencil 95
1.99
Kivel
Central
19.99
Jardire
Central
4.99
PersonalDetails.txt
Sales.txt
Note: - Use structures in the coding and declare structure array as public as shown below. The question 7
doesn't need arrays.
Structure personaldetails
Din rid As String 'Employee id
Din fn As String
Din In As String
Din rn As String
End Structure
'First name
"Last name
' Region he belongs to
Structure Regionalsales
Din id As String 'employee id
od As Date "Order Date
Din region As String 'order region
iten As String product nane
Din unit As Integer Quantity of items
Din 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". I Mark
c. Add a button and text as "Exit Application".
d. Add a datagridview and name it dgvl.
e. Add formText as Your Id.
f. Save the with the name mainform.vb.
1 Mark
I Mark
0.5 Mark
0.5 Mark
Your ld
Adwaat Al Maktabiyah
Add New Order
Exit Application
2. Add a new form and save it as Displaysales.vb
a. Add a datagridview and a button as shown below.
1 Mark
Ext
3. Add a new form and save it as AddNewSales.vb
a. Add Label with the text "Add New Sales".
i. Dock: Top
ii. Autosize: False
iii. TextAlign: Middle, Center
iv. Apply Backcolor of your choice
3 Mark
b. Design the form as shown below:
4 Marks
X
aAddNewSales
Add New Sales
Order Date
Empld
Region
Item
Unit price
Unts
Add Sales to the fike
Exit

Transcribed Image Text:4. Private Sub MainForm_Load(ByVal sender As Object, Byval e As
System. EventArgs) Handles Me. Load
a. Write query to display Region and Total of sales as shown below.
5 Marks
Adwaat Al Maktabiyah
Region Total
Add New Order
East
6002.09
Central 11139.07
West
2486.72
Exit Application
5. Private Sub btnexit_Click(sender As System.Cbject, e As System. Eventargs) Handles btnExit.C1ick
a. Display messagebox to exit from application, if yes, exit application
2 Marks
6. Private Sub dgvi_CellContentClick(Byval sender As System.bject, Byval e As
System. Nindows.Forns.DataGridvicacellEventargs) Handles dgvi.CellcontentClick
I Mark
1 Mark
a. Get the contents of a selected cell in a public variable reg as string
b. Open form, Displaysales
7. Private Sub Displaysales Load(Byval sender As Systen.Object, Byval e As System. Eventargs) Handles
Myllase.Lead
a. Write a query to display sales of the selected region in the datagridviewlas shown below.
3 Marks
Display Seks
Enp id
Order Date
tem
Unts
Unt Cot
Tatal
E111
16/2020
Penal
199
139 05
E111
4/1/2020
Bnder
60
499
2994
E111
Brder
60
199
5394
12/2020
Brder
29
199
57.71
E420
7/29/2020
Brder
81
1999
1619 19
E11
VI5/2020
Penal
35
499
174 65
E11
S/18/2020
Pen Set
16
15.99
255 34
E111
10/22/2020
Pen
64
399
Exit
8. Private Sub btnNeuorder_Click(Byval sender As Systen.Object, Byval e As Systen. EventArgs) Handles
btnkeworder .click
a. Add the following data to the Sales.txt file.
Empid : Your ld
Order Date: 4/10/2022
Region: Central
3 Marks
Item: TextBook
Units: 5
Unit cost: 5
AddNewSales
Add New Sales
Order Date 104/10/2022
Erpld
Save
Cen
Regon
Tetbook
Saved Record into Sales.bt
5
Unts
Add Sa
OK
Exit
pymm
Eme
Order Date
Bem
Unte
Ln Cot
Tota
C121
Pen Set
42
2399
C456
10/2021
Penc
129
903
cars
10/31/2021
Penc
14
1.29
18.06
C2s3
1/17/202
inde
11
499
54.09
C253
12/4/2021
Dnder
94
1999
ca
12/21/2021
2
4.99
C1234E
125
C1234
Tet
25
Exit
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 6 steps with 4 images

Recommended textbooks for you

Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON

Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science

Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning

Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON

Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science

Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning

Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning

Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education

Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY