# The architecture ```mermaid architecture-beta group server(server)[Ubuntu server] service db(database)[Database]in server service background(cloud)[Background worker]in server service asp(internet)[ASP app]in server service node(internet)[NodeJS server]in server service yarp(internet)[YARP]in server service jama(server)[Jama REST API] service client(disk)[Client] db:R -- L:asp background:B -- T:db jama:R -- L:background node:B -- T:yarp asp:R -- L:yarp yarp:B -- T:client ``` # Data layer **EF Core (code first approach)** ```csharp public class Project : IProject { public int ProjectId { get; set; } public int JamaId { get; set; } [MaxLength(255)] public required string? Name { get; set; } public required List Reports { get; set; } public ProjectSource Source { get; set; } } ``` **DbContext** ```csharp using Microsoft.EntityFrameworkCore; using Shared.Models; using Shared.Models.Reports; namespace Shared.Data; /// /// /// /// public class ReportContext(DbContextOptions options) : DbContext(options) { public DbSet BaseReports { get; set; } public DbSet Projects { get; set; } public DbSet ArchitecturalDesignReports { get; set; } public DbSet DetailedDesignReports { get; set; } public DbSet IntegrationTestReports { get; set; } public DbSet QualificationTestReports { get; set; } public DbSet RequirementsAnalysisReports { get; set; } public DbSet UnitVerificationReports { get; set; } /// protected override void OnModelCreating(ModelBuilder modelBuilder) { modelBuilder.Entity(entity => entity.HasBaseType()); modelBuilder.Entity(entity => entity.HasBaseType()); modelBuilder.Entity(entity => entity.HasBaseType()); modelBuilder.Entity(entity => entity.HasBaseType()); modelBuilder.Entity(entity => entity.HasBaseType()); modelBuilder.Entity(entity => entity.HasBaseType()); } } ``` **Providing dbcontext** ```csharp var connectionString = builder.Configuration.GetConnectionString("mysql") ?? throw new InvalidOperationException("Please provide the config value \"ConnectionStrings::mysql\"."); builder.Services.AddDbContext(o => o.UseMySql(connectionString, new MySqlServerVersion(new Version(8, 4, 4)))); ``` **Migration command** ```plaintext dotnet ef migrations add AddedProject ``` **Auto generated migration** ```csharp public partial class AddedProject : Migration { /// protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.CreateTable( name: "Projects", columns: table => new { ProjectId = table.Column(type: "int", nullable: false) .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn), JamaId = table.Column(type: "int", nullable: false), Name = table.Column(type: "longtext", nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), Source = table.Column(type: "int", nullable: false) }, constraints: table => { table.PrimaryKey("PK_Projects", x => x.ProjectId); }) .Annotation("MySql:CharSet", "utf8mb4"); migrationBuilder.CreateTable( name: "BaseReports", columns: table => new { Id = table.Column(type: "int", nullable: false) .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn), CreatedAt = table.Column(type: "datetime(6)", nullable: false), ProjectId = table.Column(type: "int", nullable: false), // Other report properties }, constraints: table => { table.ForeignKey( name: "FK_BaseReports_Projects_ProjectId", column: x => x.ProjectId, principalTable: "Projects", principalColumn: "ProjectId", onDelete: ReferentialAction.Cascade); }) .Annotation("MySql:CharSet", "utf8mb4"); } /// protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropTable( name: "BaseReports"); migrationBuilder.DropTable( name: "Projects"); } } ``` **Updating database** # Background worker - Runs periodically - Interacts with Jama REST API to get data ```plaintext 2025-07-09 21:04:03 info: ReportWorker.ReportBackgroundWorker[0] Successfully generated and saved 330 reports 2025-07-09 21:04:03 info: ReportWorker.ReportBackgroundWorker[0] Starting execution in 23 hours and 55 minutes ``` **Fetching data from Jama** ```plaintext GET https://innolux.jamacloud.com/filters/42/results?project=1234&maxResults=1 ``` **Jama client implementation** ```csharp public async Task> TryGetFilterResultCount( int filterId, int projectId, CancellationToken cancellationToken = default) { const int maxResults = 1; // We're only interested in the count and not the items itself, 1 is minimum. var queryParams = new Dictionary { { "project", projectId.ToString() }, { "maxResults", maxResults.ToString() } }; var queryString = QueryString.Create(queryParams); HttpResponseMessage response; try { response = await _httpClient.GetAsync($"filters/{filterId}/results{queryString}", cancellationToken); } catch (Exception e) { _logger.LogError(e, "An error has occured while fetching the Jama API for filter results, " + "filter id: {filterId}, project: {projectId}", filterId, projectId ); return Result.Failure(e); } if (!response.IsSuccessStatusCode) { var errorMessage = await response.Content.ReadAsStringAsync(cancellationToken); _logger.LogError("Request failed with status code {StatusCode}: {Error Message}", response.StatusCode, errorMessage); return Result.Failure(new HttpRequestException( $"Request failed with status code {response.StatusCode}: {errorMessage}")); } try { var filterResults = await response.Content.ReadFromJsonAsync(cancellationToken); return filterResults?.Meta.PageInfo is null ? Result.Failure(new InvalidOperationException("Failed to deserialize response content.")) : Result.Success(filterResults.Meta.PageInfo.TotalResults); } catch (Exception e) { return Result.Failure(e); } } ``` # ASP.NET application (web) - Exposes report data via HTTP - Build with DI [Link to specification](https://editor.swagger.io/) # Next.js application (React) - Serves static HTML + interactive JavaScript to the client - Persistent widget configuration - Chart.js # YARP (Reverse proxy) - Static IP - Proxies requests

<DaanEggen/>

</>

Metrics dashboard presentation