public async Task <GeneralCheckGrid <MaintenanceWindow> > GetFilteredMaintenanceWindowsAsync(MaintenanceWindowDataTableQuery query)
{
var grid = new GeneralCheckGrid <MaintenanceWindow>();
var results = await this.maintenanceWindowRepository.ReadSortedAsync(query);
var resultList = results as IList <MaintenanceWindow> ?? results.ToList();
// Sort
resultList = SortResults(resultList, query);
// paging (start row/end row)
// Add sort/ start row/end row to MWDataTableQuery
var gridCount = resultList.Count;
grid.Data = resultList.AsQueryable();
if (0 < query.StartRow)
{
grid.Data = grid.Data.Skip(query.StartRow - 1);
}
if (0 < query.EndRow)
{
grid.Data = grid.Data.Take(query.EndRow - query.StartRow + 1);
}
grid.Count = gridCount;
return(grid);
}
public virtual GeneralCheckGrid <FileLatency> FileLatencies(GridConditions gridConditions, Dictionary <FileLatency.Columns, String> filterConditions, Dictionary <FileLatency.Columns, FilterOperand> filterOperands)
{
var grid = new GeneralCheckGrid <FileLatency>();
var dt = this.fileLatencyRepository.GetFileLevelLatencyDetails(gridConditions, filterConditions, filterOperands);
var gridData = (from DataRow d in dt.Rows
select new FileLatency
{
ServerName = d.GetField <String>("ServerName"),
DatabaseName = d.GetField <String>("DatabaseName"),
Score = d.GetField <decimal?>("Score"),
DataReadLatency = d.GetField <long?>("DataReadLatency"),
DataWriteLatency = d.GetField <long?>("DataWriteLatency"),
LogReadLatency = d.GetField <long?>("LogReadLatency"),
LogWriteLatency = d.GetField <long?>("LogWriteLatency"),
}).ToList();
grid.Count = gridData.Count();
grid.Data = gridData.AsQueryable();
if (0 < gridConditions.StartRow)
{
grid.Data = grid.Data.Skip(gridConditions.StartRow - 1);
}
if (0 < gridConditions.EndRow)
{
grid.Data = grid.Data.Take(gridConditions.EndRow - gridConditions.StartRow + 1);
}
return(grid);
}
public virtual GeneralCheckGrid <EnvironmentCheckDatabaseDetails> DatabaseDetails(GridConditions gridConditions, EnvironmentCheckDatabaseFilterConditions filterConditions, EnvironmentCheckDatabaseFilterOperands filterOperands)
{
var grid = new GeneralCheckGrid <EnvironmentCheckDatabaseDetails>();
var dt = this.environmentCheckRepository.GetDatabaseDetails(gridConditions, filterConditions, filterOperands);
var gridData = (from DataRow d in dt.Rows
select new EnvironmentCheckDatabaseDetails
{
AdHocWorkLoad = d.Field <Int32?>("AdHocWorkLoad") ?? 0,
LastSQLRestart = d.Field <DateTime?>("LastSQLRestart") ?? DateTime.MinValue,
MaxDegreeOfParallelism = d.Field <Int32?>("MaxDegreeOfParallelism") ?? 0,
MaxServerMemory = Convert.ToDouble(d["MaxServerMemory"]),
ServerName = d.Field <String>("ServerName"),
SQLVersion = d.Field <String>("SQLVersion"),
TempDBDataFiles = d.Field <Int32?>("TempDBDataFiles") ?? 0,
}).ToList();
grid.Count = gridData.Count();
grid.Data = gridData.AsQueryable();
if (0 < gridConditions.StartRow)
{
grid.Data = grid.Data.Skip(gridConditions.StartRow - 1);
}
if (0 < gridConditions.EndRow)
{
grid.Data = grid.Data.Take(gridConditions.EndRow - gridConditions.StartRow + 1);
}
return(grid);
}
public virtual GeneralCheckGrid <EnvironmentCheckServerDetails> ServerDetails(GridConditions gridConditions, EnvironmentCheckServerFilterConditions filterConditions, EnvironmentCheckServerFilterOperands filterOperands)
{
var grid = new GeneralCheckGrid <EnvironmentCheckServerDetails>();
var dt = this.environmentCheckRepository.GetServerDetails(gridConditions, filterConditions, filterOperands);
var gridData = (from DataRow d in dt.Rows
select new EnvironmentCheckServerDetails
{
Hyperthreaded = d.Field <Boolean>("Hyperthreaded"),
LogicalProcessors = d.Field <Int32>("LogicalProcessors"),
OSName = d.Field <String>("OSName"),
OSVersion = d.Field <String>("OSVersion"),
ServerName = d.Field <String>("ServerName"),
}).ToList();
grid.Count = gridData.Count();
grid.Data = gridData.AsQueryable();
if (0 < gridConditions.StartRow)
{
grid.Data = grid.Data.Skip(gridConditions.StartRow - 1);
}
if (0 < gridConditions.EndRow)
{
grid.Data = grid.Data.Take(gridConditions.EndRow - gridConditions.StartRow + 1);
}
return(grid);
}
public virtual GeneralCheckGrid <EnvironmentCheckRecommendation> Recommendations(GridConditions gridConditions, EnvironmentCheckRecommendationFilterConditions filterConditions)
{
var grid = new GeneralCheckGrid <EnvironmentCheckRecommendation>();
var dt = this.environmentCheckRepository.GetRecomendations(gridConditions, filterConditions);
var gridData = (from DataRow d in dt.Rows
select new EnvironmentCheckRecommendation
{
Recommendation = d.Field <String>("Recommendation"),
Scope = d.Field <String>("Scope"),
Section = d.Field <String>("Section"),
Status = d.Field <String>("Status"),
Description = d.Field <String>("Description"),
Name = d.Field <String>("Name"),
Value = d.Field <String>("Value"),
}).ToList();
grid.Count = gridData.Count();
grid.Data = gridData.AsQueryable();
if (0 < gridConditions.StartRow)
{
grid.Data = grid.Data.Skip(gridConditions.StartRow - 1);
}
if (0 < gridConditions.EndRow)
{
grid.Data = grid.Data.Take(gridConditions.EndRow - gridConditions.StartRow + 1);
}
return(grid);
}
public async Task GenerateCSV_Success()
{
//Arrange
var queryParams = new List <KeyValuePair <string, string> >();
this.requestServiceMock.Setup(mock => mock.GetQueryParams(this.maintenanceWindowSchedulerController.Request))
.Returns(queryParams);
var windows = new List <MaintenanceWindow>
{
};
var grid = new GeneralCheckGrid <MaintenanceWindow>
{
Data = windows.AsQueryable()
};
this.maintenanceWindowSchedulingServiceMock.Setup(mock => mock.GetFilteredMaintenanceWindowsAsync(It.IsAny <MaintenanceWindowDataTableQuery>()))
.ReturnsAsync(grid);
//Act
var result = await this.maintenanceWindowSchedulerController.GenerateCSV();
//Assert
Assert.That(result, Is.Not.Null);
Assert.That(result.StatusCode, Is.EqualTo(HttpStatusCode.OK));
}
public async Task GetFilteredMaintenanceWindows_Success()
{
//Arrange
var queryParams = new List <KeyValuePair <string, string> >();
var windows = new List <MaintenanceWindow>
{
new MaintenanceWindow
{
StartTime = DateTime.UtcNow,
EndTime = DateTime.UtcNow.AddHours(1),
Reason = MaintenanceWindowReason.Other,
Comments = "Unit Test"
}
};
var grid = new GeneralCheckGrid <MaintenanceWindow>
{
Data = windows.AsQueryable()
};
this.requestServiceMock.Setup(mock => mock.GetQueryParams(this.maintenanceWindowSchedulerController.Request))
.Returns(queryParams);
this.maintenanceWindowSchedulingServiceMock.Setup(mock => mock.GetFilteredMaintenanceWindowsAsync(It.IsAny <MaintenanceWindowDataTableQuery>()))
.ReturnsAsync(grid);
//Act
var result = await this.maintenanceWindowSchedulerController.GetListOfSchedules();
//Assert
Assert.That(result, Is.Not.Null);
}
