57 lines
2.1 KiB
C#
57 lines
2.1 KiB
C#
namespace PostFundManagement.Domain.Configuration.Entities;
|
|
|
|
public sealed class Award : IEntityTypeConfiguration<Domain.Entities.Award>
|
|
{
|
|
public void Configure(EntityTypeBuilder<Domain.Entities.Award> builder)
|
|
{
|
|
builder.ToTable(nameof(Domain.Entities.Award).Pluralize());
|
|
|
|
builder.HasKey(pk => pk.Id);
|
|
builder.Property(f => f.OrganisationId).IsRequired();
|
|
builder.Property(f => f.ProgrammeId).IsRequired();
|
|
builder.Property(f => f.ProjectId).IsRequired(false);
|
|
builder.Property(f => f.CreatedBy).IsRequired();
|
|
builder.Property(f => f.UpdatedBy).IsRequired(false);
|
|
builder.Property(f => f.ApprovedBy).IsRequired(false);
|
|
builder.Property(f => f.CreatedAt).IsRequired().HasDefaultValueSql("now()");
|
|
builder.Property(f => f.UpdatedAt).IsRequired(false);
|
|
builder.Property(f => f.Status).IsRequired().HasConversion<int>().HasDefaultValueSql("1");
|
|
builder.Property(f => f.Amount).IsRequired().HasPrecision(18, 2);
|
|
|
|
builder.HasOne(f => f.Organisation)
|
|
.WithMany()
|
|
.HasForeignKey(fk => fk.OrganisationId)
|
|
.IsRequired()
|
|
.OnDelete(DeleteBehavior.Restrict);
|
|
|
|
builder.HasOne(f => f.Programme)
|
|
.WithMany(f => f.Awards)
|
|
.HasForeignKey(fk => fk.ProgrammeId)
|
|
.IsRequired()
|
|
.OnDelete(DeleteBehavior.Restrict);
|
|
|
|
builder.HasOne(f => f.Project)
|
|
.WithMany(f => f.Awards)
|
|
.HasForeignKey(fk => fk.ProjectId)
|
|
.IsRequired(false)
|
|
.OnDelete(DeleteBehavior.SetNull);
|
|
|
|
builder.HasOne(f => f.Creator)
|
|
.WithMany()
|
|
.HasForeignKey(fk => fk.CreatedBy)
|
|
.IsRequired()
|
|
.OnDelete(DeleteBehavior.NoAction);
|
|
|
|
builder.HasOne(f => f.Updator)
|
|
.WithMany()
|
|
.HasForeignKey(fk => fk.UpdatedBy)
|
|
.IsRequired(false)
|
|
.OnDelete(DeleteBehavior.NoAction);
|
|
|
|
builder.HasOne(f => f.Approver)
|
|
.WithMany()
|
|
.HasForeignKey(fk => fk.ApprovedBy)
|
|
.IsRequired(false)
|
|
.OnDelete(DeleteBehavior.NoAction);
|
|
}
|
|
} |