public EnvironmentCheckViewModel() { GridConditions = new GridConditions(); RecommendationFilterConditions = new EnvironmentCheckRecommendationFilterConditions(); ServerFilterConditions = new EnvironmentCheckServerFilterConditions(); ServerFilterOperands = new EnvironmentCheckServerFilterOperands(); DatabaseFilterConditions = new EnvironmentCheckDatabaseFilterConditions(); DatabaseFilterOperands = new EnvironmentCheckDatabaseFilterOperands(); }
public void GetDatabaseDetails(EnvironmentCheckDatabaseColumns sortColumn) { //Arrange var gridCond = new GridConditions { SortColumn = sortColumn.ToString(), SortDirection = "asc", }; var filterConds = new EnvironmentCheckDatabaseFilterConditions { }; var filterOps = new EnvironmentCheckDatabaseFilterOperands { }; //Act var result = ecRepo.GetDatabaseDetails(gridCond, filterConds, filterOps); //Assert Assert.That(result, Is.Not.Null); }
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 DataTable GetDatabaseDetails(GridConditions gridConditions, EnvironmentCheckDatabaseFilterConditions filterConditions, EnvironmentCheckDatabaseFilterOperands 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 = "@sqlVersionFilter", DbType = DbType.String, Value = GetNullableDBValue(filterConditions.SQLVersion) }, new SqlParameter { ParameterName = "@adhocWorkloadFilter", DbType = DbType.String, Value = GetNullableDBValue(filterConditions.AdHocWorkload) }, new SqlParameter { ParameterName = "@maxServerMemoryFilter", DbType = DbType.String, Value = GetNullableDBValue(filterConditions.MaxServerMemory) }, new SqlParameter { ParameterName = "@maxdegreeOfParallelismFilter", DbType = DbType.String, Value = GetNullableDBValue(filterConditions.MaxDegreeOfParallelism) }, new SqlParameter { ParameterName = "@tempDBDataFilesFilter", DbType = DbType.String, Value = GetNullableDBValue(filterConditions.tempDBDataFiles) }, new SqlParameter { ParameterName = "@lastSQLRestartFilter", DbType = DbType.String, Value = GetNullableDBValue(filterConditions.LastSqlRestart) }, //Filter operands new SqlParameter { ParameterName = "@adhocWorkloadOperator", DbType = DbType.Int32, Value = (int)filterOperands.AdHocWorkload }, new SqlParameter { ParameterName = "@maxServerMemoryOperator", DbType = DbType.Int32, Value = (int)filterOperands.MaxServerMemory }, new SqlParameter { ParameterName = "@maxDegreeOfParallelismOperator", DbType = DbType.Int32, Value = (int)filterOperands.MaxDegreeOfParallelism }, new SqlParameter { ParameterName = "@tempDBDataFilesOperator", DbType = DbType.Int32, Value = (int)filterOperands.TempDBDataFiles }, new SqlParameter { ParameterName = "@lastSQLRestartOperator", DbType = DbType.Int32, Value = (int)filterOperands.LastSQLRestart }, //Page-level filters }; var data = SqlHelper.ExecuteDataset(conn, CommandType.Text, Resources.ReadEnvironmentCheckDatabaseDetails, parameters); if (false == String.IsNullOrEmpty(gridConditions.SortColumn) && false == String.IsNullOrEmpty(gridConditions.SortDirection)) { String sortExpression = $"{gridConditions.SortColumn} {gridConditions.SortDirection}"; data.Tables[0].DefaultView.Sort = sortExpression; return(data.Tables[0].DefaultView.ToTable()); } return(data.Tables[0]); } }