Changeset aee2b88 for iknow-api/Data/AppDbContext.cs

Timestamp:

12/16/25 23:05:19 (9 months ago)

Author:

Stefan-Saveski <stefansaveski19@…>

Branches:

master

Children:

bb02e3a

Parents:

61fd94e

Message:

Upgraded database, added get subjects and get passed subjects.

File:

• iknow-api/Data/AppDbContext.cs (modified) (2 diffs)

iknow-api/Data/AppDbContext.cs

@@ -25 +25 @@
         public DbSet<Documents> Documents { get; set; }
         public DbSet<Payment> Payments { get; set; }
+        public DbSet<ProfessorSubjects> ProfessorSubjects { get; set; }
 
 
@@ -165 +166 @@
                 .HasForeignKey(es => es.Id)
                 .OnDelete(DeleteBehavior.Restrict);
+
+            // -------------------------
+            // ProfessorSubjects (many-to-many: Professor -> Semester -> Subject)
+            // -------------------------
+            modelBuilder.Entity<ProfessorSubjects>()
+                .HasKey(ps => new { ps.ProfessorId, ps.SemesterId, ps.SubjectId });
+
+            modelBuilder.Entity<ProfessorSubjects>()
+                .HasOne(ps => ps.Professor)
+                .WithMany()
+                .HasForeignKey(ps => ps.ProfessorId)
+                .OnDelete(DeleteBehavior.Cascade);
+
+            modelBuilder.Entity<ProfessorSubjects>()
+                .HasOne(ps => ps.Semester)
+                .WithMany()
+                .HasForeignKey(ps => ps.SemesterId)
+                .OnDelete(DeleteBehavior.Cascade);
+
+            modelBuilder.Entity<ProfessorSubjects>()
+                .HasOne(ps => ps.Subject)
+                .WithMany()
+                .HasForeignKey(ps => ps.SubjectId)
+                .OnDelete(DeleteBehavior.Cascade);
         }