Library Management System

ASP.NET Core 8 MVC app with a redesigned teal/purple gradient UI, using SQLite (no SQL Server / LocalDB required).

How to run

Unzip and open the folder in Visual Studio 2022 (double-click will prompt to create a .sln, or just open the folder) — or run from terminal:
```
cd LibraryManagement
dotnet restore
dotnet run
```
The app auto-creates library.db (SQLite) and seeds sample Books, Students, Librarians, and one Borrow Record on first run.
Browse to the URL shown in the console (e.g. https://localhost:5001 or http://localhost:5066).

Username: admin
Password: admin123 (Demo-only cookie auth in AccountController.cs — swap in ASP.NET Identity for production.)

Dashboard — gradient stat cards (Books, Students, Librarians, Borrow Records, active borrows, available copies) + recent activity table
Books — card-grid catalog with cover images, search + genre filter, full CRUD
Students — table view, search, full CRUD, per-student borrow history
Librarians — staff cards with avatar initials, roles, full CRUD
Borrow History — status filter (Borrowed/Returned/Overdue, auto-flags overdue), one-click Return button that restocks the book, full CRUD
Login/Logout — cookie-based auth

Swap SQLite for SQL Server by changing the connection string in appsettings.json and the UseSqlite call in Program.cs to UseSqlServer.
Book cover images pull from OpenLibrary URLs in the seed data — replace CoverImageUrl with your own image links anytime via Edit.