using Indotalent.Data.Entities;
using Indotalent.Shared.Consts;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Metadata.Builders;

namespace Indotalent.Infrastructure.Database.MsSQL.Configuration;

public class LeaveRequestConfiguration : IEntityTypeConfiguration<LeaveRequest>
{
    public void Configure(EntityTypeBuilder<LeaveRequest> builder)
    {
        builder.Property(e => e.AutoNumber)
            .HasMaxLength(GlobalConsts.StringLengthShort);

        builder.Property(e => e.Reason)
            .HasMaxLength(GlobalConsts.StringLengthMedium);

        builder.Property(e => e.Status)
            .HasMaxLength(GlobalConsts.StringLengthShort);

        builder.Property(e => e.AttachmentPath)
            .HasMaxLength(GlobalConsts.StringLengthMedium);

        builder.Property(e => e.ApproverId)
            .HasMaxLength(GlobalConsts.StringLengthShort);

        builder.Property(e => e.RejectReason)
            .HasMaxLength(GlobalConsts.StringLengthMedium);

        builder.HasOne(e => e.Employee)
            .WithMany()
            .HasForeignKey(e => e.EmployeeId)
            .OnDelete(DeleteBehavior.Restrict);

        builder.HasOne(e => e.LeaveCategory)
            .WithMany()
            .HasForeignKey(e => e.LeaveCategoryId)
            .OnDelete(DeleteBehavior.Restrict);

        builder.HasIndex(e => new { e.TenantId, e.AutoNumber }).IsUnique();
        builder.HasIndex(e => e.Status);
        builder.HasIndex(e => e.StartDate);
        builder.HasIndex(e => e.EndDate);
    }
}