Project Introduction
The E-Commerce Website Project is designed to create a comprehensive online shopping platform that allows users to browse, purchase, and review products. Built using ASP.NET and SQL Server, this application aims to provide a seamless shopping experience for customers while offering robust management tools for administrators. The system will include features such as user registration, product management, order processing, and customer reviews, ensuring a user-friendly interface and efficient backend operations.
Project Objectives
- To develop a user-friendly interface for customers to browse and purchase products.
- To implement a secure user authentication system for managing user accounts and roles.
- To manage product listings, including details such as price, description, and stock levels.
- To facilitate the creation and management of shopping carts and wishlists for users.
- To handle order processing, including payment and shipping address management.
- To allow users to leave reviews and ratings for products they have purchased.
- To implement a coupon system for discounts and promotions.
- To provide administrators with tools to manage users, products, orders, and reviews effectively.
Project Modules
- User Management Module: Handles user registration, login, and role management.
- Product Management Module: Manages product details, including creation, updates, and deletions.
- Category Management Module: Facilitates the creation and management of product categories.
- Shopping Cart Module: Allows users to add, update, and remove items from their shopping cart.
- Order Management Module: Handles order placement, payment processing, and order tracking.
- Review Management Module: Manages customer reviews and ratings for products.
- Wishlist Module: Allows users to create and manage wishlists for future purchases.
- Coupon Management Module: Manages discount coupons and their application during checkout.
- Shipping Address Management Module: Handles the creation and management of user shipping addresses.
- Reporting Module: Generates reports on sales, user activity, and product performance.
SQL Server Database Tables
-- Create Users Table
CREATE TABLE Users (
UserId INT PRIMARY KEY IDENTITY(1,1),
Username NVARCHAR(50) NOT NULL UNIQUE,
PasswordHash NVARCHAR(256) NOT NULL,
Email NVARCHAR(100) NOT NULL UNIQUE,
RoleId INT,
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (RoleId) REFERENCES Roles(RoleId)
);
-- Create Roles Table
CREATE TABLE Roles (
RoleId INT PRIMARY KEY IDENTITY(1,1),
RoleName NVARCHAR(50) NOT NULL UNIQUE
);
-- Create Products Table
CREATE TABLE Products (
ProductId INT PRIMARY KEY IDENTITY(1,1),
Name NVARCHAR(100) NOT NULL,
Description NVARCHAR(MAX) NOT NULL,
Price DECIMAL(18, 2) NOT NULL,
Stock INT NOT NULL,
CategoryId INT,
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (CategoryId) REFERENCES Categories(CategoryId)
);
-- Create Categories Table
CREATE TABLE Categories (
CategoryId INT PRIMARY KEY IDENTITY(1,1),
Name NVARCHAR(100) NOT NULL UNIQUE
);
-- Create CartItems Table
CREATE TABLE CartItems (
CartItemId INT PRIMARY KEY IDENTITY(1,1),
UserId INT,
ProductId INT,
Quantity INT NOT NULL,
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId),
FOREIGN KEY (ProductId) REFERENCES Products(ProductId)
);
-- Create Orders Table
CREATE TABLE Orders (
OrderId INT PRIMARY KEY IDENTITY(1,1),
UserId INT,
OrderDate DATETIME DEFAULT GETDATE(),
TotalAmount DECIMAL(18, 2) NOT NULL,
ShippingAddressId INT,
Status NVARCHAR(50) NOT NULL,
FOREIGN KEY (User Id) REFERENCES Users(UserId),
FOREIGN KEY (ShippingAddressId) REFERENCES ShippingAddresses(ShippingAddressId)
);
-- Create OrderItems Table
CREATE TABLE OrderItems (
OrderItemId INT PRIMARY KEY IDENTITY(1,1),
OrderId INT,
ProductId INT,
Quantity INT NOT NULL,
Price DECIMAL(18, 2) NOT NULL,
FOREIGN KEY (OrderId) REFERENCES Orders(OrderId),
FOREIGN KEY (ProductId) REFERENCES Products(ProductId)
);
-- Create Reviews Table
CREATE TABLE Reviews (
ReviewId INT PRIMARY KEY IDENTITY(1,1),
ProductId INT,
UserId INT,
Rating INT CHECK (Rating >= 1 AND Rating <= 5),
Comment NVARCHAR(MAX),
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (ProductId) REFERENCES Products(ProductId),
FOREIGN KEY (User Id) REFERENCES Users(UserId)
);
-- Create Wishlists Table
CREATE TABLE Wishlists (
WishlistId INT PRIMARY KEY IDENTITY(1,1),
UserId INT,
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId)
);
-- Create WishlistItems Table
CREATE TABLE WishlistItems (
WishlistItemId INT PRIMARY KEY IDENTITY(1,1),
WishlistId INT,
ProductId INT,
FOREIGN KEY (WishlistId) REFERENCES Wishlists(WishlistId),
FOREIGN KEY (ProductId) REFERENCES Products(ProductId)
);
-- Create Coupons Table
CREATE TABLE Coupons (
CouponId INT PRIMARY KEY IDENTITY(1,1),
Code NVARCHAR(50) NOT NULL UNIQUE,
DiscountAmount DECIMAL(18, 2) NOT NULL,
ExpirationDate DATETIME NOT NULL,
IsActive BIT DEFAULT 1
);
-- Create ShippingAddresses Table
CREATE TABLE ShippingAddresses (
ShippingAddressId INT PRIMARY KEY IDENTITY(1,1),
UserId INT,
AddressLine1 NVARCHAR(256) NOT NULL,
AddressLine2 NVARCHAR(256),
City NVARCHAR(100) NOT NULL,
State NVARCHAR(100) NOT NULL,
ZipCode NVARCHAR(20) NOT NULL,
Country NVARCHAR(100) NOT NULL,
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId)
);
Explanation of the Tables
Users: Stores user information, including username, password hash, email, and role.
Roles: Defines user roles (e.g., Admin, Customer).
Products: Contains product details, including name, description, price, stock, and category.
Categories: Organizes products into categories.
CartItems: Represents items in a user's shopping cart.
Models
Here are the model classes corresponding to your SQL tables:
Models/User.cs
namespace ECommerceWebsite.Models
{
public class User
{
public int UserId { get; set; }
public string Username { get; set; }
public string PasswordHash { get; set; }
public string Email { get; set; }
public int RoleId { get; set; }
public DateTime CreatedAt { get; set; }
}
}
Models/Role.cs
namespace ECommerceWebsite.Models
{
public class Role
{
public int RoleId { get; set; }
public string RoleName { get; set; }
}
}
Models/Product.cs
namespace ECommerceWebsite.Models
{
public class Product
{
public int ProductId { get; set; }
public string Name { get; set; }
public string Description { get; set; }
public decimal Price { get; set; }
public int Stock { get; set; }
public int CategoryId { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
}
Models/Category.cs
namespace ECommerceWebsite.Models
{
public class Category
{
public int CategoryId { get; set; }
public string Name { get; set; }
}
}
Models/CartItem.cs
namespace ECommerceWebsite.Models
{
public class CartItem
{
public int CartItemId { get; set; }
public int UserId { get; set; }
public int ProductId { get; set; }
public int Quantity { get; set; }
public DateTime CreatedAt { get; set; }
}
}
Models/Order.cs
namespace ECommerceWebsite.Models
{
public class Order
{
public int OrderId { get; set; }
public int UserId { get; set; }
public DateTime OrderDate { get; set; }
public decimal TotalAmount { get; set; }
public int ShippingAddressId { get; set; }
public string Status { get; set; }
}
}
Models/OrderItem.cs
namespace ECommerceWebsite.Models
{
public class OrderItem
{
public int OrderItemId { get; set; }
public int OrderId { get; set; }
public int ProductId { get; set; }
public int Quantity { get; set; }
public decimal Price { get; set; }
}
}
Models/Review.cs
namespace ECommerceWebsite.Models
{
public class Review
{
public int ReviewId { get; set; }
public int ProductId { get; set; }
public int UserId { get; set; }
public int Rating { get; set; }
public string Comment { get; set; }
public DateTime CreatedAt { get; set; }
}
}
Models/Wishlist.cs
namespace ECommerceWebsite.Models
{
public class Wishlist
{
public int WishlistId { get; set; }
public int UserId { get; set; }
public DateTime CreatedAt { get; set; }
}
}
Models/WishlistItem.cs
namespace ECommerceWebsite.Models
{
public class WishlistItem
{
public int WishlistItemId { get; set; }
public int WishlistId { get; set; }
public int ProductId { get; set; }
}
}
Models/Coupon.cs
namespace ECommerceWebsite.Models
{
public class Coupon
{
public int CouponId { get; set; }
public string Code { get; set; }
public decimal DiscountAmount { get; set; }
public DateTime ExpirationDate { get; set; }
public bool IsActive { get; set; }
}
}
Models/ShippingAddress.cs
namespace ECommerceWebsite.Models
{
public class ShippingAddress
{
public int ShippingAddressId { get; set; }
public int UserId { get; set; }
public string AddressLine 1 { get; set; }
public string AddressLine2 { get; set; }
public string City { get; set; }
public string State { get; set; }
public string ZipCode { get; set; }
public string Country { get; set; }
public DateTime CreatedAt { get; set; }
}
}
Repositories
Now, let's create repositories for each model using ADO.NET. Each repository will contain methods for basic CRUD operations.
Repositories/UserRepository.cs
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using ECommerceWebsite.Models;
namespace ECommerceWebsite.Repositories
{
public class UserRepository
{
private readonly string _connectionString;
public UserRepository(string connectionString)
{
_connectionString = connectionString;
}
public void AddUser (User user)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Users (Username, PasswordHash, Email, RoleId) VALUES (@Username, @PasswordHash, @Email, @RoleId)", connection);
command.Parameters.AddWithValue("@Username", user.Username);
command.Parameters.AddWithValue("@PasswordHash", user.PasswordHash);
command.Parameters.AddWithValue("@Email", user.Email);
command.Parameters.AddWithValue("@RoleId", user.RoleId);
connection.Open();
command.ExecuteNonQuery();
}
}
public User GetUser ById(int userId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Users WHERE UserId = @User Id", connection);
command.Parameters.AddWithValue("@User Id", userId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new User
{
UserId = (int)reader["User Id"],
Username = reader["Username"].ToString(),
PasswordHash = reader["PasswordHash"].ToString(),
Email = reader["Email"].ToString(),
RoleId = (int)reader["RoleId"],
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return null;
}
public List<User> GetAllUsers()
{
var users = new List<User>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Users", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
users.Add(new User
{
UserId = (int)reader["User Id"],
Username = reader["Username"].ToString(),
PasswordHash = reader["PasswordHash"].ToString(),
Email = reader["Email"].ToString(),
RoleId = (int)reader["RoleId"],
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return users;
}
public void UpdateUser (User user)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Users SET Username = @Username, PasswordHash = @PasswordHash, Email = @Email, RoleId = @RoleId WHERE UserId = @User Id", connection);
command.Parameters.AddWithValue("@User Id", user.UserId);
command.Parameters.AddWithValue("@Username", user.Username);
command.Parameters.AddWithValue("@PasswordHash", user.PasswordHash);
command.Parameters.AddWithValue("@Email", user.Email);
command.Parameters.AddWithValue("@RoleId", user.RoleId);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteUser (int userId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Users WHERE UserId = @User Id", connection);
command.Parameters.AddWithValue("@User Id", userId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
}
Repositories/RoleRepository.cs
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using ECommerceWebsite.Models;
namespace ECommerceWebsite.Repositories
{
public class RoleRepository
{
private readonly string _connectionString;
public RoleRepository(string connectionString)
{
_connectionString = connectionString;
}
public void AddRole(Role role)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Roles (RoleName) VALUES (@RoleName)", connection);
command.Parameters.AddWithValue("@RoleName", role.RoleName);
connection.Open();
command.ExecuteNonQuery();
}
}
public Role GetRoleById(int roleId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Roles WHERE RoleId = @RoleId", connection);
command.Parameters.AddWithValue("@RoleId", roleId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Role
{
RoleId = (int)reader["RoleId"],
RoleName = reader["RoleName"].ToString()
};
}
}
}
return null;
}
public List<Role> GetAllRoles()
{
var roles = new List<Role>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Roles", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
roles.Add(new Role
{
RoleId = (int)reader["RoleId"],
RoleName = reader["RoleName"].ToString()
});
}
}
}
return roles;
}
public void UpdateRole(Role role)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Roles SET RoleName = @RoleName WHERE RoleId = @RoleId", connection);
command.Parameters.AddWithValue("@RoleId", role.RoleId);
command.Parameters.AddWithValue("@RoleName", role.RoleName);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteRole(int roleId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Roles WHERE RoleId = @RoleId", connection);
command.Parameters.AddWithValue("@RoleId", roleId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
}
Repositories/ProductRepository.cs
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using ECommerceWebsite.Models;
namespace ECommerceWebsite.Repositories
{
public class ProductRepository
{
private readonly string _connectionString;
public ProductRepository(string connectionString)
{
_connectionString = connectionString;
}
public void AddProduct(Product product)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Products (Name, Description, Price, Stock, CategoryId) VALUES (@Name, @Description, @Price, @Stock, @CategoryId)", connection);
command.Parameters.AddWithValue("@Name", product.Name);
command.Parameters.AddWithValue("@Description", product.Description);
command.Parameters.AddWithValue("@Price", product.Price);
command.Parameters.AddWithValue("@Stock", product.Stock);
command.Parameters.AddWithValue("@CategoryId", product.CategoryId);
connection.Open();
command.ExecuteNonQuery();
}
}
public Product GetProductById(int productId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Products WHERE ProductId = @ProductId", connection);
command.Parameters.AddWithValue("@ProductId", productId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Product
{
ProductId = (int)reader["ProductId"],
Name = reader["Name"].ToString(),
Description = reader["Description"].ToString(),
Price = (decimal)reader["Price"],
Stock = (int)reader["Stock"],
CategoryId = (int)reader["CategoryId"],
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return null;
}
public List<Product> GetAllProducts()
{
var products = new List<Product>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Products", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
products.Add(new Product
{
ProductId = (int)reader["ProductId"],
Name = reader["Name"].ToString(),
Description = reader["Description"].ToString(),
Price = (decimal)reader["Price"],
Stock = (int)reader["Stock"],
CategoryId = (int)reader["CategoryId"],
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader ["UpdatedAt"]
});
}
}
}
return products;
}
public void UpdateProduct(Product product)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Products SET Name = @Name, Description = @Description, Price = @Price, Stock = @Stock, CategoryId = @CategoryId WHERE ProductId = @ProductId", connection);
command.Parameters.AddWithValue("@ProductId", product.ProductId);
command.Parameters.AddWithValue("@Name", product.Name);
command.Parameters.AddWithValue("@Description", product.Description);
command.Parameters.AddWithValue("@Price", product.Price);
command.Parameters.AddWithValue("@Stock", product.Stock);
command.Parameters.AddWithValue("@CategoryId", product.CategoryId);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteProduct(int productId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Products WHERE ProductId = @ProductId", connection);
command.Parameters.AddWithValue("@ProductId", productId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
}
Repositories/CategoryRepository.cs
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using ECommerceWebsite.Models;
namespace ECommerceWebsite.Repositories
{
public class CategoryRepository
{
private readonly string _connectionString;
public CategoryRepository(string connectionString)
{
_connectionString = connectionString;
}
public void AddCategory(Category category)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Categories (Name) VALUES (@Name)", connection);
command.Parameters.AddWithValue("@Name", category.Name);
connection.Open();
command.ExecuteNonQuery();
}
}
public Category GetCategoryById(int categoryId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Categories WHERE CategoryId = @CategoryId", connection);
command.Parameters.AddWithValue("@CategoryId", categoryId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Category
{
CategoryId = (int)reader["CategoryId"],
Name = reader["Name"].ToString()
};
}
}
}
return null;
}
public List<Category> GetAllCategories()
{
var categories = new List<Category>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Categories", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
categories.Add(new Category
{
CategoryId = (int)reader["CategoryId"],
Name = reader["Name"].ToString()
});
}
}
}
return categories;
}
public void UpdateCategory(Category category)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Categories SET Name = @Name WHERE CategoryId = @CategoryId", connection);
command.Parameters.AddWithValue("@CategoryId", category.CategoryId);
command.Parameters.AddWithValue("@Name", category.Name);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteCategory(int categoryId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Categories WHERE CategoryId = @CategoryId", connection);
command.Parameters.AddWithValue("@CategoryId", categoryId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
}
This structure provides a solid foundation for your E-Commerce website project, allowing you to manage users, roles, products, categories, and other entities effectively using ADO.NET. You can expand upon this by adding more repositories for other models as needed.
Additional Repositories
Below are the repository implementations for the remaining models in your E-Commerce application, including CartItem, Order, OrderItem, Review, Wishlist, WishlistItem, Coupon, and ShippingAddress.
Repositories/CartItemRepository.cs
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using ECommerceWebsite.Models;
namespace ECommerceWebsite.Repositories
{
public class CartItemRepository
{
private readonly string _connectionString;
public CartItemRepository(string connectionString)
{
_connectionString = connectionString;
}
public void AddCartItem(CartItem cartItem)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO CartItems (User Id, ProductId, Quantity) VALUES (@User Id, @ProductId, @Quantity)", connection);
command.Parameters.AddWithValue("@User Id", cartItem.UserId);
command.Parameters.AddWithValue("@ProductId", cartItem.ProductId);
command.Parameters.AddWithValue("@Quantity", cartItem.Quantity);
connection.Open();
command.ExecuteNonQuery();
}
}
public List<CartItem> GetCartItemsByUser Id(int userId)
{
var cartItems = new List<CartItem>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM CartItems WHERE UserId = @User Id", connection);
command.Parameters.AddWithValue("@User Id", userId);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
cartItems.Add(new CartItem
{
CartItemId = (int)reader["CartItemId"],
UserId = (int)reader["User Id"],
ProductId = (int)reader["ProductId"],
Quantity = (int)reader["Quantity"],
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return cartItems;
}
public void UpdateCartItem(CartItem cartItem)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE CartItems SET Quantity = @Quantity WHERE CartItemId = @CartItemId", connection);
command.Parameters.AddWithValue("@CartItemId", cartItem.CartItemId);
command.Parameters.AddWithValue("@Quantity", cartItem.Quantity);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteCartItem(int cartItemId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM CartItems WHERE CartItemId = @CartItemId", connection);
command.Parameters.AddWithValue("@CartItemId", cartItemId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
}
Repositories/OrderRepository.cs
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using ECommerceWebsite.Models;
namespace ECommerceWebsite.Repositories
{
public class OrderRepository
{
private readonly string _connectionString;
public OrderRepository(string connectionString)
{
_connectionString = connectionString;
}
public void AddOrder(Order order)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Orders (User Id, TotalAmount, ShippingAddressId, Status) VALUES (@User Id, @TotalAmount, @ShippingAddressId, @Status)", connection);
command.Parameters.AddWithValue("@User Id", order.UserId);
command.Parameters.AddWithValue("@TotalAmount", order.TotalAmount);
command.Parameters.AddWithValue("@ShippingAddressId", order.ShippingAddressId);
command.Parameters.AddWithValue("@Status", order.Status);
connection.Open();
command.ExecuteNonQuery();
}
}
public Order GetOrderById(int orderId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Orders WHERE OrderId = @OrderId", connection);
command.Parameters.AddWithValue("@OrderId", orderId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Order
{
OrderId = (int)reader["OrderId"],
UserId = (int)reader["User Id"],
OrderDate = (DateTime)reader["OrderDate"],
TotalAmount = (decimal)reader["TotalAmount"],
ShippingAddressId = (int)reader["ShippingAddressId"],
Status = reader["Status"].ToString()
};
}
}
return null;
}
public List<Order> GetAllOrders()
{
var orders = new List<Order>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Orders", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
orders.Add(new Order
{
OrderId = (int)reader["OrderId"],
UserId = (int)reader["User Id"],
OrderDate = (DateTime)reader["OrderDate"],
TotalAmount = (decimal)reader["TotalAmount"],
ShippingAddressId = (int)reader["ShippingAddressId"],
Status = reader["Status"].ToString()
});
}
}
}
return orders;
}
public void UpdateOrder(Order order)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Orders SET TotalAmount = @TotalAmount, ShippingAddressId = @ShippingAddressId, Status = @Status WHERE OrderId = @OrderId", connection);
command.Parameters.AddWithValue("@OrderId", order.OrderId);
command.Parameters.AddWithValue("@TotalAmount", order.TotalAmount);
command.Parameters.AddWithValue("@ShippingAddressId", order.ShippingAddressId);
command.Parameters.AddWithValue("@Status", order.Status);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteOrder(int orderId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Orders WHERE OrderId = @OrderId", connection);
command.Parameters.AddWithValue("@OrderId", orderId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
}
Repositories/OrderItemRepository.cs
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using ECommerceWebsite.Models;
namespace ECommerceWebsite.Repositories
{
public class OrderItemRepository
{
private readonly string _connectionString;
public OrderItemRepository(string connectionString)
{
_connectionString = connectionString;
}
public void AddOrderItem(OrderItem orderItem)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO OrderItems (OrderId, ProductId, Quantity, Price) VALUES (@OrderId, @ProductId, @Quantity, @Price)", connection);
command.Parameters.AddWithValue("@OrderId", orderItem.OrderId);
command.Parameters.AddWithValue("@ProductId", orderItem.ProductId);
command.Parameters.AddWithValue("@Quantity", orderItem.Quantity);
command.Parameters.AddWithValue("@Price", orderItem.Price);
connection.Open();
command.ExecuteNonQuery();
}
}
public List<OrderItem> GetOrderItemsByOrderId(int orderId)
{
var orderItems = new List<OrderItem>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM OrderItems WHERE OrderId = @OrderId", connection);
command.Parameters.AddWithValue("@OrderId", orderId);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
orderItems.Add(new OrderItem
{
OrderItemId = (int)reader["OrderItemId"],
OrderId = (int)reader["OrderId"],
ProductId = (int)reader["ProductId"],
Quantity = (int)reader["Quantity"],
Price = (decimal)reader["Price"]
});
}
}
}
return orderItems;
}
public void UpdateOrderItem(OrderItem orderItem)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE OrderItems SET Quantity = @Quantity, Price = @Price WHERE OrderItemId = @OrderItemId", connection);
command.Parameters.AddWithValue("@OrderItemId", orderItem.OrderItemId);
command.Parameters.AddWithValue("@Quantity", orderItem.Quantity);
command.Parameters.AddWithValue("@Price", orderItem.Price);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteOrderItem(int orderItemId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM OrderItems WHERE OrderItemId = @OrderItemId", connection);
command.Parameters.AddWithValue("@OrderItemId", orderItemId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
}
Repositories/ReviewRepository.cs
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using ECommerceWebsite.Models;
namespace ECommerceWebsite.Repositories
{
public class ReviewRepository
{
private readonly string _connectionString;
public ReviewRepository(string connectionString)
{
_connectionString = connectionString;
}
public void AddReview(Review review)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Reviews (ProductId, UserId, Rating, Comment) VALUES (@ProductId, @User Id, @Rating, @Comment)", connection);
command.Parameters.AddWithValue("@ProductId", review.ProductId);
command.Parameters.AddWithValue("@User Id", review.UserId);
command.Parameters.AddWithValue("@Rating", review.Rating);
command.Parameters.AddWithValue("@Comment", review.Comment);
connection.Open();
command.ExecuteNonQuery();
}
}
public List<Review> GetReviewsByProductId(int productId)
{
var reviews = new List<Review>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Reviews WHERE ProductId = @ProductId", connection);
command.Parameters.AddWithValue("@ProductId", productId);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
reviews.Add(new Review
{
ReviewId = (int)reader["ReviewId"],
ProductId = (int)reader["ProductId"],
UserId = (int)reader["User Id"],
Rating = (int)reader["Rating"],
Comment = reader["Comment"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return reviews;
}
public void UpdateReview(Review review)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Reviews SET Rating = @Rating, Comment = @Comment WHERE ReviewId = @ReviewId", connection);
command.Parameters.AddWithValue("@ReviewId", review.ReviewId);
command.Parameters.AddWithValue("@Rating", review.Rating);
command.Parameters.AddWithValue("@Comment", review.Comment);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteReview(int reviewId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Reviews WHERE ReviewId = @ReviewId", connection);
command.Parameters.AddWithValue("@ReviewId", reviewId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
}
Repositories/WishlistRepository.cs
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using ECommerceWebsite.Models;
namespace ECommerceWebsite.Repositories
{
public class WishlistRepository
{
private readonly string _connectionString;
public WishlistRepository(string connectionString)
{
_connectionString = connectionString;
}
public void AddWishlist(Wishlist wishlist)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Wishlists (User Id) VALUES (@User Id)", connection);
command.Parameters.AddWithValue("@User Id", wishlist.UserId);
connection.Open();
command.ExecuteNonQuery();
}
}
public List<Wishlist> GetWishlistsByUser Id(int userId)
{
var wishlists = new List<Wishlist>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Wishlists WHERE UserId = @User Id", connection);
command.Parameters.AddWithValue("@User Id", userId);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
wishlists.Add(new Wishlist
{
WishlistId = (int)reader["WishlistId"],
UserId = (int)reader["User Id"],
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return wishlists;
}
public void DeleteWishlist(int wishlistId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Wishlists WHERE WishlistId = @WishlistId", connection);
command.Parameters.AddWithValue("@WishlistId", wishlistId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
}
Repositories/WishlistItemRepository.cs
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using ECommerceWebsite.Models;
namespace ECommerceWebsite.Repositories
{
public class WishlistItemRepository
{
private readonly string _connectionString;
public WishlistItemRepository(string connectionString)
{
_connectionString = connectionString;
}
public void AddWishlistItem(WishlistItem wishlistItem)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO WishlistItems (WishlistId, ProductId) VALUES (@WishlistId, @ProductId)", connection);
command.Parameters.AddWithValue("@WishlistId", wishlistItem.WishlistId);
command.Parameters.AddWithValue("@ProductId", wishlistItem.ProductId);
connection.Open();
command.ExecuteNonQuery();
}
}
public List<WishlistItem> GetWishlistItemsByWishlistId(int wishlistId)
{
var wishlistItems = new List<WishlistItem>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM WishlistItems WHERE WishlistId = @WishlistId", connection);
command.Parameters.AddWithValue("@WishlistId", wishlistId);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
wishlistItems.Add(new WishlistItem
{
WishlistItemId = (int)reader["WishlistItemId"],
WishlistId = (int)reader["WishlistId"],
ProductId = (int)reader["ProductId"]
});
}
}
}
return wishlistItems;
}
public void DeleteWishlistItem(int wishlistItemId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM WishlistItems WHERE WishlistItemId = @WishlistItemId", connection);
command.Parameters.AddWithValue("@WishlistItemId", wishlistItemId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
}
Repositories/CouponRepository.cs
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using ECommerceWebsite.Models;
namespace ECommerceWebsite.Repositories
{
public class CouponRepository
{
private readonly string _connectionString;
public CouponRepository(string connectionString)
{
_connectionString = connectionString;
}
public void AddCoupon(Coupon coupon)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Coupons (Code, DiscountAmount, ExpirationDate, IsActive) VALUES (@Code, @DiscountAmount, @ExpirationDate, @IsActive)", connection);
command.Parameters.AddWithValue("@Code", coupon.Code);
command.Parameters.AddWithValue("@DiscountAmount", coupon.DiscountAmount);
command.Parameters.AddWithValue("@ExpirationDate", coupon.ExpirationDate);
command.Parameters.AddWithValue("@IsActive", coupon.IsActive);
connection.Open();
command.ExecuteNonQuery();
}
}
public Coupon GetCouponById(int couponId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Coupons WHERE CouponId = @CouponId", connection);
command.Parameters.AddWithValue("@CouponId", couponId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Coupon
{
CouponId = (int)reader["CouponId"],
Code = reader["Code"].ToString(),
DiscountAmount = (decimal)reader["DiscountAmount"],
ExpirationDate = (DateTime)reader["ExpirationDate"],
IsActive = (bool)reader["IsActive"]
};
}
}
}
return null;
}
public List<Coupon> GetAllCoupons()
{
var coupons = new List<Coupon>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Coupons", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
coupons.Add(new Coupon
{
CouponId = (int)reader["CouponId"],
Code = reader["Code"].ToString(),
DiscountAmount = (decimal)reader["DiscountAmount"],
ExpirationDate = (DateTime)reader["ExpirationDate"],
IsActive = (bool)reader["IsActive"]
});
}
}
}
return coupons;
}
public void UpdateCoupon(Coupon coupon)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Coupons SET Code = @Code, DiscountAmount = @DiscountAmount, ExpirationDate = @ExpirationDate, IsActive = @IsActive WHERE CouponId = @CouponId", connection);
command.Parameters.Add WithValue("@CouponId", coupon.CouponId);
command.Parameters.AddWithValue("@Code", coupon.Code);
command.Parameters.AddWithValue("@DiscountAmount", coupon.DiscountAmount);
command.Parameters.AddWithValue("@ExpirationDate", coupon.ExpirationDate);
command.Parameters.AddWithValue("@IsActive", coupon.IsActive);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteCoupon(int couponId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Coupons WHERE CouponId = @CouponId", connection);
command.Parameters.AddWithValue("@CouponId", couponId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
}
Repositories/ShippingAddressRepository.cs
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using ECommerceWebsite.Models;
namespace ECommerceWebsite.Repositories
{
public class ShippingAddressRepository
{
private readonly string _connectionString;
public ShippingAddressRepository(string connectionString)
{
_connectionString = connectionString;
}
public void AddShippingAddress(ShippingAddress shippingAddress)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO ShippingAddresses (User Id, AddressLine1, AddressLine2, City, State, ZipCode, Country) VALUES (@User Id, @AddressLine1, @AddressLine2, @City, @State, @ZipCode, @Country)", connection);
command.Parameters.AddWithValue("@User Id", shippingAddress.UserId);
command.Parameters.AddWithValue("@AddressLine1", shippingAddress.AddressLine1);
command.Parameters.AddWithValue("@AddressLine2", shippingAddress.AddressLine2);
command.Parameters.AddWithValue("@City", shippingAddress.City);
command.Parameters.AddWithValue("@State", shippingAddress.State);
command.Parameters.AddWithValue("@ZipCode", shippingAddress.ZipCode);
command.Parameters.AddWithValue("@Country", shippingAddress.Country);
connection.Open();
command.ExecuteNonQuery();
}
}
public ShippingAddress GetShippingAddressById(int shippingAddressId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM ShippingAddresses WHERE ShippingAddressId = @ShippingAddressId", connection);
command.Parameters.AddWithValue("@ShippingAddressId", shippingAddressId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new ShippingAddress
{
ShippingAddressId = (int)reader["ShippingAddressId"],
UserId = (int)reader["User Id"],
AddressLine1 = reader["AddressLine1"].ToString(),
AddressLine2 = reader["AddressLine2"].ToString(),
City = reader["City"].ToString(),
State = reader["State"].ToString(),
ZipCode = reader["ZipCode"].ToString(),
Country = reader["Country"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return null;
}
public List<ShippingAddress> GetShippingAddressesByUser Id(int userId)
{
var shippingAddresses = new List<ShippingAddress>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM ShippingAddresses WHERE UserId = @User Id", connection);
command.Parameters.AddWithValue("@User Id", userId);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
shippingAddresses.Add(new ShippingAddress
{
ShippingAddressId = (int)reader["ShippingAddressId"],
UserId = (int)reader["User Id"],
AddressLine1 = reader["AddressLine1"].ToString(),
AddressLine2 = reader["AddressLine2"].ToString(),
City = reader["City"].ToString(),
State = reader["State"].ToString(),
ZipCode = reader["ZipCode"].ToString(),
Country = reader["Country"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return shippingAddresses;
}
public void UpdateShippingAddress(ShippingAddress shippingAddress)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE ShippingAddresses SET AddressLine1 = @AddressLine1, AddressLine2 = @AddressLine2, City = @City, State = @State, ZipCode = @ZipCode, Country = @Country WHERE ShippingAddressId = @ShippingAddressId", connection);
command.Parameters.AddWithValue("@ShippingAddressId", shippingAddress .ShippingAddressId);
command.Parameters.AddWithValue("@AddressLine1", shippingAddress.AddressLine1);
command.Parameters.AddWithValue("@AddressLine2", shippingAddress.AddressLine2);
command.Parameters.AddWithValue("@City", shippingAddress.City);
command.Parameters.AddWithValue("@State", shippingAddress.State);
command.Parameters.AddWithValue("@ZipCode", shippingAddress.ZipCode);
command.Parameters.AddWithValue("@Country", shippingAddress.Country);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteShippingAddress(int shippingAddressId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM ShippingAddresses WHERE ShippingAddressId = @ShippingAddressId", connection);
command.Parameters.AddWithValue("@ShippingAddressId", shippingAddressId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
}
This completes the repository implementations for all the models in your E-Commerce application. Each repository provides methods for adding, retrieving, updating, and deleting records in the corresponding database tables, allowing for effective data management within your application.
Creating Controllers
Now create a controller for each repository.
Below are example controllers for each of the repositories in your ASP.NET E-Commerce application. Each controller will handle HTTP requests and interact with the corresponding repository to perform CRUD operations.
Controllers/UserController.cs
using Microsoft.AspNetCore.Mvc;
using ECommerceWebsite.Models;
using ECommerceWebsite.Repositories;
namespace ECommerceWebsite.Controllers
{
public class UserController : Controller
{
private readonly UserRepository _userRepository;
public UserController(UserRepository userRepository)
{
_userRepository = userRepository;
}
public IActionResult Index()
{
var users = _userRepository.GetAllUsers();
return View(users);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(User user)
{
if (ModelState.IsValid)
{
_userRepository.AddUser (user);
return RedirectToAction("Index");
}
return View(user);
}
public IActionResult Edit(int id)
{
var user = _userRepository.GetUser ById(id);
if (user == null)
{
return NotFound();
}
return View(user);
}
[HttpPost]
public IActionResult Edit(User user)
{
if (ModelState.IsValid)
{
_userRepository.UpdateUser (user);
return RedirectToAction("Index");
}
return View(user);
}
public IActionResult Delete(int id)
{
var user = _userRepository.GetUser ById(id);
if (user == null)
{
return NotFound();
}
return View(user);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_userRepository.DeleteUser (id);
return RedirectToAction("Index");
}
}
}
2. Controllers/RoleController.cs
using Microsoft.AspNetCore.Mvc;
using ECommerceWebsite.Models;
using ECommerceWebsite.Repositories;
namespace ECommerceWebsite.Controllers
{
public class RoleController : Controller
{
private readonly RoleRepository _roleRepository;
public RoleController(RoleRepository roleRepository)
{
_roleRepository = roleRepository;
}
public IActionResult Index()
{
var roles = _roleRepository.GetAllRoles();
return View(roles);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Role role)
{
if (ModelState.IsValid)
{
_roleRepository.AddRole(role);
return RedirectToAction("Index");
}
return View(role);
}
public IActionResult Edit(int id)
{
var role = _roleRepository.GetRoleById(id);
if (role == null)
{
return NotFound();
}
return View(role);
}
[HttpPost]
public IActionResult Edit(Role role)
{
if (ModelState.IsValid)
{
_roleRepository.UpdateRole(role);
return RedirectToAction("Index");
}
return View(role);
}
public IActionResult Delete(int id)
{
var role = _roleRepository.GetRoleById(id);
if (role == null)
{
return NotFound();
}
return View(role);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_roleRepository.DeleteRole(id);
return RedirectToAction("Index");
}
}
}
3. Controllers/ProductController.cs
using Microsoft.AspNetCore.Mvc;
using ECommerceWebsite.Models;
using ECommerceWebsite.Repositories;
namespace ECommerceWebsite.Controllers
{
public class ProductController : Controller
{
private readonly ProductRepository _productRepository;
public ProductController(ProductRepository productRepository)
{
_productRepository = productRepository;
}
public IActionResult Index()
{
var products = _productRepository.GetAllProducts();
return View(products);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Product product)
{
if (ModelState.IsValid)
{
_productRepository.AddProduct(product);
return RedirectToAction("Index");
}
return View(product);
}
public IActionResult Edit(int id)
{
var product = _productRepository.GetProductById(id);
if (product == null)
{
return NotFound();
}
return View(product);
}
[HttpPost]
public IActionResult Edit(Product product)
{
if (ModelState.IsValid)
{
_productRepository.UpdateProduct(product);
return RedirectToAction("Index");
}
return View(product);
}
public IActionResult Delete(int id)
{
var product = _productRepository.GetProductById(id);
if (product == null)
{
return NotFound();
}
return View(product);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_productRepository.DeleteProduct(id);
return RedirectToAction("Index");
}
}
}
4. Controllers/CartItemController.cs
using Microsoft.AspNetCore.Mvc;
using ECommerceWebsite.Models;
using ECommerceWebsite.Repositories;
namespace ECommerceWebsite.Controllers
{
public class CartItemController : Controller
{
private readonly CartItemRepository _cartItemRepository;
public CartItemController(CartItemRepository cartItemRepository)
{
_cartItemRepository = cartItemRepository;
}
public IActionResult Index(int userId)
{
var cartItems = _cartItemRepository.GetCartItemsByUser Id(userId);
return View(cartItems);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(CartItem cartItem)
{
if (ModelState.IsValid)
{
_cartItemRepository.AddCartItem(cartItem);
return RedirectToAction("Index", new { userId = cartItem.UserId });
}
return View(cartItem);
}
public IActionResult Edit(int id)
{
var cartItem = _cartItemRepository.GetCartItemsByUser Id(id);
if (cartItem == null)
{
return NotFound();
}
return View(cartItem);
}
[HttpPost]
public IActionResult Edit(CartItem cartItem)
{
if (ModelState.IsValid)
{
_cartItemRepository.UpdateCartItem(cartItem);
return RedirectToAction("Index", new { userId = cartItem.UserId });
}
return View(cartItem);
}
public IActionResult Delete(int id)
{
var cartItem = _cartItemRepository.GetCartItemsByUser Id(id);
if (cartItem == null)
{
return NotFound();
}
return View(cartItem);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_cartItemRepository.DeleteCartItem(id);
return RedirectToAction("Index");
}
}
}
5. Controllers/OrderController.cs
using Microsoft.AspNetCore.Mvc;
using ECommerceWebsite.Models;
using ECommerceWebsite.Repositories;
namespace ECommerceWebsite.Controllers
{
public class OrderController : Controller
{
private readonly OrderRepository _orderRepository;
public OrderController(OrderRepository orderRepository)
{
_orderRepository = orderRepository;
}
public IActionResult Index()
{
var orders = _orderRepository.GetAllOrders();
return View(orders);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Order order)
{
if (ModelState.IsValid)
{
_orderRepository.AddOrder(order);
return RedirectToAction("Index");
}
return View(order);
}
public IActionResult Edit(int id)
{
var order = _orderRepository.GetOrderById(id);
if (order == null)
{
return NotFound();
}
return View(order);
}
[HttpPost]
public IActionResult Edit(Order order)
{
if (ModelState.IsValid)
{
_orderRepository.UpdateOrder(order);
return RedirectToAction("Index");
}
return View(order);
}
public IActionResult Delete(int id)
{
var order = _orderRepository.GetOrderById(id);
if (order == null)
{
return NotFound();
}
return View(order);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_orderRepository.DeleteOrder(id);
return RedirectToAction("Index");
}
}
}
6. Controllers/OrderItemController.cs
using Microsoft.AspNetCore.Mvc;
using ECommerceWebsite.Models;
using ECommerceWebsite.Repositories;
namespace ECommerceWebsite.Controllers
{
public class OrderItemController : Controller
{
private readonly OrderItemRepository _orderItemRepository;
public OrderItemController(OrderItemRepository orderItemRepository)
{
_orderItemRepository = orderItemRepository;
}
public IActionResult Index(int orderId)
{
var orderItems = _orderItemRepository.GetOrderItemsByOrderId(orderId);
return View(orderItems);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(OrderItem orderItem)
{
if (ModelState .IsValid)
{
_orderItemRepository.AddOrderItem(orderItem);
return RedirectToAction("Index", new { orderId = orderItem.OrderId });
}
return View(orderItem);
}
public IActionResult Edit(int id)
{
var orderItem = _orderItemRepository.GetOrderItemsByOrderId(id);
if (orderItem == null)
{
return NotFound();
}
return View(orderItem);
}
[HttpPost]
public IActionResult Edit(OrderItem orderItem)
{
if (ModelState.IsValid)
{
_orderItemRepository.UpdateOrderItem(orderItem);
return RedirectToAction("Index", new { orderId = orderItem.OrderId });
}
return View(orderItem);
}
public IActionResult Delete(int id)
{
var orderItem = _orderItemRepository.GetOrderItemsByOrderId(id);
if (orderItem == null)
{
return NotFound();
}
return View(orderItem);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_orderItemRepository.DeleteOrderItem(id);
return RedirectToAction("Index");
}
}
}
7. Controllers/ReviewController.cs
using Microsoft.AspNetCore.Mvc;
using ECommerceWebsite.Models;
using ECommerceWebsite.Repositories;
namespace ECommerceWebsite.Controllers
{
public class ReviewController : Controller
{
private readonly ReviewRepository _reviewRepository;
public ReviewController(ReviewRepository reviewRepository)
{
_reviewRepository = reviewRepository;
}
public IActionResult Index(int productId)
{
var reviews = _reviewRepository.GetReviewsByProductId(productId);
return View(reviews);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Review review)
{
if (ModelState.IsValid)
{
_reviewRepository.AddReview(review);
return RedirectToAction("Index", new { productId = review.ProductId });
}
return View(review);
}
public IActionResult Edit(int id)
{
var review = _reviewRepository.GetReviewsByProductId(id);
if (review == null)
{
return NotFound();
}
return View(review);
}
[HttpPost]
public IActionResult Edit(Review review)
{
if (ModelState.IsValid)
{
_reviewRepository.UpdateReview(review);
return RedirectToAction("Index", new { productId = review.ProductId });
}
return View(review);
}
public IActionResult Delete(int id)
{
var review = _reviewRepository.GetReviewsByProductId(id);
if (review == null)
{
return NotFound();
}
return View(review);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_reviewRepository.DeleteReview(id);
return RedirectToAction("Index");
}
}
}
8. Controllers/WishlistController.cs
using Microsoft.AspNetCore.Mvc;
using ECommerceWebsite.Models;
using ECommerceWebsite.Repositories;
namespace ECommerceWebsite.Controllers
{
public class WishlistController : Controller
{
private readonly WishlistRepository _wishlistRepository;
public WishlistController(WishlistRepository wishlistRepository)
{
_wishlistRepository = wishlistRepository;
}
public IActionResult Index(int userId)
{
var wishlists = _wishlistRepository.GetWishlistsByUser Id(userId);
return View(wishlists);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Wishlist wishlist)
{
if (ModelState.IsValid)
{
_wishlistRepository.AddWishlist(wishlist);
return RedirectToAction("Index", new { userId = wishlist.UserId });
}
return View(wishlist);
}
public IActionResult Delete(int id)
{
var wishlist = _wishlistRepository.GetWishlistsByUser Id(id);
if (wishlist == null)
{
return NotFound();
}
return View(wishlist);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_wishlistRepository.DeleteWishlist(id);
return RedirectToAction("Index");
}
}
}
9. Controllers/WishlistItemController.cs
using Microsoft.AspNetCore.Mvc;
using ECommerceWebsite.Models;
using ECommerceWebsite.Repositories;
namespace ECommerceWebsite.Controllers
{
public class WishlistItemController : Controller
{
private readonly WishlistItemRepository _wishlistItemRepository;
public WishlistItemController(WishlistItemRepository wishlistItemRepository)
{
_wishlistItemRepository = wishlistItemRepository;
}
public IActionResult Index(int wishlistId)
{
var wishlistItems = _wishlistItemRepository.GetWishlistItemsByWishlistId(wishlistId);
return View(wishlistItems);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(WishlistItem wishlistItem)
{
if (ModelState.IsValid)
{
_wishlistItemRepository.AddWishlistItem(wishlistItem);
return RedirectToAction("Index", new { wishlistId = wishlistItem.WishlistId });
}
return View(wishlistItem);
}
public IActionResult Delete(int id)
{
var wishlistItem = _wishlistItemRepository.GetWishlistItemsByWishlistId(id);
if (wishlistItem == null)
{
return NotFound();
}
return View(wishlistItem);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_wishlistItemRepository.DeleteWishlistItem(id);
return RedirectToAction("Index");
}
}
}
10. Controllers/CouponController.cs
using Microsoft.AspNetCore.Mvc;
using ECommerceWebsite.Models;
using ECommerceWebsite.Repositories;
namespace ECommerceWebsite.Controllers
{
public class CouponController : Controller
{
private readonly CouponRepository _couponRepository;
public CouponController(CouponRepository couponRepository)
{
_couponRepository = couponRepository;
}
public IActionResult Index()
{
var coupons = _couponRepository.GetAllCoupons();
return View(coupons);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Coupon coupon)
{
if (ModelState.IsValid)
{
_couponRepository.AddCoupon(coupon);
return RedirectToAction("Index");
}
return View(coupon);
}
public IActionResult Edit(int id)
{
var coupon = _couponRepository.GetCouponById(id);
if (coupon == null)
{
return NotFound();
}
return View(coupon);
}
[HttpPost]
public IActionResult Edit(Coupon coupon)
{
if (ModelState.IsValid)
{
_couponRepository.UpdateCoupon(coupon);
return RedirectToAction("Index");
}
return View(coupon);
}
public IActionResult Delete(int id)
{
var coupon = _couponRepository.GetCouponById(id);
if (coupon == null)
{
return NotFound();
}
return View(coupon);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_couponRepository.DeleteCoupon(id);
return RedirectToAction("Index");
}
}
}
11. Controllers/ShippingAddressController.cs
using Microsoft.AspNetCore.Mvc;
using ECommerceWebsite.Models;
using ECommerceWebsite.Repositories;
namespace ECommerceWebsite.Controllers
{
public class ShippingAddressController : Controller
{
private readonly ShippingAddressRepository _shippingAddressRepository;
public ShippingAddressController(ShippingAddressRepository shippingAddressRepository)
{
_shippingAddressRepository = shippingAddressRepository;
}
public IActionResult Index(int userId)
{
var shippingAddresses = _shippingAddressRepository.GetShippingAddressesByUser Id(userId);
return View(shippingAddresses);
}
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(ShippingAddress shippingAddress)
{
if (ModelState.IsValid)
{
_shippingAddressRepository.AddShippingAddress(shippingAddress);
return RedirectToAction("Index", new { userId = shippingAddress.UserId });
}
return View(shippingAddress);
}
public IActionResult Edit(int id)
{
var shippingAddress = _shippingAddressRepository.GetShippingAddressById(id);
if (shippingAddress == null)
{
return NotFound();
}
return View(shippingAddress);
}
[HttpPost]
public IActionResult Edit(ShippingAddress shippingAddress)
{
if (ModelState.IsValid)
{
_shippingAddressRepository.UpdateShippingAddress(shippingAddress);
return RedirectToAction("Index", new { userId = shippingAddress.UserId });
}
return View(shippingAddress);
}
public IActionResult Delete(int id)
{
var shippingAddress = _shippingAddressRepository.GetShippingAddressById(id);
if (shippingAddress == null)
{
return NotFound();
}
return View(shippingAddress);
}
[HttpPost, ActionName("Delete")]
public IActionResult DeleteConfirmed(int id)
{
_shippingAddressRepository.DeleteShippingAddress(id);
return RedirectToAction("Index");
}
}
}
This completes the controller implementations
Below are the view files for each of the controllers in your ASP.NET E-Commerce application. Each view will correspond to the actions defined in the controllers and will use Bootstrap for styling.
1. Views/User
Views/User/Index.cshtml
@model IEnumerable<ECommerceWebsite.Models.User>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>User List</title>
</head>
<body>
<div class="container">
<h2 class="mt-5">User List</h2>
<a href='@Url.Action("Create")" class="btn btn-primary mb-3">Create New User</a>
<table class="table">
<thead>
<tr>
<th>UserId</th>
<th>Username</th>
<th>Email</th>
<th>RoleId</th>
<th>CreatedAt</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var user in Model)
{
<tr>
<td>@user.UserId</td>
<td>@user.Username</td>
<td>@user.Email</td>
<td>@user.RoleId</td>
<td>@user.CreatedAt</td>
<td>
<a href='@Url.Action("Edit", new { id = user.UserId })" class="btn btn-warning">Edit</a>
<a href='@Url.Action("Delete", new { id = user.UserId })" class="btn btn-danger">Delete</a>
</td>
</tr>
}
</tbody>
</table>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
Views/User/Create.cshtml
@model ECommerceWebsite.Models.User
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Create User</title>
</head>
<body>
<div class="container">
<h2 class="mt-5">Create User</h2>
<form asp-action="Create" method="post">
<div class="mb-3">
<label for="Username" class="form-label">Username</label>
<input type="text" class="form-control" id="Username" name="Username" required>
</div>
<div class="mb-3">
<label for="Email" class="form-label">Email</label>
<input type="email" class="form-control" id="Email" name="Email" required>
</div>
<div class="mb-3">
<label for="PasswordHash" class="form-label">Password</label>
<input type="password" class="form-control" id="PasswordHash" name="PasswordHash" required>
</div>
<div class="mb-3">
<label for="RoleId" class="form-label">Role ID</label>
<input type="number" class="form-control" id="RoleId" name="RoleId" required>
</div>
<button type="submit" class="btn btn-primary">Create</button>
<a href='@Url.Action("Index")" class="btn btn-secondary">Back to List</a>
</form>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
Views/User/Edit.cshtml
@model ECommerceWebsite.Models.User
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Edit User</title>
</head>
<body>
<div class="container">
<h2 class="mt-5">Edit User</h2>
<form asp-action="Edit" method="post">
<input type="hidden" name="User Id " value="@Model.UserId" />
<div class="mb-3">
<label for="Username" class="form-label">Username</label>
<input type="text" class="form-control" id="Username" name="Username" value="@Model.Username" required>
</div>
<div class="mb-3">
<label for="Email" class="form-label">Email</label>
<input type="email" class="form-control" id="Email" name="Email" value="@Model.Email" required>
</div>
<div class="mb-3">
<label for="RoleId" class="form-label">Role ID</label>
<input type="number" class="form-control" id="RoleId" name="RoleId" value="@Model.RoleId" required>
</div>
<button type="submit" class="btn btn-primary">Save Changes</button>
<a href='@Url.Action("Index")" class="btn btn-secondary">Back to List</a>
</form>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
Views/User/Delete.cshtml
@model ECommerceWebsite.Models.User
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Delete User</title>
</head>
<body>
<div class="container">
<h2 class="mt-5">Delete User</h2>
<h4>Are you sure you want to delete this user?</h4>
<dl class="row">
<dt class="col-sm-3">Username</dt>
<dd class="col-sm-9">@Model.Username</dd>
<dt class="col-sm-3">Email</dt>
<dd class="col-sm-9">@Model.Email</dd>
</dl>
<form asp-action="DeleteConfirmed" method="post">
<input type="hidden" name="User Id" value="@Model.UserId" />
<button type="submit" class="btn btn-danger">Delete</button>
<a href='@Url.Action("Index")" class="btn btn-secondary">Cancel</a>
</form>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
2. Views/Role
Views/Role/Index.cshtml
@model IEnumerable<ECommerceWebsite.Models.Role>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Role List</title>
</head>
<body>
<div class="container">
<h2 class="mt-5">Role List</h2>
<a href='@Url.Action("Create")" class="btn btn-primary mb-3">Create New Role</a>
<table class="table">
<thead>
<tr>
<th>RoleId</th>
<th>RoleName</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var role in Model)
{
<tr>
<td>@role.RoleId</td>
<td>@role.RoleName</td>
<td>
<a href='@Url.Action("Edit", new { id = role.RoleId })" class="btn btn-warning">Edit</a>
<a href='@Url.Action("Delete", new { id = role.RoleId })" class="btn btn-danger">Delete</a>
</td>
</tr>
}
</tbody>
</table>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
Views/Role/Create.cshtml
@model ECommerceWebsite.Models.Role
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net .net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Create Role</title>
</head>
<body>
<div class="container">
<h2 class="mt-5">Create Role</h2>
<form asp-action="Create" method="post">
<div class="mb-3">
<label for="RoleName" class="form-label">Role Name</label>
<input type="text" class="form-control" id="RoleName" name="RoleName" required>
</div>
<button type="submit" class="btn btn-primary">Create</button>
<a href='@Url.Action("Index")" class="btn btn-secondary">Back to List</a>
</form>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
Views/Role/Edit.cshtml
@model ECommerceWebsite.Models.Role
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Edit Role</title>
</head>
<body>
<div class="container">
<h2 class="mt-5">Edit Role</h2>
<form asp-action="Edit" method="post">
<input type="hidden" name="RoleId" value="@Model.RoleId" />
<div class="mb-3">
<label for="RoleName" class="form-label">Role Name</label>
<input type="text" class="form-control" id="RoleName" name="RoleName" value="@Model.RoleName" required>
</div>
<button type="submit" class="btn btn-primary">Save Changes</button>
<a href='@Url.Action("Index")" class="btn btn-secondary">Back to List</a>
</form>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
Views/Role/Delete.cshtml
@model ECommerceWebsite.Models.Role
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Delete Role</title>
</head>
<body>
<div class="container">
<h2 class="mt-5">Delete Role</h2>
<h4>Are you sure you want to delete this role?</h4>
<dl class="row">
<dt class="col-sm-3">Role Name</dt>
<dd class="col-sm-9">@Model.RoleName</dd>
</dl>
<form asp-action="DeleteConfirmed" method="post">
<input type="hidden" name="RoleId" value="@Model.RoleId" />
<button type="submit" class="btn btn-danger">Delete</button>
<a href='@Url.Action("Index")" class="btn btn-secondary">Cancel</a>
</form>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
3. Views/Product
Views/Product/Index.cshtml
@model IEnumerable<ECommerceWebsite.Models.Product>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Product List</title>
</head>
<body>
<div class="container">
<h2 class="mt-5">Product List</h2>
<a href='@Url.Action("Create")" class="btn btn-primary mb-3">Create New Product</a>
<table class="table">
<thead>
<tr>
<th>ProductId</th>
<th>ProductName</th>
<th>Price</th>
<th>Stock</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var product in Model)
{
<tr>
<td>@product.ProductId</td>
<td>@product.ProductName</td>
<td>@product.Price</td>
<td>@product.Stock</td>
<td>
<a href='@Url.Action("Edit", new { id = product.ProductId })" class="btn btn-warning">Edit</a>
<a href='@Url.Action("Delete", new { id = product.ProductId })" class="btn btn-danger">Delete</a>
</td>
</tr>
}
</tbody>
</table>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
Views/Product/Create.cshtml
@model ECommerceWebsite.Models.Product
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Create Product</title>
</head>
<body>
<div class="container">
<h2 class="mt-5">Create Product</h2>
<form asp-action="Create" method="post">
<div class="mb-3">
<label for="ProductName" class="form-label">Product Name</label>
<input type="text" class="form-control" id="ProductName" name="ProductName" required>
</div>
<div class="mb-3">
<label for="Price" class="form-label">Price</label>
<input type="number" class="form-control" id="Price" name="Price" required>
</div>
<div class="mb-3">
<label for="Stock" class="form-label">Stock</label>
<input type="number" class="form-control" id="Stock" name="Stock" required>
</div>
<button type="submit" class="btn btn-primary">Create</button>
<a href='@Url.Action("Index")" class="btn btn-secondary">Back to List</a>
</form>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
Views/Product/Edit.cshtml
@model ECommerceWebsite.Models.Product
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Edit Product</title>
</head>
<body>
<div class="container">
<h2 class="mt-5">Edit Product</h2>
<form asp-action="Edit" method="post">
<input type="hidden" name="ProductId" value="@Model.ProductId" />
<div class="mb-3">
<label for="ProductName" class="form-label">Product Name</label>
<input type="text" class="form-control" id="ProductName" name="ProductName" value="@Model.ProductName" required>
</div>
<div class="mb-3">
<label for="Price" class="form-label">Price</label>
<input type="number" class="form-control" id="Price" name="Price" value="@Model.Price" required>
</div>
<div class="mb-3">
<label for="Stock" class="form-label">Stock</label>
<input type="number" class="form-control" id="Stock" name="Stock" value="@Model.Stock" required>
</div>
<button type="submit" class="btn btn-primary">Save Changes</button>
<a href='@Url.Action("Index")" class="btn btn-secondary">Back to List</a>
</form>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
Views/Product/Delete.cshtml
@model ECommerceWebsite.Models.Product
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https ://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Delete Product</title>
</head>
<body>
<div class="container">
<h2 class="mt-5">Delete Product</h2>
<h4>Are you sure you want to delete this product?</h4>
<dl class="row">
<dt class="col-sm-3">Product Name</dt>
<dd class="col-sm-9">@Model.ProductName</dd>
<dt class="col-sm-3">Price</dt>
<dd class="col-sm-9">@Model.Price</dd>
<dt class="col-sm-3">Stock</dt>
<dd class="col-sm-9">@Model.Stock</dd>
</dl>
<form asp-action="DeleteConfirmed" method="post">
<input type="hidden" name="ProductId" value="@Model.ProductId" />
<button type="submit" class="btn btn-danger">Delete</button>
<a href='@Url.Action("Index")" class="btn btn-secondary">Cancel</a>
</form>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
4. Views/CartItem
Views/CartItem/Index.cshtml
@model IEnumerable<ECommerceWebsite.Models.CartItem>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Cart Item List</title>
</head>
<body>
<div class="container">
<h2 class="mt-5">Cart Item List</h2>
<a href='@Url.Action("Create")" class="btn btn-primary mb-3">Add New Item</a>
<table class="table">
<thead>
<tr>
<th>CartItemId</th>
<th>ProductId</th>
<th>UserId</th>
<th>Quantity</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var item in Model)
{
<tr>
<td>@item.CartItemId</td>
<td>@item.ProductId</td>
<td>@item.UserId</td>
<td>@item.Quantity</td>
<td>
<a href='@Url.Action("Edit", new { id = item.CartItemId })" class="btn btn-warning">Edit</a>
<a href='@Url.Action("Delete", new { id = item.CartItemId })" class="btn btn-danger">Delete</a>
</td>
</tr>
}
</tbody>
</table>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
Views/CartItem/Create.cshtml
@model ECommerceWebsite.Models.CartItem
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Add Cart Item</title>
</head>
<body>
<div class="container">
<h2 class="mt-5">Add Cart Item</h2>
<form asp-action="Create" method="post">
<div class="mb-3">
<label for="ProductId" class="form-label">Product ID</label>
<input type="number" class="form-control" id="ProductId" name="ProductId" required>
</div>
<div class="mb-3">
<label for="User Id" class="form-label">User ID</label>
<input type="number" class="form-control" id="User Id" name="User Id" required>
</div>
<div class="mb-3">
<label for="Quantity" class="form-label">Quantity</label>
<input type="number" class="form-control" id="Quantity" name="Quantity" required>
</div>
<button type="submit" class="btn btn-primary">Add</button>
<a href="@Url .Action("Index")" class="btn btn-secondary">Back to List</a>
</form>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
Views/CartItem/Edit.cshtml
@model ECommerceWebsite.Models.CartItem
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Edit Cart Item</title>
</head>
<body>
<div class="container">
<h2 class="mt-5">Edit Cart Item</h2>
<form asp-action="Edit" method="post">
<input type="hidden" name="CartItemId" value="@Model.CartItemId" />
<div class="mb-3">
<label for="ProductId" class="form-label">Product ID</label>
<input type="number" class="form-control" id="ProductId" name="ProductId" value="@Model.ProductId" required>
</div>
<div class="mb-3">
<label for="User Id" class="form-label">User ID</label>
<input type="number" class="form-control" id="User Id" name="User Id" value="@Model.UserId" required>
</div>
<div class="mb-3">
<label for="Quantity" class="form-label">Quantity</label>
<input type="number" class="form-control" id="Quantity" name="Quantity" value="@Model.Quantity" required>
</div>
<button type="submit" class="btn btn-primary">Save Changes</button>
<a href='@Url.Action("Index")" class="btn btn-secondary">Back to List</a>
</form>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
Views/CartItem/Delete.cshtml
@model ECommerceWebsite.Models.CartItem
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Delete Cart Item</title>
</head>
<body>
<div class="container">
<h2 class="mt-5">Delete Cart Item</h2>
<h4>Are you sure you want to delete this cart item?</h4>
<dl class="row">
<dt class="col-sm-3">Product ID</dt>
<dd class="col-sm-9">@Model.ProductId</dd>
<dt class="col-sm-3">User ID</dt>
<dd class="col-sm-9">@Model.UserId</dd>
<dt class="col-sm-3">Quantity</dt>
<dd class="col-sm-9">@Model.Quantity</dd>
</dl>
<form asp-action="DeleteConfirmed" method="post">
<input type="hidden" name="CartItemId" value="@Model.CartItemId" />
<button type="submit" class="btn btn-danger">Delete</button>
<a href='@Url.Action("Index")" class="btn btn-secondary">Cancel</a>
</form>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
5. Views/Order
Views/Order/Index.cshtml
@model IEnumerable<ECommerceWebsite.Models.Order>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Order List</title>
</head>
<body>
<div class="container">
<h2 class="mt-5">Order List</h2>
<a href='@Url.Action("Create")" class="btn btn-primary mb-3">Create New Order</a>
<table class="table">
<thead>
<tr>
<th >OrderId</th>
<th>UserId</th>
<th>TotalAmount</th>
<th>OrderDate</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var order in Model)
{
<tr>
<td>@order.OrderId</td>
<td>@order.UserId</td>
<td>@order.TotalAmount</td>
<td>@order.OrderDate</td>
<td>
<a href='@Url.Action("Edit", new { id = order.OrderId })" class="btn btn-warning">Edit</a>
<a href='@Url.Action("Delete", new { id = order.OrderId })" class="btn btn-danger">Delete</a>
</td>
</tr>
}
</tbody>
</table>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
Views/Order/Create.cshtml
@model ECommerceWebsite.Models.Order
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Create Order</title>
</head>
<body>
<div class="container">
<h2 class="mt-5">Create Order</h2>
<form asp-action="Create" method="post">
<div class="mb-3">
<label for="User Id" class="form-label">User ID</label>
<input type="number" class="form-control" id="User Id" name="User Id" required>
</div>
<div class="mb-3">
<label for="TotalAmount" class="form-label">Total Amount</label>
<input type="number" class="form-control" id="TotalAmount" name="TotalAmount" required>
</div>
<button type="submit" class="btn btn-primary">Create</button>
<a href='@Url.Action("Index")" class="btn btn-secondary">Back to List</a>
</form>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
Views/Order/Edit.cshtml
@model ECommerceWebsite.Models.Order
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Edit Order</title>
</head>
<body>
<div class="container">
<h2 class ="mt-5">Edit Order</h2>
<form asp-action="Edit" method="post">
<input type="hidden" name="OrderId" value="@Model.OrderId" />
<div class="mb-3">
<label for="User Id" class="form-label">User ID</label>
<input type="number" class="form-control" id="User Id" name="User Id" value="@Model.UserId" required>
</div>
<div class="mb-3">
<label for="TotalAmount" class="form-label">Total Amount</label>
<input type="number" class="form-control" id="TotalAmount" name="TotalAmount" value="@Model.TotalAmount" required>
</div>
<button type="submit" class="btn btn-primary">Save Changes</button>
<a href='@Url.Action("Index")" class="btn btn-secondary">Back to List</a>
</form>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
Views/Order/Delete.cshtml
@model ECommerceWebsite.Models.Order
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Delete Order</title>
</head>
<body>
<div class="container">
<h2 class="mt-5">Delete Order</h2>
<h4>Are you sure you want to delete this order?</h4>
<dl class="row">
<dt class="col-sm-3">User ID</dt>
<dd class="col-sm-9">@Model.UserId</dd>
<dt class="col-sm-3">Total Amount</dt>
<dd class="col-sm-9">@Model.TotalAmount</dd>
<dt class="col-sm-3">Order Date</dt>
<dd class="col-sm-9">@Model.OrderDate</dd>
</dl>
<form asp-action="DeleteConfirmed" method="post">
<input type="hidden" name="OrderId" value="@Model.OrderId" />
<button type="submit" class="btn btn-danger">Delete</button>
<a href='@Url.Action("Index")" class="btn btn-secondary">Cancel</a>
</form>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
6. Views/OrderItem
Views/OrderItem/Index.cshtml
@model IEnumerable<ECommerceWebsite.Models.OrderItem>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Order Item List</title>
</head>
<body>
<div class="container">
<h2 class="mt-5">Order Item List</h2>
<a href='@Url.Action("Create")" class="btn btn-primary mb-3">Add New Item</a>
<table class="table">
<thead>
<tr>
<th>OrderItemId</th>
<th>OrderId</th>
<th>ProductId</th>
<th>Quantity</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var item in Model)
{
<tr>
<td>@item.OrderItemId</td>
<td>@item.OrderId</td>
<td>@item.ProductId</td>
<td>@item.Quantity</td>
<td>
<a href='@Url.Action("Edit", new { id = item.OrderItemId })" class="btn btn-warning">Edit</a>
<a href='@Url.Action("Delete", new { id = item.OrderItemId })" class="btn btn-danger">Delete</a>
</td>
</tr>
}
</tbody>
</table>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
Views/Order Item/Create.cshtml
@model ECommerceWebsite.Models.OrderItem
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Add Order Item</title>
</head>
<body>
<div class="container">
<h2 class="mt-5">Add Order Item</h2>
<form asp-action="Create" method="post">
<div class="mb-3">
<label for="OrderId" class="form-label">Order ID</label>
<input type="number" class="form-control" id="OrderId" name="OrderId" required>
</div>
<div class="mb-3">
<label for="ProductId" class="form-label">Product ID</label>
<input type="number" class="form-control" id="ProductId" name="ProductId" required>
</div>
<div class="mb-3">
<label for="Quantity" class="form-label">Quantity</label>
<input type="number" class="form-control" id="Quantity" name="Quantity" required>
</div>
<button type="submit" class="btn btn-primary">Add</button>
<a href='@Url.Action("Index")" class="btn btn-secondary">Back to List</a>
</form>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
Views/OrderItem/Edit.cshtml
@model ECommerceWebsite.Models.OrderItem
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Edit Order Item</title>
</head>
<body>
<div class="container">
<h2 class="mt-5">Edit Order Item</h2>
<form asp-action="Edit" method="post">
<input type="hidden" name="OrderItemId" value="@Model.OrderItemId" />
<div class="mb-3">
<label for="OrderId" class="form-label">Order ID</label>
<input type="number" class="form-control" id="OrderId" name="OrderId" value="@Model.OrderId" required>
</div>
<div class="mb-3">
<label for="ProductId" class="form-label">Product ID</label>
<input type="number" class="form-control" id="ProductId" name="ProductId" value="@Model.ProductId" required>
</div>
<div class="mb-3">
<label for="Quantity" class="form-label">Quantity</label>
<input type="number" class="form-control" id="Quantity" name="Quantity" value="@Model.Quantity" required>
</div>
<button type="submit" class="btn btn-primary">Save Changes</button>
<a href='@Url.Action("Index")" class="btn btn-secondary">Back to List</a>
</form>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
Views/OrderItem/Delete.cshtml
@model ECommerceWebsite.Models.OrderItem
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Delete Order Item</title>
</head>
<body>
<div class="container">
<h2 class="mt-5">Delete Order Item</h2>
<h4>Are you sure you want to delete this order item?</h4>
<dl class="row">
<dt class="col-sm-3">Order ID</dt>
<dd class="col-sm-9">@Model.OrderId</dd>
<dt class="col-sm-3">Product ID</dt>
<dd class="col-sm-9">@Model.ProductId</dd>
<dt class="col-sm -3">Quantity</dt>
<dd class="col-sm-9">@Model.Quantity</dd>
</dl>
<form asp-action="DeleteConfirmed" method="post">
<input type="hidden" name="OrderItemId" value="@Model.OrderItemId" />
<button type="submit" class="btn btn-danger">Delete</button>
<a href='@Url.Action("Index")" class="btn btn-secondary">Cancel</a>
</form>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
7. Views/Review
Views/Review/Index.cshtml
@model IEnumerable<ECommerceWebsite.Models.Review>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Review List</title>
</head>
<body>
<div class="container">
<h2 class="mt-5">Review List</h2>
<a href='@Url.Action("Create")" class="btn btn-primary mb-3">Add New Review</a>
<table class="table">
<thead>
<tr>
<th>ReviewId</th>
<th>ProductId</th>
<th>UserId</th>
<th>Rating</th>
<th>Comment</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var review in Model)
{
<tr>
<td>@review.ReviewId</td>
<td>@review.ProductId</td>
<td>@review.UserId</td>
<td>@review.Rating</td>
<td>@review.Comment</td>
<td>
<a href='@Url.Action("Edit", new { id = review.ReviewId })" class="btn btn-warning">Edit</a>
<a href='@Url.Action("Delete", new { id = review.ReviewId })" class="btn btn-danger">Delete</a>
</td>
</tr>
}
</tbody>
</table>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
Views/Review/Create.cshtml
@model ECommerceWebsite.Models.Review
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Add Review</title>
</head>
<body>
<div class="container">
<h2 class="mt-5">Add Review</h2>
<form asp-action="Create" method="post">
<div class="mb-3">
<label for="ProductId" class="form-label">Product ID</label>
<input type="number" class="form-control" id="ProductId" name="ProductId" required>
</div>
<div class="mb-3">
<label for="User Id" class="form-label">User ID</label>
<input type="number" class="form-control" id="User Id" name="User Id" required>
</div>
<div class="mb-3">
<label for="Rating" class="form-label">Rating</label>
<input type="number" class="form-control" id="Rating" name="Rating" min="1" max="5" required>
</div>
<div class="mb-3">
<label for="Comment" class="form-label">Comment</label>
<textarea class="form-control" id="Comment" name="Comment" required></textarea>
</div>
<button type="submit" class="btn btn-primary">Add</button>
<a href='@Url.Action("Index")" class="btn btn-secondary">Back to List</a>
</form>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
Views/Review/Edit.cshtml
@model ECommerceWebsite.Models.Review
<!DOCTYPE html
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Edit Review</title>
</head>
<body>
<div class="container">
<h2 class="mt-5">Edit Review</h2>
<form asp-action="Edit" method="post">
<input type="hidden" name="ReviewId" value="@Model.ReviewId" />
<div class="mb-3">
<label for="ProductId" class="form-label">Product ID</label>
<input type="number" class="form-control" id="ProductId" name="ProductId" value="@Model.ProductId" required>
</div>
<div class="mb-3">
<label for="User Id" class="form-label">User ID</label>
<input type="number" class="form-control" id="User Id" name="User Id" value="@Model.UserId" required>
</div>
<div class="mb-3">
<label for="Rating" class="form-label">Rating</label>
<input type="number" class="form-control" id="Rating" name="Rating" value="@Model.Rating" min="1" max="5" required>
</div>
<div class="mb-3">
<label for="Comment" class="form-label">Comment</label>
<textarea class="form-control" id="Comment" name="Comment" required>@Model.Comment</textarea>
</div>
<button type="submit" class="btn btn-primary">Save Changes</button>
<a href='@Url.Action("Index")" class="btn btn-secondary">Back to List</a>
</form>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
Views/Review/Delete.cshtml
@model ECommerceWebsite.Models.Review
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Delete Review</title>
</head>
<body>
<div class="container">
<h2 class="mt-5">Delete Review</h2>
<h4>Are you sure you want to delete this review?</h4>
<dl class="row">
<dt class="col-sm-3">Product ID</dt>
<dd class="col-sm-9">@Model.ProductId</dd>
<dt class="col-sm-3">User ID</dt>
<dd class="col-sm-9">@Model.UserId</dd>
<dt class="col-sm-3">Rating</dt>
<dd class="col-sm-9">@Model.Rating</dd>
<dt class="col-sm-3">Comment</dt>
<dd class="col-sm-9">@Model.Comment</dd>
</dl>
<form asp-action="DeleteConfirmed" method="post">
<input type="hidden" name="ReviewId" value="@Model.ReviewId" />
<button type="submit" class="btn btn-danger">Delete</button>
<a href='@Url.Action("Index")" class="btn btn-secondary">Cancel</a>
</form>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
8. Views/Wishlist
Views/Wishlist/Index.cshtml
@model IEnumerable<ECommerceWebsite.Models.Wishlist>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Wishlist List</title>
</head>
<body>
<div class="container">
<h2 class="mt-5">Wishlist List</h2>
<a href='@Url.Action("Create")" class="btn btn-primary mb-3">Create New Wishlist</a>
<table class="table">
<thead>
<tr>
<th>WishlistId</th>
<th>UserId</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var wishlist in Model)
{
<tr>
<td>@wishlist.WishlistId</td>
<td>@wishlist.UserId</td>
<td>
<a href='@Url.Action("Delete", new { id = wishlist.WishlistId })" class="btn btn-danger">Delete</a>
</td>
</tr>
}
</tbody>
</table>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
Views/Wishlist/Create.cshtml
@model ECommerceWebsite.Models.Wishlist
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Create Wishlist</title>
</head>
<body>
<div class="container">
<h2 class="mt-5">Create Wishlist</h2>
<form asp-action="Create" method="post">
<div class="mb-3">
<label for="User Id" class="form-label">User ID</label>
<input type="number" class="form-control" id="User Id" name="User Id" required>
</div>
<button type="submit" class="btn btn-primary">Create</button>
<a href='@Url.Action("Index")" class="btn btn-secondary">Back to List</a>
</form>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
Views/Wishlist/Delete.cshtml
@model ECommerceWebsite.Models.Wishlist
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Delete Wishlist</title>
</head>
<body>
<div class="container">
<h2 class="mt-5">Delete Wishlist</h2>
<h4>Are you sure you want to delete this wishlist?</h4>
<dl class="row">
<dt class="col-sm-3">User ID</dt>
<dd class="col-sm-9">@Model.UserId</dd>
</dl>
<form asp-action="DeleteConfirmed" method="post">
<input type="hidden" name="WishlistId" value="@Model.WishlistId" />
<button type="submit" class="btn btn-danger">Delete</button>
<a href='@Url.Action("Index")" class="btn btn-secondary">Cancel</a>
</form>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
9. Views/WishlistItem
Views/WishlistItem/Index.cshtml
@model IEnumerable<ECommerceWebsite.Models.WishlistItem>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Wishlist Item List</title>
</head>
<body>
<div class="container">
<h2 class="mt-5">Wishlist Item List</h2>
<a href='@Url.Action("Create")" class="btn btn-primary mb-3">Add New Item</a>
<table class="table">
<thead>
<tr>
<th>WishlistItemId</th>
<th>WishlistId</th>
<th>ProductId</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var item in Model)
{
<tr>
<td>@item.WishlistItemId</td>
<td>@item.WishlistId</td>
<td>@item.ProductId</td>
<td>
<a href="@Url .Action("Delete", new { id = item.WishlistItemId })" class="btn btn-danger">Delete</a>
</td>
</tr>
}
</tbody>
</table>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
Views/WishlistItem/Create.cshtml
@model ECommerceWebsite.Models.WishlistItem
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Add Wishlist Item</title>
</head>
<body>
<div class="container">
<h2 class="mt-5">Add Wishlist Item</h2>
<form asp-action="Create" method="post">
<div class="mb-3">
<label for="WishlistId" class="form-label">Wishlist ID</label>
<input type="number" class="form-control" id="WishlistId" name="WishlistId" required>
</div>
<div class="mb-3">
<label for="ProductId" class="form-label">Product ID</label>
<input type="number" class="form-control" id="ProductId" name="ProductId" required>
</div>
<button type="submit" class="btn btn-primary">Add</button>
<a href='@Url.Action("Index")" class="btn btn-secondary">Back to List</a>
</form>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
Views/WishlistItem/Delete.cshtml
@model ECommerceWebsite.Models.WishlistItem
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Delete Wishlist Item</title>
</head>
<body>
<div class="container">
<h2 class="mt-5">Delete Wishlist Item</h2>
<h4>Are you sure you want to delete this wishlist item?</h4>
<dl class="row">
<dt class="col-sm-3">Wishlist ID</dt>
<dd class="col-sm-9">@Model.WishlistId</dd>
<dt class="col-sm-3">Product ID</dt>
<dd class="col-sm-9">@Model.ProductId</dd>
</dl>
<form asp-action="DeleteConfirmed" method="post">
<input type="hidden" name="WishlistItemId" value="@Model.WishlistItemId" />
<button type="submit" class="btn btn-danger">Delete</button>
<a href='@Url.Action("Index")" class="btn btn-secondary">Cancel</a>
</form>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
10. Views/Coupon
Views/Coupon/Index.cshtml
@model IEnumerable<ECommerceWebsite.Models.Coupon>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Coupon List</title>
</head>
<body>
<div class="container">
<h2 class="mt-5">Coupon List</h2>
<a href='@Url.Action("Create")" class="btn btn-primary mb-3">Create New Coupon</a>
<table class="table">
<thead>
<tr>
<th>CouponId</th>
<th>Code</th>
<th>Discount</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var coupon in Model)
{
<tr>
<td>@coupon.CouponId</td>
<td>@coupon.Code</td>
<td>@coupon.Discount</td>
<td>
<a href='@Url.Action("Edit", new { id = coupon.CouponId })" class="btn btn-warning">Edit</a>
<a href='@Url.Action("Delete", new { id = coupon.CouponId })" class="btn btn-danger">Delete</a>
</td>
</tr>
}
</tbody>
</table>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
Views/Coupon/Create.cshtml
@model ECommerceWebsite.Models.Coupon
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Create Coupon</title>
</head>
<body>
<div class="container">
<h2 class="mt-5">Create Coupon</h2>
<form asp-action="Create" method="post">
<div class="mb-3">
<label for="Code" class="form-label">Coupon Code</label>
<input type="text" class="form-control" id="Code" name="Code" required>
</div>
<div class="mb-3">
<label for="Discount" class="form-label">Discount</label>
<input type="number" class="form-control" id="Discount" name="Discount" required>
</div>
<button type="submit" class="btn btn-primary">Create</button>
<a href='@Url.Action("Index")" class="btn btn-secondary">Back to List</a>
</form>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
Views/Coupon/Edit.cshtml
@model ECommerceWebsite.Models.Coupon
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Edit Coupon</title>
</head>
<body>
<div class="container">
<h2 class="mt-5">Edit Coupon</h2>
<form asp-action="Edit" method="post">
<input type="hidden" name="CouponId" value="@Model.CouponId" />
<div class="mb-3">
<label for="Code" class="form-label">Coupon Code</label>
<input type="text" class="form-control" id="Code" name="Code" value="@Model.Code" required>
</div>
<div class="mb-3">
<label for="Discount" class="form-label">Discount</label>
<input type="number" class="form-control" id="Discount" name="Discount" value="@Model.Discount" required>
</div>
<button type="submit" class="btn btn-primary">Save Changes</button>
<a href='@Url.Action("Index")" class="btn btn-secondary">Back to List</a>
</form>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
Views/Coupon/Delete.cshtml
@model ECommerceWebsite.Models.Coupon
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Delete Coupon</title>
</head>
<body>
<div class="container">
<h2 class="mt-5">Delete Coupon</h2>
<h4>Are you sure you want to delete this coupon?</h4>
<dl class="row">
<dt class="col-sm-3">Coupon Code</dt>
<dd class="col-sm-9">@Model.Code</dd>
<dt class="col-sm-3">Discount</dt>
<dd class="col-sm-9">@Model.Discount</dd>
</dl>
<form asp-action="DeleteConfirmed" method="post">
<input type="hidden" name="CouponId" value="@Model.CouponId" />
<button type="submit" class="btn btn-danger">Delete</button>
<a href='@Url.Action("Index")" class="btn btn-secondary">Cancel</a>
</form>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
11. Views/ShippingAddress
Views/ShippingAddress/Index.cshtml
@model IEnumerable<ECommerceWebsite.Models.ShippingAddress>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Shipping Address List</title>
</head>
<body>
<div class="container">
<h2 class="mt-5">Shipping Address List</h2>
<a href='@Url.Action("Create")" class="btn btn-primary mb-3">Add New Address</a>
<table class="table">
<thead>
<tr>
<th>ShippingAddressId</th>
<th>UserId</th>
<th>AddressLine1</th>
<th>City</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var address in Model)
{
<tr>
<td>@address.ShippingAddressId</td>
<td>@address.UserId</td>
<td>@address.AddressLine1</td>
<td>@address.City</td>
<td>
<a href='@Url.Action("Edit", new { id = address.ShippingAddressId })" class="btn btn-warning">Edit</a>
<a href='@Url.Action("Delete", new { id = address.ShippingAddressId })" class="btn btn-danger">Delete</a>
</td>
</tr>
}
</tbody>
</table>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
Views/ShippingAddress/Create.cshtml
@model ECommerceWebsite.Models.ShippingAddress
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Create Shipping Address</title>
</head>
<body>
<div class="container">
<h2 class="mt-5">Create Shipping Address</h2>
<form asp-action="Create" method="post">
<div class="mb-3">
<label for="User Id" class="form-label">User ID</label>
<input type="number" class="form-control" id="User Id" name="User Id" required>
</div>
<div class="mb-3">
<label for="AddressLine1" class="form-label">Address Line 1</label>
<input type="text" class="form-control" id="AddressLine1" name="AddressLine1" required>
</div>
<div class="mb-3">
<label for="City" class="form-label">City</label>
<input type="text" class="form-control" id="City" name="City" required>
</div>
<button type="submit" class="btn btn-primary">Create</button>
<a href='@Url.Action("Index")" class="btn btn-secondary">Back to List</a>
</form>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
Views/ShippingAddress/Edit.cshtml
@model ECommerceWebsite.Models.ShippingAddress
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Edit Shipping Address</title>
</head>
<body>
<div class="container">
<h2 class="mt -5">Edit Shipping Address</h2>
<form asp-action="Edit" method="post">
<input type="hidden" name="ShippingAddressId" value="@Model.ShippingAddressId" />
<div class="mb-3">
<label for="User Id" class="form-label">User ID</label>
<input type="number" class="form-control" id="User Id" name="User Id" value="@Model.UserId" required>
</div>
<div class="mb-3">
<label for="AddressLine1" class="form-label">Address Line 1</label>
<input type="text" class="form-control" id="AddressLine1" name="AddressLine1" value="@Model.AddressLine1" required>
</div>
<div class="mb-3">
<label for="City" class="form-label">City</label>
<input type="text" class="form-control" id="City" name="City" value="@Model.City" required>
</div>
<button type="submit" class="btn btn-primary">Save Changes</button>
<a href='@Url.Action("Index")" class="btn btn-secondary">Back to List</a>
</form>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
Views/ShippingAddress/Delete.cshtml
@model ECommerceWebsite.Models.ShippingAddress
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Delete Shipping Address</title>
</head>
<body>
<div class="container">
<h2 class="mt-5">Delete Shipping Address</h2>
<h4>Are you sure you want to delete this shipping address?</h4>
<dl class="row">
<dt class="col-sm-3">User ID</dt>
<dd class="col-sm-9">@Model.UserId</dd>
<dt class="col-sm-3">Address Line 1</dt>
<dd class="col-sm-9">@Model.AddressLine1</dd>
<dt class="col-sm-3">City</dt>
<dd class="col-sm-9">@Model.City</dd>
</dl>
<form asp-action="DeleteConfirmed" method="post">
<input type="hidden" name="ShippingAddressId" value="@Model.ShippingAddressId" />
<button type="submit" class="btn btn-danger">Delete</button>
<a href='@Url.Action("Index")" class="btn btn-secondary">Cancel</a>
</form>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
Now create the shop page and display the product aslo add the features for add to cart, add to wishlist
To create a shop page that displays products and includes features for adding items to the cart and wishlist, we will follow these steps:
Create the Shop Page View: This will display the list of products.
Add "Add to Cart" and "Add to Wishlist" buttons: These buttons will allow users to add products to their cart or wishlist.
Implement the necessary actions in the ProductController: This will handle the logic for adding products to the cart and wishlist.
1. Create the Shop Page View
Views/Product/Shop.cshtml
@model IEnumerable<ECommerceWebsite.Models.Product>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Shop</title>
</head>
<body>
<div class="container">
<h2 class="mt-5">Shop</h2>
<div class="row">
@foreach (var product in Model)
{
<div class="col-md-4 mb-4">
<div class="card">
<div class="card-body">
<h5 class="card-title">@product.Name</h5>
<p class="card-text">@product.Description</p>
<p class="card-text"><strong>Price: </strong>@product.Price.ToString("C")</p>
<p class="card-text"><strong>Stock: </strong>@product.Stock</p>
<form asp-action="AddToCart" method="post">
<input type="hidden" name="ProductId" value="@product.ProductId" />
<button type="submit" class="btn btn-primary">Add to Cart</button>
</form>
<form asp-action="AddToWishlist" method="post" class="mt-2">
<input type="hidden" name="ProductId" value="@product.ProductId" />
<button type="submit" class="btn btn-secondary">Add to Wishlist</button>
</form>
</div>
</div>
</div>
}
</div>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
2. Implement the Actions in the ProductController
Controllers/ProductController.cs
Add the following methods to your ProductController to handle adding products to the cart and wishlist.
using Microsoft.AspNetCore.Mvc;
using ECommerceWebsite.Models;
using ECommerceWebsite.Repositories;
namespace ECommerceWebsite.Controllers
{
public class ProductController : Controller
{
private readonly ProductRepository _productRepository;
private readonly CartItemRepository _cartItemRepository;
private readonly WishlistRepository _wishlistRepository;
public ProductController(ProductRepository productRepository, CartItemRepository cartItemRepository, WishlistRepository wishlistRepository)
{
_productRepository = productRepository;
_cartItemRepository = cartItemRepository;
_wishlistRepository = wishlistRepository;
}
public IActionResult Shop()
{
var products = _productRepository.GetAllProducts();
return View(products);
}
[HttpPost]
public IActionResult AddToCart(int productId)
{
// Assuming you have a way to get the current user's ID
int userId = GetCurrentUser Id(); // Implement this method to get the current user's ID
var cartItem = new CartItem
{
UserId = userId,
ProductId = productId,
Quantity = 1, // Default quantity
CreatedAt = DateTime.Now
};
_cartItemRepository.AddCartItem(cartItem);
return RedirectToAction("Shop");
}
[HttpPost]
public IActionResult AddToWishlist(int productId)
{
// Assuming you have a way to get the current user's ID
int userId = GetCurrentUser Id(); // Implement this method to get the current user's ID
var wishlistItem = new WishlistItem
{
WishlistId = GetWishlistIdByUser Id(userId), // Implement this method to get the user's wishlist ID
ProductId = productId
};
_wishlistRepository.AddWishlistItem(wishlistItem);
return RedirectToAction("Shop");
}
// Implement GetCurrentUser Id and GetWishlistIdByUser Id methods as needed
}
}
Implement Helper Methods
You will need to implement the GetCurrentUser Id and GetWishlistIdByUser Id methods to retrieve the current user's ID and their wishlist ID.
private int Get CurrentUser Id()
{
// Logic to retrieve the current user's ID from the session or authentication context
return HttpContext.User.Identity.IsAuthenticated ? Convert.ToInt32(HttpContext.User.FindFirst("User Id")?.Value) : 0;
}
private int GetWishlistIdByUser Id(int userId)
{
// Logic to retrieve the wishlist ID for the given user ID
var wishlist = _wishlistRepository.GetWishlistByUser Id(userId);
return wishlist?.WishlistId ?? 0; // Return 0 if no wishlist found
}
With the above implementation, you now have a shop page that displays products with options to add them to the cart or wishlist. The AddToCart and AddToWishlist actions in the ProductController handle the logic for adding items based on the user's actions. Make sure to adjust the repository methods to fit your data access layer and ensure that the necessary models and views are in place.
Creating the Dashboard Page
To create a dashboard page for your E-Commerce project that displays consolidated data, we will follow these steps:
Step 1: Create the Dashboard View
This view will display various statistics and data related to your e-commerce application.
Views/Admin/Dashboard.cshtml
@model ECommerceWebsite.ViewModels.DashboardViewModel
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Dashboard</title>
</head>
<body>
<div class="container">
<h2 class="mt-5">Dashboard</h2>
<div class="row">
<div class="col-md-4 mb-4">
<div class="card text-white bg-primary">
<div class="card-body">
<h5 class="card-title">Total Users</h5>
<p class="card-text">@Model.TotalUsers</p>
</div>
</div>
</div>
<div class="col-md-4 mb-4">
<div class="card text-white bg-success">
<div class="card-body">
<h5 class="card-title">Total Products</h5>
<p class="card-text">@Model.TotalProducts</p>
</div>
</div>
</div>
<div class="col-md-4 mb-4">
<div class="card text-white bg-warning">
<div class="card-body">
<h5 class="card-title">Total Orders</h5>
<p class="card-text">@Model.TotalOrders</p>
</div>
</div>
</div>
</div>
<div class="row">
<div class="col-md-4 mb-4">
<div class="card text-white bg-info">
<div class="card-body">
<h5 class="card-title">Total Revenue</h5>
<p class="card-text">@Model.TotalRevenue.ToString("C")</p>
</div>
</div>
</div>
<div class="col-md-4 mb-4">
<div class="card text-white bg-danger">
<div class="card-body">
<h5 class="card-title">Total Reviews</h5>
<p class="card-text">@Model.TotalReviews</p>
</div>
</div>
</div>
<div class="col-md-4 mb-4">
<div class="card text-white bg-secondary">
<div class="card-body">
<h5 class="card-title">Total Coupons</h5>
<p class="card-text">@Model.TotalCoupons</p>
</div>
</div>
</div>
</div>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
2. Create the Dashboard ViewModel
Create a ViewModel to hold the data for the dashboard.
ViewModels/DashboardViewModel.cs
namespace ECommerceWebsite.ViewModels
{
public class DashboardViewModel
{
public int TotalUsers { get; set; }
public int TotalProducts { get; set; }
public int TotalOrders { get; set; }
public decimal TotalRevenue { get; set; }
public int TotalReviews { get; set; }
public int TotalCoupons { get; set; }
}
}
Step 2: Implement the Dashboard Controller
This controller will fetch the necessary data from the repositories and pass it to the view.
Controllers/AdminController.cs
using Microsoft.AspNetCore.Mvc;
using ECommerceWebsite.Repositories;
using ECommerceWebsite.ViewModels;
namespace ECommerceWebsite.Controllers
{
public class AdminController : Controller
{
private readonly UserRepository _userRepository;
private readonly ProductRepository _productRepository;
private readonly OrderRepository _orderRepository;
private readonly ReviewRepository _reviewRepository;
private readonly CouponRepository _couponRepository;
public AdminController(UserRepository userRepository, ProductRepository productRepository, OrderRepository orderRepository, ReviewRepository reviewRepository, CouponRepository couponRepository)
{
_userRepository = userRepository;
_productRepository = productRepository;
_orderRepository = orderRepository;
_reviewRepository = reviewRepository;
_couponRepository = couponRepository }
public IActionResult Dashboard()
{
var dashboardViewModel = new DashboardViewModel
{
TotalUsers = _userRepository.GetTotalUsers(),
TotalProducts = _productRepository.GetTotalProducts(),
TotalOrders = _orderRepository.GetTotalOrders(),
TotalRevenue = _orderRepository.GetTotalRevenue(),
TotalReviews = _reviewRepository.GetTotalReviews(),
TotalCoupons = _couponRepository.GetTotalCoupons()
};
return View(dashboardViewModel);
}
}
}
Step 3: Implement Repository Methods
Ensure that your repository classes have the necessary methods to retrieve the required data.
Example Methods in Repositories
public class UserRepository
{
public int GetTotalUsers()
{
// Logic to get total users from the database
}
}
public class ProductRepository
{
public int GetTotalProducts()
{
// Logic to get total products from the database
}
}
public class OrderRepository
{
public int GetTotalOrders()
{
// Logic to get total orders from the database
}
public decimal GetTotalRevenue()
{
// Logic to calculate total revenue from orders
}
}
public class ReviewRepository
{
public int GetTotalReviews()
{
// Logic to get total reviews from the database
}
}
public class CouponRepository
{
public int GetTotalCoupons()
{
// Logic to get total coupons from the database
}
}
With this implementation, you now have a dashboard page that displays consolidated data related to your e-commerce project, including total users, products, orders, revenue, reviews, and coupons. The AdminController fetches the necessary data from the repositories and passes it to the view for display. Make sure to adjust the repository methods to fit your data access layer and ensure that the necessary models and views are in place.
Implementing GetTotal Methods
Below are the complete implementations of the GetTotal methods for each repository in your ASP.NET E-Commerce application. These methods will retrieve the total counts for users, products, orders, reviews, and coupons from the database.
1. UserRepository.cs
using System.Data.SqlClient;
namespace ECommerceWebsite.Repositories
{
public class UserRepository
{
private readonly string _connectionString;
public UserRepository(string connectionString)
{
_connectionString = connectionString;
}
public int GetTotalUsers()
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT COUNT(*) FROM Users", connection);
connection.Open();
return (int)command.ExecuteScalar();
}
}
// Other methods...
}
}
2. ProductRepository.cs
using System.Data.SqlClient;
namespace ECommerceWebsite.Repositories
{
public class ProductRepository
{
private readonly string _connectionString;
public ProductRepository(string connectionString)
{
_connectionString = connectionString;
}
public int GetTotalProducts()
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT COUNT(*) FROM Products", connection);
connection.Open();
return (int)command.ExecuteScalar();
}
}
// Other methods...
}
}
3. OrderRepository.cs
using System.Data.SqlClient;
namespace ECommerceWebsite.Repositories
{
public class OrderRepository
{
private readonly string _connectionString;
public OrderRepository(string connectionString)
{
_connectionString = connectionString;
}
public int GetTotalOrders()
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT COUNT(*) FROM Orders", connection);
connection.Open();
return (int)command.ExecuteScalar();
}
}
public decimal GetTotalRevenue()
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT SUM(TotalAmount) FROM Orders", connection);
connection.Open();
var result = command.ExecuteScalar();
return result != DBNull.Value ? (decimal)result : 0;
}
}
// Other methods...
}
}
4. ReviewRepository.cs
using System.Data.SqlClient;
namespace ECommerceWebsite.Repositories
{
public class ReviewRepository
{
private readonly string _connectionString;
public ReviewRepository(string connectionString)
{
_connectionString = connectionString;
}
public int GetTotalReviews()
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT COUNT(*) FROM Reviews", connection);
connection.Open();
return (int)command.ExecuteScalar();
}
}
// Other methods...
}
}
5. CouponRepository.cs
using System.Data.SqlClient;
namespace ECommerceWebsite.Repositories
{
public class CouponRepository
{
private readonly string _connectionString;
public CouponRepository(string connectionString)
{
_connectionString = connectionString;
}
public int GetTotalCoupons()
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT COUNT(*) FROM Coupons", connection);
connection.Open();
return (int)command.ExecuteScalar();
}
}
// Other methods...
}
}
With these implementations, each repository now has a method to retrieve the total count of users, products, orders, reviews, and coupons from the database. The ExecuteScalar method is used to execute the SQL command and return a single value, which is the count of records in the respective table.
Make sure to handle exceptions and edge cases as needed in your production code, such as connection issues or invalid data.
AI 
ASP.NET API 
ASP.NET CLI 
ASP.NET Core 
ASP.NET MVC 
ASP.NET Projects With Source Code 
ASP.NET Web Forms 
ASP.NET Web Pages 
AWS 
Angular 10 
Bash 
Bitcoin 
Blockchain 
C Tutorial 
C# 
CPP 
Chat GPT 
Cheat Sheet 
Cyber Security 
Dart 
Django 
Docker 
Ether.js 
Ethereum 
Flask 
Flask Projects With Source Code 
GEN AI 
Git 
Go Language 
Google Cloud Platform 
GraphQL 
Hardhat 
INI 
JSON 
Java 
JavaScript 
Kotlin 
Kubernetes 
LaTeX 
Laravel 
Laravel 10 E-Commerce Project 
Laravel 11 E-Commerce Project 
Laravel 9 E-Commerce Project 
Laravel 9 React Tutorial 
Laravel E-Commerce Project 
Laravel Home Services Project 
Laravel Projects With Source Code 
Laravel Tutorial Advanced 
Laravel Tutorial Beginners 
Livewire 
Markdown 
Matlab 
Metamask 
Microsoft Azure 
MongoDB Tutorial Advanced 
MongoDB Tutorial Beginners 
MySql Tutorial Advanced 
MySql Tutorial Beginners 
NextJS 
Node JS 
Node JS Projects With Source Code 
PHP Projects With Source Code 
PHP Tutorial Advanced 
PHP Tutorial Beginners 
Project Database Schema 
Python 
React JS 
Ruby 
Rust 
SQL Server Queries 
SQL Server Tutorial Advanced 
SQL Server Tutorial Beginners 
Sass 
Solidity 
Spring Boot 
Truffle 
TypeScript 
VueJS 
Web3.js 
WordPress Tutorial Advanced 
WordPress Tutorial Beginners 
YAML