Index: iknow-api/Repository/Implementations/UserRepository.cs
===================================================================
--- iknow-api/Repository/Implementations/UserRepository.cs	(revision c2f79d73d7219c8c8bcc00f5badba27a707b22be)
+++ iknow-api/Repository/Implementations/UserRepository.cs	(revision 33c69d6e6096b3f8bcc1428ef0cedb8ded41b5c2)
@@ -63,4 +63,11 @@
             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();
+        }
 
     }