It is a demo web application that demonstrates abilities of SqExpress and ngSetState libraries.
SqGoods it is a catalog of products with dynamic attributes.
The key feature is a complex filtering (any kind of boolean expressions) using the dynamic attributes.
- .Net 6 SDK
- NodeJS
- MSSQL or MYSQL or PostgreSQL server (you will need to create an empty database)
In <Code Root>/SqGoods/appsettings.json
update the following attributes
- DbType -
MsSql
orMySql
orPgSql
- ConnectionString - proper connection string to a selected server and the empty database
All required tables and initial data will be created at the first run.
- go to
<Code Root>/SqGoods
- run
dotnet run
- Open
http:https://localhost:55242
in a browser
SqGoods is a catalog of products divided into different categories with their own attributes.
- The administrator can add/remove both the categories themselves and their attributes:
- An attribute can be one of the following types:
- Boolean
- Integer
- One of predefined attribute items (single select)
- Subset of predefined attribute items (multi select)
- Also, administrator can add/remove/modify products in a selected category using the category attributes:
- Any user can see products grouped by categories and create a complex query:
- All database data can be exported into a JSON file: