public static NotificationProvider LoadNotificationProvider(string connectionString, int SQLCommandTimeout) { NotificationProvider provider = new NotificationProvider(SQLCommandTimeout); try { if (!string.IsNullOrEmpty(connectionString)) { // Retrieve server information. LOG.Info("Retrieve NotificationProvider"); using (SqlConnection connection = new SqlConnection(connectionString) ) { // Open the connection. connection.Open(); using (SqlDataReader rdr = provider.ExecuteLocalReader(connection, null, CommandType.Text, QueryGetNotificationProvider, null)) { while (rdr.Read()) { provider.setValues(rdr); } } } } } catch (SqlException ex) { LOG.Error(string.Format("Error loading Notification Provider: {0}", ex.ToString())); } catch (Exception ex) { LOG.Error(string.Format("Error loading Notification Provider: {0}", ex.ToString())); } return(provider); }
public void RefreshNotificationProvider() { m_notificationProvider = Idera.SQLsecure.Core.Accounts.NotificationProvider.LoadNotificationProvider(m_ConnectionStringBuilder.ConnectionString, Utility.SQLCommandTimeout.GetSQLCommandTimeoutFromRegistry()); }