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