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));
}
