public void GetUptimeHours(UptimeViewColumns sortColumn) { // Arrange var gridConditions = new GridConditions(); var filterConditions = new UptimeViewFilterConditions(); var filterOperands = new UptimeViewFilterOperands(); //Grid conditions gridConditions.SortColumn = sortColumn.ToString(); gridConditions.SortDirection = "ASC"; gridConditions.TimezoneOffset = 0; gridConditions.StartRow = 1; gridConditions.EndRow = 25; // Act var result = this.reportRepository.GetUptimeHours(gridConditions, filterConditions, filterOperands); // Assert Assert.That(result, Is.Not.Null); Assert.That(result, Is.Not.Empty); }
public UptimeReportViewModel() { GridConditions = new GridConditions(); FilterConditions = new UptimeViewFilterConditions(); FilterOperands = new UptimeViewFilterOperands(); }
public virtual UptimeViewGrid UptimeHours(GridConditions gridConditions, UptimeViewFilterConditions filterConditions, UptimeViewFilterOperands filterOperands) { var grid = new UptimeViewGrid(); var dt = this.reportRepository.GetUptimeHours(gridConditions, filterConditions, filterOperands); if (dt.Count > 1) { var searchUsers = dt[0]; grid.Data = (from DataRow d in searchUsers.Rows select new UptimeReportHourInfo { Index = d.Field <int>("RowNumber"), SummaryDayHour = d.Field <DateTime?>("SummaryDayHour").GetValueOrDefault(DateTime.UtcNow), Score = d.Field <int?>("Score").GetValueOrDefault(0), Status = d.Field <string>("Status"), Uptime = (double)d.Field <decimal?>("Uptime").GetValueOrDefault(100), AffectedByMaintenanceWindow = d.Field <bool>("AffectedByMaintenanceWindow") }).AsQueryable(); var resultInfo = dt[1]; grid.Count = resultInfo.Rows.Count > 0 ? resultInfo.Rows[0].Field <int?>("FilteredCount").GetValueOrDefault(0) : 0; } return(grid); }