SQL Support Ticket Web Portal

Заказчик: AI | Опубликовано: 13.09.2025

I already run an SQL Express database that stores all of our internal support-ticket tables; what I am missing is the front office that lets my team log new issues quickly from any browser on the company network. I need a small web portal whose single focus is a form input system tied directly to that existing database. The form must: • capture all standard ticket fields I already have (subject, description, requester, etc.) • include clearly visible priority levels (low / medium / high, matching the enum in the current table) • allow users to attach multiple files with size limits I can set in a config file • trigger automated email notifications to the assigned technician and the requester after submit or status change The application should connect to SQL Express with secure credentials, respect the current schema (I will provide a diagram), and write only to the SupportTickets table set—no schema changes are needed. A clean, responsive HTML/CSS layout is enough; no heavy design work is required. If you prefer ASP.NET Core, Python Flask, or Node.js/Express, let me know—any stack is acceptable as long as it runs behind IIS or a lightweight Windows service and stays easy to maintain. Deliverables 1. Source code for the web portal and any helper scripts 2. SQL connection string held in a separate config file 3. README with setup steps and a brief hand-off on how to adjust email server settings 4. One deployed test instance on my dev server proving end-to-end ticket creation, file upload, and notification delivery I will supply remote access to the dev server plus sample data as soon as the project starts.