/// <summary>
/// Gets a list of alarms that need to be procesed.
/// </summary>
/// <returns></returns>
public alarm_phone_queueDataTable GetUnconfirmedAlarms()
{
AlarmDataSet.alarm_phone_queueDataTable tbl = new alarm_phone_queueDataTable();
string sql = "select * from alarm_phone_queue where (status='new' or status = 'unconfirmed') and active =" + m_server.PortableWhereBool(true);
m_server.FillTable(tbl, sql);
return(tbl);
}
/// <summary>
/// Gets a list of alarms in priority order for processing
/// only alarms with status (new, or unconfirmed)
/// </summary>
/// <returns></returns>
public alarm_phone_queueDataTable GetNewAlarms()
{
AlarmDataSet.alarm_phone_queueDataTable tbl = new alarm_phone_queueDataTable();
string sql = "select * from alarm_phone_queue where status='new' or status = 'unconfirmed' order by priority";
m_server.FillTable(tbl, sql);
return(tbl);
}
/// <summary>
/// Gets a list of alarms in priority order for processing
/// only alarms with status (new, or unconfirmed)
/// </summary>
/// <returns></returns>
public alarm_phone_queueDataTable GetNewAlarms()
{
AlarmDataSet.alarm_phone_queueDataTable tbl = new alarm_phone_queueDataTable();
string sql = "select * from alarm_phone_queue where status='new' or status = 'unconfirmed' order by priority";
m_server.FillTable(tbl, sql);
return tbl;
}