← Back to work
Public Sector Application

Fine Management App

An internal web application built for police departments to record traffic violations, verify vehicle details, process fine payments, send citizen notifications, and generate daily and monthly compliance reports — all from a single secure platform.

Fine Management App preview
ASP.NET Core MVC Entity Framework Core JWT Auth RBAC Twilio SMS MailKit RDLC Reports Crystal Reports Bootstrap 5

Project Description

This application was built as a comprehensive internal tool for police departments to digitise and streamline the entire traffic violation management process — replacing manual paper-based records with a fast, searchable, and auditable digital system.

The system supports three distinct user roles — Traffic Officers who issue fines, Supervisors who review and approve records, and Admins who manage the platform and generate reports. Sensitive citizen and vehicle data is handled with role-gated access and full audit trails to meet the security requirements expected of a government-facing application.

Key Highlights

  • Traffic violation recording module — Officers log incidents by selecting violation type, entering vehicle number, capturing location, and attaching evidence notes — with real-time vehicle lookup to auto-populate owner details, reducing data entry time per ticket.
  • Vehicle number verification — Vehicle lookup queries the registry database to instantly retrieve owner name, registration details, and previous violation history — giving officers full context before issuing a new fine.
  • Fine payment processing + status tracking — Citizens pay fines online through a secure gateway with real-time status updates (Pending, Paid, Overdue, Disputed) tracked in SQL Server and reflected instantly on the officer dashboard.
  • SMS + email notifications via Twilio & MailKit — Automatic citizen alerts when a fine is issued, when payment deadline is approaching, and when payment is confirmed — reducing manual follow-up work for officers.
  • Report generation with RDLC / Crystal Reports — Dynamic daily violation summaries, monthly revenue reports, officer-wise stats, and violation type breakdowns — exportable to PDF and Excel with date-range and department filters.
  • Role-based access control for 3 user types — Officers issue fines, Supervisors review and override, Admins manage configuration and reports — all enforced via JWT-secured routes at every level.
  • SQL Server schema + stored procedures — Complete database schema covering violations, vehicles, citizens, payments, officers, and audit logs — with stored procedures for complex fine aggregation and optimised indexes on large violation history tables.
  • Centralized admin dashboard — Live KPIs showing fines issued today, pending payments, collected revenue, and top violation types using Chart.js charts with server-side data via AJAX calls.