Winform Set 02
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Winform Set 02 as PDF for free.
More details
- Words: 507
- Pages: 5
PRACTICAL EXAMINATION QUESTION PAPER Winforms Set 02
Semester:
Curriculum:
ACCP
Date:
Duration:
2 Hours
4/12/2005
Total Marks: 30
Important to students Read carefully the following instructions before doing your work on the examination. Your work will NOT be accepted for evaluation UNLESS it conforms to all the instructions. -
Students must create a folder named in the specified location (e.g. d:\Online) and save all necessary files (including source, class, html, database, txt, ...) in the created folder, do not classify into sub-folders. All other locations will be ignored.
Winform Practical – Set 2 – Page 1
Question (30 marks) SupperShoppe, one of the leading department stores, is in need of a stock maintenance system. Given below is the table structure to be used: Table: Category Table: Items Column Description Column Description CatCode Item Category code ItemCode Item Code CatDescription Description of category ItemDesc Description ItemCat Category Table: User Price Price Column Description Qoh Quantity on hand UserName User Name Comp Compliments if any Password Password Status Status The database must be created in SQL server, and student must generate the script of creating tables and write down script to insert data into tables. All scripts must be submitted in the file <Student Number>.SQL and save in the submitted folder. Develop a MDI application for the client mentioned above, providing the following functionalities: 1. Login (9 marks) At start-up, the application should prompt for a valid user name and password as shown in Figure 1 below. In addition to the user name and password, the status of the user name is also to be considered for verification. A status value of 0 (zero) and 1(one) can be used to signify the status being active and inactive respectively. Only the active user names are valid. The application should terminate if the user clicked on cancel button.
Figure 1 Winform Practical – Set 2 – Page 2
2. Add Category (5 marks) Adds new category to the category table as shown in Figure 2 below. The category code entered should not be an existing one.
Figure 2 3. Add Item: (9 marks) Adds new items to the item table as shown in Figure 3. The item code has to be auto generated. The item code will be of 8 digits format including leading zeros. The textbox for compliments should contain the text “no compliments” by default.
Figure 3 Winform Practical – Set 2 – Page 3
4. Update Stock (8 marks) This option permits to update the current stock of the available items by adding more quantities, as shown in Figure 4. The user should be able to enter or select a particular item code and on selection it should display the details of the item. Then the user can modify both quantity and compliment details.
Figure 4 5. Main form (9 marks) Create a tool bar as shown in Figure 5 with four buttons representing the above functionalities.
Figure 5
Winform Practical – Set 2 – Page 4
Winform Practical – Set 2 – Page 5
Semester:
Curriculum:
ACCP
Date:
Duration:
2 Hours
4/12/2005
Total Marks: 30
Important to students Read carefully the following instructions before doing your work on the examination. Your work will NOT be accepted for evaluation UNLESS it conforms to all the instructions. -
Students must create a folder named
Winform Practical – Set 2 – Page 1
Question (30 marks) SupperShoppe, one of the leading department stores, is in need of a stock maintenance system. Given below is the table structure to be used: Table: Category Table: Items Column Description Column Description CatCode Item Category code ItemCode Item Code CatDescription Description of category ItemDesc Description ItemCat Category Table: User Price Price Column Description Qoh Quantity on hand UserName User Name Comp Compliments if any Password Password Status Status The database must be created in SQL server, and student must generate the script of creating tables and write down script to insert data into tables. All scripts must be submitted in the file <Student Number>.SQL and save in the submitted folder. Develop a MDI application for the client mentioned above, providing the following functionalities: 1. Login (9 marks) At start-up, the application should prompt for a valid user name and password as shown in Figure 1 below. In addition to the user name and password, the status of the user name is also to be considered for verification. A status value of 0 (zero) and 1(one) can be used to signify the status being active and inactive respectively. Only the active user names are valid. The application should terminate if the user clicked on cancel button.
Figure 1 Winform Practical – Set 2 – Page 2
2. Add Category (5 marks) Adds new category to the category table as shown in Figure 2 below. The category code entered should not be an existing one.
Figure 2 3. Add Item: (9 marks) Adds new items to the item table as shown in Figure 3. The item code has to be auto generated. The item code will be of 8 digits format including leading zeros. The textbox for compliments should contain the text “no compliments” by default.
Figure 3 Winform Practical – Set 2 – Page 3
4. Update Stock (8 marks) This option permits to update the current stock of the available items by adding more quantities, as shown in Figure 4. The user should be able to enter or select a particular item code and on selection it should display the details of the item. Then the user can modify both quantity and compliment details.
Figure 4 5. Main form (9 marks) Create a tool bar as shown in Figure 5 with four buttons representing the above functionalities.
Figure 5
Winform Practical – Set 2 – Page 4
Winform Practical – Set 2 – Page 5
Related Documents
Winform Set 02
November 2019 0
Winform Set 04
November 2019 1
Winform Set 01
November 2019 0
Winform Set 03
November 2019 0
Winform Set 05
November 2019 0