Project Introduction
The Auction Management System is designed to facilitate online auctions by providing a platform for users to bid on items, manage their accounts, and track auction events. Built using ASP.NET and SQL Server, this application aims to streamline the auction process for both buyers and sellers. Users can create accounts, list items for auction, place bids, and make payments securely. The system also includes features for managing auction types, generating reports, and providing feedback, enhancing the overall user experience in the auction environment.
Project Objectives
- To create a secure user authentication system for managing user accounts and roles.
- To enable users to create and manage auction items, including descriptions and starting prices.
- To facilitate the bidding process, allowing users to place bids on items.
- To manage payments for successful bids and track payment statuses.
- To organize auctions with specific start and end dates, and types.
- To generate reports on auction activities, bids, and user interactions.
- To collect user feedback to improve the platform's functionality and user experience.
- To implement a notification system to keep users informed about auction updates and bid statuses.
Project Modules
- User Management Module: Handles user registration, login, and role management.
- Auction Management Module: Manages the creation and organization of auctions.
- Item Management Module: Allows users to list, edit, and delete auction items.
- Bid Management Module: Facilitates the bidding process and tracks bid history.
- Payment Management Module: Handles payment processing for auction items.
- Report Generation Module: Generates reports on auction performance and user activity.
- Feedback Module: Collects and manages user feedback on the auction process.
- Notification Module: Sends notifications to users regarding auction updates and bid statuses.
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,
FirstName NVARCHAR(50) NOT NULL,
LastName NVARCHAR(50) NOT NULL,
RoleId INT NOT NULL,
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt 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,
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE()
);
-- Create Items Table
CREATE TABLE Items (
ItemId INT PRIMARY KEY IDENTITY(1,1),
ItemName NVARCHAR(100) NOT NULL,
Description NVARCHAR(MAX),
StartingPrice DECIMAL(18, 2) NOT NULL,
AuctionId INT NOT NULL,
CreatedBy INT NOT NULL,
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (AuctionId) REFERENCES Auctions(AuctionId),
FOREIGN KEY (CreatedBy) REFERENCES Users(UserId)
);
-- Create Bids Table
CREATE TABLE Bids (
BidId INT PRIMARY KEY IDENTITY(1,1),
ItemId INT NOT NULL,
UserId INT NOT NULL,
BidAmount DECIMAL(18, 2) NOT NULL,
BidTime DATETIME DEFAULT GETDATE(),
FOREIGN KEY (ItemId) REFERENCES Items(ItemId),
FOREIGN KEY (User Id) REFERENCES Users(UserId)
);
-- Create Payments Table
CREATE TABLE Payments (
PaymentId INT PRIMARY KEY IDENTITY(1,1),
UserId INT NOT NULL,
ItemId INT NOT NULL,
PaymentAmount DECIMAL(18, 2) NOT NULL,
PaymentDate DATETIME DEFAULT GETDATE(),
PaymentStatus NVARCHAR(20) NOT NULL, -- e.g., Completed, Pending, Failed
FOREIGN KEY (User Id) REFERENCES Users(UserId),
FOREIGN KEY (ItemId) REFERENCES Items(ItemId)
);
-- Create Auctions Table
CREATE TABLE Auctions (
AuctionId INT PRIMARY KEY IDENTITY(1,1),
AuctionTitle NVARCHAR(100) NOT NULL,
AuctionTypeId INT NOT NULL,
StartDate DATETIME NOT NULL,
EndDate DATETIME NOT NULL,
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (AuctionTypeId) REFERENCES AuctionTypes(AuctionTypeId)
);
-- Create AuctionTypes Table
CREATE TABLE AuctionTypes (
AuctionTypeId INT PRIMARY KEY IDENTITY(1,1),
TypeName NVARCHAR(50) NOT NULL UNIQUE,
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE()
);
-- Create Reports Table
CREATE TABLE Reports (
ReportId INT PRIMARY KEY IDENTITY(1,1),
UserId INT NOT NULL,
ReportDate DATETIME NOT NULL,
ReportContent NVARCHAR(MAX),
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId)
);
-- Create Feedback Table
CREATE TABLE Feedback (
FeedbackId INT PRIMARY KEY IDENTITY(1,1),
UserId INT NOT NULL,
FeedbackContent NVARCHAR(MAX) NOT NULL,
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId)
);
-- Create Notifications Table
CREATE TABLE Notifications (
NotificationId INT PRIMARY KEY IDENTITY(1,1),
UserId INT NOT NULL,
Message NVARCHAR(255) NOT NULL,
IsRead BIT NOT NULL DEFAULT 0,
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId)
);
Explanation of Tables
Users: Stores user information, including their role.
Roles: Defines different roles (e.g., Admin, Bidder) in the system.
Items: Contains details about auction items, including their starting price and associated auction.
Bids: Records bids placed by users on auction items.
Payments: Manages payment transactions for items won in auctions.
Auctions: Stores information about auctions, including their type and duration.
AuctionTypes: Defines different types of auctions (e.g., English, Dutch).
Reports: Allows users to generate reports related to their auction activities.
Feedback: Collects user feedback on the auction system.
Notifications: Stores notifications for users regarding bids, auction updates, and other relevant information.
To create a model and repository pattern using ADO.NET for the provided SQL Server tables in an ASP.NET application
We will follow these steps:
Create Models
Define C# classes that represent the tables in your database.
public class User
{
public int UserId { get; set; }
public string Username { get; set; }
public string PasswordHash { get; set; }
public string Email { get; set; }
public string FirstName { get; set; }
public string LastName { get; set; }
public int RoleId { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class Role
{
public int RoleId { get; set; }
public string RoleName { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class Item
{
public int ItemId { get; set; }
public string ItemName { get; set; }
public string Description { get; set; }
public decimal StartingPrice { get; set; }
public int AuctionId { get; set; }
public int CreatedBy { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class Bid
{
public int BidId { get; set; }
public int ItemId { get; set; }
public int UserId { get; set; }
public decimal BidAmount { get; set; }
public DateTime BidTime { get; set; }
}
public class Payment
{
public int PaymentId { get; set; }
public int UserId { get; set; }
public int ItemId { get; set; }
public decimal PaymentAmount { get; set; }
public DateTime PaymentDate { get; set; }
public string PaymentStatus { get; set; }
}
public class Auction
{
public int AuctionId { get; set; }
public string AuctionTitle { get; set; }
public int AuctionTypeId { get; set; }
public DateTime StartDate { get; set; }
public DateTime EndDate { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class AuctionType
{
public int AuctionTypeId { get; set; }
public string TypeName { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public class Report
{
public int ReportId { get; set; }
public int UserId { get; set; }
public DateTime ReportDate { get; set; }
public string ReportContent { get; set; }
public DateTime CreatedAt { get; set; }
}
public class Feedback
{
public int FeedbackId { get; set; }
public int UserId { get; set; }
public string FeedbackContent { get; set; }
public DateTime CreatedAt { get; set; }
}
public class Notification
{
public int NotificationId { get; set; }
public int UserId { get; set; }
public string Message { get; set; }
public bool IsRead { get; set; }
public DateTime CreatedAt { get; set; }
}
Create Repositories
Next, we will create a generic repository interface and a concrete implementation for the User entity. You can create similar repositories for other entities.
Generic Repository Interface
public interface IRepository<T>
{
IEnumerable<T> GetAll();
T GetById(int id);
void Add(T entity);
void Update(T entity);
void Delete(int id);
}
User Repository Implementation
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
public class UserRepository : IRepository<User>
{
private readonly string _connectionString;
public UserRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<User> GetAll()
{
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(),
FirstName = reader["FirstName"].ToString(),
LastName = reader["LastName"].ToString(),
RoleId = (int)reader["RoleId"],
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime )reader["UpdatedAt"]
});
}
}
}
return users;
}
public User GetById(int id)
{
User user = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Users WHERE UserId = @User Id", connection);
command.Parameters.AddWithValue("@User Id", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
user = new User
{
UserId = (int)reader["User Id"],
Username = reader["Username"].ToString(),
PasswordHash = reader["PasswordHash"].ToString(),
Email = reader["Email"].ToString(),
FirstName = reader["FirstName"].ToString(),
LastName = reader["LastName"].ToString(),
RoleId = (int)reader["RoleId"],
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return user;
}
public void Add(User user)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Users (Username, PasswordHash, Email, FirstName, LastName, RoleId) VALUES (@Username, @PasswordHash, @Email, @FirstName, @LastName, @RoleId)", connection);
command.Parameters.AddWithValue("@Username", user.Username);
command.Parameters.AddWithValue("@PasswordHash", user.PasswordHash);
command.Parameters.AddWithValue("@Email", user.Email);
command.Parameters.AddWithValue("@FirstName", user.FirstName);
command.Parameters.AddWithValue("@LastName", user.LastName);
command.Parameters.AddWithValue("@RoleId", user.RoleId);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(User user)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Users SET Username = @Username, PasswordHash = @PasswordHash, Email = @Email, FirstName = @FirstName, LastName = @LastName, RoleId = @RoleId, UpdatedAt = GETDATE() WHERE UserId = @User Id", connection);
command.Parameters.AddWithValue("@Username", user.Username);
command.Parameters.AddWithValue("@PasswordHash", user.PasswordHash);
command.Parameters.AddWithValue("@Email", user.Email);
command.Parameters.AddWithValue("@FirstName", user.FirstName);
command.Parameters.AddWithValue("@LastName", user.LastName);
command.Parameters.AddWithValue("@RoleId", user.RoleId);
command.Parameters.AddWithValue("@User Id", user.UserId);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Users WHERE UserId = @User Id", connection);
command.Parameters.AddWithValue("@User Id", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
This structure provides a solid foundation for your ASP.NET application using ADO.NET with a repository pattern. You can create similar repository classes for other entities like Role, Item, Bid, Payment, Auction, AuctionType, Report, Feedback, and Notification by following the same pattern as shown for the User Repository.
Sure! Below are the repository implementations for the remaining models
Role, Item, Bid, Payment, Auction, AuctionType, Report, Feedback, and Notification. Each repository follows the same pattern as the User Repository.
Role Repository Implementation
public class RoleRepository : IRepository<Role>
{
private readonly string _connectionString;
public RoleRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<Role> GetAll()
{
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(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return roles;
}
public Role GetById(int id)
{
Role role = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Roles WHERE RoleId = @RoleId", connection);
command.Parameters.AddWithValue("@RoleId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
role = new Role
{
RoleId = (int)reader["RoleId"],
RoleName = reader["RoleName"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return role;
}
public void Add(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 void Update(Role role)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Roles SET RoleName = @RoleName, UpdatedAt = GETDATE() WHERE RoleId = @RoleId", connection);
command.Parameters.AddWithValue("@RoleName", role.RoleName);
command.Parameters.AddWithValue("@RoleId", role.RoleId);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Roles WHERE RoleId = @RoleId", connection);
command.Parameters.AddWithValue("@RoleId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Item Repository Implementation
public class ItemRepository : IRepository<Item>
{
private readonly string _connectionString;
public ItemRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<Item> GetAll()
{
var items = new List<Item>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Items", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
items.Add(new Item
{
ItemId = (int)reader["ItemId"],
ItemName = reader["ItemName"].ToString(),
Description = reader["Description"].ToString(),
StartingPrice = (decimal)reader["StartingPrice"],
AuctionId = (int)reader["AuctionId"],
CreatedBy = (int)reader["CreatedBy"],
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return items;
}
public Item GetById(int id)
{
Item item = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Items WHERE ItemId = @ItemId", connection);
command.Parameters.AddWithValue("@ItemId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
item = new Item
{
ItemId = (int)reader["ItemId"],
ItemName = reader["ItemName"].ToString(),
Description = reader["Description"].ToString(),
StartingPrice = (decimal)reader["StartingPrice"],
AuctionId = (int)reader["AuctionId"],
CreatedBy = (int)reader["CreatedBy"],
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return item;
}
public void Add(Item item)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Items (ItemName, Description, StartingPrice, AuctionId, CreatedBy) VALUES (@ItemName, @Description, @StartingPrice, @AuctionId, @CreatedBy)", connection);
command.Parameters.AddWithValue("@ItemName", item.ItemName);
command.Parameters.AddWithValue("@Description", item.Description);
command.Parameters.AddWithValue("@StartingPrice", item.StartingPrice);
command.Parameters.AddWithValue("@AuctionId", item.AuctionId);
command.Parameters.AddWithValue("@CreatedBy", item.CreatedBy);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(Item item)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Items SET ItemName = @ItemName, Description = @Description, StartingPrice = @StartingPrice, AuctionId = @AuctionId, CreatedBy = @CreatedBy, UpdatedAt = GETDATE() WHERE ItemId = @ItemId", connection);
command.Parameters.AddWithValue("@ItemName", item.ItemName);
command.Parameters.AddWithValue("@Description", item.Description);
command.Parameters.AddWithValue("@StartingPrice", item.StartingPrice);
command.Parameters.AddWithValue("@AuctionId", item.AuctionId);
command.Parameters.AddWithValue("@CreatedBy", item.CreatedBy);
command.Parameters.AddWithValue("@ItemId", item.ItemId);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Items WHERE ItemId = @ItemId", connection);
command.Parameters.AddWithValue("@ItemId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Bid Repository Implementation
public class BidRepository : IRepository<Bid>
{
private readonly string _connectionString;
public BidRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<Bid> GetAll()
{
var bids = new List<Bid>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Bids", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
bids.Add(new Bid
{
BidId = (int)reader["BidId"],
ItemId = (int)reader["ItemId"],
UserId = (int)reader["User Id"],
BidAmount = (decimal)reader["BidAmount"],
BidTime = (DateTime)reader["BidTime"]
});
}
}
}
return bids;
}
public Bid GetById(int id)
{
Bid bid = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Bids WHERE BidId = @BidId", connection);
command.Parameters.AddWithValue("@BidId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
bid = new Bid
{
BidId = (int)reader["BidId"],
ItemId = (int)reader["ItemId"],
UserId = (int)reader["User Id"],
BidAmount = (decimal)reader["BidAmount"],
BidTime = (DateTime)reader["BidTime"]
};
}
}
}
return bid;
}
public void Add(Bid bid)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Bids (ItemId, UserId, BidAmount) VALUES (@ItemId, @User Id, @BidAmount)", connection);
command.Parameters.AddWithValue("@ItemId", bid.ItemId);
command.Parameters.AddWithValue("@User Id", bid.UserId);
command.Parameters.AddWithValue("@BidAmount", bid.BidAmount);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(Bid bid)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Bids SET ItemId = @ItemId, UserId = @User Id, BidAmount = @BidAmount, BidTime = GETDATE() WHERE BidId = @BidId", connection);
command.Parameters.AddWithValue("@ItemId", bid.ItemId);
command.Parameters.AddWithValue("@User Id", bid.UserId);
command.Parameters.AddWithValue("@BidAmount", bid.BidAmount);
command.Parameters.AddWithValue("@BidId", bid.BidId);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Bids WHERE BidId = @BidId", connection);
command.Parameters.AddWithValue("@BidId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Payment Repository Implementation
public class PaymentRepository : IRepository<Payment>
{
private readonly string _connectionString;
public PaymentRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<Payment> GetAll()
{
var payments = new List<Payment>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Payments", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
payments.Add(new Payment
{
PaymentId = (int)reader["PaymentId"],
UserId = (int)reader["User Id"],
ItemId = (int)reader["ItemId"],
PaymentAmount = (decimal)reader["PaymentAmount"],
PaymentDate = (DateTime)reader["PaymentDate"],
PaymentStatus = reader["PaymentStatus"].ToString()
});
}
}
}
return payments;
}
public Payment GetById(int id)
{
Payment payment = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Payments WHERE PaymentId = @PaymentId", connection);
command.Parameters.AddWithValue("@PaymentId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
payment = new Payment
{
PaymentId = (int)reader["PaymentId"],
UserId = (int)reader["User Id"],
ItemId = (int)reader["ItemId"],
PaymentAmount = (decimal)reader["PaymentAmount"],
PaymentDate = (DateTime)reader["PaymentDate"],
PaymentStatus = reader["PaymentStatus"].ToString()
};
}
}
}
return payment;
}
public void Add(Payment payment)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Payments (User Id, ItemId, PaymentAmount, PaymentStatus) VALUES (@User Id, @ItemId, @PaymentAmount, @PaymentStatus)", connection);
command.Parameters.AddWithValue("@User Id", payment.UserId);
command.Parameters.AddWithValue("@ItemId", payment.ItemId);
command.Parameters.AddWithValue("@PaymentAmount", payment.PaymentAmount);
command.Parameters.AddWithValue("@PaymentStatus", payment.PaymentStatus);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(Payment payment)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Payments SET UserId = @User Id, ItemId = @ItemId, PaymentAmount = @PaymentAmount, PaymentStatus = @PaymentStatus WHERE PaymentId = @PaymentId", connection);
command.Parameters.AddWithValue("@User Id", payment.UserId);
command.Parameters.AddWithValue("@ItemId", payment.ItemId);
command.Parameters.AddWithValue("@PaymentAmount", payment.PaymentAmount);
command.Parameters.AddWithValue("@PaymentStatus", payment.PaymentStatus);
command.Parameters.AddWithValue("@PaymentId", payment.PaymentId);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Payments WHERE PaymentId = @PaymentId", connection);
command.Parameters.AddWithValue("@PaymentId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Auction Repository Implementation
public class AuctionRepository : IRepository<Auction>
{
private readonly string _connectionString;
public AuctionRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<Auction> GetAll()
{
var auctions = new List<Auction>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Auctions", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
auctions.Add(new Auction
{
AuctionId = (int)reader["AuctionId"],
AuctionTitle = reader["AuctionTitle"].ToString(),
AuctionTypeId = (int)reader["AuctionTypeId"],
StartDate = (DateTime)reader["StartDate"],
EndDate = (DateTime)reader["EndDate"],
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return auctions;
}
public Auction GetById(int id)
{
Auction auction = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Auctions WHERE AuctionId = @AuctionId", connection);
command.Parameters.AddWithValue("@AuctionId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
auction = new Auction
{
AuctionId = (int)reader["AuctionId"],
AuctionTitle = reader["AuctionTitle"].ToString(),
AuctionTypeId = (int)reader["AuctionTypeId"],
StartDate = (DateTime)reader["StartDate"],
EndDate = (DateTime)reader["EndDate"],
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return auction;
}
public void Add(Auction auction)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Auctions (AuctionTitle, AuctionTypeId, StartDate, EndDate) VALUES (@AuctionTitle, @AuctionTypeId, @StartDate, @EndDate)", connection);
command.Parameters.AddWithValue("@AuctionTitle", auction.AuctionTitle);
command.Parameters.AddWithValue("@AuctionTypeId", auction.AuctionTypeId);
command.Parameters.AddWithValue("@StartDate", auction.StartDate);
command.Parameters.AddWithValue("@EndDate", auction.EndDate);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(Auction auction)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Auctions SET AuctionTitle = @AuctionTitle, AuctionTypeId = @AuctionTypeId, StartDate = @StartDate, EndDate = @EndDate, UpdatedAt = GETDATE() WHERE AuctionId = @AuctionId", connection);
command.Parameters.AddWithValue("@AuctionTitle", auction.AuctionTitle);
command.Parameters.AddWithValue("@AuctionTypeId", auction.AuctionTypeId);
command.Parameters.AddWithValue("@StartDate", auction.StartDate);
command.Parameters.AddWithValue("@EndDate", auction.EndDate);
command.Parameters.AddWithValue("@AuctionId", auction.AuctionId);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Auctions WHERE AuctionId = @AuctionId", connection);
command.Parameters.AddWithValue("@AuctionId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
AuctionType Repository Implementation
public class AuctionTypeRepository : IRepository<AuctionType>
{
private readonly string _connectionString;
public AuctionTypeRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<AuctionType> GetAll()
{
var auctionTypes = new List<AuctionType>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM AuctionTypes", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
auctionTypes.Add(new AuctionType
{
AuctionTypeId = (int)reader["AuctionTypeId"],
TypeName = reader["TypeName"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
});
}
}
}
return auctionTypes;
}
public AuctionType GetById(int id)
{
AuctionType auctionType = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM AuctionTypes WHERE AuctionTypeId = @AuctionTypeId", connection);
command.Parameters.AddWithValue("@AuctionTypeId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
auctionType = new AuctionType
{
AuctionTypeId = (int)reader["AuctionTypeId"],
TypeName = reader["TypeName"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"],
UpdatedAt = (DateTime)reader["UpdatedAt"]
};
}
}
}
return auctionType;
}
public void Add(Auction Type auctionType)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO AuctionTypes (TypeName) VALUES (@TypeName)", connection);
command.Parameters.AddWithValue("@TypeName", auctionType.TypeName);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(AuctionType auctionType)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE AuctionTypes SET TypeName = @TypeName, UpdatedAt = GETDATE() WHERE AuctionTypeId = @AuctionTypeId", connection);
command.Parameters.AddWithValue("@TypeName", auctionType.TypeName);
command.Parameters.AddWithValue("@AuctionTypeId", auctionType.AuctionTypeId);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM AuctionTypes WHERE AuctionTypeId = @AuctionTypeId", connection);
command.Parameters.AddWithValue("@AuctionTypeId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Report Repository Implementation
public class ReportRepository : IRepository<Report>
{
private readonly string _connectionString;
public ReportRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<Report> GetAll()
{
var reports = new List<Report>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Reports", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
reports.Add(new Report
{
ReportId = (int)reader["ReportId"],
UserId = (int)reader["User Id"],
ReportDate = (DateTime)reader["ReportDate"],
ReportContent = reader["ReportContent"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return reports;
}
public Report GetById(int id)
{
Report report = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Reports WHERE ReportId = @ReportId", connection);
command.Parameters.AddWithValue("@ReportId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
report = new Report
{
ReportId = (int)reader["ReportId"],
UserId = (int)reader["User Id"],
ReportDate = (DateTime)reader["ReportDate"],
ReportContent = reader["ReportContent"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return report;
}
public void Add(Report report)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Reports (User Id, ReportDate, ReportContent) VALUES (@User Id, @ReportDate, @ReportContent)", connection);
command.Parameters.AddWithValue("@User Id", report.UserId);
command.Parameters.AddWithValue("@ReportDate", report.ReportDate);
command.Parameters.AddWithValue("@ReportContent", report.ReportContent);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(Report report)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Reports SET UserId = @User Id, ReportDate = @ReportDate, ReportContent = @ReportContent WHERE ReportId = @ReportId", connection);
command.Parameters.AddWithValue("@User Id", report.UserId);
command.Parameters.AddWithValue("@ReportDate", report.ReportDate);
command.Parameters.AddWithValue("@ReportContent", report.ReportContent);
command.Parameters.AddWithValue("@ReportId", report.ReportId);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Reports WHERE ReportId = @ReportId", connection);
command.Parameters.AddWithValue("@ReportId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Feedback Repository Implementation
public class FeedbackRepository : IRepository<Feedback>
{
private readonly string _connectionString;
public FeedbackRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<Feedback> GetAll()
{
var feedbacks = new List<Feedback>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Feedback", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
feedbacks.Add(new Feedback
{
FeedbackId = (int)reader["FeedbackId"],
UserId = (int)reader["User Id"],
FeedbackContent = reader["FeedbackContent"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return feedbacks;
}
public Feedback GetById(int id)
{
Feedback feedback = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Feedback WHERE FeedbackId = @FeedbackId", connection);
command.Parameters.AddWithValue("@FeedbackId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
feedback = new Feedback
{
FeedbackId = (int)reader["FeedbackId"],
UserId = (int)reader["User Id"],
FeedbackContent = reader["FeedbackContent"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return feedback;
}
public void Add(Feedback feedback)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Feedback (User Id, FeedbackContent) VALUES (@User Id, @FeedbackContent)", connection);
command.Parameters.AddWithValue("@User Id", feedback.UserId);
command.Parameters.AddWithValue("@FeedbackContent", feedback.FeedbackContent);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(Feedback feedback)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Feedback SET UserId = @User Id, FeedbackContent = @FeedbackContent WHERE FeedbackId = @FeedbackId", connection);
command.Parameters.AddWithValue("@User Id", feedback.UserId);
command.Parameters.AddWithValue("@FeedbackContent", feedback.FeedbackContent);
command.Parameters.AddWithValue("@FeedbackId", feedback.FeedbackId);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Feedback WHERE FeedbackId = @FeedbackId", connection);
command.Parameters.AddWithValue("@FeedbackId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Notification Repository Implementation
public class NotificationRepository : IRepository<Notification>
{
private readonly string _connectionString;
public NotificationRepository(string connectionString)
{
_connectionString = connectionString;
}
public IEnumerable<Notification> GetAll()
{
var notifications = new List<Notification>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Notifications", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
notifications.Add(new Notification
{
NotificationId = (int)reader["NotificationId"],
UserId = (int)reader["User Id"],
Message = reader["Message"].ToString(),
IsRead = (bool)reader["IsRead"],
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return notifications;
}
public Notification GetById(int id)
{
Notification notification = null;
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Notifications WHERE NotificationId = @NotificationId", connection);
command.Parameters.AddWithValue("@NotificationId", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
notification = new Notification
{
NotificationId = (int)reader["NotificationId"],
UserId = (int)reader["User Id"],
Message = reader["Message"].ToString(),
IsRead = (bool)reader["IsRead"],
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return notification;
}
public void Add(Notification notification)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Notifications (User Id, Message, IsRead) VALUES (@User Id, @Message, @IsRead )", connection);
command.Parameters.AddWithValue("@User Id", notification.UserId);
command.Parameters.AddWithValue("@Message", notification.Message);
command.Parameters.AddWithValue("@IsRead", notification.IsRead);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Update(Notification notification)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Notifications SET UserId = @User Id, Message = @Message, IsRead = @IsRead WHERE NotificationId = @NotificationId", connection);
command.Parameters.AddWithValue("@User Id", notification.UserId);
command.Parameters.AddWithValue("@Message", notification.Message);
command.Parameters.AddWithValue("@IsRead", notification.IsRead);
command.Parameters.AddWithValue("@NotificationId", notification.NotificationId);
connection.Open();
command.ExecuteNonQuery();
}
}
public void Delete(int id)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Notifications WHERE NotificationId = @NotificationId", connection);
command.Parameters.AddWithValue("@NotificationId", id);
connection.Open();
command.ExecuteNonQuery();
}
}
}
This completes the repository implementations for all the models defined in your SQL Server schema. Each repository follows the same structure, allowing for consistent data access patterns across your application. You can now utilize these repositories in your ASP.NET application to manage data for users, roles, items, bids, payments, auctions, auction types, reports, feedback, and notifications.
To create controllers for each repository in an ASP.NET MVC application
We will follow the standard pattern of creating a controller for each entity. Each controller will handle HTTP requests and interact with the corresponding repository to perform CRUD operations. Below are the example controllers for each of the repositories we created earlier.
UserController
using System.Web.Mvc;
using System.Collections.Generic;
public class UserController : Controller
{
private readonly UserRepository _userRepository;
public UserController()
{
_userRepository = new UserRepository("YourConnectionStringHere");
}
public ActionResult Index()
{
var users = _userRepository.GetAll();
return View(users);
}
public ActionResult Details(int id)
{
var user = _userRepository.GetById(id);
return View(user);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(User user)
{
if (ModelState.IsValid)
{
_userRepository.Add(user);
return RedirectToAction("Index");
}
return View(user);
}
public ActionResult Edit(int id)
{
var user = _userRepository.GetById(id);
return View(user);
}
[HttpPost]
public ActionResult Edit(User user)
{
if (ModelState.IsValid)
{
_userRepository.Update(user);
return RedirectToAction("Index");
}
return View(user);
}
public ActionResult Delete(int id)
{
var user = _userRepository.GetById(id);
return View(user);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_userRepository.Delete(id);
return RedirectToAction("Index");
}
}
RoleController
public class RoleController : Controller
{
private readonly RoleRepository _roleRepository;
public RoleController()
{
_roleRepository = new RoleRepository("YourConnectionStringHere");
}
public ActionResult Index()
{
var roles = _roleRepository.GetAll();
return View(roles);
}
public ActionResult Details(int id)
{
var role = _roleRepository.GetById(id);
return View(role);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(Role role)
{
if (ModelState.IsValid)
{
_roleRepository.Add(role);
return RedirectToAction("Index");
}
return View(role);
}
public ActionResult Edit(int id)
{
var role = _roleRepository.GetById(id);
return View(role);
}
[HttpPost]
public ActionResult Edit(Role role)
{
if (ModelState.IsValid)
{
_roleRepository.Update(role);
return RedirectToAction("Index");
}
return View(role);
}
public ActionResult Delete(int id)
{
var role = _roleRepository.GetById(id);
return View(role);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_roleRepository.Delete(id);
return RedirectToAction("Index");
}
}
ItemController
public class ItemController : Controller
{
private readonly ItemRepository _itemRepository;
public ItemController()
{
_itemRepository = new ItemRepository("YourConnectionStringHere");
}
public ActionResult Index()
{
var items = _itemRepository.GetAll();
return View(items);
}
public ActionResult Details(int id)
{
var item = _itemRepository.GetById(id);
return View(item);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(Item item)
{
if (ModelState.IsValid)
{
_itemRepository.Add(item);
return RedirectToAction("Index");
}
return View(item);
}
public ActionResult Edit(int id)
{
var item = _itemRepository.GetById(id);
return View(item);
}
[HttpPost]
public ActionResult Edit(Item item)
{
if (ModelState.IsValid)
{
_itemRepository.Update(item);
return RedirectToAction("Index");
}
return View(item);
}
public ActionResult Delete(int id)
{
var item = _itemRepository.GetById(id);
return View(item);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_itemRepository.Delete(id);
return RedirectToAction("Index");
}
}
BidController
public class BidController : Controller
{
private readonly BidRepository _bidRepository;
public BidController()
{
_bidRepository = new BidRepository("YourConnectionStringHere");
}
public ActionResult Index()
{
var bids = _bidRepository.GetAll();
return View(bids);
}
public ActionResult Details(int id)
{
var bid = _bidRepository.GetById(id);
return View(bid);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(Bid bid)
{
if (ModelState.IsValid)
{
_bidRepository.Add(bid);
return RedirectToAction("Index");
}
return View(bid);
}
public ActionResult Edit(int id)
{
var bid = _bidRepository.GetById(id);
return View(bid);
}
[HttpPost]
public ActionResult Edit(Bid bid)
{
if (ModelState.IsValid)
{
_bidRepository.Update(bid);
return RedirectToAction("Index");
}
return View(bid);
}
public ActionResult Delete(int id)
{
var bid = _bidRepository.GetById(id);
return View(bid);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_bidRepository.Delete(id);
return RedirectToAction("Index");
}
}
PaymentController
public class PaymentController : Controller
{
private readonly PaymentRepository _paymentRepository;
public PaymentController()
{
_paymentRepository = new PaymentRepository("YourConnectionStringHere");
}
public ActionResult Index()
{
var payments = _paymentRepository.GetAll();
return View(payments);
}
public ActionResult Details(int id)
{
var payment = _paymentRepository.GetById(id);
return View(payment);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(Payment payment)
{
if (ModelState.IsValid)
{
_paymentRepository.Add(payment);
return RedirectToAction("Index");
}
return View(payment);
}
public ActionResult Edit(int id)
{
var payment = _paymentRepository.GetById(id);
return View(payment);
}
[HttpPost]
public ActionResult Edit(Payment payment)
{
if (ModelState.IsValid)
{
_paymentRepository.Update(payment);
return RedirectToAction("Index");
}
return View(payment);
}
public ActionResult Delete(int id)
{
var payment = _paymentRepository.GetById(id);
return View(payment);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_paymentRepository.Delete(id);
return RedirectToAction("Index");
}
}
AuctionController
public class AuctionController : Controller
{
private readonly AuctionRepository _auctionRepository;
public AuctionController()
{
_auctionRepository = new AuctionRepository("YourConnectionStringHere");
}
public ActionResult Index()
{
var auctions = _auctionRepository.GetAll();
return View(auctions);
}
public ActionResult Details(int id)
{
var auction = _auctionRepository.GetById(id);
return View(auction);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(Auction auction)
{
if (ModelState.IsValid)
{
_auctionRepository.Add(auction);
return RedirectToAction("Index");
}
return View(auction);
}
public ActionResult Edit(int id)
{
var auction = _auctionRepository.GetById(id);
return View(auction);
}
[HttpPost]
public ActionResult Edit(Auction auction)
{
if (ModelState.IsValid)
{
_auctionRepository.Update(auction);
return RedirectToAction("Index");
}
return View(auction);
}
public ActionResult Delete(int id)
{
var auction = _auctionRepository.GetById(id);
return View(auction);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_auctionRepository.Delete(id);
return RedirectToAction("Index");
}
}
AuctionTypeController
public class AuctionTypeController : Controller
{
private readonly AuctionTypeRepository _auctionTypeRepository;
public AuctionTypeController()
{
_auctionTypeRepository = new AuctionTypeRepository("YourConnectionStringHere");
}
public ActionResult Index()
{
var auctionTypes = _auctionTypeRepository.GetAll();
return View(auctionTypes);
}
public ActionResult Details(int id)
{
var auctionType = _auctionTypeRepository.GetById(id);
return View(auctionType);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(AuctionType auctionType)
{
if (ModelState.IsValid)
{
_auctionTypeRepository.Add( auctionType);
return RedirectToAction("Index");
}
return View(auctionType);
}
public ActionResult Edit(int id)
{
var auctionType = _auctionTypeRepository.GetById(id);
return View(auctionType);
}
[HttpPost]
public ActionResult Edit(AuctionType auctionType)
{
if (ModelState.IsValid)
{
_auctionTypeRepository.Update(auctionType);
return RedirectToAction("Index");
}
return View(auctionType);
}
public ActionResult Delete(int id)
{
var auctionType = _auctionTypeRepository.GetById(id);
return View(auctionType);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_auctionTypeRepository.Delete(id);
return RedirectToAction("Index");
}
}
ReportController
public class ReportController : Controller
{
private readonly ReportRepository _reportRepository;
public ReportController()
{
_reportRepository = new ReportRepository("YourConnectionStringHere");
}
public ActionResult Index()
{
var reports = _reportRepository.GetAll();
return View(reports);
}
public ActionResult Details(int id)
{
var report = _reportRepository.GetById(id);
return View(report);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(Report report)
{
if (ModelState.IsValid)
{
_reportRepository.Add(report);
return RedirectToAction("Index");
}
return View(report);
}
public ActionResult Edit(int id)
{
var report = _reportRepository.GetById(id);
return View(report);
}
[HttpPost]
public ActionResult Edit(Report report)
{
if (ModelState.IsValid)
{
_reportRepository.Update(report);
return RedirectToAction("Index");
}
return View(report);
}
public ActionResult Delete(int id)
{
var report = _reportRepository.GetById(id);
return View(report);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_reportRepository.Delete(id);
return RedirectToAction("Index");
}
}
FeedbackController
public class FeedbackController : Controller
{
private readonly FeedbackRepository _feedbackRepository;
public FeedbackController()
{
_feedbackRepository = new FeedbackRepository("YourConnectionStringHere");
}
public ActionResult Index()
{
var feedbacks = _feedbackRepository.GetAll();
return View(feedbacks);
}
public ActionResult Details(int id)
{
var feedback = _feedbackRepository.GetById(id);
return View(feedback);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(Feedback feedback)
{
if (ModelState.IsValid)
{
_feedbackRepository.Add(feedback);
return RedirectToAction("Index");
}
return View(feedback);
}
public ActionResult Edit(int id)
{
var feedback = _feedbackRepository.GetById(id);
return View(feedback);
}
[HttpPost]
public ActionResult Edit(Feedback feedback)
{
if (ModelState.IsValid)
{
_feedbackRepository.Update(feedback);
return RedirectToAction("Index");
}
return View(feedback);
}
public ActionResult Delete(int id)
{
var feedback = _feedbackRepository.GetById(id);
return View(feedback);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_feedbackRepository.Delete(id);
return RedirectToAction("Index");
}
}
NotificationController
public class NotificationController : Controller
{
private readonly NotificationRepository _notificationRepository;
public NotificationController()
{
_notificationRepository = new NotificationRepository("YourConnectionStringHere");
}
public ActionResult Index()
{
var notifications = _notificationRepository.GetAll();
return View(notifications);
}
public ActionResult Details(int id)
{
var notification = _notificationRepository.GetById(id);
return View(notification);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(Notification notification)
{
if (ModelState.IsValid)
{
_notificationRepository.Add(notification);
return RedirectToAction("Index");
}
return View(notification);
}
public ActionResult Edit(int id)
{
var notification = _notificationRepository.GetById(id );
return View(notification);
}
[HttpPost]
public ActionResult Edit(Notification notification)
{
if (ModelState.IsValid)
{
_notificationRepository.Update(notification);
return RedirectToAction("Index");
}
return View(notification);
}
public ActionResult Delete(int id)
{
var notification = _notificationRepository.GetById(id);
return View(notification);
}
[HttpPost, ActionName("Delete")]
public ActionResult DeleteConfirmed(int id)
{
_notificationRepository.Delete(id);
return RedirectToAction("Index");
}
}
This completes the controller implementations for all the repositories. Each controller provides the necessary actions to handle CRUD operations and interact with the corresponding repository, allowing for a clean separation of concerns in your ASP.NET MVC application. You can now create views for each action to complete the functionality.
Creating views for each controller in an ASP.NET MVC application
Involves creating Razor view files that correspond to the actions in the controllers. Below, I will provide a basic structure for the views for each controller, including the Index, Details, Create, Edit, and Delete views.
User Views
Views/User/Index.cshtml
@model IEnumerable<YourNamespace.Models.User>
@{
ViewBag.Title = "Users";
}
<h2>Users</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table">
<thead>
<tr>
<th>Username</th>
<th>Email</th>
<th>First Name</th>
<th>Last Name</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var user in Model)
{
<tr>
<td>@user.Username</td>
<td>@user.Email</td>
<td>@user.FirstName</td>
<td>@user.LastName</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id = user.UserId }) |
@Html.ActionLink("Details", "Details", new { id = user.UserId }) |
@Html.ActionLink("Delete", "Delete", new { id = user.UserId })
</td>
</tr>
}
</tbody>
</table>
Views/User/Details.cshtml
@model YourNamespace.Models.User
@{
ViewBag.Title = "User Details";
}
<h2>User Details</h2>
<div>
<h4>User</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Username)
</dt>
<dd>
@Html.DisplayFor(model => model.Username)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Email)
</dt>
<dd>
@Html.DisplayFor(model => model.Email)
</dd>
<dt>
@Html.DisplayNameFor(model => model.FirstName)
</dt>
<dd>
@Html.DisplayFor(model => model.FirstName)
</dd>
<dt>
@Html.DisplayNameFor(model => model.LastName)
</dt>
<dd>
@Html.DisplayFor(model => model.LastName)
</dd>
</dl>
</div>
<div>
@Html.ActionLink("Edit", "Edit", new { id = Model.UserId }) |
@Html.ActionLink("Back to List", "Index")
</div>
Views/User/Create.cshtml
@model YourNamespace.Models.User
@{
ViewBag.Title = "Create User";
}
<h2>Create User</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>User</h4>
<hr />
<div class="form-group">
@Html.LabelFor(model => model.Username, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Username, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Username, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Email, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Email, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Email, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.FirstName, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.FirstName, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.FirstName, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.LastName, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.LastName, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.LastName, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
Views/User/Edit.cshtml
@model YourNamespace.Models.User
@{
ViewBag.Title = "Edit User";
}
<h2>Edit User</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>User</h4>
<hr />
<div class="form-group">
@Html.LabelFor(model => model.Username, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Username, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Username, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Email, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Email, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Email, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.FirstName, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.FirstName, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.FirstName, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.LastName, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.LastName, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.LastName, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
Views/User/Delete.cshtml
@model YourNamespace.Models.User
@{
ViewBag.Title = "Delete User";
}
<h2>Delete User</h2>
<div>
<h4>User</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Username)
</dt>
<dd>
@Html.DisplayFor(model => model.Username)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Email)
</dt>
<dd>
@Html.DisplayFor(model => model.Email)
</dd>
<dt>
@Html.DisplayNameFor(model => model.FirstName)
</dt>
<dd>
@Html.DisplayFor(model => model.FirstName)
</dd>
<dt>
@Html.DisplayNameFor(model => model.LastName)
</dt>
<dd>
@Html.DisplayFor(model => model.LastName)
</dd>
</dl>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div>
<input type="submit" value="Delete" class="btn btn-danger" />
@Html.ActionLink("Cancel", "Index")
</div>
}
Role Views
Views/Role/Index.cshtml
@model IEnumerable<YourNamespace.Models.Role>
@{
ViewBag.Title = "Roles";
}
<h2>Roles</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table">
<thead>
<tr>
<th>Role Name</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var role in Model)
{
<tr>
<td>@role.Name</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id = role.RoleId }) |
@Html.ActionLink("Details", "Details", new { id = role.RoleId }) |
@Html.ActionLink("Delete", "Delete", new { id = role.RoleId })
</td>
</tr>
}
</tbody>
</table>
Views/Role/Details.cshtml
@model YourNamespace.Models.Role
@{
ViewBag.Title = "Role Details";
}
<h2>Role Details</h2>
<div>
<h4>Role</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Name)
</dt>
<dd>
@Html.DisplayFor(model => model.Name)
</dd>
</dl>
</div>
<div>
@Html.ActionLink("Edit", "Edit", new { id = Model.RoleId }) |
@Html.ActionLink("Back to List", "Index")
</div>
Views/Role/Create.cshtml
@model YourNamespace.Models.Role
@{
ViewBag.Title = "Create Role";
}
<h2>Create Role</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Role</h4>
<hr />
<div class="form-group">
@Html.LabelFor(model => model.Name, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Name, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Name, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Role/Edit.cshtml
@model YourNamespace.Models.Role
@{
ViewBag.Title = "Edit Role";
}
<h2>Edit Role</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Role</h4>
<hr />
<div class="form-group">
@Html.LabelFor(model => model.Name, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Name, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Name, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Role/Delete.cshtml
@model YourNamespace.Models.Role
@{
ViewBag.Title = "Delete Role";
}
<h2>Delete Role</h2>
<div>
<h4>Role</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Name)
</dt>
<dd>
@Html.DisplayFor(model => model.Name)
</dd>
</dl>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div>
<input type="submit" value="Delete" class="btn btn-danger" />
@Html.ActionLink("Cancel", "Index")
</div>
}
Item Views
Views/Item/Index.cshtml
@model IEnumerable<YourNamespace.Models.Item>
@{
ViewBag.Title = "Items";
}
<h2>Items</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table">
<thead>
<tr>
<th>Item Name</th>
<th>Price</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var item in Model)
{
<tr>
<td>@item.Name</td>
<td>@item.Price</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id = item.ItemId }) |
@Html.ActionLink("Details", "Details", new { id = item.ItemId }) |
@Html.ActionLink("Delete", "Delete", new { id = item.ItemId })
</td>
</tr>
}
</tbody>
</table>
Views/Item/Details.cshtml
@model YourNamespace.Models.Item
@{
ViewBag.Title = "Item Details";
}
<h2>Item Details</h2>
<div>
<h4>Item</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Name)
</dt>
<dd>
@Html.DisplayFor(model => model.Name)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Price)
</dt>
<dd>
@Html.DisplayFor(model => model.Price)
</dd>
</dl>
</div>
<div>
@Html.ActionLink("Edit", "Edit", new { id = Model.ItemId }) |
@Html.ActionLink("Back to List", "Index")
</div>
Views/Item/Create.cshtml
@model YourNamespace.Models.Item
@{
ViewBag.Title = "Create Item";
}
<h2>Create Item</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Item</h4>
<hr />
<div class="form-group">
@Html.LabelFor(model => model.Name, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Name, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Name, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Price, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Price, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Price, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Item/Edit.cshtml
@model YourNamespace.Models.Item
@{
ViewBag.Title = "Edit Item";
}
<h2>Edit Item</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Item</h4>
<hr />
<div class="form-group">
@Html.LabelFor(model => model.Name, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Name, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Name, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Price, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Price, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Price, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Item/Delete.cshtml
@model YourNamespace.Models.Item
@{
ViewBag.Title = "Delete Item";
}
<h2>Delete Item</h2>
<div>
<h4>Item</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Name)
</dt>
<dd>
@Html.DisplayFor(model => model.Name)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Price)
</dt>
<dd>
@Html.DisplayFor(model => model.Price)
</dd>
</dl>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div>
<input type="submit" value="Delete" class="btn btn-danger" />
@Html.ActionLink("Cancel", "Index")
</div>
}
Bid Views
Views/Bid/Index.cshtml
@model IEnumerable<YourNamespace.Models.Bid>
@{
ViewBag.Title = "Bids";
}
<h2>Bids</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table">
<thead>
<tr>
<th>Bid Amount</th>
<th>Item</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var bid in Model)
{
<tr>
<td>@bid.Amount</td>
<td>@bid.Item.Name</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id = bid.BidId }) |
@Html.ActionLink("Details", "Details", new { id = bid.BidId }) |
@Html.ActionLink("Delete", "Delete", new { id = bid.BidId })
</td>
</tr>
}
</tbody>
</table>
Views/Bid/Details.cshtml
@model YourNamespace.Models.Bid
@{
ViewBag.Title = "Bid Details";
}
<h2>Bid Details</h2>
<div>
<h4>Bid</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Amount)
</dt>
<dd>
@Html.DisplayFor(model => model.Amount)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Item.Name)
</dt>
<dd>
@Html.DisplayFor(model => model.Item.Name)
</dd>
</dl>
</div>
<div>
@Html.ActionLink("Edit", "Edit", new { id = Model.BidId }) |
@Html.ActionLink("Back to List", "Index")
</div>
Views/Bid/Create.cshtml
@model YourNamespace.Models.Bid
@{
ViewBag.Title = "Create Bid";
}
<h2>Create Bid</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Bid</h4>
<hr />
<div class="form-group">
@Html.LabelFor(model => model.Amount, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Amount, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Amount, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.ItemId, "Item", htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.DropDownList("ItemId", null, "Select Item", new { @class = "form-control" })
@Html.ValidationMessageFor(model => model.ItemId, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Bid/Edit.cshtml
@model YourNamespace.Models.Bid
@{
ViewBag.Title = "Edit Bid";
}
<h2>Edit Bid</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4> Bid</h4>
<hr />
<div class="form-group">
@Html.LabelFor(model => model.Amount, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Amount, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Amount, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.ItemId, "Item", htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.DropDownList("ItemId", null, "Select Item", new { @class = "form-control" })
@Html.ValidationMessageFor(model => model.ItemId, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Bid/Delete.cshtml
@model YourNamespace.Models.Bid
@{
ViewBag.Title = "Delete Bid";
}
<h2>Delete Bid</h2>
<div>
<h4>Bid</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Amount)
</dt>
<dd>
@Html.DisplayFor(model => model.Amount)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Item.Name)
</dt>
<dd>
@Html.DisplayFor(model => model.Item.Name)
</dd>
</dl>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div>
<input type="submit" value="Delete" class="btn btn-danger" />
@Html.ActionLink("Cancel", "Index")
</div>
}
Payment Views
Views/Payment/Index.cshtml
@model IEnumerable<YourNamespace.Models.Payment>
@{
ViewBag.Title = "Payments";
}
<h2>Payments</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table">
<thead>
<tr>
<th>Amount</th>
<th>Date</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var payment in Model)
{
<tr>
<td>@payment.Amount</td>
<td>@payment.Date.ToShortDateString()</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id = payment.PaymentId }) |
@Html.ActionLink("Details", "Details", new { id = payment.PaymentId }) |
@Html.ActionLink("Delete", "Delete", new { id = payment.PaymentId })
</td>
</tr>
}
</tbody>
</table>
Views/Payment/Details.cshtml
@model YourNamespace.Models.Payment
@{
ViewBag.Title = "Payment Details";
}
<h2>Payment Details</h2>
<div>
<h4>Payment</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Amount)
</dt>
<dd>
@Html.DisplayFor(model => model.Amount)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Date)
</dt>
<dd>
@Html.DisplayFor(model => model.Date.ToShortDateString())
</dd>
</dl>
</div>
<div>
@Html.ActionLink("Edit", "Edit", new { id = Model.PaymentId }) |
@Html.ActionLink("Back to List", "Index")
</div>
Views/Payment/Create.cshtml
@model YourNamespace.Models.Payment
@{
ViewBag.Title = "Create Payment";
}
<h2>Create Payment</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Payment</h4>
<hr />
<div class="form-group">
@Html.LabelFor(model => model.Amount, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model .Amount, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Amount, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Date, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Date, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Date, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Payment/Edit.cshtml
@model YourNamespace.Models.Payment
@{
ViewBag.Title = "Edit Payment";
}
<h2>Edit Payment</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Payment</h4>
<hr />
<div class="form-group">
@Html.LabelFor(model => model.Amount, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Amount, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Amount, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Date, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Date, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Date, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Payment/Delete.cshtml
@model YourNamespace.Models.Payment
@{
ViewBag.Title = "Delete Payment";
}
<h2>Delete Payment</h2>
<div>
<h4>Payment</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Amount)
</dt>
<dd>
@Html.DisplayFor(model => model.Amount)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Date)
</dt>
<dd>
@Html.DisplayFor(model => model.Date.ToShortDateString())
</dd>
</dl>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div>
<input type="submit" value="Delete" class="btn btn-danger" />
@Html.ActionLink("Cancel", "Index")
</div>
}
Auction Views
Views/Auction/Index.cshtml
@model IEnumerable<YourNamespace.Models.Auction>
@{
ViewBag.Title = "Auctions";
}
<h2>Auctions</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table">
<thead>
<tr>
<th>Auction Name</th>
<th>Start Date</th>
<th>End Date</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var auction in Model)
{
<tr>
<td>@auction.Name</td>
<td>@auction.StartDate.ToShortDateString()</td>
<td>@auction.EndDate.ToShortDateString()</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id = auction.AuctionId }) |
@Html.ActionLink("Details", "Details", new { id = auction.AuctionId }) |
@Html.ActionLink("Delete", "Delete", new { id = auction.AuctionId })
</td>
</tr>
}
</tbody>
</table>
Views/Auction/Details.cshtml
@model YourNamespace.Models .Auction
@{
ViewBag.Title = "Auction Details";
}
<h2>Auction Details</h2>
<div>
<h4>Auction</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Name)
</dt>
<dd>
@Html.DisplayFor(model => model.Name)
</dd>
<dt>
@Html.DisplayNameFor(model => model.StartDate)
</dt>
<dd>
@Html.DisplayFor(model => model.StartDate.ToShortDateString())
</dd>
<dt>
@Html.DisplayNameFor(model => model.EndDate)
</dt>
<dd>
@Html.DisplayFor(model => model.EndDate.ToShortDateString())
</dd>
</dl>
</div>
<div>
@Html.ActionLink("Edit", "Edit", new { id = Model.AuctionId }) |
@Html.ActionLink("Back to List", "Index")
</div>
Views/Auction/Create.cshtml
@model YourNamespace.Models.Auction
@{
ViewBag.Title = "Create Auction";
}
<h2>Create Auction</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Auction</h4>
<hr />
<div class="form-group">
@Html.LabelFor(model => model.Name, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Name, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Name, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.StartDate, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.StartDate, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.StartDate, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.EndDate, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.EndDate, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.EndDate, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Auction/Edit.cshtml
@model YourNamespace.Models.Auction
@{
ViewBag.Title = "Edit Auction";
}
<h2>Edit Auction</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Auction</h4>
<hr />
<div class="form-group">
@Html.LabelFor(model => model.Name, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Name, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Name, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.StartDate, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.StartDate, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.StartDate, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.EndDate, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.EndDate, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.EndDate, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Auction/Delete.cshtml
@model YourNamespace.Models.Auction
@{
ViewBag.Title = "Delete Auction";
}
<h2>Delete Auction</h2>
<div>
<h4>Auction</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Name)
</dt>
<dd>
@Html.DisplayFor(model => model.Name)
</dd>
<dt>
@Html.DisplayNameFor(model => model.StartDate)
</dt>
<dd>
@Html.DisplayFor(model => model.StartDate.ToShortDateString())
</dd>
<dt>
@Html.DisplayNameFor(model => model.EndDate)
</dt>
<dd>
@Html.DisplayFor(model => model.EndDate.ToShortDateString())
</dd>
</dl>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div>
<input type="submit" value="Delete" class="btn btn-danger" />
@Html.ActionLink("Cancel", "Index")
</div>
}
AuctionType Views
Views/AuctionType/Index.cshtml
@model IEnumerable<YourNamespace.Models.AuctionType>
@{
ViewBag.Title = "Auction Types";
}
<h2>Auction Types</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table">
<thead>
<tr>
<th>Type Name</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var auctionType in Model)
{
<tr>
<td>@auctionType.Name</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id = auctionType.AuctionTypeId }) |
@Html.ActionLink("Details", "Details", new { id = auctionType.AuctionTypeId }) |
@Html.ActionLink("Delete", "Delete", new { id = auctionType.AuctionTypeId })
</td>
</tr>
}
</tbody>
</table>
Views/AuctionType/Details.cshtml
@model YourNamespace.Models.AuctionType
@{
ViewBag.Title = "Auction Type Details";
}
<h2>Auction Type Details</h2>
<div>
<h4>Auction Type</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Name)
</dt>
<dd>
@Html.DisplayFor(model => model.Name)
</dd>
</dl>
</div>
<div>
@Html.ActionLink("Edit", "Edit", new { id = Model.AuctionTypeId }) |
@Html.ActionLink("Back to List", "Index")
</div>
Views/AuctionType/Create.cshtml
@model YourNamespace.Models.AuctionType
@{
ViewBag.Title = "Create Auction Type";
}
<h2>Create Auction Type</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Auction Type</h4>
<hr />
<div class="form-group">
@Html.LabelFor(model => model.Name, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Name, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Name, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
Views/AuctionType/Edit.cshtml
@model YourNamespace.Models.AuctionType
@{
ViewBag.Title = "Edit Auction Type";
}
<h2>Edit Auction Type</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Auction Type</h4>
<hr />
<div class="form-group">
@Html.LabelFor(model => model.Name, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Name, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Name, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
Views/AuctionType/Delete.cshtml
@model YourNamespace.Models.AuctionType
@{
ViewBag.Title = "Delete Auction Type";
}
<h2>Delete Auction Type</h2>
<div>
<h4>Auction Type</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Name)
</dt>
<dd>
@Html.DisplayFor(model => model.Name)
</dd>
</dl>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div>
<input type="submit" value="Delete" class="btn btn-danger" />
@Html.ActionLink("Cancel", "Index")
</div>
}
Report Views
Views/Report/Index.cshtml
@model IEnumerable<YourNamespace.Models.Report>
@{
ViewBag.Title = "Reports";
}
<h2>Reports</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table">
<thead>
<tr>
<th>Report Title</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var report in Model)
{
<tr>
<td>@report.Title</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id = report.ReportId }) |
@Html .ActionLink("Details", "Details", new { id = report.ReportId }) |
@Html.ActionLink("Delete", "Delete", new { id = report.ReportId })
</td>
</tr>
}
</tbody>
</table>
Views/Report/Details.cshtml
@model YourNamespace.Models.Report
@{
ViewBag.Title = "Report Details";
}
<h2>Report Details</h2>
<div>
<h4>Report</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Title)
</dt>
<dd>
@Html.DisplayFor(model => model.Title)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Content)
</dt>
<dd>
@Html.DisplayFor(model => model.Content)
</dd>
</dl>
</div>
<div>
@Html.ActionLink("Edit", "Edit", new { id = Model.ReportId }) |
@Html.ActionLink("Back to List", "Index")
</div>
Views/Report/Create.cshtml
@model YourNamespace.Models.Report
@{
ViewBag.Title = "Create Report";
}
<h2>Create Report</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Report</h4>
<hr />
<div class="form-group">
@Html.LabelFor(model => model.Title, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Title, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Title, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Content, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.TextAreaFor(model => model.Content, new { @class = "form-control" })
@Html.ValidationMessageFor(model => model.Content, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Report/Edit.cshtml
@model YourNamespace.Models.Report
@{
ViewBag.Title = "Edit Report";
}
<h2>Edit Report</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Report</h4>
<hr />
<div class="form-group">
@Html.LabelFor(model => model.Title, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Title, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Title, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Content, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.TextAreaFor(model => model.Content, new { @class = "form-control" })
@Html.ValidationMessageFor(model => model.Content, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Report/Delete.cshtml
@model YourNamespace.Models.Report
@{
ViewBag.Title = "Delete Report";
}
<h2>Delete Report</h2>
<div>
<h4>Report</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Title)
</dt>
<dd>
@Html.DisplayFor(model => model.Title)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Content)
</dt>
<dd>
@Html .DisplayFor(model => model.Content)
</dd>
</dl>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div>
<input type="submit" value="Delete" class="btn btn-danger" />
@Html.ActionLink("Cancel", "Index")
</div>
}
Feedback Views
Views/Feedback/Index.cshtml
@model IEnumerable<YourNamespace.Models.Feedback>
@{
ViewBag.Title = "Feedbacks";
}
<h2>Feedbacks</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table">
<thead>
<tr>
<th>Feedback Content</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var feedback in Model)
{
<tr>
<td>@feedback.Content</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id = feedback.FeedbackId }) |
@Html.ActionLink("Details", "Details", new { id = feedback.FeedbackId }) |
@Html.ActionLink("Delete", "Delete", new { id = feedback.FeedbackId })
</td>
</tr>
}
</tbody>
</table>
Views/Feedback/Details.cshtml
@model YourNamespace.Models.Feedback
@{
ViewBag.Title = "Feedback Details";
}
<h2>Feedback Details</h2>
<div>
<h4>Feedback</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Content)
</dt>
<dd>
@Html.DisplayFor(model => model.Content)
</dd>
</dl>
</div>
<div>
@Html.ActionLink("Edit", "Edit", new { id = Model.FeedbackId }) |
@Html.ActionLink("Back to List", "Index")
</div>
Views/Feedback/Create.cshtml
@model YourNamespace.Models.Feedback
@{
ViewBag.Title = "Create Feedback";
}
<h2>Create Feedback</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Feedback</h4>
<hr />
<div class="form-group">
@Html.LabelFor(model => model.Content, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.TextAreaFor(model => model.Content, new { @class = "form-control" })
@Html.ValidationMessageFor(model => model.Content, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Feedback/Edit.cshtml
@model YourNamespace.Models.Feedback
@{
ViewBag.Title = "Edit Feedback";
}
<h2>Edit Feedback</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Feedback</h4>
<hr />
<div class="form-group">
@Html.LabelFor(model => model.Content, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.TextAreaFor(model => model.Content, new { @class = "form-control" })
@Html.ValidationMessageFor(model => model.Content, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Feedback/Delete.cshtml
@model YourNamespace.Models.Feedback
@{
ViewBag.Title = "Delete Feedback";
}
<h2>Delete Feedback</h2>
<div>
<h4>Feedback</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Content)
</dt>
<dd>
@Html.DisplayFor(model => model.Content)
</dd>
</dl>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div>
<input type="submit" value="Delete" class="btn btn-danger" />
@Html.ActionLink("Cancel", "Index")
</div>
}
Notification Views
Views/Notification/Index.cshtml
@model IEnumerable<YourNamespace.Models.Notification>
@{
ViewBag.Title = "Notifications";
}
<h2>Notifications</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table">
<thead>
<tr>
<th>Notification Message</th>
<th>Date</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var notification in Model)
{
<tr>
<td>@notification.Message</td>
<td>@notification.Date.ToShortDateString()</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id = notification.NotificationId }) |
@Html.ActionLink("Details", "Details", new { id = notification.NotificationId }) |
@Html.ActionLink("Delete", "Delete", new { id = notification.NotificationId })
</td>
</tr>
}
</tbody>
</table>
Views/Notification/Details.cshtml
@model YourNamespace.Models.Notification
@{
ViewBag.Title = "Notification Details";
}
<h2>Notification Details</h2>
<div>
<h4>Notification</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Message)
</dt>
<dd>
@Html.DisplayFor(model => model.Message)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Date)
</dt>
<dd>
@Html.DisplayFor(model => model.Date.ToShortDateString())
</dd>
</dl>
</div>
<div>
@Html.ActionLink("Edit", "Edit", new { id = Model.NotificationId }) |
@Html.ActionLink("Back to List", "Index")
</div>
Views/Notification/Create.cshtml
@model YourNamespace.Models.Notification
@{
ViewBag.Title = "Create Notification";
}
<h2>Create Notification</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Notification</h4>
<hr />
<div class="form-group">
@Html.LabelFor(model => model.Message, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.TextAreaFor(model => model.Message, new { @class = "form-control" })
@Html.ValidationMessageFor(model => model.Message, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Notification/Edit.cshtml
@model YourNamespace.Models.Notification
@{
ViewBag.Title = "Edit Notification";
}
<h2>Edit Notification</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>Notification</h4>
<hr />
<div class="form-group">
@Html.LabelFor(model => model.Message, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.TextAreaFor(model => model.Message, new { @class = "form-control" })
@Html.ValidationMessageFor(model => model.Message, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
Views/Notification/Delete.cshtml
@model YourNamespace.Models.Notification
@{
ViewBag.Title = "Delete Notification";
}
<h2>Delete Notification</h2>
<div>
<h4>Notification</h4>
<hr />
<dl class="dl-horizontal">
<dt>
@Html.DisplayNameFor(model => model.Message)
</dt>
<dd>
@Html.DisplayFor(model => model.Message)
</dd>
<dt>
@Html.DisplayNameFor(model => model.Date)
</dt>
<dd>
@Html.DisplayFor(model => model.Date.ToShortDateString())
</dd>
</dl>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div>
<input type="submit" value="Delete" class="btn btn-danger" />
@Html.ActionLink("Cancel", "Index")
</div>
}
This completes the view implementations for all the controllers
Each view provides the necessary UI to perform CRUD operations for the respective models, allowing users to interact with the application effectively. You can further customize the styles and layouts as needed to fit your application's design.
Creating a dashboard page in an ASP.NET MVC application
Involves aggregating data from various models and presenting it in a user-friendly format. Below, I will outline how to create a simple dashboard that displays consolidated data related to your project, such as the number of users, roles, items, bids, payments, auctions, auction types, reports, feedback, and notifications.
Step 1: Create a Dashboard ViewModel
First, create a ViewModel that will hold the consolidated data for the dashboard.
ViewModels/DashboardViewModel.cs
namespace YourNamespace.ViewModels
{
public class DashboardViewModel
{
public int UserCount { get; set; }
public int RoleCount { get; set; }
public int ItemCount { get; set; }
public int BidCount { get; set; }
public int PaymentCount { get; set; }
public int AuctionCount { get; set; }
public int AuctionTypeCount { get; set; }
public int ReportCount { get; set; }
public int FeedbackCount { get; set; }
public int NotificationCount { get; set; }
}
}
Step 2: Create the Dashboard Controller
Next, create a controller that will fetch the data and pass it to the dashboard view.
Controllers/DashboardController.cs
using System.Web.Mvc;
using YourNamespace.Models; // Include your models
using YourNamespace.ViewModels; // Include your ViewModels
public class DashboardController : Controller
{
private readonly UserRepository _userRepository;
private readonly RoleRepository _roleRepository;
private readonly ItemRepository _itemRepository;
private readonly BidRepository _bidRepository;
private readonly PaymentRepository _paymentRepository;
private readonly AuctionRepository _auctionRepository;
private readonly AuctionTypeRepository _auctionTypeRepository;
private readonly ReportRepository _reportRepository;
private readonly FeedbackRepository _feedbackRepository;
private readonly NotificationRepository _notificationRepository;
public DashboardController()
{
// Initialize repositories with your connection string
_userRepository = new UserRepository("YourConnectionStringHere");
_roleRepository = new RoleRepository("YourConnectionStringHere");
_itemRepository = new ItemRepository("YourConnectionStringHere");
_bidRepository = new BidRepository("YourConnectionStringHere");
_paymentRepository = new PaymentRepository("YourConnectionStringHere");
_auctionRepository = new AuctionRepository("YourConnectionStringHere");
_auctionTypeRepository = new AuctionTypeRepository("YourConnectionStringHere");
_reportRepository = new ReportRepository("YourConnectionStringHere");
_feedbackRepository = new FeedbackRepository("YourConnectionStringHere");
_notificationRepository = new NotificationRepository("YourConnectionStringHere");
}
public ActionResult Index()
{
var dashboardViewModel = new DashboardViewModel
{
UserCount = _userRepository.GetAll().Count(),
RoleCount = _roleRepository.GetAll().Count(),
ItemCount = _itemRepository.GetAll().Count(),
BidCount = _bidRepository.GetAll().Count(),
PaymentCount = _paymentRepository.GetAll().Count(),
AuctionCount = _auctionRepository.GetAll().Count(),
AuctionTypeCount = _auctionTypeRepository.GetAll().Count(),
ReportCount = _reportRepository.GetAll().Count(),
FeedbackCount = _feedbackRepository.GetAll().Count(),
NotificationCount = _notificationRepository.GetAll().Count()
};
return View(dashboardViewModel);
}
}
Step 3: Create the Dashboard View
Now, create a view that will display the dashboard data.
Views/Dashboard/Index.cshtml
@model YourNamespace.ViewModels.DashboardViewModel
@{
ViewBag.Title = "Dashboard";
}
<h2>Dashboard</h2>
<div class="row">
<div class="col-md-3">
<div class="panel panel-default">
<div class="panel-heading">Users</div>
<div class="panel-body">
<h3>@Model.UserCount</h3>
</div>
</div>
</div>
<div class="col-md-3">
<div class="panel panel-default">
<div class="panel-heading">Roles</div>
<div class="panel-body">
<h3>@Model.RoleCount</h3>
</div>
</div>
</div>
<div class="col-md-3">
<div class="panel panel-default">
<div class="panel-heading">Items</div>
<div class="panel-body">
<h3>@Model.ItemCount</h3>
</div>
</div>
</div>
<div class="col-md-3">
<div class="panel panel-default">
<div class="panel-heading">Bids</div>
<div class="panel-body">
<h3>@Model.BidCount</h3>
</div>
</div>
</div>
</div>
<div class="row">
<div class="col-md-3">
<div class="panel panel-default">
<div class="panel-heading">Payments</div>
<div class="panel-body">
<h3>@Model.PaymentCount</h3>
</div>
</div>
</div>
<div class="col-md-3">
<div class="panel panel-default">
<div class="panel-heading">Auctions</div>
<div class="panel-body">
<h3>@Model.AuctionCount</h3>
</div>
</div>
</div>
<div class="col-md-3">
<div class="panel panel-default">
<div class="panel-heading">Auction Types</div>
<div class="panel-body">
<h3>@Model.AuctionTypeCount</h3>
</div>
</div>
</div>
<div class="col-md-3">
<div class="panel panel-default">
<div class="panel-heading">Reports</div>
<div class="panel-body">
<h3>@Model.ReportCount</h3>
</div>
</div>
</div>
</div>
<div class="row">
<div class="col-md-3">
<div class="panel panel-default">
<div class="panel-heading">Feedback</div>
<div class="panel-body">
<h3>@Model.FeedbackCount</h3>
</div>
</div>
</div>
<div class="col-md-3">
<div class="panel panel-default">
<div class="panel-heading">Notifications</div>
<div class="panel-body">
<h3>@Model.NotificationCount</h3>
</div>
</div>
</div>
</div>
Step 4: Update the Route Configuration
Make sure to add a route for the dashboard in your RouteConfig.cs file if necessary.
routes.MapRoute(
name: "Dashboard",
url: "Dashboard",
defaults: new { controller = "Dashboard", action = "Index" }
);
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