Project Introduction
The Library Management System is a web application designed to facilitate the management of library operations, including book borrowing, user management, and notifications. Built using Node.js, this platform allows librarians to manage book inventories and track borrowing records while providing members with an easy way to borrow and return books. The system supports multiple user roles, including admin, librarian, and member, ensuring a tailored experience for each user type. The underlying MySQL database schema is structured to manage users, books, borrowing records, notifications, and payments, providing a robust foundation for effective library management.
Project Objectives
- To develop a user-friendly interface for librarians to manage book inventories and user accounts.
- To implement a secure user authentication system for managing borrowing and returning of books.
- To allow members to search for books, borrow them, and track their borrowing history.
- To manage notifications for users regarding due dates and fines.
- To facilitate payment processing for any fines incurred by members.
- To ensure the application is scalable and maintainable for future enhancements.
Project Modules
- User Management Module:
This module handles user registration, authentication, and role management, allowing users to manage their accounts securely.
- Book Management Module:
This module allows librarians to add, update, and manage book inventories, including details such as title, author, and ISBN.
- Borrowing Management Module:
This module facilitates the borrowing process, allowing members to borrow books and track due dates and return statuses.
- Notification Module:
This module sends notifications to users regarding due dates, return reminders, and any fines incurred.
- Payment Management Module:
This module manages payments for fines, allowing users to pay any outstanding amounts securely.
Steps Overview
Set Up the Project: Initialize a new Node.js project and install the necessary packages.
Configure Sequelize: Set up Sequelize to connect to your MySQL database.
Define Models: Create Sequelize models based on the provided SQL tables.
Create Repositories: Implement repository functions for CRUD operations.
Set Up Controllers: Create controllers to handle requests and responses.
Define Routes: Set up routes to connect the controllers.
Create Views: Use EJS to create views for displaying data.
Implement Bootstrap 5: Style the views using Bootstrap 5.
Create a Dashboard: Create a dashboard to display consolidated data.
Step 1: Set Up the Project
mkdir library-management-system
cd library-management-system
npm init -y
npm install express sequelize mysql2 ejs body-parser
Step 2: Configure Sequelize
Create a file named config.js for database configuration.
// config.js
const { Sequelize } = require('sequelize');
const sequelize = new Sequelize('database_name', 'username', 'password', {
host: 'localhost',
dialect: 'mysql',
});
module.exports = sequelize;
Step 3: Define Models
Create a folder named models and create model files for each table.
models/User.js
const { Model, DataTypes } = require('sequelize');
const sequelize = require('../config');
class User extends Model {}
User .init({
UserId: {
type: DataTypes.INTEGER,
primaryKey: true,
autoIncrement: true,
},
Username: {
type: DataTypes.STRING(50),
allowNull: false,
unique: true,
},
PasswordHash: {
type: DataTypes.STRING(256),
allowNull: false,
},
Email: {
type: DataTypes.STRING(100),
allowNull: false,
unique: true,
},
RoleId: {
type: DataTypes.INTEGER,
},
}, {
sequelize,
modelName: 'User ',
timestamps: true,
});
module.exports = User;
models/Role.js
const { Model, DataTypes } = require('sequelize');
const sequelize = require('../config');
class Role extends Model {}
Role.init({
RoleId: {
type: DataTypes.INTEGER,
primaryKey: true,
autoIncrement: true,
},
RoleName: {
type: DataTypes.STRING(50),
allowNull: false,
unique: true,
},
}, {
sequelize,
modelName: 'Role',
timestamps: false,
});
module.exports = Role;
models/Book.js
const { Model, DataTypes } = require('sequelize');
const sequelize = require('../config');
class Book extends Model {}
Book.init({
BookId: {
type: DataTypes.INTEGER,
primaryKey: true,
autoIncrement: true,
},
Title: {
type: DataTypes.STRING(200),
allowNull: false,
},
Author: {
type: DataTypes.STRING(100),
allowNull: false,
},
ISBN: {
type: DataTypes.STRING(20),
allowNull: false,
unique: true,
},
Publisher: {
type: DataTypes.STRING(100),
},
PublishedDate: {
type: DataTypes.DATE,
},
Category: {
type: DataTypes.STRING(100),
},
CopiesAvailable: {
type: DataTypes.INTEGER,
allowNull: false,
},
}, {
sequelize,
modelName: 'Book',
timestamps: true,
});
module.exports = Book;
models/CatalogItem.js
const { Model, DataTypes } = require('sequelize');
const sequelize = require('../config');
class CatalogItem extends Model {}
CatalogItem.init({
CatalogItemId: {
type: DataTypes.INTEGER,
primaryKey: true,
autoIncrement: true,
},
BookId: {
type: DataTypes.INTEGER,
},
Location: {
type: DataTypes.STRING(100),
},
Status: {
type: DataTypes.STRING(50),
allowNull: false,
},
}, {
sequelize,
modelName: 'CatalogItem',
timestamps: true,
});
module.exports = CatalogItem;
models/CirculationRecord.js
const { Model, DataTypes } = require('sequelize');
const sequelize = require('../config');
class CirculationRecord extends Model {}
CirculationRecord.init({
CirculationRecordId: {
type: DataTypes.INTEGER,
primaryKey: true,
autoIncrement: true,
},
UserId: {
type: DataTypes.INTEGER,
},
CatalogItemId: {
type: DataTypes.INTEGER,
},
CheckoutDate: {
type: DataTypes.DATE,
allowNull: false,
},
DueDate: {
type: DataTypes.DATE,
allowNull: false,
},
ReturnDate: {
type: DataTypes.DATE,
},
}, {
sequelize,
modelName: 'CirculationRecord',
timestamps: true,
});
module.exports = CirculationRecord;
models/Reservation.js
const { Model, DataTypes } = require('sequelize');
const sequelize = require('../config');
class Reservation extends Model {}
Reservation.init({
ReservationId: {
type: DataTypes.INTEGER,
primaryKey: true,
autoIncrement: true,
},
UserId: {
type: DataTypes.INTEGER },
CatalogItemId: {
type: DataTypes.INTEGER,
},
ReservationDate: {
type: DataTypes.DATE,
allowNull: false,
},
ExpirationDate: {
type: DataTypes.DATE,
allowNull: false,
},
}, {
sequelize,
modelName: 'Reservation',
timestamps: true,
});
module.exports = Reservation;
models/InventoryItem.js
const { Model, DataTypes } = require('sequelize');
const sequelize = require('../config');
class InventoryItem extends Model {}
InventoryItem.init({
InventoryItemId: {
type: DataTypes.INTEGER,
primaryKey: true,
autoIncrement: true,
},
BookId: {
type: DataTypes.INTEGER,
},
Quantity: {
type: DataTypes.INTEGER,
allowNull: false,
},
}, {
sequelize,
modelName: 'InventoryItem',
timestamps: true,
});
module.exports = InventoryItem;
models/Membership.js
const { Model, DataTypes } = require('sequelize');
const sequelize = require('../config');
class Membership extends Model {}
Membership.init({
MembershipId: {
type: DataTypes.INTEGER,
primaryKey: true,
autoIncrement: true,
},
UserId: {
type: DataTypes.INTEGER,
},
MembershipType: {
type: DataTypes.STRING(50),
allowNull: false,
},
StartDate: {
type: DataTypes.DATE,
allowNull: false,
},
ExpirationDate: {
type: DataTypes.DATE,
allowNull: false,
},
}, {
sequelize,
modelName: 'Membership',
timestamps: true,
});
module.exports = Membership;
models/DigitalResource.js
const { Model, DataTypes } = require('sequelize');
const sequelize = require('../config');
class DigitalResource extends Model {}
DigitalResource.init({
DigitalResourceId: {
type: DataTypes.INTEGER,
primaryKey: true,
autoIncrement: true,
},
Title: {
type: DataTypes.STRING(200),
allowNull: false,
},
ResourceType: {
type: DataTypes.STRING(50),
allowNull: false,
},
URL: {
type: DataTypes.STRING(256),
allowNull: false,
},
}, {
sequelize,
modelName: 'DigitalResource',
timestamps: true,
});
module.exports = DigitalResource;
models/InterlibraryLoan.js
const { Model, DataTypes } = require('sequelize');
const sequelize = require('../config');
class InterlibraryLoan extends Model {}
InterlibraryLoan.init({
InterlibraryLoanId: {
type: DataTypes.INTEGER,
primaryKey: true,
autoIncrement: true,
},
UserId: {
type: DataTypes.INTEGER,
},
BookId: {
type: DataTypes.INTEGER,
},
LoanDate: {
type: DataTypes.DATE,
allowNull: false,
},
DueDate: {
type: DataTypes.DATE,
allowNull: false,
},
}, {
sequelize,
modelName: 'InterlibraryLoan',
timestamps: true,
});
module.exports = InterlibraryLoan;
models/Event.js
const { Model, DataTypes } = require('sequelize');
const sequelize = require('../config');
class Event extends Model {}
Event.init({
EventId: {
type: DataTypes.INTEGER,
primaryKey: true,
autoIncrement: true,
},
Title: {
type: DataTypes.STRING(100),
allowNull: false,
},
Description: {
type: DataTypes.TEXT,
},
EventDate: {
type: DataTypes.DATE,
allowNull: false,
},
}, {
sequelize,
modelName: 'Event',
timestamps: true,
});
module.exports = Event;
models/Feedback.js
const { Model, DataTypes } = require('sequelize');
const sequelize = require('../config');
class Feedback extends Model {}
Feedback.init({
FeedbackId: {
type: DataTypes.INTEGER,
primaryKey: true,
autoIncrement: true,
},
UserId: {
type: DataTypes.INTEGER,
},
Comments: {
type: DataTypes.TEXT,
},
}, {
sequelize,
modelName: 'Feedback',
timestamps: true,
});
module.exports = Feedback;
Step 4: Create Repositories
Create a folder named repositories and implement repository functions for CRUD operations.
repositories/userRepository.js
const User = require('../models/User');
class UserRepository {
async createUser (data) {
return await User.create(data);
}
async getAllUsers() {
return await User.find All();
}
async getUser ById(userId) {
return await User.findByPk(userId);
}
async updateUser (userId, data) {
await User.update(data, { where: { UserId: userId } });
return this.getUser ById(userId);
}
async deleteUser (userId) {
return await User.destroy({ where: { UserId: userId } });
}
}
module.exports = new UserRepository();
repositories/roleRepository.js
const Role = require('../models/Role');
class RoleRepository {
async createRole(data) {
return await Role.create(data);
}
async getAllRoles() {
return await Role.findAll();
}
async getRoleById(roleId) {
return await Role.findByPk(roleId);
}
async updateRole(roleId, data) {
await Role.update(data, { where: { RoleId: roleId } });
return this.getRoleById(roleId);
}
async deleteRole(roleId) {
return await Role.destroy({ where: { RoleId: roleId } });
}
}
module.exports = new RoleRepository();
Step 5: Set Up Controllers
Create a folder named controllers and implement controllers to handle requests.
controllers/userController.js
const userRepository = require('../repositories/userRepository');
class UserController {
async createUser (req, res) {
try {
const user = await userRepository.createUser (req.body);
res.status(201).json(user);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async getAllUsers(req, res) {
try {
const users = await userRepository.getAllUsers();
res.status(200).json(users);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async getUser ById(req, res) {
try {
const user = await userRepository.getUser ById(req.params.id);
if (!user) return res.status(404).json({ error: 'User not found' });
res.status(200).json(user);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async updateUser (req, res) {
try {
const user = await userRepository.updateUser (req.params.id, req.body);
if (!user) return res.status(404).json({ error: 'User not found' });
res.status(200).json(user);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async deleteUser (req, res) {
try {
const result = await userRepository.deleteUser (req.params.id);
if (!result) return res.status(404).json({ error: 'User not found' });
res.status(204).send();
} catch (error) {
res.status(500).json({ error: error.message });
}
}
}
module.exports = new UserController();
Step 6: Define Routes
Create a folder named routes and set up routes to connect the controllers.
routes/userRoutes.js
const express = require('express');
const router = express.Router();
const userController = require('../controllers/userController');
router.post('/', userController.createUser );
router.get('/', userController.getAllUsers);
router.get('/:id', userController.getUser ById);
router.put('/:id', userController.updateUser );
router.delete('/:id', userController.deleteUser );
module.exports = router;
Step 7: Create Views
Create a folder named views and create EJS files for displaying data.
views/users.ejs
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Users</title>
</head>
<body>
<div class="container">
<h1 class="mt-4">Users</h1>
<table class="table">
<thead>
<tr>
<th>UserId</th>
<th>Username</th>
<th>Email</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
<% users.forEach(user => { %>
<tr>
<td><%= user.UserId %></td>
<td><%= user.Username %></td>
<td><%= user.Email %></td>
<td>
<a href="/users/<%= user.UserId %>" class="btn btn-info">View</a>
<a href="/users/<%= user.UserId %>/edit" class="btn btn-warning">Edit</a>
<form action="/users/<%= user.UserId %>" method="POST" style="display:inline;">
<input type="hidden" name="_method" value="DELETE">
<button type="submit" class="btn btn-danger">Delete</button>
</form>
</td>
</tr>
<% }) %>
</tbody>
</table>
<a href="/users/new" class="btn btn-primary">Add User</a>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
views/userForm.ejs
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title><%= user ? 'Edit User' : 'Add User' %></title>
</head>
<body>
<div class="container">
<h1 class="mt-4"><%= user ? 'Edit User' : 'Add User' %></h1>
<form action="<%= user ? '/users/' + user.UserId : '/users' %>" method="POST">
<% if (user) { %>
<input type="hidden" name="_method" value="PUT">
<% } %>
<div class="mb-3">
<label for="Username" class="form-label">Username</label>
<input type="text" class="form-control" id="Username" name="Username" value="<%= user ? user.Username : '' %>" required>
</div>
<div class="mb-3">
<label for="Email" class="form-label">Email</label>
<input type="email" class="form-control" id="Email" name="Email" value="<%= user ? user.Email : '' %>" required>
</div>
<button type="submit" class="btn btn-primary"><%= user ? 'Update User' : 'Create User' %></button>
<a href="/users" class="btn btn-secondary">Cancel</a>
</form>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
Step 8: Implement Bootstrap 5
The views already include Bootstrap 5 for styling. Ensure that the Bootstrap CSS and JS links are included in the head and body sections of your EJS files.
Step 9: Create a Dashboard
You can create a dashboard similar to the one previously described, aggregating data from the various models. Create a new controller and route for the dashboard.
controllers/dashboardController.js
const User = require('../models/User');
const Role = require('../models/Role');
const Book = require('../models/Book');
class DashboardController {
async getDashboard(req, res) {
try {
const userCount = await User.count();
const roleCount = await Role.count();
const bookCount = await Book.count();
res.render('dashboard', {
userCount,
roleCount,
bookCount,
});
} catch (error) {
console.error(error);
res.status(500).send('Internal Server Error');
}
}
}
module.exports = new DashboardController();
routes/dashboardRoutes.js
const express = require('express');
const router = express.Router();
const dashboardController = require('../controllers/dashboardController');
router.get('/', dashboardController.getDashboard);
module.exports = router;
views/dashboard.ejs
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Dashboard</title>
</head>
<body>
<div class="container">
<h1 class="mt-4">Dashboard</h1>
<div class="row mt-4">
<div class="col-md-4">
<div class="card text-white bg-primary mb-3">
<div class="card-header">Total Users</div>
<div class="card-body">
<h 5 class="card-title"><%= userCount %></h5>
<p class="card-text">Total number of registered users.</p>
</div>
</div>
</div>
<div class="col-md-4">
<div class="card text-white bg-success mb-3">
<div class="card-header">Total Roles</div>
<div class="card-body">
<h5 class="card-title"><%= roleCount %></h5>
<p class="card-text">Total number of roles defined.</p>
</div>
</div>
</div>
<div class="col-md-4">
<div class="card text-white bg-info mb-3">
<div class="card-header">Total Books</div>
<div class="card-body">
<h5 class="card-title"><%= bookCount %></h5>
<p class="card-text">Total number of books available.</p>
</div>
</div>
</div>
</div>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
Final Steps
Run the Application: Start your application by running node index.js in your terminal.
Access the Dashboard: Open your browser and navigate to http://localhost:3000/dashboard to view the dashboard.
Manage Users: Navigate to http://localhost:3000/users to manage users, including creating, updating, and deleting user records.
This implementation provides a complete CRUD application for managing users, roles, and books in a library management system, along with a dashboard to visualize key metrics.
Define Remaining Models
Create model files for each remaining table in the models directory.
models/CatalogItem.js
const { Model, DataTypes } = require('sequelize');
const sequelize = require('../config');
class CatalogItem extends Model {}
CatalogItem.init({
CatalogItemId: {
type: DataTypes.INTEGER,
primaryKey: true,
autoIncrement: true,
},
BookId: {
type: DataTypes.INTEGER,
allowNull: false,
},
Location: {
type: DataTypes.STRING(100),
},
Status: {
type: DataTypes.STRING(50),
allowNull: false,
},
}, {
sequelize,
modelName: 'CatalogItem',
timestamps: true,
});
module.exports = CatalogItem;
models/CirculationRecord.js
const { Model, DataTypes } = require('sequelize');
const sequelize = require('../config');
class CirculationRecord extends Model {}
CirculationRecord.init({
CirculationRecordId: {
type: DataTypes.INTEGER,
primaryKey: true,
autoIncrement: true,
},
UserId: {
type: DataTypes.INTEGER,
allowNull: false,
},
CatalogItemId: {
type: DataTypes.INTEGER,
allowNull: false,
},
CheckoutDate: {
type: DataTypes.DATE,
allowNull: false,
},
DueDate: {
type: DataTypes.DATE,
allowNull: false,
},
ReturnDate: {
type: DataTypes.DATE,
},
}, {
sequelize,
modelName: 'CirculationRecord',
timestamps: true,
});
module.exports = CirculationRecord;
models/Reservation.js
const { Model, DataTypes } = require('sequelize');
const sequelize = require('../config');
class Reservation extends Model {}
Reservation.init({
ReservationId: {
type: DataTypes.INTEGER,
primaryKey: true,
autoIncrement: true,
},
UserId: {
type: DataTypes.INTEGER,
allowNull: false,
},
CatalogItemId: {
type: DataTypes.INTEGER,
allowNull: false,
},
ReservationDate: {
type: DataTypes.DATE,
allowNull: false,
},
ExpirationDate: {
type: DataTypes.DATE,
allowNull: false,
},
}, {
sequelize,
modelName: 'Reservation',
timestamps: true,
});
module.exports = Reservation;
models/InventoryItem.js
const { Model, DataTypes } = require('sequelize');
const sequelize = require('../config');
class InventoryItem extends Model {}
InventoryItem.init({
InventoryItemId: {
type: DataTypes.INTEGER,
primaryKey: true,
autoIncrement: true,
},
BookId: {
type: DataTypes.INTEGER,
allowNull: false,
},
Quantity: {
type: DataTypes.INTEGER,
allowNull: false,
},
}, {
sequelize,
modelName: 'InventoryItem',
timestamps: true,
});
module.exports = InventoryItem;
models/Membership.js
const { Model, DataTypes } = require('sequelize');
const sequelize = require('../config');
class Membership extends Model {}
Membership.init({
MembershipId: {
type: DataTypes.INTEGER,
primaryKey: true,
autoIncrement: true,
},
UserId: {
type: DataTypes.INTEGER,
allowNull: false,
},
MembershipType: {
type: DataTypes.STRING(50),
allowNull: false,
},
StartDate: {
type: DataTypes.DATE,
allowNull: false,
},
ExpirationDate: {
type: DataTypes.DATE,
allowNull: false,
},
}, {
sequelize,
modelName: 'Membership',
timestamps: true,
});
module.exports = Membership;
models/DigitalResource.js
const { Model, DataTypes } = require('sequelize');
const sequelize = require('../config');
class DigitalResource extends Model {}
DigitalResource.init({
DigitalResourceId: {
type: DataTypes.INTEGER,
primaryKey: true,
autoIncrement: true,
},
Title: {
type: DataTypes.STRING(200),
allowNull: false,
},
ResourceType: {
type: DataTypes.STRING(50),
allowNull: false,
},
URL: {
type: DataTypes.STRING(256),
allowNull: false,
},
}, {
sequelize,
modelName: 'DigitalResource',
timestamps: true,
});
module.exports = DigitalResource;
models/InterlibraryLoan.js
const { Model, DataTypes } = require('sequelize');
const sequelize = require('../config');
class InterlibraryLoan extends Model {}
InterlibraryLoan.init({
InterlibraryLoanId: {
type: DataTypes.INTEGER,
primaryKey: true,
autoIncrement: true,
},
UserId: {
type: DataTypes.INTEGER,
allowNull: false,
},
BookId: {
type: DataTypes.INTEGER,
allowNull: false,
},
LoanDate: {
type: DataTypes.DATE,
allowNull: false,
},
DueDate: {
type: DataTypes.DATE,
allowNull: false,
},
}, {
sequelize,
modelName: 'InterlibraryLoan',
timestamps : true,
});
module.exports = InterlibraryLoan;
models/Event.js
const { Model, DataTypes } = require('sequelize');
const sequelize = require('../config');
class Event extends Model {}
Event.init({
EventId: {
type: DataTypes.INTEGER,
primaryKey: true,
autoIncrement: true,
},
Title: {
type: DataTypes.STRING(100),
allowNull: false,
},
Description: {
type: DataTypes.TEXT,
},
EventDate: {
type: DataTypes.DATE,
allowNull: false,
},
}, {
sequelize,
modelName: 'Event',
timestamps: true,
});
module.exports = Event;
models/Feedback.js
const { Model, DataTypes } = require('sequelize');
const sequelize = require('../config');
class Feedback extends Model {}
Feedback.init({
FeedbackId: {
type: DataTypes.INTEGER,
primaryKey: true,
autoIncrement: true,
},
UserId: {
type: DataTypes.INTEGER,
allowNull: false,
},
Comments: {
type: DataTypes.TEXT,
},
}, {
sequelize,
modelName: 'Feedback',
timestamps: true,
});
module.exports = Feedback;
Create Repositories
Create repository files for each model in the repositories directory.
repositories/bookRepository.js
const Book = require('../models/Book');
class BookRepository {
async createBook(data) {
return await Book.create(data);
}
async getAllBooks() {
return await Book.findAll();
}
async getBookById(bookId) {
return await Book.findByPk(bookId);
}
async updateBook(bookId, data) {
await Book.update(data, { where: { BookId: bookId } });
return this.getBookById(bookId);
}
async deleteBook(bookId) {
return await Book.destroy({ where: { BookId: bookId } });
}
}
module.exports = new BookRepository();
repositories/catalogItemRepository.js
const CatalogItem = require('../models/CatalogItem');
class CatalogItemRepository {
async createCatalogItem(data) {
return await CatalogItem.create(data);
}
async getAllCatalogItems() {
return await CatalogItem.findAll();
}
async getCatalogItemById(catalogItemId) {
return await CatalogItem.findByPk(catalogItemId);
}
async updateCatalogItem(catalogItemId, data) {
await CatalogItem.update(data, { where: { CatalogItemId: catalogItemId } });
return this.getCatalogItemById(catalogItemId);
}
async deleteCatalogItem(catalogItemId) {
return await CatalogItem.destroy({ where: { CatalogItemId: catalogItemId } });
}
}
module.exports = new CatalogItemRepository();
repositories/circulationRecordRepository.js
const CirculationRecord = require('../models/CirculationRecord');
class CirculationRecordRepository {
async createCirculationRecord(data) {
return await CirculationRecord.create(data);
}
async getAllCirculationRecords() {
return await CirculationRecord.findAll();
}
async getCirculationRecordById(recordId) {
return await CirculationRecord.findByPk(recordId);
}
async updateCirculationRecord(recordId, data) {
await CirculationRecord.update(data, { where: { CirculationRecordId: recordId } });
return this.getCirculationRecordById(recordId);
}
async deleteCirculationRecord(recordId) {
return await CirculationRecord.destroy({ where: { CirculationRecordId: recordId } });
}
}
module.exports = new CirculationRecordRepository();
repositories/reservationRepository.js
const Reservation = require('../models/Reservation');
class ReservationRepository {
async createReservation(data) {
return await Reservation.create(data);
}
async getAllReservations() {
return await Reservation.findAll();
}
async getReservationById(reservationId) {
return await Reservation.findByPk(reservationId);
}
async updateReservation(reservationId, data) {
await Reservation.update(data, { where: { ReservationId: reservationId } });
return this.getReservationById(reservationId);
}
async deleteReservation(reservationId) {
return await Reservation.destroy({ where: { ReservationId: reservationId } });
}
}
module.exports = new ReservationRepository();
repositories/inventoryItemRepository.js
const InventoryItem = require('../models/InventoryItem');
class InventoryItemRepository {
async createInventoryItem(data) {
return await InventoryItem.create(data);
}
async getAllInventoryItems(){
return await InventoryItem.findAll();
}
async getInventoryItemById(inventoryItemId) {
return await InventoryItem.findByPk(inventoryItemId);
}
async updateInventoryItem(inventoryItemId, data) {
await InventoryItem.update(data, { where: { InventoryItemId: inventoryItemId } });
return this.getInventoryItemById(inventoryItemId);
}
async deleteInventoryItem(inventoryItemId) {
return await InventoryItem.destroy({ where: { InventoryItemId: inventoryItemId } });
}
}
module.exports = new InventoryItemRepository();
repositories/membershipRepository.js
const Membership = require('../models/Membership');
class MembershipRepository {
async createMembership(data) {
return await Membership.create(data);
}
async getAllMemberships() {
return await Membership.findAll();
}
async getMembershipById(membershipId) {
return await Membership.findByPk(membershipId);
}
async updateMembership(membershipId, data) {
await Membership.update(data, { where: { MembershipId: membershipId } });
return this.getMembershipById(membershipId);
}
async deleteMembership(membershipId) {
return await Membership.destroy({ where: { MembershipId: membershipId } });
}
}
module.exports = new MembershipRepository();
repositories/digitalResourceRepository.js
const DigitalResource = require('../models/DigitalResource');
class DigitalResourceRepository {
async createDigitalResource(data) {
return await DigitalResource.create(data);
}
async getAllDigitalResources() {
return await DigitalResource.findAll();
}
async getDigitalResourceById(resourceId) {
return await DigitalResource.findByPk(resourceId);
}
async updateDigitalResource(resourceId, data) {
await DigitalResource.update(data, { where: { DigitalResourceId: resourceId } });
return this.getDigitalResourceById(resourceId);
}
async deleteDigitalResource(resourceId) {
return await DigitalResource.destroy({ where: { DigitalResourceId: resourceId } });
}
}
module.exports = new DigitalResourceRepository();
repositories/interlibraryLoanRepository.js
const InterlibraryLoan = require('../models/InterlibraryLoan');
class InterlibraryLoanRepository {
async createInterlibraryLoan(data) {
return await InterlibraryLoan.create(data);
}
async getAllInterlibraryLoans() {
return await InterlibraryLoan.findAll();
}
async getInterlibraryLoanById(loanId) {
return await InterlibraryLoan.findByPk(loanId);
}
async updateInterlibraryLoan(loanId, data) {
await InterlibraryLoan.update(data, { where: { InterlibraryLoanId: loanId } });
return this.getInterlibraryLoanById(loanId);
}
async deleteInterlibraryLoan(loanId) {
return await InterlibraryLoan.destroy({ where: { InterlibraryLoanId: loanId } });
}
}
module.exports = new InterlibraryLoanRepository();
repositories/eventRepository.js
const Event = require('../models/Event');
class EventRepository {
async createEvent(data) {
return await Event.create(data);
}
async getAllEvents() {
return await Event.findAll();
}
async getEventById(eventId) {
return await Event.findByPk(eventId);
}
async updateEvent(eventId, data) {
await Event.update(data, { where: { EventId: eventId } });
return this.getEventById(eventId);
}
async deleteEvent(eventId) {
return await Event.destroy({ where: { EventId: eventId } });
}
}
module.exports = new EventRepository();
repositories/feedbackRepository.js
const Feedback = require('../models/Feedback');
class FeedbackRepository {
async createFeedback(data) {
return await Feedback.create(data);
}
async getAllFeedbacks() {
return await Feedback.findAll();
}
async getFeedbackById(feedbackId) {
return await Feedback.findByPk(feedbackId);
}
async updateFeedback(feedbackId, data) {
await Feedback.update(data, { where: { FeedbackId: feedbackId } });
return this.getFeedbackById(feedbackId);
}
async deleteFeedback(feedbackId) {
return await Feedback.destroy({ where: { FeedbackId: feedbackId } });
}
}
module.exports = new FeedbackRepository();
Set Up Controllers
Create controller files for each model in the controllers directory.
controllers/bookController.js
const bookRepository = require('../repositories/bookRepository');
class BookController {
async createBook(req, res) {
try {
const book = await bookRepository .createBook(req.body);
res.status(201).json(book);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async getAllBooks(req, res) {
try {
const books = await bookRepository.getAllBooks();
res.status(200).json(books);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async getBookById(req, res) {
try {
const book = await bookRepository.getBookById(req.params.id);
if (!book) return res.status(404).json({ error: 'Book not found' });
res.status(200).json(book);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async updateBook(req, res) {
try {
const book = await bookRepository.updateBook(req.params.id, req.body);
if (!book) return res.status(404).json({ error: 'Book not found' });
res.status(200).json(book);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async deleteBook(req, res) {
try {
const result = await bookRepository.deleteBook(req.params.id);
if (!result) return res.status(404).json({ error: 'Book not found' });
res.status(204).send();
} catch (error) {
res.status(500).json({ error: error.message });
}
}
}
module.exports = new BookController();
controllers/catalogItemController.js
const catalogItemRepository = require('../repositories/catalogItemRepository');
class CatalogItemController {
async createCatalogItem(req, res) {
try {
const catalogItem = await catalogItemRepository.createCatalogItem(req.body);
res.status(201).json(catalogItem);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async getAllCatalogItems(req, res) {
try {
const catalogItems = await catalogItemRepository.getAllCatalogItems();
res.status(200).json(catalogItems);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async getCatalogItemById(req, res) {
try {
const catalogItem = await catalogItemRepository.getCatalogItemById(req.params.id);
if (!catalogItem) return res.status(404).json({ error: 'Catalog Item not found' });
res.status(200).json(catalogItem);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async updateCatalogItem(req, res) {
try {
const catalogItem = await catalogItemRepository.updateCatalogItem(req.params.id, req.body);
if (!catalogItem) return res.status(404).json({ error: 'Catalog Item not found' });
res.status(200).json(catalogItem);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async deleteCatalogItem(req, res) {
try {
const result = await catalogItemRepository.deleteCatalogItem(req.params.id);
if (!result) return res.status(404).json({ error: 'Catalog Item not found' });
res.status(204).send();
} catch (error) {
res.status(500).json({ error: error.message });
}
}
}
module.exports = new CatalogItemController();
controllers/circulationRecordController.js
const circulationRecordRepository = require('../repositories/circulationRecordRepository');
class CirculationRecordController {
async createCirculationRecord(req, res) {
try {
const circulationRecord = await circulationRecordRepository.createCirculationRecord(req.body);
res.status(201).json(circulationRecord);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async getAllCirculationRecords(req, res) {
try {
const circulationRecords = await circulationRecordRepository.getAllCirculationRecords();
res.status(200).json(circulationRecords);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async getCirculationRecordById(req, res) {
try {
const circulationRecord = await circulationRecordRepository.getCirculationRecordById(req.params.id);
if (!circulationRecord) return res.status(404).json({ error: 'Circulation Record not found' });
res.status(200).json(circulationRecord);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async updateCirculationRecord(req, res) {
try {
const circulationRecord = await circulationRecordRepository.updateCirculationRecord(req.params.id, req.body);
if (!circulationRecord) return res.status(404).json({ error: 'Circulation Record not found' });
res.status(200).json(circulationRecord);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async deleteCirculationRecord(req, res) {
try {
const result = await circulationRecordRepository.deleteCirculationRecord(req.params.id);
if (!result) return res.status(404).json({ error: 'Circulation Record not found' });
res.status(204).send();
} catch (error) {
res.status(500).json({ error: error.message });
}
}
}
module.exports = new CirculationRecordController();
controllers/reservationController.js
const reservationRepository = require('../repositories/reservationRepository');
class ReservationController {
async createReservation(req, res) {
try {
const reservation = await reservationRepository.createReservation(req.body);
res.status(201).json(reservation);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async getAllReservations(req, res) {
try {
const reservations = await reservationRepository.getAllReservations();
res.status(200).json(reservations);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async getReservationById(req, res) {
try {
const reservation = await reservationRepository.getReservationById(req.params.id);
if (!reservation) return res.status(404).json({ error: 'Reservation not found' });
res.status(200).json(reservation);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async updateReservation(req, res) {
try {
const reservation = await reservationRepository.updateReservation(req.params.id, req.body);
if (!reservation) return res.status(404).json({ error: 'Reservation not found' });
res.status(200).json(reservation);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async deleteReservation(req, res) {
try {
const result = await reservationRepository.deleteReservation(req.params.id);
if (!result) return res.status(404).json({ error: 'Reservation not found' });
res.status(204).send();
} catch (error) {
res.status(500).json({ error: error.message });
}
}
}
module.exports = new ReservationController();
controllers/inventoryItemController.js
const inventoryItemRepository = require('../repositories/inventoryItemRepository');
class InventoryItemController {
async createInventoryItem(req, res) {
try {
const inventoryItem = await inventoryItemRepository.createInventoryItem(req.body);
res.status(201).json(inventoryItem);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async getAllInventoryItems(req, res) {
try {
const inventoryItems = await inventoryItemRepository.getAllInventoryItems();
res.status(200).json(inventoryItems);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async getInventoryItemById(req, res) {
try {
const inventoryItem = await inventoryItemRepository.getInventoryItemById(req.params.id);
if (!inventoryItem) return res.status(404).json({ error: 'Inventory Item not found' });
res.status(200).json(inventoryItem);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async updateInventoryItem(req, res) {
try {
const inventoryItem = await inventoryItemRepository.updateInventoryItem(req.params.id, req.body);
if (!inventoryItem) return res.status(404).json({ error: 'Inventory Item not found' });
res.status(200).json(inventoryItem);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async deleteInventoryItem(req, res) {
try {
const result = await inventoryItemRepository.deleteInventoryItem(req.params.id);
if (!result) return res.status(404).json({ error: 'Inventory Item not found' });
res.status(204).send();
} catch (error) {
res.status(500).json({ error: error.message });
}
}
}
module.exports = new InventoryItemController();
controllers/membershipController.js
const membershipRepository = require('../repositories/membershipRepository');
class MembershipController {
async createMembership(req, res) {
try {
const membership = await membershipRepository.createMembership(req.body);
res.status(201).json(membership);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async getAllMemberships(req, res) {
try {
const memberships = await membershipRepository.getAllMemberships();
res.status(200).json(memberships);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async getMembershipById(req, res) {
try {
const membership = await membershipRepository.getMembershipById(req.params.id);
if (!membership) return res.status(404).json({ error: 'Membership not found' });
res.status(200).json(membership);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async updateMembership(req, res) {
try {
const membership = await membershipRepository.updateMembership(req.params.id, req.body);
if (!membership) return res.status(404).json({ error: 'Membership not found' });
res.status(200).json(membership);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async deleteMembership(req, res) {
try {
const result = await membershipRepository.deleteMembership(req.params.id);
if (!result) return res.status(404).json({ error: 'Membership not found' });
res.status(204).send();
} catch (error) {
res.status(500).json({ error: error.message });
}
}
}
module.exports = new MembershipController();
controllers/digitalResourceController.js
const digitalResourceRepository = require('../repositories/digitalResourceRepository');
class DigitalResourceController {
async createDigitalResource(req, res) {
try {
const digitalResource = await digitalResourceRepository.createDigitalResource(req.body);
res.status(201).json(digitalResource);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async getAllDigitalResources(req, res) {
try {
const digitalResources = await digitalResourceRepository.getAllDigitalResources();
res.status(200).json(digitalResources);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async getDigitalResourceById(req, res) {
try {
const digitalResource = await digitalResourceRepository.getDigitalResourceById(req.params.id);
if (!digitalResource) return res.status(404).json({ error: 'Digital Resource not found' });
res.status(200).json(digitalResource);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async updateDigitalResource(req, res) {
try {
const digitalResource = await digitalResourceRepository.updateDigitalResource(req.params.id, req.body);
if (!digitalResource) return res.status(404).json({ error: 'Digital Resource not found' });
res.status(200).json(digitalResource);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async deleteDigitalResource(req, res) {
try {
const result = await digitalResourceRepository.deleteDigitalResource(req.params.id);
if (!result) return res.status(404).json({ error: 'Digital Resource not found' });
res.status(204).send();
} catch (error) {
res.status(500).json({ error: error.message });
}
}
}
module.exports = new DigitalResourceController();
controllers/interlibraryLoanController.js
const interlibraryLoanRepository = require('../repositories/interlibraryLoanRepository');
class InterlibraryLoanController {
async createInterlibraryLoan(req, res) {
try {
const interlibraryLoan = await interlibraryLoanRepository.createInterlibraryLoan(req.body);
res.status(201).json(interlibraryLoan);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async getAllInterlibraryLoans(req, res) {
try {
const interlibraryLoans = await interlibraryLoanRepository.getAllInterlibraryLoans();
res.status(200).json(interlibraryLoans);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async getInterlibraryLoanById(req, res) {
try {
const inter libraryLoan = await interlibraryLoanRepository.getInterlibraryLoanById(req.params.id);
if (!interlibraryLoan) return res.status(404).json({ error: 'Interlibrary Loan not found' });
res.status(200).json(interlibraryLoan);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async updateInterlibraryLoan(req, res) {
try {
const interlibraryLoan = await interlibraryLoanRepository.updateInterlibraryLoan(req.params.id, req.body);
if (!interlibraryLoan) return res.status(404).json({ error: 'Interlibrary Loan not found' });
res.status(200).json(interlibraryLoan);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async deleteInterlibraryLoan(req, res) {
try {
const result = await interlibraryLoanRepository.deleteInterlibraryLoan(req.params.id);
if (!result) return res.status(404).json({ error: 'Interlibrary Loan not found' });
res.status(204).send();
} catch (error) {
res.status(500).json({ error: error.message });
}
}
}
module.exports = new InterlibraryLoanController();
controllers/eventController.js
const eventRepository = require('../repositories/eventRepository');
class EventController {
async createEvent(req, res) {
try {
const event = await eventRepository.createEvent(req.body);
res.status(201).json(event);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async getAllEvents(req, res) {
try {
const events = await eventRepository.getAllEvents();
res.status(200).json(events);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async getEventById(req, res) {
try {
const event = await eventRepository.getEventById(req.params.id);
if (!event) return res.status(404).json({ error: 'Event not found' });
res.status(200).json(event);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async updateEvent(req, res) {
try {
const event = await eventRepository.updateEvent(req.params.id, req.body);
if (!event) return res.status(404).json({ error: 'Event not found' });
res.status(200).json(event);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async deleteEvent(req, res) {
try {
const result = await eventRepository.deleteEvent(req.params.id);
if (!result) return res.status(404).json({ error: 'Event not found' });
res.status(204).send();
} catch (error) {
res.status(500).json({ error: error.message });
}
}
}
module.exports = new EventController();
controllers/feedbackController.js
const feedbackRepository = require('../repositories/feedbackRepository');
class FeedbackController {
async createFeedback(req, res) {
try {
const feedback = await feedbackRepository.createFeedback(req.body);
res.status(201).json(feedback);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async getAllFeedbacks(req, res) {
try {
const feedbacks = await feedbackRepository.getAllFeedbacks();
res.status(200).json(feedbacks);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async getFeedbackById(req, res) {
try {
const feedback = await feedbackRepository.getFeedbackById(req.params.id);
if (!feedback) return res.status(404).json({ error: 'Feedback not found' });
res.status(200).json(feedback);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async updateFeedback(req, res) {
try {
const feedback = await feedbackRepository.updateFeedback(req.params.id, req.body);
if (!feedback) return res.status(404).json({ error: 'Feedback not found' });
res.status(200).json(feedback);
} catch (error) {
res.status(500).json({ error: error.message });
}
}
async deleteFeedback(req, res) {
try {
const result = await feedbackRepository.deleteFeedback(req.params.id);
if (!result) return res.status(404).json({ error: 'Feedback not found' });
res.status( 204).send();
} catch (error) {
res.status(500).json({ error: error.message });
}
}
}
module.exports = new FeedbackController();
Define Routes
Create route files for each model in the routes directory.
routes/bookRoutes.js
const express = require('express');
const router = express.Router();
const bookController = require('../controllers/bookController');
router.post('/', bookController.createBook);
router.get('/', bookController.getAllBooks);
router.get('/:id', bookController.getBookById);
router.put('/:id', bookController.updateBook);
router.delete('/:id', bookController.deleteBook);
module.exports = router;
routes/catalogItemRoutes.js
const express = require('express');
const router = express.Router();
const catalogItemController = require('../controllers/catalogItemController');
router.post('/', catalogItemController.createCatalogItem);
router.get('/', catalogItemController.getAllCatalogItems);
router.get('/:id', catalogItemController.getCatalogItemById);
router.put('/:id', catalogItemController.updateCatalogItem);
router.delete('/:id', catalogItemController.deleteCatalogItem);
module.exports = router;
routes/circulationRecordRoutes.js
const express = require('express');
const router = express.Router();
const circulationRecordController = require('../controllers/circulationRecordController');
router.post('/', circulationRecordController.createCirculationRecord);
router.get('/', circulationRecordController.getAllCirculationRecords);
router.get('/:id', circulationRecordController.getCirculationRecordById);
router.put('/:id', circulationRecordController.updateCirculationRecord);
router.delete('/:id', circulationRecordController.deleteCirculationRecord);
module.exports = router;
routes/reservationRoutes.js
const express = require('express');
const router = express.Router();
const reservationController = require('../controllers/reservationController');
router.post('/', reservationController.createReservation);
router.get('/', reservationController.getAllReservations);
router.get('/:id', reservationController.getReservationById);
router.put('/:id', reservationController.updateReservation);
router.delete('/:id', reservationController.deleteReservation);
module.exports = router;
routes/inventoryItemRoutes.js
const express = require('express');
const router = express.Router();
const inventoryItemController = require('../controllers/inventoryItemController');
router.post('/', inventoryItemController.createInventoryItem);
router.get('/', inventoryItemController.getAllInventoryItems);
router.get('/:id', inventoryItemController.getInventoryItemById);
router.put('/:id', inventoryItemController.updateInventoryItem);
router.delete('/:id', inventoryItemController.deleteInventoryItem);
module.exports = router;
routes/membershipRoutes.js
const express = require('express');
const router = express.Router();
const membershipController = require('../controllers/membershipController');
router.post('/', membershipController.createMembership);
router.get('/', membershipController.getAllMemberships);
router.get('/:id', membershipController.getMembershipById);
router.put('/:id', membershipController.updateMembership);
router.delete('/:id', membershipController.deleteMembership);
module.exports = router;
routes/digitalResourceRoutes.js
const express = require('express');
const router = express.Router();
const digitalResourceController = require('../controllers/digitalResourceController');
router.post('/', digitalResourceController.createDigitalResource);
router.get('/', digitalResourceController.getAllDigitalResources);
router.get('/:id', digitalResourceController.getDigitalResourceById);
router.put('/:id', digitalResourceController.updateDigitalResource);
router.delete('/:id', digitalResourceController.deleteDigitalResource);
module.exports = router;
routes/interlibraryLoanRoutes.js
const express = require('express');
const router = express.Router();
const interlibraryLoanController = require('../controllers/interlibraryLoanController');
router.post('/', interlibraryLoanController.createInterlibraryLoan);
router.get('/', interlibraryLoanController.getAllInterlibraryLoans);
router.get('/:id', interlibraryLoanController.getInterlibraryLoanById);
router.put('/:id', interlibraryLoanController.updateInterlibraryLoan);
router.delete('/:id', interlibraryLoanController.deleteInterlibraryLoan);
module.exports = router;
routes/eventRoutes.js
const express = require('express');
const router = express.Router();
const eventController = require('../controllers/eventController');
router.post('/', eventController.createEvent);
router.get('/', eventController.getAllEvents);
router.get('/:id', eventController.getEventById);
router.put('/:id', eventController.updateEvent);
router.delete('/:id', eventController.deleteEvent);
module.exports = router;
routes/feedbackRoutes.js
const express = require('express');
const router = express.Router();
const feedbackController = require('../controllers/feedbackController');
router.post('/', feedbackController.createFeedback);
router.get('/', feedbackController.getAllFeedbacks);
router.get('/:id', feedbackController.getFeedbackById);
router.put('/:id', feedbackController.updateFeedback);
router.delete('/: id', feedbackController.deleteFeedback);
module.exports = router;
Create Views
Create EJS view files for each model in the views directory.
views/books.ejs
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Books</title>
</head>
<body>
<div class="container">
<h1 class="mt-4">Books</h1>
<table class="table">
<thead>
<tr>
<th>BookId</th>
<th>Title</th>
<th>Author</th>
<th>ISBN</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
<% books.forEach(book => { %>
<tr>
<td><%= book.BookId %></td>
<td><%= book.Title %></td>
<td><%= book.Author %></td>
<td><%= book.ISBN %></td>
<td>
<a href="/books/<%= book.BookId %>" class="btn btn-info">View</a>
<a href="/books/<%= book.BookId %>/edit" class="btn btn-warning">Edit</a>
<form action="/books/<%= book.BookId %>" method="POST" style="display:inline;">
<input type="hidden" name="_method" value="DELETE">
<button type="submit" class="btn btn-danger">Delete</button>
</form>
</td>
</tr>
<% }) %>
</tbody>
</table>
<a href="/books/new" class="btn btn-primary">Add Book</a>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
views/bookForm.ejs
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title><%= book ? 'Edit Book' : 'Add Book' %></title>
</head>
<body>
<div class="container">
<h1 class="mt-4"><%= book ? 'Edit Book' : 'Add Book' %></h1>
<form action="<%= book ? '/books/' + book.BookId : '/books' %>" method="POST">
<% if (book) { %>
<input type="hidden" name="_method" value="PUT">
<% } %>
<div class="mb-3">
<label for="Title" class="form-label">Title</label>
<input type="text" class="form-control" id="Title" name="Title" value="<%= book ? book.Title : '' %>" required>
</div>
<div class="mb-3">
<label for="Author" class="form-label">Author</label>
<input type="text" class="form-control" id="Author" name="Author" value="<%= book ? book.Author : '' %>" required>
</div>
<div class="mb-3">
<label for="ISBN" class="form-label">ISBN</label>
<input type="text" class="form-control" id="ISBN" name="ISBN" value="<%= book ? book.ISBN : '' %>" required>
</div>
<button type="submit" class="btn btn-primary"><%= book ? 'Update Book' : 'Create Book' %></button>
<a href="/books" class="btn btn-secondary">Cancel</a>
</form>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
views/catalogItems.ejs
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Catalog Items</title>
</head>
<body>
<div class="container">
<h1 class="mt-4">Catalog Items</h1>
<table class="table">
<thead>
<tr>
<th>CatalogItemId</th>
<th>BookId</th>
<th>Location</th>
<th>Status</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
<% catalogItems.forEach(item => { %>
<tr>
<td><%= item.CatalogItemId %></td>
<td><%= item.BookId %></td>
<td><%= item.Location %></td>
<td><%= item.Status %></td>
<td>
<a href="/catalogItems/<%= item.CatalogItemId %>" class="btn btn-info">View</a>
<a href="/catalogItems/<%= item.CatalogItemId %>/edit" class="btn btn-warning">Edit</a>
<form action="/catalogItems/<%= item.CatalogItemId %>" method="POST" style="display:inline;">
<input type="hidden" name="_method" value="DELETE">
<button type="submit" class="btn btn-danger">Delete</button>
</form>
</td>
</tr>
<% }) %>
</tbody>
</table>
<a href="/catalogItems/new" class="btn btn-primary">Add Catalog Item</a>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
views/catalogItemForm.ejs
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title><%= catalogItem ? 'Edit Catalog Item' : 'Add Catalog Item' %></title>
</head>
<body>
<div class="container">
<h1 class="mt-4"><%= catalogItem ? 'Edit Catalog Item' : 'Add Catalog Item' %></h1>
<form action="<%= catalogItem ? '/catalogItems/' + catalogItem.CatalogItemId : '/catalogItems' %>" method="POST">
<% if (catalogItem) { %>
<input type="hidden" name="_method" value="PUT">
<% } %>
<div class="mb-3">
<label for="BookId" class="form-label">Book ID</label>
<input type="number" class="form-control" id="BookId" name="BookId" value="<%= catalogItem ? catalogItem.BookId : '' %>" required>
</div>
<div class="mb-3">
<label for="Location" class="form-label">Location</label>
<input type="text" class="form-control" id="Location" name="Location" value="<%= catalogItem ? catalogItem.Location : '' %>" required>
</div>
<div class="mb-3">
<label for="Status" class="form-label">Status</label>
<input type="text" class="form-control" id="Status" name="Status" value="<%= catalogItem ? catalogItem.Status : '' %>" required>
</div>
<button type="submit" class="btn btn-primary"><%= catalogItem ? 'Update Catalog Item' : 'Create Catalog Item' %></button>
<a href="/catalogItems" class="btn btn-secondary">Cancel</a>
</form>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
views/circulationRecords.ejs
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Circulation Records</title>
</head>
<body>
<div class="container">
<h1 class="mt-4">Circulation Records</h1>
<table class="table">
<thead>
<tr>
<th>RecordId</th>
<th>UserId</th>
<th>CatalogItemId</th>
<th>CheckoutDate</th>
<th>DueDate</th>
<th>ReturnDate</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
<% circulationRecords.forEach(record => { %>
<tr>
<td><%= record.CirculationRecordId %></td>
<td><%= record.UserId %></td>
<td><%= record.CatalogItemId %></td>
<td><%= record.CheckoutDate %></td>
<td><%= record.DueDate %></td>
<td><%= record.ReturnDate ? record.ReturnDate : 'Not Returned' %></td>
<td>
<a href="/circulationRecords/<%= record.CirculationRecordId %>" class="btn btn-info">View</a>
<a href="/circulationRecords/<%= record.CirculationRecordId %>/edit" class="btn btn-warning">Edit</a>
<form action="/circulationRecords/<%= record.CirculationRecordId %>" method="POST" style="display:inline;">
<input type="hidden" name="_method" value="DELETE">
<button type="submit" class="btn btn-danger">Delete</button>
</form>
</td>
</tr>
<% }) %>
</tbody>
</table>
<a href="/circulationRecords/new" class="btn btn-primary">Add Circulation Record</a>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
views/circulationRecordForm.ejs
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title><%= circulationRecord ? 'Edit Circulation Record' : 'Add Circulation Record' %></title>
</head>
<body>
<div class="container">
<h1 class="mt-4"><%= circulationRecord ? 'Edit Circulation Record' : 'Add Circulation Record' %></h1>
<form action="<%= circulationRecord ? '/circulationRecords/' + circulationRecord.CirculationRecordId : '/circulationRecords' %>" method="POST">
<% if (circulationRecord) { %>
<input type="hidden" name="_method" value="PUT">
<% } %>
<div class="mb-3">
<label for="User Id" class="form-label">User ID</label>
<input type="number" class="form-control" id="User Id" name="User Id" value="<%= circulationRecord ? circulationRecord.UserId : '' %>" required>
</div>
<div class="mb-3">
<label for="CatalogItemId" class="form-label">Catalog Item ID</label>
<input type="number" class="form-control" id="CatalogItemId" name="CatalogItemId" value="<%= circulationRecord ? circulationRecord.CatalogItemId : '' %>" required>
</div>
<div class="mb-3">
<label for="CheckoutDate" class="form-label">Checkout Date</label>
<input type="date" class="form-control" id="CheckoutDate" name="CheckoutDate" value="<%= circulationRecord ? circulationRecord.CheckoutDate.toISOString().split('T')[0] : '' %>" required>
</div>
<div class="mb-3">
<label for="DueDate" class="form-label">Due Date</label>
<input type="date" class="form-control" id="DueDate" name="DueDate" value="<%= circulationRecord ? circulationRecord.DueDate.toISOString().split('T')[0] : '' %>" required>
</div>
<button type="submit" class="btn btn-primary"><%= circulationRecord ? 'Update Circulation Record' : 'Create Circulation Record' %></button>
<a href="/circulationRecords" class="btn btn-secondary">Cancel</a>
</form>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
views/reservations.ejs
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm /bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Reservations</title>
</head>
<body>
<div class="container">
<h1 class="mt-4">Reservations</h1>
<table class="table">
<thead>
<tr>
<th>ReservationId</th>
<th>UserId</th>
<th>CatalogItemId</th>
<th>ReservationDate</th>
<th>ExpirationDate</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
<% reservations.forEach(reservation => { %>
<tr>
<td><%= reservation.ReservationId %></td>
<td><%= reservation.UserId %></td>
<td><%= reservation.CatalogItemId %></td>
<td><%= reservation.ReservationDate %></td>
<td><%= reservation.ExpirationDate %></td>
<td>
<a href="/reservations/<%= reservation.ReservationId %>" class="btn btn-info">View</a>
<a href="/reservations/<%= reservation.ReservationId %>/edit" class="btn btn-warning">Edit</a>
<form action="/reservations/<%= reservation.ReservationId %>" method="POST" style="display:inline;">
<input type="hidden" name="_method" value="DELETE">
<button type="submit" class="btn btn-danger">Delete</button>
</form>
</td>
</tr>
<% }) %>
</tbody>
</table>
<a href="/reservations/new" class="btn btn-primary">Add Reservation</a>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
views/reservationForm.ejs
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title><%= reservation ? 'Edit Reservation' : 'Add Reservation' %></title>
</head>
<body>
<div class="container">
<h1 class="mt-4"><%= reservation ? 'Edit Reservation' : 'Add Reservation' %></h1>
<form action="<%= reservation ? '/reservations/' + reservation.ReservationId : '/reservations' %>" method="POST">
<% if (reservation) { %>
<input type="hidden" name="_method" value="PUT">
<% } %>
<div class="mb-3">
<label for="User Id" class="form-label">User ID</label>
<input type="number" class="form-control" id="User Id" name="User Id" value="<%= reservation ? reservation.UserId : '' %>" required>
</div>
<div class="mb-3">
<label for="CatalogItemId" class="form-label">Catalog Item ID</label>
<input type="number" class="form-control" id="CatalogItemId" name="CatalogItemId" value="<%= reservation ? reservation.CatalogItemId : '' %>" required>
</div>
<div class="mb-3">
<label for="ReservationDate" class="form-label">Reservation Date</label>
<input type="date" class="form-control" id="ReservationDate" name="ReservationDate" value="<%= reservation ? reservation.ReservationDate.toISOString().split('T')[0] : '' %>" required>
</div>
<div class="mb-3">
<label for="ExpirationDate" class="form-label">Expiration Date</label>
<input type="date" class="form-control" id="ExpirationDate" name="ExpirationDate" value="<%= reservation ? reservation.ExpirationDate.toISOString().split('T')[0] : '' %>" required>
</div>
<button type="submit" class="btn btn-primary"><%= reservation ? 'Update Reservation' : 'Create Reservation' %></button>
<a href="/reservations" class="btn btn-secondary">Cancel</a>
</form>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
views/inventoryItems.ejs
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Inventory Items</title>
</head>
<body>
<div class="container">
<h1 class="mt-4">Inventory Items</h1>
<table class="table">
<thead>
<tr>
<th>InventoryItemId</th>
<th>BookId</th>
<th>Quantity</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
<% inventoryItems.forEach(item => { %>
<tr>
<td><%= item.InventoryItemId %></td>
<td><%= item.BookId %></td>
<td><%= item.Quantity %></td>
<td>
<a href="/inventoryItems/<%= item.InventoryItemId %>" class="btn btn-info">View</a>
<a href="/inventoryItems/<%= item.InventoryItemId %>/edit" class="btn btn-warning">Edit</a>
<form action="/inventoryItems/<%= item.InventoryItemId %>" method="POST" style="display:inline;">
<input type="hidden" name="_method" value="DELETE">
<button type="submit" class="btn btn-danger">Delete</button>
</form>
</td>
</tr>
<% }) %>
</tbody>
</table>
<a href="/inventoryItems/new" class="btn btn-primary">Add Inventory Item</a>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
views/inventoryItemForm.ejs
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title><%= inventoryItem ? 'Edit Inventory Item' : 'Add Inventory Item' %></title>
</head>
<body>
<div class="container">
<h1 class="mt-4"><%= inventoryItem ? 'Edit Inventory Item' : 'Add Inventory Item' %></h1>
<form action="<%= inventoryItem ? '/inventoryItems/' + inventoryItem.InventoryItemId : '/inventoryItems' %>" method="POST">
<% if (inventoryItem) { %>
<input type="hidden" name="_method" value="PUT">
<% } %>
<div class="mb-3">
<label for="BookId" class="form-label">Book ID</label>
<input type="number" class="form-control" id="BookId" name="BookId" value="<%= inventoryItem ? inventoryItem.BookId : '' %>" required>
</div>
<div class="mb-3">
<label for="Quantity" class="form-label">Quantity</label>
<input type="number" class="form-control" id="Quantity" name="Quantity" value="<%= inventoryItem ? inventoryItem.Quantity : '' %>" required>
</div>
<button type="submit" class="btn btn-primary"><%= inventoryItem ? 'Update Inventory Item' : 'Create Inventory Item' %></button>
<a href="/inventoryItems" class="btn btn-secondary">Cancel</a>
</form>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
views/memberships.ejs
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Memberships</title>
</head>
<body>
<div class="container">
<h1 class="mt-4">Memberships</h1>
<table class="table">
<thead>
<tr>
<th>MembershipId</th>
<th>UserId</th>
<th>MembershipType</th>
<th>StartDate</th>
<th>ExpirationDate</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
<% memberships.forEach(membership => { %>
<tr>
<td><%= membership.MembershipId %></td>
<td><%= membership.UserId %></td>
<td><%= membership.MembershipType %></td>
<td><%= membership.StartDate %></td>
<td><%= membership.ExpirationDate %></td>
<td>
<a href="/memberships/<%= membership.MembershipId %>" class="btn btn-info">View</a>
<a href="/memberships/<%= membership.MembershipId %>/edit" class="btn btn-warning">Edit</a>
<form action="/memberships/<%= membership.MembershipId %>" method="POST" style="display:inline;">
<input type="hidden" name="_method" value="DELETE">
<button type="submit" class="btn btn-danger">Delete</button>
</form>
</td>
</tr>
<% }) %>
</tbody>
</table>
<a href="/memberships/new" class="btn btn-primary">Add Membership</a>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
views/membershipForm.ejs
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title><%= membership ? 'Edit Membership' : 'Add Membership' %></title>
</head>
<body>
<div class="container">
<h1 class="mt-4"><%= membership ? 'Edit Membership' : 'Add Membership' %></h1>
<form action="<%= membership ? '/memberships/' + membership.MembershipId : '/memberships' %>" method="POST">
<% if (membership) { %>
<input type="hidden" name="_method" value="PUT">
<% } %>
<div class="mb-3">
<label for="User Id" class="form-label">User ID</label>
<input type="number" class="form-control" id="User Id" name="User Id" value="<%= membership ? membership.UserId : '' %>" required>
</div>
<div class="mb-3">
<label for="MembershipType" class="form-label">Membership Type</label>
<input type="text" class="form-control" id="MembershipType" name="MembershipType" value="<%= membership ? membership.MembershipType : '' %>" required>
</div>
<div class="mb-3">
<label for="StartDate" class="form-label">Start Date</label>
<input type="date" class="form-control" id="StartDate" name="StartDate" value="<%= membership ? membership.StartDate.toISOString().split('T')[0] : '' %>" required>
</div>
<div class="mb-3">
<label for="ExpirationDate" class="form-label">Expiration Date</label>
<input type="date" class="form-control" id="ExpirationDate" name="ExpirationDate" value="<%= membership ? membership.ExpirationDate.toISOString().split('T')[0] : '' %>" required>
</div>
<button type="submit" class="btn btn-primary"><%= membership ? 'Update Membership' : 'Create Membership' %></button>
<a href="/memberships" class="btn btn-secondary">Cancel</a>
</form>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
views/digitalResources.ejs
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Digital Resources</title>
</head>
<body>
<div class="container">
<h1 class="mt-4">Digital Resources</h1>
<table class="table">
<thead>
<tr>
<th>DigitalResourceId</th>
<th>Title</th>
<th>ResourceType</th>
<th>URL</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
<% digitalResources.forEach(resource => { %>
<tr>
<td><%= resource.DigitalResourceId %></td>
<td><%= resource.Title %></td>
<td><%= resource.ResourceType %></td>
<td><%= resource.URL %></td>
<td>
<a href="/digitalResources/<%= resource.DigitalResourceId %>" class="btn btn-info">View</a>
<a href="/digitalResources/<%= resource.DigitalResourceId %>/edit" class="btn btn-warning">Edit</a>
<form action="/digitalResources/<%= resource.DigitalResourceId %>" method="POST" style="display:inline;">
<input type="hidden" name="_method" value="DELETE">
<button type="submit" class="btn btn-danger">Delete</button>
</form>
</td>
</tr>
<% }) %>
</tbody>
</table>
<a href="/digitalResources/new" class="btn btn-primary">Add Digital Resource</a>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
views/digitalResourceForm.ejs
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title><%= digitalResource ? 'Edit Digital Resource' : 'Add Digital Resource' %></title>
</head>
<body>
<div class="container">
<h1 class="mt-4"><%= digitalResource ? 'Edit Digital Resource' : 'Add Digital Resource' %></h1>
<form action="<%= digitalResource ? '/digitalResources/' + digitalResource.DigitalResourceId : '/digitalResources' %>" method="POST">
<% if (digitalResource) { %>
<input type="hidden" name="_method" value="PUT">
<% } %>
<div class="mb-3">
<label for="Title" class="form-label">Title</label>
<input type="text" class="form-control" id="Title" name="Title" value="<%= digitalResource ? digitalResource.Title : '' %>" required>
</div>
<div class="mb-3">
<label for="ResourceType" class="form-label">Resource Type</label>
<input type="text" class="form-control" id="ResourceType" name="ResourceType" value="<%= digitalResource ? digitalResource.ResourceType : '' %>" required>
</div>
<div class="mb-3">
<label for="URL" class="form-label">URL</label>
<input type="url" class="form-control" id="URL" name="URL" value="<%= digitalResource ? digitalResource.URL : '' %>" required>
</div>
<button type="submit" class="btn btn-primary"><%= digitalResource ? 'Update Digital Resource' : 'Create Digital Resource' %></button>
<a href="/digitalResources" class="btn btn-secondary">Cancel</a>
</form>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
views/interlibraryLoans.ejs
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Interlibrary Loans</title>
</head>
<body>
<div class="container">
<h1 class="mt-4">Interlibrary Loans</h1>
<table class="table">
<thead>
<tr>
<th>InterlibraryLoanId</th>
<th>UserId</th>
<th>BookId</th>
<th>LoanDate</th>
<th>DueDate</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
<% interlibraryLoans.forEach(loan => { %>
<tr>
<td><%= loan.InterlibraryLoanId %></td>
<td><%= loan.UserId %></td>
<td><%= loan.BookId %></td>
<td><%= loan.LoanDate %></td>
<td><%= loan.DueDate %></td>
<td>
<a href="/interlibraryLoans/<%= loan.InterlibraryLoanId %>" class="btn btn-info">View</a>
<a href="/interlibraryLoans/<%= loan.InterlibraryLoanId %>/edit" class="btn btn-warning">Edit</a>
<form action="/interlibraryLoans/<%= loan.InterlibraryLoanId %>" method="POST" style="display:inline;">
<input type="hidden" name="_method" value="DELETE">
<button type="submit" class="btn btn-danger">Delete</button>
</form>
</td>
</tr>
<% }) %>
</tbody>
</table>
<a href="/interlibraryLoans/new" class="btn btn-primary">Add Interlibrary Loan</a>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
views/interlibraryLoanForm.ejs
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title><%= interlibraryLoan ? 'Edit Interlibrary Loan' : 'Add Interlibrary Loan' %></title>
</head>
<body>
<div class="container">
<h1 class="mt-4"><%= interlibraryLoan ? 'Edit Interlibrary Loan' : 'Add Interlibrary Loan' %></h1>
<form action="<%= interlibraryLoan ? '/interlibraryLoans/' + interlibraryLoan.InterlibraryLoanId : '/interlibraryLoans' %>" method="POST">
<% if (interlibraryLoan) { %>
<input type="hidden" name="_method" value="PUT">
<% } %>
<div class="mb-3">
<label for="User Id" class="form-label">User ID</label>
<input type="number" class="form-control" id="User Id" name="User Id" value="<%= interlibraryLoan ? interlibraryLoan.UserId : '' %>" required>
</div>
<div class="mb-3">
<label for="BookId" class="form-label">Book ID</label>
<input type="number" class="form-control" id="BookId" name="BookId" value="<%= interlibraryLoan ? interlibraryLoan.BookId : '' %>" required>
</div>
<div class="mb-3">
<label for="LoanDate" class="form-label">Loan Date</label>
<input type="date" class="form-control" id="LoanDate" name="LoanDate" value="<%= interlibraryLoan ? interlibraryLoan.LoanDate.toISOString().split('T')[0] : '' %>" required>
</div>
<div class="mb-3">
<label for="DueDate" class="form-label">Due Date</label>
<input type="date" class="form-control" id="DueDate" name="DueDate" value="<%= interlibraryLoan ? interlibraryLoan.DueDate.toISOString().split('T')[0] : '' %>" required>
</div>
<button type="submit" class="btn btn-primary"><%= interlibraryLoan ? 'Update Interlibrary Loan' : 'Create Interlibrary Loan' %></button>
<a href="/interlibraryLoans" class="btn btn-secondary">Cancel</a>
</form>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
views/events.ejs
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Events</title>
</head>
<body>
<div class="container">
<h1 class="mt-4">Events</h1>
<table class="table">
<thead>
<tr>
<th>EventId</th>
<th>Title</th>
<th>Description</th>
<th>EventDate</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
<% events.forEach(event => { %>
<tr>
<td><%= event.EventId %></td>
<td><%= event.Title %></td>
<td><%= event.Description %></td>
<td><%= event.EventDate %></td>
<td>
<a href="/events/<%= event.EventId %>" class="btn btn-info">View</a>
<a href="/events/<%= event.EventId %>/edit" class="btn btn-warning">Edit</a>
<form action="/events/<%= event.EventId %>" method="POST" style="display:inline;">
<input type="hidden" name="_method" value="DELETE">
<button type="submit" class="btn btn-danger">Delete</button>
</form>
</td>
</tr>
<% }) %>
</tbody>
</table>
<a href="/events/new" class="btn btn-primary">Add Event</a>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
views/eventForm.ejs
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title><%= event ? 'Edit Event' : 'Add Event' %></title>
</head>
<body>
<div class="container">
<h1 class="mt-4"><%= event ? 'Edit Event' : 'Add Event' %></h1>
<form action="<%= event ? '/events/' + event.EventId : '/events' %>" method="POST">
<% if (event) { %>
<input type="hidden" name="_method" value="PUT">
<% } %>
<div class="mb-3">
<label for="Title" class="form-label">Title</label>
<input type="text" class="form-control" id="Title" name="Title" value="<%= event ? event.Title : '' %>" required>
</div>
<div class="mb-3">
<label for="Description" class="form-label">Description</label>
<textarea class="form-control" id="Description" name="Description" required><%= event ? event.Description : '' %></textarea>
</div>
<div class="mb-3">
<label for="EventDate" class="form-label">Event Date</label>
<input type="date" class="form-control" id="EventDate" name="EventDate" value="<%= event ? event.EventDate.toISOString().split('T')[0] : '' %>" required>
</div>
<button type="submit" class="btn btn-primary"><%= event ? 'Update Event' : 'Create Event' %></button>
<a href="/events" class="btn btn-secondary">Cancel</a>
</form>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
views/feedbacks.ejs
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Feedbacks</title>
</head>
<body>
<div class="container">
<h1 class="mt-4">Feedbacks</h1>
<table class="table">
<thead>
<tr>
<th>FeedbackId</th>
<th>UserId</th>
<th>Comments</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
<% feedbacks.forEach(feedback => { %>
<tr>
<td><%= feedback.FeedbackId %></td>
<td><%= feedback.UserId %></td>
<td><%= feedback.Comments %></td>
<td>
<a href="/feedbacks/<%= feedback.FeedbackId %>" class="btn btn-info">View</a>
<a href="/feedbacks/<%= feedback.FeedbackId %>/edit" class="btn btn-warning">Edit</a>
<form action="/feedbacks /<%= feedback.FeedbackId %>" method="POST" style="display:inline;">
<input type="hidden" name="_method" value="DELETE">
<button type="submit" class="btn btn-danger">Delete</button>
</form>
</td>
</tr>
<% }) %>
</tbody>
</table>
<a href="/feedbacks/new" class="btn btn-primary">Add Feedback</a>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
views/ feedbackForm.ejs
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title><%= feedback ? 'Edit Feedback' : 'Add Feedback' %></title>
</head>
<body>
<div class="container">
<h1 class="mt-4"><%= feedback ? 'Edit Feedback' : 'Add Feedback' %></h1>
<form action="<%= feedback ? '/feedbacks/' + feedback.FeedbackId : '/feedbacks' %>" method="POST">
<% if (feedback) { %>
<input type="hidden" name="_method" value="PUT">
<% } %>
<div class="mb-3">
<label for="User Id" class="form-label">User ID</label>
<input type="number" class="form-control" id="User Id" name="User Id" value="<%= feedback ? feedback.UserId : '' %>" required>
</div>
<div class="mb-3">
<label for="Comments" class="form-label">Comments</label>
<textarea class="form-control" id="Comments" name="Comments" required><%= feedback ? feedback.Comments : '' %></textarea>
</div>
<button type="submit" class="btn btn-primary"><%= feedback ? 'Update Feedback' : 'Create Feedback' %></button>
<a href="/feedbacks" class="btn btn-secondary">Cancel</a>
</form>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
Integrate Routes
In your main application file (e.g., index.js), make sure to integrate all the routes created for each model.
const express = require('express');
const bodyParser = require('body-parser');
const app = express();
const sequelize = require('./config');
// Import routes
const userRoutes = require('./routes/userRoutes');
const bookRoutes = require('./routes/bookRoutes');
const catalogItemRoutes = require('./routes/catalogItemRoutes');
const circulationRecordRoutes = require('./routes/circulationRecordRoutes');
const reservationRoutes = require('./routes/reservationRoutes');
const inventoryItemRoutes = require('./routes/inventoryItemRoutes');
const membershipRoutes = require('./routes/membershipRoutes');
const digitalResourceRoutes = require('./routes/digitalResourceRoutes');
const interlibraryLoanRoutes = require('./routes/interlibraryLoanRoutes');
const eventRoutes = require('./routes/eventRoutes');
const feedbackRoutes = require('./routes/feedbackRoutes');
// Middleware
app.use(bodyParser.urlencoded({ extended: true }));
app.use(express.static('public'));
app.set('view engine', 'ejs');
// Use routes
app.use('/users', userRoutes);
app.use('/books', bookRoutes);
app.use('/catalogItems', catalogItemRoutes);
app.use('/circulationRecords', circulationRecordRoutes);
app.use('/reservations', reservationRoutes);
app.use('/inventoryItems', inventoryItemRoutes);
app.use('/memberships', membershipRoutes);
app.use('/digitalResources', digitalResourceRoutes);
app.use('/interlibraryLoans', interlibraryLoanRoutes);
app.use('/events', eventRoutes);
app.use('/feedbacks', feedbackRoutes);
// Sync database and start server
sequelize.sync().then(() => {
app.listen(3000, () => {
console.log('Server is running on http://localhost:3000');
});
}).catch(err => {
console.error('Unable to connect to the database:', err);
});
Run the Application
Start your application by running node index.js in your terminal.
Access the Application: Open your browser and navigate to http://localhost:3000 to access the various CRUD functionalities for each model.
This completes the implementation of a complete CRUD application for the library management system using Node.js, Sequelize, Express, EJS, and Bootstrap.
Create a Dashboard Page
To create a dashboard page that consolidates data related to the library management system, we will follow these steps:
Create a Dashboard Route: Define a route for the dashboard.
Create a Dashboard Controller: Implement a controller to fetch and aggregate data from various models.
Create a Dashboard View: Design a view to display the consolidated data.
Update the Main Application: Integrate the dashboard into the main application.
Step 1: Create a Dashboard Route
Create a new file named dashboardRoutes.js in the routes directory.
routes/dashboardRoutes.js
const express = require('express');
const router = express.Router();
const dashboardController = require('../controllers/dashboardController');
router.get('/', dashboardController.getDashboard);
module.exports = router;
Step 2: Create a Dashboard Controller
Create a new file named dashboardController.js in the controllers directory.
controllers/dashboardController.js
const User = require('../models/User');
const Book = require('../models/Book');
const CatalogItem = require('../models/CatalogItem');
const CirculationRecord = require('../models/CirculationRecord');
const Reservation = require('../models/Reservation');
const Membership = require('../models/Membership');
const DigitalResource = require('../models/DigitalResource');
const InterlibraryLoan = require('../models/InterlibraryLoan');
const Event = require('../models/Event');
const Feedback = require('../models/Feedback');
class DashboardController {
async getDashboard(req, res) {
try {
const userCount = await User.count();
const bookCount = await Book.count();
const catalogItemCount = await CatalogItem.count();
const circulationRecordCount = await CirculationRecord.count();
const reservationCount = await Reservation.count();
const membershipCount = await Membership.count();
const digitalResourceCount = await DigitalResource.count();
const interlibraryLoanCount = await InterlibraryLoan.count();
const eventCount = await Event.count();
const feedbackCount = await Feedback.count();
res.render('dashboard', {
userCount,
bookCount,
catalogItemCount,
circulationRecordCount,
reservationCount,
membershipCount,
digitalResourceCount,
interlibraryLoanCount,
eventCount,
feedbackCount,
});
} catch (error) {
console.error(error);
res.status(500).send('Internal Server Error');
}
}
}
module.exports = new DashboardController();
Step 3: Create a Dashboard View
Create a new file named dashboard.ejs in the views directory.
views/dashboard.ejs
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Dashboard</title>
</head>
<body>
<div class="container">
<h1 class="mt-4">Dashboard</h1>
<div class="row mt-4">
<div class="col-md-3">
<div class="card text-white bg-primary mb-3">
<div class="card-header">Total Users</div>
<div class="card-body">
<h5 class="card-title"><%= userCount %></h5>
<p class="card-text">Total number of registered users.</p>
</div>
</div>
</div>
<div class="col-md-3">
<div class="card text-white bg-success mb-3">
<div class="card-header">Total Books</div>
<div class="card-body">
<h5 class="card-title"><%= bookCount %></h5>
<p class="card-text">Total number of books available.</p>
</div>
</div>
</div>
<div class="col-md-3">
<div class="card text-white bg-info mb-3">
<div class="card-header">Total Catalog Items</div>
<div class="card-body">
<h5 class="card-title"><%= catalogItemCount %></h5>
<p class="card-text">Total catalog items in the library.</p>
</div>
</div>
</div>
<div class="col-md-3">
<div class="card text-white bg-warning mb-3">
<div class="card-header">Total Circulation Records</div>
<div class="card-body">
<h5 class="card-title"><%= circulationRecordCount %></h5>
<p class="card-text">Total circulation records.</p>
</div>
</div>
</div>
</div>
<div class="row mt-4">
<div class="col-md-3">
<div class="card text-white bg-danger mb-3">
<div class="card-header">Total Reservations</div>
<div class="card-body">
<h5 class="card-title"><%= reservationCount %></h5>
<p class="card-text">Total reservations made.</p>
</div>
</div>
</div>
<div class="col-md-3">
<div class="card text-white bg-secondary mb-3">
<div class="card-header">Total Memberships</div>
<div class="card-body">
<h5 class="card-title"><%= membershipCount %></h5>
<p class="card-text">Total memberships issued.</p>
</div>
</div>
</div>
<div class="col-md-3">
<div class ="card text-white bg-light mb-3">
<div class="card-header">Total Digital Resources</div>
<div class="card-body">
<h5 class="card-title"><%= digitalResourceCount %></h5>
<p class="card-text">Total digital resources available.</p>
</div>
</div>
</div>
<div class="col-md-3">
<div class="card text-white bg-dark mb-3">
<div class="card-header">Total Interlibrary Loans</div>
<div class="card-body">
<h5 class="card-title"><%= interlibraryLoanCount %></h5>
<p class="card-text">Total interlibrary loans processed.</p>
</div>
</div>
</div>
</div>
<div class="row mt-4">
<div class="col-md-3">
<div class="card text-white bg-info mb-3">
<div class="card-header">Total Events</div>
<div class="card-body">
<h5 class="card-title"><%= eventCount %></h5>
<p class="card-text">Total events organized.</p>
</div>
</div>
</div>
<div class="col-md-3">
<div class="card text-white bg-warning mb-3">
<div class="card-header">Total Feedbacks</div>
<div class="card-body">
<h5 class="card-title"><%= feedbackCount %></h5>
<p class="card-text">Total feedback received.</p>
</div>
</div>
</div>
</div>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
Step 4: Update the Main Application
In your main application file (e.g., index.js), integrate the dashboard route.
const dashboardRoutes = require('./routes/dashboardRoutes');
// Use routes
app.use('/users', userRoutes);
app.use('/books', bookRoutes);
app.use('/catalogItems', catalogItemRoutes);
app.use('/circulationRecords', circulationRecordRoutes);
app.use('/reservations', reservationRoutes);
app.use('/inventoryItems', inventoryItemRoutes);
app.use('/memberships', membershipRoutes);
app.use('/digitalResources', digitalResourceRoutes);
app.use('/interlibraryLoans', interlibraryLoanRoutes);
app.use('/events', eventRoutes);
app.use('/feedbacks', feedbackRoutes);
app.use('/dashboard', dashboardRoutes); // Add this line for the dashboard
Final Steps
Run the Application: Start your application by running node index.js in your terminal.
Access the Dashboard: Open your browser and navigate to http://localhost:3000/dashboard to view the consolidated data on the dashboard.
This completes the implementation of a dashboard page that consolidates data related to the library management system.
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