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);
}
