| | | 1 | | using Microsoft.EntityFrameworkCore; |
| | | 2 | | using Microsoft.EntityFrameworkCore.Metadata.Builders; |
| | | 3 | | using MechanicsSoftware.Domain.Entities; |
| | | 4 | | using MechanicsSoftware.Domain.ValueObjects; |
| | | 5 | | using MechanicsSoftware.Domain.Enums; |
| | | 6 | | using MechanicsSoftware.Domain.Exceptions; |
| | | 7 | | |
| | | 8 | | namespace MechanicsSoftware.Infrastructure.Persistence.Configurations; |
| | | 9 | | |
| | | 10 | | public sealed class PartConfiguration : IEntityTypeConfiguration<Part> |
| | 1 | 11 | | { |
| | 1 | 12 | | public void Configure(EntityTypeBuilder<Part> builder) |
| | 2 | 13 | | { |
| | 3 | 14 | | builder.ToTable("parts"); |
| | 1 | 15 | | |
| | 2 | 16 | | builder.HasKey(p => p.Id); |
| | 3 | 17 | | builder.Property(p => p.Id).HasColumnName("id"); |
| | 1 | 18 | | |
| | 3 | 19 | | builder.Property(p => p.Code) |
| | 3 | 20 | | .HasColumnName("code") |
| | 2 | 21 | | .HasMaxLength(50) |
| | 3 | 22 | | .IsRequired(); |
| | 1 | 23 | | |
| | 3 | 24 | | builder.Property(p => p.Name) |
| | 3 | 25 | | .HasColumnName("name") |
| | 2 | 26 | | .HasMaxLength(100) |
| | 3 | 27 | | .IsRequired(); |
| | 1 | 28 | | |
| | 3 | 29 | | builder.Property(p => p.Description) |
| | 2 | 30 | | .HasColumnName("description") |
| | 3 | 31 | | .HasMaxLength(500); |
| | 1 | 32 | | |
| | 3 | 33 | | builder.Property(p => p.UnitPrice) |
| | 3 | 34 | | .HasConversion( |
| | 3 | 35 | | m => m.Cents, |
| | 3 | 36 | | m => new Money(m)) |
| | 2 | 37 | | .HasColumnName("unit_price") |
| | 3 | 38 | | .IsRequired(); |
| | 1 | 39 | | |
| | 3 | 40 | | builder.Property(p => p.StockQuantity) |
| | 2 | 41 | | .HasColumnName("stock_quantity") |
| | 3 | 42 | | .IsRequired(); |
| | 1 | 43 | | |
| | 3 | 44 | | builder.Property(p => p.ReservedQuantity) |
| | 2 | 45 | | .HasColumnName("reserved_quantity") |
| | 3 | 46 | | .IsRequired(); |
| | | 47 | | |
| | 3 | 48 | | builder.Ignore(p => p.AvailableQuantity); |
| | 1 | 49 | | |
| | 3 | 50 | | builder.HasIndex(p => p.Code) |
| | 2 | 51 | | .IsUnique() |
| | 3 | 52 | | .HasDatabaseName("ix_parts_code"); |
| | 1 | 53 | | |
| | 3 | 54 | | builder.Navigation(p => p.Movements) |
| | 3 | 55 | | .HasField("_movements") |
| | 3 | 56 | | .UsePropertyAccessMode(PropertyAccessMode.Field); |
| | 1 | 57 | | |
| | 3 | 58 | | builder.OwnsMany(p => p.Movements, sm => |
| | 3 | 59 | | { |
| | 3 | 60 | | sm.ToTable("stock_movements"); |
| | 3 | 61 | | sm.HasKey(s => s.Id); |
| | 3 | 62 | | sm.Property(s => s.Id) |
| | 3 | 63 | | .HasColumnName("id") |
| | 3 | 64 | | .ValueGeneratedNever(); |
| | 3 | 65 | | sm.WithOwner().HasForeignKey(s => s.PartId); |
| | 3 | 66 | | sm.Property(s => s.PartId).HasColumnName("part_id"); |
| | 3 | 67 | | sm.HasIndex(s => s.PartId).HasDatabaseName("ix_stock_movements_part_id"); |
| | 3 | 68 | | sm.Property(s => s.Type) |
| | 2 | 69 | | .HasColumnName("type") |
| | 2 | 70 | | .HasConversion<string>() |
| | 2 | 71 | | .IsRequired(); |
| | 2 | 72 | | sm.Property(s => s.Quantity).HasColumnName("quantity").IsRequired(); |
| | 2 | 73 | | sm.Property(s => s.Reference).HasColumnName("reference"); |
| | 2 | 74 | | sm.Property(s => s.CreatedAt).HasColumnName("created_at").IsRequired(); |
| | 2 | 75 | | }); |
| | 2 | 76 | | } |
| | | 77 | | } |