Changeset 615f18d for iknow-api/Repository

Timestamp:

12/10/25 13:44:07 (10 months ago)

Author:

Stefan-Saveski <stefansaveski19@…>

Branches:

master

Children:

f735dac

Parents:

ab652ff

Message:

Add getSemesters endpoint and related data access

Introduce a new getSemesters endpoint in UserController.cs to retrieve user semester data using JWT authentication.

Add DbSet<EnrolledSemesters> to AppDbContext.cs for database interaction.

Implement GetUserSemestersAsync in UserRepository.cs to fetch semesters by user ID, and update IUserRepository.cs to declare this method.

Add GetUserSemesters method in UserService.cs to extract user ID from JWT and retrieve semesters, updating IUserService.cs accordingly.

Location:

iknow-api/Repository

Files:

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

iknow-api/Repository/Implementations/UserRepository.cs

@@ -63 +63 @@
             return await _context.User.CountAsync();
         }
+        public async Task<List<EnrolledSemesters>> GetUserSemestersAsync(int id)
+        {
+            return await _context.EnrolledSemesters
+                .Include(es => es.Major)
+                .Where(es => es.UserId == id)
+                .ToListAsync();
+        }
 
     }

iknow-api/Repository/Interface/IUserRepository.cs

@@ -12 +12 @@
         Task<int> GetUsersCountAsync();
         Task<User?> GetUserByIdAsync(int id);
+        Task<List<EnrolledSemesters>?> GetUserSemestersAsync(int id);
         Task<User?> GetOnlyUserByIdAsync(int id);