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 AllMarkers() { List <Db_objects> devices = new List <Db_objects>(); try { devices = repo.GetAllObjects().ToList(); } catch (Exception ex) { loger.LogToFile(Utilite.CreateDefaultLogMessage(User.Identity.Name, "error", ex.Message + " " + ex.StackTrace)); } return(Json(devices, JsonRequestBehavior.AllowGet)); }
public JsonResult UpdateMarker(Db_objects marker) { int updateCount; try { Db_objects old = repo.GetObjectById(marker.ObjectId); updateCount = repo.UpdateObject(marker); if (updateCount > 0) { loger.LogToFile(Utilite.CreateDefaultLogMessage(User.Identity.Name, "update", "old values: " + new JavaScriptSerializer().Serialize(old) + "; new values: " + new JavaScriptSerializer().Serialize(marker))); } } catch (Exception ex) { loger.LogToFile(Utilite.CreateDefaultLogMessage(User.Identity.Name, "error", ex.Message + " " + ex.StackTrace)); updateCount = -1; } return(Json(updateCount)); }
public ActionResult GetMarker(int ObjectId) { try { Db_objects marker = repo.GetObjectById(ObjectId); if (marker != null) { return(Json(marker, JsonRequestBehavior.AllowGet)); } else { return(HttpNotFound()); } } catch (Exception ex) { loger.LogToFile(Utilite.CreateDefaultLogMessage(User.Identity.Name, "error", ex.Message + " " + ex.StackTrace)); return(HttpNotFound()); } }
public JsonResult DeleteMarker(int ObjectId) { int deleteCount; try { Db_objects deleted = repo.GetObjectById(ObjectId); deleteCount = repo.DeleteObjectById(ObjectId); if (deleteCount > 0) { loger.LogToFile(Utilite.CreateDefaultLogMessage(User.Identity.Name, "delete", new JavaScriptSerializer().Serialize(deleted))); } } catch (Exception ex) { loger.LogToFile(Utilite.CreateDefaultLogMessage(User.Identity.Name, "error", ex.Message + " " + ex.StackTrace)); deleteCount = -1; } return(Json(deleteCount)); }
public JsonResult InsertNewMarker(Db_objects marker) { int insertedId; try { insertedId = repo.InsertObject(marker); // логирование if (insertedId > 0) { loger.LogToFile(Utilite.CreateDefaultLogMessage(User.Identity.Name, "insert", new JavaScriptSerializer().Serialize(marker))); } } catch (Exception ex) { loger.LogToFile(Utilite.CreateDefaultLogMessage(User.Identity.Name, "error", ex.Message + " " + ex.StackTrace)); insertedId = -1; } return(Json(insertedId)); }
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)); }
public ActionResult GenerateReport(ReportSource rc, String ReportType) { if (!ModelState.IsValid) { return(View("ReportIndex", rc)); } List <ByHourStat> values = new List <ByHourStat>(); try { Db_objects m = repo_.GetObjectByIdentity(rc.Identity); if (m != null) { ViewBag.ObjectName = m.Address; } else { ViewBag.ObjectName = "-"; } if (ReportType.IndexOf("Месячный", StringComparison.OrdinalIgnoreCase) >= 0) { values = repo_.GetStatByDays(rc.DateParam, rc.Identity).ToList(); return(View("StatByMonth", values)); } else { values = repo_.GetStatByHour(rc.DateParam, rc.Identity).ToList(); return(View("StatByDay", values)); } } catch (Exception ex) { loger.LogToFile(Utilite.CreateDefaultLogMessage(User.Identity.Name, "error", ex.Message + " " + ex.StackTrace)); return(Content("При формировании отчета возникли ошибки. обратитесь к разработчику.")); } }