Skip to content

Latest commit

 

History

History
49 lines (33 loc) · 1.88 KB

README.md

File metadata and controls

49 lines (33 loc) · 1.88 KB

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 6 SDK
  • NodeJS
  • 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 http://localhost:55242 in a browser

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:

img1

  • 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)

img3

  • Also, administrator can add/remove/modify products in a selected category using the category attributes:

img2

  • Any user can see products grouped by categories and create a complex query:

img4

  • All database data can be exported into a JSON file:

img5