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("При формировании отчета возникли ошибки. обратитесь к разработчику."));
}
}
