/// <summary>
///
/// </summary>
/// <param name="db"></param>
public void LoadClassifications(NPoco.Database db)
{
using (new HourGlass(this))
{
List<SigClass> data = db.Fetch<SigClass>(_sql.GetQuery(Sql.Query.SQL_SIG_CLASS));
_classifications = new List<NameValue>();
foreach (var result in data)
{
NameValue nameValue = new NameValue();
nameValue.Name = result.Name;
nameValue.Value = result.Id.ToString();
_classifications.Add(nameValue);
}
}
}
/// <summary>
///
/// </summary>
/// <param name="db"></param>
public void LoadSensors(NPoco.Database db)
{
using (new HourGlass(this))
{
List<Sensor> data = db.Fetch<Sensor>(_sql.GetQuery(Sql.Query.SQL_SENSORS));
_sensors = new List<NameValue>();
foreach (var result in data)
{
NameValue nameValue = new NameValue();
nameValue.Name = result.HostName;
nameValue.Value = result.Sid.ToString();
_sensors.Add(nameValue);
}
}
}
/// <summary>
///
/// </summary>
/// <param name="db"></param>
public void LoadAcknowledgementClasses(NPoco.Database db)
{
using (new HourGlass(this))
{
List<AcknowledgmentClass> data = db.Fetch<AcknowledgmentClass>(_sql.GetQuery(Sql.Query.SQL_ACKNOWLEDGEMENT_CLASSES));
_acknowledgementClasses = new List<NameValue>();
foreach (var result in data)
{
NameValue nameValue = new NameValue();
nameValue.Name = result.Desc;
nameValue.Value = result.Id.ToString();
_acknowledgementClasses.Add(nameValue);
}
}
}