using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Metadata.Builders;
using Minerva.Domain.Entities;

namespace Minerva.Infra.Data.Configurations
{
    public class PhoneConfiguration : IEntityTypeConfiguration<Phone>
    {
        public void Configure(EntityTypeBuilder<Phone> builder)
        {
            builder.OwnsOne(o => o.PhoneNumber,
                sa =>
                {
                    sa.Property(p => p.FullNumberP)
                        .HasColumnName("FullNumber")
                        .HasComputedColumnSql("CONCAT(AreaCode Number) PERSISTED");

                    sa.Property(p => p.AreaCode)
                        .HasColumnName("AreaCode")
                        .HasMaxLength(2)
                        .IsRequired();

                    sa.Property(p => p.Number)
                        .HasColumnName("Number")
                        .HasMaxLength(9)
                        .IsRequired();
                });
        }
    }
}