1. Discover

Gemini returns candidate papers for the highlighted claim. The backend verifies each one against CrossRef and falls back to a Google Scholar search when no match is found.

2. Ground

The student pastes the paper's text. Gemini labels the result as an exact match, a related passage, or a contradiction of the claim.

3. Review

Relevant passages are highlighted in the paper by color, alongside the rubric verdict, an APA citation, and a synthesis paragraph.

1. Register

A seven-step form submits to sp_RegisterUser, which only the revora_api login can run. In one transaction it finds or creates the address and inserts the ID, branch, entity, and user rows, while triggers hash the password and log the submission.

2. Review

Administrators work through a pending queue where a SQL function flags each application as On Track, Due Soon, or Overdue. Only the revora_staff login can run the approval procedures, and every decision and note is written to the audit log.

3. Secure

Each login gets only the access it needs. An attempted DELETE as revora_api fails with SQL Server error 229, and the staff and API logins see masked emails, phone numbers, and ID numbers.

1. Certificates & Reports

Each document type has its own template with the barangay seal and details like the resident's relationship or years of cohabitation. I also built the cleanup drive attendance sheet and added the barangay header to the other report PDFs.

2. Household Succession

When a primary head is deactivated, the secondary head takes over automatically. Reactivated residents return as regular members, and a household left without a head shows a warning with a dialog to assign new heads.

3. Security & Audit

The audit log could not see users signed in with JWT, so I attached the signed-in user to every request and added login and export logging. Admin-only pages are now blocked, and admins cannot change their own role.

1. Data

Entity classes in a Suppliers.DataModel library define the SQL Server schema, mapped onto named tables and columns with the Fluent API. Each change ships as an EF Core migration.

2. Access

Products go through IGenericRepo<T>, a reusable add, get, update, and delete layer in its own library, injected into the controller. AutoMapper turns entities into view models and back.

3. Web

MVC controllers and Razor views behind [Authorize], with anti-forgery tokens on sign-in, edits, and deletes, styled with Bootstrap and DataTables.