| | | 1 | | using CoWorkingApp.Core.Domain.Entities; |
| | | 2 | | using Microsoft.EntityFrameworkCore; |
| | | 3 | | |
| | | 4 | | namespace CoWorkingApp.API.Infrastructure.Context |
| | | 5 | | { |
| | | 6 | | /// <summary> |
| | | 7 | | /// Clase que representa el contexto de la base de datos para la aplicación CoWorking. |
| | | 8 | | /// </summary> |
| | | 9 | | public class CoWorkingContext : DbContext |
| | | 10 | | { |
| | | 11 | | /// <summary> |
| | | 12 | | /// Constructor que recibe las opciones de configuración del contexto. |
| | | 13 | | /// </summary> |
| | | 14 | | /// <param name="options">Opciones de configuración del contexto.</param> |
| | 231 | 15 | | public CoWorkingContext(DbContextOptions<CoWorkingContext> options) : base(options) { } |
| | | 16 | | |
| | | 17 | | /// <summary> |
| | | 18 | | /// DbSet que representa la tabla de usuarios en la base de datos. |
| | | 19 | | /// </summary> |
| | 132 | 20 | | public DbSet<User> Users { get; set; } |
| | | 21 | | |
| | | 22 | | /// <summary> |
| | | 23 | | /// DbSet que representa la tabla de asientos en la base de datos. |
| | | 24 | | /// </summary> |
| | 131 | 25 | | public DbSet<Seat> Seats { get; set; } |
| | | 26 | | |
| | | 27 | | /// <summary> |
| | | 28 | | /// DbSet que representa la tabla de reservas en la base de datos. |
| | | 29 | | /// </summary> |
| | 130 | 30 | | public DbSet<Reservation> Reservations { get; set; } |
| | | 31 | | |
| | | 32 | | /// <summary> |
| | | 33 | | /// Método que se llama al crear el modelo de la base de datos y define las configuraciones adicionales. |
| | | 34 | | /// </summary> |
| | | 35 | | /// <param name="modelBuilder">Constructor del modelo de la base de datos.</param> |
| | | 36 | | protected override void OnModelCreating(ModelBuilder modelBuilder) |
| | 2 | 37 | | { |
| | 2 | 38 | | ModelCreateUser(modelBuilder); |
| | 2 | 39 | | ModelCreateSeat(modelBuilder); |
| | 2 | 40 | | ModelCreateReservation(modelBuilder); |
| | 2 | 41 | | } |
| | | 42 | | |
| | | 43 | | /// <summary> |
| | | 44 | | /// Configuración del modelo de la entidad User a través de Fluent API. |
| | | 45 | | /// </summary> |
| | | 46 | | /// <param name="modelBuilder">Constructor del modelo de la base de datos.</param> |
| | | 47 | | private void ModelCreateUser(ModelBuilder modelBuilder) |
| | 2 | 48 | | { |
| | 2 | 49 | | modelBuilder.Entity<User>(user => |
| | 2 | 50 | | { |
| | 2 | 51 | | user.ToTable("Users"); |
| | 2 | 52 | | user.HasKey(u => u.Id); |
| | 2 | 53 | | user.Property(u => u.Name).IsRequired().HasMaxLength(50); |
| | 2 | 54 | | user.Property(u => u.LastName).IsRequired().HasMaxLength(50); |
| | 2 | 55 | | user.Property(u => u.Email).IsRequired().HasMaxLength(100); |
| | 2 | 56 | | user.Property(u => u.Password).IsRequired().HasMaxLength(50); |
| | 2 | 57 | | user.HasIndex(u => u.Email).IsUnique(); |
| | 2 | 58 | | |
| | 2 | 59 | | // Ignorar la colección Reservations en la entidad User |
| | 2 | 60 | | user.Ignore(u => u.Reservations); |
| | 4 | 61 | | }); |
| | 2 | 62 | | } |
| | | 63 | | |
| | | 64 | | /// <summary> |
| | | 65 | | /// Configuración del modelo de la entidad Reservation a través de Fluent API. |
| | | 66 | | /// </summary> |
| | | 67 | | /// <param name="modelBuilder">Constructor del modelo de la base de datos.</param> |
| | | 68 | | private void ModelCreateReservation(ModelBuilder modelBuilder) |
| | 2 | 69 | | { |
| | 2 | 70 | | modelBuilder.Entity<Reservation>(reservation => |
| | 2 | 71 | | { |
| | 2 | 72 | | reservation.ToTable("Reservations"); |
| | 2 | 73 | | reservation.HasKey(r => r.Id); |
| | 2 | 74 | | reservation.Property(r => r.Date).IsRequired(); |
| | 2 | 75 | | |
| | 2 | 76 | | // Relación con User |
| | 2 | 77 | | reservation.HasOne(r => r.User) |
| | 2 | 78 | | .WithMany(u => u.Reservations) |
| | 2 | 79 | | .HasForeignKey(r => r.UserId) |
| | 2 | 80 | | .OnDelete(DeleteBehavior.Cascade); |
| | 2 | 81 | | |
| | 2 | 82 | | // Relación con Seat |
| | 2 | 83 | | reservation.HasOne(r => r.Seat) |
| | 2 | 84 | | .WithMany(s => s.Reservations) |
| | 2 | 85 | | .HasForeignKey(r => r.SeatId) |
| | 2 | 86 | | .OnDelete(DeleteBehavior.Cascade); |
| | 4 | 87 | | }); |
| | 2 | 88 | | } |
| | | 89 | | |
| | | 90 | | /// <summary> |
| | | 91 | | /// Configuración del modelo de la entidad Seat a través de Fluent API. |
| | | 92 | | /// </summary> |
| | | 93 | | /// <param name="modelBuilder">Constructor del modelo de la base de datos.</param> |
| | | 94 | | private void ModelCreateSeat(ModelBuilder modelBuilder) |
| | 2 | 95 | | { |
| | 2 | 96 | | modelBuilder.Entity<Seat>(seat => |
| | 2 | 97 | | { |
| | 2 | 98 | | seat.ToTable("Seats"); |
| | 2 | 99 | | seat.HasKey(s => s.Id); |
| | 2 | 100 | | seat.Property(s => s.Name).IsRequired().HasMaxLength(50); |
| | 2 | 101 | | seat.Property(s => s.IsBlocked).IsRequired(); |
| | 2 | 102 | | seat.Property(s => s.Description).HasMaxLength(255); |
| | 2 | 103 | | seat.HasIndex(s => s.Name).IsUnique(); |
| | 2 | 104 | | |
| | 2 | 105 | | // Ignorar la colección Reservations en la entidad Seat |
| | 2 | 106 | | seat.Ignore(s => s.Reservations); |
| | 4 | 107 | | }); |
| | 2 | 108 | | } |
| | | 109 | | } |
| | | 110 | | } |