Class UserRepository

Namespace

Builvero.Infrastructure.Repositories

Assembly

Builvero.Infrastructure.dll

Repository implementation for user data access operations using Entity Framework Core.

public class UserRepository : IUserRepository

Inheritance

object

UserRepository

Implements

IUserRepository

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Remarks

This repository provides methods for querying, creating, updating, and managing users and their related entities. All queries use eager loading (Include) to fetch related entities (Profile, Educations, Experiences, Skills, BuilderTags) to avoid N+1 query problems.

Constructors

UserRepository(ApplicationDbContext)

Initializes a new instance of the UserRepository class.

public UserRepository(ApplicationDbContext context)

Parameters

context ApplicationDbContext

The Entity Framework database context for data access.

Methods

CreateAsync(User, CancellationToken)

Creates a new user entity in the database.

public Task<User> CreateAsync(User user, CancellationToken cancellationToken = default)

Parameters

user User

The user entity to create. Related entities (Profile, Educations, etc.) are also persisted if included.

cancellationToken CancellationToken

Cancellation token to cancel the operation.

Returns

Task<User>

The created user entity with database-generated values (e.g., timestamps) populated.

Remarks

This method adds the user to the context and saves changes. If the user includes related entities (Profile, Educations, Experiences, etc.), they are also persisted in the same transaction.

EmailExistsAsync(string, CancellationToken)

Checks if a user with the specified email address already exists in the database.

public Task<bool> EmailExistsAsync(string email, CancellationToken cancellationToken = default)

Parameters

email string

The email address to check.

cancellationToken CancellationToken

Cancellation token to cancel the operation.

Returns

Task<bool>

true if a user with the email exists; otherwise, false.

Remarks

Email comparison is case-sensitive. This method is typically used during user registration to enforce email uniqueness.

GetByEmailAsync(string, CancellationToken)

Retrieves a user by their email address with profile loaded.

public Task<User?> GetByEmailAsync(string email, CancellationToken cancellationToken = default)

Parameters

email string

The email address of the user to retrieve.

cancellationToken CancellationToken

Cancellation token to cancel the operation.

Returns

Task<User>

The user entity with Profile loaded, or null if not found.

Remarks

Email comparison is case-sensitive. Only the Profile navigation property is eagerly loaded.

GetByEmailWithProfileAsync(string, CancellationToken)

Retrieves a user by their email address with complete profile information loaded.

public Task<User?> GetByEmailWithProfileAsync(string email, CancellationToken cancellationToken = default)

Parameters

email string

The email address of the user to retrieve.

cancellationToken CancellationToken

Cancellation token to cancel the operation.

Returns

Task<User>

The user entity with Profile, Educations, Experiences, UserBuilderTags, and UserSkills loaded, or null if not found.

Remarks

This method is similar to GetByIdAsync(Guid, CancellationToken) but queries by email instead of ID. Uses eager loading to include all related entities for complete profile information.

GetByIdAsNoTrackingAsync(Guid, CancellationToken)

Retrieves a user by their unique identifier without tracking (AsNoTracking).

public Task<User?> GetByIdAsNoTrackingAsync(Guid id, CancellationToken cancellationToken = default)

Parameters

id Guid

The unique identifier of the user to retrieve.

cancellationToken CancellationToken

Cancellation token to cancel the operation.

Returns

Task<User>

The user entity with all related entities loaded, but not tracked by EF Core, or null if not found.

Remarks

This method is useful for reading fresh data after SaveChanges when you need to ensure navigation properties reflect the latest database state without EF Core change tracking interference. Uses the same eager loading as GetByIdAsync but with AsNoTracking().

GetByIdAsync(Guid, CancellationToken)

Retrieves a user by their unique identifier with all related entities loaded.

public Task<User?> GetByIdAsync(Guid id, CancellationToken cancellationToken = default)

Parameters

id Guid

The unique identifier of the user to retrieve.

cancellationToken CancellationToken

Cancellation token to cancel the operation.

Returns

Task<User>

The user entity with Profile, Educations, Experiences, UserBuilderTags, and UserSkills loaded, or null if not found.

Remarks

Uses eager loading to include:

• Profile (one-to-one relationship)
• Educations collection
• Experiences collection
• UserBuilderTags with BuilderTag navigation property
• UserSkills with Skill navigation property

GetSearchUsersCountAsync(string?, UserCategory?, List<Guid>?, CancellationToken)

Gets the total count of users matching the specified search criteria.

public Task<int> GetSearchUsersCountAsync(string? text, UserCategory? category, List<Guid>? skillIds, CancellationToken cancellationToken = default)

Parameters

text string

Optional search text for filtering users by name or profile summary.

category UserCategory?

Optional user category filter (e.g., SoftwareEngineer, Designer).

skillIds List<Guid>

Optional list of skill IDs to filter users by.

cancellationToken CancellationToken

Cancellation token to cancel the operation.

Returns

Task<int>

The total count of users matching the search criteria.

GetUsersAsync(int, int, string?, UserStatus?, UserRole?, CancellationToken)

Retrieves a paginated list of users with optional filtering by search term, status, and role.

public Task<List<User>> GetUsersAsync(int page, int pageSize, string? search = null, UserStatus? status = null, UserRole? role = null, CancellationToken cancellationToken = default)

Parameters

page int

The page number (1-based) to retrieve.

pageSize int

The number of users per page.

search string

Optional search term to filter users by email or profile name (case-insensitive).

status UserStatus?

Optional status filter to include only users with the specified status.

role UserRole?

Optional role filter to include only users with the specified role.

cancellationToken CancellationToken

Cancellation token to cancel the operation.

Returns

Task<List<User>>

A list of users matching the filters, ordered by creation date (newest first).

Remarks

This method uses eager loading to include:

• Profile (for name search and display)
• Invitation (for invitation code display in admin views)

Search is performed on both email addresses and profile full names (case-insensitive contains match). Results are ordered by creation date in descending order (newest users first).

GetUsersByRolesAsync(List<UserRole>, CancellationToken)

Gets all active users whose role is in the specified list of roles. Used for sending bulk admin updates to specific user groups.

public Task<List<User>> GetUsersByRolesAsync(List<UserRole> roles, CancellationToken cancellationToken = default)

Parameters

roles List<UserRole>

List of user roles to filter by.

cancellationToken CancellationToken

Cancellation token to cancel the operation.

Returns

Task<List<User>>

List of active users with the specified roles.

Remarks

This method is used by the admin bulk email feature to retrieve users by role for sending administrative updates. Only active users are returned.

GetUsersCountAsync(string?, UserStatus?, UserRole?, CancellationToken)

Gets the total count of users matching the specified filters.

public Task<int> GetUsersCountAsync(string? search = null, UserStatus? status = null, UserRole? role = null, CancellationToken cancellationToken = default)

Parameters

search string

Optional search term to filter users by email or name.

status UserStatus?

Optional status filter (e.g., Active, Blocked).

role UserRole?

Optional role filter (e.g., User, Admin, Moderator).

cancellationToken CancellationToken

Cancellation token to cancel the operation.

Returns

Task<int>

The total count of users matching the filters.

SearchUsersAsync(string?, UserCategory?, List<Guid>?, int, int, CancellationToken)

Searches for users matching the specified criteria with pagination support.

public Task<List<User>> SearchUsersAsync(string? text, UserCategory? category, List<Guid>? skillIds, int page, int pageSize, CancellationToken cancellationToken = default)

Parameters

text string

Optional search text for filtering users by name or profile summary.

category UserCategory?

Optional user category filter (e.g., SoftwareEngineer, Designer).

skillIds List<Guid>

Optional list of skill IDs to filter users by.

page int

The page number (1-based) to retrieve.

pageSize int

The number of users per page.

cancellationToken CancellationToken

Cancellation token to cancel the operation.

Returns

Task<List<User>>

A list of users matching the search criteria.

UpdateAsync(User, CancellationToken)

Updates an existing user entity in the database.

public Task<User> UpdateAsync(User user, CancellationToken cancellationToken = default)

Parameters

user User

The user entity to update. All properties are updated.

cancellationToken CancellationToken

Cancellation token to cancel the operation.

Returns

Task<User>

The updated user entity.

Remarks

This method marks the user as modified and saves changes. Related entities are not automatically updated - they must be managed separately if changes are needed.