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

Timestamp:

12/08/25 21:51:12 (10 months ago)

Author:

Stefan-Saveski <stefan@…>

Branches:

master

Children:

bb656bc

Parents:

a92a2a4

Message:

Refactor and enhance application structure

Enhanced error handling in AuthController with detailed exception handling for user registration. Updated UserDTO to improve JSON serialization and renamed enums for clarity. Introduced new entities (Major, PassedSubject, etc.) and seeded initial data in AppDbContext.

Replaced legacy migrations with 20251208203846_InitialCreate, reflecting the updated schema. Fixed typographical errors and improved JSON serialization in Program.cs with case-insensitive property matching and enum handling.

Refactored repository interfaces for better null safety. Improved debugging in AuthService and updated connection strings. Added the PassedSubject entity and cleaned up redundant code and unused imports for better maintainability.

File:

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

iknow-api/Data/AppDbContext.cs

@@ -17 +17 @@
         public DbSet<Subject> Subjects { get; set; }
         public DbSet<DependencySubject> DependencySubjects { get; set; }
+        public DbSet<Major> Majors { get; set; }
+        public DbSet<PassedSubject> PassedSubjects { get; set; }
 
 
@@ -22 +24 @@
         {
             base.OnModelCreating(modelBuilder);
+
+            modelBuilder.Entity<Major>().HasData(
+                new Major { Id = 1, Name = "PIT" },
+                new Major { Id = 2, Name = "SIIS" },
+                new Major { Id = 3, Name = "SEIS" },
+                new Major { Id = 4, Name = "KN" }
+            );
+
 
             // -------------------------
@@ -128 +138 @@
                 .HasForeignKey(ss => ss.EnrolledSemesterId)
                 .OnDelete(DeleteBehavior.Restrict);
+
+            // -------------------------
+            // PassedSubject (one-to-one with SemesterSubject)
+            // -------------------------
+            modelBuilder.Entity<PassedSubject>()
+                .HasKey(ps => ps.Id);
+
+            modelBuilder.Entity<PassedSubject>()
+                .HasOne(ps => ps.SemesterSubject)
+                .WithOne(ss => ss.PassedSubject)
+                .HasForeignKey<PassedSubject>(ps => ps.SemesterSubjectId)
+                .OnDelete(DeleteBehavior.Cascade);
         }