The Library Management System is a comprehensive and user-friendly solution designed to streamline and automate the management of library resources. With features such as book inventory management, loan handling, patron records management, and in-depth queries for data analysis, the system is an ideal tool for librarians and library staff.
The system was developed using C# programming language, the .NET framework, and Microsoft SQL Server for the backend database, ensuring a robust and high-performance solution.
To install and run this project, you will need:
.NET Framework: The system was built on the .NET Framework. If you don't have it installed, you can download it from the official Microsoft website.
Microsoft SQL Server: The backend of the system uses Microsoft SQL Server. It can be downloaded from the official Microsoft website.
Visual Studio: This is the recommended IDE for running the system. You can download it from the official Microsoft website.
- Clone the repository:
-
Open the solution file (.sln) with Visual Studio.
-
Build the solution by navigating to Build > Build Solution in Visual Studio.
-
In your SQL Server management tool, run the SQL script located in the SQL Insert Statements directory of the project to set up your database.
-
In the SqlConnectionManager class, update the connection string with your database details.
To run the project, follow the steps below:
-
In Visual Studio, navigate to Debug > Start Debugging or simply press F5.
-
In the application, click on the "Activate Database" button and enter the name of your database to establish a connection.
The system is now ready to be used.
The Library Management System includes the following features:
- Patron Management Features
-
Search Patron Name: Searches for patron records based on the provided name.
-
Add Patron: Allows for secure addition of new patron records.
-
Edit Patron: Provides the ability to securely update existing patron records.
-
Delete Patron: Removes a patron record and all associated loans.
