Legacy System Modernization
From FoxPro desktops to validated executive analytics - without rewriting profit rules.
6 min read
Executive summary
This portfolio documents a real modernization path: from FoxPro-era media operations through WinForms to a read-only ASP.NET MVC executive layer - without changing the underlying profit business rules.
Technology timeline
FoxPro
Early desktop media operations
C# WinForms + DevExpress
MBAS booking & profit forms (F0010_1)
SQL Server
BOOKING_Demo schema + reporting views
ASP.NET MVC
Read-only portfolio module
Executive Analytics
Dashboards with validated profit
What was preserved
- ChiTietLichBookNgayView - same reporting grain as legacy Search().
- LichBookChiTietNgayViewModel profit chain - ported to LegacyProfitabilityService.
- KyTu + StatusComplete filters - confirmed airings only.
- Profit validation - SUM(LoiNhuan) matches formula check at 0% variance.
What was modernized
- Dark executive UI with Chart.js analytics.
- Product Performance and Profitability dashboards.
- Demo-safe masking for public portfolio visitors.
- Business Knowledge Center for non-media audiences.
Portfolio message
The MVC layer proves the developer understands legacy domain logic - not just how to build new screens on top of a database.
Related Dashboards
Skills Demonstrated
- Visual FoxPro maintenance
- SQL Server reporting
- Business analysis
- Revenue analytics
- Profitability modelling
- ASP.NET MVC modernization
- Dashboard development
- Data validation and reconciliation
- Executive reporting
- Process automation