feat(CUB-39): create background job for filament usage sync

backend/API/Controllers/PrintJobsController.cs

@@ -413,92 +413,6 @@ public class PrintJobsController : ControllerBase
         return NoContent();
     }
 
-    // ── GET /api/printjobs/{id}/cost-summary ──────────────────────────
-
-    /// <summary>
-    /// Gets the material cost summary for a specific print job.
-    /// Calculates total material cost from filament usage (grams derived)
-    /// and the spool's purchase price. Returns warnings instead of errors
-    /// when cost data is unavailable.
-    /// </summary>
-    /// <param name="id">The unique identifier of the print job.</param>
-    /// <returns>A cost summary with breakdown and any warnings about missing data.</returns>
-    /// <response code="200">Returns the cost summary. Warnings field lists any missing data.</response>
-    /// <response code="404">If the print job with the given ID is not found.</response>
-    [HttpGet("{id:guid}/cost-summary")]
-    [ProducesResponseType(typeof(CostSummaryResponse), StatusCodes.Status200OK)]
-    [ProducesResponseType(StatusCodes.Status404NotFound)]
-    public async Task<ActionResult<CostSummaryResponse>> GetCostSummary(Guid id)
-    {
-        _logger.LogDebug("Getting cost summary for print job {Id}", id);
-
-        var job = await _dbContext.PrintJobs
-            .Include(j => j.Spool)
-                .ThenInclude(s => s!.MaterialBase)
-            .FirstOrDefaultAsync(j => j.Id == id);
-
-        if (job is null)
-        {
-            _logger.LogWarning("Print job {Id} not found for cost summary", id);
-            return NotFound(new { error = $"Print job with ID '{id}' not found." });
-        }
-
-        var warnings = new List<string>();
-        var spool = job.Spool;
-
-        // Build response with what we have
-        var response = new CostSummaryResponse
-        {
-            PrintJobId = job.Id,
-            PrintName = job.PrintName,
-            SpoolId = job.SpoolId,
-            SpoolSerial = spool?.SpoolSerial ?? string.Empty,
-            SpoolBrand = spool?.Brand ?? string.Empty,
-            SpoolColorName = spool?.ColorName ?? string.Empty,
-            MmExtruded = job.MmExtruded,
-            GramsDerived = job.GramsDerived,
-            SpoolPurchasePrice = spool?.PurchasePrice,
-            SpoolWeightTotalGrams = spool?.WeightTotalGrams,
-            StoredCostPerPrint = job.CostPerPrint
-        };
-
-        // Validate spool data availability
-        if (spool is null)
-        {
-            warnings.Add("Spool data is not available for this print job. Cost cannot be calculated.");
-            response.Warnings = warnings;
-            return Ok(response);
-        }
-
-        // Check if we can calculate cost
-        if (!spool.PurchasePrice.HasValue)
-        {
-            warnings.Add("Spool purchase price is not set. Cost per gram and total material cost cannot be calculated.");
-        }
-
-        if (spool.WeightTotalGrams <= 0)
-        {
-            warnings.Add("Spool total weight is zero or invalid. Cost per gram and total material cost cannot be calculated.");
-        }
-
-        // If we have enough data, calculate the cost
-        if (spool.PurchasePrice.HasValue && spool.WeightTotalGrams > 0)
-        {
-            var pricePerGram = spool.PurchasePrice.Value / spool.WeightTotalGrams;
-            response.PricePerGram = Math.Round(pricePerGram, 4);
-            response.TotalMaterialCost = Math.Round(job.GramsDerived * pricePerGram, 4);
-        }
-
-        // Warn if grams derived is zero but mm extruded is non-zero
-        if (job.GramsDerived == 0 && job.MmExtruded > 0)
-        {
-            warnings.Add("GramsDerived is zero despite MmExtruded being non-zero. Cost may be inaccurate. Consider re-deriving grams from filament parameters.");
-        }
-
-        response.Warnings = warnings;
-        return Ok(response);
-    }
-
     // ── Gram Derivation Formula ────────────────────────────────────
 
     /// <summary>

backend/API/DTOs/PrintJobs/CostSummaryResponse.cs

@@ -1,55 +0,0 @@
-namespace Extrudex.API.DTOs.PrintJobs;
-
-/// <summary>
-/// Response DTO for the cost summary of a print job.
-/// Provides a breakdown of material cost based on filament usage
-/// and spool pricing data. If cost data is incomplete, warnings
-/// are returned instead of throwing an error.
-/// </summary>
-public class CostSummaryResponse
-{
-    /// <summary>Unique identifier of the print job.</summary>
-    public Guid PrintJobId { get; set; }
-
-    /// <summary>Human-readable name of the print job.</summary>
-    public string PrintName { get; set; } = string.Empty;
-
-    /// <summary>Foreign key to the spool used for this print job.</summary>
-    public Guid SpoolId { get; set; }
-
-    /// <summary>Serial number of the spool.</summary>
-    public string SpoolSerial { get; set; } = string.Empty;
-
-    /// <summary>Brand of the spool.</summary>
-    public string SpoolBrand { get; set; } = string.Empty;
-
-    /// <summary>Color name of the spool.</summary>
-    public string SpoolColorName { get; set; } = string.Empty;
-
-    /// <summary>Total millimeters of filament extruded during this print.</summary>
-    public decimal MmExtruded { get; set; }
-
-    /// <summary>Derived grams consumed for this print job.</summary>
-    public decimal GramsDerived { get; set; }
-
-    /// <summary>Purchase price of the full spool, if available.</summary>
-    public decimal? SpoolPurchasePrice { get; set; }
-
-    /// <summary>Total weight of the spool in grams when full.</summary>
-    public decimal? SpoolWeightTotalGrams { get; set; }
-
-    /// <summary>Calculated price per gram (purchase price / total weight), if available.</summary>
-    public decimal? PricePerGram { get; set; }
-
-    /// <summary>Calculated total material cost for this print job, if available.</summary>
-    public decimal? TotalMaterialCost { get; set; }
-
-    /// <summary>The CostPerPrint stored on the print job entity, if set.</summary>
-    public decimal? StoredCostPerPrint { get; set; }
-
-    /// <summary>
-    /// Warnings about missing data that prevent cost calculation.
-    /// Empty if all data is available and cost was calculated successfully.
-    /// </summary>
-    public List<string> Warnings { get; set; } = new();
-}

backend/API/Jobs/FilamentUsageSyncJob.cs

@@ -0,0 +1,79 @@
+using Extrudex.Domain.Interfaces;
+using Extrudex.Infrastructure.Configuration;
+using Microsoft.Extensions.Hosting;
+using Microsoft.Extensions.Logging;
+using Microsoft.Extensions.Options;
+
+namespace Extrudex.API.Jobs;
+
+/// <summary>
+/// Background job that periodically syncs filament usage data from
+/// Moonraker printers. Runs as a hosted service and polls all active
+/// Moonraker printers on a configurable interval to persist usage
+/// data to the Extrudex database.
+/// 
+/// Configuration is bound from the "FilamentUsageSync" section in
+/// appsettings.json. Set Enabled=false to disable without removing
+/// the service registration.
+/// </summary>
+public class FilamentUsageSyncJob : BackgroundService
+{
+    private readonly IFilamentUsageSyncService _syncService;
+    private readonly FilamentUsageSyncOptions _options;
+    private readonly ILogger<FilamentUsageSyncJob> _logger;
+
+    /// <summary>
+    /// Creates a new FilamentUsageSyncJob.
+    /// </summary>
+    /// <param name="syncService">The service that performs the actual sync logic.</param>
+    /// <param name="options">Configuration options for polling interval and timeouts.</param>
+    /// <param name="logger">Logger for diagnostic output.</param>
+    public FilamentUsageSyncJob(
+        IFilamentUsageSyncService syncService,
+        IOptions<FilamentUsageSyncOptions> options,
+        ILogger<FilamentUsageSyncJob> logger)
+    {
+        _syncService = syncService;
+        _options = options.Value;
+        _logger = logger;
+    }
+
+    /// <inheritdoc />
+    protected override async Task ExecuteAsync(CancellationToken stoppingToken)
+    {
+        if (!_options.Enabled)
+        {
+            _logger.LogInformation("Filament usage sync job is disabled via configuration — exiting");
+            return;
+        }
+
+        _logger.LogInformation(
+            "Filament usage sync job starting — polling every {Interval}",
+            _options.PollingInterval);
+
+        // Delay briefly on startup to allow the web host to fully initialize
+        await Task.Delay(TimeSpan.FromSeconds(10), stoppingToken);
+
+        while (!stoppingToken.IsCancellationRequested)
+        {
+            try
+            {
+                var syncedCount = await _syncService.SyncAllAsync(stoppingToken);
+
+                _logger.LogInformation(
+                    "Filament usage sync completed — {SyncedCount} printer(s) synced. Next sync in {Interval}",
+                    syncedCount, _options.PollingInterval);
+            }
+            catch (Exception ex) when (ex is not OperationCanceledException)
+            {
+                _logger.LogError(ex,
+                    "Error during filament usage sync cycle — will retry in {Interval}",
+                    _options.PollingInterval);
+            }
+
+            await Task.Delay(_options.PollingInterval, stoppingToken);
+        }
+
+        _logger.LogInformation("Filament usage sync job shutting down");
+    }
+}

backend/Domain/Entities/FilamentUsage.cs

@@ -1,73 +0,0 @@
-using Extrudex.Domain.Base;
-
-namespace Extrudex.Domain.Entities;
-
-/// <summary>
-/// Tracks filament consumption for a specific print job on a specific spool.
-/// Each record captures the grams used, which printer consumed it, and when the
-/// usage was recorded. This enables granular per-job usage analytics, COGS
-/// reconciliation, and spool weight depletion tracking.
-///
-/// A single PrintJob may have multiple FilamentUsage records if multiple spools
-/// were consumed (e.g., multi-material prints via AMS).
-/// </summary>
-public class FilamentUsage : AuditableEntity
-{
-    /// <summary>
-    /// Foreign key to the print job that consumed this filament.
-    /// A usage record is always tied to a print job.
-    /// </summary>
-    public Guid PrintJobId { get; set; }
-
-    /// <summary>
-    /// Navigation to the print job that consumed this filament.
-    /// </summary>
-    public PrintJob PrintJob { get; set; } = null!;
-
-    /// <summary>
-    /// Foreign key to the spool (filament) that provided the material.
-    /// Links usage back to the specific physical spool for inventory tracking.
-    /// </summary>
-    public Guid SpoolId { get; set; }
-
-    /// <summary>
-    /// Navigation to the spool that provided the material.
-    /// </summary>
-    public Spool Spool { get; set; } = null!;
-
-    /// <summary>
-    /// Foreign key to the printer that executed the print job.
-    /// Denormalized from PrintJob for direct querying of per-printer usage.
-    /// </summary>
-    public Guid PrinterId { get; set; }
-
-    /// <summary>
-    /// Navigation to the printer that executed the print job.
-    /// </summary>
-    public Printer Printer { get; set; } = null!;
-
-    /// <summary>
-    /// Grams of filament consumed during this print job.
-    /// Derived from mm_extruded × cross_section_area × material_density,
-    /// or measured directly from AMS weight delta.
-    /// </summary>
-    public decimal GramsUsed { get; set; }
-
-    /// <summary>
-    /// Millimeters of filament extruded for this usage record.
-    /// The primary physical measurement; grams_used is derived from this.
-    /// </summary>
-    public decimal MmExtruded { get; set; }
-
-    /// <summary>
-    /// Timestamp when this usage record was created (UTC).
-    /// Represents when the usage was first logged, which may differ from
-    /// the print job's started_at or completed_at timestamps.
-    /// </summary>
-    public DateTime RecordedAt { get; set; } = DateTime.UtcNow;
-
-    /// <summary>
-    /// Optional notes about this usage record (e.g., "AMS tray 3", "manual weight check").
-    /// </summary>
-    public string? Notes { get; set; }
-}

backend/Domain/Entities/PrintJob.cs

@@ -97,10 +97,4 @@ public class PrintJob : AuditableEntity
     /// Optional notes about the print job (e.g., "First layer adhesion issues").
     /// </summary>
     public string? Notes { get; set; }
-
-    /// <summary>
-    /// Navigation collection of filament usage records for this print job.
-    /// Enables tracking granular per-spool consumption within a print.
-    /// </summary>
-    public ICollection<FilamentUsage> FilamentUsages { get; set; } = new List<FilamentUsage>();
 }

backend/Domain/Entities/Printer.cs

@@ -94,10 +94,4 @@ public class Printer : AuditableEntity
     /// Navigation collection of print jobs executed on this printer.
     /// </summary>
     public ICollection<PrintJob> PrintJobs { get; set; } = new List<PrintJob>();
-
-    /// <summary>
-    /// Navigation collection of filament usage records tracking consumption on this printer.
-    /// Enables querying per-printer filament usage and COGS.
-    /// </summary>
-    public ICollection<FilamentUsage> FilamentUsages { get; set; } = new List<FilamentUsage>();
 }

backend/Domain/Entities/Spool.cs

@@ -102,10 +102,4 @@ public class Spool : AuditableEntity
     /// Navigation collection of print jobs that consumed filament from this spool.
     /// </summary>
     public ICollection<PrintJob> PrintJobs { get; set; } = new List<PrintJob>();
-
-    /// <summary>
-    /// Navigation collection of filament usage records tracking consumption from this spool.
-    /// Enables querying how much filament was consumed per print job.
-    /// </summary>
-    public ICollection<FilamentUsage> FilamentUsages { get; set; } = new List<FilamentUsage>();
 }

backend/Domain/Interfaces/IFilamentUsageSyncService.cs

@@ -0,0 +1,19 @@
+namespace Extrudex.Domain.Interfaces;
+
+/// <summary>
+/// Service interface for syncing filament usage data from printers
+/// into the Extrudex database. Handles querying Moonraker printers,
+/// computing derived usage metrics, and persisting updates to spools
+/// and print job records.
+/// </summary>
+public interface IFilamentUsageSyncService
+{
+    /// <summary>
+    /// Performs a single sync cycle: queries all active Moonraker printers,
+    /// fetches their current filament usage data, and persists updates to
+    /// the database.
+    /// </summary>
+    /// <param name="cancellationToken">Cancellation token for graceful shutdown.</param>
+    /// <returns>The number of printers successfully synced.</returns>
+    Task<int> SyncAllAsync(CancellationToken cancellationToken = default);
+}

backend/Domain/Interfaces/IMoonrakerClient.cs

@@ -0,0 +1,39 @@
+namespace Extrudex.Domain.Interfaces;
+
+/// <summary>
+/// Client interface for communicating with Moonraker REST API endpoints
+/// on Klipper-based printers (e.g., Elegoo Centauri Carbon).
+/// Used to retrieve filament usage data, print job status, and
+/// remaining spool weight from the printer.
+/// </summary>
+public interface IMoonrakerClient
+{
+    /// <summary>
+    /// Fetches the current filament usage data from the Moonraker server.
+    /// Returns a dictionary of usage metrics reported by the printer.
+    /// </summary>
+    /// <param name="hostnameOrIp">The printer's hostname or IP address.</param>
+    /// <param name="port">The Moonraker API port (default: 7125).</param>
+    /// <param name="apiKey">Optional API key for authentication.</param>
+    /// <param name="cancellationToken">Cancellation token for the HTTP request.</param>
+    /// <returns>A dictionary of usage metric names to their decimal values.</returns>
+    Task<Dictionary<string, decimal>> GetFilamentUsageAsync(
+        string hostnameOrIp,
+        int port,
+        string? apiKey,
+        CancellationToken cancellationToken = default);
+
+    /// <summary>
+    /// Checks whether the Moonraker server is reachable and responding.
+    /// </summary>
+    /// <param name="hostnameOrIp">The printer's hostname or IP address.</param>
+    /// <param name="port">The Moonraker API port (default: 7125).</param>
+    /// <param name="apiKey">Optional API key for authentication.</param>
+    /// <param name="cancellationToken">Cancellation token for the HTTP request.</param>
+    /// <returns><c>true</c> if the server responded successfully; otherwise <c>false</c>.</returns>
+    Task<bool> IsReachableAsync(
+        string hostnameOrIp,
+        int port,
+        string? apiKey,
+        CancellationToken cancellationToken = default);
+}

backend/Infrastructure/Configuration/FilamentUsageSyncOptions.cs

@@ -0,0 +1,33 @@
+namespace Extrudex.Infrastructure.Configuration;
+
+/// <summary>
+/// Configuration options for the FilamentUsageSync background job.
+/// Bound from appsettings.json under the "FilamentUsageSync" section.
+/// Controls polling interval and per-printer timeout settings.
+/// </summary>
+public class FilamentUsageSyncOptions
+{
+    /// <summary>
+    /// The section name in appsettings.json where these options are bound.
+    /// </summary>
+    public const string SectionName = "FilamentUsageSync";
+
+    /// <summary>
+    /// How often the background job polls printers for usage data.
+    /// Default: 5 minutes. Minimum recommended: 1 minute.
+    /// </summary>
+    public TimeSpan PollingInterval { get; set; } = TimeSpan.FromMinutes(5);
+
+    /// <summary>
+    /// Timeout for individual HTTP requests to a Moonraker printer.
+    /// Default: 30 seconds.
+    /// </summary>
+    public TimeSpan RequestTimeout { get; set; } = TimeSpan.FromSeconds(30);
+
+    /// <summary>
+    /// Whether the sync job is enabled. Set to false to disable
+    /// the background job without removing its registration.
+    /// Default: true.
+    /// </summary>
+    public bool Enabled { get; set; } = true;
+}

backend/Infrastructure/Data/Configurations/FilamentUsageConfiguration.cs

@@ -1,83 +0,0 @@
-using Extrudex.Domain.Entities;
-using Microsoft.EntityFrameworkCore;
-using Microsoft.EntityFrameworkCore.Metadata.Builders;
-
-namespace Extrudex.Infrastructure.Data.Configurations;
-
-public class FilamentUsageConfiguration : BaseEntityConfiguration<FilamentUsage>
-{
-    public override void Configure(EntityTypeBuilder<FilamentUsage> builder)
-    {
-        base.Configure(builder);
-
-        builder.Property(e => e.PrintJobId)
-            .HasColumnName("print_job_id")
-            .IsRequired();
-
-        builder.Property(e => e.SpoolId)
-            .HasColumnName("spool_id")
-            .IsRequired();
-
-        builder.Property(e => e.PrinterId)
-            .HasColumnName("printer_id")
-            .IsRequired();
-
-        builder.Property(e => e.GramsUsed)
-            .HasColumnName("grams_used")
-            .HasPrecision(10, 2)
-            .IsRequired();
-
-        builder.Property(e => e.MmExtruded)
-            .HasColumnName("mm_extruded")
-            .HasPrecision(12, 2)
-            .IsRequired();
-
-        builder.Property(e => e.RecordedAt)
-            .HasColumnName("recorded_at")
-            .HasDefaultValueSql("now() at time zone 'utc'")
-            .IsRequired();
-
-        builder.Property(e => e.Notes)
-            .HasColumnName("notes")
-            .HasMaxLength(2000);
-
-        // Index on print_job_id for querying usage by print job
-        builder.HasIndex(e => e.PrintJobId)
-            .HasDatabaseName("ix_filament_usages_print_job_id");
-
-        // Index on spool_id for querying usage by spool (filament)
-        builder.HasIndex(e => e.SpoolId)
-            .HasDatabaseName("ix_filament_usages_spool_id");
-
-        // Index on printer_id for querying usage by printer
-        builder.HasIndex(e => e.PrinterId)
-            .HasDatabaseName("ix_filament_usages_printer_id");
-
-        // Index on recorded_at for time-range queries
-        builder.HasIndex(e => e.RecordedAt)
-            .HasDatabaseName("ix_filament_usages_recorded_at");
-
-        // Composite index for querying usage by spool within a date range
-        builder.HasIndex(e => new { e.SpoolId, e.RecordedAt })
-            .HasDatabaseName("ix_filament_usages_spool_id_recorded_at");
-
-        // Relationships
-        builder.HasOne(e => e.PrintJob)
-            .WithMany(e => e.FilamentUsages)
-            .HasForeignKey(e => e.PrintJobId)
-            .HasConstraintName("fk_filament_usages_print_job")
-            .OnDelete(DeleteBehavior.Cascade);
-
-        builder.HasOne(e => e.Spool)
-            .WithMany(e => e.FilamentUsages)
-            .HasForeignKey(e => e.SpoolId)
-            .HasConstraintName("fk_filament_usages_spool")
-            .OnDelete(DeleteBehavior.Restrict);
-
-        builder.HasOne(e => e.Printer)
-            .WithMany(e => e.FilamentUsages)
-            .HasForeignKey(e => e.PrinterId)
-            .HasConstraintName("fk_filament_usages_printer")
-            .OnDelete(DeleteBehavior.Restrict);
-    }
-}

backend/Infrastructure/Data/ExtrudexDbContext.cs

@@ -23,7 +23,6 @@ public class ExtrudexDbContext : DbContext
     public DbSet<AmsUnit> AmsUnits => Set<AmsUnit>();
     public DbSet<AmsSlot> AmsSlots => Set<AmsSlot>();
     public DbSet<PrintJob> PrintJobs => Set<PrintJob>();
-    public DbSet<FilamentUsage> FilamentUsages => Set<FilamentUsage>();
 
     protected override void OnModelCreating(ModelBuilder modelBuilder)
     {

backend/Infrastructure/Data/Migrations/20260426183433_AddFilamentUsageTrackingModel.cs

@@ -1,533 +0,0 @@
-using System;
-using Microsoft.EntityFrameworkCore.Migrations;
-
-#nullable disable
-
-namespace Extrudex.Infrastructure.Data.Migrations
-{
-    /// <inheritdoc />
-    public partial class AddFilamentUsageTrackingModel : Migration
-    {
-        /// <inheritdoc />
-        protected override void Up(MigrationBuilder migrationBuilder)
-        {
-            migrationBuilder.CreateTable(
-                name: "filament_usages",
-                columns: table => new
-                {
-                    id = table.Column<Guid>(type: "uuid", nullable: false),
-                    print_job_id = table.Column<Guid>(type: "uuid", nullable: false),
-                    spool_id = table.Column<Guid>(type: "uuid", nullable: false),
-                    printer_id = table.Column<Guid>(type: "uuid", nullable: false),
-                    grams_used = table.Column<decimal>(type: "numeric(10,2)", precision: 10, scale: 2, nullable: false),
-                    mm_extruded = table.Column<decimal>(type: "numeric(12,2)", precision: 12, scale: 2, nullable: false),
-                    recorded_at = table.Column<DateTime>(type: "timestamp with time zone", nullable: false, defaultValueSql: "now() at time zone 'utc'"),
-                    notes = table.Column<string>(type: "character varying(2000)", maxLength: 2000, nullable: true),
-                    created_at = table.Column<DateTime>(type: "timestamp with time zone", nullable: false, defaultValueSql: "now() at time zone 'utc'"),
-                    updated_at = table.Column<DateTime>(type: "timestamp with time zone", nullable: false, defaultValueSql: "now() at time zone 'utc'")
-                },
-                constraints: table =>
-                {
-                    table.PrimaryKey("PK_filament_usages", x => x.id);
-                    table.ForeignKey(
-                        name: "fk_filament_usages_print_job",
-                        column: x => x.print_job_id,
-                        principalTable: "print_jobs",
-                        principalColumn: "id",
-                        onDelete: ReferentialAction.Cascade);
-                    table.ForeignKey(
-                        name: "fk_filament_usages_printer",
-                        column: x => x.printer_id,
-                        principalTable: "printers",
-                        principalColumn: "id",
-                        onDelete: ReferentialAction.Restrict);
-                    table.ForeignKey(
-                        name: "fk_filament_usages_spool",
-                        column: x => x.spool_id,
-                        principalTable: "spools",
-                        principalColumn: "id",
-                        onDelete: ReferentialAction.Restrict);
-                });
-
-            migrationBuilder.UpdateData(
-                table: "material_bases",
-                keyColumn: "id",
-                keyValue: new Guid("10000000-0000-0000-0000-000000000001"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9388), new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9388) });
-
-            migrationBuilder.UpdateData(
-                table: "material_bases",
-                keyColumn: "id",
-                keyValue: new Guid("10000000-0000-0000-0000-000000000002"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9871), new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9871) });
-
-            migrationBuilder.UpdateData(
-                table: "material_bases",
-                keyColumn: "id",
-                keyValue: new Guid("10000000-0000-0000-0000-000000000003"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9881), new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9881) });
-
-            migrationBuilder.UpdateData(
-                table: "material_bases",
-                keyColumn: "id",
-                keyValue: new Guid("10000000-0000-0000-0000-000000000004"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9888), new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9888) });
-
-            migrationBuilder.UpdateData(
-                table: "material_bases",
-                keyColumn: "id",
-                keyValue: new Guid("10000000-0000-0000-0000-000000000005"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9895), new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9895) });
-
-            migrationBuilder.UpdateData(
-                table: "material_bases",
-                keyColumn: "id",
-                keyValue: new Guid("10000000-0000-0000-0000-000000000006"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9901), new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9902) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000001"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(90), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(90) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000002"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(251), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(251) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000003"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(259), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(259) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000004"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(266), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(266) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000005"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(272), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(272) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000006"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(278), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(278) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000007"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(285), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(285) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000008"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(291), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(291) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000009"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(297), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(298) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000010"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(304), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(304) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000011"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(310), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(310) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000012"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(316), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(317) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000013"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(323), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(323) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000014"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(329), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(329) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000015"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(336), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(336) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000001"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(482), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(482) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000002"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(805), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(806) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000003"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(815), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(815) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000004"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(821), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(821) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000005"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(828), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(828) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000006"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(834), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(834) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000007"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(840), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(840) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000008"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(847), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(847) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000009"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(853), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(853) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000010"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(859), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(860) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000011"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(866), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(866) });
-
-            migrationBuilder.CreateIndex(
-                name: "ix_filament_usages_print_job_id",
-                table: "filament_usages",
-                column: "print_job_id");
-
-            migrationBuilder.CreateIndex(
-                name: "ix_filament_usages_printer_id",
-                table: "filament_usages",
-                column: "printer_id");
-
-            migrationBuilder.CreateIndex(
-                name: "ix_filament_usages_recorded_at",
-                table: "filament_usages",
-                column: "recorded_at");
-
-            migrationBuilder.CreateIndex(
-                name: "ix_filament_usages_spool_id",
-                table: "filament_usages",
-                column: "spool_id");
-
-            migrationBuilder.CreateIndex(
-                name: "ix_filament_usages_spool_id_recorded_at",
-                table: "filament_usages",
-                columns: new[] { "spool_id", "recorded_at" });
-        }
-
-        /// <inheritdoc />
-        protected override void Down(MigrationBuilder migrationBuilder)
-        {
-            migrationBuilder.DropTable(
-                name: "filament_usages");
-
-            migrationBuilder.UpdateData(
-                table: "material_bases",
-                keyColumn: "id",
-                keyValue: new Guid("10000000-0000-0000-0000-000000000001"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1096), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1096) });
-
-            migrationBuilder.UpdateData(
-                table: "material_bases",
-                keyColumn: "id",
-                keyValue: new Guid("10000000-0000-0000-0000-000000000002"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1620), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1620) });
-
-            migrationBuilder.UpdateData(
-                table: "material_bases",
-                keyColumn: "id",
-                keyValue: new Guid("10000000-0000-0000-0000-000000000003"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1630), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1630) });
-
-            migrationBuilder.UpdateData(
-                table: "material_bases",
-                keyColumn: "id",
-                keyValue: new Guid("10000000-0000-0000-0000-000000000004"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1638), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1638) });
-
-            migrationBuilder.UpdateData(
-                table: "material_bases",
-                keyColumn: "id",
-                keyValue: new Guid("10000000-0000-0000-0000-000000000005"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1645), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1645) });
-
-            migrationBuilder.UpdateData(
-                table: "material_bases",
-                keyColumn: "id",
-                keyValue: new Guid("10000000-0000-0000-0000-000000000006"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1651), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1652) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000001"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1850), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1850) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000002"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2041), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2041) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000003"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2049), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2049) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000004"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2055), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2056) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000005"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2062), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2062) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000006"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2068), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2068) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000007"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2075), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2075) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000008"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2081), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2081) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000009"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2100), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2100) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000010"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2107), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2107) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000011"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2113), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2113) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000012"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2120), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2120) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000013"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2126), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2126) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000014"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2132), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2133) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000015"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2139), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2139) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000001"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2304), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2304) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000002"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2463), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2463) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000003"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2471), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2471) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000004"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2477), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2478) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000005"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2484), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2484) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000006"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2490), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2491) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000007"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2497), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2497) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000008"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2503), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2503) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000009"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2510), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2510) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000010"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2516), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2516) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000011"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2522), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2523) });
-        }
-    }
-}

backend/Infrastructure/Data/Migrations/ExtrudexDbContextModelSnapshot.cs

@@ -104,77 +104,6 @@ namespace Extrudex.Infrastructure.Data.Migrations
                     b.ToTable("ams_units", (string)null);
                 });
 
-            modelBuilder.Entity("Extrudex.Domain.Entities.FilamentUsage", b =>
-                {
-                    b.Property<Guid>("Id")
-                        .HasColumnType("uuid")
-                        .HasColumnName("id");
-
-                    b.Property<DateTime>("CreatedAt")
-                        .ValueGeneratedOnAdd()
-                        .HasColumnType("timestamp with time zone")
-                        .HasColumnName("created_at")
-                        .HasDefaultValueSql("now() at time zone 'utc'");
-
-                    b.Property<decimal>("GramsUsed")
-                        .HasPrecision(10, 2)
-                        .HasColumnType("numeric(10,2)")
-                        .HasColumnName("grams_used");
-
-                    b.Property<decimal>("MmExtruded")
-                        .HasPrecision(12, 2)
-                        .HasColumnType("numeric(12,2)")
-                        .HasColumnName("mm_extruded");
-
-                    b.Property<string>("Notes")
-                        .HasMaxLength(2000)
-                        .HasColumnType("character varying(2000)")
-                        .HasColumnName("notes");
-
-                    b.Property<Guid>("PrintJobId")
-                        .HasColumnType("uuid")
-                        .HasColumnName("print_job_id");
-
-                    b.Property<Guid>("PrinterId")
-                        .HasColumnType("uuid")
-                        .HasColumnName("printer_id");
-
-                    b.Property<DateTime>("RecordedAt")
-                        .ValueGeneratedOnAdd()
-                        .HasColumnType("timestamp with time zone")
-                        .HasColumnName("recorded_at")
-                        .HasDefaultValueSql("now() at time zone 'utc'");
-
-                    b.Property<Guid>("SpoolId")
-                        .HasColumnType("uuid")
-                        .HasColumnName("spool_id");
-
-                    b.Property<DateTime>("UpdatedAt")
-                        .ValueGeneratedOnAdd()
-                        .HasColumnType("timestamp with time zone")
-                        .HasColumnName("updated_at")
-                        .HasDefaultValueSql("now() at time zone 'utc'");
-
-                    b.HasKey("Id");
-
-                    b.HasIndex("PrintJobId")
-                        .HasDatabaseName("ix_filament_usages_print_job_id");
-
-                    b.HasIndex("PrinterId")
-                        .HasDatabaseName("ix_filament_usages_printer_id");
-
-                    b.HasIndex("RecordedAt")
-                        .HasDatabaseName("ix_filament_usages_recorded_at");
-
-                    b.HasIndex("SpoolId")
-                        .HasDatabaseName("ix_filament_usages_spool_id");
-
-                    b.HasIndex("SpoolId", "RecordedAt")
-                        .HasDatabaseName("ix_filament_usages_spool_id_recorded_at");
-
-                    b.ToTable("filament_usages", (string)null);
-                });
-
             modelBuilder.Entity("Extrudex.Domain.Entities.MaterialBase", b =>
                 {
                     b.Property<Guid>("Id")
@@ -216,50 +145,50 @@ namespace Extrudex.Infrastructure.Data.Migrations
                         new
                         {
                             Id = new Guid("10000000-0000-0000-0000-000000000001"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9388),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1096),
                             DensityGperCm3 = 1.24m,
                             Name = "PLA",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9388)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1096)
                         },
                         new
                         {
                             Id = new Guid("10000000-0000-0000-0000-000000000002"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9871),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1620),
                             DensityGperCm3 = 1.27m,
                             Name = "PETG",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9871)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1620)
                         },
                         new
                         {
                             Id = new Guid("10000000-0000-0000-0000-000000000003"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9881),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1630),
                             DensityGperCm3 = 1.04m,
                             Name = "ABS",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9881)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1630)
                         },
                         new
                         {
                             Id = new Guid("10000000-0000-0000-0000-000000000004"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9888),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1638),
                             DensityGperCm3 = 1.07m,
                             Name = "ASA",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9888)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1638)
                         },
                         new
                         {
                             Id = new Guid("10000000-0000-0000-0000-000000000005"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9895),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1645),
                             DensityGperCm3 = 1.21m,
                             Name = "TPU",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9895)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1645)
                         },
                         new
                         {
                             Id = new Guid("10000000-0000-0000-0000-000000000006"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9901),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1651),
                             DensityGperCm3 = 1.14m,
                             Name = "Nylon",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9902)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1652)
                         });
                 });
 
@@ -303,122 +232,122 @@ namespace Extrudex.Infrastructure.Data.Migrations
                         new
                         {
                             Id = new Guid("20000000-0000-0000-0000-000000000001"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(90),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1850),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000001"),
                             Name = "Basic",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(90)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1850)
                         },
                         new
                         {
                             Id = new Guid("20000000-0000-0000-0000-000000000002"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(251),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2041),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000001"),
                             Name = "Matte",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(251)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2041)
                         },
                         new
                         {
                             Id = new Guid("20000000-0000-0000-0000-000000000003"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(259),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2049),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000001"),
                             Name = "Silk",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(259)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2049)
                         },
                         new
                         {
                             Id = new Guid("20000000-0000-0000-0000-000000000004"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(266),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2055),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000001"),
                             Name = "Glitter",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(266)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2056)
                         },
                         new
                         {
                             Id = new Guid("20000000-0000-0000-0000-000000000005"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(272),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2062),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000001"),
                             Name = "Marble",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(272)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2062)
                         },
                         new
                         {
                             Id = new Guid("20000000-0000-0000-0000-000000000006"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(278),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2068),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000001"),
                             Name = "Sparkle",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(278)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2068)
                         },
                         new
                         {
                             Id = new Guid("20000000-0000-0000-0000-000000000007"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(285),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2075),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000002"),
                             Name = "Basic",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(285)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2075)
                         },
                         new
                         {
                             Id = new Guid("20000000-0000-0000-0000-000000000008"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(291),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2081),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000002"),
                             Name = "Matte",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(291)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2081)
                         },
                         new
                         {
                             Id = new Guid("20000000-0000-0000-0000-000000000009"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(297),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2100),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000002"),
                             Name = "Silk",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(298)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2100)
                         },
                         new
                         {
                             Id = new Guid("20000000-0000-0000-0000-000000000010"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(304),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2107),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000003"),
                             Name = "Basic",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(304)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2107)
                         },
                         new
                         {
                             Id = new Guid("20000000-0000-0000-0000-000000000011"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(310),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2113),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000003"),
                             Name = "Matte",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(310)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2113)
                         },
                         new
                         {
                             Id = new Guid("20000000-0000-0000-0000-000000000012"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(316),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2120),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000004"),
                             Name = "Basic",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(317)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2120)
                         },
                         new
                         {
                             Id = new Guid("20000000-0000-0000-0000-000000000013"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(323),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2126),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000004"),
                             Name = "Matte",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(323)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2126)
                         },
                         new
                         {
                             Id = new Guid("20000000-0000-0000-0000-000000000014"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(329),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2132),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000005"),
                             Name = "Basic",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(329)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2133)
                         },
                         new
                         {
                             Id = new Guid("20000000-0000-0000-0000-000000000015"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(336),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2139),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000006"),
                             Name = "Basic",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(336)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2139)
                         });
                 });
 
@@ -462,90 +391,90 @@ namespace Extrudex.Infrastructure.Data.Migrations
                         new
                         {
                             Id = new Guid("30000000-0000-0000-0000-000000000001"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(482),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2304),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000001"),
                             Name = "Carbon Fiber",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(482)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2304)
                         },
                         new
                         {
                             Id = new Guid("30000000-0000-0000-0000-000000000002"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(805),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2463),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000001"),
                             Name = "Glass Fiber",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(806)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2463)
                         },
                         new
                         {
                             Id = new Guid("30000000-0000-0000-0000-000000000003"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(815),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2471),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000001"),
                             Name = "Wood Fill",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(815)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2471)
                         },
                         new
                         {
                             Id = new Guid("30000000-0000-0000-0000-000000000004"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(821),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2477),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000001"),
                             Name = "Glow-in-the-Dark",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(821)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2478)
                         },
                         new
                         {
                             Id = new Guid("30000000-0000-0000-0000-000000000005"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(828),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2484),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000002"),
                             Name = "Carbon Fiber",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(828)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2484)
                         },
                         new
                         {
                             Id = new Guid("30000000-0000-0000-0000-000000000006"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(834),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2490),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000002"),
                             Name = "Glass Fiber",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(834)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2491)
                         },
                         new
                         {
                             Id = new Guid("30000000-0000-0000-0000-000000000007"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(840),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2497),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000003"),
                             Name = "Carbon Fiber",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(840)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2497)
                         },
                         new
                         {
                             Id = new Guid("30000000-0000-0000-0000-000000000008"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(847),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2503),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000003"),
                             Name = "Glass Fiber",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(847)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2503)
                         },
                         new
                         {
                             Id = new Guid("30000000-0000-0000-0000-000000000009"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(853),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2510),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000004"),
                             Name = "Carbon Fiber",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(853)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2510)
                         },
                         new
                         {
                             Id = new Guid("30000000-0000-0000-0000-000000000010"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(859),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2516),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000006"),
                             Name = "Carbon Fiber",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(860)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2516)
                         },
                         new
                         {
                             Id = new Guid("30000000-0000-0000-0000-000000000011"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(866),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2522),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000006"),
                             Name = "Glass Fiber",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(866)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2523)
                         });
                 });
 
@@ -909,36 +838,6 @@ namespace Extrudex.Infrastructure.Data.Migrations
                     b.Navigation("Printer");
                 });
 
-            modelBuilder.Entity("Extrudex.Domain.Entities.FilamentUsage", b =>
-                {
-                    b.HasOne("Extrudex.Domain.Entities.PrintJob", "PrintJob")
-                        .WithMany("FilamentUsages")
-                        .HasForeignKey("PrintJobId")
-                        .OnDelete(DeleteBehavior.Cascade)
-                        .IsRequired()
-                        .HasConstraintName("fk_filament_usages_print_job");
-
-                    b.HasOne("Extrudex.Domain.Entities.Printer", "Printer")
-                        .WithMany("FilamentUsages")
-                        .HasForeignKey("PrinterId")
-                        .OnDelete(DeleteBehavior.Restrict)
-                        .IsRequired()
-                        .HasConstraintName("fk_filament_usages_printer");
-
-                    b.HasOne("Extrudex.Domain.Entities.Spool", "Spool")
-                        .WithMany("FilamentUsages")
-                        .HasForeignKey("SpoolId")
-                        .OnDelete(DeleteBehavior.Restrict)
-                        .IsRequired()
-                        .HasConstraintName("fk_filament_usages_spool");
-
-                    b.Navigation("PrintJob");
-
-                    b.Navigation("Printer");
-
-                    b.Navigation("Spool");
-                });
-
             modelBuilder.Entity("Extrudex.Domain.Entities.MaterialFinish", b =>
                 {
                     b.HasOne("Extrudex.Domain.Entities.MaterialBase", "MaterialBase")
@@ -1037,17 +936,10 @@ namespace Extrudex.Infrastructure.Data.Migrations
                     b.Navigation("Spools");
                 });
 
-            modelBuilder.Entity("Extrudex.Domain.Entities.PrintJob", b =>
-                {
-                    b.Navigation("FilamentUsages");
-                });
-
             modelBuilder.Entity("Extrudex.Domain.Entities.Printer", b =>
                 {
                     b.Navigation("AmsUnits");
 
-                    b.Navigation("FilamentUsages");
-
                     b.Navigation("PrintJobs");
                 });
 
@@ -1055,8 +947,6 @@ namespace Extrudex.Infrastructure.Data.Migrations
                 {
                     b.Navigation("AmsSlots");
 
-                    b.Navigation("FilamentUsages");
-
                     b.Navigation("PrintJobs");
                 });
 #pragma warning restore 612, 618

backend/Infrastructure/Services/FilamentUsageSyncService.cs

@@ -0,0 +1,139 @@
+using Extrudex.Domain.Enums;
+using Extrudex.Domain.Interfaces;
+using Extrudex.Infrastructure.Data;
+using Microsoft.EntityFrameworkCore;
+using Microsoft.Extensions.Logging;
+
+namespace Extrudex.Infrastructure.Configuration;
+
+/// <summary>
+/// Service that syncs filament usage data from Moonraker printers into the
+/// Extrudex database. Queries all active Moonraker printers, fetches their
+/// current filament usage metrics, and updates spool remaining weights and
+/// print job records.
+/// </summary>
+public class FilamentUsageSyncService : IFilamentUsageSyncService
+{
+    private readonly ExtrudexDbContext _dbContext;
+    private readonly IMoonrakerClient _moonrakerClient;
+    private readonly ILogger<FilamentUsageSyncService> _logger;
+
+    /// <summary>
+    /// Creates a new FilamentUsageSyncService.
+    /// </summary>
+    /// <param name="dbContext">The EF Core database context for persisting updates.</param>
+    /// <param name="moonrakerClient">The Moonraker HTTP client for fetching printer data.</param>
+    /// <param name="logger">Logger for diagnostic output.</param>
+    public FilamentUsageSyncService(
+        ExtrudexDbContext dbContext,
+        IMoonrakerClient moonrakerClient,
+        ILogger<FilamentUsageSyncService> logger)
+    {
+        _dbContext = dbContext;
+        _moonrakerClient = moonrakerClient;
+        _logger = logger;
+    }
+
+    /// <inheritdoc />
+    public async Task<int> SyncAllAsync(CancellationToken cancellationToken = default)
+    {
+        _logger.LogInformation("Starting filament usage sync cycle");
+
+        var printers = await _dbContext.Printers
+            .Where(p => p.IsActive && p.ConnectionType == ConnectionType.Moonraker)
+            .Include(p => p.AmsUnits)
+                .ThenInclude(u => u.Slots)
+                    .ThenInclude(s => s.Spool)
+            .ToListAsync(cancellationToken);
+
+        if (printers.Count == 0)
+        {
+            _logger.LogInformation("No active Moonraker printers found — skipping sync");
+            return 0;
+        }
+
+        _logger.LogInformation("Found {PrinterCount} active Moonraker printer(s) to sync", printers.Count);
+
+        var syncedCount = 0;
+
+        foreach (var printer in printers)
+        {
+            try
+            {
+                var usageData = await _moonrakerClient.GetFilamentUsageAsync(
+                    printer.HostnameOrIp,
+                    printer.Port,
+                    printer.ApiKey,
+                    cancellationToken);
+
+                if (usageData.Count == 0)
+                {
+                    _logger.LogWarning(
+                        "No usage data returned from printer {PrinterName} ({Host}:{Port})",
+                        printer.Name, printer.HostnameOrIp, printer.Port);
+                    continue;
+                }
+
+                // Update spool remaining weights from AMS data
+                UpdateSpoolWeights(printer, usageData);
+
+                // Mark printer as seen and idle (reachable = idle, not printing)
+                printer.LastSeenAt = DateTime.UtcNow;
+                printer.Status = PrinterStatus.Idle;
+
+                syncedCount++;
+                _logger.LogInformation(
+                    "Successfully synced filament usage from printer {PrinterName}",
+                    printer.Name);
+            }
+            catch (Exception ex)
+            {
+                _logger.LogError(ex,
+                    "Error syncing filament usage from printer {PrinterName} ({Host}:{Port})",
+                    printer.Name, printer.HostnameOrIp, printer.Port);
+            }
+        }
+
+        await _dbContext.SaveChangesAsync(cancellationToken);
+
+        _logger.LogInformation(
+            "Filament usage sync cycle complete — {SyncedCount}/{TotalCount} printers synced",
+            syncedCount, printers.Count);
+
+        return syncedCount;
+    }
+
+    /// <summary>
+    /// Updates spool remaining weights based on usage data received from Moonraker.
+    /// For printers with AMS units, updates the remaining weight on each slot's spool.
+    /// </summary>
+    private void UpdateSpoolWeights(
+        Domain.Entities.Printer printer,
+        Dictionary<string, decimal> usageData)
+    {
+        // Update AMS slot remaining weights if available
+        foreach (var amsUnit in printer.AmsUnits)
+        {
+            foreach (var slot in amsUnit.Slots)
+            {
+                if (slot.Spool != null && slot.RemainingWeightG.HasValue)
+                {
+                    // Sync the AMS-reported remaining weight to the spool
+                    slot.Spool.WeightRemainingGrams = slot.RemainingWeightG.Value;
+
+                    _logger.LogDebug(
+                        "Updated spool {SpoolSerial} remaining weight to {Weight}g",
+                        slot.Spool.SpoolSerial, slot.RemainingWeightG.Value);
+                }
+            }
+        }
+
+        // If usage data contains extruded mm, log it for observability
+        if (usageData.TryGetValue("mm_extruded", out var mmExtruded) && mmExtruded > 0)
+        {
+            _logger.LogInformation(
+                "Printer {PrinterName} reports {MmExtruded}mm filament extruded in latest job",
+                printer.Name, mmExtruded);
+        }
+    }
+}

backend/Infrastructure/Services/MoonrakerClient.cs

@@ -0,0 +1,130 @@
+using System.Net.Http.Json;
+using System.Text.Json;
+using Extrudex.Domain.Interfaces;
+using Microsoft.Extensions.Logging;
+using Microsoft.Extensions.Options;
+
+namespace Extrudex.Infrastructure.Configuration;
+
+/// <summary>
+/// HTTP client for communicating with Moonraker REST API endpoints
+/// on Klipper-based printers (e.g., Elegoo Centauri Carbon).
+/// Retrieves filament usage data and printer status information.
+/// </summary>
+public class MoonrakerClient : IMoonrakerClient
+{
+    private readonly HttpClient _httpClient;
+    private readonly ILogger<MoonrakerClient> _logger;
+
+    /// <summary>
+    /// Creates a new MoonrakerClient with the configured HTTP client and logger.
+    /// </summary>
+    /// <param name="httpClient">The HTTP client for making requests to Moonraker endpoints.</param>
+    /// <param name="logger">Logger for diagnostic output.</param>
+    public MoonrakerClient(HttpClient httpClient, ILogger<MoonrakerClient> logger)
+    {
+        _httpClient = httpClient;
+        _logger = logger;
+    }
+
+    /// <inheritdoc />
+    public async Task<Dictionary<string, decimal>> GetFilamentUsageAsync(
+        string hostnameOrIp,
+        int port,
+        string? apiKey,
+        CancellationToken cancellationToken = default)
+    {
+        var baseUrl = BuildBaseUrl(hostnameOrIp, port);
+        var result = new Dictionary<string, decimal>();
+
+        try
+        {
+            // Query Moonraker server info endpoint for filament usage data
+            using var request = new HttpRequestMessage(HttpMethod.Get, $"{baseUrl}/server/history/items?limit=1");
+            if (!string.IsNullOrEmpty(apiKey))
+            {
+                request.Headers.Add("X-Api-Key", apiKey);
+            }
+
+            using var response = await _httpClient.SendAsync(request, cancellationToken);
+            response.EnsureSuccessStatusCode();
+
+            var json = await response.Content.ReadFromJsonAsync<JsonElement>(cancellationToken: cancellationToken);
+
+            // Extract filament usage from the response
+            // Moonraker returns job history with filament_used and similar fields
+            if (json.TryGetProperty("result", out var resultElement))
+            {
+                if (resultElement.TryGetProperty("items", out var items) && items.GetArrayLength() > 0)
+                {
+                    var job = items[0];
+
+                    // Moonraker tracks filament_used in millimeters
+                    if (job.TryGetProperty("filament_used", out var filamentUsed))
+                    {
+                        result["mm_extruded"] = filamentUsed.GetDecimal();
+                    }
+
+                    // Total duration in seconds
+                    if (job.TryGetProperty("print_duration", out var duration))
+                    {
+                        result["print_duration_seconds"] = duration.GetDecimal();
+                    }
+                }
+            }
+
+            _logger.LogDebug(
+                "Retrieved filament usage from Moonraker at {Host}:{Port}: {MetricCount} metrics",
+                hostnameOrIp, port, result.Count);
+        }
+        catch (HttpRequestException ex)
+        {
+            _logger.LogWarning(ex,
+                "Failed to retrieve filament usage from Moonraker at {Host}:{Port}",
+                hostnameOrIp, port);
+        }
+        catch (JsonException ex)
+        {
+            _logger.LogWarning(ex,
+                "Failed to parse Moonraker response from {Host}:{Port}",
+                hostnameOrIp, port);
+        }
+
+        return result;
+    }
+
+    /// <inheritdoc />
+    public async Task<bool> IsReachableAsync(
+        string hostnameOrIp,
+        int port,
+        string? apiKey,
+        CancellationToken cancellationToken = default)
+    {
+        var baseUrl = BuildBaseUrl(hostnameOrIp, port);
+
+        try
+        {
+            using var request = new HttpRequestMessage(HttpMethod.Get, $"{baseUrl}/server/info");
+            if (!string.IsNullOrEmpty(apiKey))
+            {
+                request.Headers.Add("X-Api-Key", apiKey);
+            }
+
+            using var response = await _httpClient.SendAsync(request, cancellationToken);
+            return response.IsSuccessStatusCode;
+        }
+        catch (HttpRequestException)
+        {
+            _logger.LogDebug("Moonraker at {Host}:{Port} is not reachable", hostnameOrIp, port);
+            return false;
+        }
+    }
+
+    /// <summary>
+    /// Builds the base URL for Moonraker API calls from hostname and port.
+    /// </summary>
+    private static string BuildBaseUrl(string hostnameOrIp, int port)
+    {
+        return $"http://{hostnameOrIp}:{port}";
+    }
+}

backend/Program.cs

@@ -1,7 +1,9 @@
 using System.Reflection;
 using Extrudex.API.Filters;
 using Extrudex.API.Hubs;
+using Extrudex.API.Jobs;
 using Extrudex.Domain.Interfaces;
+using Extrudex.Infrastructure.Configuration;
 using Extrudex.Infrastructure.Data;
 using Extrudex.Infrastructure.Services;
 using FluentValidation;
@@ -77,6 +79,16 @@ builder.Services.AddCors(options =>
 // ── SignalR (real-time printer updates) ────────────────────
 builder.Services.AddSignalR();
 
+// ── Filament Usage Sync (Background Job) ──────────────────
+builder.Services.Configure<FilamentUsageSyncOptions>(
+    builder.Configuration.GetSection(FilamentUsageSyncOptions.SectionName));
+builder.Services.AddHttpClient<IMoonrakerClient, MoonrakerClient>(client =>
+{
+    client.DefaultRequestHeaders.Add("User-Agent", "Extrudex/1.0");
+});
+builder.Services.AddScoped<IFilamentUsageSyncService, FilamentUsageSyncService>();
+builder.Services.AddHostedService<FilamentUsageSyncJob>();
+
 // ── Health Checks ───────────────────────────────────────────
 builder.Services.AddHealthChecks()
     .AddNpgSql(connectionString);

backend/appsettings.Development.json

@@ -8,5 +8,10 @@
   },
   "ConnectionStrings": {
     "ExtrudexDb": "Host=localhost;Port=5432;Database=extrudex_dev;Username=extrudex;Password=changeme"
+  },
+  "FilamentUsageSync": {
+    "PollingInterval": "00:01:00",
+    "RequestTimeout": "00:00:30",
+    "Enabled": true
   }
 }

backend/appsettings.json

@@ -9,5 +9,10 @@
   "AllowedHosts": "*",
   "ConnectionStrings": {
     "ExtrudexDb": "Host=localhost;Port=5432;Database=extrudex;Username=extrudex;Password=changeme"
+  },
+  "FilamentUsageSync": {
+    "PollingInterval": "00:05:00",
+    "RequestTimeout": "00:00:30",
+    "Enabled": true
   }
 }

frontend/.dockerignore

@@ -1,11 +0,0 @@
-node_modules
-dist
-.git
-.gitignore
-.angular
-.vscode
-*.md
-.editorconfig
-.prettierrc
-src/test.ts
-**/*.spec.ts

frontend/Dockerfile

@@ -1,28 +0,0 @@
-# Stage 1: Build the Angular application
-FROM node:22-alpine AS build
-
-WORKDIR /app
-
-# Copy package files first for better layer caching
-COPY package.json package-lock.json ./
-RUN npm ci
-
-# Copy source and build
-COPY . .
-RUN npx ng build --configuration production
-
-# Stage 2: Serve static files with nginx
-FROM nginx:alpine
-
-# Remove default nginx config
-RUN rm /etc/nginx/conf.d/default.conf
-
-# Copy custom nginx config
-COPY nginx.conf /etc/nginx/conf.d/default.conf
-
-# Copy built Angular artifacts from build stage
-COPY --from=build /app/dist/frontend/browser /usr/share/nginx/html
-
-EXPOSE 80
-
-CMD ["nginx", "-g", "daemon off;"]

frontend/nginx.conf

@@ -1,42 +0,0 @@
-server {
-    listen 80;
-    server_name _;
-    root /usr/share/nginx/html;
-    index index.html;
-
-    # Gzip compression
-    gzip on;
-    gzip_types text/plain text/css application/json application/javascript text/xml application/xml text/javascript;
-    gzip_min_length 256;
-
-    # Angular SPA — fallback to index.html for client-side routing
-    location / {
-        try_files $uri $uri/ /index.html;
-    }
-
-    # Cache static assets aggressively
-    location ~* \.(js|css|png|jpg|jpeg|gif|ico|svg|woff2?|ttf|eot)$ {
-        expires 1y;
-        add_header Cache-Control "public, immutable";
-    }
-
-    # Proxy API requests to backend
-    # Uses resolver so nginx doesn't crash if backend isn't available at startup
-    resolver 127.0.0.11 valid=30s ipv6=off;
-    set $backend "extrudex-api:8080";
-
-    location /api/ {
-        proxy_pass http://$backend;
-        proxy_set_header Host $host;
-        proxy_set_header X-Real-IP $remote_addr;
-        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
-        proxy_set_header X-Forwarded-Proto $scheme;
-    }
-
-    # Health check endpoint
-    location /health {
-        access_log off;
-        return 200 "ok";
-        add_header Content-Type text/plain;
-    }
-}

frontend/package-lock.json

@@ -8,7 +8,6 @@
       "name": "frontend",
       "version": "0.0.0",
       "dependencies": {
-        "@angular/animations": "^21.2.10",
         "@angular/cdk": "^21.2.8",
         "@angular/common": "^21.2.0",
         "@angular/compiler": "^21.2.0",
@@ -327,21 +326,6 @@
         "yarn": ">= 1.13.0"
       }
     },
-    "node_modules/@angular/animations": {
-      "version": "21.2.10",
-      "resolved": "https://registry.npmjs.org/@angular/animations/-/animations-21.2.10.tgz",
-      "integrity": "sha512-sIzAcxwtRCJ/fu0tK4mo1ooiEaDxJ+Nl6s9nK1D1NP1em12VX03Jx8CMixp/kVtgh4mZnm1x6psBB0FUz3U3Ug==",
-      "license": "MIT",
-      "dependencies": {
-        "tslib": "^2.3.0"
-      },
-      "engines": {
-        "node": "^20.19.0 || ^22.12.0 || >=24.0.0"
-      },
-      "peerDependencies": {
-        "@angular/core": "21.2.10"
-      }
-    },
     "node_modules/@angular/build": {
       "version": "21.2.8",
       "resolved": "https://registry.npmjs.org/@angular/build/-/build-21.2.8.tgz",

frontend/package.json

@@ -11,7 +11,6 @@
   "private": true,
   "packageManager": "npm@11.11.0",
   "dependencies": {
-    "@angular/animations": "^21.2.10",
     "@angular/cdk": "^21.2.8",
     "@angular/common": "^21.2.0",
     "@angular/compiler": "^21.2.0",

frontend/src/app/app.config.ts

@@ -1,15 +1,11 @@
 import { ApplicationConfig, provideBrowserGlobalErrorListeners } from '@angular/core';
 import { provideRouter } from '@angular/router';
-import { provideHttpClient, withFetch } from '@angular/common/http';
-import { provideAnimationsAsync } from '@angular/platform-browser/animations/async';
 
 import { routes } from './app.routes';
 
 export const appConfig: ApplicationConfig = {
   providers: [
     provideBrowserGlobalErrorListeners(),
-    provideRouter(routes),
-    provideHttpClient(withFetch()),
-    provideAnimationsAsync(),
+    provideRouter(routes)
   ]
-};
+};

frontend/src/app/components/delete-filament-dialog/delete-filament-dialog.component.html

@@ -1,78 +0,0 @@
-<!-- Delete Filament Confirmation Dialog -->
-<h2 mat-dialog-title>
-  <mat-icon aria-hidden="true">warning</mat-icon>
-  Delete Filament Spool?
-</h2>
-
-<mat-dialog-content>
-  <p class="dialog-description">
-    You are about to permanently remove this filament spool from inventory.
-  </p>
-
-  <!-- Spool details card -->
-  <div class="spool-details" role="list" aria-label="Spool details">
-    <div class="detail-row" role="listitem">
-      <span class="detail-label">Material</span>
-      <span class="detail-value">{{ filament.materialBaseName }}{{ filament.materialFinishName ? ' — ' + filament.materialFinishName : '' }}{{ filament.materialModifierName ? ' (' + filament.materialModifierName + ')' : '' }}</span>
-    </div>
-
-    <div class="detail-row" role="listitem">
-      <span class="detail-label">Brand</span>
-      <span class="detail-value">{{ filament.brand }}</span>
-    </div>
-
-    <div class="detail-row" role="listitem">
-      <span class="detail-label">Color</span>
-      <span class="detail-value color-value">
-        <span class="color-swatch-inline"
-              [style.background-color]="filament.colorHex"
-              [attr.aria-label]="filament.colorName">
-        </span>
-        {{ filament.colorName }}
-      </span>
-    </div>
-
-    <div class="detail-row" role="listitem">
-      <span class="detail-label">Serial</span>
-      <span class="detail-value serial-value">{{ filament.spoolSerial }}</span>
-    </div>
-
-    <div class="detail-row" role="listitem">
-      <span class="detail-label">Remaining</span>
-      <span class="detail-value">{{ formatWeight(filament.weightRemainingGrams) }} / {{ formatWeight(filament.weightTotalGrams) }}</span>
-    </div>
-
-    <div class="detail-row" role="listitem">
-      <span class="detail-label">Status</span>
-      <span class="detail-value">
-        <span class="status-badge"
-              [class.active]="filament.isActive"
-              [class.inactive]="!filament.isActive">
-          {{ filament.isActive ? 'Active' : 'Inactive' }}
-        </span>
-      </span>
-    </div>
-  </div>
-
-  <p class="dialog-warning">
-    <mat-icon aria-hidden="true">info</mat-icon>
-    This action cannot be undone.
-  </p>
-</mat-dialog-content>
-
-<mat-dialog-actions align="end">
-  <button mat-button
-          type="button"
-          (click)="onCancel()"
-          class="cancel-button">
-    Cancel
-  </button>
-  <button mat-flat-button
-          type="button"
-          color="warn"
-          (click)="onConfirm()"
-          class="confirm-button">
-    <mat-icon aria-hidden="true">delete</mat-icon>
-    Delete Spool
-  </button>
-</mat-dialog-actions>

frontend/src/app/components/delete-filament-dialog/delete-filament-dialog.component.scss

@@ -1,150 +0,0 @@
-/**
- * Delete Filament Dialog Styles
- * Touch-optimized confirmation dialog for spool removal
- */
-
-$spacing-unit: 8px;
-$color-critical: #ef4444;
-$color-inactive: #94a3b8;
-$color-active: #22c55e;
-
-// Dialog title
-h2[mat-dialog-title] {
-  display: flex;
-  align-items: center;
-  gap: $spacing-unit;
-  color: $color-critical;
-
-  mat-icon {
-    font-size: 24px !important;
-    width: 24px !important;
-    height: 24px !important;
-  }
-}
-
-// Description text
-.dialog-description {
-  margin: 0 0 $spacing-unit * 2;
-  font-size: 14px;
-  line-height: 1.5;
-  color: var(--mat-sys-on-surface);
-}
-
-// Spool details card
-.spool-details {
-  display: flex;
-  flex-direction: column;
-  gap: $spacing-unit;
-  padding: $spacing-unit * 1.5;
-  background-color: var(--mat-sys-surface-container);
-  border-radius: 8px;
-  margin-bottom: $spacing-unit * 2;
-}
-
-.detail-row {
-  display: flex;
-  justify-content: space-between;
-  align-items: center;
-  padding: $spacing-unit * 0.5 0;
-  font-size: 14px;
-
-  &:not(:last-child) {
-    border-bottom: 1px solid var(--mat-sys-outline-variant);
-    padding-bottom: $spacing-unit;
-  }
-}
-
-.detail-label {
-  font-weight: 500;
-  color: var(--mat-sys-on-surface-variant);
-  flex-shrink: 0;
-}
-
-.detail-value {
-  font-weight: 400;
-  color: var(--mat-sys-on-surface);
-  text-align: right;
-}
-
-// Color swatch inline
-.color-swatch-inline {
-  display: inline-block;
-  width: 18px;
-  height: 18px;
-  border-radius: 50%;
-  border: 1.5px solid rgba(0, 0, 0, 0.12);
-  vertical-align: middle;
-  margin-right: 4px;
-}
-
-.color-value {
-  display: flex;
-  align-items: center;
-  justify-content: flex-end;
-  gap: 4px;
-}
-
-// Serial value — monospace
-.serial-value {
-  font-family: 'JetBrains Mono', 'Roboto Mono', monospace;
-  font-size: 13px;
-  letter-spacing: 0.02em;
-}
-
-// Status badge — matches filament table styling
-.status-badge {
-  display: inline-flex;
-  align-items: center;
-  padding: 2px 8px;
-  border-radius: 10px;
-  font-size: 11px;
-  font-weight: 600;
-  text-transform: uppercase;
-  letter-spacing: 0.04em;
-
-  &.active {
-    background-color: rgba($color-active, 0.12);
-    color: $color-active;
-  }
-
-  &.inactive {
-    background-color: rgba($color-inactive, 0.12);
-    color: $color-inactive;
-  }
-}
-
-// Warning text
-.dialog-warning {
-  display: flex;
-  align-items: center;
-  gap: $spacing-unit;
-  margin: 0;
-  font-size: 13px;
-  color: $color-critical;
-
-  mat-icon {
-    font-size: 18px !important;
-    width: 18px !important;
-    height: 18px !important;
-  }
-}
-
-// Dialog action buttons
-mat-dialog-actions {
-  padding-top: $spacing-unit * 2;
-
-  .cancel-button {
-    min-width: 80px;
-  }
-
-  .confirm-button {
-    min-width: 120px;
-
-    mat-icon {
-      font-size: 18px !important;
-      width: 18px !important;
-      height: 18px !important;
-      margin-right: 4px;
-    }
-  }
-}

frontend/src/app/components/delete-filament-dialog/delete-filament-dialog.component.ts

@@ -1,68 +0,0 @@
-import { ChangeDetectionStrategy, Component, inject } from '@angular/core';
-import { CommonModule } from '@angular/common';
-import {
-  MAT_DIALOG_DATA,
-  MatDialogRef,
-  MatDialogModule,
-} from '@angular/material/dialog';
-import { MatButtonModule } from '@angular/material/button';
-import { MatIconModule } from '@angular/material/icon';
-import { MatChipsModule } from '@angular/material/chips';
-
-import { Filament } from '../../models/filament.model';
-
-/**
- * Data passed into the delete confirmation dialog.
- */
-export interface DeleteFilamentDialogData {
-  filament: Filament;
-}
-
-/**
- * Delete confirmation dialog for filament spool removal.
- *
- * Displays spool details (material, brand, color, serial, remaining weight)
- * and requires the user to confirm before deletion proceeds.
- * Cancel dismisses the dialog with no action.
- */
-@Component({
-  selector: 'app-delete-filament-dialog',
-  standalone: true,
-  imports: [
-    CommonModule,
-    MatDialogModule,
-    MatButtonModule,
-    MatIconModule,
-    MatChipsModule,
-  ],
-  templateUrl: './delete-filament-dialog.component.html',
-  styleUrl: './delete-filament-dialog.component.scss',
-  changeDetection: ChangeDetectionStrategy.OnPush,
-})
-export class DeleteFilamentDialogComponent {
-  private readonly dialogRef = inject(
-    MatDialogRef<DeleteFilamentDialogComponent, boolean>
-  );
-  readonly data: DeleteFilamentDialogData = inject(MAT_DIALOG_DATA);
-
-  /** The filament spool being considered for deletion */
-  readonly filament = this.data.filament;
-
-  /** Format weight for display in dialog */
-  formatWeight(grams: number): string {
-    if (grams >= 1000) {
-      return `${(grams / 1000).toFixed(1)}kg`;
-    }
-    return `${Math.round(grams)}g`;
-  }
-
-  /** Cancel — close dialog with false (no deletion) */
-  onCancel(): void {
-    this.dialogRef.close(false);
-  }
-
-  /** Confirm — close dialog with true (proceed with deletion) */
-  onConfirm(): void {
-    this.dialogRef.close(true);
-  }
-}

frontend/src/app/components/filament-table/filament-table.component.html

@@ -1,4 +1,4 @@
-<!-- Filament Inventory Table — with low stock indicators and delete actions -->
+<!-- Filament Inventory Table — with low stock indicators -->
 <div class="filament-table-container" role="region" aria-label="Filament inventory">
 
   <!-- Low Stock Alert Banner — shown when critical or low stock spools exist -->
@@ -106,32 +106,10 @@
       </td>
     </ng-container>
 
-    <!-- Actions Column — delete button -->
-    <ng-container matColumnDef="actions">
-      <th mat-header-cell *matHeaderCellDef>Actions</th>
-      <td mat-cell *matCellDef="let filament">
-        <button mat-icon-button
-                type="button"
-                color="warn"
-                [attr.aria-label]="'Delete ' + filament.materialBaseName + ' — ' + filament.colorName"
-                matTooltip="Delete spool"
-                matTooltipPosition="above"
-                [disabled]="deleting() === filament.id"
-                (click)="onDeleteClick(filament)">
-          @if (deleting() === filament.id) {
-            <mat-icon aria-hidden="true">hourglass_empty</mat-icon>
-          } @else {
-            <mat-icon aria-hidden="true">delete</mat-icon>
-          }
-        </button>
-      </td>
-    </ng-container>
-
     <tr mat-header-row *matHeaderRowDef="columns()"></tr>
     <tr mat-row *matRowDef="let row; columns: columns();"
         [class.row-critical]="classifyStockLevel(row) === 'critical'"
-        [class.row-low]="classifyStockLevel(row) === 'low'"
-        [class.row-deleting]="deleting() === row.id">
+        [class.row-low]="classifyStockLevel(row) === 'low'">
     </tr>
   </table>
 

frontend/src/app/components/filament-table/filament-table.component.scss

@@ -235,20 +235,6 @@ mat-chip {
   }
 }
 
-// Actions column
-.actions-cell {
-  display: flex;
-  align-items: center;
-  justify-content: center;
-}
-
-// Row being deleted — subtle fade
-:host ::ng-deep .row-deleting {
-  opacity: 0.5;
-  pointer-events: none;
-  transition: opacity 0.3s ease;
-}
-
 // Empty state
 .empty-state {
   display: flex;

frontend/src/app/components/filament-table/filament-table.component.ts

@@ -3,7 +3,6 @@ import {
   Component,
   Input,
   computed,
-  inject,
   signal,
 } from '@angular/core';
 import { CommonModule } from '@angular/common';
@@ -13,21 +12,12 @@ import { MatIconModule } from '@angular/material/icon';
 import { MatProgressBarModule } from '@angular/material/progress-bar';
 import { MatTooltipModule } from '@angular/material/tooltip';
 import { MatSortModule, Sort } from '@angular/material/sort';
-import { MatButtonModule } from '@angular/material/button';
-import { MatDialog, MatDialogModule } from '@angular/material/dialog';
-import { MatSnackBar, MatSnackBarModule } from '@angular/material/snack-bar';
-
 import {
   Filament,
   StockLevel,
   getRemainingPercent,
   classifyStockLevel,
 } from '../../models/filament.model';
-import { FilamentService } from '../../services/filament.service';
-import {
-  DeleteFilamentDialogComponent,
-  DeleteFilamentDialogData,
-} from '../delete-filament-dialog/delete-filament-dialog.component';
 
 /** Display column definitions for the filament table */
 export type FilamentColumn =
@@ -37,8 +27,7 @@ export type FilamentColumn =
   | 'serial'
   | 'remaining'
   | 'stockLevel'
-  | 'status'
-  | 'actions';
+  | 'status';
 
 @Component({
   selector: 'app-filament-table',
@@ -51,26 +40,16 @@ export type FilamentColumn =
     MatProgressBarModule,
     MatTooltipModule,
     MatSortModule,
-    MatButtonModule,
-    MatDialogModule,
-    MatSnackBarModule,
   ],
   templateUrl: './filament-table.component.html',
   styleUrl: './filament-table.component.scss',
   changeDetection: ChangeDetectionStrategy.OnPush,
 })
 export class FilamentTableComponent {
-  private readonly dialog = inject(MatDialog);
-  private readonly snackBar = inject(MatSnackBar);
-  private readonly filamentService = inject(FilamentService);
-
   /** Filament data input — reactive signal for live updates */
   readonly filaments = signal<Filament[]>([]);
 
-  /** Whether a delete operation is in progress */
-  readonly deleting = signal<string | null>(null);
-
-  /** Columns to display — defaults to all columns including actions */
+  /** Columns to display — defaults to all columns */
   @Input()
   set displayedColumns(cols: FilamentColumn[]) {
     this._displayedColumns.set(cols);
@@ -86,7 +65,6 @@ export class FilamentTableComponent {
     'remaining',
     'stockLevel',
     'status',
-    'actions',
   ]);
 
   /** Default columns for template binding */
@@ -274,52 +252,6 @@ export class FilamentTableComponent {
     this.sortedFilaments.set(sorted);
   }
 
-  /**
-   * Open the delete confirmation dialog for a filament spool.
-   * On confirm: calls DELETE endpoint and removes the row on success.
-   * On cancel: dialog dismissed, no action taken.
-   */
-  onDeleteClick(filament: Filament): void {
-    const dialogData: DeleteFilamentDialogData = { filament };
-    const dialogRef = this.dialog.open(DeleteFilamentDialogComponent, {
-      data: dialogData,
-      width: '480px',
-      disableClose: true,
-    });
-
-    dialogRef.afterClosed().subscribe((confirmed: boolean | undefined) => {
-      if (!confirmed) {
-        return; // User cancelled — no action
-      }
-
-      // Mark as deleting for UI feedback
-      this.deleting.set(filament.id);
-
-      this.filamentService.deleteFilament(filament.id).subscribe({
-        next: () => {
-          // Remove the deleted filament from local data
-          const updated = this.filaments().filter((f) => f.id !== filament.id);
-          this.updateFilaments(updated);
-          this.deleting.set(null);
-
-          this.snackBar.open(
-            `Deleted ${filament.materialBaseName} — ${filament.colorName}`,
-            'Dismiss',
-            { duration: 4000 }
-          );
-        },
-        error: () => {
-          this.deleting.set(null);
-          this.snackBar.open(
-            `Failed to delete ${filament.materialBaseName} — ${filament.colorName}. Please try again.`,
-            'Dismiss',
-            { duration: 6000 }
-          );
-        },
-      });
-    });
-  }
-
   /** Template helper: get remaining percent */
   getRemainingPercent = getRemainingPercent;
 

frontend/src/app/services/filament.service.ts

@@ -1,37 +0,0 @@
-import { Injectable, inject } from '@angular/core';
-import { HttpClient } from '@angular/common/http';
-import { Observable } from 'rxjs';
-
-import { Filament } from '../models/filament.model';
-
-/**
- * API base URL — matches the Extrudex backend default.
- * TODO: Move to environment config when multi-environment support is added.
- */
-const API_BASE_URL = '/api';
-
-/**
- * Service for CRUD operations on filament spools.
- * Communicates with the Extrudex backend SpoolsController.
- */
-@Injectable({ providedIn: 'root' })
-export class FilamentService {
-  private readonly http = inject(HttpClient);
-
-  /**
-   * Fetch all filament spools from the backend.
-   * GET /api/spools
-   */
-  getFilaments(): Observable<Filament[]> {
-    return this.http.get<Filament[]>(`${API_BASE_URL}/spools`);
-  }
-
-  /**
-   * Soft-delete a filament spool by ID.
-   * DELETE /api/spools/{id}
-   * Returns 204 No Content on success.
-   */
-  deleteFilament(id: string): Observable<void> {
-    return this.http.delete<void>(`${API_BASE_URL}/spools/${id}`);
-  }
-}