itsok2023/CRUD_BY_ZESTORM — reverse-engineered prompt

I want this repo turned into a simple Product CRUD module that matches the existing Role pattern already in the project. Use the same database and stored procedure style from the README.

In the UI, I should be able to see all products in a grid, add a new product, edit one, delete one, and open a single product by id. Each product should have category name, product name, product price, and active status. I also want a search area where I can filter by category and product name, with dropdowns populated from the distinct category and product name queries.

Please wire everything through the application, domain, infrastructure, and UI layers so it actually works end to end, including database calls to CreateProduct, UpdateProduct, DeleteProduct, GetProductById, GetProducts, SearchProducts, GetCategoryNames, and GetProductNames. Add basic validation for required fields and sensible price input. If helpful, include the sample product seed data from the README so I can test it right away. Look up current docs online if you need to.