Changeset b38c39c for iknow-api/Repository

Timestamp:

10/27/25 21:50:02 (11 months ago)

Author:

stefansaveski <stefansaveski19@…>

Branches:

master

Children:

ff202cf

Parents:

cab02ad

Message:

Add user-related entities and enforce one-to-one mappings

Enhanced the User model with new entities: ContactInfo,
EnrollmentInfo, and HighSchool, establishing one-to-one
relationships. Updated UserDTO with additional fields and
introduced enums for type, quota, and major. Modified
UserRepository and AuthService to handle new entities.

Updated database schema with unique constraints on UserId
for related tables and added EF Core migration
20251027191028_dbRelations. Adjusted JSON serialization
to prevent circular references.

Location:

iknow-api/Repository

Files:

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

iknow-api/Repository/Implementations/UserRepository.cs

@@ -25 +25 @@
         }
         
-        public async Task<User> GetUserByIdAsync(int id)
+        public async Task<User?> GetUserByIdAsync(int id)
         {
-            return await _context.User.FirstOrDefaultAsync(u => u.Id == id);
+            return await _context.User
+                .Include(u => u.ContactInfo)
+                .Include(u => u.EnrollmentInfo)
+                .Include(u => u.HighSchool)
+                .FirstOrDefaultAsync(u => u.Id == id);
         }
 
@@ -36 +40 @@
             await _context.SaveChangesAsync();
         }
+        public async Task AddContactAsync(ContactInfo contactInfo)
+        {
+            _context.ContactInfo.Add(contactInfo);
+            await _context.SaveChangesAsync();
+        }
+        public async Task AddEnrollmentAsync(EnrollmentInfo enrollment)
+        {
+            _context.EnrollmentInfo.Add(enrollment);
+            await _context.SaveChangesAsync();
+        }   
+        public async Task AddHighSchoolAsync(HighSchool highSchool)
+        {
+            _context.HighSchool.Add(highSchool);
+            await _context.SaveChangesAsync();
+        }       
 
         public async Task<int> GetUsersCountAsync()

iknow-api/Repository/Interface/IUserRepository.cs

@@ -7 +7 @@
         Task<User?> GetUserByUsernameAsync(string username);
         Task AddUserAsync(User user);
+        Task AddContactAsync(ContactInfo contactInfo);
+        Task AddEnrollmentAsync(EnrollmentInfo enrollment);
+        Task AddHighSchoolAsync(HighSchool highSchool);
         Task<int> GetUsersCountAsync();
         Task<User> GetUserByIdAsync(int id);