Projects

Desktop

BaytIntegration — ERP Desktop Toolkit

An auto-updating desktop integration toolkit for Bay.t ERP built on a 'read via SQL, write via API' philosophy. Its undocumented API was reverse-engineered.

v1.5.5 in production · reverse-engineered

.NET 8WinFormsDevExpressDapperVelopackSQL Server

Problem

Bay.t ERP's Partner API was limited and nearly undocumented; field staff needed to create carts/orders on the ERP quickly.

Solution

I reverse-engineered the 348-table database schema and the API payload structures, turning the findings into a permanent knowledge base. I built a Clean Architecture toolkit with .NET 8 + WinForms + DevExpress and set up auto-updates with Velopack.

Highlights

  • "Read via SQL, write via Partner API" hybrid integration pattern
  • Production auto-updates with Velopack + a launcher
  • Multi-company / multi-database support, BCrypt-protected tool authorization
  • Real customer-site race-condition, type-binding and connection-cache bugs solved with defensive patterns
  • Matured in production up to v1.5.5 with semantic versioning