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...
icon
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
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: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
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
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 6 steps with 4 images

Blurred answer
Similar questions
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
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 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)
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
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY