public void GetUserExperienceServerDetails(ServerViewColumns sortColumn) { //Arrange var gridConditions = new GridConditions(); var filterConditions = new ServerViewFilterConditions(); var filterOperands = new ServerViewFilterOperands(); //Grid conditions gridConditions.SortColumn = sortColumn.ToString(); gridConditions.SortDirection = "ASC"; gridConditions.TimezoneOffset = 0; gridConditions.StartRow = 1; gridConditions.EndRow = 25; //Filter conditions filterConditions.Server = ""; filterConditions.Workspace = ""; //Filter operands filterOperands.Score = FilterOperand.Equals; filterOperands.TotalUsers = FilterOperand.Equals; filterOperands.TotalSearchAudits = FilterOperand.Equals; filterOperands.TotalNonSearchAudits = FilterOperand.Equals; filterOperands.TotalLongRunning = FilterOperand.Equals; filterOperands.TotalExecutionTime = FilterOperand.Equals; filterOperands.TotalAudits = FilterOperand.Equals; //Page-level filters gridConditions.StartDate = DateTime.Now.AddYears(-1); gridConditions.EndDate = DateTime.Now.AddDays(1); //Act var result = this.reportRepository.GetUserExperienceServerDetails(gridConditions, filterConditions, filterOperands); //Assert Assert.That(result, Is.Not.Null); Assert.That(result, Is.Not.Empty); }
public UserExperienceServerViewModel() { GridConditions = new GridConditions(); FilterConditions = new ServerViewFilterConditions(); FilterOperands = new ServerViewFilterOperands(); }
public virtual ServerViewGrid ServerWorkspaces(GridConditions gridConditions, ServerViewFilterConditions filterConditions, ServerViewFilterOperands filterOperands) { var grid = new ServerViewGrid(); var dt = this.reportRepository.GetUserExperienceServerDetails(gridConditions, filterConditions, filterOperands); if (dt.Count > 1) { var searchUsers = dt[0]; grid.Data = (from DataRow d in searchUsers.Rows select new UserExperienceServerWorkspaceInfo { Index = d.Field <int>("RowNumber"), ServerId = d.Field <int>("ServerArtifactId"), Server = d.Field <string>("Server"), WorkspaceId = d.Field <int>("CaseArtifactId"), Workspace = d.Field <string>("Workspace"), SummaryDayHour = d.Field <DateTime>("SummaryDayHour"), Score = d.Field <int?>("Score").GetValueOrDefault(0), TotalUsers = d.Field <int?>("TotalUsers").GetValueOrDefault(0), TotalLongRunning = d.Field <int?>("TotalLongRunning").GetValueOrDefault(0), TotalSearchAudits = d.Field <int?>("TotalSearchAudits").GetValueOrDefault(0), TotalNonSearchAudits = d.Field <int?>("TotalNonSearchAudits").GetValueOrDefault(0), TotalAudits = d.Field <int?>("TotalAudits").GetValueOrDefault(0), TotalExecutionTime = d.Field <Int64?>("TotalExecutionTime").GetValueOrDefault(0), 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); }