コード例 #1
0
 private string GetDayOfWeekDownMost(CategoryViewModel category)
 {
     var afterDate = DateTime.Now.AddMonths(-1);
     var downtimeDayOfWeekGroupOfReads = DB.PollCategoryValue
         .Where(p => p.CategoryID == category.PollCategoryID && p.CreatedTime > afterDate && p.Status == PollStatusType.Down)
         .GroupBy(r => SqlFunctions.DatePart("weekday", r.CreatedTime))
         .OrderByDescending(g => g.Count())
         .Select(r=>r.Key)
         .FirstOrDefault();
     var x = downtimeDayOfWeekGroupOfReads != null ? Enum.ToObject(typeof(DayOfWeek), downtimeDayOfWeekGroupOfReads).ToString() : "Tuesday";
     return x;
 }
コード例 #2
0
        private void FillCategoryViewModel(CategoryViewModel categoryViewModel)
        {
            categoryViewModel.MostRecentRead = GetMostRecentRead(categoryViewModel);
            categoryViewModel.StatusMessage = GetStatusMessage(categoryViewModel);
            categoryViewModel.UptimeLast24Hours = GetUptimeForLast24Hours(categoryViewModel);
            categoryViewModel.Uptime30Days = GetUptimeLast30Days(categoryViewModel);
            categoryViewModel.DowntimePercentage = GetDowntimePercentage(categoryViewModel);
            categoryViewModel.DayOfWeek = GetDayOfWeekDownMost(categoryViewModel);
            categoryViewModel.HourOfDay = GetHourOfDayDownTheMost(categoryViewModel);

            categoryViewModel.HasReads = true;
        }
コード例 #3
0
        private int? GetHourOfDayDownTheMost(CategoryViewModel category)
        {
            var afterDate = DateTime.Now.AddMonths(-1);
            var downtimeHour = DB.PollCategoryValue
                .Where(p => p.CategoryID == category.PollCategoryID && p.CreatedTime > afterDate && p.Status == PollStatusType.Down)
                .GroupBy(r => SqlFunctions.DatePart("hour", r.CreatedTime))
                .OrderByDescending(g => g.Count())
                .Select(r => r.Key)
                .FirstOrDefault();

            return downtimeHour ?? 4;
        }
コード例 #4
0
 private decimal GetDowntimePercentage(CategoryViewModel category)
 {
     var afterDate = DateTime.Now.AddMonths(-1);
     var queryForReadsAfterDate = DB.PollCategoryValue.Where(c => c.CategoryID == category.PollCategoryID && c.CreatedTime > afterDate);
     var totalReadings = queryForReadsAfterDate.Count();
     var downReadings = queryForReadsAfterDate.Count(r=>r.Status == PollStatusType.Down);
     return (decimal)downReadings / totalReadings;
 }
コード例 #5
0
        private List<UptimeInTimespan> GetUptimeLast30Days(CategoryViewModel category)
        {
            DateTimeOffset date30DaysAgo = DateTimeOffset.Now.AddDays(-31);

            string sqlFormat = @"
                    select  CAST(CreatedTime as DATE) as T,
                         (select COUNT(0) from PollCategoryValue upValues
                                where CategoryID = '{0}'
                                    AND DAY( CAST(v.CreatedTime as DATE)) = DAY( CAST(upValues.CreatedTime as DATE) )
                                    AND MONTH( CAST(v.CreatedTime as DATE)) = MONTH( CAST(upValues.CreatedTime as DATE) )
                                    AND YEAR( CAST(v.CreatedTime as DATE)) = YEAR( CAST(upValues.CreatedTime as DATE) )
                                    AND Status = 1)
                            / CAST( COUNT(0) as decimal(18, 5)) as P
                    from PollCategoryValue v
                    where CategoryID = '{0}'
                        AND CreatedTime >= DATEADD(month, -1, GETDATE())
                    group by CAST(CreatedTime as DATE)
                    order by T";
            string sql = string.Format(sqlFormat, category.PollCategoryID);

            var uptimeStats = DB.Database.SqlQuery<UptimeInTimespan>(sql).ToList();
            return uptimeStats;
        }
コード例 #6
0
 private List<UptimeInTimespan> GetUptimeForLast24Hours(CategoryViewModel category)
 {
     var oneDayAgo = DateTimeOffset.Now.AddDays(-1);
     return DB.PollCategoryValue
                 .Where(v=>v.CategoryID == category.PollCategoryID)
                 .Where(r => r.CreatedTime >= oneDayAgo)
                 .ToList()
                 .GroupBy(p => p.CreatedTime.ToString("MM/dd/yyyy HH"))
                 .Select(pollValuesInHour =>
                 {
                     var singleTime = pollValuesInHour.First().CreatedTime;
                     return new UptimeInTimespan()
                     {
                         P = (decimal)pollValuesInHour.Count(v => v.Status == PollStatusType.Up) / pollValuesInHour.Count(),
                         T = singleTime.Date.AddHours(singleTime.Hour)
                     };
                 })
                 .ToList();
 }
コード例 #7
0
        private string GetStatusMessage(CategoryViewModel matchingCategoryViewModel)
        {
            var statusMessage = "";
            var lastChange = DB.PollCategoryValue.Where(v=>v.CategoryID == matchingCategoryViewModel.PollCategoryID)
                .Where(p => (p.Status == PollStatusType.Down && matchingCategoryViewModel.MostRecentRead.Status != PollStatusType.Down) ||
                    (p.Status == PollStatusType.Up && matchingCategoryViewModel.MostRecentRead.Status != PollStatusType.Up))
                .OrderByDescending(p => p.CreatedTime)
                .FirstOrDefault();

            if (lastChange != null)
            {
                TimeSpan timeSinceLastStatusChange = lastChange.CreatedTime.Subtract(DateTime.Now);
                statusMessage = ConvertTimeSpanToFriendlyText(timeSinceLastStatusChange);
            }
            return statusMessage;
        }
コード例 #8
0
 private PollCategoryValueJSON GetMostRecentRead(CategoryViewModel category)
 {
     var recentReadingValue = DB.PollCategoryValue
         .Where(v => v.CategoryID == category.PollCategoryID)
         .OrderByDescending(p => p.CreatedTime)
         .FirstOrDefault();
     if (recentReadingValue == null)
         return null;
     return new PollCategoryValueJSON(recentReadingValue);
 }