International Journal of Scientific Research and Engineering Development

This paper presents the design, development, and deployment of the Online Tourist Information System (OTIS), a full-stack e-governance web application built during a four-month internship at the National Informatics Centre (NIC), Pondicherry. Tourism management in Pondicherry has long relied on manual, paper-based processes — hotels maintaining physical visitor registers, departments compiling records by hand, and compliance reports sent to the Ministry of Home Affairs (MHA) through slow, error-prone workflows. OTIS completely replaces this fragmented system with a centralised, role-based digital platform. Built on ASP.NET Core MVC (.NET 10) with C#, dual SQL Server connections, Bootstrap 5, and QuestPDF, the system supports five user roles — Department Admin, Department Operator, Hotel Admin, Hotel Operator, and Public/MIS User — each with strictly scoped permissions. Key features include SMS OTP hotel verification, BCrypt password hashing, offline CAPTCHA, cookie-based authentication, automated daily MHA report dispatch, an AI-powered public chatbot, a feedback and rating system, and a full audit trail with IP address logging. Testing confirmed resistance to SQL injection, session hijacking, and OTP replay attacks. OTIS provides a replicable, production-ready e-governance model for tourism digitisation across Indian states and Union Territories

Mr. P.Rajapandian1, Kaviya. M,"OTIS: Digitalizing Tourist Information Management for the Department of Tourism, Government of Puducherry UT — An E-Governance Web Application" International Journal of Scientific Research and Engineering Development, V9(3): Page(2122-2127) May-June 2026. ISSN: 2581-7175. www.ijsred.com. Published by Scientific and Academic Research Publishing.