public void Configure(EntityTypeBuilder <CandidateDAO> builder)
{
builder.BaseConfigure();
builder.ToTable("Candidates");
builder.Property(t => t.FirstName)
.HasMaxLength(50)
.IsRequired();
builder.Property(t => t.MiddleName)
.HasMaxLength(50);
builder.Property(t => t.LastName)
.HasMaxLength(50)
.IsRequired();
builder.Property(t => t.Email)
.HasMaxLength(100)
.IsRequired();
builder.Property(t => t.Cc)
.HasMaxLength(500);
builder.Property(t => t.JobscoreUrl)
.HasMaxLength(500);
builder.Property(t => t.GitHubAccount)
.HasMaxLength(100);
builder.Property(t => t.Description)
.HasMaxLength(1000);
builder.HasOne(x => x.JobTitle)
.WithMany(x => x.Candidates)
.HasForeignKey(x => x.JobTitleId);
}
public void Configure(EntityTypeBuilder <JobTitleDAO> builder)
{
builder.BaseConfigure();
builder.ToTable("JobTitles");
builder.Property(t => t.Name)
.HasMaxLength(100)
.IsRequired();
builder.Property(t => t.Description)
.HasMaxLength(1000);
}
public void Configure(EntityTypeBuilder <EvaluationSectionDAO> builder)
{
builder.BaseConfigure();
builder.ToTable("EvaluationSections");
builder.Property(t => t.Name)
.HasMaxLength(150)
.IsRequired();
builder.Property(t => t.Multiplier)
.HasDefaultValue(1);
}
public void Configure(EntityTypeBuilder <ProductDAO> builder)
{
builder.BaseConfigure();
builder.ToTable("Products");
builder.Property(t => t.Name)
.HasMaxLength(200)
.IsRequired();
builder.Property(p => p.Price)
.HasColumnType(DefaultDbTypes.DecimalType);
}
public void Configure(EntityTypeBuilder <OrderDAO> builder)
{
builder.BaseConfigure();
builder.ToTable("Orders");
builder.HasMany(x => x.Items)
.WithOne(p => p.Order)
.HasForeignKey(p => p.OrderId)
.OnDelete(DeleteBehavior.Cascade);
builder.Property(p => p.Amount)
.HasColumnType(DefaultDbTypes.DecimalType);
}
public void Configure(EntityTypeBuilder <OrderItemDAO> builder)
{
builder.BaseConfigure();
builder.ToTable("OrderItems");
builder.HasOne(x => x.Product)
.WithMany()
.HasForeignKey(x => x.ProductId)
.OnDelete(DeleteBehavior.Cascade);
builder.Property(p => p.Price)
.HasColumnType(DefaultDbTypes.DecimalType);
}
public void Configure(EntityTypeBuilder <TestDAO> builder)
{
builder.BaseConfigure();
builder.ToTable("Tests");
builder.Property(t => t.Name)
.IsRequired()
.HasMaxLength(200)
.HasDefaultValue(string.Empty);
builder.Property(t => t.Template)
.IsRequired();
builder.Property(t => t.Description)
.HasMaxLength(1000);
builder.HasOne(x => x.JobTitle)
.WithMany(x => x.Tests)
.HasForeignKey(x => x.JobTitleId);
}
public void Configure(EntityTypeBuilder <ExamDAO> builder)
{
builder.BaseConfigure();
builder.ToTable("Exams");
builder.Property(t => t.GitHubRepositoryName)
.HasMaxLength(400);
builder.Property(t => t.GitHubInvitationId)
.HasMaxLength(100);
builder.Property(t => t.GitHubLink)
.HasMaxLength(400);
builder.Property(t => t.AccessCode)
.HasMaxLength(80);
builder.HasOne(x => x.Candidate)
.WithMany(x => x.Exams)
.HasForeignKey(x => x.CandidateId);
builder.HasOne(x => x.Test)
.WithMany(x => x.Exams)
.HasForeignKey(x => x.TestId);
}
public void Configure(EntityTypeBuilder <EvaluationNoteDAO> builder)
{
builder.BaseConfigure();
builder.ToTable("EvaluationNotes");
builder.Property(t => t.Value)
.HasMaxLength(5000)
.IsRequired();
builder.Property(t => t.FieldType)
.HasDefaultValue(EvaluationFieldType.Comment);
builder.HasOne(t => t.Section)
.WithMany(t => t.EvaluationNotes)
.HasForeignKey(t => t.SectionId)
.IsRequired();
builder.HasOne(t => t.Exam)
.WithMany(t => t.EvaluationNotes)
.HasForeignKey(t => t.ExamId)
.IsRequired();
}
