winform set 02

8/14/2019 Winform Set 02

1/5

PRACTICAL EXAMINATION

QUESTION PAPER

Winforms

Set 02

Semester: Curriculum: ACCPDate: 4/12/2005 Duration: 2 Hours

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 otherlocations will be ignored.

Winform Practical Set 2 Page 1


2/5

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

Column Description

CatCode Item Category code

CatDescription Description of category

Table: User

Column Description

UserName User Name

Password Password

Status Status

Table: Items

Column Description

ItemCode Item Code

ItemDesc Description

ItemCat Category

Price Price

Qoh Quantity on hand

Comp Compliments if any

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

.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



3/5

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



4/5

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



5/5


winform set 02

Documents