How kenjirodada/logbooksqlserver works
This is a Thai household-assistance logbook: staff sign in, maintain beneficiary records, review assistance and reports, and manage each family’s members and supporting photos. The browser uses authenticated API endpoints; controllers validate and persist records through EF Core, while uploaded images are stored under the web root. The excerpts show the main dashboard and family-detail flows. Other pages are represented from the file tree; their specific runtime wiring was not inspected.
Main entry points: LogbookDbContext.cs EF Core data context · family.js Family detail · AuthController.cs Authentication API · Program.cs ASP.NET application host
Components 13
Staff interface
- Dashboard and reports
wwwroot/js/app.js - Family detail
wwwroot/js/family.js - Login page
wwwroot/js/login.js
Application API
- Authentication API
Controllers/AuthController.cs - Beneficiary records API
Controllers/BeneficiariesController.cs - Household members API
Controllers/HouseholdMembersController.cs - Beneficiary media API
Controllers/BeneficiaryMediaController.cs
Domain and persistence
- EF Core data context
Data/LogbookDbContext.cs - Logbook entities
Models
Application runtime
- ASP.NET application host
Program.cs
Other components
- Staff user
- SQL Server database
- Uploaded image files
Connections 19
- Staff user → Dashboard and reports: uses
- Staff user → Family detail: uses
- Staff user → Login page: uses
- Dashboard and reports → Authentication API: checks session
wwwroot/js/app.js - Dashboard and reports → Beneficiary records API: loads and edits
wwwroot/js/app.js - Family detail → Authentication API: checks session
wwwroot/js/family.js - Family detail → Beneficiary records API: loads and updates
wwwroot/js/family.js - Family detail → Household members API: manages members
wwwroot/js/family.js - Family detail → Beneficiary media API: manages photos
wwwroot/js/family.js - Authentication API → EF Core data context: queries users
Controllers/AuthController.cs - Beneficiary records API → EF Core data context: reads and writes
Controllers/BeneficiariesController.cs - Household members API → EF Core data context: reads and writes
Controllers/HouseholdMembersController.cs - Beneficiary media API → EF Core data context: reads and writes
Controllers/BeneficiaryMediaController.cs - Beneficiary media API → Uploaded image files: stores and deletes
Controllers/BeneficiaryMediaController.cs - ASP.NET application host → EF Core data context: configures
Program.cs - ASP.NET application host → SQL Server database: connects to
Program.cs - ASP.NET application host → Authentication API: maps controllers
Program.cs - EF Core data context → Logbook entities: defines sets
Data/LogbookDbContext.cs - Login page → Authentication API: submits credentials