public async Task <IActionResult> Dashboard(Guid userId)
{
var servers = await _serverService.GetAllAsync(x => x.UserId == userId);
var memoryUsageMetrics = await _memoryUsageMetricsService.GetAllAsync(x => servers.Select(s => s.Id).Contains(x.ServerId));
var result = new List <SqlServerBadgeModel>();
foreach (var server in servers.OrderBy(x => x.CreatedDate))
{
var memoryUsageMetric = memoryUsageMetrics.LastOrDefault(x => x.ServerId == server.Id);
var serverBadge = new SqlServerBadgeModel
{
ServerId = server.Id,
Name = server.Name,
PageLifetime = memoryUsageMetric?.PageLifetime ?? 0,
PageReadsCount = memoryUsageMetric?.PageReadsCount ?? 0,
RequestCount = memoryUsageMetric?.RequestsCount ?? 0,
Description = server.Description,
ServerAddress = $"{server.Host}: {server.Port}",
ConnectedUsers = 0,
IsAlive = true
};
result.Add(serverBadge);
}
return(Ok(result));
}
