Overview

Architecture Diagram

Browser / Mobile
      │
Angular 20 FE  ←─── projects/wi/ and projects/cms/
      │  HTTP
      ▼
FastEndpoints SL  ←─── WiSL / CMSSL
      │
BLL (Business Logic)  ←─── WiBLL / CMSBLL
      │
DAL (Data Access)  ←─── WiDAL / CMSDAL
      │  Dapper + raw SQL
SQL Server (WI.* and DBO.* schemas)

Three-Layer Pattern

SL (*.cs in EndPoints/) → BaseEndpoint<TReq, TResp>
  ↓ injects IBll
BLL (*.cs in WiBLL/) → validates, orchestrates
  ↓ injects IDal
DAL (*.cs in WiDAL/CustomCode/) → IQueryExecutor → Dapper
  ↑ SQL constants in WiDAL/Query/Wi/*QB.cs

Legend & Conventions

WI BE Section 1: WI Module — Backend (C#)

1.1 Database Schema DB

1.2 Query Builders (SQL Constants) BE

All SQL lives in *QB.cs files as public const string. Never embedded inline in BLL/DAL.

1.3 DTOs and Enums BE

1.4 DAL Layer (Data Access) BE DB

1.5 BLL Layer (Business Logic) BE

Same structure as DAL but adds validation, orchestration, and cache invalidation.

1.6 SL Layer (FastEndpoints — HTTP) BE API

Base path for all WI endpoints: /wi/{Group}/{Action}.

WI FE Section 2: WI Module — Frontend (Angular 20)

2.1 Key Services

2.2 Models and Enums

2.3 Player Components

All under projects/wi/src/lib/player/.

2.4 Content Block Renderers

All under projects/wi/src/lib/player/content/.

2.5 Renderer Components (Layout Layer)

All under projects/wi/src/lib/renderer/.

2.6 Authoring / Master Components

All under projects/wi/src/lib/master/.

2.7 Shared UI Components

2.8 Line Setup Components

2.9 Shift Roster Components

2.10 Analytics Components

CMS BE Section 3: CMS Module — Backend (C#)

3.1 Database Schema DB

3.2 Query Builders BE

3.3 DAL Layer BE

3.4 BLL Layer BE

Same interface names with the CMSBLL namespace. Key business rules:

3.5 SL Layer (FastEndpoints) BE API

Base path: /cms/{Group}/{Action}.

CMS FE Section 4: CMS Module — Frontend (Angular 20)

4.1 Services

4.2 Components

4.3 CmsEditorService State Shape

// projects/cms/service/cms-editor.service.ts
currentDocument = signal<ContentFullDocumentDTO | null>(null);
selectedContainerIdx = signal<number>(-1);
selectedBlockId = signal<number>(-1);
isDirty = signal<boolean>(false);
// auto-save: debounce 2s after last edit → calls CmsDbService.saveContentBlock()

Section 5: Key Design Patterns & Conventions

5.1 Query Builder Pattern BE

// WiDAL/Query/Wi/WiMasterQB.cs
public static class WiMasterQB {
    public const string GET_WI_FULL_DETAIL = @"
        SELECT w.WIID, w.WICODE, ...
        FROM   WI.MWI w
        WHERE  w.WIID = @WiId AND w.TENANTID = @TenantId";
}

5.2 DAL via IQueryExecutor BE

// Never store IDbConnection; always use IQueryExecutor
var result = await _qe.QueryAsync<WiHeaderDTO>(login, WiMasterQB.GET_WI_LIST,
    new { TenantId = login.ClientId, WiProcessId = wiProcessId },
    cancellationToken: ct).ConfigureAwait(false);

5.3 FastEndpoint SL Template BE API

public class GetWIList : BaseEndpoint<GetWIList.Parameters, ResponseStandardDTO<object>> {
    public override void Configure() { Get("/WI/GetWIList"); AllowAnonymous(); }

    protected override string? GetCacheKey(Parameters req, LoginDTO login)
        => $"WiList:{login.ClientId}:{req.WiProcessId}:{req.WiStatus}";

    protected override async Task<ResponseStandardDTO<object>> ExecuteAsync(
        Parameters req, LoginDTO login, CancellationToken ct)
        => await _bll.GetWiList(req.WiProcessId, req.WiStatus, login, ct);
}

5.4 Angular Signal Pattern FE

// Reactive data with rxResource
readonly wiDetail = rxResource({
  request: () => ({ wiId: this.wiId() }),
  loader: ({ request }) => this.db.getWiFullDetail(request.wiId)
});

5.5 Specificity Scoring Algorithm (Assignment Resolution)

Score = RoutingDetailId match: +30
      + WorkstationId match:   +15
      + RoutingId match:       +20
      + WorkCenterId match:    +10
      + ModelId match:         +10
      + ProductFamilyId match: +5

Max = 90 points. Highest score wins.

5.6 Content Lifecycle (CMS)

Draft (0) → Submit → InReview (1) → Approve → Approved (2)
         → Publish → Published (3) → Archive → Archived (4)

No backward transitions.
TCONTENTVERSION snapshot created on each Publish.

5.7 Append-Only Tables DB