Lab 06 Report - Pine Valley Furniture

main.aspx - Homepage providing navigation to all pages, adapts based on user role (Customer or Employee).
Register.aspx - Allows customers to create accounts. Adds records to CUSTOMER_t table.
Search.aspx - Lets logged-in customers search products by description, view details, and add to cart. Supports "Show All" option.
Cart.aspx - Displays the latest order for the customer, including product, quantity, price, and grand total. Provides checkout button.
EmployeeLogin.aspx - Employee login page validating credentials against EMPLOYEE_t. Sets session and redirects to dashboard.
Update_Catalog.aspx - Employees can update product details like description, finish, and price.
Update_Customer.aspx - Allows updating customer details such as name, address, city, and postal code.
Payment.aspx - Placeholder page for payment processing.
Help.aspx - Provides guidance for using the system.

Customers: Search products, add to cart, view/update personal info, proceed to checkout.
Employees: Login via EmployeeLogin.aspx, manage catalog and customer info, update records. Cannot place orders.

Orders: Adds products to ORDER_t and Order_line_t, creating new orders if none exist for today.
Updates quantity automatically if a product already exists in the order.
Customer and catalog updates use dynamic SQL queries to reflect changes in the database.

Background color: Light cream (#FFF2E0) for a soft look.
Headers: Purple (#898AC4), centered.
Navigation bar: Styled with hover effects.
Buttons: Rounded with hover transitions and consistent spacing.
Product cards: Structured layout with padding, borders, and soft backgrounds.
Authentication and update forms: Centered with padding, shadow, and border-radius.

Role-based access control for Customer and Employee roles.
Cart displays totals and grand total dynamically.
Employee login restricts access to administrative functions.
Database operations ensure proper order creation, quantity updates, and data consistency.