public void GetSystemLoadServerDetails(LoadViewColumns sortColumn) { //Arrange var gridConditions = new GridConditions(); var filterConditions = new LoadViewFilterConditions(); var filterOperands = new LoadViewFilterOperands(); //Grid conditions gridConditions.SortColumn = sortColumn.ToString(); gridConditions.SortDirection = "ASC"; gridConditions.TimezoneOffset = 0; gridConditions.StartRow = 1; gridConditions.EndRow = 25; //Filter conditions filterConditions.Server = ""; filterConditions.ServerType = ""; //Filter operands filterOperands.OverallScore = FilterOperand.Equals; filterOperands.CPUUtilizationScore = FilterOperand.Equals; filterOperands.RAMUtilizationScore = FilterOperand.Equals; filterOperands.MemorySignalScore = FilterOperand.Equals; filterOperands.WaitsScore = FilterOperand.Equals; filterOperands.VirtualLogFilesScore = FilterOperand.Equals; filterOperands.LatencyScore = FilterOperand.Equals; //Page-level filters gridConditions.StartDate = DateTime.Now.AddYears(-1); gridConditions.EndDate = DateTime.Now.AddDays(1); //Act var result = this.reportRepository.GetSystemLoadServerDetails(gridConditions, filterConditions, filterOperands); //Assert Assert.That(result, Is.Not.Null); Assert.That(result, Is.Not.Empty); }
public virtual LoadViewGrid ServerHours(GridConditions gridConditions, LoadViewFilterConditions filterConditions, LoadViewFilterOperands filterOperands) { var grid = new LoadViewGrid(); var dt = this.reportRepository.GetSystemLoadServerDetails(gridConditions, filterConditions, filterOperands); if (dt.Count > 1) { var searchUsers = dt[0]; grid.Data = (from DataRow d in searchUsers.Rows select new SystemLoadServerHourInfo { Index = d.Field <int>("RowNumber"), ServerId = d.Field <int>("ServerArtifactId"), Server = d.Field <string>("Server"), ServerType = d.Field <string>("ServerType"), SummaryDayHour = d.Field <DateTime>("SummaryDayHour"), OverallScore = d.Field <int?>("Score").GetValueOrDefault(100), CPUScore = d.Field <int?>("CPUScore").GetValueOrDefault(100), RAMScore = d.Field <int?>("RAMScore").GetValueOrDefault(100), MemorySignalStateScore = d.Field <int?>("MemorySignalStateScore").GetValueOrDefault(100), MemorySignalStateRatio = d.Field <int?>("MemorySignalStateRatio").GetValueOrDefault(0), Pageouts = d.Field <int?>("Pageouts").GetValueOrDefault(0), WaitsScore = d.Field <int?>("WaitsScore").GetValueOrDefault(100), VirtualLogFilesScore = d.Field <int?>("VirtualLogFilesScore").GetValueOrDefault(100), MaxVirtualLogFiles = d.Field <int?>("MaxVirtualLogFiles").GetValueOrDefault(0), LatencyScore = d.Field <int?>("LatencyScore").GetValueOrDefault(100), HighestLatencyDatabase = d.Field <string>("HighestLatencyDatabase"), ReadLatencyMs = d.Field <int?>("ReadLatencyMs").GetValueOrDefault(0), WriteLatencyMs = d.Field <int?>("WriteLatencyMs").GetValueOrDefault(0), IsDataFile = d.Field <bool?>("IsDataFile").GetValueOrDefault(false), IsActiveWeeklySample = d.Field <bool>("IsActiveArrivalRateSample") }).AsQueryable(); var resultInfo = dt[1]; grid.Count = resultInfo.Rows.Count > 0 ? resultInfo.Rows[0].Field <int?>("FilteredCount").GetValueOrDefault(0) : 0; } return(grid); }
public SystemLoadServerViewModel() { GridConditions = new GridConditions(); FilterConditions = new LoadViewFilterConditions(); FilterOperands = new LoadViewFilterOperands(); }