A Windows desktop app for running a school library: a catalogue of books, issuing and returning them to students and teachers, a daily report of what is overdue, and an Excel export. Data lives in Google Cloud Firestore, so every library computer sees the same books.
Built with C# and WinForms on .NET 8.
| Today | Issue & return |
|---|---|
![]() |
![]() |
| Library | Daily report |
![]() |
![]() |
- Today: what is overdue and what is due within 3 days, with a box to jump straight to a book.
- Library with search-as-you-type across title, author, barcode, IDs and borrower, and filters that show how many books each holds.
- Issue & return: look a book up by number, catalogue label or barcode, then issue or return it, or edit or delete its record. Works with USB barcode scanners (they type the code and press Enter).
- Register: add copies and see today's registrations with their catalogue IDs, ready for labelling.
- Lending rules in one place: students borrow for a month, teachers until the end of the school year (25 June).
- Daily report on screen and as an Excel workbook, optionally saved automatically once a day.
- Sample-data mode to try the app without a Firebase project.
- Keyboard: Ctrl+1 to Ctrl+6 switch screens, F5 reloads, Enter submits, Esc clears the search.
You need Windows 10 or 11 and the .NET 8 SDK.
Try it with the built-in sample library (nothing is saved):
dotnet run --project src/LibraryManagement.App -- --demoRun it normally:
dotnet run --project src/LibraryManagement.AppOr open LibraryManagementSystem.sln in Visual Studio 2022 and press F5.
The app needs a service-account key for your Firebase project. Nothing about the project is compiled into the app.
- In the Firebase console open Project settings → Service accounts and click Generate new private key.
- Start the app and click Choose key file… (or use Settings → Data source later).
The app remembers the file's location for your Windows user. Two alternatives need no clicking:
- save the key next to the
.exeasfirebase-credentials.json, or - set the
GOOGLE_APPLICATION_CREDENTIALSenvironment variable to the key's path.
Keep the key secret. It gives full access to the project's data. Never commit it:
.gitignorealready blocks the usual file names. If a key is ever shared or pushed by accident, delete it in the Firebase console and generate a new one.
The app reads and writes two collections. Field names are the ones the first version of the app created, so existing data keeps working.
| Collection | Document ID | Fields |
|---|---|---|
Books |
running number (0, 1, …) |
Name, Author, Barcode, BTSID, Available (bool), RegistrationDate, IssueDate, DueDate, IssuedBy, IssuedBy_BTSCID, IssuedBy_Level, IssuedBy_Section |
Users |
any | BTSCID (e.g. BTS-10-214), Name, Level (Student or Teacher), Section |
Dates are stored as dd-MM-yyyy text and empty values as the text null. Members are
added in the Firebase console; the app does not edit them.
src/
LibraryManagement.Core/ No UI. Runs anywhere .NET runs, so it can be unit-tested.
Models/ Book, Loan, Member, lending rules, statistics, search
Data/ ILibraryRepository + Firestore and in-memory implementations
Services/LibraryStore.cs The app's state and every operation a librarian can perform
Reporting/ Excel export of the daily report
Configuration/ Per-user settings (JSON under %AppData%)
LibraryManagement.App/ The WinForms app
Ui/ Theme, embedded title font, custom-drawn controls
Views/ One class per screen
MainForm.cs Sidebar, navigation, busy indicator, notifications
tests/
LibraryManagement.Core.Tests/ xUnit tests for the Core project
The screens are built in code (see Ui/Make.cs) rather than with the drag-and-drop
designer, which keeps each one short and lets the layout stretch and scale with the
display's DPI.
| What | Where |
|---|---|
| Settings | %AppData%\Library Management System\settings.json |
| Error log | %AppData%\Library Management System\logs\app.log |
| Reports | Documents\Library Management System (changeable in Settings) |
The title typeface (Crimson Text), the crest and the icon are embedded in the executable, so the app looks the same on any computer without installing anything. All other text uses Segoe UI, which is part of Windows.
dotnet testThe tests cover the lending rules, due-date and overdue logic, reading and writing the
Firestore document format, every LibraryStore operation (against the in-memory
repository), settings, and the Excel export.
dotnet publish src/LibraryManagement.App -c Release -r win-x64 --self-contained true -o publishCopy the whole publish folder to the other PC and run LibraryManagementSystem.exe.
.NET does not need to be installed there.
- This project: see LICENSE.
- Crimson Text is under the
SIL Open Font License 1.1,
which permits bundling and embedding it in software. Its licence file ships in the
app's
licensesfolder. - EPPlus is used under its Polyform Noncommercial licence, which covers non-commercial use such as a school library. Commercial use needs a paid EPPlus licence.



