Lab 06 Report - Pine Valley Furniture
Website Pages & Their Purpose
- 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.
Role-Based Access
- 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.
Database Integration
- 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.
CSS Styling (style.css)
- 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.
Key Functional Enhancements
- 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.