private HomePageDashboardDto CalculateHomeDashboardDto()
{
HomePageDashboardDto output = new HomePageDashboardDto();
long storageSize = 0;
using (var conn = new SqlConnection(Configuration.MsSqlConnectionString))
{
var dbSpaceUsed = conn.Query <DbSpaceUsedDto>(" exec sp_spaceused 'TaskLog'").First();
storageSize = long.Parse(dbSpaceUsed.Reserved.Replace("KB", ""));
}
var nodes = _nodeAppService.Query(new PaginationQueryInput {
Page = 1, Size = 10
});
output.NodeTotalCount = (int)nodes.Total;
output.NodeOnlineCount = _nodeAppService.GetOnlineNodeCount();
output.Nodes = nodes.Result;
output.TaskCount = DbContext.Task.Count(t => !t.IsDeleted);
output.RunningTaskCount = DbContext.Task.Count(t => t.IsRunning);
output.LogSize = storageSize > G ? storageSize / G + "G" : storageSize / 1024 + "M";
return(output);
}
private HomePageDashboardDto CalculateHomeDashboardDto()
{
HomePageDashboardDto output = new HomePageDashboardDto();
var client = new MongoClient(Configuration.LogMongoConnectionString);
var database = client.GetDatabase("dotnetspider");
BsonDocumentCommand <BsonDocument> command = new BsonDocumentCommand <BsonDocument>(new BsonDocument {
{ "dbStats", 1 }, { "scale", 1024 }
});
var result = database.RunCommand(command);
var storageSize = result.GetValue("storageSize").ToInt64();
var nodes = _nodeAppService.Query(new PaginationQueryInput {
Page = 1, Size = 10
});
output.NodeTotalCount = (int)nodes.Total;
output.NodeOnlineCount = _nodeAppService.GetOnlineNodeCount();
output.Nodes = nodes.Result;
output.TaskCount = DbContext.Task.Count(t => !t.IsDeleted);
output.RunningTaskCount = DbContext.Task.Count(t => t.IsRunning);
output.LogSize = storageSize > G ? storageSize / G + "G" : storageSize / 1024 + "M";
return(output);
}
