Class BoardService

backend/Services/BoardService.cs:8–887

namespace Backend.Services;

public class BoardService : IBoardService
{
    private readonly AppDbContext _db;

    public BoardService(AppDbContext db)
    {
        _db = db;
    }

    public async Task<List<BoardSummaryDto>> GetBoardsAsync(int userId)
    {
        var boards = await _db.Boards
            .AsNoTracking()
            .Where(b => b.OwnerId == userId
                     || b.Members.Any(m => m.UserId == userId && m.Status == "Accepted")
                     || (b.Workspace.Members.Any(wm => wm.UserId == userId && wm.Status == "Accepted")))
            .Select(b => new BoardSummaryDto
            {
                Id = b.Id,
                Name = b.Name,
                CreatedAt = b.CreatedAt,
                Role = b.OwnerId == userId ? "Owner" : "Member",
                ThemeColor = b.ThemeColor,
                WorkspaceId = b.WorkspaceId,
                WorkspaceName = b.Workspace.Name,
                IsClosed = b.IsClosed,
                OpenTasksCount = b.Columns.SelectMany(c => c.TaskCards)
                    .Count(t => !t.Column.Name.ToLower().Contains("done") && !t.Column.Name.ToLower().Contains("complete")),
                Members = b.Members
                    .Where(m => m.Status == "Accepted")
                    .Select(m => new BoardMemberDto
                    {
                        Id = m.Id,
                        UserId = m.UserId,
                        Username = m.User.Username,
                        AvatarUrl = m.User.AvatarUrl,
                        Role = m.Role
                    }).ToList()
            })
            .ToListAsync();

        // Populate members and override roles based on workspace permissions
        foreach (var board in boards)
        {
            var b = await _db.Boards
                .AsNoTracking()
                .Include(x => x.Owner)
                .Include(x => x.Workspace)
                .ThenInclude(w => w.Members)
                .FirstOrDefaultAsync(x => x.Id == board.Id);

            if (b == null) continue;

            // Determine if requester is workspace admin
            bool isWsAdmin = b.Workspace.OwnerId == userId ||
                            b.Workspace.Members.Any(wm => wm.UserId == userId && wm.Role == "Admin" && wm.Status == "Accepted");

            if (isWsAdmin)