public EnvironmentCheckViewModel()
{
GridConditions = new GridConditions();
RecommendationFilterConditions = new EnvironmentCheckRecommendationFilterConditions();
ServerFilterConditions = new EnvironmentCheckServerFilterConditions();
ServerFilterOperands = new EnvironmentCheckServerFilterOperands();
DatabaseFilterConditions = new EnvironmentCheckDatabaseFilterConditions();
DatabaseFilterOperands = new EnvironmentCheckDatabaseFilterOperands();
}
public void GetRecomendations(EnvironmentCheckRecommendationColumns sortColumn)
{
//Arrange
var gridCond = new GridConditions {
SortColumn = sortColumn.ToString(), SortDirection = "asc",
};
var filterConds = new EnvironmentCheckRecommendationFilterConditions {
};
//Act
var result = ecRepo.GetRecomendations(gridCond, filterConds);
//Assert
Assert.That(result, Is.Not.Null);
}
/// <summary>
/// Retrieves data for environment check system recommendations
/// </summary>
/// <param name="gridConditions"></param>
/// <param name="filterConditions"></param>
/// <returns></returns>
public DataTable GetRecomendations(GridConditions gridConditions, EnvironmentCheckRecommendationFilterConditions filterConditions)
{
var sortColumn = gridConditions.SortColumn.ToLower() == "status" ? "Severity" : gridConditions.SortColumn;
using (var conn = (SqlConnection)this.connectionFactory.GetEddsPerformanceConnection())
{
var parameters = new[] {
//Filter conditions
new SqlParameter {
ParameterName = "@scopeFilter", DbType = DbType.String, Value = GetNullableDBValue(filterConditions.Scope)
},
new SqlParameter {
ParameterName = "@nameFilter", DbType = DbType.String, Value = GetNullableDBValue(filterConditions.Name)
},
new SqlParameter {
ParameterName = "@descriptionFilter", DbType = DbType.String, Value = GetNullableDBValue(filterConditions.Description)
},
new SqlParameter {
ParameterName = "@statusFilter", DbType = DbType.String, Value = GetNullableDBValue(filterConditions.Status)
},
new SqlParameter {
ParameterName = "@recommendationFilter", DbType = DbType.String, Value = GetNullableDBValue(filterConditions.Recommendation)
},
new SqlParameter {
ParameterName = "@valueFilter", DbType = DbType.String, Value = GetNullableDBValue(filterConditions.Value)
},
new SqlParameter {
ParameterName = "@sectionFilter", DbType = DbType.String, Value = GetNullableDBValue(filterConditions.Section)
},
};
var data = SqlHelper.ExecuteDataset(conn, CommandType.Text, Properties.Resources.ReadEnvironmentCheckRecommendation, parameters);
if (false == String.IsNullOrEmpty(sortColumn) && false == String.IsNullOrEmpty(gridConditions.SortDirection))
{
String sortExpression = String.Format("{0} {1}", sortColumn, gridConditions.SortDirection);
data.Tables[0].DefaultView.Sort = sortExpression;
return(data.Tables[0].DefaultView.ToTable());
}
return(data.Tables[0]);
}
}
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);
}
