| | | 1 | | using Microsoft.EntityFrameworkCore; |
| | | 2 | | using Microsoft.EntityFrameworkCore.Metadata.Builders; |
| | | 3 | | using Domain.Entities; |
| | | 4 | | |
| | | 5 | | namespace Repository.Mapping; |
| | | 6 | | public class LancamentoMap : IEntityTypeConfiguration<Lancamento> |
| | | 7 | | { |
| | | 8 | | public void Configure(EntityTypeBuilder<Lancamento> builder) |
| | 3 | 9 | | { |
| | 3 | 10 | | builder.ToTable(nameof(Lancamento)); |
| | 3 | 11 | | builder.Property(l => l.Id).HasColumnType("varchar(36)") |
| | 3 | 12 | | .HasConversion(v => v.ToString(), v => new Guid(v)) |
| | 3 | 13 | | .IsRequired(); |
| | 3 | 14 | | builder.HasKey(l => l.Id); |
| | 3 | 15 | | builder.Property(l => l.UsuarioId) |
| | 3 | 16 | | .HasColumnType("varchar(36)") |
| | 3 | 17 | | .HasConversion(v => v.ToString(), v => new Guid(v)) |
| | 3 | 18 | | .IsRequired(); |
| | 3 | 19 | | builder.Property(l => l.DespesaId) |
| | 3 | 20 | | .HasColumnType("varchar(36)") |
| | 3 | 21 | | .HasConversion( |
| | 3 | 22 | | v => v.HasValue ? v.Value.ToString() : null, |
| | 3 | 23 | | v => v != null ? new Guid(v) : (Guid?)null); |
| | | 24 | | |
| | 3 | 25 | | builder.Property(l => l.ReceitaId) |
| | 3 | 26 | | .HasColumnType("varchar(36)") |
| | 3 | 27 | | .HasConversion( |
| | 3 | 28 | | v => v.HasValue ? v.Value.ToString() : null, |
| | 3 | 29 | | v => v != null ? new Guid(v) : (Guid?)null); |
| | | 30 | | |
| | | 31 | | //MySqlServer |
| | 3 | 32 | | builder.Property(m => m.Data).HasColumnType("datetime").IsRequired(); |
| | 3 | 33 | | builder.Property(m => m.DataCriacao).HasColumnType("datetime").HasDefaultValueSql<DateTime>("CURRENT_TIMESTAMP") |
| | | 34 | | |
| | | 35 | | // MsSqlServer |
| | | 36 | | //builder.Property(l => l.Data).HasColumnType("datetime").IsRequired(); |
| | | 37 | | //builder.Property(l => l.DataCriacao).HasColumnType("datetime").HasDefaultValueSql<DateTime>("GetDate()"); |
| | | 38 | | |
| | 3 | 39 | | builder.Property(l => l.Valor).HasColumnType("decimal(10, 2)"); |
| | 3 | 40 | | builder.Property(l => l.Descricao).HasMaxLength(100); |
| | 3 | 41 | | builder.HasOne(l => l.Usuario).WithMany().HasForeignKey(l => l.UsuarioId).OnDelete(DeleteBehavior.NoAction); |
| | 3 | 42 | | builder.HasOne(l => l.Despesa).WithMany().HasForeignKey(l => l.DespesaId).OnDelete(DeleteBehavior.NoAction); |
| | 3 | 43 | | builder.HasOne(l => l.Receita).WithMany().HasForeignKey(l => l.ReceitaId).OnDelete(DeleteBehavior.NoAction); |
| | 3 | 44 | | } |
| | | 45 | | } |