public void GetSystemLoadServerDetails(LoadViewColumns sortColumn)
{
//Arrange
var gridConditions = new GridConditions();
var filterConditions = new LoadViewFilterConditions();
var filterOperands = new LoadViewFilterOperands();
//Grid conditions
gridConditions.SortColumn = sortColumn.ToString();
gridConditions.SortDirection = "ASC";
gridConditions.TimezoneOffset = 0;
gridConditions.StartRow = 1;
gridConditions.EndRow = 25;
//Filter conditions
filterConditions.Server = "";
filterConditions.ServerType = "";
//Filter operands
filterOperands.OverallScore = FilterOperand.Equals;
filterOperands.CPUUtilizationScore = FilterOperand.Equals;
filterOperands.RAMUtilizationScore = FilterOperand.Equals;
filterOperands.MemorySignalScore = FilterOperand.Equals;
filterOperands.WaitsScore = FilterOperand.Equals;
filterOperands.VirtualLogFilesScore = FilterOperand.Equals;
filterOperands.LatencyScore = FilterOperand.Equals;
//Page-level filters
gridConditions.StartDate = DateTime.Now.AddYears(-1);
gridConditions.EndDate = DateTime.Now.AddDays(1);
//Act
var result = this.reportRepository.GetSystemLoadServerDetails(gridConditions, filterConditions, filterOperands);
//Assert
Assert.That(result, Is.Not.Null);
Assert.That(result, Is.Not.Empty);
}
public virtual LoadViewGrid ServerHours(GridConditions gridConditions, LoadViewFilterConditions filterConditions, LoadViewFilterOperands filterOperands)
{
var grid = new LoadViewGrid();
var dt = this.reportRepository.GetSystemLoadServerDetails(gridConditions, filterConditions, filterOperands);
if (dt.Count > 1)
{
var searchUsers = dt[0];
grid.Data = (from DataRow d in searchUsers.Rows
select new SystemLoadServerHourInfo
{
Index = d.Field <int>("RowNumber"),
ServerId = d.Field <int>("ServerArtifactId"),
Server = d.Field <string>("Server"),
ServerType = d.Field <string>("ServerType"),
SummaryDayHour = d.Field <DateTime>("SummaryDayHour"),
OverallScore = d.Field <int?>("Score").GetValueOrDefault(100),
CPUScore = d.Field <int?>("CPUScore").GetValueOrDefault(100),
RAMScore = d.Field <int?>("RAMScore").GetValueOrDefault(100),
MemorySignalStateScore = d.Field <int?>("MemorySignalStateScore").GetValueOrDefault(100),
MemorySignalStateRatio = d.Field <int?>("MemorySignalStateRatio").GetValueOrDefault(0),
Pageouts = d.Field <int?>("Pageouts").GetValueOrDefault(0),
WaitsScore = d.Field <int?>("WaitsScore").GetValueOrDefault(100),
VirtualLogFilesScore = d.Field <int?>("VirtualLogFilesScore").GetValueOrDefault(100),
MaxVirtualLogFiles = d.Field <int?>("MaxVirtualLogFiles").GetValueOrDefault(0),
LatencyScore = d.Field <int?>("LatencyScore").GetValueOrDefault(100),
HighestLatencyDatabase = d.Field <string>("HighestLatencyDatabase"),
ReadLatencyMs = d.Field <int?>("ReadLatencyMs").GetValueOrDefault(0),
WriteLatencyMs = d.Field <int?>("WriteLatencyMs").GetValueOrDefault(0),
IsDataFile = d.Field <bool?>("IsDataFile").GetValueOrDefault(false),
IsActiveWeeklySample = d.Field <bool>("IsActiveArrivalRateSample")
}).AsQueryable();
var resultInfo = dt[1];
grid.Count = resultInfo.Rows.Count > 0 ? resultInfo.Rows[0].Field <int?>("FilteredCount").GetValueOrDefault(0) : 0;
}
return(grid);
}
public SystemLoadServerViewModel()
{
GridConditions = new GridConditions();
FilterConditions = new LoadViewFilterConditions();
FilterOperands = new LoadViewFilterOperands();
}
