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 void AddPathToRegistryTest()
{
string programName = "5nine Manager for Hyper-V";
string path = "c:\\";
Utilite.AddPathToRegistry(programName, path);
}
private void InstallGpuFeature()
{
try
{
if (MessageBox.Show("Want install Remote-Desktop-Services and RDS-Virtualization feature?", "Install GPU feature", MessageBoxButtons.YesNo,
MessageBoxIcon.Information, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
{
List <InstallResult> installResult = Utilite.InstallGPUFeature();
int showFlag = 0;
if (installResult.Where(s => s.RestartNeeded == true).Count() > 0)
{
if (MessageBox.Show("You need to restart your computer to finish installing.", "Reboot computer", MessageBoxButtons.YesNo,
MessageBoxIcon.Information, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
{
showFlag++;
Utilite.Reboot();
}
}
if (showFlag == 0 && (installResult.Where(s => s.Success == true).Count() == 2))
{
MessageBox.Show("Install Success.");
}
}
}
catch (Exception ex)
{
MessageBox.Show("Install fail : " + ex.ToString());
}
}
private void ShutdownComputer_Click(object sender, EventArgs e)
{
if (MessageBox.Show("This will shotdown computer. Confirm?", "Shotdown computer", MessageBoxButtons.YesNo,
MessageBoxIcon.Information, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
{
Utilite.Shutdown();
}
}
private void Reboot_Click(object sender, EventArgs e)
{
if (MessageBox.Show("This will reboot computer. Confirm?", "Reboot computer", MessageBoxButtons.YesNo,
MessageBoxIcon.Information, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
{
Utilite.Reboot();
}
}
private void TrySave5NinePathRemoveRun()
{
RegistryKey key = Registry.LocalMachine.OpenSubKey(@"SOFTWARE\Microsoft\Windows\CurrentVersion\Run", true);
// RegistryKey key = Registry.LocalMachine.OpenSubKey(@"SOFTWARE\Wow6432Node", true);
object o = key.GetValue(Constants.Five9RegName);
// save run to regedeit
if (o != null)
{
Utilite.AddPathToRegistry(Constants.Five9RegName, o.ToString());
key.DeleteValue(Constants.Five9RegName, true);
key.Close();
}
}
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 static void Open59Manager()
{
//RegistryKey key = Registry.LocalMachine.OpenSubKey(@"SOFTWARE\Microsoft\Windows\CurrentVersion\Run");
//object o = key.GetValue("5nine Manager for Hyper-V");
string installPath = string.Empty;
bool installed = Utilite.IsApplictionInstalled(Constants.Five9RegName, out installPath);
if (!installed)
{
if (MessageBox.Show("Install 59manager?", "Install 59manager?", MessageBoxButtons.YesNo, MessageBoxIcon.Information,
MessageBoxDefaultButton.Button1) == DialogResult.Yes)
{
ProcessCaller.ProcessOpen(MainForm.FiveNineInstallPath + VanScript.FiveNineInstall);
}
}
else
{
logger.Debug(TryGet5NineStartPath());
ProcessCaller.ProcessOpen(TryGet5NineStartPath());
}
}
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));
}
private void EnableRemoteControl()
{
try
{
bool result = Utilite.EnablePsRemoting();
bool remoteControle = Utilite.EnableRemoteControle();
if (result && remoteControle)
{
MessageBox.Show("Enable Remote Controle success");
}
else
{
MessageBox.Show("Enable Remote Controle fail");
}
ChangeStatus(CheckModule.EnableRemoteControle, result);
PaintingModuleListView();
}
catch (Exception ex)
{
MessageBox.Show("Enable Remote Controle fail : {0}", ex.Message);
}
}
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("При формировании отчета возникли ошибки. обратитесь к разработчику."));
}
}
