public ActionResult DeleteConfirmed(int id)
{
RpiDatalog rpiDatalog = db.RpiDatalogs.Find(id);
db.RpiDatalogs.Remove(rpiDatalog);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,DtRead,DataRead,RpiDeviceId")] RpiDatalog rpiDatalog)
{
if (ModelState.IsValid)
{
db.Entry(rpiDatalog).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.RpiDeviceId = new SelectList(db.RpiDevices, "Id", "Description", rpiDatalog.RpiDeviceId);
return(View(rpiDatalog));
}
// GET: Rpi/RpiDatalogs/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
RpiDatalog rpiDatalog = db.RpiDatalogs.Find(id);
if (rpiDatalog == null)
{
return(HttpNotFound());
}
return(View(rpiDatalog));
}
// GET: Rpi/RpiDatalogs/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
RpiDatalog rpiDatalog = db.RpiDatalogs.Find(id);
if (rpiDatalog == null)
{
return(HttpNotFound());
}
ViewBag.RpiDeviceId = new SelectList(db.RpiDevices, "Id", "Description", rpiDatalog.RpiDeviceId);
return(View(rpiDatalog));
}
// GET: Rpi/RpiDevices
public ActionResult Index()
{
var rpiDevices = db.RpiDevices.Include(r => r.RpiVersion);
List <DeviceDetailsLists> details = new List <DeviceDetailsLists>();
foreach (var devices in rpiDevices)
{
var versionNo = db.RpiVersions.Where(r => r.Id == devices.RpiVersionId).FirstOrDefault();
RpiDatalog logs = new RpiDatalog();
logs.DataRead = "{\"Temp\":0,\"Humidity\":0,\"Light\":0,\"Fan\":0,\"Water\":0}";
logs = db.RpiDatalogs.Where(r => r.RpiDeviceId == devices.Id).OrderByDescending(r => r.DtRead).FirstOrDefault();
RpiData data = new RpiData();
if (logs != null)
{
data = JsonConvert.DeserializeObject <RpiData>(logs.DataRead);
}
else
{
string empty = "{\"Temp\":0,\"Humidity\":0,\"Light\":0,\"Fan\":0,\"Water\":0}";
data = JsonConvert.DeserializeObject <RpiData>(empty);
}
details.Add(new DeviceDetailsLists()
{
Id = devices.Id,
Description = devices.Description,
Version = versionNo.VersionNo,
Temp = double.Parse(data.Temp),
Humidity = double.Parse(data.Humidity),
Light = int.Parse(data.Light),
Fan = int.Parse(data.Fan),
Water = int.Parse(data.Water)
});
}
return(View(details));
}
