private FilterResult FilterData(UserExperienceService svc, UserExperienceServerViewModel viewModel, bool isDownload, IQualityIndicatorService qualityIndicatorService)
{
var grid = svc.ServerWorkspaces(viewModel.GridConditions, viewModel.FilterConditions, viewModel.FilterOperands);
var aaData = grid.Data.Select(d => new string[] {
$"{d.SummaryDayHour.ToShortDateString()} {d.SummaryDayHour:t}",
isDownload ?
$"{d.Server} ({d.ServerId})"
: string.Format(HoursLinkFormat, d.ServerId, string.Empty, $"{d.Server} ({d.ServerId})"),
isDownload
? d.Score.ToString()
:$"<span class='{qualityIndicatorService.GetCssClassForScore(d.Score, false)}'>{d.Score}</span>",
isDownload ?
$"{d.Workspace} ({d.WorkspaceId})"
: string.Format(HoursLinkFormat, d.ServerId, $"&Workspace={d.WorkspaceId}", $"{d.Workspace} ({d.WorkspaceId})"),
d.TotalLongRunning.ToString(),
d.TotalUsers.ToString(),
d.TotalSearchAudits.ToString(),
d.TotalNonSearchAudits.ToString(),
d.TotalAudits.ToString(),
d.TotalExecutionTime.ToString(),
d.IsActiveWeeklySample ? "Yes" : "No"
}).ToArray();
return(new FilterResult()
{
Data = aaData, TotalRecordCount = grid.Count
});
}
private void Initialize(UserExperienceServerViewModel model, string serverParam)
{
if (!string.IsNullOrEmpty(serverParam))
{
model.FilterConditions.Server = serverParam;
}
var json = new JavaScriptSerializer().Serialize(model);
VarscatState.Value = json;
TimezoneOffset.Value = RequestService.GetTimezoneOffset(this.Request).ToString();
SampleStart.Value = base.GlassInfo.MinSampleDate.GetValueOrDefault(DateTime.UtcNow).ToString("s");
}
/// <summary>
/// Translates a Server view into grid data
/// </summary>
/// <param name="viewModel"></param>
/// <returns></returns>
private DataTableResponse FetchServerGridData(UserExperienceService svc, UserExperienceServerViewModel viewModel, IQualityIndicatorService qualityIndicatorService)
{
var data = FilterData(svc, viewModel, false, qualityIndicatorService);
var dtResponse = new DataTableResponse()
{
sEcho = string.IsNullOrEmpty(viewModel.GridConditions.sEcho)
? "1"
: viewModel.GridConditions.sEcho,
aaData = data.Data,
recordsTotal = data.Data.Count(),
recordsFiltered = data.TotalRecordCount
};
return(dtResponse);
}
private string FetchFileData(UserExperienceService svc, UserExperienceServerViewModel viewModel, IQualityIndicatorService qualityIndicatorService)
{
var filterResult = FilterData(svc, viewModel, true, qualityIndicatorService);
using (var sw = new System.IO.StringWriter())
{
var heaaderArr = new string[]
{
"Hour", "Server", "Score", "Workspace", "Long-Running Queries", "Total Users", "Total Search Audits",
"Total Non-Search Audits", "Total Audits", "Total Execution Time", "Weekly Sample"
};
sw.WriteLine(string.Join(",", heaaderArr));
foreach (var row in filterResult.Data)
{
sw.WriteCsvSafeLine(row);
}
return(sw.ToString());
}
}
/// <summary>
/// Pulls query parameters from the request and converts them to grid and filter conditions for the Server View
/// </summary>
/// <returns></returns>
protected UserExperienceServerViewModel PopulateServerModelSettings()
{
var model = new UserExperienceServerViewModel();
var queryParams = this.requestService.GetQueryParamsDecoded(Request);
//Grid conditions
model.GridConditions = PopulateCommonGridConditions(queryParams);
var iSortCol = queryParams.FirstOrDefault(k => k.Key == "iSortCol_0");
var sSortDir = queryParams.FirstOrDefault(k => k.Key == "sSortDir_0");
var sortColumn = string.IsNullOrEmpty(iSortCol.Value)
? null
: (ServerViewColumns?)System.Enum.Parse(typeof(ServerViewColumns), iSortCol.Value);
var sortBy = sortColumn?.ToString();
model.GridConditions.SortIndex = iSortCol.Value;
model.GridConditions.SortColumn = sortBy;
model.GridConditions.SortDirection = sSortDir.Value;
//Filter conditions
var hourFilter = queryParams.FirstOrDefault(k => k.Key == "sSearch_0");
var serverFilter = queryParams.FirstOrDefault(k => k.Key == "sSearch_1");
var scoreFilter = queryParams.FirstOrDefault(k => k.Key == "sSearch_2");
var workspaceFilter = queryParams.FirstOrDefault(k => k.Key == "sSearch_3");
var totalLRQFilter = queryParams.FirstOrDefault(k => k.Key == "sSearch_4");
var totalUsersFilter = queryParams.FirstOrDefault(k => k.Key == "sSearch_5");
var totalSearchFilter = queryParams.FirstOrDefault(k => k.Key == "sSearch_6");
var totalNonSearchFilter = queryParams.FirstOrDefault(k => k.Key == "sSearch_7");
var totalAuditFilter = queryParams.FirstOrDefault(k => k.Key == "sSearch_8");
var totalTimeFilter = queryParams.FirstOrDefault(k => k.Key == "sSearch_9");
var weeklyFilter = queryParams.FirstOrDefault(k => k.Key == "sSearch_10");
int totalLRQ, totalUsers, totalSearch, totalNonSearch, totalAudit, score;
Int64 totalTime;
DateTime hour;
model.FilterConditions = new ServerViewFilterConditions()
{
SummaryDayHour = DateTime.TryParse(HttpUtility.UrlDecode(hourFilter.Value), out hour)
? hour
: (DateTime?)null,
Server = serverFilter.Value,
Score = int.TryParse(scoreFilter.Value, out score)
? score
: (int?)null,
TotalLongRunning = int.TryParse(totalLRQFilter.Value, out totalLRQ)
? totalLRQ
: (int?)null,
Workspace = workspaceFilter.Value,
TotalUsers = int.TryParse(totalUsersFilter.Value, out totalUsers)
? totalUsers
: (int?)null,
TotalSearchAudits = int.TryParse(totalSearchFilter.Value, out totalSearch)
? totalSearch
: (int?)null,
TotalNonSearchAudits = int.TryParse(totalNonSearchFilter.Value, out totalNonSearch)
? totalNonSearch
: (int?)null,
TotalAudits = int.TryParse(totalAuditFilter.Value, out totalAudit)
? totalAudit
: (int?)null,
TotalExecutionTime = Int64.TryParse(totalTimeFilter.Value, out totalTime)
? totalTime
: (Int64?)null,
IsActiveWeeklySample = string.IsNullOrEmpty(weeklyFilter.Value)
? null
: (bool?)weeklyFilter.Value.Equals("yes", StringComparison.CurrentCultureIgnoreCase)
};
//Filter operands
System.Enum.TryParse <FilterOperand>(queryParams.FirstOrDefault(k => k.Key == "sOperand_2").Value, out model.FilterOperands.Score);
System.Enum.TryParse <FilterOperand>(queryParams.FirstOrDefault(k => k.Key == "sOperand_4").Value, out model.FilterOperands.TotalLongRunning);
System.Enum.TryParse <FilterOperand>(queryParams.FirstOrDefault(k => k.Key == "sOperand_5").Value, out model.FilterOperands.TotalUsers);
System.Enum.TryParse <FilterOperand>(queryParams.FirstOrDefault(k => k.Key == "sOperand_6").Value, out model.FilterOperands.TotalSearchAudits);
System.Enum.TryParse <FilterOperand>(queryParams.FirstOrDefault(k => k.Key == "sOperand_7").Value, out model.FilterOperands.TotalNonSearchAudits);
System.Enum.TryParse <FilterOperand>(queryParams.FirstOrDefault(k => k.Key == "sOperand_8").Value, out model.FilterOperands.TotalAudits);
System.Enum.TryParse <FilterOperand>(queryParams.FirstOrDefault(k => k.Key == "sOperand_9").Value, out model.FilterOperands.TotalExecutionTime);
return(model);
}
