/// <summary>
/// Gets all active IVR alarms.
/// </summary>
/// <param name="criteria"></param>
/// <returns></returns>
protected override TTIVRNotificationThreads LoadList(BaseCriteria criteria)
{
try
{
Criteria listCriteria = (Criteria)criteria;
//Initialize the CSqlDbCommand for execute the stored procedure
CSqlDbCommand cmd = new CSqlDbCommand(DBCommands.USP_NS_GETIVRNOTIFICATIONTHREADLIST, System.Data.CommandType.StoredProcedure);
//Execute reader
CDAO.ExecReader(cmd);
/*fill the object and add to list.*/
while (CDAO.DataReader.Read())
{
IvrAlarm alarm = new IvrAlarm();
alarm.ThreadID = CDAO.DataReader["ThreadID"].ToInt();
this.Add(alarm);
}
}
catch
{
throw;
}
finally
{
CDAO.CloseDataReader();
CDAO.Dispose();
}
return(this);
}
/// <summary>
/// Gets all active IVR alarms.
/// </summary>
/// <param name="criteria"></param>
/// <returns></returns>
protected override IvrAlarmList LoadList(BaseCriteria criteria)
{
try
{
Criteria listCriteria = (Criteria)criteria;
//Initialize the CSqlDbCommand for execute the stored procedure
CSqlDbCommand cmd = new CSqlDbCommand(DBCommands.USP_NS_GET_IVRALARMLIST, System.Data.CommandType.StoredProcedure);
cmd.AddWithValue("numAttempts", NumAttempts);
//Execute reader
CDAO.ExecReader(cmd);
/*fill the object and add to list.*/
while (CDAO.DataReader.Read())
{
IvrAlarm alarm = new IvrAlarm();
alarm.IVRPhoneNumber = CDAO.DataReader["PhoneNumber"].ToStr();
alarm.AlarmID = CDAO.DataReader["AlarmID"].ToInt();
alarm.IsSuccess = CDAO.DataReader["isSuccess"].ToBoolean();
alarm.NotificationID = CDAO.DataReader["Notification_RecID"].ToInt();
alarm.AttemptCount = CDAO.DataReader["numAttempts"].ToInt16();
alarm.QueueTime = TypeCommonExtensions.IfNull(CDAO.DataReader["QueueTime"], DateTime.UtcNow).ToDateTime();
alarm.LastAttemptTime = TypeCommonExtensions.IfNull(CDAO.DataReader["LastAttemptTime"], DateTime.UtcNow).ToDateTime();
alarm.IvrAlarmID = CDAO.DataReader["RecID"].ToInt();
alarm.UTID = CDAO.DataReader["UTID"].ToStr();
alarm.Probe = CDAO.DataReader["Probe"].ToInt();
alarm.SensorType = CDAO.DataReader["SensorType"].ToStr();
if (CDAO.DataReader["IVR_SensorName"] != DBNull.Value)
{
alarm.IVR_SensorName = CDAO.DataReader["IVR_SensorName"].ToStr();
}
else
{
alarm.IVR_SensorName = (CDAO.DataReader["PuckName"].ToStr() == string.Empty ? "Sensor" : CDAO.DataReader["PuckName"].ToStr());
}
alarm.Value = CDAO.DataReader["AlarmData"].ToDecimal();
alarm.AlarmMaxValue = CDAO.DataReader["CondMaxValue"].ToDecimal();
alarm.AlarmMinValue = CDAO.DataReader["CondMinValue"].ToDecimal();
alarm.CondThresholdMins = CDAO.DataReader["CondThresholdMins"].ToInt();
alarm.AlarmTime = TypeCommonExtensions.IfNull(CDAO.DataReader["AlarmTime"], DateTime.UtcNow).ToDateTime();
alarm.IVRUserID = CDAO.DataReader["UserID"].ToInt();
alarm.PersonName = CDAO.DataReader["FirstName"].ToString() + " " + CDAO.DataReader["LastName"].ToString();
alarm.LanguageID = (CDAO.DataReader["LanguageID"].ToInt() == 0 ? 1 : CDAO.DataReader["LanguageID"].ToInt());
alarm.IsCelsius = CDAO.DataReader["isCelsius"].ToBoolean();
alarm.StoreName = GenStoreInfo.GetInstance().StoreName;
alarm.IvrID = CDAO.DataReader["RecID"].ToInt();
alarm.StoreNumber = GenStoreInfo.GetInstance().StorePhoneNumber.ToString();
alarm.AlarmStartTime = TypeCommonExtensions.IfNull(CDAO.DataReader["AlarmStartTime"], DateTime.UtcNow).ToDateTime();
//if (alarm.AlarmID > 0)
this.Add(alarm);
}
}
catch
{
throw;
}
finally
{
CDAO.CloseDataReader();
CDAO.Dispose();
}
return(this);
}