Library Management System (LMS) - C# WinForms

The Library Management System is a comprehensive software solution designed to simplify and automate the management of library operations. Developed using C# WinForms, this system provides a user-friendly interface for both librarians and library members. It includes features for user registration, book management, and book borrowing, ensuring a smooth and efficient library experience. By leveraging advanced SQL queries, including joins and subqueries, the system guarantees efficient data retrieval and manipulation, making it an ideal choice for libraries looking to modernize their operations.

Features

• User Registration: Allows new users to register, creating a personalized experience and enabling librarians to track borrowing habits.
• Book Management: Enables librarians to add, update, and remove books from the library's catalog, ensuring that the library's inventory is always up-to-date.
• Book Borrowing: Simplifies the process of borrowing books, including tracking which user has borrowed a book and when it is due back.

Getting Started

Prerequisites

To run this Library Management System, ensure you have the following installed:

• .NET Framework 4.7.2 or later
• Microsoft SQL Server

Installation

1. Clone the repository to your local machine:

   git clone https://github.com/MohamedRadyA/LibraryManagementSystem

2. Open the solution file (LibraryManagementSystem.sln) in Visual Studio.
3. Restore NuGet packages to resolve any dependencies.
4. Update the connection string in App.config to match your SQL Server instance.
5. Build and run the application from Visual Studio.

Database Setup

1. Execute the SQL scripts located in the Database folder to create the necessary tables and relationships in your SQL Server instance.
2. Optionally, seed the database with initial data by running the seed script provided in the Database\Seeds directory.

Usage

Upon launching the application, you will be greeted with the main interface, where you can navigate to different sections of the system:

• To register a new user, navigate to the User Registration section and fill out the form.
• To manage books, go to the Book Management section where you can add, update, or remove books.
• To borrow a book, access the Book Borrowing section, select a user and a book, and complete the borrowing process.

Media

Diagrams

Built With

• C# WinForms - For the user interface
• SQL Server - For data storage and management