//
// GET: /Alert/
public ActionResult Index()
{
var db = new HefestoDevicesEntities();
var alerts = db.Alerts.ToList();
ViewBag.list = alerts;
return View();
}
//
// GET: /AlertLV/Details/5
public string Details(int id)
{
string listresult = "";
XMLalert result = new XMLalert();
var db = new HefestoDevicesEntities();
Device_Information device = new Device_Information();
device = db.Device_Information.Find(id);
var alerts = (from p in db.Alerts
where p.Device_Information.Device_Name.Contains(device.Device_Name)
select p).ToList();
foreach (var alert in alerts)
{
result.Id = alert.Alert_Id;
result.Name = alert.Device_Information.Device_Name;
result.Alert = alert.Alert_Types.Alert_Description;
result.Opendate = alert.Alert_Opendate;
result.Closedate = alert.Alert_Closedate.ToString();
listresult += result.XMLresult("AlertArray");
}
return listresult;
}
/********************************************************************************************************************/
//
// GET: /Device/Delete/5
public ActionResult Delete(int id)
{
var db = new HefestoDevicesEntities();
Device_Information device = new Device_Information();
device = db.Device_Information.Find(id);
var alerts = (from p in db.Alerts
where p.Device_Information.Device_Name.Contains(device.Device_Name)
select p).ToList();
if (alerts.Count() > 0)
{
foreach (var alert in alerts)
{
db.Alerts.Remove(alert);
}
}
var monitor = (from p in db.Monitor
where p.Device_Information.Device_Name.Contains(device.Device_Name)
select p).ToList();
if (monitor.Count() > 0)
{
foreach (var mon in monitor)
{
db.Monitor.Remove(mon);
}
}
db.Device_Information.Remove(device );
db.SaveChanges();
return RedirectToAction("Index");
//return View();
}
/********************************************************************************************************************/
public ActionResult Details(int id)
{
var db = new HefestoDevicesEntities();
Alerts alert = new Alerts();
alert = db.Alerts.Find(id);
return View(alert);
}
//
// GET: /MonitoringLV/Details/5
public string Details(int id)
{
string listresult = "";
XMLmonitoring result = new XMLmonitoring();
var db = new HefestoDevicesEntities();
Device_Information device = new Device_Information();
device = db.Device_Information.Find(id);
var monitors = (from p in db.Monitor
where p.Device_Information.Device_Name.Contains(device.Device_Name)
select p).ToList();
foreach (var monitor in monitors)
{
result.Id = monitor.Monitor_Id;
result.Name = monitor.Device_Information.Device_Name;
result.Date = monitor.Monitor_Date.ToString();
result.Current = (float)monitor.Monitor_Current;
result.Voltage = (float)monitor.Monitor_Voltage;
listresult += result.XMLresult("Array2");
}
return listresult;
}
public string Ontime(int id)
{
string result = "";
var db = new HefestoDevicesEntities();
Device_Information device = new Device_Information();
device = db.Device_Information.Find(id);
result = result + "hr" + device.Device_OnTime.Value.Hours.ToString();//DateTime.Now.Hour.ToString();
result = result + "mn" + device.Device_OnTime.Value.Minutes.ToString() + "$\r\n"; //DateTime.Now.Minute.ToString() + "$\r\n";
return result;
}
//
// GET: /Monitoring/Details/5
public ActionResult Details(int id)
{
var db = new HefestoDevicesEntities();
Device_Information device = new Device_Information();
device = db.Device_Information.Find(id);
ViewBag.devicename = device.Device_Name;
ViewBag.monitoring = (from p in db.Monitor
where p.Device_Information.Device_Name.Contains(device.Device_Name)
select p).ToList();
return View();
}
/********************************************************************************************************************/
public ActionResult Changemode(int id, int mode, int status)
{
var db = new HefestoDevicesEntities();
Device_Information device = new Device_Information();
device = db.Device_Information.Find(id);
device.Device_Mode = mode;
device.Device_Status = status;
db.SaveChanges();
return RedirectToAction("Details", new { id = device.Device_Id });
//return View();
}
//GET: /DeviceLV/Control/?id=&mode=&status=
public string Control(int id, int mode, int status)
{
var db = new HefestoDevicesEntities();
Device_Information device = new Device_Information();
device = db.Device_Information.Find(id);
device.Device_Mode = mode;
device.Device_Status = status;
db.SaveChanges();
return "OK";
}
public string Create(int id, int type)
{
var db = new HefestoDevicesEntities();
Alerts alert = new Alerts();
Device_Information device = new Device_Information();
Alert_Types mess = new Alert_Types();
//Variables used for obtain information to the mail
mess = db.Alert_Types.Find(type);
device = db.Device_Information.Find(id);
//Creation of new alert
alert.Alert_Device = id;
alert.Alert_Type = type;
alert.Alert_Opendate = DateTime.Now;
alert.Alert_Isread = 0;
db.Alerts.Add(alert);
db.SaveChanges();
//Creation of the message and maps location
string message = "Report from: " + device.Device_Name + " about: " + mess.Alert_Description;
message += "\r\n Location: \r\n";
message += "http://maps.googleapis.com/maps/api/staticmap?center=" + device.Device_Lat.ToString() + "," + device.DEvice_Long.ToString() + "&zoom=15&size=600x300&maptype=roadmap&markers=color:blue%7Clabel:S%7C";
message += device.Device_Lat.ToString() + "," + device.DEvice_Long.ToString() + "&sensor=false";
//Creation of the mail's header
string subject = "Alert from: " + device.Device_Name;
string address = device.Device_Email;
string email = "*****@*****.**";
string password = "******";
//Send Email message
var loginInfo = new NetworkCredential(email, password);
var msg = new MailMessage();
var smtpClient = new SmtpClient("smtp.gmail.com", 587);
msg.From = new MailAddress(email);
msg.To.Add(new MailAddress(address));
msg.Subject = subject;
msg.Body = message;
msg.IsBodyHtml = true;
smtpClient.EnableSsl = true;
smtpClient.UseDefaultCredentials = false;
smtpClient.Credentials = loginInfo;
smtpClient.Send(msg);
//Shows the information of the device after create alert
return "OK";
}
//
// GET: /MonitoringLV/Create
public string Create(int id,int status,float current, float voltage)
{
var db = new HefestoDevicesEntities();
Monitor mon = new Monitor();
mon.Monitor_Device = id;
mon.Monitor_Date = DateTime.Now;
mon.Monitor_Status = status;
mon.Monitor_Current = current;
mon.Monitor_Voltage = voltage;
db.Monitor.Add(mon);
db.SaveChanges();
return "OK";
}
//
// GET: /DeviceLV/Create?name=&lat=&lon=&mode=&status=&zone=&email=
public string Create(string name, float lat, float lon, int mode, int status, string zone, string email)
{
var db = new HefestoDevicesEntities();
Device_Information device = new Device_Information();
device.Device_Name = name;
device.Device_Lat = lat;
device.DEvice_Long = lon;
device.Device_Mode = mode;
device.Device_Status = status;
device.Device_Zone = zone;
device.Device_Email = email;
db.Device_Information.Add(device);
db.SaveChanges();
return "OK";
}
/********************************************************************************************************************/
//
// GET: /Device/Create
public ActionResult Create(string name, float lat, float lon, int mode, int status, string zone,string email)
{
var db = new HefestoDevicesEntities();
Device_Information device = new Device_Information();
device.Device_Name = name;
device.Device_Lat = lat;
device.DEvice_Long = lon;
device.Device_Mode = mode;
device.Device_Status = status;
device.Device_Zone = zone;
device.Device_Email = email;
db.Device_Information.Add(device);
db.SaveChanges();
return RedirectToAction("Details", new { id = device.Device_Id });
//return View();
}
//
// GET: /DeviceLV/Details/5
public string Details(int id)
{
XMLparser result= new XMLparser();
var db = new HefestoDevicesEntities();
Device_Information device = new Device_Information();
device = db.Device_Information.Find(id);
result.Name = device.Device_Name;
result.Email = device.Device_Email;
result.Zone = device.Device_Zone;
result.Id = device.Device_Id;
result.Lat = (float) device.Device_Lat;
result.Long =(float) device.DEvice_Long;
result.Mode =(int) device.Device_Mode;
result.Status = (int)device.Device_Status;
return result.XMLresult("Value");
}
//
// GET: /MonitoringLV/
public string Index()
{
string listresult = "";
XMLmonitoring result = new XMLmonitoring();
var db = new HefestoDevicesEntities();
var monitors = db.Monitor.ToList();
foreach (var monitor in monitors)
{
result.Id = monitor.Monitor_Id;
result.Name = monitor.Device_Information.Device_Name;
result.Date = monitor.Monitor_Date.ToString();
result.Current = (float)monitor.Monitor_Current;
result.Voltage = (float)monitor.Monitor_Voltage;
listresult += result.XMLresult("Array2");
}
return listresult;
}
public string Create2(int id, int status, float current, float voltage,float var1,float var2)
{
try
{
var db = new HefestoDevicesEntities();
Monitor mon = new Monitor();
mon.Monitor_Device = id;
mon.Monitor_Date = DateTime.Now;
mon.Monitor_Status = status;
mon.Monitor_Current = Math.Round(current,2);
mon.Monitor_Voltage = Math.Round(voltage,2);
mon.Monitor_Var1 = Math.Round(var1,2);
mon.Monitor_Var2 = Math.Round(var2, 2);
db.Monitor.Add(mon);
db.SaveChanges();
return "OK$";
}
catch
{
return "ERROR";
}
}
public string GetPortOn(int id)
{
try
{
var db = new HefestoDevicesEntities();
Device_Information device = new Device_Information();
device = db.Device_Information.Find(id);
return "st" + device.Device_Port_On_Over.ToString() + "$";
}
catch
{
return "ERROR";
}
}
//
// GET: /AlertLV/
public string Index()
{
string listresult = "";
XMLalert result = new XMLalert();
var db = new HefestoDevicesEntities();
var alerts = db.Alerts.ToList();
foreach (var alert in alerts)
{
result.Id = alert.Alert_Id;
result.Name = alert.Device_Information.Device_Name;
result.Alert = alert.Alert_Types.Alert_Description;
result.Opendate = alert.Alert_Opendate;
result.Closedate = alert.Alert_Closedate.ToString();
listresult += result.XMLresult("AlertArray");
}
return listresult;
}
public string GetHist(int id)
{
try
{
var db = new HefestoDevicesEntities();
Device_Information device = new Device_Information();
device = db.Device_Information.Find(id);
return "st" + device.Device_Histerresys.ToString() + "$";
}
catch
{
return "ERROR";
}
}
//
// GET: /DeviceLV/
public string Index()
{
string listresult="";
XMLparser result = new XMLparser();
var db = new HefestoDevicesEntities();
var devices = db.Device_Information.ToList();
foreach (var device in devices)
{
result.Name = device.Device_Name;
result.Email = device.Device_Email;
result.Zone = device.Device_Zone;
result.Id = device.Device_Id;
result.Lat = (float)device.Device_Lat;
result.Long = (float)device.DEvice_Long;
result.Mode = (int)device.Device_Mode;
result.Status = (int)device.Device_Status;
listresult += result.XMLresult("DeviceArray");
}
return listresult;
}
public ActionResult New(Device_Information model)
{
if (ModelState.IsValid)
{
var db = new HefestoDevicesEntities();
db.Device_Information.Add(model);
db.SaveChanges();
return RedirectToAction("Details", new { id = model.Device_Id });
}
// If we got this far, something failed, redisplay form
return View("New");
}
public ActionResult ReadAlert(int id)
{
var db = new HefestoDevicesEntities();
Alerts alert = new Alerts();
alert = db.Alerts.Find(id);
alert.Alert_Isread = 1;
alert.Alert_Closedate = DateTime.Now;
db.SaveChanges();
return RedirectToAction("Details", "Alert", new { id = id });
}
public string ReadAlert(int id)
{
var db = new HefestoDevicesEntities();
Alerts alert = new Alerts();
alert = db.Alerts.Find(id);
if (alert.Alert_Isread == 0)
{
alert.Alert_Isread = 1;
alert.Alert_Closedate = DateTime.Now;
db.SaveChanges();
return "OK";
}
else { return "ERROR"; }
}
/********************************************************************************************************************/
//
// GET: /Device/
public ActionResult Index()
{
var db = new HefestoDevicesEntities();
var devices = db.Device_Information.ToList();
ViewBag.list = devices;
return View();
}
public ActionResult Edit(Device_Information model)
{
var db = new HefestoDevicesEntities();
Device_Information device = new Device_Information();
device = db.Device_Information.Find(model.Device_Id);
if (ModelState.IsValid)
{
device.Device_Name = model.Device_Name ;
device.Device_Lat = model.Device_Lat ;
device.DEvice_Long = model.DEvice_Long;
device.Device_Mode = model.Device_Mode ;
device.Device_Status =model.Device_Status ;
device.Device_Email = model.Device_Email ;
device.Device_Zone = model.Device_Zone;
device.Device_OffTime = model.Device_OffTime;
device.Device_OnTime = model.Device_OnTime;
device.Device_Port_In = model.Device_Port_In;
device.Device_Port_Off_Under = model.Device_Port_Off_Under;
device.Device_Port_On_Over = model.Device_Port_On_Over;
device.Device_SetPoint = model.Device_SetPoint;
device.Device_Histerresys = model.Device_Histerresys;
db.SaveChanges();
return RedirectToAction("Details", new { id = device.Device_Id });
}
// If we got this far, something failed, redisplay form
return View(device);
}
/********************************************************************************************************************/
//
// GET: /Device/Edit/5
public ActionResult Edit(int id)
{
var db = new HefestoDevicesEntities();
Device_Information device = new Device_Information();
device = db.Device_Information.Find(id);
return View(device);
}
/********************************************************************************************************************/
//
// GET: /Device/Details/5
public ActionResult Details(int id)
{
var db = new HefestoDevicesEntities();
Device_Information device = new Device_Information();
device=db.Device_Information.Find(id);
ViewBag.device = device;
string maps="http://maps.googleapis.com/maps/api/staticmap?center=" + device.Device_Lat.ToString() + "," + device.DEvice_Long.ToString() + "&zoom=15&size=600x300&maptype=roadmap&markers=color:blue%7Clabel:S%7C";
maps+= device.Device_Lat.ToString() + "," + device.DEvice_Long.ToString() + "&sensor=false";
ViewBag.maps = maps;
ViewBag.alerts = (from p in db.Alerts
where p.Device_Information.Device_Name.Contains(device.Device_Name )
select p).ToList();
return View();
}
public string GetMode(int id)
{
try
{
var db = new HefestoDevicesEntities();
Device_Information device = new Device_Information();
device = db.Device_Information.Find(id);
return "<" + device.Device_Mode.ToString() + ">";
}
catch
{
return "ERROR";
}
}
//
// GET: /Monitoring/
public ActionResult Index()
{
var db = new HefestoDevicesEntities();
var monitor = db.Monitor.ToList();
monitor.OrderByDescending(Monitor => Monitor.Monitor_Device );
ViewBag.list = monitor;
return View();
}