public JsonResult GetDataBySmallPeriod(string identity) { DateTime start = DateTime.Now; DateTime end = DateTime.Now; double interval; EWdata jsonData = new EWdata(); jsonData.EndDate = end; jsonData.StartDate = start; try { if (!Double.TryParse(ConfigurationManager.AppSettings["dataInterval"], NumberStyles.Any, CultureInfo.GetCultureInfo("en-US").NumberFormat, out interval)) { interval = 4; // по умолчанию 4 часов } start = end.AddHours(-interval); jsonData.StartDate = start; IEnumerable <PumpParameters> data = repo_.GetPumpParamsByIdentityAndDate(identity, start, end); IEnumerable <PumpParameters> temp = data.OrderByDescending(x => x.RecvDate); jsonData.DataTable = temp.ToList(); } catch (Exception ex) { loger.LogToFile(Utilite.CreateDefaultLogMessage(User.Identity.Name, "error", ex.Message + " " + ex.StackTrace)); } return(Json(jsonData, JsonRequestBehavior.AllowGet)); }
public JsonResult GetByPeriod(string identity, DateTime start_, string parameterGraph = "Amperage1") { DateTime end = start_.AddHours(1); IEnumerable <ElectricAndWaterParams> data = repo_.GetPumpParamsByIdentityAndDate(identity, start_, end); EWdata jsonData = new EWdata(); jsonData.StartDate = start_; jsonData.EndDate = end; IEnumerable <ElectricAndWaterParams> temp = data.OrderBy(x => x.RecvDate); jsonData.DataTable = temp.ToList(); PropertyInfo infoprop = (typeof(ElectricAndWaterParams)).GetProperty(parameterGraph); jsonData.DataGraph = temp.Select(x => new DataForVisual() { RecvDate = x.RecvDate, Value = (double)infoprop.GetValue(x) }).ToList(); return(Json(jsonData, JsonRequestBehavior.AllowGet)); }
public JsonResult GetDataBySmallPeriod(string identity, string parameterGraph) { DateTime end = DateTime.Now; double interval = 1; // 1 час для построения графика int interval_table = 30; // 30 мин для данных try { interval = Convert.ToDouble(ConfigurationManager.AppSettings["DataVisualInterval"], CultureInfo.GetCultureInfo("en-US").NumberFormat); interval_table = Convert.ToInt32(ConfigurationManager.AppSettings["DataTableInterval"], CultureInfo.GetCultureInfo("en-US").NumberFormat); } catch (Exception ex) { LogMessage message = new LogMessage() { MessageDate = DateTime.Now, MessageType = "error", MessageText = ex.Message + ex.StackTrace }; loger.LogToFile(message); loger.LogToDatabase(message); interval = 1; interval_table = 30; } DateTime start = end.AddHours(-interval); IEnumerable <ElectricAndWaterParams> data = repo_.GetPumpParamsByIdentityAndDate(identity, start, end); EWdata jsonData = new EWdata(); jsonData.StartDate = start; jsonData.EndDate = end; IEnumerable <ElectricAndWaterParams> temp = data.OrderByDescending(x => x.RecvDate); jsonData.DataTable = temp.Where(x => x.RecvDate > end.AddMinutes(-interval_table)).ToList(); PropertyInfo infoprop = (typeof(ElectricAndWaterParams)).GetProperty(parameterGraph); jsonData.DataGraph = temp.Select(x => new DataForVisual() { RecvDate = x.RecvDate, Value = infoprop.GetValue(x) == null ? 0 : (double)infoprop.GetValue(x) }).ToList(); return(Json(jsonData, JsonRequestBehavior.AllowGet)); }
public JsonResult GetByPeriod(string identity, DateTime start_) { DateTime start = new DateTime(start_.Year, start_.Month, start_.Day, 0, 0, 0); DateTime end = new DateTime(start_.Year, start_.Month, start_.Day, 23, 59, 59); EWdata jsonData = new EWdata(); jsonData.StartDate = start; jsonData.EndDate = end; try { IEnumerable <PumpParameters> data = repo_.GetPumpParamsByIdentityAndDate(identity, start, end); IEnumerable <PumpParameters> temp = data.OrderBy(x => x.RecvDate); jsonData.DataTable = temp.ToList(); } catch (Exception ex) { loger.LogToFile(Utilite.CreateDefaultLogMessage(User.Identity.Name, "error", ex.Message + " " + ex.StackTrace)); } return(Json(jsonData, JsonRequestBehavior.AllowGet)); }