QR Powered Stakeholder Inquiry Tracking app

The CHIETA Stakeholder Management System was created in order to meet important business needs related to appointment scheduling, inquiry tracking, and stakeholder engagement. Prior to the transition of advisory services to a hybrid, partially virtual model, there was no single interface for handling stakeholder visits or enquiries, which resulted in scheduling conflicts and communication delays.

Our suggested solution presents an integrated web application that uses QR technology to securely check in, handle enquiries, and schedule appointments automatically. While advisors manage appointments and instantly update inquiry statuses, stakeholders can conveniently log enquiries, schedule meetings with advisors, and monitor progress online. Administrators are able to monitor service performance, add new users, and make sure that all roles work together seamlessly.

With Google Cloud Firestore serving as the NoSQL backend for scalability and real-time updates, the system is constructed on a contemporary cloud-based architecture utilising ASP.NET Core MVC.  Secure logins and user roles (Client, Advisor, Admin) are managed by Firebase Authentication.  While MailKit manages confirmation emails with embedded QR codes created by QRCoder, a TokenService creates one-time QR tokens that are saved as SHA-256 hashes in Firestore.

 Key characteristics include:

·       Appointment verification via QR code for safe on-site check-in.

·       Automated reference numbers are used for online appointment scheduling and inquiry logging.

·       dashboards for advisors that track assigned enquiries and provide status updates.

·       Tools for system administrators to create and manage users.

·       Booking confirmations and status updates are sent by email.

In summary, the system improves service transparency, speeds up stakeholder engagement, and lowers administrative burden, showing how cloud integration and QR technology can modernise service delivery for the public.