Changeset 2e17229 for iknow-api/Repository

Timestamp:

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

Author:

Stefan-Saveski <stefansaveski19@…>

Branches:

master

Children:

bf18ca4

Parents:

9f7a52e

Message:

Upgraded database, added get subjects and get passed subjects.

Location:

iknow-api/Repository

Files:

• Implementations/UserRepository.cs (modified) (1 diff)
• Interface/IUserRepository.cs (modified) (1 diff)

iknow-api/Repository/Implementations/UserRepository.cs

@@ -66 +66 @@
         {
             return await _context.EnrolledSemesters
+                .AsNoTracking()
                 .Include(es => es.Major)
+                .Include(es => es.Semester)
+                .Include(es => es.SemesterSubjects)
+                    .ThenInclude(ss => ss.Subject)
+                .Include(es => es.SemesterSubjects)
+                    .ThenInclude(ss => ss.Professor)
                 .Where(es => es.UserId == id)
+                .AsSplitQuery() // This helps avoid cartesian explosion
+                .ToListAsync();
+        }
+
+        public async Task<List<PassedSubject>> GetUserPassedSubjectsAsync(int id)
+        {
+            return await _context.PassedSubjects
+                .AsNoTracking()
+                .Include(ps => ps.SemesterSubject)
+                    .ThenInclude(ss => ss.Subject)
+                .Include(ps => ps.SemesterSubject)
+                    .ThenInclude(ss => ss.EnrolledSemester)
+                        .ThenInclude(es => es.Semester)
+                .Include(ps => ps.SemesterSubject)
+                    .ThenInclude(ss => ss.Professor)
+                .Where(ps => ps.SemesterSubject.UserId == id)
                 .ToListAsync();
         }

iknow-api/Repository/Interface/IUserRepository.cs

@@ -14 +14 @@
         Task<List<EnrolledSemesters>?> GetUserSemestersAsync(int id);
         Task<User?> GetOnlyUserByIdAsync(int id);
-
+        Task<List<PassedSubject>> GetUserPassedSubjectsAsync(int id);
     }
 }