SqGoods

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.

Prerequisites

• .NET 8 SDK
• MSSQL or MYSQL or PostgreSQL server (you will need to create an empty database)

Configuration

In <Code Root>/SqGoods/appsettings.json update the following attributes

• DbType - MsSql or MySql or PgSql
• 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.

Running

1. go to <Code Root>/SqGoods
2. run dotnet run
3. Open https://localhost:7042 in a browser

The repository includes prebuilt production SPA assets under SqGoods/ClientApp/dist, so dotnet run does not require npm/node.

If you need to rebuild frontend assets manually:

1. go to <Code Root>/SqGoods/ClientApp
2. run npm install
3. run npm run build

npm run build is configured to regenerate only production assets under SqGoods/ClientApp/dist/SqGoods.

What the Application does

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: