This section provides a quick preview of questions from the document. It may not display every question or the complete wording of each one. For the full content, including diagrams, tables and other information, view the original PDF above.
10.1Run the solution.
10.2Hold the ALT key down and press the print screen button (This will copy the active screen\
10.3Open MS Word and pa ste the form/screen in a new document.
10.4Add your examination number to the top right hand side of your page.
10.5Print the page. 11. You are allowed to make use of the help files in VB.NET. 12. The following files will appear on your h ard drive in the folders:
Q1— Section header —
Q2— Section header —
Q3— Section header —
Q4— Section header —
Q1— Section header —
Q1— Section header —
1.1FIGURE 1.5 clsTicketSales CalcPrepayment (\ cellnumber tPrice
1.1Add your EXAMINATION NUMBER to the program code as a comment. Add the following code to the TicketSa les class named clsTicketSales
1.1.1Define the private variables for the clsTicketSales class.
1.1.2Write the code to c reate the following public properties for the TicketSales class each referring to set and retrieve the values of the p
Q1— Section header —
1.1Write the code to include a default constructor for the class.
1.1Write the code to include the CalcPrepayment (\ method for the TicketSales class. Th
1.2Add your EXAMINATION NUMBER as a comment to the program c ode of the frmTicketSales module . Add the following program code to the frmTicketSales Instantiate an
1.3Add the code to the Click Event of the btnCalculateSales button
1.3.1(a\ Determine which ticket category has been selected from the combobox ssign the values from the controls to the appropriate object properties. Make use of a Case Select statement
Q2— Section header —
2.1Add the following program code to the GetPolicy (\ sub procedure:
2.1.1Write the program code that will est ablish a connection to the database that would be needed to extract records from the tables.
2.1.2Write an SQL statement that will retrieve the all member' s policy records from the database: member and policy tables. (See STEP 1\ The followin g fields should be shown: LastName, Identityno, PolicyID, PName, Cover, Status.
2.1.3When the frmPolicy is loaded the joined tables should be displayed in the DataGridView. (1\ (10041024\ 14
2.2Crea te a SearchPolicy(\ sub procedure and include a parameterized query that will be used to search for all the corresponding member policies. All policy and member details are listed where the ID number of the member
2.3Add the follo wing program code to the DeletePolicy (\ sub procedure:
2.3.1For the DeletePolicy (\sub procedure, include a parameterized SQL statement that will delete the policy of the member selected. The policy corresponding to the current active record is deleted. The user sh
2.3.2Call the DeletePolicy (\ sub procedure in the btndelete click event. (1\
2.4Run the program a nd delete the policy 100010 for member Khumalo Add your EXAMINATION NUMBER as a comment to the program code
Q3— Section header —
Q3— Section header —
Q4— Section header —
3.1Create an external Cascading Style Sheet (CSS\d save it as style.css. Add your EXAMINATION NUMBER as a comment to the C SS code.
3.1Add a rule set for the header a height of 80 px, centre and padding of 0 15 px. (2\
3.1Add a rule set for the content a width of 150 px float to left, padding of 5 px 15 px. (2\
3.1Add a rule set for sidebar a width of 270 px, padding of 5 px 15 px and float to left. (2\ Make a PRINTOUT of the CSS code (10041024\
3.2Create an HTML file and save it as Index.html. Insert your EXAMINATION NUMBER as the title of the page.
3.2.1Add a link to the external style sheet Style.css. (1\
3.2.2Define the pagewrap division with six div elements. The first element is the header a nd it will contain the heading BFS in the body section (2\
3.2.3Create the content division and insert the hyperli nks using level 5 heading. (2\
3.2.4Create the middle division and insert the heading using level 1 heading, add the image save in the folder
Q3— Section header —
Q3— Section header —
3.2.5Create the sidebar division and insert the heading using a l evel 2 heading Insert the image saved in the folder
Q3— Section header —
3.2.6Use the paragraph text saved in the folder
Q3— Section header —
3.2.7Create the footer division and insert your EXAMINATION NUMBER. (1\ Make a PRINTOUT of the source code. Make a PRINTOUT of the web page from the web browser
Q4— Section header —
4.1Below is a screen print of the Appllication page ( Apply.html FIGURE 4.1 Insert the content for the Application pag e: Insert your EXAMINATION NUMBER as the title to the web page.
4.1.1Create a borderless table to align the controls of the form. (2\
4.1.2Create the web form a FIGURE 4.1 above . The textbox must accept maximum length of 13 characters and contact must
4.1.3Create a text area with 6 rows and 35 columns for suggestion and comments about the product. A d two buttons for Register and clear (3\
4.1.4Add the picture on the sidebar with height of 255 px and width of 350 px. (3\
4.1.5Use JavaScript and create a user defined function to check whether the user has an e mail in the mail textbox. (8\ FIGURE 4.2
4.1.6Display an appropriate m essage (See FIGURE 4.2 and set the focus into the textbox.\ (2\
4.1.7Write a code to check if the e (5\ FIGURE 4.3
4.1.8 Display an appropriate message (See FIGURE 4.3 and set the focus into the textbox and select the text
4.1.9When the user clicks the s ubmit button display a message Thanking you for participating! (1\ The cancel button clears all th e input boxes.
4.2Make a PRINTOUT of the source code.
4.3Print the web page from the web browser. 30 TOTAL: 100