Changeset 70a9f6d for iknow-api/Data/AppDbContext.cs

Timestamp:

12/10/25 15:12:34 (10 months ago)

Author:

imbrsk <boris696boris@…>

Branches:

master

Children:

61fd94e

Parents:

33c69d6

Message:

feat: Add ActiveSemesters model and update related entities

• Introduced ActiveSemesters model with properties: id, year, and Type.
• Updated EnrolledSemesters model to include new properties: CratedAt, LastChange, Veryfied, Node, and StudentComment.
• Modified Payment model to change the primary key and updated table name to Payments.
• Added Signature property to SemesterSubject model and updated table name to SemesterSubjects.
• Created new migration to reflect changes in the database schema.
• Updated User model to include a reference to Payments.

File:

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

iknow-api/Data/AppDbContext.cs

@@ -14 +14 @@
         public DbSet<EnrollmentInfo> EnrollmentInfo { get; set; }
         public DbSet<RefreshToken> RefreshToken { get; set; }
-
         public DbSet<Subject> Subjects { get; set; }
         public DbSet<DependencySubject> DependencySubjects { get; set; }
@@ -20 +19 @@
         public DbSet<PassedSubject> PassedSubjects { get; set; }
         public DbSet<EnrolledSemesters> EnrolledSemesters { get; set; }
+        public DbSet<ActiveSemesters> ActiveSemesters { get; set; }
+        public DbSet<SemesterSubject> SemesterSubjects { get; set; }
+        public DbSet<MajorSubjects> MajorSubjects { get; set; }
+        public DbSet<UserDocuments> UserDocuments { get; set; }
+        public DbSet<Documents> Documents { get; set; }
+        public DbSet<Payment> Payments { get; set; }
 
 
@@ -92 +97 @@
             // -------------------------
             modelBuilder.Entity<Payment>()
-                .HasKey(ab => new { ab.UserId, ab.EnrollmentInfoId });
+                .HasKey(p => p.Id);
 
             modelBuilder.Entity<Payment>()
-                .HasOne(ab => ab.User)
-                .WithMany(a => a.EnrolledSemesters)
-                .HasForeignKey(ab => ab.UserId)
+                .HasOne(p => p.User)
+                .WithMany(u => u.EnrolledSemesters)
+                .HasForeignKey(p => p.UserId)
                 .OnDelete(DeleteBehavior.Cascade);
 
             modelBuilder.Entity<Payment>()
-                .HasOne(ab => ab.EnrolledSemesters)
-                .WithMany(b => b.Users)
-                .HasForeignKey(ab => ab.EnrollmentInfoId)
+                .HasOne(p => p.EnrolledSemesters)
+                .WithMany(es => es.Users)
+                .HasForeignKey(p => p.EnrollmentInfoId)
                 .OnDelete(DeleteBehavior.Cascade);
 
@@ -151 +156 @@
                 .HasForeignKey<PassedSubject>(ps => ps.SemesterSubjectId)
                 .OnDelete(DeleteBehavior.Cascade);
+
+            // -------------------------
+            // ActiveSemesters to EnrolledSemesters (one-to-many)
+            // -------------------------
+            modelBuilder.Entity<EnrolledSemesters>()
+                .HasOne(es => es.Semester)
+                .WithMany(a => a.EnrolledSemesters)
+                .HasForeignKey(es => es.Id)
+                .OnDelete(DeleteBehavior.Restrict);
         }