Lab 05 Report - Pine Valley Furniture

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.

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

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.