Project Introduction
The Library Management System is designed to facilitate the management of library resources, including books, digital resources, and user memberships. Built using ASP.NET and SQL Server, this application aims to streamline library operations by providing a comprehensive platform for managing user accounts, book circulation, reservations, and events. The system will allow librarians to efficiently track inventory, manage memberships, and handle user feedback, ultimately enhancing the overall library experience for patrons.
Project Objectives
- To create a secure user authentication system for managing user accounts and roles.
- To enable users to search for and access physical and digital library resources.
- To manage book circulation, including checkouts, returns, and due dates.
- To facilitate reservations for books and other resources.
- To maintain accurate inventory records for all library items.
- To manage user memberships and track their status and benefits.
- To provide a platform for interlibrary loans to expand resource availability.
- To organize library events and manage registrations for attendees.
- To collect and analyze user feedback to improve library services.
Project Modules
- User Management Module: Handles user registration, login, and role management.
- Book Management Module: Manages the addition, editing, and deletion of books in the library.
- Catalog Management Module: Facilitates the management of catalog items and their statuses.
- Circulation Management Module: Tracks checkouts, returns, and due dates for library items.
- Reservation Management Module: Allows users to reserve books and resources.
- Inventory Management Module: Maintains records of inventory items and their quantities.
- Membership Management Module: Manages user memberships and their associated benefits.
- Digital Resources Module: Manages digital resources such as eBooks and audiobooks.
- Interlibrary Loan Module: Facilitates loans between libraries for resource sharing.
- Event Management Module: Organizes library events and manages attendee registrations.
- Feedback Management Module: Collects and analyzes user feedback to enhance library services.
SQL Server Database Tables
-- Create Users Table
CREATE TABLE Users (
UserId INT PRIMARY KEY IDENTITY(1,1),
Username NVARCHAR(50) NOT NULL UNIQUE,
PasswordHash NVARCHAR(256) NOT NULL,
Email NVARCHAR(100) NOT NULL UNIQUE,
RoleId INT,
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (RoleId) REFERENCES Roles(RoleId)
);
-- Create Roles Table
CREATE TABLE Roles (
RoleId INT PRIMARY KEY IDENTITY(1,1),
RoleName NVARCHAR(50) NOT NULL UNIQUE
);
-- Create Books Table
CREATE TABLE Books (
BookId INT PRIMARY KEY IDENTITY(1,1),
Title NVARCHAR(200) NOT NULL,
Author NVARCHAR(100) NOT NULL,
ISBN NVARCHAR(20) NOT NULL UNIQUE,
Publisher NVARCHAR(100),
PublishedDate DATE,
Category NVARCHAR(100),
CopiesAvailable INT NOT NULL,
CreatedAt DATETIME DEFAULT GETDATE()
);
-- Create CatalogItems Table
CREATE TABLE CatalogItems (
CatalogItemId INT PRIMARY KEY IDENTITY(1,1),
BookId INT,
Location NVARCHAR(100),
Status NVARCHAR(50) NOT NULL, -- e.g., Available, Checked Out
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (BookId) REFERENCES Books(BookId)
);
-- Create CirculationRecords Table
CREATE TABLE CirculationRecords (
CirculationRecordId INT PRIMARY KEY IDENTITY(1,1),
UserId INT,
CatalogItemId INT,
CheckoutDate DATETIME NOT NULL,
DueDate DATETIME NOT NULL,
ReturnDate DATETIME,
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId),
FOREIGN KEY (CatalogItemId) REFERENCES CatalogItems(CatalogItemId)
);
-- Create Reservations Table
CREATE TABLE Reservations (
ReservationId INT PRIMARY KEY IDENTITY(1,1),
UserId INT,
CatalogItemId INT,
ReservationDate DATETIME NOT NULL,
ExpirationDate DATETIME NOT NULL,
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId),
FOREIGN KEY (CatalogItemId) REFERENCES CatalogItems(CatalogItemId)
);
-- Create InventoryItems Table
CREATE TABLE InventoryItems (
InventoryItemId INT PRIMARY KEY IDENTITY(1,1),
BookId INT,
Quantity INT NOT NULL,
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (BookId) REFERENCES Books(BookId)
);
-- Create Memberships Table
CREATE TABLE Memberships (
MembershipId INT PRIMARY KEY IDENTITY(1,1),
UserId INT,
MembershipType NVARCHAR(50) NOT NULL, -- e.g., Regular, Premium
StartDate DATE NOT NULL,
ExpirationDate DATE NOT NULL,
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId)
);
-- Create DigitalResources Table
CREATE TABLE DigitalResources (
DigitalResourceId INT PRIMARY KEY IDENTITY(1,1),
Title NVARCHAR(200) NOT NULL,
ResourceType NVARCHAR(50) NOT NULL, -- e.g., eBook, Audiobook
URL NVARCHAR(256) NOT NULL,
CreatedAt DATETIME DEFAULT GETDATE()
);
-- Create InterlibraryLoans Table
CREATE TABLE InterlibraryLoans (
InterlibraryLoanId INT PRIMARY KEY IDENTITY(1,1),
UserId INT,
BookId INT,
LoanDate DATETIME NOT NULL,
DueDate DATETIME NOT NULL,
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId),
FOREIGN KEY (BookId) REFERENCES Books(BookId)
);
-- Create Events Table
CREATE TABLE Events (
EventId INT PRIMARY KEY IDENTITY(1,1),
Title NVARCHAR(100) NOT NULL,
Description NVARCHAR(MAX),
EventDate DATETIME NOT NULL,
CreatedAt DATETIME DEFAULT GETDATE()
);
-- Create Feedback Table
CREATE TABLE Feedback (
FeedbackId INT PRIMARY KEY IDENTITY(1,1),
UserId INT,
Comments NVARCHAR(MAX),
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId)
);
Explanation of the Tables
Users: Stores user information, including username, password hash, email, and role.
Roles: Defines user roles (e.g., Admin, Librarian, Member).
Books: Contains book details, including title, author, ISBN, publisher, published date, category, and available copies.
CatalogItems: Manages catalog items, linking books to their physical locations and status (e.g., available, checked out).
CirculationRecords: Tracks the checkout and return of catalog items by users, including due dates and return dates.
Reservations: Contains reservation details for catalog items, including user information and expiration dates.
InventoryItems: Manages the inventory of books, tracking the quantity available in the library.
Memberships: Stores membership information for users, including membership type and validity dates.
DigitalResources: Contains information about digital resources available in the library, including type and URL.
InterlibraryLoans: Tracks loans of books from other libraries, including loan and due dates.
Events: Manages events organized by the library, including title, description, and date.
Feedback: Stores feedback from users, allowing them to provide comments on library services.
To create models and repositories using ADO.NET for your Library Management System
We will follow these steps:
Create Models
Define C# classes that represent the database tables.
//Models/User.cs
public class User
{
public int UserId { get; set; }
public string Username { get; set; }
public string PasswordHash { get; set; }
public string Email { get; set; }
public int RoleId { get; set; }
public DateTime CreatedAt { get; set; }
}
//Models/Role.cs
public class Role
{
public int RoleId { get; set; }
public string RoleName { get; set; }
}
//Models/Book.cs
public class Book
{
public int BookId { get; set; }
public string Title { get; set; }
public string Author { get; set; }
public string ISBN { get; set; }
public string Publisher { get; set; }
public DateTime? PublishedDate { get; set; }
public string Category { get; set; }
public int CopiesAvailable { get; set; }
public DateTime CreatedAt { get; set; }
}
//Models/CatalogItem.cs
public class CatalogItem
{
public int CatalogItemId { get; set; }
public int BookId { get; set; }
public string Location { get; set; }
public string Status { get; set; }
public DateTime CreatedAt { get; set; }
}
//Models/CirculationRecord.cs
public class CirculationRecord
{
public int CirculationRecordId { get; set; }
public int UserId { get; set; }
public int CatalogItemId { get; set; }
public DateTime CheckoutDate { get; set; }
public DateTime DueDate { get; set; }
public DateTime? ReturnDate { get; set; }
public DateTime CreatedAt { get; set; }
}
//Models/Reservation.cs
public class Reservation
{
public int ReservationId { get; set; }
public int UserId { get; set; }
public int CatalogItemId { get; set; }
public DateTime ReservationDate { get; set; }
public DateTime ExpirationDate { get; set; }
public DateTime CreatedAt { get; set; }
}
//Models/InventoryItem.cs
public class InventoryItem
{
public int InventoryItemId { get; set; }
public int BookId { get; set; }
public int Quantity { get; set; }
public DateTime CreatedAt { get; set; }
}
//Models/Membership.cs
public class Membership
{
public int MembershipId { get; set; }
public int UserId { get; set; }
public string MembershipType { get; set; }
public DateTime StartDate { get; set; }
public DateTime ExpirationDate { get; set; }
public DateTime CreatedAt { get; set; }
}
//Models/DigitalResource.cs
public class DigitalResource
{
public int DigitalResourceId { get; set; }
public string Title { get; set; }
public string ResourceType { get; set; }
public string URL { get; set; }
public DateTime CreatedAt { get; set; }
}
//Models/InterlibraryLoan.cs
public class InterlibraryLoan
{
public int InterlibraryLoanId { get; set; }
public int UserId { get; set; }
public int BookId { get; set; }
public DateTime LoanDate { get; set; }
public DateTime DueDate { get; set; }
public DateTime CreatedAt { get; set; }
}
//Models/Event.cs
public class Event
{
public int EventId { get; set; }
public string Title { get; set; }
public string Description { get; set; }
public DateTime EventDate { get; set; }
public DateTime CreatedAt { get; set; }
}
//Models/Feedback.cs
public class Feedback
{
public int FeedbackId { get; set; }
public int UserId { get; set; }
public string Comments { get; set; }
public DateTime CreatedAt { get; set; }
}
Create Repositories
Now, let's create repository classes for each model using ADO.NET.
Repositories/UserRepository.cs
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
public class UserRepository
{
private readonly string _connectionString;
public UserRepository(string connectionString)
{
_connectionString = connectionString;
}
public void AddUser (User user)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Users (Username, PasswordHash, Email, RoleId) VALUES (@Username, @PasswordHash, @Email, @RoleId)", connection);
command.Parameters.AddWithValue("@Username", user.Username);
command.Parameters.AddWithValue("@PasswordHash", user.PasswordHash);
command.Parameters.AddWithValue("@Email", user.Email);
command.Parameters.AddWithValue("@RoleId", user.RoleId);
connection.Open();
command.ExecuteNonQuery();
}
}
public User GetUser ById(int userId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Users WHERE UserId = @User Id", connection);
command.Parameters.AddWithValue("@User Id", userId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new User
{
UserId = (int)reader["User Id"],
Username = reader["Username"].ToString(),
PasswordHash = reader["PasswordHash"].ToString(),
Email = reader["Email"].ToString(),
RoleId = (int)reader["RoleId"],
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return null;
}
public List<User> GetAllUsers()
{
var users = new List<User>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Users", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
users.Add(new User
{
UserId = (int)reader["User Id"],
Username = reader["Username"].ToString(),
PasswordHash = reader["PasswordHash"].ToString(),
Email = reader["Email"].ToString(),
RoleId = (int)reader["RoleId"],
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return users;
}
public void UpdateUser (User user)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Users SET Username = @Username, PasswordHash = @PasswordHash, Email = @Email, RoleId = @RoleId WHERE UserId = @User Id", connection);
command.Parameters.AddWithValue("@User Id", user.UserId);
command.Parameters.AddWithValue("@Username", user.Username);
command.Parameters.AddWithValue("@PasswordHash", user.PasswordHash);
command.Parameters.AddWithValue("@Email", user.Email);
command.Parameters.AddWithValue("@RoleId", user.RoleId);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteUser (int userId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Users WHERE UserId = @User Id", connection);
command.Parameters.AddWithValue("@User Id", userId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Repositories/RoleRepository.cs
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
public class RoleRepository
{
private readonly string _connectionString;
public RoleRepository(string connectionString)
{
_connectionString = connectionString;
}
public void AddRole(Role role)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Roles (RoleName) VALUES (@RoleName)", connection);
command.Parameters.AddWithValue("@RoleName", role.RoleName);
connection.Open();
command.ExecuteNonQuery();
}
}
public Role GetRoleById(int roleId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Roles WHERE RoleId = @RoleId", connection);
command.Parameters.AddWithValue("@RoleId", roleId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Role
{
RoleId = (int)reader["RoleId"],
RoleName = reader["RoleName"].ToString()
};
}
}
}
return null;
}
public List<Role> GetAllRoles()
{
var roles = new List<Role>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Roles", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
roles.Add(new Role
{
RoleId = (int)reader["RoleId"],
RoleName = reader["RoleName"].ToString()
});
}
}
}
return roles;
}
public void UpdateRole(Role role)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Roles SET RoleName = @RoleName WHERE RoleId = @RoleId", connection);
command.Parameters.AddWithValue("@RoleId", role.RoleId);
command.Parameters.AddWithValue("@RoleName", role.RoleName);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteRole(int roleId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Roles WHERE RoleId = @RoleId", connection);
command.Parameters.AddWithValue("@RoleId", roleId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Repositories/BookRepository.cs
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
public class BookRepository
{
private readonly string _connectionString;
public BookRepository(string connectionString)
{
_connectionString = connectionString;
}
public void AddBook(Book book)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Books (Title, Author, ISBN, Publisher, PublishedDate, Category, CopiesAvailable) VALUES (@Title, @Author, @ISBN, @Publisher, @PublishedDate, @Category, @CopiesAvailable)", connection);
command.Parameters.AddWithValue("@Title", book.Title);
command.Parameters.AddWithValue("@Author", book.Author);
command.Parameters.AddWithValue("@ISBN", book.ISBN);
command.Parameters.AddWithValue("@Publisher", book.Publisher);
command.Parameters.AddWithValue("@PublishedDate", (object)book.PublishedDate ?? DBNull.Value);
command.Parameters.AddWithValue("@Category", book.Category);
command.Parameters.AddWithValue("@CopiesAvailable", book.CopiesAvailable);
connection.Open();
command.ExecuteNonQuery();
}
}
public Book GetBookById(int bookId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Books WHERE BookId = @BookId", connection);
command.Parameters.AddWithValue("@BookId", bookId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Book
{
BookId = (int)reader["BookId"],
Title = reader["Title"].ToString(),
Author = reader["Author"].ToString(),
ISBN = reader["ISBN"].ToString(),
Publisher = reader["Publisher"].ToString(),
PublishedDate = reader["PublishedDate"] as DateTime?,
Category = reader["Category"].ToString(),
CopiesAvailable = (int)reader["CopiesAvailable"],
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return null;
}
public List<Book> GetAllBooks()
{
var books = new List<Book>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Books", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
books.Add(new Book
{
BookId = (int)reader["BookId"],
Title = reader["Title"].ToString(),
Author = reader["Author"].ToString(),
ISBN = reader["ISBN"].ToString(),
Publisher = reader["Publisher"].ToString(),
PublishedDate = reader["PublishedDate"] as DateTime?,
Category = reader["Category"].ToString(),
CopiesAvailable = (int)reader["CopiesAvailable"],
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return books;
}
public void UpdateBook(Book book)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Books SET Title = @Title, Author = @Author, ISBN = @ISBN, Publisher = @Publisher, PublishedDate = @PublishedDate, Category = @Category, CopiesAvailable = @CopiesAvailable WHERE BookId = @BookId", connection);
command.Parameters.AddWithValue("@BookId", book.BookId);
command.Parameters.AddWithValue("@Title", book.Title);
command.Parameters.AddWithValue("@Author", book.Author);
command.Parameters.AddWithValue("@ISBN", book.ISBN);
command.Parameters.AddWithValue("@Publisher", book.Publisher);
command.Parameters.AddWithValue("@PublishedDate", (object)book.PublishedDate ?? DBNull.Value);
command.Parameters.AddWithValue("@Category", book.Category);
command.Parameters.AddWithValue("@CopiesAvailable", book.CopiesAvailable);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteBook(int bookId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Books WHERE BookId = @BookId", connection);
command.Parameters.AddWithValue("@BookId", bookId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Repositories/CatalogItemRepository.cs
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
public class CatalogItemRepository
{
private readonly string _connectionString;
public CatalogItemRepository(string connectionString)
{
_connectionString = connectionString;
}
public void AddCatalogItem(CatalogItem catalogItem)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO CatalogItems (BookId, Location, Status) VALUES (@BookId, @Location, @Status)", connection);
command.Parameters.AddWithValue("@BookId", catalogItem.BookId);
command.Parameters.AddWithValue("@Location", catalogItem.Location);
command.Parameters.AddWithValue("@Status", catalogItem.Status);
connection.Open();
command.ExecuteNonQuery();
}
}
public CatalogItem GetCatalogItemById(int catalogItemId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM CatalogItems WHERE CatalogItemId = @CatalogItemId", connection);
command.Parameters.AddWithValue("@CatalogItemId", catalogItemId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new CatalogItem
{
CatalogItemId = (int)reader["CatalogItemId"],
BookId = (int)reader["BookId"],
Location = reader["Location"].ToString(),
Status = reader["Status"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return null;
}
public List<CatalogItem> GetAllCatalogItems()
{
var catalogItems = new List<CatalogItem>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM CatalogItems", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
catalogItems.Add(new CatalogItem
{
CatalogItemId = (int)reader["CatalogItemId"],
BookId = (int)reader["BookId"],
Location = reader["Location"].ToString(),
Status = reader["Status"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return catalogItems;
}
public void UpdateCatalogItem(CatalogItem catalogItem)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE CatalogItems SET BookId = @BookId, Location = @Location, Status = @Status WHERE CatalogItemId = @CatalogItemId", connection);
command.Parameters.AddWithValue("@CatalogItemId", catalogItem.CatalogItemId);
command.Parameters.AddWithValue("@BookId", catalogItem.BookId);
command.Parameters.AddWithValue("@Location", catalogItem.Location);
command.Parameters.AddWithValue("@Status", catalogItem.Status);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteCatalogItem(int catalogItemId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM CatalogItems WHERE CatalogItemId = @CatalogItemId", connection);
command.Parameters.AddWithValue("@CatalogItemId", catalogItemId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Repositories/CirculationRecordRepository.cs
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
public class CirculationRecordRepository
{
private readonly string _connectionString;
public CirculationRecordRepository(string connectionString)
{
_connectionString = connectionString;
}
public void AddCirculationRecord(CirculationRecord circulationRecord)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO CirculationRecords (User Id, CatalogItemId, CheckoutDate, DueDate) VALUES (@User Id, @CatalogItemId, @CheckoutDate, @DueDate)", connection);
command.Parameters.AddWithValue("@User Id", circulationRecord.UserId);
command.Parameters.AddWithValue("@CatalogItemId", circulationRecord.CatalogItemId);
command.Parameters.AddWithValue("@CheckoutDate", circulationRecord.CheckoutDate);
command.Parameters.AddWithValue("@DueDate", circulationRecord.DueDate);
connection.Open();
command.ExecuteNonQuery();
}
}
public CirculationRecord GetCirculationRecordById(int circulationRecordId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM CirculationRecords WHERE CirculationRecordId = @CirculationRecordId", connection);
command.Parameters.AddWithValue("@CirculationRecordId", circulationRecordId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new CirculationRecord
{
CirculationRecordId = (int)reader["CirculationRecordId"],
UserId = (int)reader["User Id"],
CatalogItemId = (int)reader["CatalogItemId"],
CheckoutDate = (DateTime)reader["CheckoutDate"],
DueDate = (DateTime)reader["DueDate"],
ReturnDate = reader["ReturnDate"] as DateTime?,
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return null;
}
public List<CirculationRecord> GetAllCirculationRecords()
{
var circulationRecords = new List<CirculationRecord>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM CirculationRecords", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
circulationRecords.Add(new CirculationRecord
{
CirculationRecordId = (int)reader["CirculationRecordId"],
UserId = (int)reader["User Id"],
CatalogItemId = (int)reader["CatalogItemId"],
CheckoutDate = (DateTime)reader["CheckoutDate"],
DueDate = (DateTime)reader["DueDate"],
ReturnDate = reader["ReturnDate"] as DateTime?,
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return circulationRecords;
}
public void UpdateCirculationRecord(CirculationRecord circulationRecord)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE CirculationRecords SET UserId = @User Id, CatalogItemId = @CatalogItemId, CheckoutDate = @CheckoutDate, DueDate = @DueDate, ReturnDate = @ReturnDate WHERE CirculationRecordId = @CirculationRecordId", connection);
command.Parameters.AddWithValue("@CirculationRecordId", circulationRecord.CirculationRecordId);
command.Parameters.AddWithValue("@User Id", circulationRecord.UserId);
command.Parameters.AddWithValue("@CatalogItemId", circulationRecord.CatalogItemId);
command.Parameters.AddWithValue("@CheckoutDate", circulationRecord.CheckoutDate);
command.Parameters.AddWithValue("@DueDate", circulationRecord.DueDate);
command.Parameters.AddWithValue("@ReturnDate", (object)circulationRecord.ReturnDate ?? DBNull.Value);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteCirculationRecord(int circulationRecordId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM CirculationRecords WHERE CirculationRecordId = @CirculationRecordId", connection);
command.Parameters.AddWithValue("@CirculationRecordId", circulationRecordId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Repositories/ReservationRepository.cs
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
public class ReservationRepository
{
private readonly string _connectionString;
public ReservationRepository(string connectionString)
{
_connectionString = connectionString;
}
public void AddReservation(Reservation reservation)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Reservations (User Id, CatalogItemId, ReservationDate, ExpirationDate) VALUES (@User Id, @CatalogItemId, @ReservationDate, @ExpirationDate)", connection);
command.Parameters.AddWithValue("@User Id", reservation.UserId);
command.Parameters.AddWithValue("@CatalogItemId", reservation.CatalogItemId);
command.Parameters.AddWithValue("@ReservationDate", reservation.ReservationDate);
command.Parameters.AddWithValue("@ExpirationDate", reservation.ExpirationDate);
connection.Open();
command.ExecuteNonQuery();
}
}
public Reservation GetReservationById(int reservationId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Reservations WHERE ReservationId = @ReservationId", connection);
command.Parameters.AddWithValue("@ReservationId", reservationId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Reservation
{
ReservationId = (int)reader["ReservationId"],
UserId = (int)reader["User Id"],
CatalogItemId = (int)reader["CatalogItemId"],
ReservationDate = (DateTime)reader["ReservationDate"],
ExpirationDate = (DateTime)reader["ExpirationDate"],
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return null;
}
public List<Reservation> GetAllReservations()
{
var reservations = new List<Reservation>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Reservations", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
reservations.Add(new Reservation
{
ReservationId = (int)reader["ReservationId"],
UserId = (int)reader["User Id"],
CatalogItemId = (int)reader["CatalogItemId"],
ReservationDate = (DateTime)reader["ReservationDate"],
ExpirationDate = (DateTime)reader["ExpirationDate"],
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return reservations;
}
public void UpdateReservation(Reservation reservation)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Reservations SET UserId = @User Id, CatalogItemId = @CatalogItemId, ReservationDate = @ReservationDate, ExpirationDate = @ExpirationDate WHERE ReservationId = @ReservationId", connection);
command.Parameters.AddWithValue("@ReservationId", reservation.ReservationId);
command.Parameters.AddWithValue("@User Id ", reservation.UserId);
command.Parameters.AddWithValue("@CatalogItemId", reservation.CatalogItemId);
command.Parameters.AddWithValue("@ReservationDate", reservation.ReservationDate);
command.Parameters.AddWithValue("@ExpirationDate", reservation.ExpirationDate);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteReservation(int reservationId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Reservations WHERE ReservationId = @ReservationId", connection);
command.Parameters.AddWithValue("@ReservationId", reservationId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Repositories/InventoryItemRepository.cs
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
public class InventoryItemRepository
{
private readonly string _connectionString;
public InventoryItemRepository(string connectionString)
{
_connectionString = connectionString;
}
public void AddInventoryItem(InventoryItem inventoryItem)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO InventoryItems (BookId, Quantity) VALUES (@BookId, @Quantity)", connection);
command.Parameters.AddWithValue("@BookId", inventoryItem.BookId);
command.Parameters.AddWithValue("@Quantity", inventoryItem.Quantity);
connection.Open();
command.ExecuteNonQuery();
}
}
public InventoryItem GetInventoryItemById(int inventoryItemId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM InventoryItems WHERE InventoryItemId = @InventoryItemId", connection);
command.Parameters.AddWithValue("@InventoryItemId", inventoryItemId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new InventoryItem
{
InventoryItemId = (int)reader["InventoryItemId"],
BookId = (int)reader["BookId"],
Quantity = (int)reader["Quantity"],
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return null;
}
public List<InventoryItem> GetAllInventoryItems()
{
var inventoryItems = new List<InventoryItem>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM InventoryItems", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
inventoryItems.Add(new InventoryItem
{
InventoryItemId = (int)reader["InventoryItemId"],
BookId = (int)reader["BookId"],
Quantity = (int)reader["Quantity"],
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return inventoryItems;
}
public void UpdateInventoryItem(InventoryItem inventoryItem)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE InventoryItems SET BookId = @BookId, Quantity = @Quantity WHERE InventoryItemId = @InventoryItemId", connection);
command.Parameters.AddWithValue("@InventoryItemId", inventoryItem.InventoryItemId);
command.Parameters.AddWithValue("@BookId", inventoryItem.BookId);
command.Parameters.AddWithValue("@Quantity", inventoryItem.Quantity);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteInventoryItem(int inventoryItemId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM InventoryItems WHERE InventoryItemId = @InventoryItemId", connection);
command.Parameters.AddWithValue("@InventoryItemId", inventoryItemId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Repositories/MembershipRepository.cs
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
public class MembershipRepository
{
private readonly string _connectionString;
public MembershipRepository(string connectionString)
{
_connectionString = connectionString;
}
public void AddMembership(Membership membership)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Memberships (User Id, MembershipType, StartDate, ExpirationDate) VALUES (@User Id, @MembershipType, @StartDate, @ExpirationDate)", connection);
command.Parameters.AddWithValue("@User Id", membership.UserId);
command.Parameters.AddWithValue("@MembershipType", membership.MembershipType);
command.Parameters.AddWithValue("@StartDate", membership.StartDate);
command.Parameters.AddWithValue("@ExpirationDate", membership.ExpirationDate);
connection.Open();
command.ExecuteNonQuery();
}
}
public Membership GetMembershipById(int membershipId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Memberships WHERE MembershipId = @MembershipId", connection);
command.Parameters.AddWithValue("@MembershipId", membershipId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Membership
{
MembershipId = (int)reader["MembershipId"],
UserId = (int)reader["User Id"],
MembershipType = reader["MembershipType"].ToString(),
StartDate = (DateTime)reader["StartDate"],
ExpirationDate = (DateTime)reader["ExpirationDate"],
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return null;
}
public List<Membership> GetAllMemberships()
{
var memberships = new List<Membership>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Memberships", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
memberships.Add(new Membership
{
MembershipId = (int)reader["MembershipId"],
UserId = (int)reader["User Id"],
MembershipType = reader["MembershipType"].ToString(),
StartDate = (DateTime)reader["StartDate"],
ExpirationDate = (DateTime)reader["ExpirationDate"],
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return memberships;
}
public void UpdateMembership(Membership membership)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Memberships SET UserId = @User Id, MembershipType = @MembershipType, StartDate = @StartDate, ExpirationDate = @ExpirationDate WHERE MembershipId = @MembershipId", connection);
command.Parameters.AddWithValue("@MembershipId", membership.MembershipId);
command.Parameters.AddWithValue("@User Id", membership.UserId);
command.Parameters.AddWithValue("@MembershipType", membership.MembershipType);
command.Parameters.AddWithValue("@StartDate", membership.StartDate);
command.Parameters.AddWithValue("@ExpirationDate", membership.ExpirationDate);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteMembership(int membershipId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Memberships WHERE MembershipId = @MembershipId", connection);
command.Parameters.AddWithValue("@MembershipId", membershipId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Repositories/DigitalResourceRepository.cs
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
public class DigitalResourceRepository
{
private readonly string _connectionString;
public DigitalResourceRepository(string connectionString)
{
_connectionString = connectionString;
}
public void AddDigitalResource(DigitalResource digitalResource)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO DigitalResources (Title, ResourceType, URL) VALUES (@Title, @ResourceType, @URL)", connection);
command.Parameters.AddWithValue("@Title", digitalResource.Title);
command.Parameters.AddWithValue("@ResourceType", digitalResource.ResourceType);
command.Parameters.AddWithValue("@URL", digitalResource.URL);
connection.Open();
command.ExecuteNonQuery();
}
}
public DigitalResource GetDigitalResourceById(int digitalResourceId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM DigitalResources WHERE DigitalResourceId = @DigitalResourceId", connection);
command.Parameters.AddWithValue("@DigitalResourceId", digitalResourceId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new DigitalResource
{
DigitalResourceId = (int)reader["DigitalResourceId"],
Title = reader["Title"].ToString(),
ResourceType = reader["ResourceType"].ToString(),
URL = reader["URL"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return null;
}
public List<DigitalResource> GetAllDigitalResources()
{
var digitalResources = new List<DigitalResource>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM DigitalResources", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
digitalResources.Add(new DigitalResource
{
DigitalResourceId = (int)reader["DigitalResourceId"],
Title = reader["Title"].ToString(),
ResourceType = reader["ResourceType"].ToString(),
URL = reader["URL"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return digitalResources;
}
public void UpdateDigitalResource(DigitalResource digitalResource)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE DigitalResources SET Title = @Title, ResourceType = @ResourceType, URL = @URL WHERE DigitalResourceId = @DigitalResourceId", connection);
command.Parameters.AddWithValue("@DigitalResourceId", digitalResource.DigitalResourceId);
command.Parameters.AddWithValue("@Title", digitalResource.Title);
command.Parameters.AddWithValue("@ResourceType", digitalResource.ResourceType);
command.Parameters.AddWithValue("@URL", digitalResource.URL);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteDigitalResource(int digitalResourceId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM DigitalResources WHERE DigitalResourceId = @DigitalResourceId", connection);
command.Parameters.AddWithValue("@DigitalResourceId", digitalResourceId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Repositories/InterlibraryLoanRepository.cs
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
public class InterlibraryLoanRepository
{
private readonly string _connectionString;
public InterlibraryLoanRepository(string connectionString)
{
_connectionString = connectionString;
}
public void AddInterlibraryLoan(InterlibraryLoan interlibraryLoan)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO InterlibraryLoans (User Id, BookId, LoanDate, DueDate) VALUES (@User Id, @BookId, @LoanDate, @DueDate)", connection);
command.Parameters.AddWithValue("@User Id", interlibraryLoan.UserId);
command.Parameters.AddWithValue("@BookId", interlibraryLoan.BookId);
command.Parameters.AddWithValue("@LoanDate", interlibraryLoan.LoanDate);
command.Parameters.AddWithValue("@DueDate", interlibraryLoan.DueDate);
connection.Open();
command.ExecuteNonQuery();
}
}
public InterlibraryLoan GetInterlibraryLoanById(int interlibraryLoanId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM InterlibraryLoans WHERE InterlibraryLoanId = @InterlibraryLoanId", connection);
command.Parameters.AddWithValue("@InterlibraryLoanId", interlibraryLoanId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new InterlibraryLoan
{
InterlibraryLoanId = (int)reader["InterlibraryLoanId"],
UserId = (int)reader["User Id"],
BookId = (int)reader["BookId"],
LoanDate = (DateTime)reader["LoanDate"],
DueDate = (DateTime)reader["DueDate"],
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return null;
}
public List<InterlibraryLoan> GetAllInterlibraryLoans()
{
var interlibraryLoans = new List<InterlibraryLoan>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM InterlibraryLoans", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
interlibraryLoans.Add(new InterlibraryLoan
{
InterlibraryLoanId = (int)reader["InterlibraryLoanId"],
UserId = (int)reader["User Id"],
BookId = (int)reader["BookId"],
LoanDate = (DateTime)reader["LoanDate"],
DueDate = (DateTime)reader["DueDate"],
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return interlibraryLoans;
}
public void UpdateInterlibraryLoan(InterlibraryLoan interlibraryLoan)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE InterlibraryLoans SET UserId = @ User Id, BookId = @BookId, LoanDate = @LoanDate, DueDate = @DueDate WHERE InterlibraryLoanId = @InterlibraryLoanId", connection);
command.Parameters.AddWithValue("@InterlibraryLoanId", interlibraryLoan.InterlibraryLoanId);
command.Parameters.AddWithValue("@User Id", interlibraryLoan.UserId);
command.Parameters.AddWithValue("@BookId", interlibraryLoan.BookId);
command.Parameters.AddWithValue("@LoanDate", interlibraryLoan.LoanDate);
command.Parameters.AddWithValue("@DueDate", interlibraryLoan.DueDate);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteInterlibraryLoan(int interlibraryLoanId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM InterlibraryLoans WHERE InterlibraryLoanId = @InterlibraryLoanId", connection);
command.Parameters.AddWithValue("@InterlibraryLoanId", interlibraryLoanId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Repositories/EventRepository.cs
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
public class EventRepository
{
private readonly string _connectionString;
public EventRepository(string connectionString)
{
_connectionString = connectionString;
}
public void AddEvent(Event eventItem)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Events (Title, Description, EventDate) VALUES (@Title, @Description, @EventDate)", connection);
command.Parameters.AddWithValue("@Title", eventItem.Title);
command.Parameters.AddWithValue("@Description", eventItem.Description);
command.Parameters.AddWithValue("@EventDate", eventItem.EventDate);
connection.Open();
command.ExecuteNonQuery();
}
}
public Event GetEventById(int eventId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Events WHERE EventId = @EventId", connection);
command.Parameters.AddWithValue("@EventId", eventId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Event
{
EventId = (int)reader["EventId"],
Title = reader["Title"].ToString(),
Description = reader["Description"].ToString(),
EventDate = (DateTime)reader["EventDate"],
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return null;
}
public List<Event> GetAllEvents()
{
var events = new List<Event>();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Events", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
events.Add(new Event
{
EventId = (int)reader["EventId"],
Title = reader["Title"].ToString(),
Description = reader["Description"].ToString(),
EventDate = (DateTime)reader["EventDate"],
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return events;
}
public void UpdateEvent(Event eventItem)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Events SET Title = @Title, Description = @Description, EventDate = @EventDate WHERE EventId = @EventId", connection);
command.Parameters.AddWithValue("@EventId", eventItem.EventId);
command.Parameters.AddWithValue("@Title", eventItem.Title);
command.Parameters.AddWithValue("@Description", eventItem.Description);
command.Parameters.AddWithValue("@EventDate", eventItem.EventDate);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteEvent(int eventId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Events WHERE EventId = @EventId", connection);
command.Parameters.AddWithValue("@EventId", eventId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Repositories/FeedbackRepository.cs
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
public class FeedbackRepository
{
private readonly string _connectionString;
public FeedbackRepository(string connectionString)
{
_connectionString = connectionString;
}
public void AddFeedback(Feedback feedback)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("INSERT INTO Feedback (User Id, Comments) VALUES (@User Id, @Comments)", connection);
command.Parameters.AddWithValue("@User Id", feedback.UserId);
command.Parameters.AddWithValue("@Comments", feedback.Comments);
connection.Open();
command.ExecuteNonQuery();
}
}
public Feedback GetFeedbackById(int feedbackId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("SELECT * FROM Feedback WHERE FeedbackId = @FeedbackId", connection);
command.Parameters.AddWithValue("@FeedbackId", feedbackId);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
return new Feedback
{
FeedbackId = (int)reader["FeedbackId"],
UserId = (int)reader["User Id"],
Comments = reader["Comments"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"]
};
}
}
}
return null;
}
public List<Feedback> GetAllFeedbacks()
{
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"],
Comments = reader["Comments"].ToString(),
CreatedAt = (DateTime)reader["CreatedAt"]
});
}
}
}
return feedbacks;
}
public void UpdateFeedback(Feedback feedback)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("UPDATE Feedback SET UserId = @User Id, Comments = @Comments WHERE FeedbackId = @FeedbackId", connection);
command.Parameters.AddWithValue("@FeedbackId", feedback.FeedbackId);
command.Parameters.AddWithValue("@User Id", feedback.UserId);
command.Parameters.AddWithValue("@Comments", feedback.Comments);
connection.Open();
command.ExecuteNonQuery();
}
}
public void DeleteFeedback(int feedbackId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand("DELETE FROM Feedback WHERE FeedbackId = @FeedbackId", connection);
command.Parameters.AddWithValue("@FeedbackId", feedbackId);
connection.Open();
command.ExecuteNonQuery();
}
}
}
Summary of the Implementation
1. Models: Each model class represents a table in the database, encapsulating the properties that correspond to the columns in the respective tables.
2. Repositories: Each repository class provides methods to interact with the database, including adding, retrieving, updating, and deleting records. The use of ADO.NET allows for direct SQL command execution, providing flexibility and control over database operations.
Next Steps
- Dependency Injection: Consider implementing dependency injection for your repositories to manage their lifecycle and dependencies more effectively.
- Error Handling: Implement error handling in your repository methods to manage exceptions that may arise during database operations.
- Unit Testing: Create unit tests for your repository methods to ensure they function correctly and handle edge cases.
- Service Layer: Optionally, create a service layer that interacts with the repositories to encapsulate business logic and provide a cleaner API for your controllers.
This structure will help you maintain a clean separation of concerns, making your application easier to manage and extend in the future.
Now create controller for each repositories
Below are the controller implementations for each repository in your Library Management System. Each controller will handle HTTP requests and interact with the corresponding repository to perform CRUD operations.
UserController.cs
using Microsoft.AspNetCore.Mvc;
using System.Collections.Generic;
public class UserController : Controller
{
private readonly UserRepository _userRepository;
public UserController(UserRepository userRepository)
{
_userRepository = userRepository;
}
[HttpGet]
public IActionResult Index()
{
var users = _userRepository.GetAllUsers();
return View(users);
}
[HttpGet]
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(User user)
{
if (ModelState.IsValid)
{
_userRepository.AddUser (user);
return RedirectToAction("Index");
}
return View(user);
}
[HttpGet]
public IActionResult Edit(int id)
{
var user = _userRepository.GetUser ById(id);
return View(user);
}
[HttpPost]
public IActionResult Edit(User user)
{
if (ModelState.IsValid)
{
_userRepository.UpdateUser (user);
return RedirectToAction("Index");
}
return View(user);
}
[HttpGet]
public IActionResult Delete(int id)
{
_userRepository.DeleteUser (id);
return RedirectToAction("Index");
}
}
RoleController.cs
using Microsoft.AspNetCore.Mvc;
using System.Collections.Generic;
public class RoleController : Controller
{
private readonly RoleRepository _roleRepository;
public RoleController(RoleRepository roleRepository)
{
_roleRepository = roleRepository;
}
[HttpGet]
public IActionResult Index()
{
var roles = _roleRepository.GetAllRoles();
return View(roles);
}
[HttpGet]
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Role role)
{
if (ModelState.IsValid)
{
_roleRepository.AddRole(role);
return RedirectToAction("Index");
}
return View(role);
}
[HttpGet]
public IActionResult Edit(int id)
{
var role = _roleRepository.GetRoleById(id);
return View(role);
}
[HttpPost]
public IActionResult Edit(Role role)
{
if (ModelState.IsValid)
{
_roleRepository.UpdateRole(role);
return RedirectToAction("Index");
}
return View(role);
}
[HttpGet]
public IActionResult Delete(int id)
{
_roleRepository.DeleteRole(id);
return RedirectToAction("Index");
}
}
BookController.cs
using Microsoft.AspNetCore.Mvc;
using System.Collections.Generic;
public class BookController : Controller
{
private readonly BookRepository _bookRepository;
public BookController(BookRepository bookRepository)
{
_bookRepository = bookRepository;
}
[HttpGet]
public IActionResult Index()
{
var books = _bookRepository.GetAllBooks();
return View(books);
}
[HttpGet]
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Book book)
{
if (ModelState.IsValid)
{
_bookRepository.AddBook(book);
return RedirectToAction("Index");
}
return View(book);
}
[HttpGet]
public IActionResult Edit(int id)
{
var book = _bookRepository.GetBookById(id);
return View(book);
}
[HttpPost]
public IActionResult Edit(Book book)
{
if (ModelState.IsValid)
{
_bookRepository.UpdateBook(book);
return RedirectToAction("Index");
}
return View(book);
}
[HttpGet]
public IActionResult Delete(int id)
{
_bookRepository.DeleteBook(id);
return RedirectToAction("Index");
}
}
CatalogItemController.cs
using Microsoft.AspNetCore.Mvc;
using System.Collections.Generic;
public class CatalogItemController : Controller
{
private readonly CatalogItemRepository _catalogItemRepository;
public CatalogItemController(CatalogItemRepository catalogItemRepository)
{
_catalogItemRepository = catalogItemRepository;
}
[HttpGet]
public IActionResult Index()
{
var catalogItems = _catalogItemRepository.GetAllCatalogItems();
return View(catalogItems);
}
[HttpGet]
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(CatalogItem catalogItem)
{
if (ModelState.IsValid)
{
_catalogItemRepository.AddCatalogItem(catalogItem);
return RedirectToAction("Index");
}
return View(catalogItem);
}
[HttpGet]
public IActionResult Edit(int id)
{
var catalogItem = _catalogItemRepository.GetCatalogItemById(id);
return View(catalogItem);
}
[HttpPost]
public IActionResult Edit(CatalogItem catalogItem)
{
if (ModelState.IsValid)
{
_catalogItemRepository.UpdateCatalogItem(catalogItem);
return RedirectToAction("Index");
}
return View(catalogItem);
}
[HttpGet]
public IActionResult Delete(int id)
{
_catalogItemRepository.DeleteCatalogItem(id);
return RedirectToAction("Index");
}
}
CirculationRecordController.cs
using Microsoft.AspNetCore.Mvc;
using System.Collections.Generic;
public class CirculationRecordController : Controller
{
private readonly CirculationRecordRepository _circulationRecordRepository;
public CirculationRecordController(CirculationRecordRepository circulationRecordRepository)
{
_circulationRecordRepository = circulationRecordRepository;
}
[HttpGet]
public IActionResult Index()
{
var circulationRecords = _circulationRecordRepository.GetAllCirculationRecords();
return View(circulationRecords);
}
[HttpGet]
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(CirculationRecord circulationRecord)
{
if (ModelState.IsValid)
{
_circulationRecordRepository.AddCirculationRecord(circulationRecord);
return RedirectToAction("Index");
}
return View(circulationRecord);
}
[HttpGet]
public IActionResult Edit(int id)
{
var circulationRecord = _circulationRecordRepository.GetCirculationRecordById(id);
return View(circulationRecord);
}
[HttpPost]
public IActionResult Edit(CirculationRecord circulationRecord)
{
if (ModelState.IsValid)
{
_circulationRecordRepository.UpdateCirculationRecord(circulationRecord);
return RedirectToAction("Index");
}
return View(circulationRecord);
}
[HttpGet]
public IActionResult Delete(int id)
{
_circulationRecordRepository.DeleteCirculationRecord(id);
return RedirectToAction("Index");
}
}
ReservationController.cs
using Microsoft.AspNetCore.Mvc;
using System.Collections.Generic;
public class ReservationController : Controller
{
private readonly ReservationRepository _reservationRepository;
public ReservationController(ReservationRepository reservationRepository)
{
_reservationRepository = reservationRepository;
}
[HttpGet]
public IActionResult Index()
{
var reservations = _reservationRepository.GetAllReservations();
return View(reservations);
}
[HttpGet]
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Reservation reservation)
{
if (ModelState.IsValid)
{
_reservationRepository.AddReservation(reservation);
return RedirectToAction("Index");
}
return View(reservation);
}
[HttpGet]
public IActionResult Edit(int id)
{
var reservation = _reservationRepository.GetReservationById(id);
return View(reservation);
}
[HttpPost]
public IActionResult Edit(Reservation reservation)
{
if (ModelState.IsValid)
{
_reservationRepository.UpdateReservation(reservation);
return RedirectToAction("Index");
}
return View(reservation);
}
[HttpGet]
public IActionResult Delete(int id)
{
_reservationRepository.DeleteReservation(id);
return RedirectToAction("Index");
}
}
InventoryItemController.cs
using Microsoft.AspNetCore.Mvc;
using System.Collections.Generic;
public class InventoryItemController : Controller
{
private readonly InventoryItemRepository _inventoryItemRepository;
public InventoryItemController(InventoryItemRepository inventoryItemRepository)
{
_inventoryItemRepository = inventoryItemRepository;
}
[HttpGet]
public IActionResult Index()
{
var inventoryItems = _inventoryItemRepository.GetAllInventoryItems();
return View(inventoryItems);
}
[HttpGet]
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(InventoryItem inventoryItem)
{
if (ModelState.IsValid)
{
_inventoryItemRepository.AddInventoryItem(inventoryItem);
return RedirectToAction("Index");
}
return View(inventoryItem);
}
[HttpGet]
public IActionResult Edit(int id)
{
var inventoryItem = _inventoryItemRepository.GetInventoryItemById(id);
return View(inventoryItem);
}
[HttpPost]
public IActionResult Edit(InventoryItem inventoryItem)
{
if (ModelState.IsValid)
{
_inventoryItemRepository.UpdateInventoryItem(inventoryItem);
return RedirectToAction("Index");
}
return View(inventoryItem);
}
[HttpGet]
public IActionResult Delete(int id)
{
_inventoryItemRepository.DeleteInventoryItem(id);
return RedirectToAction("Index");
}
}
MembershipController.cs
using Microsoft.AspNetCore.Mvc;
using System.Collections.Generic;
public class MembershipController : Controller
{
private readonly MembershipRepository _membershipRepository;
public MembershipController(MembershipRepository membershipRepository)
{
_membershipRepository = membershipRepository;
}
[HttpGet]
public IActionResult Index()
{
var memberships = _membershipRepository.GetAllMemberships();
return View(memberships);
}
[HttpGet]
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Membership membership)
{
if (ModelState.IsValid)
{
_membershipRepository.AddMembership(membership);
return RedirectToAction("Index");
}
return View(membership);
}
[HttpGet]
public IActionResult Edit(int id)
{
var membership = _membershipRepository.GetMembershipById(id);
return View(membership);
}
[HttpPost]
public IActionResult Edit(Membership membership)
{
if (ModelState.IsValid)
{
_membershipRepository.UpdateMembership(membership);
return RedirectToAction("Index");
}
return View(membership);
}
[HttpGet]
public IActionResult Delete(int id)
{
_membershipRepository.DeleteMembership(id);
return RedirectToAction("Index");
}
}
DigitalResourceController.cs
using Microsoft.AspNetCore.Mvc;
using System.Collections.Generic;
public class DigitalResourceController : Controller
{
private readonly DigitalResourceRepository _digitalResourceRepository;
public DigitalResourceController(DigitalResourceRepository digitalResourceRepository)
{
_digitalResourceRepository = digitalResourceRepository;
}
[HttpGet]
public IActionResult Index()
{
var digitalResources = _digitalResourceRepository.GetAllDigitalResources();
return View(digitalResources);
}
[HttpGet]
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(DigitalResource digitalResource)
{
if (ModelState.IsValid)
{
_digitalResourceRepository.AddDigitalResource(digitalResource);
return RedirectToAction("Index");
}
return View(digitalResource);
}
[HttpGet]
public IActionResult Edit(int id)
{
var digitalResource = _digitalResourceRepository.GetDigitalResourceById(id);
return View(digitalResource);
}
[HttpPost]
public IActionResult Edit(DigitalResource digitalResource)
{
if (ModelState.IsValid)
{
_digitalResourceRepository.UpdateDigitalResource(digitalResource);
return RedirectToAction("Index");
}
return View(digitalResource);
}
[HttpGet]
public IActionResult Delete(int id)
{
_digitalResourceRepository.DeleteDigitalResource(id);
return RedirectToAction("Index");
}
}
InterlibraryLoanController.cs
using Microsoft.AspNetCore.Mvc;
using System.Collections.Generic;
public class InterlibraryLoanController : Controller
{
private readonly InterlibraryLoanRepository _interlibraryLoanRepository;
public InterlibraryLoanController(InterlibraryLoanRepository interlibraryLoanRepository)
{
_interlibraryLoanRepository = interlibraryLoanRepository;
}
[HttpGet]
public IActionResult Index()
{
var interlibraryLoans = _interlibraryLoanRepository.GetAllInterlibraryLoans();
return View(interlibraryLoans);
}
[HttpGet]
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(InterlibraryLoan interlibraryLoan)
{
if (ModelState.IsValid)
{
_interlibraryLoanRepository.AddInterlibraryLoan(interlibraryLoan);
return RedirectToAction("Index");
}
return View(interlibraryLoan);
}
[HttpGet]
public IActionResult Edit(int id)
{
var interlibraryLoan = _interlibraryLoanRepository.GetInterlibraryLoanById(id);
return View(interlibraryLoan);
}
[HttpPost]
public IActionResult Edit(InterlibraryLoan interlibraryLoan)
{
if (ModelState.IsValid)
{
_interlibraryLoanRepository.UpdateInterlibraryLoan(interlibraryLoan);
return RedirectToAction("Index");
}
return View(interlibraryLoan);
}
[HttpGet]
public IActionResult Delete(int id)
{
_interlibraryLoanRepository.DeleteInterlibraryLoan(id);
return RedirectToAction("Index");
}
}
EventController.cs
using Microsoft.AspNetCore.Mvc;
using System.Collections.Generic;
public class EventController : Controller
{
private readonly EventRepository _eventRepository;
public EventController(EventRepository eventRepository)
{
_eventRepository = eventRepository;
}
[HttpGet]
public IActionResult Index()
{
var events = _eventRepository.GetAllEvents();
return View(events);
}
[HttpGet]
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Event eventItem)
{
if (ModelState.IsValid)
{
_eventRepository.AddEvent(eventItem);
return RedirectToAction("Index");
}
return View(eventItem);
}
[HttpGet]
public IActionResult Edit(int id)
{
var eventItem = _eventRepository.GetEventById(id);
return View(eventItem);
}
[HttpPost]
public IActionResult Edit(Event eventItem)
{
if (ModelState.IsValid)
{
_eventRepository.UpdateEvent(eventItem);
return RedirectToAction("Index");
}
return View(eventItem);
}
[HttpGet]
public IActionResult Delete(int id)
{
_eventRepository.DeleteEvent(id);
return RedirectToAction("Index");
}
}
FeedbackController.cs
using Microsoft.AspNetCore.Mvc;
using System.Collections.Generic;
public class FeedbackController : Controller
{
private readonly FeedbackRepository _feedbackRepository;
public FeedbackController(FeedbackRepository feedbackRepository)
{
_feedbackRepository = feedbackRepository;
}
[HttpGet]
public IActionResult Index()
{
var feedbacks = _feedbackRepository.GetAllFeedbacks();
return View(feedbacks);
}
[HttpGet]
public IActionResult Create()
{
return View();
}
[HttpPost]
public IActionResult Create(Feedback feedback)
{
if (ModelState.IsValid)
{
_feedbackRepository.AddFeedback(feedback);
return RedirectToAction("Index");
}
return View(feedback);
}
[HttpGet]
public IActionResult Edit(int id)
{
var feedback = _feedbackRepository.GetFeedbackById(id);
return View(feedback);
}
[HttpPost]
public IActionResult Edit(Feedback feedback)
{
if (ModelState.IsValid)
{
_feedbackRepository.UpdateFeedback(feedback);
return RedirectToAction("Index");
}
return View(feedback);
}
[HttpGet]
public IActionResult Delete(int id)
{
_feedbackRepository.DeleteFeedback(id);
return RedirectToAction("Index");
}
}
Each controller is designed to handle HTTP requests for its respective repository, providing methods for creating, reading, updating, and deleting records. This structure allows for a clean separation of concerns, making it easier to manage the application's logic and data flow. You can further enhance these controllers with additional features such as validation, error handling, and logging as needed.
Below are the Razor view files for each controller in your Online Ticket Booking System
Each view corresponds to the actions defined in the controllers, allowing you to create, read, update, and delete records for each entity.
User Views
Views/User/Index.cshtml
@model IEnumerable<User>
<h2>Users</h2>
<a href='@Url.Action("Create")'>Create New User</a>
<table>
<thead>
<tr>
<th>Username</th>
<th>Email</th>
<th>Role ID</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var user in Model)
{
<tr>
<td>@user.Username</td>
<td>@user.Email</td>
<td>@user.RoleId</td>
<td>
<a href='@Url.Action("Edit", new { id = user.UserId })'>Edit</a> |
<a href='@Url.Action("Delete", new { id = user.UserId })'>Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/User/Create.cshtml
@model User
<h2>Create User</h2>
<form asp-action="Create" method="post">
<label>Username:</label>
<input asp-for="Username" required />
<label>Password:</label>
<input asp-for="PasswordHash" type="password" required />
<label>Email:</label>
<input asp-for="Email" required />
<label>Role ID:</label>
<input asp-for="RoleId" required />
<button type="submit">Create</button>
</form>
Views/User/Edit.cshtml
@model User
<h2>Edit User</h2>
<form asp-action="Edit" method="post">
<input type="hidden" asp-for="User Id" />
<label>Username:</label>
<input asp-for="Username" required />
<label>Password:</label>
<input asp-for="PasswordHash" type="password" />
<label>Email:</label>
<input asp-for="Email" required />
<label>Role ID:</label>
<input asp-for="RoleId" required />
<button type="submit">Update</button>
</form>
Role Views
Views/Role/Index.cshtml
@model IEnumerable<Role>
<h2>Roles</h2>
<a href='@Url.Action("Create")'>Create New Role</a>
<table>
<thead>
<tr>
<th>Role Name</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var role in Model)
{
<tr>
<td>@role.RoleName</td>
<td>
<a href='@Url.Action("Edit", new { id = role.RoleId })'>Edit</a> |
<a href='@Url.Action("Delete", new { id = role.RoleId })'>Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Role/Create.cshtml
@model Role
<h2>Create Role</h2>
<form asp-action="Create" method="post">
<label>Role Name:</label>
<input asp-for="RoleName" required />
<button type="submit">Create</button>
</form>
Views/Role/Edit.cshtml
@model Role
<h2>Edit Role</h2>
<form asp-action="Edit" method="post">
<input type="hidden" asp-for="RoleId" />
<label>Role Name:</label>
<input asp-for="RoleName" required />
<button type="submit">Update</button>
</form>
Book Views
Views/Book/Index.cshtml
@model IEnumerable<Book>
<h2>Books</h2>
<a href='@Url.Action("Create")'>Create New Book</a>
<table>
<thead>
<tr>
<th>Title</th>
<th>Author</th>
<th>ISBN</th>
<th>Publisher</th>
<th>Published Date</th>
<th>Copies Available</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var book in Model)
{
<tr>
<td>@book.Title</td>
<td>@book.Author</td>
<td>@book.ISBN</td>
<td>@book.Publisher</td>
<td>@book.PublishedDate?.ToShortDateString()</td>
<td>@book.CopiesAvailable</td>
<td>
<a href='@Url.Action("Edit", new { id = book.BookId })'>Edit</a> |
<a href='@Url.Action("Delete", new { id = book.BookId })'>Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Book/Create.cshtml
@model Book
<h2>Create Book</h2>
<form asp-action="Create" method="post">
<label>Title:</label>
<input asp-for="Title" required />
<label>Author:</label>
<input asp-for="Author" required />
<label>ISBN:</label>
<input asp-for="ISBN" required />
<label>Publisher:</label>
<input asp-for="Publisher" />
<label>Published Date:</label>
<input asp-for="PublishedDate" type="date" />
<label>Copies Available:</label>
<input asp-for="CopiesAvailable" type="number" required />
<button type="submit">Create</button>
</form>
Views/Book/Edit.cshtml
@model Book
<h2>Edit Book</h2>
<form asp-action="Edit" method="post">
<input type="hidden" asp-for="BookId" />
<label>Title:</label>
<input asp-for="Title" required />
<label>Author:</label>
<input asp-for="Author" required />
<label>ISBN:</label>
<input asp-for="ISBN" required />
<label>Publisher:</label>
<input asp-for="Publisher" />
<label>Published Date:</label>
<input asp-for="PublishedDate" type="date" />
<label>Copies Available:</label>
<input asp-for="CopiesAvailable" type="number" required />
<button type="submit">Update</button>
</form>
CatalogItem Views
Views/CatalogItem/Index.cshtml
@model IEnumerable<CatalogItem>
<h2>Catalog Items</h2>
<a href='@Url.Action("Create")'>Create New Catalog Item</a>
<table>
<thead>
<tr>
<th>Book ID</th>
<th>Location</th>
<th>Status</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var catalogItem in Model)
{
<tr>
<td>@catalogItem.BookId</td>
<td>@catalogItem.Location</td>
<td>@catalogItem.Status</td>
<td>
<a href='@Url.Action("Edit", new { id = catalogItem.CatalogItemId })'>Edit</a> |
<a href='@Url.Action("Delete", new { id = catalogItem.CatalogItemId })'>Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/CatalogItem/Create.cshtml
@model CatalogItem
<h2>Create Catalog Item</h2>
<form asp-action="Create" method="post">
<label>Book ID:</label>
<input asp-for="BookId" required />
<label>Location:</label>
<input asp-for="Location" required />
<label>Status:</label>
<input asp-for="Status" required />
<button type="submit">Create</button>
</form>
Views/CatalogItem/Edit.cshtml
@model CatalogItem
<h2>Edit Catalog Item</h2>
<form asp-action="Edit" method="post">
<input type="hidden" asp-for="CatalogItemId" />
<label>Book ID:</label>
<input asp-for="BookId" required />
<label>Location:</label>
<input asp-for="Location" required />
<label>Status:</label>
<input asp-for="Status" required />
<button type="submit">Update</button>
</form>
CirculationRecord Views
Views/CirculationRecord/Index.cshtml
@model IEnumerable<CirculationRecord>
<h2>Circulation Records</h2>
<a href='@Url.Action("Create")'>Create New Circulation Record</a>
<table>
<thead>
<tr>
<th>User ID</th>
<th>Catalog Item ID</th>
<th>Checkout Date</th>
<th>Due Date</th>
<th>Return Date</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var record in Model)
{
<tr>
<td>@record.UserId</td>
<td>@record.CatalogItemId</td>
<td>@record.CheckoutDate.ToShortDateString()</td>
<td>@record.DueDate.ToShortDateString()</td>
<td>@record.ReturnDate?.ToShortDateString()</td>
<td>
<a href='@Url.Action("Edit", new { id = record.CirculationRecordId })'>Edit</a> |
<a href='@Url.Action("Delete", new { id = record.CirculationRecordId })'>Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/CirculationRecord/Create.cshtml
@model CirculationRecord
<h2>Create Circulation Record</h2>
<form asp-action="Create" method="post">
<label>User ID:</label>
<input asp-for="User Id" required />
<label>Catalog Item ID:</label>
<input asp-for="CatalogItemId" required />
<label>Checkout Date:</label>
<input asp-for="CheckoutDate" type="datetime-local" required />
<label>Due Date:</label>
<input asp-for="DueDate" type="datetime-local" required />
<button type="submit">Create</button>
</form>
Views/CirculationRecord/Edit.cshtml
@model CirculationRecord
<h2>Edit Circulation Record</h2>
<form asp-action="Edit" method="post">
<input type="hidden" asp-for="CirculationRecordId" />
<label>User ID:</label>
<input asp-for="User Id" required />
<label>Catalog Item ID:</label>
<input asp-for="CatalogItemId" required />
<label>Checkout Date:</label>
<input asp-for="CheckoutDate" type="datetime-local" required />
<label>Due Date:</label>
<input asp-for="DueDate" type="datetime-local" required />
<button type="submit">Update</button>
</form>
Reservation Views
Views/Reservation/Index.cshtml
@model IEnumerable<Reservation>
<h2>Reservations</h2>
<a href='@Url.Action("Create")'>Create New Reservation</a>
<table>
<thead>
<tr>
<th>User ID</th>
<th>Catalog Item ID</th>
<th>Reservation Date</th>
<th>Expiration Date</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var reservation in Model)
{
<tr>
<td>@reservation.UserId</td>
<td>@reservation.CatalogItemId</td>
<td>@reservation.ReservationDate.ToShortDateString()</td>
<td>@reservation.ExpirationDate.ToShortDateString()</td>
<td>
<a href='@Url.Action("Edit", new { id = reservation.ReservationId })'>Edit</a> |
<a href='@Url.Action("Delete", new { id = reservation.ReservationId })'>Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Reservation/Create.cshtml
@model Reservation
<h2>Create Reservation</h2>
<form asp-action="Create" method="post">
<label>User ID:</label>
<input asp-for="User Id" required />
<label>Catalog Item ID:</label>
<input asp-for="CatalogItemId" required />
<label>Reservation Date:</label>
<input asp-for="ReservationDate" type="datetime-local" required />
<label>Expiration Date:</label>
<input asp-for="ExpirationDate" type="datetime-local" required />
<button type="submit">Create</button>
</form>
Views/Reservation/Edit.cshtml
@model Reservation
<h2>Edit Reservation</h2>
<form asp-action="Edit" method="post">
<input type="hidden" asp-for="ReservationId" />
<label>User ID:</label>
<input asp-for="User Id" required />
<label>Catalog Item ID:</label>
<input asp-for="CatalogItemId" required />
<label>Reservation Date:</label>
<input asp-for="ReservationDate" type="datetime-local" required />
<label>Expiration Date:</label>
<input asp-for="ExpirationDate" type="datetime-local" required />
<button type="submit">Update</button>
</form>
InventoryItem Views
Views/InventoryItem/Index.cshtml
@model IEnumerable<InventoryItem>
<h2>Inventory Items</h2>
<a href='@Url.Action("Create")'>Create New Inventory Item</a>
<table>
<thead>
<tr>
<th>Book ID</th>
<th>Quantity</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var inventoryItem in Model)
{
<tr>
<td>@inventoryItem.BookId</td>
<td>@inventoryItem.Quantity</td>
<td>
<a href='@Url.Action("Edit", new { id = inventoryItem.InventoryItemId })'>Edit</a> |
<a href='@Url.Action("Delete", new { id = inventoryItem.InventoryItemId })'>Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/InventoryItem/Create.cshtml
@model InventoryItem
<h2>Create Inventory Item</h2>
<form asp-action="Create" method="post">
<label>Book ID:</label>
<input asp-for="BookId" required />
<label>Quantity:</label>
<input asp-for="Quantity" type="number" required />
<button type="submit">Create</button>
</form>
Views/InventoryItem/Edit.cshtml
@model InventoryItem
<h2>Edit Inventory Item</h2>
<form asp-action="Edit" method="post">
<input type="hidden" asp-for="InventoryItemId" />
<label>Book ID:</label>
<input asp-for="BookId" required />
<label>Quantity:</label>
<input asp-for="Quantity" type="number" required />
<button type="submit">Update</button>
</form>
Membership Views
Views/Membership/Index.cshtml
@model IEnumerable<Membership>
<h2>Memberships</h2>
<a href='@Url.Action("Create")'>Create New Membership</a>
<table>
<thead>
<tr>
<th>User ID</th>
<th>Membership Type</th>
<th>Start Date</th>
<th>Expiration Date</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var membership in Model)
{
<tr>
<td>@membership.UserId</td>
<td>@membership.MembershipType</td>
<td>@membership.StartDate.ToShortDateString()</td>
<td>@membership.ExpirationDate.ToShortDateString()</td>
<td>
<a href='@Url.Action("Edit", new { id = membership.MembershipId })"> Edit</a> |
<a href='@Url.Action("Delete", new { id = membership.MembershipId })'>Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Membership/Create.cshtml
@model Membership
<h2>Create Membership</h2>
<form asp-action="Create" method="post">
<label>User ID:</label>
<input asp-for="User Id" required />
<label>Membership Type:</label>
<input asp-for="MembershipType" required />
<label>Start Date:</label>
<input asp-for="StartDate" type="date" required />
<label>Expiration Date:</label>
<input asp-for="ExpirationDate" type="date" required />
<button type="submit">Create</button>
</form>
Views/Membership/Edit.cshtml
@model Membership
<h2>Edit Membership</h2>
<form asp-action="Edit" method="post">
<input type="hidden" asp-for="MembershipId" />
<label>User ID:</label>
<input asp-for="User Id" required />
<label>Membership Type:</label>
<input asp-for="MembershipType" required />
<label>Start Date:</label>
<input asp-for="StartDate" type="date" required />
<label>Expiration Date:</label>
<input asp-for="ExpirationDate" type="date" required />
<button type="submit">Update</button>
</form>
DigitalResource Views
Views/DigitalResource/Index.cshtml
@model IEnumerable<DigitalResource>
<h2>Digital Resources</h2>
<a href='@Url.Action("Create")'>Create New Digital Resource</a>
<table>
<thead>
<tr>
<th>Title</th>
<th>Type</th>
<th>URL</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var resource in Model)
{
<tr>
<td>@resource.Title</td>
<td>@resource.Type</td>
<td>@resource.Url</td>
<td>
<a href='@Url.Action("Edit", new { id = resource.DigitalResourceId })'>Edit</a> |
<a href='@Url.Action("Delete", new { id = resource.DigitalResourceId })'>Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/DigitalResource/Create.cshtml
@model DigitalResource
<h2>Create Digital Resource</h2>
<form asp-action="Create" method="post">
<label>Title:</label>
<input asp-for="Title" required />
<label>Type:</label>
<input asp-for="Type" required />
<label>URL:</label>
<input asp-for="Url" required />
<button type="submit">Create</button>
</form>
Views/DigitalResource/Edit.cshtml
@model DigitalResource
<h2>Edit Digital Resource</h2>
<form asp-action="Edit" method="post">
<input type="hidden" asp-for="DigitalResourceId" />
<label>Title:</label>
<input asp-for="Title" required />
<label>Type:</label>
<input asp-for="Type" required />
<label>URL:</label>
<input asp-for="Url" required />
<button type="submit">Update</button>
</form>
InterlibraryLoan Views
Views/InterlibraryLoan/Index.cshtml
@model IEnumerable<InterlibraryLoan>
<h2>Interlibrary Loans</h2>
<a href='@Url.Action("Create")'>Create New Interlibrary Loan</a>
<table>
<thead>
<tr>
<th>User ID</th>
<th>Book ID</th>
<th>Loan Date</th>
<th>Return Date</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var loan in Model)
{
<tr>
<td>@loan.UserId</td>
<td>@loan.BookId</td>
<td>@loan.LoanDate.ToShortDateString()</td>
<td>@loan.ReturnDate?.ToShortDateString()</td>
<td>
<a href='@Url.Action("Edit", new { id = loan.InterlibraryLoanId })'>Edit</a> |
<a href='@Url.Action("Delete", new { id = loan.InterlibraryLoanId })">Delete </a>
</td>
</tr>
}
</tbody>
</table>
Views/InterlibraryLoan/Create.cshtml
@model InterlibraryLoan
<h2>Create Interlibrary Loan</h2>
<form asp-action="Create" method="post">
<label>User ID:</label>
<input asp-for="User Id" required />
<label>Book ID:</label>
<input asp-for="BookId" required />
<label>Loan Date:</label>
<input asp-for="LoanDate" type="date" required />
<label>Return Date:</label>
<input asp-for="ReturnDate" type="date" />
<button type="submit">Create</button>
</form>
Views/InterlibraryLoan/Edit.cshtml
@model InterlibraryLoan
<h2>Edit Interlibrary Loan</h2>
<form asp-action="Edit" method="post">
<input type="hidden" asp-for="InterlibraryLoanId" />
<label>User ID:</label>
<input asp-for="User Id" required />
<label>Book ID:</label>
<input asp-for="BookId" required />
<label>Loan Date:</label>
<input asp-for="LoanDate" type="date" required />
<label>Return Date:</label>
<input asp-for="ReturnDate" type="date" />
<button type="submit">Update</button>
</form>
Event Views
Views/Event/Index.cshtml
@model IEnumerable<Event>
<h2>Events</h2>
<a href='@Url.Action("Create")'>Create New Event</a>
<table>
<thead>
<tr>
<th>Event Name</th>
<th>Date</th>
<th>Location</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var eventItem in Model)
{
<tr>
<td>@eventItem.EventName</td>
<td>@eventItem.EventDate.ToShortDateString()</td>
<td>@eventItem.Location</td>
<td>
<a href='@Url.Action("Edit", new { id = eventItem.EventId })'>Edit</a> |
<a href='@Url.Action("Delete", new { id = eventItem.EventId })'>Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Event/Create.cshtml
@model Event
<h2>Create Event</h2>
<form asp-action="Create" method="post">
<label>Event Name:</label>
<input asp-for="EventName" required />
<label>Date:</label>
<input asp-for="EventDate" type="date" required />
<label>Location:</label>
<input asp-for="Location" required />
<button type="submit">Create</button>
</form>
Views/Event/Edit.cshtml
@model Event
<h2>Edit Event</h2>
<form asp-action="Edit" method="post">
<input type="hidden" asp-for="EventId" />
<label>Event Name:</label>
<input asp-for="EventName" required />
<label>Date:</label>
<input asp-for="EventDate" type="date" required />
<label>Location:</label>
<input asp-for="Location" required />
<button type="submit">Update</button>
</form>
Feedback Views
Views/Feedback/Index.cshtml
@model IEnumerable<Feedback>
<h2>Feedback</h2>
<a href='@Url.Action("Create")'>Create New Feedback</a>
<table>
<thead>
<tr>
<th>User ID</th>
<th>Comment</th>
<th>Date</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach (var feedback in Model)
{
<tr>
<td>@feedback.UserId</td>
<td>@feedback.Comment</td>
<td>@feedback.Date.ToShortDateString()</td>
<td>
<a href='@Url.Action("Edit", new { id = feedback.FeedbackId })'>Edit</a> |
<a href='@Url.Action("Delete", new { id = feedback.FeedbackId })'>Delete</a>
</td>
</tr>
}
</tbody>
</table>
Views/Feedback/Create.cshtml
@model Feedback
<h2>Create Feedback</h2>
<form asp-action="Create" method="post">
<label>User ID:</label>
<input asp-for="User Id" required />
<label>Comment:</label>
<textarea asp-for="Comment" required></textarea>
<label>Date:</label>
<input asp-for="Date" type="date" required />
<button type="submit">Create</button>
</form>
Views/Feedback/Edit.cshtml
@model Feedback
<h2>Edit Feedback</h2>
<form asp-action="Edit" method="post">
<input type="hidden" asp-for="FeedbackId" />
<label>User ID:</label>
<input asp-for="User Id" required />
<label>Comment:</label>
<textarea asp-for="Comment" required></textarea>
<label>Date:</label>
<input asp-for="Date" type="date" required />
<button type="submit">Update</button>
</form>
These Razor view files provide a user interface for each controller's actions, allowing users to interact with the system by creating, viewing, editing, and deleting records. Each view is structured to ensure a smooth user experience while maintaining the necessary data integrity and validation. You can further enhance these views with additional styling and client-side validation as needed.
To create a dashboard page for your Online Ticket Booking System
That displays consolidated data, we will follow these steps:
Create a ViewModel to hold the data for the dashboard.
Models/DashboardViewModel.cs
public class DashboardViewModel
{
public int TotalUsers { get; set; }
public int TotalRoles { get; set; }
public int TotalBooks { get; set; }
public int TotalCatalogItems { get; set; }
public int TotalCirculationRecords { get; set; }
public int TotalReservations { get; set; }
public int TotalInventoryItems { get; set; }
public int TotalMemberships { get; set; }
public int TotalDigitalResources { get; set; }
public int TotalInterlibraryLoans { get; set; }
public int TotalEvents { get; set; }
public int TotalFeedbacks { get; set; }
}
Create the Dashboard Controller
Create a new controller called DashboardController to fetch the data from the repositories and pass it to the view.
Controllers/DashboardController.cs
using Microsoft.AspNetCore.Mvc;
public class DashboardController : Controller
{
private readonly UserRepository _userRepository;
private readonly RoleRepository _roleRepository;
private readonly BookRepository _bookRepository;
private readonly CatalogItemRepository _catalogItemRepository;
private readonly CirculationRecordRepository _circulationRecordRepository;
private readonly ReservationRepository _reservationRepository;
private readonly InventoryItemRepository _inventoryItemRepository;
private readonly MembershipRepository _membershipRepository;
private readonly DigitalResourceRepository _digitalResourceRepository;
private readonly InterlibraryLoanRepository _interlibraryLoanRepository;
private readonly EventRepository _eventRepository;
private readonly FeedbackRepository _feedbackRepository;
public DashboardController(
UserRepository userRepository,
RoleRepository roleRepository,
BookRepository bookRepository,
CatalogItemRepository catalogItemRepository,
CirculationRecordRepository circulationRecordRepository,
ReservationRepository reservationRepository,
InventoryItemRepository inventoryItemRepository,
MembershipRepository membershipRepository,
DigitalResourceRepository digitalResourceRepository,
InterlibraryLoanRepository interlibraryLoanRepository,
EventRepository eventRepository,
FeedbackRepository feedbackRepository)
{
_userRepository = userRepository;
_roleRepository = roleRepository;
_bookRepository = bookRepository;
_catalogItemRepository = catalogItemRepository;
_circulationRecordRepository = circulationRecordRepository;
_reservationRepository = reservationRepository;
_inventoryItemRepository = inventoryItemRepository;
_membershipRepository = membershipRepository;
_digitalResourceRepository = digitalResourceRepository;
_interlibraryLoanRepository = interlibraryLoanRepository;
_eventRepository = eventRepository;
_feedbackRepository = feedbackRepository;
}
public IActionResult Index()
{
var model = new DashboardViewModel
{
TotalUsers = _userRepository.GetAllUsers().Count,
TotalRoles = _roleRepository.GetAllRoles().Count,
TotalBooks = _bookRepository.GetAllBooks().Count,
TotalCatalogItems = _catalogItemRepository.GetAllCatalogItems().Count,
TotalCirculationRecords = _circulationRecordRepository.GetAllCirculationRecords().Count,
TotalReservations = _reservationRepository.GetAllReservations().Count,
TotalInventoryItems = _inventoryItemRepository.GetAllInventoryItems().Count,
TotalMemberships = _membershipRepository.GetAllMemberships().Count,
TotalDigitalResources = _digitalResourceRepository.GetAllDigitalResources().Count,
TotalInterlibraryLoans = _interlibraryLoanRepository.GetAllInterlibraryLoans().Count,
TotalEvents = _eventRepository.GetAllEvents().Count,
TotalFeedbacks = _feedbackRepository.GetAllFeedbacks().Count
};
return View(model);
}
}
Create the Dashboard View
Create a Razor view for the dashboard that displays the consolidated data.
Views/Dashboard/Index.cshtml
@model DashboardViewModel
<h2>Dashboard</h2>
<div class="dashboard">
<div class="card">
<h3>Total Users</h3>
<p>@Model.TotalUsers</p>
</div>
<div class="card">
<h3>Total Roles</h3>
<p>@Model.TotalRoles</p>
</div>
<div class="card">
<h3>Total Books</h3>
<p>@Model.TotalBooks</p>
</div>
<div class="card">
<h3>Total Catalog Items</h3>
<p>@Model.TotalCatalogItems</ p>
</div>
<div class="card">
<h3>Total Circulation Records</h3>
<p>@Model.TotalCirculationRecords</p>
</div>
<div class="card">
<h3>Total Reservations</h3>
<p>@Model.TotalReservations</p>
</div>
<div class="card">
<h3>Total Inventory Items</h3>
<p>@Model.TotalInventoryItems</p>
</div>
<div class="card">
<h3>Total Memberships</h3>
<p>@Model.TotalMemberships</p>
</div>
<div class="card">
<h3>Total Digital Resources</h3>
<p>@Model.TotalDigitalResources</p>
</div>
<div class="card">
<h3>Total Interlibrary Loans</h3>
<p>@Model.TotalInterlibraryLoans</p>
</div>
<div class="card">
<h3>Total Events</h3>
<p>@Model.TotalEvents</p>
</div>
<div class="card">
<h3>Total Feedbacks</h3>
<p>@Model.TotalFeedbacks</p>
</div>
</div>
<style>
.dashboard {
display: grid;
grid-template-columns: repeat(auto-fill, minmax(200px, 1fr));
gap: 20px;
}
.card {
border: 1px solid #ccc;
border-radius: 5px;
padding: 20px;
text-align: center;
background-color: #f9f9f9;
}
</style>
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