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); }