public ActionResult Add(PiSpyDevice model)
{
if (ModelState.IsValid)
{
ApplicationDbContext db = new ApplicationDbContext();
string appUserId = db.Users.Single(m => m.UserName == User.Identity.Name).Id;
model.ApplicationUserId = appUserId;
db.PiSpyDevices.Add(model);
db.SaveChanges();
return RedirectToAction("Index");
}
return View(model);
}
public ActionResult Edit(PiSpyDevice model)
{
if (ModelState.IsValid)
{
ApplicationDbContext db = new ApplicationDbContext();
var piSpy = db.PiSpyDevices.Find(model.Id);
piSpy.Name = model.Name;
piSpy.SerialNumber = model.SerialNumber;
piSpy.Location = model.Location;
piSpy.Notes = model.Notes;
db.SaveChanges();
return RedirectToAction("Index");
}
return View("Add", model);
}
public DataViewModel(int piSpyId, DateTime? startTime = null, DateTime? endTime = null)
{
ApplicationDbContext db = new ApplicationDbContext();
PiSpyDevice = db.PiSpyDevices.Find(piSpyId);
StartTime = startTime ?? DateTime.Now.AddHours(-29); // db.PiSpyDataLogs.First(m => m.PiSpySerialNumber == PiSpyDevice.SerialNumber).TimeStamp; // passed in value OR the first recorded data point from that PiSpy
EndTime = endTime ?? DateTime.Now.AddHours(-5); // passed in value OR the current time in central time // subtracting 5 hours for the time zone difference
var difference = (DateTime)EndTime - (DateTime)StartTime;
Delta = (int)Math.Round(difference.TotalSeconds / 6);
this.DataLogs = db.PiSpyDataLogs.Where(m =>
m.PiSpySerialNumber == PiSpyDevice.SerialNumber
&& (StartTime == null || m.TimeStamp >= StartTime)
&& (EndTime == null || m.TimeStamp <= EndTime))
.ToList();
}
public MySpiesViewModel(PiSpyDevice dev)
{
PiSpyDevice = dev;
}