Winform Set 03
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 03 as PDF for free.
More details
- Words: 569
- Pages: 3
PRACTICAL EXAMINATION QUESTION PAPER Winforms Set 03
Semester:
Curriculum:
ACCP
Date:
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, sql, ...) in the created folder, do not classify into sub-folders. All other locations will be ignored.
ACCP2003 - Year 2 – Winform Practical – Set 3 – Page 1
Question (30 marks) Create a “Personal Assistant” application with the following specifications: Using SQL Server Database named: “PersonalAssistant” on LOCAL SQL-SERVER, with the data files to be named as Personal Assistant. MDF and Personal Assistant. LDF and SAVED on folder … \<Student Number>. Given below is the table structure to be used
-
The application interface as show in Figure 1 below. (8 marks)
Input Area
Datagrid
-
ACCP2003 - Year 2 – Winform Practical – Set 3 – Page 2
Input Area DataGrid
Figure 1
-
The Category combo box included the following items: Business, Colleagues, Familly and Friends (1 mark)
-
Date of Birth is the ‘Date Time Picker’ control and default value is set to current date (1 mark)
-
At startup, all buttons are disabled, except ‘Add’ and ‘Close’ button. In addition, all controls in the Input area are disabled too. (1 mark)
-
When user clicked on ‘Add’ button: the ‘Add’, ‘Edit’ and ‘Delete’ button will be disabled, the ‘Save’, ‘Cancel’ and ‘Close’ button will be enabled and all controls in the Input area will be enabed and set to blank. Allow user to enter data in to the controls. (4 marks)
-
When user clicked on ‘Edit’ button: the ‘Add’, ‘Edit’ and ‘Delete’ button will be disabled, the ‘Save’, ‘Cancel’ and ‘Close’ button will be enabled and all controls in the Input area will be enabed allow user to edit existed data in the controls. (4 marks)
-
The following validations should be performed:
o Name, Address, Email should not be blank (3 marks) o If Date of Birth is entered then the year should not be greater than 1990 (2 marks) -
When user clicked on ‘Delete’ button, the message box below should be displayed: If user click ‘Yes’ then the selected contact will be deleted in database. (4 marks)
-
Note: The ‘Edit’ and ‘Delete’ button will be enabled only when the Datagrid have at least 1 row of data is selected. When user select a row in Datagrid, all the information of the selected contact will be fill in the Input area (3 marks)
-
When user clicked on ‘Save’ button, the data in the Input Area should be corresponding Insert/Update into Database and display the message box ‘Save successfully’, The ‘Add’, ‘Close’ button will be enabled, the ‘Save’, ‘Cancel’ button will be disabled. In addition, the Datagrid should be refreshed to display the new data. (7 marks)
-
When user clicked on ‘Cancel’ button, all controls in the Input area should be disabled. The ‘Add’, ‘Close’ button will be enabled, the ‘Save’, ‘Cancel’ button will be disabled. (1 mark)
-
When user clicked on ‘Close’ button, the application should be closed. (1 mark)
ACCP2003 - Year 2 – Winform Practical – Set 3 – Page 3
Semester:
Curriculum:
ACCP
Date:
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
ACCP2003 - Year 2 – Winform Practical – Set 3 – Page 1
Question (30 marks) Create a “Personal Assistant” application with the following specifications: Using SQL Server Database named: “PersonalAssistant” on LOCAL SQL-SERVER, with the data files to be named as Personal Assistant. MDF and Personal Assistant. LDF and SAVED on folder … \<Student Number>. Given below is the table structure to be used
-
The application interface as show in Figure 1 below. (8 marks)
Input Area
Datagrid
-
ACCP2003 - Year 2 – Winform Practical – Set 3 – Page 2
Input Area DataGrid
Figure 1
-
The Category combo box included the following items: Business, Colleagues, Familly and Friends (1 mark)
-
Date of Birth is the ‘Date Time Picker’ control and default value is set to current date (1 mark)
-
At startup, all buttons are disabled, except ‘Add’ and ‘Close’ button. In addition, all controls in the Input area are disabled too. (1 mark)
-
When user clicked on ‘Add’ button: the ‘Add’, ‘Edit’ and ‘Delete’ button will be disabled, the ‘Save’, ‘Cancel’ and ‘Close’ button will be enabled and all controls in the Input area will be enabed and set to blank. Allow user to enter data in to the controls. (4 marks)
-
When user clicked on ‘Edit’ button: the ‘Add’, ‘Edit’ and ‘Delete’ button will be disabled, the ‘Save’, ‘Cancel’ and ‘Close’ button will be enabled and all controls in the Input area will be enabed allow user to edit existed data in the controls. (4 marks)
-
The following validations should be performed:
o Name, Address, Email should not be blank (3 marks) o If Date of Birth is entered then the year should not be greater than 1990 (2 marks) -
When user clicked on ‘Delete’ button, the message box below should be displayed: If user click ‘Yes’ then the selected contact will be deleted in database. (4 marks)
-
Note: The ‘Edit’ and ‘Delete’ button will be enabled only when the Datagrid have at least 1 row of data is selected. When user select a row in Datagrid, all the information of the selected contact will be fill in the Input area (3 marks)
-
When user clicked on ‘Save’ button, the data in the Input Area should be corresponding Insert/Update into Database and display the message box ‘Save successfully’, The ‘Add’, ‘Close’ button will be enabled, the ‘Save’, ‘Cancel’ button will be disabled. In addition, the Datagrid should be refreshed to display the new data. (7 marks)
-
When user clicked on ‘Cancel’ button, all controls in the Input area should be disabled. The ‘Add’, ‘Close’ button will be enabled, the ‘Save’, ‘Cancel’ button will be disabled. (1 mark)
-
When user clicked on ‘Close’ button, the application should be closed. (1 mark)
ACCP2003 - Year 2 – Winform Practical – Set 3 – Page 3
Related Documents
Winform Set 03
November 2019 0
Winform Set 02
November 2019 0
Winform Set 04
November 2019 1
Winform Set 01
November 2019 0
Winform Set 05
November 2019 0