private void fillList() { RoomsDetection roomsDetection = new RoomsDetection(); if (_context.MovementSekv.Any()) { var movSekvList = _context.MovementSekv.ToList(); foreach (var movSekv in movSekvList) { DateTime convertedDate = DateTime.Parse(movSekv.TimeStamp); Izby izba = null; String izbaName = ""; try { izba = _context.Rooms.Where(t => t.IzbaID == movSekv.IzbyFK).First(); izbaName = izba.Nazov; } catch (Exception e) { izbaName = "Vonku"; } string alert = "NA"; if (movSekv.Upozornenie_Cas != 0) { alert = "Čas"; } else if (movSekv.Upozornenie_Hranica != 0) { alert = "Hranica"; } MovementObj movObj = new MovementObj { PohId = movSekv.PohSekvId, RoomName = izbaName, Alert = alert, LongDate = convertedDate.ToLongDateString(), Date = convertedDate.ToShortDateString(), Time = convertedDate.ToLongTimeString(), Duration = movSekv.Cas_Zotrvania, xValue = movSekv.Xhodnota, yValue = movSekv.Yhodnota }; SequenceList.Add(movObj); } fillPageWithSequence(SequenceList.Last()); } else { MovAlert = "Neexistuje žiadna sekvencia"; } SequenceList = new ObservableCollection <MovementObj>(SequenceList.Reverse()); }
private void fillList() { int low = 0; int height = 0; int middle = 0; int ok = 0; double lowMin = 0; double heightMin = 0; double middleMin = 0; double okMin = 0; double lowMinDay = 0; double heightMinDay = 0; double middleMinDay = 0; double okMinDay = 0; int lowDay = 0; int heightDay = 0; int middleDay = 0; int okDay = 0; if (_context.TemperatureSekv.Any()) { var listTemp = _context.TemperatureSekv.ToList(); Helpers.SekvenceHelper.LimitCheck loader = new Helpers.SekvenceHelper.LimitCheck(); //DateTime actualForSummary = DateTime.Parse("2017-01-01T12:04:19Z"); DateTime actualForSummary = DateTime.Now; foreach (var t in listTemp) { DateTime convertedDate = DateTime.Parse(t.TimeStart); String durationTime = null; String endTimeString = "NA"; String endDateString = ""; double time = 0; try { DateTime endtime = DateTime.Parse(t.TimeClose); time = (endtime - convertedDate).TotalMinutes; var x = time - Math.Truncate(time); durationTime = Math.Truncate(time).ToString() + " min " + Math.Round(x * 60).ToString() + " sec"; endDateString = endtime.ToLongDateString(); endTimeString = endtime.ToLongTimeString(); } catch (Exception e) { System.Diagnostics.Debug.WriteLine("Exception parse date " + e.ToString()); durationTime = "NA"; } if (actualForSummary <= convertedDate.AddHours(12)) { switch (t.Upozornenie) { case 0: ok++; okMin += time; break; case 1: low++; lowMin += time; break; case -1: low++; lowMin += time; break; case 2: middle++; middleMin += time; break; case 3: height++; heightMin += time; break; } } if (actualForSummary <= convertedDate.AddHours(24)) { switch (t.Upozornenie) { case 0: okDay++; okMinDay += time; break; case 1: lowDay++; lowMinDay += time; break; case -1: lowDay++; lowMinDay += time; break; case 2: middleDay++; middleMinDay += time; break; case 3: heightDay++; heightMinDay += time; break; } } TemperatureObj tem = new TemperatureObj() { TempId = t.TeplSekvId, Value = "~" + t.Sekvencia.ToString("n2") + " °C", LongDate = convertedDate.ToLongDateString(), Date = convertedDate.ToShortDateString(), Time = convertedDate.ToLongTimeString(), DateEnd = endDateString, TimeEnd = endTimeString, Duration = durationTime, Upozornenie = t.Upozornenie, Alert = loader.getStringValuePulseAndTempLimit(t.Upozornenie) }; SequenceList.Add(tem); } fillPageWithSequence(SequenceList.Last()); } else { TempAlert = "Neexistuje žiadna sekvencia"; } HeightTwelve = "Vysoké: ~" + Math.Truncate(heightMin).ToString() + " min"; MiddleTwelve = "Stredné: ~" + Math.Truncate(middleMin).ToString() + " min"; LowTwelve = "Slabé: ~" + Math.Truncate(lowMin).ToString() + " min"; OkTwelve = "OK: ~" + Math.Truncate(okMin).ToString() + " min"; HeightDay = HeightTwelve = "Vysoké: ~" + Math.Truncate(heightMinDay).ToString() + " min"; MiddleDay = "Stredné: ~" + Math.Truncate(middleMinDay).ToString() + " min"; LowDay = "Slabé: ~" + Math.Truncate(lowMinDay).ToString() + " min"; OkDay = "OK: ~" + Math.Truncate(okMinDay).ToString() + " min"; // System.Diagnostics.Debug.WriteLine("/////CAS: " + okMin + " " + lowMin + " " + middleMin + " " + heightMin + " " + Math.Truncate(okMin).ToString()); SequenceList = new ObservableCollection <TemperatureObj>(SequenceList.Reverse()); }