Welcome to the College Library Management System GitHub repository! This C# and SQL-based application serves as a comprehensive solution for managing your college's library resources efficiently. The system is designed with a focus on user roles, secure access, and streamlined administration.
The application implements a robust user authentication system, allowing only authorized users to access its features. The sole administrator has exclusive access, utilizing a username and password stored securely within the database.
The admin role is empowered with versatile tools to oversee the library's inventory and activities. Key functionalities include:
. Book Inventory Management: View the complete list of library books, including details such as title, author, and the number of available copies.
. Transaction Monitoring: Keep track of purchases and borrowings made by both students and staff. Identify who borrowed or bought a book, and when.
. Financial Insights: The admin can access the library's financial status via a wallet feature. This wallet accumulates funds from book purchases and borrowings, while also reflecting expenditures for acquiring new library books.
The system distinguishes between teachers and students, tailoring their access and privileges accordingly.
. Teachers: Enjoy the freedom to purchase any book from the library's collection, enhancing their academic resources.
. Students: Have the option to borrow any book they desire, granting them access to a wide range of learning materials. They can't buy books, but their borrowing capabilities are expansive.
The library's financial health is monitored through the wallet feature. This digital ledger tallies incoming funds from book-related transactions, and deducts expenditures incurred when the admin purchases new library additions. This provides an instant overview of the library's fiscal state.