public EnvironmentCheckViewModel()
{
GridConditions = new GridConditions();
RecommendationFilterConditions = new EnvironmentCheckRecommendationFilterConditions();
ServerFilterConditions = new EnvironmentCheckServerFilterConditions();
ServerFilterOperands = new EnvironmentCheckServerFilterOperands();
DatabaseFilterConditions = new EnvironmentCheckDatabaseFilterConditions();
DatabaseFilterOperands = new EnvironmentCheckDatabaseFilterOperands();
}
public void GetServerDetails(EnvironmentCheckServerColumns sortColumn)
{
//Arrange
var gridCond = new GridConditions {
SortColumn = sortColumn.ToString(), SortDirection = "asc",
};
var filterConds = new EnvironmentCheckServerFilterConditions {
};
var filterOps = new EnvironmentCheckServerFilterOperands {
};
//Act
var result = ecRepo.GetServerDetails(gridCond, filterConds, filterOps);
//Assert
Assert.That(result, Is.Not.Null);
}
public DataTable GetServerDetails(GridConditions gridConditions, EnvironmentCheckServerFilterConditions filterConditions, EnvironmentCheckServerFilterOperands filterOperands)
{
using (var conn = (SqlConnection)this.connectionFactory.GetEddsPerformanceConnection())
{
var parameters = new[] {
//Grid conditions
//Filter conditions
new SqlParameter {
ParameterName = "@serverNameFilter", DbType = DbType.String, Value = GetNullableDBValue(filterConditions.ServerName)
},
new SqlParameter {
ParameterName = "@osnameFilter", DbType = DbType.String, Value = GetNullableDBValue(filterConditions.OSName)
},
new SqlParameter {
ParameterName = "@osversionFilter", DbType = DbType.String, Value = GetNullableDBValue(filterConditions.OSVersion)
},
new SqlParameter {
ParameterName = "@logicalProcessorsFilter", DbType = DbType.String, Value = GetNullableDBValue(filterConditions.LogicalProcessors)
},
new SqlParameter {
ParameterName = "@hypterthreadedFilter", DbType = DbType.String, Value = GetNullableDBValue(filterConditions.Hyperthreaded)
},
//Filter operands
new SqlParameter {
ParameterName = "@logicalProcessorsOperator", DbType = DbType.Int32, Value = (int)filterOperands.LogicalProcessors
},
//Page-level filters
};
var data = SqlHelper.ExecuteDataset(conn, CommandType.Text, Properties.Resources.ReadEnvironmentCheckServerDetails, parameters);
if (false == String.IsNullOrEmpty(gridConditions.SortColumn) && false == String.IsNullOrEmpty(gridConditions.SortDirection))
{
String sortExpression = String.Format("{0} {1}", gridConditions.SortColumn, gridConditions.SortDirection);
data.Tables[0].DefaultView.Sort = sortExpression;
return(data.Tables[0].DefaultView.ToTable());
}
return(data.Tables[0]);
}
}
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);
}
