/// <summary>
/// Gets the current status of the override
/// </summary>
public static bool GetOverrideStatusForSensor(SensorItemEnum item)
{
Override current;
using (RTDbContext Context = InitializeDatabaseContext())
{
var overrides = Context.Override.Where <Override>(t => t.sensor_name == item.ToString()).ToList <Override>();
if (overrides.Count() != 1)
{
throw new InvalidOperationException();
}
current = overrides[0];
}
return(current.Overridden == 1);
}
/// <summary>
/// Grabs the current threshold value from the database for the specific sensor
/// </summary>
public static double GetThresholdForSensor(SensorItemEnum item)
{
double val;
using (RTDbContext Context = InitializeDatabaseContext())
{
List <ThresholdValues> thresholds = Context.ThresholdValues.Where <ThresholdValues>(t => t.sensor_name == item.ToString()).ToList <ThresholdValues>();
if (thresholds.Count() != 1)
{
throw new InvalidOperationException();
}
val = Convert.ToDouble(thresholds[0].maxValue);
}
return(val);
}
/// <summary>
/// Updates the current override to whatever is provided
/// </summary>
public static void SetOverrideForSensor(SensorItemEnum item, bool doOverride)
{
using (RTDbContext Context = InitializeDatabaseContext())
{
var overrides = Context.Override.Where <Override>(t => t.sensor_name == item.ToString()).ToList <Override>();
if (overrides.Count() != 1)
{
throw new InvalidOperationException();
}
Override current = overrides[0];
current.Overridden = Convert.ToSByte(doOverride);
Context.Override.AddOrUpdate(current);
Context.SaveChangesAsync();
}
}
public Sensor(SensorItemEnum INItem, SensorStatusEnum status)
{
Time_Created = DateTime.Now;
Item = INItem;
Status = status;
}
public Override(SensorItemEnum INItem, String createdBy)
{
Time_Created = DateTime.Now;
Item = INItem;
User_Created_By = createdBy;
}
