🛍️ E-commerce Web Application

A complete online shopping platform for fashion enthusiasts, showcasing the latest trends in women's and men's clothing. Built with ASP.NET and C# for beginners to learn web development fundamentals.

📋 Table of Contents

• Overview
• Features
• Tech Stack
• Prerequisites
• Installation
• Database Setup
• Configuration
• Project Structure
• Usage Guide
• Screenshots
• Learning Resources
• Contributing
• License

---

🎯 Overview

This e-commerce web application is designed as a beginner-friendly project to help developers learn ASP.NET web forms, C# programming, and SQL Server database integration. The platform provides a complete online shopping experience with product browsing, cart management, user authentication, and order processing.

🎓 Perfect For:

• Students learning ASP.NET and web development
• Beginners wanting hands-on experience with C#
• Developers exploring e-commerce fundamentals
• Teaching web application architecture

🌟 What You'll Learn:

• ASP.NET Web Forms architecture
• Master Pages for consistent layouts
• C# code-behind implementation
• SQL Server database design and integration
• Session management and authentication
• Shopping cart functionality
• Admin panel development
• CRUD operations (Create, Read, Update, Delete)

---

✨ Features

🛒 Customer Features

Product Browsing

• Home Page - Featured products and latest collections
• Category Pages - Browse products by category
• Product Details - Detailed product information with images
• Search Functionality - Find products quickly
• Responsive Catalog - Grid and list views

Shopping Experience

• Shopping Cart - Add/remove items, update quantities
• Cart Summary - Real-time price calculation
• Wishlist - Save favorite items for later
• Product Reviews - Customer ratings and feedback
• Stock Availability - Real-time inventory status

User Account

• User Registration - Create new customer accounts
• Login/Logout - Secure authentication system
• Profile Management - Update personal information
• Order History - View past orders and status
• Address Book - Save multiple shipping addresses

Checkout Process

• Secure Checkout - Multi-step checkout flow
• Order Summary - Review before purchase
• Order Confirmation - Email notifications
• Payment Integration Ready - Placeholder for payment gateways

---

👨‍💼 Admin Features

Product Management

• Add Products - Create new product listings
• Edit Products - Update product information
• Delete Products - Remove discontinued items
• Product Categories - Organize products hierarchically
• Image Upload - Product photo management
• Inventory Control - Stock level management

Order Management

• View Orders - Complete order dashboard
• Order Status - Update order processing stages
• Order Details - Customer and product information
• Order Search - Filter by date, status, customer
• Print Invoices - Generate order receipts

User Management

• Customer List - View all registered users
• User Details - Customer information and order history
• Account Status - Enable/disable accounts
• Admin Accounts - Manage administrative users

Content Management

• About Us Page - Company information
• Contact Us - Inquiry form and contact details
• Static Pages - Manage informational content
• Banner Management - Homepage promotional slides

---

🛠️ Tech Stack

Backend

• Framework: ASP.NET Web Forms (.NET Framework 4.5+)
• Language: C# 6.0+
• Database: Microsoft SQL Server 2014+
• ORM: ADO.NET (SqlClient)
• Server: IIS (Internet Information Services)

Frontend

• Markup: HTML5, ASPX
• Styling: CSS3, Bootstrap 3/4
• Scripting: JavaScript, jQuery
• UI Components: ASP.NET Server Controls
• Icons: Font Awesome

Development Tools

• IDE: Visual Studio 2015/2017/2019/2022
• Database Tool: SQL Server Management Studio (SSMS)
• Version Control: Git
• Browser DevTools: Chrome/Firefox Developer Tools

---

📋 Prerequisites

Before you begin, ensure you have the following installed:

Required Software

Software	Version	Download Link
Visual Studio	2015 or later	Download
SQL Server	2014 or later	Download
SSMS	Latest	Download
.NET Framework	4.5 or later	Included with Visual Studio
IIS	7.0+	Windows Feature

System Requirements

• OS: Windows 7/8/10/11 or Windows Server
• RAM: 4GB minimum (8GB recommended)
• Storage: 2GB free space
• Browser: Chrome, Firefox, Edge, or Safari (latest version)

---

🚀 Installation

Step 1: Clone the Repository

git clone https://github.com/touficSl/ecommerce.git
cd ecommerce

Step 2: Open in Visual Studio

1. Launch Visual Studio
2. Click File → Open → Project/Solution
3. Navigate to the cloned folder
4. Select the .sln file (if present) or open as a Web Site
5. Visual Studio will load all project files

Step 3: Restore NuGet Packages

# In Visual Studio Package Manager Console
Update-Package -Reinstall

Or:

1. Right-click on Solution in Solution Explorer
2. Select Restore NuGet Packages

---

🗄️ Database Setup

Method 1: Using SQL Script (Recommended)

1. Create Database

Open SQL Server Management Studio (SSMS) and execute:

CREATE DATABASE EcommerceDB;
GO

USE EcommerceDB;
GO

2. Create Tables

-- Users Table
CREATE TABLE Users (
    UserID INT PRIMARY KEY IDENTITY(1,1),
    FullName NVARCHAR(100) NOT NULL,
    Email NVARCHAR(100) UNIQUE NOT NULL,
    Password NVARCHAR(255) NOT NULL,
    Phone NVARCHAR(20),
    Address NVARCHAR(500),
    City NVARCHAR(50),
    PostalCode NVARCHAR(10),
    Country NVARCHAR(50),
    IsAdmin BIT DEFAULT 0,
    CreatedDate DATETIME DEFAULT GETDATE(),
    IsActive BIT DEFAULT 1
);

-- Categories Table
CREATE TABLE Categories (
    CategoryID INT PRIMARY KEY IDENTITY(1,1),
    CategoryName NVARCHAR(100) NOT NULL,
    Description NVARCHAR(500),
    ImageURL NVARCHAR(255),
    IsActive BIT DEFAULT 1,
    CreatedDate DATETIME DEFAULT GETDATE()
);

-- Products Table
CREATE TABLE Products (
    ProductID INT PRIMARY KEY IDENTITY(1,1),
    ProductName NVARCHAR(200) NOT NULL,
    Description NVARCHAR(MAX),
    CategoryID INT FOREIGN KEY REFERENCES Categories(CategoryID),
    Price DECIMAL(10,2) NOT NULL,
    DiscountPrice DECIMAL(10,2),
    StockQuantity INT DEFAULT 0,
    ImageURL NVARCHAR(255),
    Brand NVARCHAR(100),
    Gender NVARCHAR(10), -- 'Men', 'Women', 'Unisex'
    Sizes NVARCHAR(100), -- 'S,M,L,XL'
    Colors NVARCHAR(100), -- 'Red,Blue,Green'
    IsFeatured BIT DEFAULT 0,
    IsActive BIT DEFAULT 1,
    CreatedDate DATETIME DEFAULT GETDATE()
);

-- Shopping Cart Table
CREATE TABLE ShoppingCart (
    CartID INT PRIMARY KEY IDENTITY(1,1),
    UserID INT FOREIGN KEY REFERENCES Users(UserID),
    ProductID INT FOREIGN KEY REFERENCES Products(ProductID),
    Quantity INT NOT NULL DEFAULT 1,
    Size NVARCHAR(10),
    Color NVARCHAR(20),
    AddedDate DATETIME DEFAULT GETDATE()
);

-- Orders Table
CREATE TABLE Orders (
    OrderID INT PRIMARY KEY IDENTITY(1,1),
    UserID INT FOREIGN KEY REFERENCES Users(UserID),
    OrderDate DATETIME DEFAULT GETDATE(),
    TotalAmount DECIMAL(10,2) NOT NULL,
    OrderStatus NVARCHAR(50) DEFAULT 'Pending', -- Pending, Processing, Shipped, Delivered, Cancelled
    ShippingAddress NVARCHAR(500),
    ShippingCity NVARCHAR(50),
    ShippingPostalCode NVARCHAR(10),
    ShippingCountry NVARCHAR(50),
    PaymentMethod NVARCHAR(50),
    PaymentStatus NVARCHAR(50) DEFAULT 'Pending',
    TrackingNumber NVARCHAR(100),
    Notes NVARCHAR(1000)
);

-- Order Details Table
CREATE TABLE OrderDetails (
    OrderDetailID INT PRIMARY KEY IDENTITY(1,1),
    OrderID INT FOREIGN KEY REFERENCES Orders(OrderID),
    ProductID INT FOREIGN KEY REFERENCES Products(ProductID),
    Quantity INT NOT NULL,
    Price DECIMAL(10,2) NOT NULL,
    Size NVARCHAR(10),
    Color NVARCHAR(20),
    Subtotal AS (Quantity * Price) PERSISTED
);

-- Contact Messages Table
CREATE TABLE ContactMessages (
    MessageID INT PRIMARY KEY IDENTITY(1,1),
    Name NVARCHAR(100) NOT NULL,
    Email NVARCHAR(100) NOT NULL,
    Subject NVARCHAR(200),
    Message NVARCHAR(MAX) NOT NULL,
    IsRead BIT DEFAULT 0,
    ReceivedDate DATETIME DEFAULT GETDATE()
);

3. Insert Sample Data

-- Sample Categories
INSERT INTO Categories (CategoryName, Description) VALUES
('Women''s Clothing', 'Latest fashion for women'),
('Men''s Clothing', 'Stylish outfits for men'),
('Accessories', 'Fashion accessories'),
('Shoes', 'Footwear collection');

-- Sample Products
INSERT INTO Products (ProductName, Description, CategoryID, Price, StockQuantity, Gender) VALUES
('Summer Dress', 'Elegant floral summer dress', 1, 49.99, 25, 'Women'),
('Casual Shirt', 'Cotton casual shirt for men', 2, 29.99, 40, 'Men'),
('Denim Jeans', 'Classic blue denim jeans', 2, 59.99, 30, 'Unisex'),
('Leather Handbag', 'Premium leather handbag', 3, 89.99, 15, 'Women'),
('Running Shoes', 'Comfortable running shoes', 4, 79.99, 50, 'Unisex');

-- Sample Admin User (password: admin123 - should be hashed in production)
INSERT INTO Users (FullName, Email, Password, IsAdmin) VALUES
('Admin User', 'admin@ecommerce.com', 'admin123', 1);

-- Sample Customer
INSERT INTO Users (FullName, Email, Password, Phone, Address, City) VALUES
('John Doe', 'john@example.com', 'password123', '1234567890', '123 Main St', 'New York');

Method 2: Attach Database File

If you have a .mdf database file:

1. Open SSMS
2. Right-click Databases → Attach
3. Click Add → Browse to your .mdf file
4. Click OK

---

⚙️ Configuration

1. Update Connection String

Open web.config and update the connection string:

<configuration>
  <connectionStrings>
    <add name="EcommerceConnectionString" 
         connectionString="Data Source=YOUR_SERVER_NAME;Initial Catalog=EcommerceDB;Integrated Security=True" 
         providerName="System.Data.SqlClient" />
    
    <!-- OR with SQL Authentication -->
    <add name="EcommerceConnectionString" 
         connectionString="Data Source=YOUR_SERVER_NAME;Initial Catalog=EcommerceDB;User ID=YOUR_USERNAME;Password=YOUR_PASSWORD" 
         providerName="System.Data.SqlClient" />
  </connectionStrings>
</configuration>

Finding Your Server Name:

• Open SSMS
• Server name appears in the connection dialog
• Usually: localhost, .\SQLEXPRESS, or (localdb)\MSSQLLocalDB

2. Configure IIS (Optional for Local Development)

For local development, Visual Studio's built-in IIS Express is sufficient. For production:

1. Open IIS Manager
2. Right-click Sites → Add Website
3. Set:
   • Site name: Ecommerce
   • Physical path: Your project folder
   • Port: 80 or 8080
4. Click OK

3. Application Settings

Additional settings in web.config:

<appSettings>
  <!-- Email Configuration (for order confirmations) -->
  <add key="SMTPServer" value="smtp.gmail.com" />
  <add key="SMTPPort" value="587" />
  <add key="SMTPUsername" value="your-email@gmail.com" />
  <add key="SMTPPassword" value="your-password" />
  
  <!-- File Upload Settings -->
  <add key="ProductImagePath" value="~/Images/Products/" />
  <add key="MaxFileSize" value="5242880" /> <!-- 5MB in bytes -->
  
  <!-- Pagination -->
  <add key="ProductsPerPage" value="12" />
</appSettings>

---

📂 Project Structure

ecommerce/
├── 📁 Images/                      # Product and category images
│   ├── Products/
│   ├── Categories/
│   └── Banners/
├── 📁 CSS/                         # Stylesheets
│   ├── style.css
│   └── admin.css
├── 📁 JS/                          # JavaScript files
│   └── script.js
├── 📁 App_Code/                    # C# class files (optional)
│   ├── DatabaseHelper.cs
│   └── Utilities.cs
├── 📄 Main.master                  # Master page template
├── 📄 Main.master.cs               # Master page code-behind
│
├── 🌐 Customer Pages
│   ├── 📄 Home.aspx                # Homepage with featured products
│   ├── 📄 Home.aspx.cs
│   ├── 📄 Category.aspx            # Product listing by category
│   ├── 📄 Category.aspx.cs
│   ├── 📄 Basket.aspx              # Shopping cart
│   ├── 📄 Basket.aspx.cs
│   ├── 📄 Orders.aspx              # Order history
│   ├── 📄 Orders.aspx.cs
│   ├── 📄 Register.aspx            # User registration
│   ├── 📄 Register.aspx.cs
│   ├── 📄 AboutUs.aspx             # About page
│   ├── 📄 AboutUs.aspx.cs
│   ├── 📄 ContactUs.aspx           # Contact form
│   └── 📄 ContactUs.aspx.cs
│
├── 👨‍💼 Admin Pages
│   ├── 📄 Admin.aspx               # Admin dashboard
│   ├── 📄 Admin.aspx.cs
│   ├── 📄 SignAdmin.aspx           # Admin login
│   └── 📄 SignAdmin.aspx.cs
│
└── 📄 web.config                   # Application configuration

---

💻 Usage Guide

For Customers

1. Browsing Products

Homepage:

http://localhost:port/Home.aspx

• View featured products
• Browse by category
• See latest arrivals

Category Page:

http://localhost:port/Category.aspx?id=1

• Filter products by category
• Sort by price, name, or date
• View product details

2. Shopping Cart

Adding to Cart:

1. Click on a product
2. Select size and color
3. Click "Add to Cart"
4. View cart icon for item count

Managing Cart:

http://localhost:port/Basket.aspx

• Update quantities
• Remove items
• View total price
• Proceed to checkout

3. User Account

Registration:

http://localhost:port/Register.aspx

Required fields:

• Full Name
• Email Address
• Password
• Phone Number
• Shipping Address

Login:

• Use registered email and password
• Access order history
• Manage profile

4. Placing Orders

Checkout Process:

1. Review items in cart
2. Confirm shipping address
3. Select payment method
4. Review order summary
5. Place order
6. Receive order confirmation

Order History:

http://localhost:port/Orders.aspx

• View all past orders
• Check order status
• Download invoices

---

For Administrators

1. Admin Login

http://localhost:port/SignAdmin.aspx

Default Credentials:

• Email: admin@ecommerce.com
• Password: admin123

⚠️ Important: Change default credentials immediately in production!

2. Admin Dashboard

http://localhost:port/Admin.aspx

Dashboard Features:

• Total sales statistics
• Recent orders
• Low stock alerts
• Customer count
• Revenue reports

3. Product Management

Add New Product:

// Code example in Admin.aspx.cs
protected void btnAddProduct_Click(object sender, EventArgs e)
{
    string productName = txtProductName.Text;
    decimal price = decimal.Parse(txtPrice.Text);
    int categoryID = int.Parse(ddlCategory.SelectedValue);
    
    // Save product to database
    SaveProduct(productName, price, categoryID);
}

Upload Product Image:

protected void btnUpload_Click(object sender, EventArgs e)
{
    if (fileUpload.HasFile)
    {
        string fileName = Path.GetFileName(fileUpload.FileName);
        string filePath = Server.MapPath("~/Images/Products/" + fileName);
        fileUpload.SaveAs(filePath);
    }
}

4. Order Management

View Orders:

• Filter by status (Pending, Processing, Shipped, Delivered)
• Search by order ID or customer name
• Update order status
• Print invoices

Update Order Status:

protected void btnUpdateStatus_Click(object sender, EventArgs e)
{
    int orderID = int.Parse(txtOrderID.Text);
    string newStatus = ddlStatus.SelectedValue;
    
    // Update in database
    UpdateOrderStatus(orderID, newStatus);
}

---

🔐 Security Considerations

⚠️ Important Security Notes

This is a learning project and includes basic security implementations. For production use, implement:

1. Password Security

Current Implementation:

// Basic password storage (NOT SECURE for production)
string password = txtPassword.Text;

Recommended for Production:

using System.Security.Cryptography;
using System.Text;

public static string HashPassword(string password)
{
    using (SHA256 sha256Hash = SHA256.Create())
    {
        byte[] bytes = sha256Hash.ComputeHash(Encoding.UTF8.GetBytes(password));
        StringBuilder builder = new StringBuilder();
        for (int i = 0; i < bytes.Length; i++)
        {
            builder.Append(bytes[i].ToString("x2"));
        }
        return builder.ToString();
    }
}

2. SQL Injection Prevention

Always use parameterized queries:

// ❌ BAD - Vulnerable to SQL Injection
string query = "SELECT * FROM Users WHERE Email = '" + email + "'";

// ✅ GOOD - Safe parameterized query
string query = "SELECT * FROM Users WHERE Email = @Email";
SqlCommand cmd = new SqlCommand(query, connection);
cmd.Parameters.AddWithValue("@Email", email);

3. Session Management

// Store user info in session after login
Session["UserID"] = userID;
Session["IsAdmin"] = isAdmin;
Session.Timeout = 30; // 30 minutes

// Check authentication
if (Session["UserID"] == null)
{
    Response.Redirect("Login.aspx");
}

4. Input Validation

// Server-side validation
protected void ValidateInput()
{
    if (string.IsNullOrWhiteSpace(txtEmail.Text))
    {
        lblError.Text = "Email is required";
        return;
    }
    
    if (!IsValidEmail(txtEmail.Text))
    {
        lblError.Text = "Invalid email format";
        return;
    }
}

---

📸 Screenshots

Customer Interface

Homepage

Featured products and category navigation

Product Category

Product listing with filters

Shopping Cart

Cart management interface

Order History

Customer order tracking

---

Admin Interface

Admin Dashboard

Sales statistics and quick actions

Product Management

Add/edit/delete products

Order Management

Process and track orders

---

📚 Learning Resources

Tutorials & Documentation

ASP.NET Web Forms:

• Microsoft ASP.NET Documentation
• W3Schools ASP.NET Tutorial
• TutorialsPoint ASP.NET Guide

C# Programming:

• C# Documentation
• C# Tutorial for Beginners
• LearnCS.org Interactive Tutorial

SQL Server:

• SQL Server Tutorial
• W3Schools SQL
• SQL Course on Codecademy

Code Examples & Patterns

Database Connection Pattern:

using System.Data.SqlClient;
using System.Configuration;

public class DatabaseHelper
{
    private string connectionString = ConfigurationManager.ConnectionStrings["EcommerceConnectionString"].ConnectionString;
    
    public SqlConnection GetConnection()
    {
        return new SqlConnection(connectionString);
    }
    
    public DataTable ExecuteQuery(string query, SqlParameter[] parameters = null)
    {
        DataTable dt = new DataTable();
        using (SqlConnection conn = GetConnection())
        {
            using (SqlCommand cmd = new SqlCommand(query, conn))
            {
                if (parameters != null)
                {
                    cmd.Parameters.AddRange(parameters);
                }
                
                conn.Open();
                SqlDataAdapter adapter = new SqlDataAdapter(cmd);
                adapter.Fill(dt);
            }
        }
        return dt;
    }
}

---

🎓 Extending the Project

Ideas for Enhancement

Beginner Level

• Add product search functionality
• Implement pagination for product listings
• Create a wishlist feature
• Add product rating and review system
• Implement email notifications

Intermediate Level

• Integrate payment gateway (PayPal, Stripe)
• Add product comparison feature
• Implement advanced filtering (price range, brand)
• Create promotional code system
• Add social media login (Facebook, Google)

Advanced Level

• Migrate to ASP.NET MVC or ASP.NET Core
• Implement RESTful API
• Add real-time inventory management
• Create mobile app using Xamarin
• Implement recommendation engine
• Add multi-language support
• Integrate with shipping providers

---

🐛 Known Issues

• Session timeout may clear shopping cart
• Image upload doesn't validate file types thoroughly
• No email verification for registration
• Limited error handling in some pages
• Admin dashboard statistics need caching

Workarounds available in Issues section

---

🤝 Contributing

Contributions are welcome! This project is designed for learning, so improvements and educational enhancements are especially appreciated.

How to Contribute

1. Fork the repository

   git clone https://github.com/YOUR_USERNAME/ecommerce.git

2. Create a feature branch

   git checkout -b feature/AmazingFeature

3. Make your changes

   • Add features
   • Fix bugs
   • Improve documentation
   • Add comments for learning purposes

4. Commit your changes

   git commit -m 'Add some AmazingFeature'

5. Push to the branch

   git push origin feature/AmazingFeature

6. Open a Pull Request

Contribution Guidelines

• Write clear, commented code for educational purposes
• Update README if you add new features
• Test all changes locally
• Follow C# naming conventions
• Add inline comments explaining complex logic

---

📝 License

This project is licensed under the MIT License - see the LICENSE file for details.

MIT License

Copyright (c) 2024 Toufic Sleiman

Permission is hereby granted, free of charge, to any person obtaining a copy
of this software and associated documentation files (the "Software"), to deal
in the Software without restriction, including without limitation the rights
to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
copies of the Software.

---

👨‍💻 Author

Toufic Sleiman

• 🌐 GitHub: @touficSl
• 💼 LinkedIn: Toufic Sleiman
• 🐦 Twitter: @sleiman_toufic
• 💻 Freelancer: TouficSl

---

🙏 Acknowledgments

• Thanks to the ASP.NET community for excellent documentation
• Bootstrap team for the responsive framework
• Font Awesome for icon library
• All contributors and students learning from this project

---

📞 Support

Getting Help

Found a bug?

• Open an Issue
• Provide detailed steps to reproduce

Have a question?

• Check existing Issues
• Ask in Discussions

Need custom development?

• Contact me via LinkedIn
• Available for freelance projects

---

📊 Project Stats

---

🚀 Deployment

Deploy to IIS (Production)

1. Publish from Visual Studio:

   • Right-click project → Publish
   • Select Folder → Choose output location
   • Click Publish

2. Configure IIS:

   • Create new website in IIS
   • Point to published folder
   • Set application pool to .NET 4.x
   • Configure database connection string

3. Security Checklist:

   • Change default admin credentials
   • Use HTTPS/SSL certificate
   • Hash passwords properly
   • Sanitize all user inputs
   • Enable error logging
   • Set up regular database backups

---

Happy Coding! 🎉

This project is perfect for learning ASP.NET fundamentals. Feel free to customize and extend it for your needs!

---

Made with ❤️ by Toufic Sleiman | Last updated: December 2024