[V0_FILE]csharp:file="Models/User.cs" type="code" isMerged="true" using System.ComponentModel.DataAnnotations; namespace EcommerceMVC.Models { public class User { public int Id { get; set; } [Required] [EmailAddress] public string Email { get; set; } [Required] public string Password { get; set; } [Required] public string FirstName { get; set; } [Required] public string LastName { get; set; } public string Role { get; set; } = "Customer"; public DateTime CreatedAt { get; set; } = DateTime.Now; public bool IsActive { get; set; } = true; } public class LoginViewModel { [Required] [EmailAddress] public string Email { get; set; } [Required] [DataType(DataType.Password)] public string Password { get; set; } public bool RememberMe { get; set; } } public class RegisterViewModel { [Required] [EmailAddress] public string Email { get; set; } [Required] [StringLength(100, MinimumLength = 6)] [DataType(DataType.Password)] public string Password { get; set; } [DataType(DataType.Password)] [Compare("Password")] public string ConfirmPassword { get; set; } [Required] public string FirstName { get; set; } [Required] public string LastName { get; set; } } } [V0_FILE]csharp:file="Models/Product.cs" type="code" isMerged="true" namespace EcommerceMVC.Models { public class Product { public int Id { get; set; } public string Name { get; set; } public string Description { get; set; } public decimal Price { get; set; } public string ImageUrl { get; set; } public int CategoryId { get; set; } public string CategoryName { get; set; } public int Stock { get; set; } public bool IsActive { get; set; } = true; public DateTime CreatedAt { get; set; } = DateTime.Now; } public class Category { public int Id { get; set; } public string Name { get; set; } public string Description { get; set; } public bool IsActive { get; set; } = true; } public class Banner { public int Id { get; set; } public string Title { get; set; } public string Description { get; set; } public string ImageUrl { get; set; } public string LinkUrl { get; set; } public int Order { get; set; } public bool IsActive { get; set; } = true; } } [V0_FILE]csharp:file="Services/IUserService.cs" type="code" isMerged="true" using EcommerceMVC.Models; namespace EcommerceMVC.Services { public interface IUserService { Task AuthenticateAsync(string email, string password); Task RegisterAsync(RegisterViewModel model); Task GetByIdAsync(int id); Task GetByEmailAsync(string email); Task EmailExistsAsync(string email); } } [V0_FILE]csharp:file="Services/UserService.cs" type="code" isMerged="true" using Dapper; using EcommerceMVC.Models; using EcommerceMVC.Services; using System.Data; using System.Data.SqlClient; using System.Security.Cryptography; using System.Text; namespace EcommerceMVC.Services { public class UserService : IUserService { private readonly string _connectionString; public UserService(IConfiguration configuration) { _connectionString = configuration.GetConnectionString("DefaultConnection"); } public async Task AuthenticateAsync(string email, string password) { using var connection = new SqlConnection(_connectionString); var hashedPassword = HashPassword(password); var parameters = new DynamicParameters(); parameters.Add("@Email", email); parameters.Add("@Password", hashedPassword); var user = await connection.QueryFirstOrDefaultAsync( "sp_AuthenticateUser", parameters, commandType: CommandType.StoredProcedure); return user; } public async Task RegisterAsync(RegisterViewModel model) { using var connection = new SqlConnection(_connectionString); var hashedPassword = HashPassword(model.Password); var parameters = new DynamicParameters(); parameters.Add("@Email", model.Email); parameters.Add("@Password", hashedPassword); parameters.Add("@FirstName", model.FirstName); parameters.Add("@LastName", model.LastName); parameters.Add("@UserId", dbType: DbType.Int32, direction: ParameterDirection.Output); await connection.ExecuteAsync( "sp_RegisterUser", parameters, commandType: CommandType.StoredProcedure); var userId = parameters.Get("@UserId"); return await GetByIdAsync(userId); } public async Task GetByIdAsync(int id) { using var connection = new SqlConnection(_connectionString); var parameters = new DynamicParameters(); parameters.Add("@Id", id); return await connection.QueryFirstOrDefaultAsync( "sp_GetUserById", parameters, commandType: CommandType.StoredProcedure); } public async Task GetByEmailAsync(string email) { using var connection = new SqlConnection(_connectionString); var parameters = new DynamicParameters(); parameters.Add("@Email", email); return await connection.QueryFirstOrDefaultAsync( "sp_GetUserByEmail", parameters, commandType: CommandType.StoredProcedure); } public async Task EmailExistsAsync(string email) { using var connection = new SqlConnection(_connectionString); var parameters = new DynamicParameters(); parameters.Add("@Email", email); parameters.Add("@Exists", dbType: DbType.Boolean, direction: ParameterDirection.Output); await connection.ExecuteAsync( "sp_CheckEmailExists", parameters, commandType: CommandType.StoredProcedure); return parameters.Get("@Exists"); } private string HashPassword(string password) { using var sha256 = SHA256.Create(); var hashedBytes = sha256.ComputeHash(Encoding.UTF8.GetBytes(password)); return Convert.ToBase64String(hashedBytes); } } } [V0_FILE]csharp:file="Controllers/AccountController.cs" type="code" isMerged="true" using EcommerceMVC.Models; using EcommerceMVC.Services; using Microsoft.AspNetCore.Authentication; using Microsoft.AspNetCore.Authentication.Cookies; using Microsoft.AspNetCore.Mvc; using System.Security.Claims; namespace EcommerceMVC.Controllers { public class AccountController : Controller { private readonly IUserService _userService; public AccountController(IUserService userService) { _userService = userService; } [HttpGet] public IActionResult Login() { return View(); } [HttpPost] public async Task Login(LoginViewModel model) { if (ModelState.IsValid) { var user = await _userService.AuthenticateAsync(model.Email, model.Password); if (user != null) { var claims = new List { new Claim(ClaimTypes.Name, user.Email), new Claim(ClaimTypes.NameIdentifier, user.Id.ToString()), new Claim(ClaimTypes.Role, user.Role), new Claim("FirstName", user.FirstName), new Claim("LastName", user.LastName) }; var claimsIdentity = new ClaimsIdentity(claims, CookieAuthenticationDefaults.AuthenticationScheme); var authProperties = new AuthenticationProperties { IsPersistent = model.RememberMe }; await HttpContext.SignInAsync(CookieAuthenticationDefaults.AuthenticationScheme, new ClaimsPrincipal(claimsIdentity), authProperties); if (user.Role == "Admin") return RedirectToAction("Index", "Dashboard"); else return RedirectToAction("Index", "Home"); } ModelState.AddModelError("", "Invalid email or password."); } return View(model); } [HttpGet] public IActionResult Register() { return View(); } [HttpPost] public async Task Register(RegisterViewModel model) { if (ModelState.IsValid) { if (await _userService.EmailExistsAsync(model.Email)) { ModelState.AddModelError("Email", "Email already exists."); return View(model); } var user = await _userService.RegisterAsync(model); if (user != null) { TempData["Success"] = "Registration successful! Please login."; return RedirectToAction("Login"); } ModelState.AddModelError("", "Registration failed. Please try again."); } return View(model); } public async Task Logout() { await HttpContext.SignOutAsync(CookieAuthenticationDefaults.AuthenticationScheme); return RedirectToAction("Index", "Home"); } } } [V0_FILE]html:file="Views/Shared/_DashboardLayout.cshtml" type="code" isMerged="true" @ViewData["Title"] - Admin Dashboard

@RenderBody()

@await RenderSectionAsync("Scripts", required: false) [V0_FILE]html:file="Views/Home/Index.cshtml" type="code" isMerged="true" @model IEnumerable @{ ViewData["Title"] = "Home Page"; var banners = ViewBag.Banners as IEnumerable; var categories = ViewBag.Categories as IEnumerable; }

@if (banners != null) { @for (int i = 0; i < banners.Count(); i++) { } }

@if (banners != null && banners.Any()) { @foreach (var banner in banners.Select((b, index) => new { Banner = b, Index = index })) { } } else {

Welcome to Our Store

Discover amazing products at great prices

Shop Now

}

Shop by Category

@if (categories != null && categories.Any()) { @foreach (var category in categories.Take(4)) {

@category.Name

@category.Description

View Products

} }

Featured Products

@if (Model != null && Model.Any()) { @foreach (var product in Model.Take(8)) {

@product.Name

@product.Description

$@product.Price.ToString("F2") Stock: @product.Stock

View

} } else {

No products available at the moment.

}

View All Products

[V0_FILE]html:file="Views/Account/Login.cshtml" type="code" isMerged="true" @model EcommerceMVC.Models.LoginViewModel @{ ViewData["Title"] = "Login"; Layout = "~/Views/Shared/_Layout.cshtml"; }

Login

@if (TempData["Success"] != null) {

@TempData["Success"]

}

Don't have an account? Register here

@section Scripts { @{await Html.RenderPartialAsync("_ValidationScriptsPartial");} } [V0_FILE]html:file="Views/Account/Register.cshtml" type="code" isMerged="true" @model EcommerceMVC.Models.RegisterViewModel @{ ViewData["Title"] = "Register"; Layout = "~/Views/Shared/_Layout.cshtml"; }

Register

First Name

Last Name

Password

Confirm Password

Already have an account? Login here

@section Scripts { @{await Html.RenderPartialAsync("_ValidationScriptsPartial");} } [V0_FILE]html:file="Views/Dashboard/Index.cshtml" type="code" isMerged="true" @{ ViewData["Title"] = "Dashboard"; Layout = "~/Views/Shared/_DashboardLayout.cshtml"; }

Dashboard

Total Products

@ViewBag.ProductCount

Sales Overview

Revenue Sources

Recent Activity

Activity	User	Date	Status
New product added	Admin	@DateTime.Now.ToString("MM/dd/yyyy")	Completed
User registration	John Doe	@DateTime.Now.AddDays(-1).ToString("MM/dd/yyyy")	Active

[V0_FILE]sql:file="scripts/create-database.sql" type="code" isMerged="true" -- Create Database CREATE DATABASE EcommerceDB; GO USE EcommerceDB; GO -- Create Users Table CREATE TABLE Users ( Id INT IDENTITY(1,1) PRIMARY KEY, Email NVARCHAR(255) NOT NULL UNIQUE, Password NVARCHAR(255) NOT NULL, FirstName NVARCHAR(100) NOT NULL, LastName NVARCHAR(100) NOT NULL, Role NVARCHAR(50) DEFAULT 'Customer', CreatedAt DATETIME2 DEFAULT GETDATE(), IsActive BIT DEFAULT 1 ); -- Create Categories Table CREATE TABLE Categories ( Id INT IDENTITY(1,1) PRIMARY KEY, Name NVARCHAR(100) NOT NULL, Description NVARCHAR(500), IsActive BIT DEFAULT 1 ); -- Create Products Table CREATE TABLE Products ( Id INT IDENTITY(1,1) PRIMARY KEY, Name NVARCHAR(200) NOT NULL, Description NVARCHAR(1000), Price DECIMAL(10,2) NOT NULL, ImageUrl NVARCHAR(500), CategoryId INT NOT NULL, Stock INT DEFAULT 0, IsActive BIT DEFAULT 1, CreatedAt DATETIME2 DEFAULT GETDATE(), FOREIGN KEY (CategoryId) REFERENCES Categories(Id) ); -- Create Banners Table CREATE TABLE Banners ( Id INT IDENTITY(1,1) PRIMARY KEY, Title NVARCHAR(200) NOT NULL, Description NVARCHAR(500), ImageUrl NVARCHAR(500) NOT NULL, LinkUrl NVARCHAR(500), [Order] INT DEFAULT 0, IsActive BIT DEFAULT 1 ); -- Insert sample admin user (password: admin123) INSERT INTO Users (Email, Password, FirstName, LastName, Role) VALUES ('admin@example.com', 'jGl25bVBBBW96Qi9Te4V37Fnqchz/Eu4qB9vKrRIqRg=', 'Admin', 'User', 'Admin'); -- Insert sample categories INSERT INTO Categories (Name, Description) VALUES ('Electronics', 'Electronic devices and gadgets'), ('Clothing', 'Fashion and apparel'), ('Books', 'Books and literature'), ('Home & Garden', 'Home improvement and gardening'); -- Insert sample products INSERT INTO Products (Name, Description, Price, CategoryId, Stock) VALUES ('Smartphone', 'Latest smartphone with advanced features', 699.99, 1, 50), ('Laptop', 'High-performance laptop for work and gaming', 1299.99, 1, 25), ('T-Shirt', 'Comfortable cotton t-shirt', 19.99, 2, 100), ('Jeans', 'Classic blue jeans', 49.99, 2, 75), ('Programming Book', 'Learn programming fundamentals', 39.99, 3, 30); -- Insert sample banners INSERT INTO Banners (Title, Description, ImageUrl, LinkUrl, [Order]) VALUES ('Summer Sale', 'Up to 50% off on selected items', '/placeholder.svg?height=400&width=1200', '/Home/Products', 1), ('New Arrivals', 'Check out our latest products', '/placeholder.svg?height=400&width=1200', '/Home/Products', 2), ('Free Shipping', 'Free shipping on orders over $100', '/placeholder.svg?height=400&width=1200', '/Home/Products', 3); [V0_FILE]sql:file="scripts/stored-procedures.sql" type="code" isMerged="true" USE EcommerceDB; GO -- Stored Procedure: Authenticate User CREATE PROCEDURE sp_AuthenticateUser @Email NVARCHAR(255), @Password NVARCHAR(255) AS BEGIN SELECT Id, Email, FirstName, LastName, Role, CreatedAt, IsActive FROM Users WHERE Email = @Email AND Password = @Password AND IsActive = 1; END GO -- Stored Procedure: Register User CREATE PROCEDURE sp_RegisterUser @Email NVARCHAR(255), @Password NVARCHAR(255), @FirstName NVARCHAR(100), @LastName NVARCHAR(100), @UserId INT OUTPUT AS BEGIN INSERT INTO Users (Email, Password, FirstName, LastName) VALUES (@Email, @Password, @FirstName, @LastName); SET @UserId = SCOPE_IDENTITY(); END GO -- Stored Procedure: Get User By ID CREATE PROCEDURE sp_GetUserById @Id INT AS BEGIN SELECT Id, Email, FirstName, LastName, Role, CreatedAt, IsActive FROM Users WHERE Id = @Id; END GO -- Stored Procedure: Get User By Email CREATE PROCEDURE sp_GetUserByEmail @Email NVARCHAR(255) AS BEGIN SELECT Id, Email, FirstName, LastName, Role, CreatedAt, IsActive FROM Users WHERE Email = @Email; END GO -- Stored Procedure: Check Email Exists CREATE PROCEDURE sp_CheckEmailExists @Email NVARCHAR(255), @Exists BIT OUTPUT AS BEGIN IF EXISTS (SELECT 1 FROM Users WHERE Email = @Email) SET @Exists = 1; ELSE SET @Exists = 0; END GO -- Stored Procedure: Get All Products CREATE PROCEDURE sp_GetAllProducts AS BEGIN SELECT p.Id, p.Name, p.Description, p.Price, p.ImageUrl, p.CategoryId, c.Name as CategoryName, p.Stock, p.IsActive, p.CreatedAt FROM Products p INNER JOIN Categories c ON p.CategoryId = c.Id WHERE p.IsActive = 1 ORDER BY p.CreatedAt DESC; END GO -- Stored Procedure: Get Products By Category CREATE PROCEDURE sp_GetProductsByCategory @CategoryId INT AS BEGIN SELECT p.Id, p.Name, p.Description, p.Price, p.ImageUrl, p.CategoryId, c.Name as CategoryName, p.Stock, p.IsActive, p.CreatedAt FROM Products p INNER JOIN Categories c ON p.CategoryId = c.Id WHERE p.CategoryId = @CategoryId AND p.IsActive = 1 ORDER BY p.CreatedAt DESC; END GO -- Stored Procedure: Get Product By ID CREATE PROCEDURE sp_GetProductById @Id INT AS BEGIN SELECT p.Id, p.Name, p.Description, p.Price, p.ImageUrl, p.CategoryId, c.Name as CategoryName, p.Stock, p.IsActive, p.CreatedAt FROM Products p INNER JOIN Categories c ON p.CategoryId = c.Id WHERE p.Id = @Id; END GO -- Stored Procedure: Get All Categories CREATE PROCEDURE sp_GetAllCategories AS BEGIN SELECT Id, Name, Description, IsActive FROM Categories WHERE IsActive = 1 ORDER BY Name; END GO -- Stored Procedure: Get Active Banners CREATE PROCEDURE sp_GetActiveBanners AS BEGIN SELECT Id, Title, Description, ImageUrl, LinkUrl, [Order], IsActive FROM Banners WHERE IsActive = 1 ORDER BY [Order]; END GO [V0_FILE]json:file="appsettings.json" type="code" isMerged="true" { "ConnectionStrings": { "DefaultConnection": "Server=(localdb)\\mssqllocaldb;Database=EcommerceDB;Trusted_Connection=true;MultipleActiveResultSets=true" }, "Logging": { "LogLevel": { "Default": "Information", "Microsoft.AspNetCore": "Warning" } }, "AllowedHosts": "*" } [V0_FILE]xml:file="EcommerceMVC.csproj" type="code" isMerged="true" net6.0 enable enable [V0_FILE]typescriptreact:file="Views/Shared/_Layout.cshtml" isEdit="true" isQuickEdit="true" isMerged="true" @ViewData["Title"] - Ecommerce Store

@RenderBody()

@await RenderSectionAsync("Scripts", required: false) [V0_FILE]html:file="Views/Home/About.cshtml" isMerged="true" @{ ViewData["Title"] = "About Us"; }

About Us

Learn more about our company, mission, and the team behind our success

Our Story

Founded in 2020, Ecommerce Store has grown from a small startup to one of the leading online retailers. We started with a simple mission: to provide high-quality products at affordable prices with exceptional customer service.

Today, we serve thousands of customers worldwide, offering a diverse range of products from electronics to fashion, books, and home essentials. Our commitment to quality and customer satisfaction remains at the heart of everything we do.

10K+

Happy Customers

5K+

Products

Our Mission, Vision & Values

Our Mission

To provide exceptional online shopping experiences by offering quality products, competitive prices, and outstanding customer service that exceeds expectations.

Our Vision

To become the world's most trusted and preferred online marketplace, connecting customers with the products they love while supporting businesses to grow.

Our Values

Integrity, customer focus, innovation, and sustainability guide everything we do. We believe in building long-term relationships based on trust and mutual respect.

Meet Our Team

John Smith

Chief Executive Officer

Leading the company with 15+ years of experience in e-commerce and retail.

Sarah Johnson

Chief Technology Officer

Driving innovation and technology excellence with expertise in software development.

Michael Brown

Chief Marketing Officer

Building brand awareness and customer relationships through strategic marketing.

Emily Davis

Chief Operations Officer

Ensuring smooth operations and exceptional customer service delivery.

Why Choose Us?

Fast & Free Shipping

Free shipping on orders over $50. Express delivery available for urgent orders.

Secure Shopping

Your personal and payment information is protected with industry-standard security.

Easy Returns

30-day return policy. If you're not satisfied, we'll make it right.

24/7 Support

Our customer service team is available around the clock to help you.

Ready to Start Shopping?

Join thousands of satisfied customers and discover amazing products at great prices.

Shop Now

[V0_FILE]html:file="Views/Home/Contact.cshtml" isMerged="true" @{ ViewData["Title"] = "Contact Us"; }

Contact Us

We'd love to hear from you. Get in touch with us!

Send us a Message

First Name *

Last Name *

Email Address *

Phone Number

Subject *

Message *

Subscribe to our newsletter for updates and special offers

Contact Information

Address

123 Business Street, Suite 100
New York, NY 10001
United States

Phone

+1 (234) 567-8900
Mon-Fri: 9:00 AM - 6:00 PM

Email

info@ecommercestore.com
support@ecommercestore.com

Business Hours

Monday - Friday: 9:00 AM - 6:00 PM
Saturday: 10:00 AM - 4:00 PM
Sunday: Closed

Quick Links

Stay connected with us on social media

Find Us

Frequently Asked Questions

You can track your order by logging into your account and visiting the "My Orders" section. You'll receive a tracking number via email once your order ships.

We offer free standard shipping on orders over $50. Express shipping is available for $9.99, and overnight shipping for $19.99. International shipping is also available.

We offer a 30-day return policy for most items. Items must be in original condition with tags attached. Some restrictions apply to certain product categories.

@section Scripts { } [V0_FILE]csharp:file="Models/ContactFormModel.cs" type="code" isMerged="true" using System.ComponentModel.DataAnnotations; namespace EcommerceMVC.Models { public class ContactFormModel { [Required] [Display(Name = "First Name")] public string FirstName { get; set; } [Required] [Display(Name = "Last Name")] public string LastName { get; set; } [Required] [EmailAddress] [Display(Name = "Email Address")] public string Email { get; set; } [Phone] [Display(Name = "Phone Number")] public string Phone { get; set; } [Required] public string Subject { get; set; } [Required] [StringLength(1000, MinimumLength = 10)] public string Message { get; set; } [Display(Name = "Subscribe to Newsletter")] public bool Newsletter { get; set; } } } [V0_FILE]css:file="wwwroot/css/site.css" type="code" isMerged="true" /* Custom styles for the ecommerce site */ /* Footer Styles */ footer { margin-top: auto; } footer a:hover { color: #fff !important; transition: color 0.3s ease; } /* Social Media Icons */ .social-links a { display: inline-block; width: 35px; height: 35px; line-height: 35px; text-align: center; border-radius: 50%; margin: 0 5px; transition: all 0.3s ease; } .social-links a:hover { transform: translateY(-3px); box-shadow: 0 5px 15px rgba(0, 0, 0, 0.3); } /* Card Hover Effects */ .card { transition: transform 0.3s ease, box-shadow 0.3s ease; } .card:hover { transform: translateY(-5px); box-shadow: 0 10px 25px rgba(0, 0, 0, 0.15); } /* Button Hover Effects */ .btn { transition: all 0.3s ease; } .btn:hover { transform: translateY(-2px); box-shadow: 0 5px 15px rgba(0, 0, 0, 0.2); } /* Newsletter Input */ .input-group .form-control:focus { border-color: #007bff; box-shadow: 0 0 0 0.2rem rgba(0, 123, 255, 0.25); } /* Responsive Design */ @media (max-width: 768px) { .display-4 { font-size: 2rem; } .lead { font-size: 1.1rem; } .card-body { padding: 1rem; } } /* Contact Form Styles */ .form-control:focus { border-color: #007bff; box-shadow: 0 0 0 0.2rem rgba(0, 123, 255, 0.25); } .form-select:focus { border-color: #007bff; box-shadow: 0 0 0 0.2rem rgba(0, 123, 255, 0.25); } /* Map Container */ .ratio { position: relative; } .ratio iframe { position: absolute; top: 0; left: 0; width: 100%; height: 100%; } /* Accordion Styles */ .accordion-button:not(.collapsed) { background-color: #e7f3ff; color: #0c63e4; } .accordion-button:focus { box-shadow: 0 0 0 0.25rem rgba(13, 110, 253, 0.25); } /* Team Member Cards */ .team-member-card { transition: all 0.3s ease; } .team-member-card:hover { transform: translateY(-10px); } /* Stats Cards */ .stats-card { background: linear-gradient(135deg, #667eea 0%, #764ba2 100%); color: white; border-radius: 15px; padding: 2rem; text-align: center; margin-bottom: 2rem; } .stats-card h3 { font-size: 3rem; font-weight: bold; margin-bottom: 0.5rem; } /* Loading Animation */ .loading { display: inline-block; width: 20px; height: 20px; border: 3px solid rgba(255, 255, 255, 0.3); border-radius: 50%; border-top-color: #fff; animation: spin 1s ease-in-out infinite; } @keyframes spin { to { transform: rotate(360deg); } } /* Custom Scrollbar */ ::-webkit-scrollbar { width: 8px; } ::-webkit-scrollbar-track { background: #f1f1f1; } ::-webkit-scrollbar-thumb { background: #888; border-radius: 4px; } ::-webkit-scrollbar-thumb:hover { background: #555; } /* Utility Classes */ .text-shadow { text-shadow: 2px 2px 4px rgba(0, 0, 0, 0.5); } .bg-gradient-primary { background: linear-gradient(135deg, #007bff 0%, #0056b3 100%); } .bg-gradient-success { background: linear-gradient(135deg, #28a745 0%, #1e7e34 100%); } .bg-gradient-info { background: linear-gradient(135deg, #17a2b8 0%, #117a8b 100%); } .bg-gradient-warning { background: linear-gradient(135deg, #ffc107 0%, #d39e00 100%); } .bg-gradient-danger { background: linear-gradient(135deg, #dc3545 0%, #bd2130 100%); } [V0_FILE]typescriptreact:file="Controllers/HomeController.cs" isEdit="true" isQuickEdit="true" isMerged="true" using EcommerceMVC.Models; using EcommerceMVC.Services; using Microsoft.AspNetCore.Mvc; namespace EcommerceMVC.Controllers { public class HomeController : Controller { private readonly IProductService _productService; public HomeController(IProductService productService) { _productService = productService; } public async Task Index() { var banners = await _productService.GetActiveBannersAsync(); var products = await _productService.GetAllProductsAsync(); var categories = await _productService.GetAllCategoriesAsync(); ViewBag.Banners = banners; ViewBag.Categories = categories; return View(products); } public async Task Products(int? categoryId) { var products = categoryId.HasValue ? await _productService.GetProductsByCategoryAsync(categoryId.Value) : await _productService.GetAllProductsAsync(); var categories = await _productService.GetAllCategoriesAsync(); ViewBag.Categories = categories; ViewBag.SelectedCategory = categoryId; return View(products); } public IActionResult About() { return View(); } public IActionResult Contact() { return View(); } [HttpPost] public IActionResult Contact(ContactFormModel model) { if (ModelState.IsValid) { // Here you would typically send an email or save to database TempData["Success"] = "Thank you for your message! We will get back to you within 24 hours."; return RedirectToAction("Contact"); } return View(model); } } } [V0_FILE]csharp:file="Models/ProductViewModels.cs" type="code" isMerged="true" using System.ComponentModel.DataAnnotations; namespace EcommerceMVC.Models { public class ProductListViewModel { public IEnumerable Products { get; set; } = new List(); public IEnumerable Categories { get; set; } = new List(); public int? CurrentCategory { get; set; } public string SearchTerm { get; set; } = ""; public string SortBy { get; set; } = "name"; public int CurrentPage { get; set; } = 1; public int TotalPages { get; set; } = 1; public int PageSize { get; set; } = 12; public int TotalProducts { get; set; } = 0; } public class CreateProductViewModel { [Required] [StringLength(200)] public string Name { get; set; } [StringLength(1000)] public string Description { get; set; } [Required] [Range(0.01, double.MaxValue, ErrorMessage = "Price must be greater than 0")] public decimal Price { get; set; } [Required] [Display(Name = "Category")] public int CategoryId { get; set; } [Required] [Range(0, int.MaxValue, ErrorMessage = "Stock must be 0 or greater")] public int Stock { get; set; } [Display(Name = "Image URL")] [StringLength(500)] public string ImageUrl { get; set; } [Display(Name = "Active")] public bool IsActive { get; set; } = true; } public class EditProductViewModel { public int Id { get; set; } [Required] [StringLength(200)] public string Name { get; set; } [StringLength(1000)] public string Description { get; set; } [Required] [Range(0.01, double.MaxValue, ErrorMessage = "Price must be greater than 0")] public decimal Price { get; set; } [Required] [Display(Name = "Category")] public int CategoryId { get; set; } [Required] [Range(0, int.MaxValue, ErrorMessage = "Stock must be 0 or greater")] public int Stock { get; set; } [Display(Name = "Image URL")] [StringLength(500)] public string ImageUrl { get; set; } [Display(Name = "Active")] public bool IsActive { get; set; } } public class CreateCategoryViewModel { [Required] [StringLength(100)] public string Name { get; set; } [StringLength(500)] public string Description { get; set; } [Display(Name = "Active")] public bool IsActive { get; set; } = true; } public class EditCategoryViewModel { public int Id { get; set; } [Required] [StringLength(100)] public string Name { get; set; } [StringLength(500)] public string Description { get; set; } [Display(Name = "Active")] public bool IsActive { get; set; } } public class AdminProductListViewModel { public IEnumerable Products { get; set; } = new List(); public int CurrentPage { get; set; } = 1; public int TotalPages { get; set; } = 1; public int PageSize { get; set; } = 10; public string SearchTerm { get; set; } = ""; public int TotalProducts { get; set; } = 0; } public class AdminOrderListViewModel { public IEnumerable Orders { get; set; } = new List(); public int CurrentPage { get; set; } = 1; public int TotalPages { get; set; } = 1; public int PageSize { get; set; } = 10; public int TotalOrders { get; set; } = 0; } public class AdminUserListViewModel { public IEnumerable Users { get; set; } = new List(); public int CurrentPage { get; set; } = 1; public int TotalPages { get; set; } = 1; public int PageSize { get; set; } = 10; public int TotalUsers { get; set; } = 0; } public class DashboardViewModel { public int TotalProducts { get; set; } public int TotalCategories { get; set; } public int TotalOrders { get; set; } public int TotalUsers { get; set; } public decimal TotalRevenue { get; set; } public int LowStockProducts { get; set; } public IEnumerable RecentProducts { get; set; } = new List(); public IEnumerable RecentOrders { get; set; } = new List(); public Dictionary MonthlySales { get; set; } = new Dictionary(); public Dictionary CategoryRevenue { get; set; } = new Dictionary(); } public class ReportsViewModel { public Dictionary SalesReport { get; set; } = new Dictionary(); public Dictionary RevenueReport { get; set; } = new Dictionary(); public IEnumerable TopSellingProducts { get; set; } = new List(); public IEnumerable TopCategories { get; set; } = new List(); } public class AnalyticsViewModel { public int TotalVisitors { get; set; } public int TotalPageViews { get; set; } public decimal ConversionRate { get; set; } public decimal AverageOrderValue { get; set; } public Dictionary TrafficSources { get; set; } = new Dictionary(); public Dictionary PopularPages { get; set; } = new Dictionary(); } public class ServiceResult { public bool Success { get; set; } public string Message { get; set; } = ""; public object Data { get; set; } } } [V0_FILE]csharp:file="Models/Order.cs" type="code" isMerged="true" namespace EcommerceMVC.Models { public class Order { public int Id { get; set; } public int UserId { get; set; } public string UserName { get; set; } public string UserEmail { get; set; } public decimal TotalAmount { get; set; } public string Status { get; set; } = "Pending"; public DateTime OrderDate { get; set; } = DateTime.Now; public string ShippingAddress { get; set; } public string PaymentMethod { get; set; } public string TrackingNumber { get; set; } public List OrderItems { get; set; } = new List(); } public class OrderItem { public int Id { get; set; } public int OrderId { get; set; } public int ProductId { get; set; } public string ProductName { get; set; } public decimal Price { get; set; } public int Quantity { get; set; } public decimal Total => Price * Quantity; } } [V0_FILE]typescriptreact:file="Program.cs" isEdit="true" isQuickEdit="true" isMerged="true" using EcommerceMVC.Services; using Microsoft.AspNetCore.Authentication.Cookies; var builder = WebApplication.CreateBuilder(args); // Add services to the container. builder.Services.AddControllersWithViews(); // Add authentication builder.Services.AddAuthentication(CookieAuthenticationDefaults.AuthenticationScheme) .AddCookie(options => { options.LoginPath = "/Account/Login"; options.LogoutPath = "/Account/Logout"; options.AccessDeniedPath = "/Account/AccessDenied"; options.ExpireTimeSpan = TimeSpan.FromHours(24); }); // Register services builder.Services.AddScoped(); builder.Services.AddScoped(); builder.Services.AddScoped(); var app = builder.Build(); // Configure the HTTP request pipeline. if (!app.Environment.IsDevelopment()) { app.UseExceptionHandler("/Home/Error"); app.UseHsts(); } app.UseHttpsRedirection(); app.UseStaticFiles(); app.UseRouting(); app.UseAuthentication(); app.UseAuthorization(); app.MapControllerRoute( name: "default", pattern: "{controller=Home}/{action=Index}/{id?}"); app.Run(); [V0_FILE]html:file="Views/Product/Index.cshtml" isMerged="true" @model EcommerceMVC.Models.ProductListViewModel @{ ViewData["Title"] = "Products"; }

@if (Model.CurrentCategory.HasValue) { @ViewBag.CategoryName } else { All Products }

Showing @Model.Products.Count() of @Model.TotalProducts products

Filters

Search Products

@product.Name

@product.Description

${@product.Price.ToString("F2")} Stock: @product.Stock

View Details @if (product.Stock > 0) { } else { }

}

@if (Model.TotalPages > 1) {

} } else {

No products found

Try adjusting your search criteria or browse different categories.

View All Products

}

@section Scripts { } [V0_FILE]html:file="Views/Product/Details.cshtml" isMerged="true" @model EcommerceMVC.Models.Product @{ ViewData["Title"] = Model.Name; var relatedProducts = ViewBag.RelatedProducts as IEnumerable; }

@Model.Name

@Model.CategoryName @if (Model.Stock <= 5 && Model.Stock > 0) { Low Stock } else if (Model.Stock == 0) { Out of Stock } else { In Stock }

${@Model.Price.ToString("F2")}

Stock: @Model.Stock units available

Description

@Model.Description

Product Description

@Model.Description

This is a high-quality product that meets all industry standards. Perfect for both personal and professional use.

Specifications

Category	@Model.CategoryName
Stock	@Model.Stock units
Price	${@Model.Price.ToString("F2")}
Availability	@(Model.Stock > 0 ? "In Stock" : "Out of Stock")

Customer Reviews

4.8 out of 5 (24 reviews)

John Doe 2 days ago

Excellent product! Highly recommended.

Shipping Information

Standard Shipping

Free shipping on orders over $50. Delivery in 5-7 business days.

Express Shipping

$9.99 for express delivery in 2-3 business days.

@if (relatedProducts != null && relatedProducts.Any()) {

Related Products

@foreach (var product in relatedProducts) {

@product.Name

@product.Description

${@product.Price.ToString("F2")} View

}

@section Scripts { } [V0_FILE]sql:file="scripts/additional-stored-procedures.sql" type="code" isMerged="true" USE EcommerceDB; GO -- Stored Procedure: Search Products CREATE PROCEDURE sp_SearchProducts @SearchTerm NVARCHAR(255), @CategoryId INT = NULL AS BEGIN SELECT p.Id, p.Name, p.Description, p.Price, p.ImageUrl, p.CategoryId, c.Name as CategoryName, p.Stock, p.IsActive, p.CreatedAt FROM Products p INNER JOIN Categories c ON p.CategoryId = c.Id WHERE p.IsActive = 1 AND (p.Name LIKE '%' + @SearchTerm + '%' OR p.Description LIKE '%' + @SearchTerm + '%') AND (@CategoryId IS NULL OR p.CategoryId = @CategoryId) ORDER BY p.CreatedAt DESC; END GO -- Stored Procedure: Get Category By ID CREATE PROCEDURE sp_GetCategoryById @Id INT AS BEGIN SELECT Id, Name, Description, IsActive FROM Categories WHERE Id = @Id; END GO -- Stored Procedure: Create Product CREATE PROCEDURE sp_CreateProduct @Name NVARCHAR(200), @Description NVARCHAR(1000), @Price DECIMAL(10,2), @CategoryId INT, @Stock INT, @ImageUrl NVARCHAR(500), @IsActive BIT, @ProductId INT OUTPUT AS BEGIN INSERT INTO Products (Name, Description, Price, CategoryId, Stock, ImageUrl, IsActive) VALUES (@Name, @Description, @Price, @CategoryId, @Stock, @ImageUrl, @IsActive); SET @ProductId = SCOPE_IDENTITY(); END GO -- Stored Procedure: Update Product CREATE PROCEDURE sp_UpdateProduct @Id INT, @Name NVARCHAR(200), @Description NVARCHAR(1000), @Price DECIMAL(10,2), @CategoryId INT, @Stock INT, @ImageUrl NVARCHAR(500), @IsActive BIT AS BEGIN UPDATE Products SET Name = @Name, Description = @Description, Price = @Price, CategoryId = @CategoryId, Stock = @Stock, ImageUrl = @ImageUrl, IsActive = @IsActive WHERE Id = @Id; END GO -- Stored Procedure: Delete Product CREATE PROCEDURE sp_DeleteProduct @Id INT AS BEGIN UPDATE Products SET IsActive = 0 WHERE Id = @Id; END GO -- Stored Procedure: Create Category CREATE PROCEDURE sp_CreateCategory @Name NVARCHAR(100), @Description NVARCHAR(500), @IsActive BIT, @CategoryId INT OUTPUT AS BEGIN INSERT INTO Categories (Name, Description, IsActive) VALUES (@Name, @Description, @IsActive); SET @CategoryId = SCOPE_IDENTITY(); END GO -- Stored Procedure: Update Category CREATE PROCEDURE sp_UpdateCategory @Id INT, @Name NVARCHAR(100), @Description NVARCHAR(500), @IsActive BIT AS BEGIN UPDATE Categories SET Name = @Name, Description = @Description, IsActive = @IsActive WHERE Id = @Id; END GO -- Stored Procedure: Delete Category CREATE PROCEDURE sp_DeleteCategory @Id INT AS BEGIN UPDATE Categories SET IsActive = 0 WHERE Id = @Id; END GO -- Stored Procedure: Toggle Product Status CREATE PROCEDURE sp_ToggleProductStatus @Id INT AS BEGIN UPDATE Products SET IsActive = CASE WHEN IsActive = 1 THEN 0 ELSE 1 END WHERE Id = @Id; END GO -- Stored Procedure: Bulk Delete Products CREATE PROCEDURE sp_BulkDeleteProducts @ProductIds NVARCHAR(MAX) AS BEGIN UPDATE Products SET IsActive = 0 WHERE Id IN (SELECT value FROM STRING_SPLIT(@ProductIds, ',')); END GO -- Stored Procedure: Get Dashboard Data CREATE PROCEDURE sp_GetDashboardData AS BEGIN SELECT (SELECT COUNT(*) FROM Products WHERE IsActive = 1) as TotalProducts, (SELECT COUNT(*) FROM Categories WHERE IsActive = 1) as TotalCategories, 0 as TotalOrders, -- Will be updated when Orders table is created (SELECT COUNT(*) FROM Users WHERE IsActive = 1) as TotalUsers, 0.00 as TotalRevenue, -- Will be updated when Orders table is created (SELECT COUNT(*) FROM Products WHERE Stock <= 5 AND IsActive = 1) as LowStockProducts; END GO -- Stored Procedure: Get Recent Products CREATE PROCEDURE sp_GetRecentProducts @Count INT = 5 AS BEGIN SELECT TOP (@Count) p.Id, p.Name, p.Description, p.Price, p.ImageUrl, p.CategoryId, c.Name as CategoryName, p.Stock, p.IsActive, p.CreatedAt FROM Products p INNER JOIN Categories c ON p.CategoryId = c.Id WHERE p.IsActive = 1 ORDER BY p.CreatedAt DESC; END GO -- Stored Procedure: Get All Users CREATE PROCEDURE sp_GetAllUsers AS BEGIN SELECT Id, Email, FirstName, LastName, Role, CreatedAt, IsActive FROM Users ORDER BY CreatedAt DESC; END GO [V0_FILE]html:file="Views/Dashboard/Products.cshtml" isMerged="true" @model EcommerceMVC.Models.AdminProductListViewModel @{ ViewData["Title"] = "Manage Products"; Layout = "~/Views/Shared/_DashboardLayout.cshtml"; }

Manage Products

Showing @Model.Products.Count() of @Model.TotalProducts products

@if (Model.Products.Any()) { @foreach (var product in Model.Products) { } } else { }

	Image	Name	Category	Price	Stock	Status	Created	Actions
		@product.Name @(product.Description?.Length > 50 ? product.Description.Substring(0, 50) + "..." : product.Description)	@product.CategoryName	${@product.Price.ToString("F2")}	@if (product.Stock <= 5 && product.Stock > 0) { @product.Stock } else if (product.Stock == 0) { @product.Stock } else { @product.Stock }	@(product.IsActive ? "Active" : "Inactive")	@product.CreatedAt.ToString("MM/dd/yyyy")	@Html.AntiForgeryToken()
No products found Start by adding your first product. Add Product

@if (Model.TotalPages > 1) {

} @section Scripts { } [V0_FILE]html:file="Views/Dashboard/CreateProduct.cshtml" isMerged="true" @model EcommerceMVC.Models.CreateProductViewModel @{ ViewData["Title"] = "Create Product"; Layout = "~/Views/Shared/_DashboardLayout.cshtml"; var categories = ViewBag.Categories as IEnumerable; }

Create New Product

Product Information

Product Name *

Category *

Description

Price *

Stock Quantity *

Image URL

Enter a valid image URL or leave blank for default placeholder.

Active (Product will be visible to customers)

Cancel

Tips

Product Images

Use high-quality images with good lighting. Recommended size: 800x800 pixels.

Product Description

Write clear, detailed descriptions that highlight key features and benefits.

Pricing

Research competitor prices and consider your costs when setting the price.

Preview

Product Name

Product description will appear here...

$0.00

@section Scripts { @{await Html.RenderPartialAsync("_ValidationScriptsPartial");} } [V0_FILE]typescriptreact:file="Controllers/ProductController.cs" isEdit="true" isQuickEdit="true" using EcommerceMVC.Models; using EcommerceMVC.Services; using Microsoft.AspNetCore.Mvc; using System.Collections.Generic; using System.Linq; using System.Threading.Tasks; namespace EcommerceMVC.Controllers { public class ProductController : Controller { private readonly IProductService _productService; public ProductController(IProductService productService) { _productService = productService; } // GET: Product public async Task Index(int? categoryId, string searchTerm, string sortBy = "name", int page = 1, int pageSize = 12) { var products = categoryId.HasValue ? await _productService.GetProductsByCategoryAsync(categoryId.Value) : await _productService.GetAllProductsAsync(); var categories = await _productService.GetAllCategoriesAsync(); // Apply search filter if (!string.IsNullOrEmpty(searchTerm)) { products = products.Where(p => p.Name.Contains(searchTerm, StringComparison.OrdinalIgnoreCase) || p.Description.Contains(searchTerm, StringComparison.OrdinalIgnoreCase)); } // Apply sorting products = sortBy.ToLower() switch { "price_asc" => products.OrderBy(p => p.Price), "price_desc" => products.OrderByDescending(p => p.Price), "name_desc" => products.OrderByDescending(p => p.Name), "newest" => products.OrderByDescending(p => p.CreatedAt), _ => products.OrderBy(p => p.Name) }; // Apply pagination var totalProducts = products.Count(); var totalPages = (int)Math.Ceiling(totalProducts / (double)pageSize); var paginatedProducts = products.Skip((page - 1) * pageSize).Take(pageSize); var viewModel = new ProductListViewModel { Products = paginatedProducts, Categories = categories, CurrentCategory = categoryId, SearchTerm = searchTerm, SortBy = sortBy, CurrentPage = page, TotalPages = totalPages, PageSize = pageSize, TotalProducts = totalProducts }; return View(viewModel); } // GET: Product/Details/5 public async Task Details(int id) { var product = await _productService.GetProductByIdAsync(id); if (product == null) { return NotFound(); } // Get related products from the same category var relatedProducts = await _productService.GetProductsByCategoryAsync(product.CategoryId); ViewBag.RelatedProducts = relatedProducts.Where(p => p.Id != id).Take(4); return View(product); } // GET: Product/Search public async Task Search(string q, int? categoryId) { if (string.IsNullOrEmpty(q)) { return RedirectToAction("Index"); } var products = await _productService.SearchProductsAsync(q, categoryId); var categories = await _productService.GetAllCategoriesAsync(); ViewBag.SearchTerm = q; ViewBag.Categories = categories; ViewBag.SelectedCategory = categoryId; return View("Index", new ProductListViewModel { Products = products, Categories = categories, SearchTerm = q, CurrentCategory = categoryId }); } // GET: Product/Category/5 public async Task Category(int id, int page = 1, int pageSize = 12) { var products = await _productService.GetProductsByCategoryAsync(id); var categories = await _productService.GetAllCategoriesAsync(); var currentCategory = categories.FirstOrDefault(c => c.Id == id); if (currentCategory == null) { return NotFound(); } // Apply pagination var totalProducts = products.Count(); var totalPages = (int)Math.Ceiling(totalProducts / (double)pageSize); var paginatedProducts = products.Skip((page - 1) * pageSize).Take(pageSize); var viewModel = new ProductListViewModel { Products = paginatedProducts, Categories = categories, CurrentCategory = id, CurrentPage = page, TotalPages = totalPages, PageSize = pageSize, TotalProducts = totalProducts }; ViewBag.CategoryName = currentCategory.Name; return View("Index", viewModel); } // POST: Product/AddToCart [HttpPost] public async Task AddToCart(int productId, int quantity = 1) { var product = await _productService.GetProductByIdAsync(productId); if (product == null) { return Json(new { success = false, message = "Product not found" }); } if (product.Stock < quantity) { return Json(new { success = false, message = "Insufficient stock" }); } // Here you would implement cart functionality // For now, we'll just return success return Json(new { success = true, message = "Product added to cart successfully" }); } // GET: Product/Compare public async Task Compare(string productIds) { if (string.IsNullOrEmpty(productIds)) { return RedirectToAction("Index"); } var ids = productIds.Split(',').Select(int.Parse).ToList(); var products = new List(); foreach (var id in ids) { var product = await _productService.GetProductByIdAsync(id); if (product != null) { products.Add(product); } } return View(products); } // GET: Product/Wishlist public IActionResult Wishlist() { // Get wishlist from session or user account return View(); } // POST: Product/AddToWishlist [HttpPost] public IActionResult AddToWishlist(int productId) { // Add to wishlist logic return Json(new { success = true, message = "Product added to wishlist" }); } // GET: Product/QuickView public async Task QuickView(int id) { var product = await _productService.GetProductByIdAsync(id); if (product == null) { return NotFound(); } return PartialView("_QuickView", product); } } } [V0_FILE]typescriptreact:file="Controllers/DashboardController.cs" isEdit="true" isQuickEdit="true" using EcommerceMVC.Models; using EcommerceMVC.Services; using Microsoft.AspNetCore.Authorization; using Microsoft.AspNetCore.Mvc; namespace EcommerceMVC.Controllers { [Authorize(Roles = "Admin")] public class DashboardController : Controller { private readonly IProductService _productService; private readonly IUserService _userService; private readonly IDashboardService _dashboardService; public DashboardController(IProductService productService, IUserService userService, IDashboardService dashboardService) { _productService = productService; _userService = userService; _dashboardService = dashboardService; } // GET: Dashboard public async Task Index() { var dashboardData = await _dashboardService.GetDashboardDataAsync(); return View(dashboardData); } // GET: Dashboard/Products public async Task Products(int page = 1, int pageSize = 10, string searchTerm = "") { var products = await _productService.GetAllProductsAsync(); if (!string.IsNullOrEmpty(searchTerm)) { products = products.Where(p => p.Name.Contains(searchTerm, StringComparison.OrdinalIgnoreCase)); } var totalProducts = products.Count(); var totalPages = (int)Math.Ceiling(totalProducts / (double)pageSize); var paginatedProducts = products.Skip((page - 1) * pageSize).Take(pageSize); var viewModel = new AdminProductListViewModel { Products = paginatedProducts, CurrentPage = page, TotalPages = totalPages, PageSize = pageSize, SearchTerm = searchTerm, TotalProducts = totalProducts }; return View(viewModel); } // GET: Dashboard/Products/Create public async Task CreateProduct() { var categories = await _productService.GetAllCategoriesAsync(); ViewBag.Categories = categories; return View(); } // POST: Dashboard/Products/Create [HttpPost] [ValidateAntiForgeryToken] public async Task CreateProduct(CreateProductViewModel model) { if (ModelState.IsValid) { var result = await _productService.CreateProductAsync(model); if (result.Success) { TempData["Success"] = "Product created successfully!"; return RedirectToAction("Products"); } ModelState.AddModelError("", result.Message); } var categories = await _productService.GetAllCategoriesAsync(); ViewBag.Categories = categories; return View(model); } // GET: Dashboard/Products/Edit/5 public async Task EditProduct(int id) { var product = await _productService.GetProductByIdAsync(id); if (product == null) { return NotFound(); } var categories = await _productService.GetAllCategoriesAsync(); ViewBag.Categories = categories; var viewModel = new EditProductViewModel { Id = product.Id, Name = product.Name, Description = product.Description, Price = product.Price, CategoryId = product.CategoryId, Stock = product.Stock, ImageUrl = product.ImageUrl, IsActive = product.IsActive }; return View(viewModel); } // POST: Dashboard/Products/Edit/5 [HttpPost] [ValidateAntiForgeryToken] public async Task EditProduct(int id, EditProductViewModel model) { if (id != model.Id) { return NotFound(); } if (ModelState.IsValid) { var result = await _productService.UpdateProductAsync(model); if (result.Success) { TempData["Success"] = "Product updated successfully!"; return RedirectToAction("Products"); } ModelState.AddModelError("", result.Message); } var categories = await _productService.GetAllCategoriesAsync(); ViewBag.Categories = categories; return View(model); } // POST: Dashboard/Products/Delete/5 [HttpPost] [ValidateAntiForgeryToken] public async Task DeleteProduct(int id) { var result = await _productService.DeleteProductAsync(id); if (result.Success) { TempData["Success"] = "Product deleted successfully!"; } else { TempData["Error"] = result.Message; } return RedirectToAction("Products"); } // GET: Dashboard/Categories public async Task Categories() { var categories = await _productService.GetAllCategoriesAsync(); return View(categories); } // GET: Dashboard/Categories/Create public IActionResult CreateCategory() { return View(); } // POST: Dashboard/Categories/Create [HttpPost] [ValidateAntiForgeryToken] public async Task CreateCategory(CreateCategoryViewModel model) { if (ModelState.IsValid) { var result = await _productService.CreateCategoryAsync(model); if (result.Success) { TempData["Success"] = "Category created successfully!"; return RedirectToAction("Categories"); } ModelState.AddModelError("", result.Message); } return View(model); } // GET: Dashboard/Categories/Edit/5 public async Task EditCategory(int id) { var category = await _productService.GetCategoryByIdAsync(id); if (category == null) { return NotFound(); } var viewModel = new EditCategoryViewModel { Id = category.Id, Name = category.Name, Description = category.Description, IsActive = category.IsActive }; return View(viewModel); } // POST: Dashboard/Categories/Edit/5 [HttpPost] [ValidateAntiForgeryToken] public async Task EditCategory(int id, EditCategoryViewModel model) { if (id != model.Id) { return NotFound(); } if (ModelState.IsValid) { var result = await _productService.UpdateCategoryAsync(model); if (result.Success) { TempData["Success"] = "Category updated successfully!"; return RedirectToAction("Categories"); } ModelState.AddModelError("", result.Message); } return View(model); } // POST: Dashboard/Categories/Delete/5 [HttpPost] [ValidateAntiForgeryToken] public async Task DeleteCategory(int id) { var result = await _productService.DeleteCategoryAsync(id); if (result.Success) { TempData["Success"] = "Category deleted successfully!"; } else { TempData["Error"] = result.Message; } return RedirectToAction("Categories"); } // GET: Dashboard/Orders public async Task Orders(int page = 1, int pageSize = 10) { var orders = await _dashboardService.GetOrdersAsync(); var totalOrders = orders.Count(); var totalPages = (int)Math.Ceiling(totalOrders / (double)pageSize); var paginatedOrders = orders.Skip((page - 1) * pageSize).Take(pageSize); var viewModel = new AdminOrderListViewModel { Orders = paginatedOrders, CurrentPage = page, TotalPages = totalPages, PageSize = pageSize, TotalOrders = totalOrders }; return View(viewModel); } // GET: Dashboard/Users public async Task Users(int page = 1, int pageSize = 10) { var users = await _dashboardService.GetUsersAsync(); var totalUsers = users.Count(); var totalPages = (int)Math.Ceiling(totalUsers / (double)pageSize); var paginatedUsers = users.Skip((page - 1) * pageSize).Take(pageSize); var viewModel = new AdminUserListViewModel { Users = paginatedUsers, CurrentPage = page, TotalPages = totalPages, PageSize = pageSize, TotalUsers = totalUsers }; return View(viewModel); } // GET: Dashboard/Reports public async Task Reports() { var reportData = await _dashboardService.GetReportsDataAsync(); return View(reportData); } // GET: Dashboard/Settings public IActionResult Settings() { return View(); } // POST: Dashboard/ToggleProductStatus [HttpPost] public async Task ToggleProductStatus(int id) { var result = await _productService.ToggleProductStatusAsync(id); return Json(new { success = result.Success, message = result.Message }); } // POST: Dashboard/BulkDeleteProducts [HttpPost] public async Task BulkDeleteProducts(int[] productIds) { if (productIds == null || productIds.Length == 0) { return Json(new { success = false, message = "No products selected" }); } var result = await _productService.BulkDeleteProductsAsync(productIds); return Json(new { success = result.Success, message = result.Message }); } // GET: Dashboard/Analytics public async Task Analytics() { var analyticsData = await _dashboardService.GetAnalyticsDataAsync(); return View(analyticsData); } // GET: Dashboard/ProductStock public async Task ProductStock() { var products = await _productService.GetAllProductsAsync(); var lowStockProducts = products.Where(p => p.Stock <= 5).OrderBy(p => p.Stock); return View(lowStockProducts); } // POST: Dashboard/UpdateStock [HttpPost] public async Task UpdateStock(int productId, int newStock) { var result = await _productService.UpdateProductStockAsync(productId, newStock); return Json(new { success = result.Success, message = result.Message }); } // GET: Dashboard/SalesReport public async Task SalesReport(DateTime? startDate, DateTime? endDate) { var reportData = await _dashboardService.GetSalesReportAsync(startDate, endDate); return View(reportData); } // POST: Dashboard/ExportProducts [HttpPost] public async Task ExportProducts() { var products = await _productService.GetAllProductsAsync(); // Export logic would go here return Json(new { success = true, message = "Products exported successfully" }); } // GET: Dashboard/BulkEdit public async Task BulkEdit(int[] productIds) { if (productIds == null || productIds.Length == 0) { TempData["Error"] = "No products selected for bulk edit."; return RedirectToAction("Products"); } var products = new List(); foreach (var id in productIds) { var product = await _productService.GetProductByIdAsync(id); if (product != null) products.Add(product); } return View(products); } } } [V0_FILE]html:file="Views/Product/Compare.cshtml" @model IEnumerable @{ ViewData["Title"] = "Compare Products"; }

Compare Products

Compare features and specifications side by side

@if (Model != null && Model.Any()) {

@foreach (var product in Model) { } @foreach (var product in Model) { } @foreach (var product in Model) { } @foreach (var product in Model) { } @foreach (var product in Model) { } @foreach (var product in Model) { }

Feature	@product.Name
Price	${@product.Price.ToString("F2")}
Category	@product.CategoryName
Stock	@if (product.Stock > 10) { @product.Stock } else if (product.Stock > 0) { @product.Stock } else { Out of Stock }
Description	@product.Description
Actions	View Details @if (product.Stock > 0) { } else { }

} else {

No products to compare

Select products from the product listing to compare them.

Browse Products

}

@section Scripts { } [V0_FILE]html:file="Views/Product/_QuickView.cshtml" @model EcommerceMVC.Models.Product [V0_FILE]html:file="Views/Dashboard/ProductStock.cshtml" @model IEnumerable @{ ViewData["Title"] = "Stock Management"; Layout = "~/Views/Shared/_DashboardLayout.cshtml"; }

Stock Management

@Model.Count(p => p.Stock == 0)

Out of Stock

@Model.Count(p => p.Stock > 0 && p.Stock <= 5)

Low Stock

@Model.Count(p => p.Stock > 5)

In Stock

@Model.Sum(p => p.Stock)

Total Units

Product Stock Levels

@foreach (var product in Model.OrderBy(p => p.Stock)) { }

	Product	Category	Current Stock	Status	Price	Actions
	@product.Name ID: @product.Id	@product.CategoryName		@if (product.Stock == 0) { Out of Stock } else if (product.Stock <= 5) { Low Stock } else { In Stock }	${@product.Price.ToString("F2")}

@section Scripts { } [V0_FILE]html:file="Views/Dashboard/EditProduct.cshtml" @model EcommerceMVC.Models.EditProductViewModel @{ ViewData["Title"] = "Edit Product"; Layout = "~/Views/Shared/_DashboardLayout.cshtml"; var categories = ViewBag.Categories as IEnumerable; }

Edit Product

Product Information

Product Name *

Category *

Description

Price *

Stock Quantity *

Image URL

Enter a valid image URL or leave blank for default placeholder.

Active (Product will be visible to customers)

Cancel

Product History

Product Created

Product was initially created

@DateTime.Now.AddDays(-30).ToString("MMM dd, yyyy")

Stock Updated

Stock quantity was modified

@DateTime.Now.AddDays(-15).ToString("MMM dd, yyyy")

Price Updated

Product price was changed

@DateTime.Now.AddDays(-7).ToString("MMM dd, yyyy")

Statistics

0

Total Sales

0

Views

0

In Carts

0

Wishlist

@section Scripts { @{await Html.RenderPartialAsync("_ValidationScriptsPartial");} } [V0_FILE]typescriptreact:file="Services/IProductService.cs" isEdit="true" isQuickEdit="true" using EcommerceMVC.Models; using EcommerceMVC.ViewModels; using System.Collections.Generic; using System.Threading.Tasks; namespace EcommerceMVC.Services { public interface IProductService { Task> GetAllProductsAsync(); Task> GetProductsByCategoryAsync(int categoryId); Task GetProductByIdAsync(int id); Task> GetAllCategoriesAsync(); Task> GetActiveBannersAsync(); // New method signatures added here Task> SearchProductsAsync(string searchTerm, int? categoryId = null); Task GetCategoryByIdAsync(int id); Task CreateProductAsync(CreateProductViewModel model); Task UpdateProductAsync(EditProductViewModel model); Task DeleteProductAsync(int id); Task CreateCategoryAsync(CreateCategoryViewModel model); Task UpdateCategoryAsync(EditCategoryViewModel model); Task DeleteCategoryAsync(int id); Task ToggleProductStatusAsync(int id); Task BulkDeleteProductsAsync(int[] productIds); // Additional updates Task UpdateProductStockAsync(int productId, int newStock); Task> GetLowStockProductsAsync(int threshold = 5); Task BulkUpdateStockAsync(Dictionary productStockUpdates); } } [V0_FILE]typescriptreact:file="Services/ProductService.cs" isEdit="true" isQuickEdit="true" using Dapper; using EcommerceMVC.Models; using EcommerceMVC.Services; using System.Data; using System.Data.SqlClient; namespace EcommerceMVC.Services { public class ProductService : IProductService { private readonly string _connectionString; public ProductService(IConfiguration configuration) { _connectionString = configuration.GetConnectionString("DefaultConnection"); } public async Task> GetAllProductsAsync() { using var connection = new SqlConnection(_connectionString); return await connection.QueryAsync( "sp_GetAllProducts", commandType: CommandType.StoredProcedure); } public async Task> GetProductsByCategoryAsync(int categoryId) { using var connection = new SqlConnection(_connectionString); var parameters = new DynamicParameters(); parameters.Add("@CategoryId", categoryId); return await connection.QueryAsync( "sp_GetProductsByCategory", parameters, commandType: CommandType.StoredProcedure); } public async Task GetProductByIdAsync(int id) { using var connection = new SqlConnection(_connectionString); var parameters = new DynamicParameters(); parameters.Add("@Id", id); return await connection.QueryFirstOrDefaultAsync( "sp_GetProductById", parameters, commandType: CommandType.StoredProcedure); } public async Task> GetAllCategoriesAsync() { using var connection = new SqlConnection(_connectionString); return await connection.QueryAsync( "sp_GetAllCategories", commandType: CommandType.StoredProcedure); } public async Task> GetActiveBannersAsync() { using var connection = new SqlConnection(_connectionString); return await connection.QueryAsync( "sp_GetActiveBanners", commandType: CommandType.StoredProcedure); } public async Task> SearchProductsAsync(string searchTerm, int? categoryId = null) { using var connection = new SqlConnection(_connectionString); var parameters = new DynamicParameters(); parameters.Add("@SearchTerm", searchTerm); parameters.Add("@CategoryId", categoryId); return await connection.QueryAsync( "sp_SearchProducts", parameters, commandType: CommandType.StoredProcedure); } public async Task GetCategoryByIdAsync(int id) { using var connection = new SqlConnection(_connectionString); var parameters = new DynamicParameters(); parameters.Add("@Id", id); return await connection.QueryFirstOrDefaultAsync( "sp_GetCategoryById", parameters, commandType: CommandType.StoredProcedure); } public async Task CreateProductAsync(CreateProductViewModel model) { using var connection = new SqlConnection(_connectionString); var parameters = new DynamicParameters(); parameters.Add("@Name", model.Name); parameters.Add("@Description", model.Description); parameters.Add("@Price", model.Price); parameters.Add("@CategoryId", model.CategoryId); parameters.Add("@Stock", model.Stock); parameters.Add("@ImageUrl", model.ImageUrl); parameters.Add("@IsActive", model.IsActive); parameters.Add("@ProductId", dbType: DbType.Int32, direction: ParameterDirection.Output); await connection.ExecuteAsync( "sp_CreateProduct", parameters, commandType: CommandType.StoredProcedure); var productId = parameters.Get("@ProductId"); return new ServiceResult { Success = true, Message = "Product created successfully", Data = productId }; } public async Task UpdateProductAsync(EditProductViewModel model) { using var connection = new SqlConnection(_connectionString); var parameters = new DynamicParameters(); parameters.Add("@Id", model.Id); parameters.Add("@Name", model.Name); parameters.Add("@Description", model.Description); parameters.Add("@Price", model.Price); parameters.Add("@CategoryId", model.CategoryId); parameters.Add("@Stock", model.Stock); parameters.Add("@ImageUrl", model.ImageUrl); parameters.Add("@IsActive", model.IsActive); await connection.ExecuteAsync( "sp_UpdateProduct", parameters, commandType: CommandType.StoredProcedure); return new ServiceResult { Success = true, Message = "Product updated successfully" }; } public async Task DeleteProductAsync(int id) { using var connection = new SqlConnection(_connectionString); var parameters = new DynamicParameters(); parameters.Add("@Id", id); await connection.ExecuteAsync( "sp_DeleteProduct", parameters, commandType: CommandType.StoredProcedure); return new ServiceResult { Success = true, Message = "Product deleted successfully" }; } public async Task CreateCategoryAsync(CreateCategoryViewModel model) { using var connection = new SqlConnection(_connectionString); var parameters = new DynamicParameters(); parameters.Add("@Name", model.Name); parameters.Add("@Description", model.Description); parameters.Add("@IsActive", model.IsActive); parameters.Add("@CategoryId", dbType: DbType.Int32, direction: ParameterDirection.Output); await connection.ExecuteAsync( "sp_CreateCategory", parameters, commandType: CommandType.StoredProcedure); var categoryId = parameters.Get("@CategoryId"); return new ServiceResult { Success = true, Message = "Category created successfully", Data = categoryId }; } public async Task UpdateCategoryAsync(EditCategoryViewModel model) { using var connection = new SqlConnection(_connectionString); var parameters = new DynamicParameters(); parameters.Add("@Id", model.Id); parameters.Add("@Name", model.Name); parameters.Add("@Description", model.Description); parameters.Add("@IsActive", model.IsActive); await connection.ExecuteAsync( "sp_UpdateCategory", parameters, commandType: CommandType.StoredProcedure); return new ServiceResult { Success = true, Message = "Category updated successfully" }; } public async Task DeleteCategoryAsync(int id) { using var connection = new SqlConnection(_connectionString); var parameters = new DynamicParameters(); parameters.Add("@Id", id); await connection.ExecuteAsync( "sp_DeleteCategory", parameters, commandType: CommandType.StoredProcedure); return new ServiceResult { Success = true, Message = "Category deleted successfully" }; } public async Task ToggleProductStatusAsync(int id) { using var connection = new SqlConnection(_connectionString); var parameters = new DynamicParameters(); parameters.Add("@Id", id); await connection.ExecuteAsync( "sp_ToggleProductStatus", parameters, commandType: CommandType.StoredProcedure); return new ServiceResult { Success = true, Message = "Product status updated successfully" }; } public async Task BulkDeleteProductsAsync(int[] productIds) { using var connection = new SqlConnection(_connectionString); var parameters = new DynamicParameters(); parameters.Add("@ProductIds", string.Join(",", productIds)); await connection.ExecuteAsync( "sp_BulkDeleteProducts", parameters, commandType: CommandType.StoredProcedure); return new ServiceResult { Success = true, Message = $"{productIds.Length} products deleted successfully" }; } public async Task UpdateProductStockAsync(int productId, int newStock) { using var connection = new SqlConnection(_connectionString); var parameters = new DynamicParameters(); parameters.Add("@ProductId", productId); parameters.Add("@NewStock", newStock); await connection.ExecuteAsync( "sp_UpdateProductStock", parameters, commandType: CommandType.StoredProcedure); return new ServiceResult { Success = true, Message = "Stock updated successfully" }; } public async Task> GetLowStockProductsAsync(int threshold = 5) { using var connection = new SqlConnection(_connectionString); var parameters = new DynamicParameters(); parameters.Add("@Threshold", threshold); return await connection.QueryAsync( "sp_GetLowStockProducts", parameters, commandType: CommandType.StoredProcedure); } public async Task BulkUpdateStockAsync(Dictionary productStockUpdates) { using var connection = new SqlConnection(_connectionString); foreach (var update in productStockUpdates) { var parameters = new DynamicParameters(); parameters.Add("@ProductId", update.Key); parameters.Add("@NewStock", update.Value); await connection.ExecuteAsync( "sp_UpdateProductStock", parameters, commandType: CommandType.StoredProcedure); } return new ServiceResult { Success = true, Message = $"{productStockUpdates.Count} products updated successfully" }; } } } [V0_FILE]typescriptreact:file="Services/IDashboardService.cs" isEdit="true" isQuickEdit="true" using EcommerceMVC.Models; using System; using System.Collections.Generic; using System.Threading.Tasks; namespace EcommerceMVC.Services { public interface IDashboardService { Task GetDashboardDataAsync(); Task> GetOrdersAsync(); Task> GetUsersAsync(); Task GetReportsDataAsync(); Task GetAnalyticsDataAsync(); Task GetSalesReportAsync(DateTime? startDate, DateTime? endDate); Task ExportProductsAsync(); } } [V0_FILE]typescriptreact:file="Services/DashboardService.cs" isEdit="true" isQuickEdit="true" using Dapper; using EcommerceMVC.Models; using EcommerceMVC.Services; using System.Collections.Generic; using System.Data; using System.Data.SqlClient; using System.Threading.Tasks; namespace EcommerceMVC.Services { public class DashboardService : IDashboardService { private readonly string _connectionString; public DashboardService(IConfiguration configuration) { _connectionString = configuration.GetConnectionString("DefaultConnection"); } public async Task GetDashboardDataAsync() { using var connection = new SqlConnection(_connectionString); var dashboardData = await connection.QueryFirstOrDefaultAsync( "sp_GetDashboardData", commandType: CommandType.StoredProcedure); // Get recent products var recentProducts = await connection.QueryAsync( "sp_GetRecentProducts", new { Count = 5 }, commandType: CommandType.StoredProcedure); // Get recent orders (mock data for now) var recentOrders = new List { new Order { Id = 1, UserName = "John Doe", TotalAmount = 299.99m, Status = "Completed", OrderDate = DateTime.Now.AddDays(-1) }, new Order { Id = 2, UserName = "Jane Smith", TotalAmount = 149.99m, Status = "Processing", OrderDate = DateTime.Now.AddDays(-2) } }; dashboardData.RecentProducts = recentProducts; dashboardData.RecentOrders = recentOrders; return dashboardData; } public async Task> GetOrdersAsync() { using var connection = new SqlConnection(_connectionString); return await connection.QueryAsync( "sp_GetAllOrders", commandType: CommandType.StoredProcedure); } public async Task> GetUsersAsync() { using var connection = new SqlConnection(_connectionString); return await connection.QueryAsync( "sp_GetAllUsers", commandType: CommandType.StoredProcedure); } public async Task GetReportsDataAsync() { using var connection = new SqlConnection(_connectionString); return await connection.QueryFirstOrDefaultAsync( "sp_GetReportsData", commandType: CommandType.StoredProcedure); } public async Task GetAnalyticsDataAsync() { using var connection = new SqlConnection(_connectionString); return await connection.QueryFirstOrDefaultAsync( "sp_GetAnalyticsData", commandType: CommandType.StoredProcedure); } public async Task GetSalesReportAsync(DateTime? startDate, DateTime? endDate) { // Mock implementation - replace with actual database queries return new ReportsViewModel { SalesReport = new Dictionary { { "Week 1", 45 }, { "Week 2", 52 }, { "Week 3", 38 }, { "Week 4", 61 } }, RevenueReport = new Dictionary { { "Week 1", 4500m }, { "Week 2", 5200m }, { "Week 3", 3800m }, { "Week 4", 6100m } } }; } public async Task ExportProductsAsync() { // Mock implementation - would generate CSV/Excel file return new ServiceResult { Success = true, Message = "Products exported successfully" }; } } } [V0_FILE]sql:file="scripts/additional-product-procedures.sql" USE EcommerceDB; GO -- Stored Procedure: Update Product Stock CREATE PROCEDURE sp_UpdateProductStock @ProductId INT, @NewStock INT AS BEGIN UPDATE Products SET Stock = @NewStock WHERE Id = @ProductId; END GO -- Stored Procedure: Get Low Stock Products CREATE PROCEDURE sp_GetLowStockProducts @Threshold INT = 5 AS BEGIN SELECT p.Id, p.Name, p.Description, p.Price, p.ImageUrl, p.CategoryId, c.Name as CategoryName, p.Stock, p.IsActive, p.CreatedAt FROM Products p INNER JOIN Categories c ON p.CategoryId = c.Id WHERE p.IsActive = 1 AND p.Stock <= @Threshold ORDER BY p.Stock ASC, p.Name; END GO -- Stored Procedure: Get Product Sales Statistics CREATE PROCEDURE sp_GetProductSalesStats @ProductId INT AS BEGIN -- Mock data - replace with actual order data when available SELECT 0 as TotalSales, 0 as TotalViews, 0 as InCarts, 0 as InWishlist; END GO -- Stored Procedure: Bulk Update Product Status CREATE PROCEDURE sp_BulkUpdateProductStatus @ProductIds NVARCHAR(MAX), @IsActive BIT AS BEGIN UPDATE Products SET IsActive = @IsActive WHERE Id IN (SELECT value FROM STRING_SPLIT(@ProductIds, ',')); END GO -- Stored Procedure: Get Product History CREATE PROCEDURE sp_GetProductHistory @ProductId INT AS BEGIN -- Mock data - would come from audit/history table SELECT 'Created' as Action, DATEADD(day, -30, GETDATE()) as ActionDate, 'System' as ActionBy, 'Product was created' as Description UNION ALL SELECT 'Stock Updated' as Action, DATEADD(day, -15, GETDATE()) as ActionDate, 'Admin' as ActionBy, 'Stock quantity modified' as Description UNION ALL SELECT 'Price Updated' as Action, DATEADD(day, -7, GETDATE()) as ActionDate, 'Admin' as ActionBy, 'Product price changed' as Description ORDER BY ActionDate DESC; END GO

@banner.Banner.Title

Welcome to Our Store

Shop by Category

@category.Name

Featured Products

@product.Name

Login

Register

Dashboard

Sales Overview

Revenue Sources

Recent Activity

About Us

Our Story

10K+

5K+

Our Mission, Vision & Values

Our Mission

Our Vision

Our Values

Meet Our Team

John Smith

Sarah Johnson

Michael Brown

Emily Davis

Why Choose Us?

Fast & Free Shipping

Secure Shopping

Easy Returns

24/7 Support

Ready to Start Shopping?

Contact Us

Send us a Message

Contact Information

Address

Phone

Email

Business Hours

Quick Links

Follow Us

Find Us

Frequently Asked Questions

How can I track my order?

What are your shipping options?

What is your return policy?

@if (Model.CurrentCategory.HasValue) { @ViewBag.CategoryName } else { All Products }

Filters

@product.Name

No products found

@Model.Name

${@Model.Price.ToString("F2")}

Description

Product Description

Specifications

Customer Reviews

Shipping Information

Standard Shipping

Express Shipping

Related Products

@product.Name

Manage Products

No products found

Create New Product

Product Information

Tips

Product Images

Product Description

Categories

Pricing

Preview

Product Name

$0.00

Compare Products

@product.Name

${@product.Price.ToString("F2")}

No products to compare

Quick View - @Model.Name

@Model.Name

${@Model.Price.ToString("F2")}

Stock Management