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