Aptech Asp.net Assignments (5)

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:

Server local
Database Final
UID final
PWD Webform

Figure 1 is the diagram of the database schema:

Database Schema

Figure 1: 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:

Product browser page screen shot

Figure 2: Product browser page screen shot

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:

  1. When the page is loaded, display all product categories from Categories table to the Select Category drop down list.
    [Mark: 5]
  2. 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
    c.    Price

    Update the Product Category label with the selected category.
    [Mark: 20]

  3. 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
    d.    Servings
    e.    Product specifications (from ProductDetails table)

    The currently-selected product should have a red border to indicate its selected status.
    [Mark: 25]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s