Changeset 11252 for branches/HiveStatistics/sources/HeuristicLab.Services.Hive.Statistics/3.3/Controllers/ChartDataController.cs
- Timestamp:
- 07/31/14 16:37:29 (10 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/HiveStatistics/sources/HeuristicLab.Services.Hive.Statistics/3.3/Controllers/ChartDataController.cs
r11246 r11252 92 92 } 93 93 94 public JsonResult CurrentCpuUtilization() 95 { 96 using (var db = new HiveDataContext(Settings.Default.HeuristicLab_Hive_LinqConnectionString)) 97 { 98 var currentCpuUtil = (from client in db.FactClientInfos 99 join clients in db.DimClients 100 on client.ClientId equals clients.Id 101 where clients.ExpirationTime == null 102 select new { client.ClientId, client.CpuUtilization, client.Time }) 103 .OrderBy(c => c.Time).GroupBy(c => c.ClientId).ToList(); 104 105 List<double> result = new List<double>(); 106 result.Add(Math.Round(currentCpuUtil.Average(s => s.Last().CpuUtilization), 2)); 107 108 return Json(result, JsonRequestBehavior.AllowGet); 109 } 110 } 111 94 112 public JsonResult CurrentCores() 95 113 { … … 97 115 { 98 116 var currentCores = (from client in db.FactClientInfos 99 select new { client.NumTotalCores, client.NumUsedCores }) 100 .ToList(); 117 join clients in db.DimClients 118 on client.ClientId equals clients.Id 119 where clients.ExpirationTime == null 120 select new { client.ClientId, client.NumTotalCores, client.NumUsedCores, client.Time }) 121 .OrderBy(c => c.Time).GroupBy(c => c.ClientId).ToList(); 101 122 102 123 List<int> result = new List<int>(); 103 result.Add(currentCores.Sum(c => c. NumTotalCores));104 result.Add(currentCores.Sum(s => s. NumUsedCores));124 result.Add(currentCores.Sum(c => c.Last().NumTotalCores)); 125 result.Add(currentCores.Sum(s => s.Last().NumUsedCores)); 105 126 106 127 return Json(result, JsonRequestBehavior.AllowGet); … … 108 129 } 109 130 110 public JsonResult CurrentCpuUtilization()111 {112 using (var db = new HiveDataContext(Settings.Default.HeuristicLab_Hive_LinqConnectionString))113 {114 var currentCpuUtil = (from client in db.FactClientInfos115 select new { client.CpuUtilization })116 .ToList();117 118 List<double> result = new List<double>();119 result.Add(Math.Round(currentCpuUtil.Average(s => s.CpuUtilization), 2));120 121 return Json(result, JsonRequestBehavior.AllowGet);122 }123 }124 125 131 public JsonResult CurrentMemory() 126 132 { … … 128 134 { 129 135 var currentMemory = (from client in db.FactClientInfos 130 select new { client.TotalMemory, client.UsedMemory }) 131 .ToList(); 136 join clients in db.DimClients 137 on client.ClientId equals clients.Id 138 where clients.ExpirationTime == null 139 select new { client.ClientId, client.TotalMemory, client.UsedMemory, client.Time }) 140 .OrderBy(c => c.Time).GroupBy(c => c.ClientId).ToList(); 132 141 133 142 List<int> result = new List<int>(); 134 result.Add(currentMemory.Sum(c => c. TotalMemory)/1000);135 result.Add(currentMemory.Sum(s => s. UsedMemory)/1000);143 result.Add(currentMemory.Sum(c => c.Last().TotalMemory)/1000); 144 result.Add(currentMemory.Sum(s => s.Last().UsedMemory)/1000); 136 145 137 146 return Json(result, JsonRequestBehavior.AllowGet);
Note: See TracChangeset
for help on using the changeset viewer.