Skip to content

Next Gen STEP AP242 Native-ish BREP Geometric Modeling Kernel

5.6 KB
Raw Blame
using Microsoft.EntityFrameworkCore;

namespace Aetheris.Samples.DatabaseDrivenCad;

public sealed class Material
{
    public int Id { get; set; }
    public required string Name { get; set; }
    public required string Grade { get; set; }
    public bool IsAluminum { get; set; }
    public ICollection<BearingBlockConfiguration> Configurations { get; } = [];
}

public sealed class DrawingMetadata
{
    public int Id { get; set; }
    public required string Company { get; set; }
    public required string Author { get; set; }
    public required string Description { get; set; }
    public ICollection<BearingBlockConfiguration> Configurations { get; } = [];
}

public sealed class BearingBlockConfiguration
{
    public int Id { get; set; }
    public required string PartNumber { get; set; }
    public double WidthMillimeters { get; set; }
    public double HeightMillimeters { get; set; }
    public double DepthMillimeters { get; set; }
    public double BoreDiameterMillimeters { get; set; }
    public double BoreTolerancePlusMillimeters { get; set; }
    public double BoreToleranceMinusMillimeters { get; set; }
    public int RevisionMajor { get; set; }
    public int RevisionMinor { get; set; }
    public int RevisionPatch { get; set; }
    public bool IsProduction { get; set; }
    public bool IsCurrent { get; set; }
    public int MaterialId { get; set; }
    public required Material Material { get; set; }
    public int DrawingMetadataId { get; set; }
    public required DrawingMetadata DrawingMetadata { get; set; }
}

public sealed class ProductCatalogContext(DbContextOptions<ProductCatalogContext> options) : DbContext(options)
{
    public DbSet<Material> Materials => Set<Material>();
    public DbSet<DrawingMetadata> DrawingMetadata => Set<DrawingMetadata>();
    public DbSet<BearingBlockConfiguration> BearingBlockConfigurations => Set<BearingBlockConfiguration>();

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        modelBuilder.Entity<Material>().HasIndex(item => item.Grade).IsUnique();
        modelBuilder.Entity<BearingBlockConfiguration>().HasIndex(item => item.PartNumber).IsUnique();
        modelBuilder.Entity<BearingBlockConfiguration>()
            .HasOne(item => item.Material).WithMany(item => item.Configurations).HasForeignKey(item => item.MaterialId);
        modelBuilder.Entity<BearingBlockConfiguration>()
            .HasOne(item => item.DrawingMetadata).WithMany(item => item.Configurations).HasForeignKey(item => item.DrawingMetadataId);
    }
}

public static class ProductCatalog
{
    public static ProductCatalogContext Open(string databasePath)
    {
        var fullPath = Path.GetFullPath(databasePath);
        Directory.CreateDirectory(Path.GetDirectoryName(fullPath)!);
        var options = new DbContextOptionsBuilder<ProductCatalogContext>()
            .UseSqlite($"Data Source={fullPath};Pooling=False")
            .Options;
        return new ProductCatalogContext(options);
    }

    public static async Task SeedAsync(ProductCatalogContext database, CancellationToken cancellationToken = default)
    {
        await database.Database.EnsureDeletedAsync(cancellationToken);
        await database.Database.EnsureCreatedAsync(cancellationToken);

        var aluminum = new Material { Name = "Aluminium 6061-T6", Grade = "6061-T6", IsAluminum = true };
        var steel = new Material { Name = "Alloy steel 4140", Grade = "4140", IsAluminum = false };
        var drawing = new DrawingMetadata { Company = "Aster Works", Author = "CAD Automation", Description = "Production bearing block" };
        database.AddRange(aluminum, steel, drawing);
        database.BearingBlockConfigurations.AddRange(
            Config("AB-101", 80, 50, 12, 18, aluminum, drawing, 1, 0, 0, true, true),
            Config("AB-204", 100, 60, 16, 24, aluminum, drawing, 2, 1, 0, true, true),
            Config("AB-305", 120, 70, 20, 30, aluminum, drawing, 3, 0, 1, true, true),
            Config("SB-210", 100, 60, 18, 22, steel, drawing, 2, 0, 0, true, false));
        await database.SaveChangesAsync(cancellationToken);
    }

    public static IQueryable<BearingBlockConfiguration> WithRelations(ProductCatalogContext database) =>
        database.BearingBlockConfigurations.AsNoTracking().Include(item => item.Material).Include(item => item.DrawingMetadata);

    public static IQueryable<BearingBlockConfiguration> ProductionAluminum(ProductCatalogContext database, double minimumBoreMillimeters = 20) =>
        WithRelations(database)
            .Where(item => item.IsProduction && item.Material.IsAluminum && item.BoreDiameterMillimeters >= minimumBoreMillimeters)
            .OrderBy(item => item.BoreDiameterMillimeters).ThenBy(item => item.PartNumber);

    public static IQueryable<BearingBlockConfiguration> CurrentMajor(ProductCatalogContext database, int major) =>
        WithRelations(database).Where(item => item.IsCurrent && item.RevisionMajor == major).OrderBy(item => item.PartNumber);

    private static BearingBlockConfiguration Config(
        string partNumber, double width, double height, double depth, double bore,
        Material material, DrawingMetadata drawing, int major, int minor, int patch, bool production, bool current) => new()
    {
        PartNumber = partNumber,
        WidthMillimeters = width,
        HeightMillimeters = height,
        DepthMillimeters = depth,
        BoreDiameterMillimeters = bore,
        BoreTolerancePlusMillimeters = 0.05,
        BoreToleranceMinusMillimeters = 0.02,
        Material = material,
        DrawingMetadata = drawing,
        RevisionMajor = major,
        RevisionMinor = minor,
        RevisionPatch = patch,
        IsProduction = production,
        IsCurrent = current,
    };
}