VB.NET Windows program to web app
Who has the thermal camera? When is it due? What's in repair? Now on any phone or browser.


Check something out. Sign in as anyone and borrow a multimeter. Digital multimeter
Hit a limit. Both thermal cameras are out, one overdue. Thermal camera
Return it broken. It goes to the repair bench, not the shelf. Loans
Export to Excel. A real .xlsx file, no Office needed. Reports
Found while reading the original's code. Old business programs usually hide a few like these.
One delete removed every record. A stored procedure's parameter had the same name as its column, so WHERE id = id matched every row.
The stock count could go blank. A database trigger lost the count when a loan was deleted. Now counts are worked out from the loans, never stored.
Adding an item failed. A trigger called a procedure that wasn't in the database.
An apostrophe broke a loan. Typed text went straight into the SQL. Now every value is passed safely.
Passwords in plain text. Gone: people sign in with their company account.
Returned before it went out. Dates are now checked, and returned loans stay in the history instead of being deleted.
| In the Windows program | On the web |
|---|---|
| MySQL on the same PC, as root, no password | A server database, backed up, with its own account |
| Windows Forms screens | React screens that work on a phone |
| VB.NET behind the buttons, triggers in the database | C# rules every change goes through, with tests |
| Export through Excel on the PC | A real .xlsx download, no Office needed |
| Users table with passwords | Company sign-in; staff and tool room see different things |
The original is Inventory Management App by Diaz Adriansyah, a VB.NET Windows Forms program under the MIT License, written for a lab in Indonesia. Its screens above are from the project's page. The web app follows its screens and tables; the company, people and history are fictional.