System Requirements Document

Project Overview

The project involves transforming an existing HTML prototype into a robust, enterprise-grade ASP.NET Core SaaS platform. The goal is to enhance the current system with superior performance, scalability, and security features, leveraging a modern tech stack and architectural best practices.

Tech Stack

• Backend: ASP.NET Core 9 Web API
• Frontend: React + TypeScript
• Database: PostgreSQL
• ORM: Entity Framework Core
• Authentication: ASP.NET Identity, JWT + Refresh Tokens
• Caching: Redis
• Job Scheduling: Hangfire
• Logging: Serilog
• Monitoring: OpenTelemetry
• Containers: Docker
• CI/CD: GitHub Actions
• AI Providers: OpenAI
• Deployment: Vercel (Frontend), Railway/Render (Backend), Supabase PostgreSQL (Database), Redis Cloud (Cache), Cloudflare (CDN)

Key Features and Systems

Authentication System

• Features: JWT access tokens, Refresh tokens, MFA/2FA, RBAC, Email verification, Session management, Audit logs, Anti brute-force, Rate limiting, Device tracking

AI Systems

• AI Visa Advisor: Immigration scoring engine, Country ranking, Profile memory, Pathway prediction, Approval probability
• AI Chat: SignalR token streaming, Persistent conversations, Vector memory, Prompt orchestration, Provider fallback, AI moderation
• AI Profile Optimizer: CRS optimization, Language recommendations, Experience optimization, Savings analysis, Spouse impact simulation

Immigration Intelligence Engine

• Visa Database: PostgreSQL normalized schema, Admin CRUD, Import pipelines, Automatic updates, Indexing/search
• Live News: Scraper workers, AI summarization, Country tagging, Processing alerts, Realtime notifications
• Processing Time Engine: Historical tracking, Embassy trends, Analytics, AI prediction

Enterprise Database Design

• Core Tables: Users, UserProfiles, VisaPrograms, AIChats, Subscriptions

ASP.NET Backend Structure

• Project Structure:
  • VisaFlowPro.API
  • VisaFlowPro.Application
  • VisaFlowPro.Domain
  • VisaFlowPro.Infrastructure
  • VisaFlowPro.Shared

Frontend Structure

• Project Structure:
  • app
  • components
  • pages
  • features
  • services
  • hooks
  • layouts
  • store
  • types
  • utils

Recommended Page System

• Public Pages: Landing, Pricing, Features, About, Blog, Login, Register
• User Dashboard: Overview, AI Tools, Visa Advisor, AI Chat, Saved Countries, Saved Pathways, Billing, Notifications, Profile
• Admin Dashboard: User Management, Visa CRUD, AI Analytics, Revenue, Support Tickets, News Management, CMS, Fraud Detection

SignalR Realtime Infrastructure

• Used for: AI token streaming, Live typing, Realtime notifications, Processing updates, Admin alerts, Background job status

Security Fixes Required

• Current Issues: Exposed API keys, Insecure browser AI calls, Lack of scalable backend, No true database layer, Missing RBAC security, Difficult maintainability, Missing production deployment architecture, Missing enterprise observability, Weak scaling model
• ASP.NET Rebuild Fixes: Server-side secrets, Encrypted config, API gateway, Anti-abuse, RBAC, Audit logging, WAF compatibility, Rate limiting, CSRF protection

Production Deployment

• Frontend: Vercel
• Backend: Railway/Render
• Database: Supabase PostgreSQL
• Cache: Redis Cloud
• CDN: Cloudflare

Docker Infrastructure

• Services: API, Frontend, Postgres, Redis, Nginx

Performance Upgrades vs Current HTML

• Current HTML: Single DOM, Inline CSS, Inline JS, Frontend-heavy, No caching
• Enterprise Rebuild: Lazy loading, Route splitting, SSR-ready, Optimized bundles, Redis caching, CDN delivery, API caching, DB indexing
• Expected Improvement: 5x–20x faster at scale

Final Recommended Development Order

• Phase 1 — Foundation: ASP.NET solution, React frontend, PostgreSQL, JWT auth, Identity, Tailwind
• Phase 2 — Core Migration: Dashboard, Sidebar, Auth pages, AI chat, Profile, Visa database
• Phase 3 — Intelligence: AI advisor, Calculators, Country compare, Pathway planner, Scoring engine
• Phase 4 — SaaS: Stripe, Subscriptions, Analytics, Billing, Admin
• Phase 5 — Enterprise Scale: Redis, Docker, CI/CD, Monitoring, AI orchestration, Queues, Observability

Final Tech Stack

• Backend: ASP.NET Core 9
• Frontend: React + TypeScript
• Database: PostgreSQL
• ORM: Entity Framework Core
• Auth: Identity + JWT
• AI Streaming: SignalR
• Cache: Redis
• Jobs: Hangfire
• Search: ElasticSearch
• Billing: Stripe
• Monitoring: OpenTelemetry
• Logging: Serilog
• Containers: Docker
• CI/CD: GitHub Actions

Implementation Phases

• Phase 1: Foundation setup with ASP.NET, React, and PostgreSQL.
• Phase 2: Core migration including dashboard and AI chat.
• Phase 3: Intelligence features like AI advisor and scoring engine.
• Phase 4: SaaS features with Stripe and admin systems.
• Phase 5: Enterprise scale with Redis, Docker, and CI/CD.
• Phase 6: AI memory and global scale architecture.
• Phase 7: Execution blueprint and scaling strategy.
• Phase 8: Repository organization and development workflow.
• Phase 9: Database engineering and AI data architecture.
• Phase 10: ASP.NET backend implementation and code architecture.
• Phase 11: Frontend architecture and AI experience engineering.
• Phase 12: DevOps, cloud infrastructure, and global deployment.
• Phase 13: AI system engineering and multi-model orchestration.
• Phase 14: Enterprise security and compliance.
• Phase 15: Billing, subscriptions, and financial infrastructure.
• Phase 16: Admin panel, CRM, and operations platform.
• Phase 17: SEO, growth engine, and viral acquisition system.
• Phase 18: Production blueprint and execution roadmap.
• Phase 19: Coding execution plan and production delivery strategy.
• Phase 20: Database architecture and Supabase production design.

This document outlines the comprehensive transformation of the initial HTML prototype into a scalable, secure, and feature-rich enterprise SaaS platform, ready for global deployment and capable of supporting complex AI-driven immigration processes.