Lab 05 Report - Pine Valley Furniture
Website Pages & Their Purpose
- main.aspx - Its the homepage providing navigation to all other pages such as search, cart, registration, and help.
- Register.aspx - Allows customers to create an account by entering personal information such as name, address, and state etc. whenever
the customer is registered a record is added in cutomer table in db.
- search.aspx - Enables users to search for products in the database by description. Supports partial matching and displays results dynamically with product name, finish, price, and quantity input for adding to cart.
- Cart.aspx - Displays all products ordered by the logged-in customer (currently hardcoded as Customer ID = 1). Users can see the product, quantity, and price. Adding the same product multiple times increases the quantity instead of creating a new line.
- update_catalog.aspx - Allows updating product information in the catalog including product line, description, finish, and price. Connected directly to the database using dynamic queries.
- update_customer.aspx - Enables updating customer details like name, address, city, state, and postal code. Uses database queries to fetch and update customer records.
- payment.aspx - Placeholder page for payment processing (not implemented in this lab, only linked from the cart page).
- Help.aspx - Provides guidance to users about using the system.
Database Integration
Lab 05 focused heavily on database operations with SQL Server. The main tasks included:
- Customer first searched product then on display customer select quantity and add to cart.
This places orders by inserting records into ORDER_t and Order_line_t tables for Customer ID = 1.
Right now it is hardcoded we are assuming that customer with id=1 is logged in as customer validation is not
implemented yet.
- Displaying all previous orders of the customer dynamically in the cart page.
If a order of a product already exist it checks and
update the quantity.
- Updating catalog entries directly in the database using dynamic SQL queries. It only updates product, it does not add any new product
- Updating customer information by fetching and writing back to CUSTOMER_t table. Customers can get their info
by their customer id and then can update the records
CSS Styling (style.css)
All pages follow a consistent design using an external CSS file:
- Background color: Light cream (#FFF2E0) for a soft look.
- Headers: Purple (#898AC4) with centered text.
- Navigation bar: Soft purple tones with hover effects.
- Buttons: Rounded with hover color transitions and consistent spacing.
- Product cards: Structured layout with spacing, borders, and soft backgrounds.
- Authentication/update boxes: Centered forms with padding, shadow, and border radius.
Back to dashboard