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);
        }
Beispiel #2
0
        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();
 }