public ActionResult History(int id)
{
Db_objects obj = repo_.GetObjectById(id);
if (obj == null)
{
return(HttpNotFound());
}
return(View(obj));
}
public ActionResult ViewParameters(int id)
{
Db_objects obj = repo_.GetObjectById(id);
if (obj == null)
{
return(HttpNotFound());
}
//ExternalRepository ins = new ExternalRepository(ConfigurationManager.ConnectionStrings["Data"].ConnectionString);
//MethodResult res = ins.InsertNewRow(DateTime.Now, "123", new Random(DateTime.Now.Second).NextDouble() * 100, new Random(DateTime.Now.Second).NextDouble() * 10, new Random(DateTime.Now.Second).NextDouble() * 10, new Random(DateTime.Now.Second).NextDouble() * 10, new Random(DateTime.Now.Second).NextDouble() * 200, new Random(DateTime.Now.Second).NextDouble() * 200, new Random(DateTime.Now.Second).NextDouble() * 200, new Random(DateTime.Now.Second).NextDouble() * 100, new Random(DateTime.Now.Second).NextDouble() * 1100,"",null,0);
return(View(obj));
}
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 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("При формировании отчета возникли ошибки. обратитесь к разработчику."));
}
}
