Library_Management_System

Library Management System is an Online Library Web Application made using ASP.NET MVC. It provides an easy-to-handle and automated system. It also provides various features and an interface for maintaining librarians’ records, students’ history of issues, and fines. The admin can easily update, delete and insert data in the database with this application. Can View all his past Records.

Features

For Admin

• Can Approve or Reject the request for any book that is requested.
• Can perform CRUD operations on Account, Book, Author, and Publisher tables.
• Can View all the past Records of each user.

For User

• Can View all the books and Request them.
• Can View all the issued books and Return them.
• Can View all his past Records.

Landing Page

Login Page

View Books Page

Getting Started

Prerequisites

Download and install the below mentioned softwares -

• Microsoft Visual Studio Community 2022 (64-bit) Version 17.3.0
• Microsoft SQL Server Management Studio Version 18.2.1
• .NET Framework Version 5.0.17

Installation

Install the below-mentioned packages inside your Visual Studio by navigating to

Tools > NuGet Package Manager > Manage NuGet Packages for Solution

• Microsoft.EntityFrameworkCore Version 5.0.17
• Microsoft.EntityFrameworkCore.Design Version 5.0.17
• Microsoft.EntityFrameworkCore.Tools Version 5.0.17
• Microsoft.EntityFrameworkCore.SqlServer Version 5.0.17

Configuration

Enter the below commands inside your console. You can open the console by navigating to

Tools > NuGet Package Manager > Package Manager Console

Add-Migration <Migration Name>

Update-Database

Make sure to update appsettings.json with the Database Name you want to give.

"DBConnection": "Server=localhost;Database=<Database Name>;Trusted_Connection=True;"