public RedirectController() { // Read the configuration specific information for this provider DotNetNuke.Framework.Providers.ProviderConfiguration _providerConfiguration = DotNetNuke.Framework.Providers.ProviderConfiguration.GetProviderConfiguration("data"); DotNetNuke.Framework.Providers.Provider objProvider = (DotNetNuke.Framework.Providers.Provider)_providerConfiguration.Providers[_providerConfiguration.DefaultProvider]; // Read the attributes for this provider //Get Connection string from web.config string _connectionString = DotNetNuke.Common.Utilities.Config.GetConnectionString(); if (_connectionString == "") { // Use connection string specified in provider _connectionString = objProvider.Attributes["connectionString"]; } string _providerPath = objProvider.Attributes["providerPath"]; _objectQualifier = objProvider.Attributes["objectQualifier"]; if (_objectQualifier != "" & _objectQualifier.EndsWith("_") == false) { _objectQualifier += "_"; } _databaseOwner = objProvider.Attributes["databaseOwner"]; if (_databaseOwner != "" & _databaseOwner.EndsWith(".") == false) { _databaseOwner += "."; } }
private static long GetEmailInfo(int siteID, int instanceID, int forumID, int topicID, string ipAddress) { long ItemID = -1; DotNetNuke.Framework.Providers.ProviderConfiguration _providerConfiguration = DotNetNuke.Framework.Providers.ProviderConfiguration.GetProviderConfiguration("data"); string connectionString; string objectQualifier; string databaseOwner; connectionString = ConfigurationManager.ConnectionStrings["SiteSqlServer"].ConnectionString; var objProvider = (DotNetNuke.Framework.Providers.Provider)(_providerConfiguration.Providers[_providerConfiguration.DefaultProvider]); objectQualifier = objProvider.Attributes["objectQualifier"]; if (objectQualifier != "" && objectQualifier.EndsWith("_") == false) { objectQualifier += "_"; } databaseOwner = objProvider.Attributes["databaseOwner"]; if (databaseOwner != "" && databaseOwner.EndsWith(".") == false) { databaseOwner += "."; } StringBuilder userIds = new StringBuilder(); userIds.Append("("); SubscriptionInfo[] arrSubscriptionInfo = lstSubscriptionInfo.ToArray(); for (int i = 0; i < arrSubscriptionInfo.Length; i++) { userIds.Append(arrSubscriptionInfo[i].UserId); if (i < arrSubscriptionInfo.Length - 1) { userIds.Append(","); } else { userIds.Append(")"); } } //dbPrefix = databaseOwner + objectQualifier + databaseObjectPrefix; IDataReader dataReader = (IDataReader)(SqlHelper.ExecuteReader(connectionString, databaseOwner + objectQualifier + "ActiveForumsEmailConnector_GetEmailInfo", siteID, instanceID, forumID, topicID, ipAddress, userIds.ToString())); if (dataReader.Read()) { ItemID = Convert.ToInt32(dataReader["RecordID"]); } return(ItemID); }