Changeset 691f152 for iknow-api/Repository

Timestamp:

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

Author:

Stefan-Saveski <stefansaveski19@…>

Branches:

master

Children:

33c69d6

Parents:

2d64b2e

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);