Purpose: Return all refresh tokens with user information

Sample Response (JSON):

{
  "success": true,
  "data": [
    {
      "id": 123,
      "userId": "user-guid-123",
      "userEmail": "user@example.com",
      "userName": "John Doe",
      "deviceName": "iPhone 12",
      "deviceType": "mobile",
      "ipAddress": "192.168.1.1",
      "countryCode": "TW",
      "isRevoked": false,
      "isTrustedDevice": true,
      "createdAt": "2025-11-09T10:30:00",
      "expiresAt": "2025-11-16T10:30:00",
      "lastUsedAt": "2025-11-09T15:45:00",
      "revokedAt": null
    }
  ],
  "totalCount": 150
}

Implementation Location:

C:\dev\AIAgent002JwtAuthApi\Controllers\AdminAccountController.cs

Code Template:

[HttpGet("all-refresh-tokens")]
[Authorize(Roles = "admin")]
public async Task<IActionResult> GetAllRefreshTokens(
    [FromQuery] int pageNumber = 1,
    [FromQuery] int pageSize = 50)
{
    try
    {
        var tokens = await _context.RefreshTokens
            .Include(t => t.User)
            .Where(t => !t.IsRevoked)
            .OrderByDescending(t => t.CreatedAt)
            .Skip((pageNumber - 1) * pageSize)
            .Take(pageSize)
            .Select(t => new
            {
                t.Id,
                t.UserId,
                UserEmail = t.User.Email,
                UserName = t.User.UserName,
                t.DeviceName,
                t.DeviceType,
                t.IpAddress,
                t.CountryCode,
                t.IsRevoked,
                t.IsTrustedDevice,
                t.CreatedAt,
                t.Expires,
                t.LastUsedAt,
                t.RevokedAt
            })
            .ToListAsync();

        var totalCount = await _context.RefreshTokens.CountAsync();

        return Ok(new
        {
            success = true,
            data = tokens,
            totalCount = totalCount
        });
    }
    catch (Exception ex)
    {
        return StatusCode(500, new
        {
            success = false,
            message = ex.Message
        });
    }
}