/// <summary>
/// Get Format string
/// </summary>
/// <returns></returns>
protected override FormatString ExecuteCommand()
{
try
{
CSqlDbCommand cmd = new CSqlDbCommand(DBCommands.USP_NS_GETFORMATSTRING);
cmd.AddWithValue("FormatID", FormatID);
cmd.AddWithValue("LanguageID", LanguageID);
cmd.AddWithValue("SensorType", SensorType);
CDAO.ExecReader(cmd);
if (CDAO.DataReader.Read())
{
ComposeString = CDAO.DataReader["FormatString"].ToStr();
}
}
catch
{
throw;
}
finally
{
CDAO.CloseDataReader();
CDAO.Dispose();
}
return(this);
}
/// <summary>
/// Get Contact state string value
/// </summary>
/// <returns></returns>
protected override ContactState ExecuteCommand()
{
try
{
CSqlDbCommand cmd = new CSqlDbCommand("SP_TTGETCONTACTSENSORTEXT");
cmd.AddWithValue("UTID", UTID);
cmd.AddWithValue("Probe", Probe);
cmd.AddWithValue("State", contactState);
cmd.AddWithValue("LanguageID", LanguageID);
CDAO.ExecReader(cmd);
if (CDAO.DataReader.Read())
{
contactStateString = CDAO.DataReader["StateText"].ToStr();
}
}
catch
{
throw;
}
finally
{
CDAO.CloseDataReader();
CDAO.Dispose();
}
return(this);
}
/// <summary>
/// Get Sensor Format ID
/// </summary>
/// <returns></returns>
protected override SensorFormatString ExecuteCommand()
{
try
{
CSqlDbCommand cmd = new CSqlDbCommand("USP_NS_GETSENSORFORMATSTRINGID");
cmd.AddWithValue("UTID", UTID);
cmd.AddWithValue("Probe", Probe);
cmd.AddWithValue("FormatType", FormatType);
cmd.AddWithValue("Action", Action);
CDAO.ExecReader(cmd);
if (CDAO.DataReader.Read())
{
SensorFormatID = CDAO.DataReader["FormatID"].ToInt();
}
}
catch
{
throw;
}
finally
{
CDAO.CloseDataReader();
CDAO.Dispose();
}
return(this);
}
protected override NotificationAcknowledgement ExecuteCommand()
{
try
{
/* Create command object for sql operation*/
CSqlDbCommand cmd = new CSqlDbCommand(DBCommands.USP_NS_IS_NOTIFICATION_ACKNOWLEDGED, System.Data.CommandType.StoredProcedure);
cmd.AddWithValue("AlarmID", AlarmID);
cmd.AddWithValue("StoreID", StoreID);
/* execute the command */
CDAO.ExecReader(cmd);
if (CDAO.DataReader.Read())
{
IsAlarmCleared = CDAO.DataReader["IsAlarmCleared"].ToBoolean();
ClearedTime = CDAO.DataReader["ClearedTime"].ToDateTime();
IsAlarmClearedByUser = CDAO.DataReader["AlarmClearedByUser"].ToBoolean();
}
}
catch
{
throw;
}
finally
{
CDAO.CloseDataReader();
CDAO.Dispose();
}
return(this);
}
protected override SensorCurrentStatus ExecuteCommand()
{
try
{
//Initialize the CSqlDbCommand for execute the stored procedure
CSqlDbCommand cmd = new CSqlDbCommand(DBCommands.USP_NS_GETCURRENTVALUE);
//Bind property values as input parameters for procedure
cmd.AddWithValue("UTID", UTID);
cmd.AddWithValue("Probe", Probe);
//Execute command
CDAO.ExecReader(cmd);
//Bind output values to IvrAlarmStatus object
if (CDAO.DataReader.Read())
{
CurrentTime = TypeCommonExtensions.IfNull(CDAO.DataReader["CurrentTime"], DateTime.UtcNow).ToDateTime();
CurrentValue = CDAO.DataReader["CurrentValue"].ToDecimal();
}
}
catch
{
throw;
}
finally
{
CDAO.CloseDataReader();
CDAO.Dispose();
}
return(this);
}
protected override CheckBackInAccept ExecuteCommand()
{
try
{
/*Initialize the command.*/
CSqlDbCommand cmd = new CSqlDbCommand(DBCommands.USP_NS_CHECKBACKINACCEPT, System.Data.CommandType.StoredProcedure);
/*add parameters to command object*/
cmd.AddWithValue("NotificationID", NotificationID);
cmd.AddWithValue("StoreID", StoreID);
/*execute command*/
CDAO.ExecReader(cmd);
if (CDAO.DataReader.Read())
{
IsBackInAcceptableRange = CDAO.DataReader["BackInRange"].ToBoolean();
LogCount = CDAO.DataReader["LogCount"].ToInt();
}
}
catch
{
throw;
}
finally
{
CDAO.CloseDataReader();
CDAO.Dispose();
}
return(this);
}
protected override InstanceType ExecuteCommand()
{
try
{
//Initialize the CSqlDbCommand for execute the stored procedure
CSqlDbCommand cmd = new CSqlDbCommand("SELECT COUNT(TABLE_NAME) AS [Count] FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'OrganizationalUnits'", System.Data.CommandType.Text);
//Execute command
CDAO.ExecReader(cmd);
if (CDAO.DataReader.Read())
{
IsMultiDB = CDAO.DataReader["Count"].ToString() == "1" ? true : false;
}
}
catch
{
throw;
}
finally
{
CDAO.CloseDataReader();
CDAO.Dispose();
}
return(this);
}
protected override NotifyPagerAddressList LoadList(BaseCriteria criteria)
{
try
{
CSqlDbCommand cmd = new CSqlDbCommand(DBCommands.USP_NS_GETNOTIFYPAGERADDRESSLIST, System.Data.CommandType.StoredProcedure);
cmd.AddWithValue("NotifyID", criteria.ID);
//Execute command
CDAO.ExecReader(cmd);
while (CDAO.DataReader.Read())
{
NotifyPagerAddress notifyPagerAddress = new NotifyPagerAddress();
notifyPagerAddress.PagerName = CDAO.DataReader["Name"].ToStr();
notifyPagerAddress.PhoneNumber = CDAO.DataReader["PagerPhone"].ToStr();
notifyPagerAddress.PagerDelay = CDAO.DataReader["PagerDelay"].ToInt();
notifyPagerAddress.DeliveryMethod = CDAO.DataReader["PagerDeliveryMethod"].ToInt();
notifyPagerAddress.PagerMessage = CDAO.DataReader["PagerMessage"].ToStr();
this.Add(notifyPagerAddress);
}
}
catch
{
throw;
}
finally
{
CDAO.CloseDataReader();
CDAO.Dispose();
}
return(this);
}
/// <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);
}
protected override RelaySwitchConfig Load(Criteria criteria)
{
RelaySwitchConfig relaySwitchConfig = new RelaySwitchConfig();
try
{
//Initialize the CSqlDbCommand for execute the stored procedure
CSqlDbCommand cmd = new CSqlDbCommand(DBCommands.USP_NS_GETNOTIFYSWITCH);
cmd.Parameters.AddWithValue("SwitchNotifyID", criteria.ID);
//Execute reader
CDAO.ExecReader(cmd);
while (CDAO.DataReader.Read())
{
relaySwitchConfig.NotifyID = CDAO.DataReader["NotifyID"].ToInt();
relaySwitchConfig.IsEnabled = CDAO.DataReader["isEnabled"].ToBoolean();
relaySwitchConfig.Name = CDAO.DataReader["Name"].ToStr();
relaySwitchConfig.SwitchInfo = CDAO.DataReader["SwitchInfo"].ToStr();
}
}
catch
{
throw;
}
finally
{
CDAO.CloseDataReader();
CDAO.Dispose();
}
return(relaySwitchConfig);
}
protected override NotifyMobileList LoadList(BaseCriteria criteria)
{
try
{
/*Initialize the command.*/
CSqlDbCommand cmd = new CSqlDbCommand(DBCommands.USP_NS_GETNOTIFYMOBILELIST, System.Data.CommandType.StoredProcedure);
cmd.AddWithValue("NotifyID", criteria.ID);
//Execute command
CDAO.ExecReader(cmd);
while (CDAO.DataReader.Read())
{
NotifyMobiles notifyMobiles = new NotifyMobiles();
notifyMobiles.MobileNumber = CDAO.DataReader["MobileNumber"].ToStr();
notifyMobiles.Name = CDAO.DataReader["Name"].ToStr();
this.Add(notifyMobiles);
}
}
catch
{
throw;
}
finally
{
CDAO.CloseDataReader();
CDAO.Dispose();
}
return(this);
}
//public int threadID { get; set; }
protected override IvrIsInProcess ExecuteCommand()
{
try
{
//Initialize the CSqlDbCommand for execute the stored procedure
CSqlDbCommand cmd = new CSqlDbCommand(DBCommands.USP_NS_IVR_ISINPROCESS);
// cmd.AddWithValue("NotificationID", NotificationID);
cmd.AddWithValue("StoreID", StoreID);
// This stored procedure was changed to an integer because on SQL 2000 the bit was being sent as a 'T' or an 'F' instead of a 1 or 0
cmd.AddWithValue("PhoneNumber", phoneNumber);
// cmd.AddWithValue("AlarmID", AlarmID);
// cmd.AddWithValue("isSucceeded", IsSucceeded.ToInt());
// cmd.AddWithValue("numAttempts", numAttempts);
//Execute command
CDAO.ExecReader(cmd);
//while (CDAO.DataReader.Read())
//{
// IsAlarmInIVRProcess = CDAO.DataReader["IsInProcess"].ToBoolean();
// LastAttemptTime = TypeCommonExtensions.IfNull(CDAO.DataReader["LastAttemptTime"], DateTime.UtcNow).ToDateTime();
// phoneNumber = CDAO.DataReader["PhoneNumber"].ToString();
// IsSucceeded = CDAO.DataReader["IsSuccess"].ToBoolean();
// numAttempts = CDAO.DataReader["numAttempts"].ToInt();
// threadID = CDAO.DataReader["ThreadID"].ToInt();
//}
// Bind output values to IvrAlarmStatus object
// if stored procedure returns a record, then it is either cleared,in-range, or in-process (call alert is not complete)
if (CDAO.DataReader.Read())
{
IsAlarmInIVRProcess = true;
// IsSucceeded = CDAO.DataReader["IsSuccess"].ToBoolean();
// numAttempts = CDAO.DataReader["numAttempts"].ToInt();
}
else
{
IsAlarmInIVRProcess = false;
}
}
catch
{
throw;
}
finally
{
CDAO.CloseDataReader();
CDAO.Dispose();
}
//return IvrAlarmStatus object
return(this);
}
protected override NotifyPopupAddressList LoadList(BaseCriteria criteria)
{
try
{
CSqlDbCommand cmd = new CSqlDbCommand(DBCommands.USP_NS_GETNOTIFYPOPUPADDRESSLIST, System.Data.CommandType.StoredProcedure);
cmd.AddWithValue("NotifyID", criteria.ID);
//Execute command
CDAO.ExecReader(cmd);
while (CDAO.DataReader.Read())
{
if (CDAO.DataReader["NetSendTo"].ToStr().Contains(";") == true)
{
string[] notifyPopupAddressEntries = CDAO.DataReader["NetSendTo"].ToStr().Split(';');
foreach (string notifyPopupAddressEntry in notifyPopupAddressEntries)
{
NotifyPopupAddress notifyPopupAddress = new NotifyPopupAddress();
notifyPopupAddress.NetSendTo = notifyPopupAddressEntry.Trim();
notifyPopupAddress.Name = CDAO.DataReader["Name"].ToStr().Trim();
this.Add(notifyPopupAddress);
}
}
else if (CDAO.DataReader["NetSendTo"].ToStr().Contains(",") == true)
{
string[] notifyPopupAddressEntries = CDAO.DataReader["NetSendTo"].ToStr().Split(',');
foreach (string notifyPopupAddressEntry in notifyPopupAddressEntries)
{
NotifyPopupAddress notifyPopupAddress = new NotifyPopupAddress();
notifyPopupAddress.NetSendTo = notifyPopupAddressEntry.Trim();
notifyPopupAddress.Name = CDAO.DataReader["Name"].ToStr().Trim();
this.Add(notifyPopupAddress);
}
}
else
{
NotifyPopupAddress notifyPopupAddress = new NotifyPopupAddress();
notifyPopupAddress.NetSendTo = CDAO.DataReader["NetSendTo"].ToStr().Trim();
notifyPopupAddress.Name = CDAO.DataReader["Name"].ToStr().Trim();
this.Add(notifyPopupAddress);
}
}
}
catch
{
throw;
}
finally
{
CDAO.CloseDataReader();
CDAO.Dispose();
}
return(this);
}
protected override EscalationList LoadList(BaseCriteria criteria)
{
try
{
/* Initialize the command object. */
CSqlDbCommand cmd = new CSqlDbCommand(DBCommands.USP_NS_GETESCALATIONPROFILEINFO, System.Data.CommandType.StoredProcedure);
cmd.Parameters.AddWithValue("EscalationProfileID", criteria.ID);
/* Execute the command. */
CDAO.ExecReader(cmd);
/* To know current escalation level*/
short _level = 1;
// LogBook.Write("Looking up Escaltion List using Profile ID: " + criteria.ID);
while (CDAO.DataReader.Read())
{
EscalationInfo escalationInfo = new EscalationInfo()
{
EscalationID = CDAO.DataReader["RecID"].ToInt(),
NotifyProfileID = CDAO.DataReader["NotificationProfileID"].ToInt(),
ProfileName = CDAO.DataReader["ProfileName"].ToStr(),
StopEscOnUserAck = (CDAO.DataReader["Flags"].ToInt() & 1).ToBoolean(),
StopEscOnSesnorNormalState = (CDAO.DataReader["Flags"].ToInt() & 2).ToBoolean(),
SwitchBitmask = CDAO.DataReader["SwitchBitmask"].ToInt16(),
WaitSecs = CDAO.DataReader["WaitSecs"].ToInt(),
IsFailSafe = (CDAO.DataReader["Ordering"].ToInt() == 6), //6 indicates the failsafe escalation. other are normal escalations.
PagerPrompt = CDAO.DataReader["PagerPrompt"].ToStr(),
Severity = (CooperAtkins.Interface.Alarm.Severity)CDAO.DataReader["Severity"],
EscalationLevel = _level
};
if (escalationInfo.StopEscOnUserAck == false && escalationInfo.StopEscOnSesnorNormalState == false)
{
LogBook.Write("Default using 'Stop Escalation on user Ack/Clear', since both user & auto are false: " + escalationInfo.ProfileName);
escalationInfo.StopEscOnUserAck = true;
}
this.Add(escalationInfo);
_level++;
}
}
catch
{
throw;
}
finally
{
CDAO.CloseDataReader();
CDAO.Dispose();
}
return(this);
}
/// <summary>
/// to fetch the message board configuration list
/// </summary>
/// <param name="criteria"></param>
/// <returns></returns>
protected override MessageBoardConfigList LoadList(BaseCriteria criteria)
{
//CDAO.Connection = EnterpriseModel.Net.
try
{
Criteria listCriteria = (Criteria)criteria;
//Initialize the CSqlDbCommand for execute the stored procedure
CSqlDbCommand cmd = new CSqlDbCommand(DBCommands.USP_NS_GETNOTIFYMSGBOARDIDLIST);
if (listCriteria.ID == null)
{
cmd.AddWithValue("MsgBoardNotifyID", System.DBNull.Value);
}
else
{
cmd.AddWithValue("MsgBoardNotifyID", listCriteria.ID);
}
//Execute reader
CDAO.ExecReader(cmd);
while (CDAO.DataReader.Read())
{
MessageBoardConfig messageBoardConfig = new MessageBoardConfig()
{
NotifyID = CDAO.DataReader["NotifyID"].ToInt(),
MessageBoardName = CDAO.DataReader["Name"].ToStr(),
IsNetworkConnected = CDAO.DataReader["NetworkConnection"].ToBoolean(),
IpAddress = CDAO.DataReader["IPAddress"].ToStr(),
Port = CDAO.DataReader["Port"].ToInt(),
COMSettings = CDAO.DataReader["Settings"].ToStr(),
IsEnabled = CDAO.DataReader["isEnabled"].ToBoolean(),
//IsGroup = CDAO.DataReader["IsGroup"].ToBoolean(),
BoardType = CDAO.DataReader["BoardType"].ToInt()
};
this.Add(messageBoardConfig);
}
}
catch
{
throw;
}
finally
{
CDAO.CloseDataReader();
CDAO.Dispose();
}
return(this);
}
protected override IvrAlarmStatus ExecuteCommand()
{
try
{
//Initialize the CSqlDbCommand for execute the stored procedure
CSqlDbCommand cmd = new CSqlDbCommand(DBCommands.USP_NS_ISALARMCLEARDORBACKINRANGE);
//Bind IvrAlarmStatus property values as input parameters for procedure
// cmd.AddWithValue("AlarmID" , AlarmID);
cmd.AddWithValue("NotificationID", NotificationID);
cmd.AddWithValue("StoreID", StoreID);
// This stored procedure was change to an integer because on SQL 2000 the bit was being sent as a 'T' or an 'F' instead of a 1 or 0
//cmd.AddWithValue("IsSucceeded", Convert.ToInt32(IsSucceeded)); //call successed or not
//Execute command
CDAO.ExecReader(cmd);
//Bind output values to IvrAlarmStatus object
//if stored procedure returns a record, then it is either cleared,in-range, or in-process (call alert is not complete)
if (CDAO.DataReader.Read())
{
//if (CDAO.DataReader.HasRows)
IsAlarmClearedOrBackInRange = true;
}
else
{
IsAlarmClearedOrBackInRange = false;
}
}
catch
{
throw;
}
finally
{
CDAO.CloseDataReader();
CDAO.Dispose();
}
//return IvrAlarmStatus object
return(this);
}
protected override SensorTypeInfoList LoadList(BaseCriteria criteria)
{
try
{
Criteria listCriteria = (Criteria)criteria;
//Initialize the CSqlDbCommand for execute the stored procedure
CSqlDbCommand cmd = new CSqlDbCommand(DBCommands.USP_NS_GETSENSORTYPEINFOLIST, System.Data.CommandType.Text);
//Execute reader
CDAO.ExecReader(cmd);
while (CDAO.DataReader.Read())
{
SensorTypeInfo sensorTypeInfo = new SensorTypeInfo()
{
ID = CDAO.DataReader["RecID"].ToInt(),
Offset1 = CDAO.DataReader["Offset1"].ToDouble(),
Offset2 = CDAO.DataReader["Offset2"].ToDouble(),
Scale1 = CDAO.DataReader["Scale1"].ToDouble(1),
Scale2 = CDAO.DataReader["Scale2"].ToDouble(1),
UOM = CDAO.DataReader["UOM"].ToStr(),
Description = CDAO.DataReader["Description"].ToStr(CDAO.DataReader["SensorType"].ToStr()),
SensorType = CDAO.DataReader["SensorType"].ToStr(),
SubType = CDAO.DataReader["SubType"].ToStr(),
nDecimals = CDAO.DataReader["nDecimals"].ToInt(),
isTemp = CDAO.DataReader["isTemp"].ToBoolean()
};
this.Add(sensorTypeInfo);
}
}
catch
{
throw;
}
finally
{
CDAO.CloseDataReader();
CDAO.Dispose();
}
return(this);
}
/// <summary>
/// Record Notification
/// </summary>
/// <returns></returns>
protected override RecordNotification ExecuteCommand()
{
//Initialize the CSqlDbCommand for execute the stored procedure
CSqlDbCommand cmd = new CSqlDbCommand(DBCommands.USP_NS_RECORDNOTIFICATION, System.Data.CommandType.StoredProcedure);
cmd.AddWithValue("NotificationID", NotificationID);
cmd.AddWithValue("TransID", TransID);
cmd.AddWithValue("Status", (int)Status);
cmd.AddWithValue("LogText", LogText);
cmd.AddWithValue("NotifyType", (int)this.NotifyType);
//Execute command
CDAO.ExecCommand(cmd);
//Close the data reader.
CDAO.CloseDataReader();
CDAO.Dispose();
//return filled object.
return(this);
}
protected override MissedCommunicationList LoadList(BaseCriteria criteria)
{
try
{
//Initialize the CSqlDbCommand for execute the stored procedure
CSqlDbCommand cmd = new CSqlDbCommand(DBCommands.USP_NS_GETMISSEDCOMMUNICATION);
//Execute command
CDAO.ExecReader(cmd);
//Create new object to assign retrieved values.
while (CDAO.DataReader.Read())
{
MissedComm missedComm = new MissedComm();
missedComm.GroupName = CDAO.DataReader["GroupName"].ToStr();
missedComm.PuckName = CDAO.DataReader["PuckName"].ToStr();
missedComm.SensorType = CDAO.DataReader["SensorType"].ToStr();
missedComm.FactoryID = CDAO.DataReader["FactoryID"].ToStr();
missedComm.UTID = CDAO.DataReader["UTID"].ToStr();
missedComm.Probe = CDAO.DataReader["Probe"].ToInt();
missedComm.Interval = CDAO.DataReader["Interval"].ToInt();
missedComm.LogIntervalMins = CDAO.DataReader["LogIntervalMins"].ToInt();
missedComm.LastContact = CDAO.DataReader["LastContact"].ToDateTime();
this.Add(missedComm);
}
}
catch
{
throw;
}
finally
{
CDAO.CloseDataReader();
CDAO.Dispose();
}
//return filled object.
return(this);
}
protected override AlarmStatus ExecuteCommand()
{
try
{
//Initialize the CSqlDbCommand for execute the stored procedure
CSqlDbCommand cmd = new CSqlDbCommand(DBCommands.USP_NS_ISALARMCLEARDORBACKINRANGE);
//Bind IvrAlarmStatus property values as input parameters for procedure
cmd.AddWithValue("NotificationID", NotificationID);
cmd.AddWithValue("StoreID", StoreID);
//Execute command
CDAO.ExecReader(cmd);
//Bind output values to IvrAlarmStatus object
if (CDAO.DataReader.Read())
{
IsAlarmClearedOrBackInRange = true;
}
else
{
IsAlarmClearedOrBackInRange = false;
}
}
catch
{
throw;
}
finally
{
CDAO.CloseDataReader();
CDAO.Dispose();
}
//return IvrAlarmStatus object
return(this);
}
protected override MissedCommInfo ExecuteCommand()
{
try
{
//Initialize the CSqlDbCommand for execute the stored procedure
CSqlDbCommand cmd = new CSqlDbCommand(DBCommands.USP_NS_GETMISSEDCOMMSETTINGS);
int storeID = ConfigurationManager.AppSettings["StoreID"].ToInt();
cmd.AddWithValue("StoreID", storeID);
//Execute command
CDAO.ExecReader(cmd);
//Create new object to assign retrieved values.
if (CDAO.DataReader.Read())
{
this.StoreID = CDAO.DataReader["StoreID"].ToInt();
this.NotificationProfileID = CDAO.DataReader["NotificationProfileID"].ToInt();
this.SwitchBitmask = CDAO.DataReader["SwitchBitmask"].ToInt16();
this.PagerPrompt = CDAO.DataReader["PagerPrompt"].ToStr();
}
}
catch
{
throw;
}
finally
{
CDAO.CloseDataReader();
CDAO.Dispose();
}
//return filled object.
return(this);
}
/// <summary>
/// to fetch the notify id ,based on the notify profile id
/// </summary>
/// <returns></returns>
protected override NotificationProfile ExecuteCommand()
{
try
{
CSqlDbCommand cmd = new CSqlDbCommand(DBCommands.USP_NS_GETACTIVENOTIFICATIONS);
cmd.AddWithValue("ProfileID", NotifyProfileID);
cmd.AddWithValue("StoreID", StoreID);
CDAO.ExecReader(cmd);
if (CDAO.DataReader.Read())
{
NotifyType = CDAO.DataReader["NotifyType"].ToInt();
EmailNotifyID = CDAO.DataReader["EmailNotifyID"].ToInt();
PagerNotifyID = CDAO.DataReader["PagerNotifyID"].ToInt();
MsgBoardNotifyID = CDAO.DataReader["MsgBoardNotifyID"].ToInt();
NetSendNotifyID = CDAO.DataReader["NetSendNotifyID"].ToInt();
SwitchNotifyID = CDAO.DataReader["SwitchNotifyID"].ToInt();
PagerPrompt = CDAO.DataReader["PagerPrompt"].ToStr();
SwitchBitMask = CDAO.DataReader["SwitchBitMask"].ToInt();
IVR_UserID = CDAO.DataReader["IVR_UserID"].ToInt();
IsAlertEnabled = CDAO.DataReader["IsAlertEnabled"].ToBoolean();
ProfileName = CDAO.DataReader["ProfileName"].ToStr();
SMSNotifyID = CDAO.DataReader.HasColumn("SMSNotifyID") ? CDAO.DataReader["SMSNotifyID"] != null ? CDAO.DataReader["SMSNotifyID"].ToInt() : 0 : 0;
}
}
catch
{
throw;
}
finally
{
CDAO.CloseDataReader();
CDAO.Dispose();
}
return(this);
}
protected override OrganizationalUnitList LoadList(BaseCriteria criteria)
{
try
{
Criteria listCriteria = (Criteria)criteria;
//Initialize the CSqlDbCommand for execute the stored procedure
CSqlDbCommand cmd = new CSqlDbCommand(DBCommands.USP_ORGANIZATIONALUNITS);
//Execute reader
CDAO.ExecReader(cmd);
while (CDAO.DataReader.Read())
{
OrganizationalUnit orgUnit = new OrganizationalUnit()
{
OUID = CDAO.DataReader["OUID"].ToInt(),
OGID = CDAO.DataReader["OGID"].ToInt(),
OUName = CDAO.DataReader["OUName"].ToStr(),
DBName = CDAO.DataReader["DBName"].ToStr(),
DSN = CDAO.DataReader["DSN"].ToStr(),
isActive = CDAO.DataReader["isActive"].ToBoolean()
};
this.Add(orgUnit);
}
}
catch
{
throw;
}
finally
{
CDAO.CloseDataReader();
CDAO.Dispose();
}
return(this);
}
public void UpdateGenStoreValues()
{
GenStoreInfo genStoreInfo = null;
try
{
//Initialize the CSqlDbCommand for execute the stored procedure
CSqlDbCommand cmd = new CSqlDbCommand(DBCommands.USP_NS_GENSTORES);
int storeID = ConfigurationManager.AppSettings["StoreID"].ToInt();
cmd.AddWithValue("StoreID", storeID);
//Execute command
CDAO.ExecReader(cmd);
//Create new object to assign retrieved values.
if (CDAO.DataReader.Read())
{
genStoreInfo = new GenStoreInfo
{
//JH - 10/22/15
//setting the StoreID value was causing issue on lines 54-59 of NotificationEligibility
//StoreID = CDAO.DataReader["StoreID"].ToInt(),
FromAddress = CDAO.DataReader["EmailFromAddress"].ToStr(),
FromName = CDAO.DataReader["EmailFromName"].ToStr(),
SmtpSendMethod = CDAO.DataReader["SMTPSendMethod"].ToInt(),
SmtpAuthDomain = CDAO.DataReader["SMTPAuthDomain"].ToStr(),
SmtpAuthPassword = CDAO.DataReader["SMTPAuthPass"].ToStr(),
SmtpAuthUserName = CDAO.DataReader["SMTPAuthUser"].ToStr(),
SmtpFlags = CDAO.DataReader["SMTPFlags"].ToInt(),
SmtpPort = CDAO.DataReader["SMTPport"].ToInt(),
SmtpServer = CDAO.DataReader["SMTPserver"].ToStr(),
SNPPPort = CDAO.DataReader["SNPPPort"].ToInt(),
SNPPServer = CDAO.DataReader["SNPPServer"].ToStr(),
PagerComPort = CDAO.DataReader["PagerCOMport"].ToInt16(),
ComPortInitStr = CDAO.DataReader["COMportInitString"].ToStr(),
SMTPAuthMethod = CDAO.DataReader["SMTPAuthMethod"].ToStr(),
//for Mobile SMS
PIN1 = CDAO.DataReader["SMSPIN1"].ToStr(),
PIN2 = CDAO.DataReader["SMSPIN2"].ToStr(),
MobileCOMPort = CDAO.DataReader["SMSCOMPort"].ToStr(),
MobileCOMSettings = CDAO.DataReader["SMSSettings"].ToStr(),
SMSProviderServiceCenter = CDAO.DataReader["SMSServiceContactNo"].ToStr(),
StoreName = CDAO.DataReader["StoreName"].ToStr(),
StorePhoneNumber = CDAO.DataReader["Telephone"].ToStr(),
FrequencyBand = CDAO.DataReader.HasColumn("FrequencyBand") ? CDAO.DataReader["FrequencyBand"] != null ? CDAO.DataReader["FrequencyBand"].ToStr() : string.Empty : string.Empty,
CDYNE_ACCOUNT = CDAO.DataReader.HasColumn("IVRSvcAcctID") ? CDAO.DataReader["IVRSvcAcctID"] != null ? CDAO.DataReader["IVRSvcAcctID"].ToStr() : string.Empty : string.Empty
};
}
}
catch
{
throw;
}
finally
{
CDAO.CloseDataReader();
CDAO.Dispose();
}
_GenStoreInfo = genStoreInfo;
}
protected override CurrentStatusAlarmList LoadList(BaseCriteria baseCriteria)
{
try
{
Criteria criteria = (Criteria)baseCriteria;
CSqlDbCommand cmd = new CSqlDbCommand(DBCommands.USP_NS_ALARMCURRENTSTATUS, System.Data.CommandType.StoredProcedure);
cmd.Parameters.AddWithValue("action", "L");
// This stored procedure was changed to an integer because on SQL 2000 the bit was being sent as a 'T' or an 'F' instead of a 1 or 0
if (criteria.Fields != null)
{
cmd.Parameters.AddWithValue("isServiceRestarted", Convert.ToInt32(criteria.Fields["isServiceRestarted"]));
}
else
{
cmd.Parameters.AddWithValue("isServiceRestarted", DBNull.Value);
}
CDAO.ExecReader(cmd);
while (CDAO.DataReader.Read())
{
AlarmObject alarm = new AlarmObject();
alarm.UTID = CDAO.DataReader["UTID"].ToStr();
alarm.Probe = CDAO.DataReader["Probe"].ToInt();
alarm.ProbeName = CDAO.DataReader["ProbeName"].ToStr();
alarm.ProbeName2 = CDAO.DataReader["ProbeName2"].ToStr();
alarm.FactoryID = CDAO.DataReader["FactoryID"].ToStr();
alarm.AlarmType = CDAO.DataReader["AlarmType"].ToInt16();
alarm.AlarmID = CDAO.DataReader["AlarmID"].ToInt();
alarm.SensorType = CDAO.DataReader["SensorType"].ToStr();
alarm.SensorClass = CDAO.DataReader["SensorClass"].ToStr();
alarm.SensorAlarmID = CDAO.DataReader["SensorAlarmID"].ToStr();
alarm.AlarmTime = CDAO.DataReader["AlarmTime"].ToDateTime();
alarm.AlarmStartTime = CDAO.DataReader["AlarmStartTime"].ToDateTime();
alarm.Value = CDAO.DataReader["Value"].ToDecimal();
alarm.AlarmMaxValue = CDAO.DataReader["AlarmMaxValue"].ToDecimal();
alarm.AlarmMinValue = CDAO.DataReader["AlarmMinValue"].ToDecimal();
alarm.Threshold = CDAO.DataReader["Threshold"].ToInt();
alarm.CondThresholdMins = CDAO.DataReader["CondThresholdMins"].ToInt();
alarm.TimeOutOfRange = CDAO.DataReader["TimeOutOfRange"].ToInt();
alarm.NotificationID = CDAO.DataReader["NotificationID"].ToInt();
alarm.AlarmProfileID = CDAO.DataReader["AlarmProfileID"].ToInt();
alarm.NotifyProfileID = CDAO.DataReader["NotifyProfileID"].ToInt();
alarm.EscalationProfileID = CDAO.DataReader["EscalationProfileID"].ToInt();
alarm.PagerMessage = CDAO.DataReader["PagerMessage"].ToStr();
alarm.SwitchBitmask = CDAO.DataReader["SwitchBitmask"].ToInt16();
alarm.Severity = (Severity)CDAO.DataReader["Severity"].ToInt();
alarm.ResetNotifyOnUserAck = CDAO.DataReader["ResetNotifyOnUserAck"].ToBoolean();
alarm.ResetNotifyOnSensorNormalRange = CDAO.DataReader["ResetNotifyOnSensorNormalRange"].ToBoolean();
alarm.DisplayValue = CDAO.DataReader["DisplayValue"].ToStr();
// Only allow "ShowCelsius" flag to be set for "TEMP" type sensors
alarm.IsCelsius = CDAO.DataReader["IsCelsius"].ToBoolean();
alarm.GroupName = CDAO.DataReader["GroupName"].ToStr();
alarm.IsResumedNitification = CDAO.DataReader["IsResumedNitification"].ToBoolean();
alarm.NotificationStartTime = CDAO.DataReader["NotificationStartTime"].ToDateTime();
alarm.IsElapsed = CDAO.DataReader["IsElapsed"].ToBoolean();
alarm.NotificationType = CDAO.DataReader["NotificationType"].ToStr();
alarm.EscRecID = CDAO.DataReader["EscalationRecID"].ToInt();
alarm.NotificationSentCount = CDAO.DataReader["NotificationSentCount"].ToInt();
this.Add(alarm);
}
}
catch
{
throw;
}
finally
{
CDAO.CloseDataReader();
CDAO.Dispose();
}
return(this);
}
/// <summary>
/// Gets Email Body
/// </summary>
/// <returns></returns>
protected override EmailBody ExecuteCommand()
{
try
{
//Initialize the CSqlDbCommand for execute the stored procedure
CSqlDbCommand cmd = new CSqlDbCommand(DBCommands.SP_TTNOTIFY_EMAILBODY);
cmd.AddWithValue("emailFormat", EmailFormat);
cmd.AddWithValue("UTID", UTID);
cmd.AddWithValue("Probe", Probe);
//cmd.AddWithValue("logTime", LogTime);
if (LogTime.HasValue == true)
{
cmd.AddWithValue("logTime", ((DateTime)LogTime).ToString("yyyy-MM-dd HH:mm:ss"));
}
else
{
cmd.AddWithValue("logTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
}
cmd.AddWithValue("tzOffset", TzOffset);
cmd.AddWithValue("SensorReading", SensorReading);
if (AlarmStartTime.HasValue == true)
{
cmd.AddWithValue("AlarmStartTime", ((DateTime)AlarmStartTime).ToString("yyyy-MM-dd HH:mm:ss"));
}
else
{
cmd.AddWithValue("AlarmStartTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
}
cmd.AddWithValue("AlarmProfileRecID", AlarmProfileRecID);
cmd.AddWithValue("ThresholdMins", ThresholdMins);
cmd.AddWithValue("CondThresholdMins", CondThresholdMins);
cmd.AddWithValue("CondMinValue", CondMinValue);
cmd.AddWithValue("CondMaxValue", CondMaxValue);
cmd.AddWithValue("IncludeHistory", IncludeHistory);
cmd.AddWithValue("ValuesUOM", ValuesUOM);
cmd.AddWithValue("HTMLlink", HTMLlink);
cmd.AddWithValue("Severity", (int)Severity);
//Execute command
CDAO.ExecReader(cmd);
//Create new object to assign retrieved values.
while (CDAO.DataReader.Read())
{
this.Body = this.Body + CDAO.DataReader[0].ToStr();
CDAO.DataReader.NextResult();
}
}
catch
{
throw;
}
finally
{
CDAO.CloseDataReader();
CDAO.Dispose();
}
//return filled object.
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);
}
/// <summary>
/// Gets alarm list.
/// </summary>
/// <param name="criteria"></param>
/// <returns></returns>
protected override AlarmList LoadList(BaseCriteria criteria)
{
try
{
Criteria listCriteria = (Criteria)criteria;
//Initialize the CSqlDbCommand for execute the stored procedure
CSqlDbCommand cmd = new CSqlDbCommand(DBCommands.USP_NS_GET_ALARMLIST, System.Data.CommandType.StoredProcedure);
//Execute reader
CDAO.ExecReader(cmd);
bool flag = true;
System.Collections.Hashtable extFields = null;
List <string> fields = new List <string>();
while (CDAO.DataReader.Read())
{
//For the first time get all the field names
if (flag)
{
for (int index = 0; index < CDAO.DataReader.FieldCount; index++)
{
fields.Add(CDAO.DataReader.GetName(index));
}
//Remove known fields from the list.
fields.Remove("UTID");
fields.Remove("Probe");
fields.Remove("ProbeName");
fields.Remove("PuckDesc2");
fields.Remove("FactoryID");
fields.Remove("AlarmType");
fields.Remove("AlarmID");
fields.Remove("SensorType");
fields.Remove("SensorClass");
fields.Remove("Options");
fields.Remove("AlarmData");
fields.Remove("CondMaxValue");
fields.Remove("CondMinValue");
fields.Remove("CondThresholdMins");
fields.Remove("NotificationRecID");
fields.Remove("AlarmProfileRecID");
fields.Remove("NotificationProfileID");
fields.Remove("EscalationProfileID");
fields.Remove("AlarmTime");
fields.Remove("AlarmStartTime");
fields.Remove("PagerMessage");
fields.Remove("SwitchBitmask");
fields.Remove("Severity");
fields.Remove("GroupName");
fields.Remove("NotifyResetFlags");
flag = false;
}
extFields = new System.Collections.Hashtable();
//Adding all extra fields in to a hash table.
foreach (string item in fields)
{
extFields.Add(item, CDAO.DataReader[item]);
}
AlarmObject alarm = new AlarmObject();
alarm.AddtionalFields = extFields;
alarm.UTID = CDAO.DataReader["UTID"].ToStr();
alarm.Probe = CDAO.DataReader["Probe"].ToInt();
alarm.ProbeName = CDAO.DataReader["ProbeName"].ToStr();
alarm.ProbeName2 = CDAO.DataReader["PuckDesc2"].ToStr();
alarm.FactoryID = CDAO.DataReader["FactoryID"].ToStr();
alarm.AlarmType = CDAO.DataReader["AlarmType"].ToInt16();
alarm.AlarmID = CDAO.DataReader["AlarmID"].ToInt();
alarm.SensorType = CDAO.DataReader["SensorType"].ToStr();
alarm.SensorClass = CDAO.DataReader["SensorClass"].ToStr();
//alarm.IsNewAlarmRecordWasCreated = (CDAO.DataReader["Options"].ToInt() == 0 ? false : true);
if (alarm.AlarmType >= AlarmType.RESETMODE)
{
//if the alarm type is reset, then
alarm.SensorAlarmID = alarm.UTID + "_" + alarm.Probe + "_" + (alarm.AlarmType - AlarmType.RESETMODE).ToString();
}
else
{
alarm.SensorAlarmID = alarm.UTID + "_" + alarm.Probe + "_" + alarm.AlarmType.ToString();
}
alarm.AlarmTime = TypeCommonExtensions.IfNull(CDAO.DataReader["AlarmTime"], DateTime.UtcNow).ToDateTime();
alarm.AlarmStartTime = TypeCommonExtensions.IfNull(CDAO.DataReader["AlarmStartTime"], alarm.AlarmTime).ToDateTime();
if (alarm.AlarmStartTime == DateTime.MinValue || alarm.AlarmStartTime < DateTime.Parse("1/1/2000"))
{
alarm.AlarmStartTime = alarm.AlarmTime;
}
alarm.Value = CDAO.DataReader["AlarmData"].ToDecimal();
alarm.AlarmMaxValue = CDAO.DataReader["CondMaxValue"].ToDecimal();
alarm.AlarmMinValue = CDAO.DataReader["CondMinValue"].ToDecimal();
alarm.Threshold = Common.DateDiff("n", alarm.AlarmStartTime, alarm.AlarmTime);
alarm.CondThresholdMins = CDAO.DataReader["CondThresholdMins"].ToInt();
alarm.TimeOutOfRange = Common.DateDiff("n", alarm.AlarmStartTime, alarm.AlarmTime);
alarm.NotificationID = CDAO.DataReader["NotificationRecID"].ToInt();
alarm.AlarmProfileID = CDAO.DataReader["AlarmProfileRecID"].ToInt();
alarm.NotifyProfileID = CDAO.DataReader["NotificationProfileID"].ToInt();
alarm.EscalationProfileID = CDAO.DataReader["EscalationProfileID"].ToInt();
alarm.PagerMessage = CDAO.DataReader["PagerPrompt"].ToStr();
alarm.SwitchBitmask = CDAO.DataReader["SwitchBitmask"].ToInt16();
alarm.Severity = (Severity)CDAO.DataReader["Severity"].ToInt();
alarm.DisplayValue = alarm.Value.ToString();
alarm.ResetNotifyOnUserAck = (CDAO.DataReader["NotifyResetFlags"].ToInt() & 1).ToBoolean();
alarm.ResetNotifyOnSensorNormalRange = (CDAO.DataReader["NotifyResetFlags"].ToInt() & 2).ToBoolean();
if (AlarmHelper.IsContactSensor(alarm.SensorType))
{
if (alarm.Value == 0)
{
alarm.DisplayValue = "CLOSED";
}
else
{
alarm.DisplayValue = "OPEN";
}
}
// Only allow "ShowCelsius" flag to be set for "TEMP" type sensors
alarm.IsCelsius = (AlarmHelper.IsTempSensor(alarm.SensorType) ? (((CDAO.DataReader["NotifyFlags"].ToInt()) & 0x1) != 0) : false);
alarm.GroupName = CDAO.DataReader["GroupName"].ToStr();
//ProcessStatus will be returned as "O" if it is a old notification.
if (CDAO.DataReader["ProcessStatus"].ToStr() == "O")
{
alarm.IsResumedNitification = true;
}
else
{
alarm.IsResumedNitification = false;
}
this.Add(alarm);
}
}
catch
{
throw;
}
finally
{
CDAO.CloseDataReader();
// Added on 2/19/2012
// To dispose the data reader object
// Srinivas Rao E
CDAO.Dispose();
}
return(this);
}
