public bool AddReading(TrackerReadingModel model)
{
int affectedRows = 0;
using (var db = new trackerwebdbEntities())
{
//look up monitor
Monitor monitor = db.Monitors.Where(x => x.IpAddress == model.IpAddress).FirstOrDefault();
if (monitor != null)
{
//update last ping
monitor.LastPing = model.Reading;
//look up tag
Tag tag = db.Tags.Where(x => x.TagId == model.TagId).FirstOrDefault();
if (tag != null)
{
Tracking t = null;
//get latest tag readings (keep most recent 3)
var historicReadings = db.Trackings.Where(x => x.TagId == tag.Id).OrderByDescending(x => x.Reading).ToList();
if (historicReadings.Count > 0)
{
//most recent reading first, check to see if location has changed
var mostRecent = historicReadings.First();
if (mostRecent.MonitorId == monitor.Id)
{
//just update reading
mostRecent.Reading = model.Reading;
}
else
{
//add reading -- only keep 3 of the last locations total per tag
if (historicReadings.Count == 3)
{
db.Trackings.Remove(historicReadings[2]);
}
t = new Tracking();
t.MonitorId = monitor.Id;
t.TagId = tag.Id;
t.Reading = model.Reading;
db.Trackings.Add(t);
}
}
else
{
//no history simply add
t = new Tracking();
t.MonitorId = monitor.Id;
t.TagId = tag.Id;
t.Reading = model.Reading;
db.Trackings.Add(t);
}
affectedRows = db.SaveChanges();
} //end find tag
} // end find monitor
} //end using statement
return(affectedRows > 0);
}
public bool AddReading(TrackerReadingModel model)
{
int affectedRows = 0;
using(var db = new trackerwebdbEntities())
{
//look up monitor
Monitor monitor = db.Monitors.Where(x => x.IpAddress == model.IpAddress).FirstOrDefault();
if (monitor != null)
{
//update last ping
monitor.LastPing = model.Reading;
//look up tag
Tag tag = db.Tags.Where(x => x.TagId == model.TagId).FirstOrDefault();
if (tag != null)
{
Tracking t = null;
//get latest tag readings (keep most recent 3)
var historicReadings = db.Trackings.Where(x => x.TagId == tag.Id).OrderByDescending(x => x.Reading).ToList();
if(historicReadings.Count > 0)
{
//most recent reading first, check to see if location has changed
var mostRecent = historicReadings.First();
if(mostRecent.MonitorId == monitor.Id)
{
//just update reading
mostRecent.Reading = model.Reading;
}
else
{
//add reading -- only keep 3 of the last locations total per tag
if (historicReadings.Count == 3)
{
db.Trackings.Remove(historicReadings[2]);
}
t = new Tracking();
t.MonitorId = monitor.Id;
t.TagId = tag.Id;
t.Reading = model.Reading;
db.Trackings.Add(t);
}
}
else
{
//no history simply add
t = new Tracking();
t.MonitorId = monitor.Id;
t.TagId = tag.Id;
t.Reading = model.Reading;
db.Trackings.Add(t);
}
affectedRows = db.SaveChanges();
} //end find tag
} // end find monitor
}//end using statement
return affectedRows > 0;
}
public Tag GetTagById(int id)
{
Tag retvalue = null;
using (var db = new trackerwebdbEntities())
{
retvalue = db.Tags.Where(x => x.Id == id).FirstOrDefault();
}
return retvalue;
}
public Monitor GetMonitorById(int id)
{
Monitor retvalue = null;
using(var db = new trackerwebdbEntities())
{
retvalue = db.Monitors.Where(x => x.Id == id).FirstOrDefault();
}
return retvalue;
}
public List<InventoryView> GetCurrentInventory()
{
List<InventoryView> retvalue = null;
using(var db = new trackerwebdbEntities())
{
retvalue = db.InventoryViews.ToList();
}
return retvalue;
}
public List<Tag> GetAllTags()
{
List<Tag> retvalue = null;
using (var db = new trackerwebdbEntities())
{
retvalue = db.Tags.ToList();
}
return retvalue;
}
public List<Monitor> GetAllMonitors()
{
List<Monitor> retvalue = null;
using(var db = new trackerwebdbEntities())
{
retvalue = db.Monitors.ToList();
}
return retvalue;
}
public Tag GetTagById(int id)
{
Tag retvalue = null;
using (var db = new trackerwebdbEntities())
{
retvalue = db.Tags.Where(x => x.Id == id).FirstOrDefault();
}
return(retvalue);
}
public Monitor GetMonitorById(int id)
{
Monitor retvalue = null;
using (var db = new trackerwebdbEntities())
{
retvalue = db.Monitors.Where(x => x.Id == id).FirstOrDefault();
}
return(retvalue);
}
public List <InventoryView> GetCurrentInventory()
{
List <InventoryView> retvalue = null;
using (var db = new trackerwebdbEntities())
{
retvalue = db.InventoryViews.ToList();
}
return(retvalue);
}
public List <Tag> GetAllTags()
{
List <Tag> retvalue = null;
using (var db = new trackerwebdbEntities())
{
retvalue = db.Tags.ToList();
}
return(retvalue);
}
public List <Monitor> GetAllMonitors()
{
List <Monitor> retvalue = null;
using (var db = new trackerwebdbEntities())
{
retvalue = db.Monitors.ToList();
}
return(retvalue);
}
public bool AddMonitor(Monitor monitor)
{
int affectedRows = 0;
using(var db = new trackerwebdbEntities())
{
monitor.Status = 1;
db.Monitors.Add(monitor);
affectedRows = db.SaveChanges();
}
return affectedRows > 0;
}
public bool AddTag(Tag Tag)
{
int affectedRows = 0;
using (var db = new trackerwebdbEntities())
{
Tag.Status = 1;
db.Tags.Add(Tag);
affectedRows = db.SaveChanges();
}
return affectedRows > 0;
}
public bool AddTag(Tag Tag)
{
int affectedRows = 0;
using (var db = new trackerwebdbEntities())
{
Tag.Status = 1;
db.Tags.Add(Tag);
affectedRows = db.SaveChanges();
}
return(affectedRows > 0);
}
public bool AddMonitor(Monitor monitor)
{
int affectedRows = 0;
using (var db = new trackerwebdbEntities())
{
monitor.Status = 1;
db.Monitors.Add(monitor);
affectedRows = db.SaveChanges();
}
return(affectedRows > 0);
}
public bool UpdateMonitor(Monitor monitor)
{
int affectedRows = 0;
using(var db = new trackerwebdbEntities())
{
//update mac, friendly name, location and status
var model = db.Monitors.Where(x => x.Id == monitor.Id).First();
model.IpAddress = monitor.IpAddress;
model.FriendlyName = monitor.FriendlyName;
model.Location = monitor.Location;
model.Status = monitor.Status;
affectedRows = db.SaveChanges();
}
return affectedRows > 0;
}
public bool UpdateTag(Tag Tag)
{
int affectedRows = 0;
using (var db = new trackerwebdbEntities())
{
//update tagid, friendly name, description and (future) image blob
var model = db.Tags.Where(x => x.Id == Tag.Id).First();
model.TagId = Tag.TagId;
model.FriendlyName = Tag.FriendlyName;
model.Description = Tag.Description;
model.Status = Tag.Status;
affectedRows = db.SaveChanges();
}
return affectedRows > 0;
}
public bool UpdateMonitor(Monitor monitor)
{
int affectedRows = 0;
using (var db = new trackerwebdbEntities())
{
//update mac, friendly name, location and status
var model = db.Monitors.Where(x => x.Id == monitor.Id).First();
model.IpAddress = monitor.IpAddress;
model.FriendlyName = monitor.FriendlyName;
model.Location = monitor.Location;
model.Status = monitor.Status;
affectedRows = db.SaveChanges();
}
return(affectedRows > 0);
}
public bool UpdateTag(Tag Tag)
{
int affectedRows = 0;
using (var db = new trackerwebdbEntities())
{
//update tagid, friendly name, description and (future) image blob
var model = db.Tags.Where(x => x.Id == Tag.Id).First();
model.TagId = Tag.TagId;
model.FriendlyName = Tag.FriendlyName;
model.Description = Tag.Description;
model.Status = Tag.Status;
affectedRows = db.SaveChanges();
}
return(affectedRows > 0);
}