Library Management System

🚀 Overview

Developed a robust Library Management System to streamline and automate library operations, offering comprehensive features for managing books, book copies, admins, users, authors, fines, borrowing and reservations while ensuring high usability and system efficiency.

⭐ Features

📝 Here're some of the project's best features:

1. Admin and User Management

   • User-friendly forms for creating, updating, deleting and managing admins and users.
   • Validation and security features, including hashed password storage and admin verification for critical updates.
   • Features to filter admins by AdminID and FullName.

2. Book and Author Management

   • Manage books and authors, including adding, updating, and deleting records.
   • Features to handle book images, filter by ISBN, title, or author, and dynamically display details.
   • feature to show full book details.

3. Book Copies Management

   • Add, update, and delete book copies to ensure accurate inventory tracking.
   • Features to filter copies by CopyID, BookID,AuthorID, Title, or ISBN.
   • Dynamic forms to manage book copy details and status, including availability statue for borrowing.
   • added borrow and reserve the book options in the form.

4. Reservations and Borrowing

   • Create and manage book reservations and borrowing records, including validation checks for availability.
   • Filtering options to efficiently search and manage reservation and borrowing history.

5. Dashboard

   • A dynamic dashboard displaying key metrics: total books, authors, users, admins, borrowing records, and reservations.
   • Real-time data integration for instant library performance insights.

6. Fines and Settings Management

   • Fine tracking and payment management, with configurable settings for borrowing periods and default fine per day.
   • Validation and error handling for seamless admin workflows.

📷 Project Screenshots:

---

🎬 Watch the Demo Video!

Take a moment to explore the demo video, where I calmly give you a simple overview of how everything works.

- Watch it on Google Drive : Video

🛠️ Installation Steps:

1. Prerequisites

sql server management studio.

visual studio code

.NET Framework 4.8 or later.

2. Clone the repository

https://github.com/Zyad-Eltayabi/Library-Management-System.git

 cd "Presentation Tier"

3. Restore LMS.bak file in your sql server management studio (you will find the file in Database folder)

4. in Presentation Tier Project, update App.config file with your sql server settings (user Id and password)

5. click on "Presentation Tier.sln" file and build the solution

6. in login screen set ( user name : admin and password : 123456 )

🔷 Technologies used in the project

• Architecture: 3-Tier Architecture
• Programming Language: C#
• Database: MS SQL Server
• Data Access: ADO.NET
• User Interface: Windows Forms