In this test you are required to develop a product browser page for an E-commerce company selling food and drink products. The database has been created and data are available, use the following information to access database:
Figure 1 is the diagram of the database schema:
Create a web form project on your local computer with the following information
Virtual Directory: http://localhost/C0305L_Final
Physical Directory : C:\inetpub\wwwroot\C0305L_Final
The product browser page is shown below:
As the application stores the image path for each product, you have to add those images to the web project application folder. Copy the folder \\Backup\mySetups\Images to your web project folder.
Implement the following logic for the page:
- When the page is loaded, display all product categories from Categories table to the Select Category drop down list.
- When Select button is clicked display all products with their information from Products table of the selected category in the list at the page bottom as shown in Figure 2. The products should be displayed horizontally on the page. The following product information should be displayed (refer to Figure 2 for details):a. Product Image
b. Product Name
Update the Product Category label with the selected category.
- The product image should have a hyperlink at which when clicked will display that product details from Products and ProductDetails tables to the page. The following product information should be displayed (refer to Figure 2 for details):a. Product Image
b. Product Name
c. Serving Size
e. Product specifications (from ProductDetails table)
The currently-selected product should have a red border to indicate its selected status.