public AlarmDataSet.alarm_phone_queueDataTable GetAlarmQueue(string siteid, string parameter)
{
var tbl = new AlarmDataSet.alarm_phone_queueDataTable();
string sql = "select * from alarm_phone_queue ";
sql += " where siteid = '" + siteid + "' and parameter = '" + parameter + "' ";
sql += " and status in ('new', 'unconfirmed')";
m_server.FillTable(tbl, sql);
return(tbl);
}
/// <summary>
/// Gets list of active alarms.
/// </summary>
/// <param name="siteid"></param>
/// <param name="parameter"></param>
/// <returns></returns>
public AlarmDataSet.alarm_phone_queueDataTable GetAlarmQueue(int alarm_definition_id)
{
var tbl = new AlarmDataSet.alarm_phone_queueDataTable();
string sql = "select * from alarm_phone_queue ";
sql += " where alarm_definition_id = " + alarm_definition_id;
sql += " and active=" + m_server.PortableWhereBool(true);
m_server.FillTable(tbl, sql);
return(tbl);
}
public AlarmDataSet.alarm_phone_queueDataTable GetAlarmQueue(bool everything = false)
{
var tbl = new AlarmDataSet.alarm_phone_queueDataTable();
string sql = "select * from alarm_phone_queue ";
if (!everything)
{
sql += " where status in ('new', 'unconfirmed')";
}
m_server.FillTable(tbl, sql);
return(tbl);
}
public AlarmDataSet.alarm_phone_queueDataTable GetAlarmQueue(bool everything = false)
{
var tbl = new AlarmDataSet.alarm_phone_queueDataTable();
string sql = "select * from alarm_phone_queue ";
if (!everything)
{
sql += " where active=" + m_server.PortableWhereBool(true);
}
m_server.FillTable(tbl, sql);
return(tbl);
}
public AlarmDataSet.alarm_phone_queueDataTable GetAlarmQueue(string siteid, string parameter)
{
var tbl = new AlarmDataSet.alarm_phone_queueDataTable();
string sql = "select * from alarm_phone_queue ";
sql += " where siteid = '" + siteid + "' and parameter = '" + parameter + "' ";
sql += " and status in ('new', 'unconfirmed')";
m_server.FillTable(tbl, sql);
return tbl;
}
public AlarmDataSet.alarm_phone_queueDataTable GetAlarmQueue(bool everything = false)
{
var tbl = new AlarmDataSet.alarm_phone_queueDataTable();
string sql = "select * from alarm_phone_queue ";
if (!everything)
{
sql += " where status in ('new', 'unconfirmed')";
}
m_server.FillTable(tbl, sql);
return tbl;
}
