public AlarmDataSet.alarm_logDataTable GetLog(int minutes) { var alarm_log = new AlarmDataSet.alarm_logDataTable(); DateTime t = DateTime.Now.AddMinutes(-minutes); var sql = "select * from alarm_log where datetime >= " + m_server.PortableDateString(t, TimeSeriesDatabase.dateTimeFormat); m_server.FillTable(alarm_log, sql); return(alarm_log); }
/// <summary> /// determines if there is any asterisk activity /// within in a specified number of minutes. /// </summary> /// <param name="id"></param> /// <param name="minutes"></param> /// <returns></returns> public bool CurrentActivity(int id, int minutes) { // look in alarm_log table and check for recent activity var alarm_log = new AlarmDataSet.alarm_logDataTable(); DateTime t = DateTime.Now.AddMinutes(-minutes); var sql = "select * from alarm_log where datetime >= " + m_server.PortableDateString(t, TimeSeriesDatabase.dateTimeFormat) + " and alarm_phone_queue_id = " + id; m_server.FillTable(alarm_log, sql); return(alarm_log.Rows.Count > 0); }