private static GeographicProvider GetCurrentObject()
{
// Get the names of providers
var config = ProviderConfiguration.GetProviderConfiguration(ProviderType);
// Read specific configuration information for this provider
var providerSettings = (ProviderSettings)config.Providers[config.DefaultProvider];
// In the cache?
var cacheKey = "Appleseed::Web::GeographicProvider::" + config.DefaultProvider;
if (CurrentCache[cacheKey] == null)
{
// The assembly should be in \bin or GAC, so we simply need
// to get an instance of the type
try
{
CurrentCache.Insert(
cacheKey, ProviderHelper.InstantiateProvider(providerSettings, typeof(GeographicProvider)));
}
catch (Exception e)
{
throw new Exception("Unable to load provider", e);
}
}
return((GeographicProvider)CurrentCache[cacheKey]);
}
public static IDbConnection GetConnection()
{
const string providerType = "data";
ProviderConfiguration providerConfiguration = ProviderConfiguration.GetProviderConfiguration(providerType);
var objProvider = ((Provider)providerConfiguration.Providers[providerConfiguration.DefaultProvider]);
string connectionString;
if (!String.IsNullOrEmpty(objProvider.Attributes["connectionStringName"]) && !String.IsNullOrEmpty(System.Configuration.ConfigurationManager.AppSettings[objProvider.Attributes["connectionStringName"]]))
{
connectionString = System.Configuration.ConfigurationManager.AppSettings[objProvider.Attributes["connectionStringName"]];
}
else
{
connectionString = objProvider.Attributes["connectionString"];
}
IDbConnection newConnection = new System.Data.SqlClient.SqlConnection
{
ConnectionString = connectionString
};
newConnection.Open();
return(newConnection);
}
public List <LogFile> GetUpgradeLogList()
{
var objProviderConfiguration = ProviderConfiguration.GetProviderConfiguration("data");
var strProviderPath = DataProvider.Instance().GetProviderPath();
return(GetLogList(strProviderPath, "*.log.resources"));
}
/// <summary>
/// Instances this instance.
/// </summary>
/// <returns></returns>
public static UrlBuilderProvider Instance()
{
// Use the cache because the reflection used later is expensive
Cache cache = HttpRuntime.Cache;
string cacheKey;
// Get the names of providers
ProviderConfiguration config = ProviderConfiguration.GetProviderConfiguration(providerType);
// Read specific configuration information for this provider
//ProviderSettings providerSettings = (ProviderSettings) config.Providers[config.DefaultProvider];
AppleseedProviderSettings providerSettings = (AppleseedProviderSettings)config.Providers[config.DefaultProvider];
// In the cache?
cacheKey = "Appleseed::Web::UrlBuilder::" + config.DefaultProvider;
if (cache[cacheKey] == null)
{
// The assembly should be in \bin or GAC, so we simply need
// to get an instance of the type
try
{
cache.Insert(cacheKey,
ProviderHelper.InstantiateProvider(providerSettings, typeof(UrlBuilderProvider)));
}
catch (Exception e)
{
throw new Exception("Unable to load provider", e);
}
}
return((UrlBuilderProvider)cache[cacheKey]);
}
private static string GetFriendlyUrlType(string friendlyUrlProvider)
{
var urlProvider = (Provider)ProviderConfiguration.GetProviderConfiguration("friendlyUrl").Providers[friendlyUrlProvider];
var urlFormat = urlProvider.Attributes["urlformat"];
return(string.IsNullOrWhiteSpace(urlFormat) ? "SearchFriendly" : FirstCharToUpper(urlFormat));
}
private esProviderSpecificMetadata esDefault(string mapName)
{
if (!m_providerMetadataMaps.ContainsKey(mapName))
{
esProviderSpecificMetadata meta = new esProviderSpecificMetadata();
meta.AddTypeMap("RateId", new esTypeMap("int", "System.Int32"));
meta.AddTypeMap("CountryCode", new esTypeMap("nvarchar", "System.String"));
meta.AddTypeMap("Region", new esTypeMap("nvarchar", "System.String"));
meta.AddTypeMap("WeightMin", new esTypeMap("decimal", "System.Decimal"));
meta.AddTypeMap("WeightMax", new esTypeMap("decimal", "System.Decimal"));
meta.AddTypeMap("Cost", new esTypeMap("money", "System.Decimal"));
meta.AddTypeMap("RateTypeId", new esTypeMap("int", "System.Int32"));
meta.AddTypeMap("RateTypeName", new esTypeMap("varchar", "System.String"));
meta.AddTypeMap("RateTypeDisplayName", new esTypeMap("varchar", "System.String"));
meta.AddTypeMap("RateTypeIsEnabled", new esTypeMap("bit", "System.Boolean"));
meta.AddTypeMap("RateTypeSortOrder", new esTypeMap("smallint", "System.Int16"));
ProviderConfiguration providerConfiguration = ProviderConfiguration.GetProviderConfiguration("data");
Provider provider = (Provider)providerConfiguration.Providers[providerConfiguration.DefaultProvider];
string objectQualifier = provider.Attributes["objectQualifier"];
if ((objectQualifier != string.Empty) && (objectQualifier.EndsWith("_") == false))
{
objectQualifier += "_";
}
if (objectQualifier != string.Empty)
{
meta.Source = objectQualifier + "vDNNspot_Store_ShippingServiceRates";
meta.Destination = objectQualifier + "vDNNspot_Store_ShippingServiceRates";
meta.spInsert = objectQualifier + "proc_vDNNspot_Store_ShippingServiceRatesInsert";
meta.spUpdate = objectQualifier + "proc_vDNNspot_Store_ShippingServiceRatesUpdate";
meta.spDelete = objectQualifier + "proc_vDNNspot_Store_ShippingServiceRatesDelete";
meta.spLoadAll = objectQualifier + "proc_vDNNspot_Store_ShippingServiceRatesLoadAll";
meta.spLoadByPrimaryKey = objectQualifier + "proc_vDNNspot_Store_ShippingServiceRatesLoadByPrimaryKey";
}
else
{
meta.Source = "vDNNspot_Store_ShippingServiceRates";
meta.Destination = "vDNNspot_Store_ShippingServiceRates";
meta.spInsert = "proc_vDNNspot_Store_ShippingServiceRatesInsert";
meta.spUpdate = "proc_vDNNspot_Store_ShippingServiceRatesUpdate";
meta.spDelete = "proc_vDNNspot_Store_ShippingServiceRatesDelete";
meta.spLoadAll = "proc_vDNNspot_Store_ShippingServiceRatesLoadAll";
meta.spLoadByPrimaryKey = "proc_vDNNspot_Store_ShippingServiceRatesLoadByPrimaryKey";
}
this.m_providerMetadataMaps["esDefault"] = meta;
}
return(this.m_providerMetadataMaps["esDefault"]);
}
public SqlDataProvider()
{
providerConfiguration = ProviderConfiguration.GetProviderConfiguration(ProviderType);
// Read the configuration specific information for this provider
Provider objProvider = (Provider)providerConfiguration.Providers[providerConfiguration.DefaultProvider];
// Read the attributes for this provider
//Get Connection string from web.config
connectionString = Config.GetConnectionString();
if (connectionString == "")
{
// Use connection string specified in provider
connectionString = objProvider.Attributes["connectionString"];
}
providerPath = objProvider.Attributes["providerPath"];
objectQualifier = objProvider.Attributes["objectQualifier"];
if (!String.IsNullOrEmpty(objectQualifier) && objectQualifier.EndsWith("_") == false)
{
objectQualifier += "_";
}
databaseOwner = objProvider.Attributes["databaseOwner"];
if (!String.IsNullOrEmpty(databaseOwner) && databaseOwner.EndsWith(".") == false)
{
databaseOwner += ".";
}
}
public SqlDataProvider()
{
this._providerConfiguration = ProviderConfiguration.GetProviderConfiguration(ReportsConstants.ProviderType);
// Read the configuration specific information for this provider
var objProvider =
(Provider)this._providerConfiguration.Providers[this._providerConfiguration.DefaultProvider];
// Read the attributes for this provider
//Get Connection string from web.config
this._connectionString = Config.GetConnectionString();
if (string.IsNullOrEmpty(this._connectionString))
{
// Use connection string specified in provider
this._connectionString = objProvider.Attributes["connectionString"];
}
this._providerPath = objProvider.Attributes["providerPath"];
this._objectQualifier = objProvider.Attributes["objectQualifier"];
if (!string.IsNullOrEmpty(this._objectQualifier) && this._objectQualifier.EndsWith("_") == false)
{
this._objectQualifier += "_";
}
this._databaseOwner = objProvider.Attributes["databaseOwner"];
if (!string.IsNullOrEmpty(this._databaseOwner) && this._databaseOwner.EndsWith(".") == false)
{
this._databaseOwner += ".";
}
}
/// <summary>
/// Prevents a default instance of the <see cref="SqlDataProvider"/> class from being created.
/// </summary>
private SqlDataProvider()
{
// Read the configuration specific information for this provider
ProviderConfiguration providerConfiguration = ProviderConfiguration.GetProviderConfiguration("data");
Provider sqlDataProviderConfigSection = (Provider)providerConfiguration.Providers[providerConfiguration.DefaultProvider];
if (!string.IsNullOrEmpty(sqlDataProviderConfigSection.Attributes["connectionStringName"]) && !string.IsNullOrEmpty(ConfigurationManager.AppSettings[sqlDataProviderConfigSection.Attributes["connectionStringName"]]))
{
this.connectionString = ConfigurationManager.AppSettings[sqlDataProviderConfigSection.Attributes["connectionStringName"]];
}
else
{
this.connectionString = sqlDataProviderConfigSection.Attributes["connectionString"];
}
this.objectQualifier = sqlDataProviderConfigSection.Attributes["objectQualifier"];
if (!string.IsNullOrEmpty(this.objectQualifier) && !this.objectQualifier.EndsWith("_", StringComparison.OrdinalIgnoreCase))
{
this.objectQualifier += "_";
}
this.databaseOwner = sqlDataProviderConfigSection.Attributes["databaseOwner"];
if (!string.IsNullOrEmpty(this.databaseOwner) && !this.databaseOwner.EndsWith(".", StringComparison.OrdinalIgnoreCase))
{
this.databaseOwner += ".";
}
}
public static Provider GetProvider(string type, string name)
{
ProviderConfiguration providerConfiguration = ProviderConfiguration.GetProviderConfiguration(type);
//Read the configuration specific information for this provider
return((Provider)providerConfiguration.Providers[name]);
}
private bool IsTrialFiftyOneProvider()
{
var provider = ProviderConfiguration.GetProviderConfiguration("clientcapability");
return(provider.DefaultProvider == "FiftyOneClientCapabilityProvider" &&
!ClientCapabilityProvider.Instance().SupportsTabletDetection);
}
public static void InitURLLibrary(Control control)
{
string Message = "This module requires that you're running \"advanced\" mode of DNN URL Rewriter. Legacy modes such as \"HumanFriendly\" & \"SearchFriendly\" are not supported. Feel free to open a support ticket at Vanjaro.com for further assistance.";
if (HttpContext.Current.Application.AllKeys.Contains("Common-Rewriter"))
{
if (HttpContext.Current.Application["Common-Rewriter"].ToString() != "advanced")
{
Skin.AddModuleMessage(control, Message, DotNetNuke.UI.Skins.Controls.ModuleMessage.ModuleMessageType.RedError);
}
}
else
{
ProviderConfiguration ProviderConfiguration = ProviderConfiguration.GetProviderConfiguration("friendlyUrl");
if (ProviderConfiguration != null && !string.IsNullOrEmpty(ProviderConfiguration.DefaultProvider) && ProviderConfiguration.DefaultProvider.ToLower() == "dnnfriendlyurl")
{
string item = ((Provider)ProviderConfiguration.Providers[ProviderConfiguration.DefaultProvider]).Attributes["urlformat"];
if (string.IsNullOrWhiteSpace(item))
{
item = "searchfriendly";
}
if (item.ToLower() != "advanced")
{
Skin.AddModuleMessage(control, Message, DotNetNuke.UI.Skins.Controls.ModuleMessage.ModuleMessageType.RedError);
}
HttpContext.Current.Application.Add("Common-Rewriter", item.ToLower());
}
else
{
HttpContext.Current.Application.Add("Common-Rewriter", "advanced");
}
}
}
public static Provider GetDefaultProvider(string type)
{
ProviderConfiguration providerConfiguration = ProviderConfiguration.GetProviderConfiguration(type);
//Read the configuration specific information for this provider
return(providerConfiguration.Providers[providerConfiguration.DefaultProvider] as Provider);
}
private void ParseFolder(DirectoryInfo folder, ref ZipOutputStream resourcesFile)
{
//Add the resource files
AddSourceFiles(folder, "*.sln", ref resourcesFile);
AddSourceFiles(folder, "*.??proj", ref resourcesFile);
AddSourceFiles(folder, "*.cs", ref resourcesFile);
AddSourceFiles(folder, "*.vb", ref resourcesFile);
AddSourceFiles(folder, "*.resx", ref resourcesFile);
//Check for Provider scripts
ProviderConfiguration objProviderConfiguration = ProviderConfiguration.GetProviderConfiguration("data");
foreach (DictionaryEntry entry in objProviderConfiguration.Providers)
{
Provider objProvider = (Provider)entry.Value;
string providerName = objProvider.Name;
AddSourceFiles(folder, "*." + providerName, ref resourcesFile);
}
//Get the sub-folders in the folder
DirectoryInfo[] folders = folder.GetDirectories();
//Recursively call ParseFolder to add files from sub-folder tree
foreach (DirectoryInfo subfolder in folders)
{
ParseFolder(subfolder, ref resourcesFile);
}
}
private void CheckForAdvanced()
{
bool advancedEnabled = false;
ProviderConfiguration fupConfig = ProviderConfiguration.GetProviderConfiguration("friendlyUrl");
if (fupConfig != null)
{
string defaultFriendlyUrlProvider = fupConfig.DefaultProvider;
var provider = (Provider)fupConfig.Providers[defaultFriendlyUrlProvider];
string urlFormat = provider.Attributes["urlFormat"];
if (!string.IsNullOrEmpty(urlFormat))
{
if (urlFormat.ToLower() == UrlFormatType.Advanced.ToString().ToLower())
{
advancedEnabled = true;
}
}
}
if (!advancedEnabled)
{
DotNetNuke.UI.Skins.Skin.AddModuleMessage(this, "<h3>Advanced Mode Not Enabled</h3><p>You must enable the DNN Advanced URL Rewritting capabilities in the web.config.</p><p><a href='http://www.dnnsoftware.com/wiki/Page/Activating-Advanced-Url-Management'>See Wiki</a></p>", ModuleMessage.ModuleMessageType.YellowWarning);
}
}
/// <summary>
/// Initializes a new instance of the <see cref="SqlDataProvider"/> class.
/// </summary>
public SqlDataProvider()
{
// Read the configuration specific information for this provider
ProviderConfiguration providerConfiguration = ProviderConfiguration.GetProviderConfiguration(ProviderType);
Provider objProvider = (Provider)providerConfiguration.Providers[providerConfiguration.DefaultProvider];
// Read the attributes for this provider
// Get Connection string from web.config
this.connectionString = Config.GetConnectionString();
if (string.IsNullOrEmpty(this.connectionString))
{
// Use connection string specified in provider
this.connectionString = objProvider.Attributes["connectionString"];
}
this.objectQualifier = objProvider.Attributes["objectQualifier"];
if (!string.IsNullOrEmpty(this.objectQualifier) && !this.objectQualifier.EndsWith("_", StringComparison.Ordinal))
{
this.objectQualifier += "_";
}
this.databaseOwner = objProvider.Attributes["databaseOwner"];
if (!string.IsNullOrEmpty(this.databaseOwner) && !this.databaseOwner.EndsWith(".", StringComparison.Ordinal))
{
this.databaseOwner += ".";
}
}
public HttpResponseMessage GetSmtpSettings()
{
try
{
var portalId = PortalSettings.Current.PortalId;
var smtpSettings = new
{
smtpServerMode = PortalController.GetPortalSetting("SMTPmode", portalId, "h"),
host = new { },
site = new
{
smtpServer = PortalController.GetPortalSetting("SMTPServer", portalId, string.Empty),
smtpConnectionLimit = PortalController.GetPortalSettingAsInteger("SMTPConnectionLimit", portalId, 2),
smtpMaxIdleTime = PortalController.GetPortalSettingAsInteger("SMTPMaxIdleTime", portalId, 100000),
smtpAuthentication = PortalController.GetPortalSetting("SMTPAuthentication", portalId, "0"),
enableSmtpSsl = PortalController.GetPortalSetting("SMTPEnableSSL", portalId, string.Empty) == "Y",
smtpUserName = PortalController.GetPortalSetting("SMTPUsername", portalId, string.Empty),
smtpPassword = PortalController.GetEncryptedString("SMTPPassword", portalId, Config.GetDecryptionkey()),
},
portalName = PortalSettings.Current.PortalName,
hideCoreSettings = ProviderConfiguration.GetProviderConfiguration("mail").GetDefaultProvider().Attributes.GetValueOrDefault("hideCoreSettings", false),
};
return(this.Request.CreateResponse(HttpStatusCode.OK, smtpSettings));
}
catch (Exception exc)
{
Logger.Error(exc);
return(this.Request.CreateErrorResponse(HttpStatusCode.InternalServerError, exc));
}
}
/// <summary>
/// 静态构造方法
/// </summary>
static DataProviderProvider()
{
string assembly = null;
try
{
ProviderConfiguration configuration = ProviderConfiguration.GetProviderConfiguration("data");
// 配置节点[data]不能为空
if (configuration == null)
{
throw new ConfigurationErrorsException();
}
// 配置节点[providers]不能为空
if (configuration.Providers == null || configuration.Providers.Count == 0)
{
throw new ConfigurationErrorsException();
}
// 配置属性[defaultProvider]不能为空
if (string.IsNullOrEmpty(configuration.DefaultProviderName))
{
throw new ConfigurationErrorsException();
}
Provider provider = configuration.Providers[configuration.DefaultProviderName];
// 默认的[provider]不能为空
if (provider == null)
{
throw new ConfigurationErrorsException();
}
assembly = provider.Attributes["assembly"];
// 配置属性[assembly]不能为空
if (string.IsNullOrEmpty(assembly))
{
throw new ConfigurationErrorsException();
}
}
catch (Exception ex)
{
ex.Data["Method"] = string.Format("数据适配器配置文件错误:{0}", ex.Message);
new ExceptionHelper().LogException(ex);
}
try
{
// 加载数据适配器程序集
m_Assembly = Assembly.Load(assembly);
}
catch (Exception ex)
{
ex.Data["Method"] = string.Format("程序集加载失败。{0}。", ex.Message);
new ExceptionHelper().LogException(ex);
}
}
private esProviderSpecificMetadata esDefault(string mapName)
{
if (!m_providerMetadataMaps.ContainsKey(mapName))
{
esProviderSpecificMetadata meta = new esProviderSpecificMetadata();
meta.AddTypeMap("Id", new esTypeMap("uniqueidentifier", "System.Guid"));
meta.AddTypeMap("OrderId", new esTypeMap("int", "System.Int32"));
meta.AddTypeMap("PaymentProviderId", new esTypeMap("smallint", "System.Int16"));
meta.AddTypeMap("GatewayUrl", new esTypeMap("nvarchar", "System.String"));
meta.AddTypeMap("GatewayTransactionId", new esTypeMap("nvarchar", "System.String"));
meta.AddTypeMap("GatewayResponse", new esTypeMap("nvarchar", "System.String"));
meta.AddTypeMap("GatewayDebugResponse", new esTypeMap("nvarchar", "System.String"));
meta.AddTypeMap("GatewayError", new esTypeMap("nvarchar", "System.String"));
meta.AddTypeMap("Amount", new esTypeMap("money", "System.Decimal"));
meta.AddTypeMap("CreatedOn", new esTypeMap("datetime", "System.DateTime"));
ProviderConfiguration providerConfiguration = ProviderConfiguration.GetProviderConfiguration("data");
Provider provider = (Provider)providerConfiguration.Providers[providerConfiguration.DefaultProvider];
string objectQualifier = provider.Attributes["objectQualifier"];
if ((objectQualifier != string.Empty) && (objectQualifier.EndsWith("_") == false))
{
objectQualifier += "_";
}
if (objectQualifier != string.Empty)
{
meta.Source = objectQualifier + "DNNspot_Store_PaymentTransaction";
meta.Destination = objectQualifier + "DNNspot_Store_PaymentTransaction";
meta.spInsert = objectQualifier + "proc_DNNspot_Store_PaymentTransactionInsert";
meta.spUpdate = objectQualifier + "proc_DNNspot_Store_PaymentTransactionUpdate";
meta.spDelete = objectQualifier + "proc_DNNspot_Store_PaymentTransactionDelete";
meta.spLoadAll = objectQualifier + "proc_DNNspot_Store_PaymentTransactionLoadAll";
meta.spLoadByPrimaryKey = objectQualifier + "proc_DNNspot_Store_PaymentTransactionLoadByPrimaryKey";
}
else
{
meta.Source = "DNNspot_Store_PaymentTransaction";
meta.Destination = "DNNspot_Store_PaymentTransaction";
meta.spInsert = "proc_DNNspot_Store_PaymentTransactionInsert";
meta.spUpdate = "proc_DNNspot_Store_PaymentTransactionUpdate";
meta.spDelete = "proc_DNNspot_Store_PaymentTransactionDelete";
meta.spLoadAll = "proc_DNNspot_Store_PaymentTransactionLoadAll";
meta.spLoadByPrimaryKey = "proc_DNNspot_Store_PaymentTransactionLoadByPrimaryKey";
}
this.m_providerMetadataMaps["esDefault"] = meta;
}
return(this.m_providerMetadataMaps["esDefault"]);
}
public static bool ShowPageUrls()
{
var fupConfig = ProviderConfiguration.GetProviderConfiguration("friendlyUrl");
var defaultFriendlyUrlProvider = fupConfig.DefaultProvider;
var showPageUrls = defaultFriendlyUrlProvider == "HccFriendlyUrl";
return(showPageUrls);
}
private esProviderSpecificMetadata esDefault(string mapName)
{
if (!m_providerMetadataMaps.ContainsKey(mapName))
{
esProviderSpecificMetadata meta = new esProviderSpecificMetadata();
meta.AddTypeMap("Id", new esTypeMap("int", "System.Int32"));
meta.AddTypeMap("ProductId", new esTypeMap("int", "System.Int32"));
meta.AddTypeMap("WidgetType", new esTypeMap("varchar", "System.String"));
meta.AddTypeMap("Name", new esTypeMap("nvarchar", "System.String"));
meta.AddTypeMap("IsRequired", new esTypeMap("bit", "System.Boolean"));
meta.AddTypeMap("PriceAdjustment", new esTypeMap("money", "System.Decimal"));
meta.AddTypeMap("WeightAdjustment", new esTypeMap("decimal", "System.Decimal"));
meta.AddTypeMap("SortOrder", new esTypeMap("smallint", "System.Int16"));
meta.AddTypeMap("Slug", new esTypeMap("nvarchar", "System.String"));
ProviderConfiguration providerConfiguration = ProviderConfiguration.GetProviderConfiguration("data");
Provider provider = (Provider)providerConfiguration.Providers[providerConfiguration.DefaultProvider];
string objectQualifier = provider.Attributes["objectQualifier"];
if ((objectQualifier != string.Empty) && (objectQualifier.EndsWith("_") == false))
{
objectQualifier += "_";
}
if (objectQualifier != string.Empty)
{
meta.Source = objectQualifier + "DNNspot_Store_ProductField";
meta.Destination = objectQualifier + "DNNspot_Store_ProductField";
meta.spInsert = objectQualifier + "proc_DNNspot_Store_ProductFieldInsert";
meta.spUpdate = objectQualifier + "proc_DNNspot_Store_ProductFieldUpdate";
meta.spDelete = objectQualifier + "proc_DNNspot_Store_ProductFieldDelete";
meta.spLoadAll = objectQualifier + "proc_DNNspot_Store_ProductFieldLoadAll";
meta.spLoadByPrimaryKey = objectQualifier + "proc_DNNspot_Store_ProductFieldLoadByPrimaryKey";
}
else
{
meta.Source = "DNNspot_Store_ProductField";
meta.Destination = "DNNspot_Store_ProductField";
meta.spInsert = "proc_DNNspot_Store_ProductFieldInsert";
meta.spUpdate = "proc_DNNspot_Store_ProductFieldUpdate";
meta.spDelete = "proc_DNNspot_Store_ProductFieldDelete";
meta.spLoadAll = "proc_DNNspot_Store_ProductFieldLoadAll";
meta.spLoadByPrimaryKey = "proc_DNNspot_Store_ProductFieldLoadByPrimaryKey";
}
this.m_providerMetadataMaps["esDefault"] = meta;
}
return(this.m_providerMetadataMaps["esDefault"]);
}
/// <summary>
/// Instances this instance.
/// </summary>
/// <returns></returns>
public static DataProvider Instance()
{
// Get the name of the provider
ProviderConfiguration objProviderConfiguration =
ProviderConfiguration.GetProviderConfiguration(ProviderType);
// Instanciate the provider
return(Instance(objProviderConfiguration.DefaultProvider, objProviderConfiguration));
}
/// <summary>
/// Gets the default connection String as specified in the provider.
/// </summary>
/// <returns>The connection String</returns>
/// <remarks></remarks>
public static string GetConnectionString()
{
ProviderConfiguration _providerConfiguration = ProviderConfiguration.GetProviderConfiguration("data");
// Read the configuration specific information for this provider
Provider objProvider = (Provider)_providerConfiguration.Providers[_providerConfiguration.DefaultProvider];
return(GetConnectionString(objProvider.Attributes["connectionStringName"]));
}
private static string GetDbOwner()
{
ProviderConfiguration providerConfiguration = ProviderConfiguration.GetProviderConfiguration("data");
Provider provider = (Provider)providerConfiguration.Providers[providerConfiguration.DefaultProvider];
string dbOwner = provider.Attributes["databaseOwner"];
return(dbOwner);
}
/// <summary>
/// Instances the specified provider name.
/// </summary>
/// <param name="providerName">Name of the provider.</param>
/// <returns></returns>
public static DataProvider Instance(string providerName)
{
// Get the name of the provider
ProviderConfiguration objProviderConfiguration =
ProviderConfiguration.GetProviderConfiguration(ProviderType);
// Instanciate the provider
return(Instance(providerName, objProviderConfiguration));
}
private esProviderSpecificMetadata esDefault(string mapName)
{
if (!m_providerMetadataMaps.ContainsKey(mapName))
{
esProviderSpecificMetadata meta = new esProviderSpecificMetadata();
meta.AddTypeMap("Id", new esTypeMap("int", "System.Int32"));
meta.AddTypeMap("CartId", new esTypeMap("uniqueidentifier", "System.Guid"));
meta.AddTypeMap("ProductId", new esTypeMap("int", "System.Int32"));
meta.AddTypeMap("Quantity", new esTypeMap("int", "System.Int32"));
meta.AddTypeMap("ProductFieldData", new esTypeMap("nvarchar", "System.String"));
meta.AddTypeMap("CreatedOn", new esTypeMap("datetime", "System.DateTime"));
meta.AddTypeMap("ModifiedOn", new esTypeMap("datetime", "System.DateTime"));
ProviderConfiguration providerConfiguration = ProviderConfiguration.GetProviderConfiguration("data");
Provider provider = (Provider)providerConfiguration.Providers[providerConfiguration.DefaultProvider];
string objectQualifier = provider.Attributes["objectQualifier"];
if ((objectQualifier != string.Empty) && (objectQualifier.EndsWith("_") == false))
{
objectQualifier += "_";
}
if (objectQualifier != string.Empty)
{
meta.Source = objectQualifier + "DNNspot_Store_CartItem";
meta.Destination = objectQualifier + "DNNspot_Store_CartItem";
meta.spInsert = objectQualifier + "proc_DNNspot_Store_CartItemInsert";
meta.spUpdate = objectQualifier + "proc_DNNspot_Store_CartItemUpdate";
meta.spDelete = objectQualifier + "proc_DNNspot_Store_CartItemDelete";
meta.spLoadAll = objectQualifier + "proc_DNNspot_Store_CartItemLoadAll";
meta.spLoadByPrimaryKey = objectQualifier + "proc_DNNspot_Store_CartItemLoadByPrimaryKey";
}
else
{
meta.Source = "DNNspot_Store_CartItem";
meta.Destination = "DNNspot_Store_CartItem";
meta.spInsert = "proc_DNNspot_Store_CartItemInsert";
meta.spUpdate = "proc_DNNspot_Store_CartItemUpdate";
meta.spDelete = "proc_DNNspot_Store_CartItemDelete";
meta.spLoadAll = "proc_DNNspot_Store_CartItemLoadAll";
meta.spLoadByPrimaryKey = "proc_DNNspot_Store_CartItemLoadByPrimaryKey";
}
this.m_providerMetadataMaps["esDefault"] = meta;
}
return(this.m_providerMetadataMaps["esDefault"]);
}
private esProviderSpecificMetadata esDefault(string mapName)
{
if (!m_providerMetadataMaps.ContainsKey(mapName))
{
esProviderSpecificMetadata meta = new esProviderSpecificMetadata();
meta.AddTypeMap("Code", new esTypeMap("varchar", "System.String"));
meta.AddTypeMap("CultureName", new esTypeMap("nvarchar", "System.String"));
meta.AddTypeMap("Description", new esTypeMap("varchar", "System.String"));
meta.AddTypeMap("Symbol", new esTypeMap("nvarchar", "System.String"));
meta.AddTypeMap("SymbolPosition", new esTypeMap("varchar", "System.String"));
meta.AddTypeMap("GroupSeparator", new esTypeMap("nvarchar", "System.String"));
meta.AddTypeMap("DecimalSeparator", new esTypeMap("nvarchar", "System.String"));
ProviderConfiguration providerConfiguration = ProviderConfiguration.GetProviderConfiguration("data");
Provider provider = (Provider)providerConfiguration.Providers[providerConfiguration.DefaultProvider];
string objectQualifier = provider.Attributes["objectQualifier"];
if ((objectQualifier != string.Empty) && (objectQualifier.EndsWith("_") == false))
{
objectQualifier += "_";
}
if (objectQualifier != string.Empty)
{
meta.Source = objectQualifier + "DNNspot_Store_Currency";
meta.Destination = objectQualifier + "DNNspot_Store_Currency";
meta.spInsert = objectQualifier + "proc_DNNspot_Store_CurrencyInsert";
meta.spUpdate = objectQualifier + "proc_DNNspot_Store_CurrencyUpdate";
meta.spDelete = objectQualifier + "proc_DNNspot_Store_CurrencyDelete";
meta.spLoadAll = objectQualifier + "proc_DNNspot_Store_CurrencyLoadAll";
meta.spLoadByPrimaryKey = objectQualifier + "proc_DNNspot_Store_CurrencyLoadByPrimaryKey";
}
else
{
meta.Source = "DNNspot_Store_Currency";
meta.Destination = "DNNspot_Store_Currency";
meta.spInsert = "proc_DNNspot_Store_CurrencyInsert";
meta.spUpdate = "proc_DNNspot_Store_CurrencyUpdate";
meta.spDelete = "proc_DNNspot_Store_CurrencyDelete";
meta.spLoadAll = "proc_DNNspot_Store_CurrencyLoadAll";
meta.spLoadByPrimaryKey = "proc_DNNspot_Store_CurrencyLoadByPrimaryKey";
}
this.m_providerMetadataMaps["esDefault"] = meta;
}
return(this.m_providerMetadataMaps["esDefault"]);
}
private esProviderSpecificMetadata esDefault(string mapName)
{
if (!m_providerMetadataMaps.ContainsKey(mapName))
{
esProviderSpecificMetadata meta = new esProviderSpecificMetadata();
meta.AddTypeMap("StoreId", new esTypeMap("int", "System.Int32"));
meta.AddTypeMap("ShippingMethodId", new esTypeMap("smallint", "System.Int16"));
meta.AddTypeMap("ShippingMethodName", new esTypeMap("nvarchar", "System.String"));
meta.AddTypeMap("ShippingRateWeightId", new esTypeMap("int", "System.Int32"));
meta.AddTypeMap("MinRange", new esTypeMap("decimal", "System.Decimal"));
meta.AddTypeMap("MaxRange", new esTypeMap("decimal", "System.Decimal"));
meta.AddTypeMap("ShippingCost", new esTypeMap("money", "System.Decimal"));
ProviderConfiguration providerConfiguration = ProviderConfiguration.GetProviderConfiguration("data");
Provider provider = (Provider)providerConfiguration.Providers[providerConfiguration.DefaultProvider];
string objectQualifier = provider.Attributes["objectQualifier"];
if ((objectQualifier != string.Empty) && (objectQualifier.EndsWith("_") == false))
{
objectQualifier += "_";
}
if (objectQualifier != string.Empty)
{
meta.Source = objectQualifier + "vDNNspot_Store_ShippingRateWeight";
meta.Destination = objectQualifier + "vDNNspot_Store_ShippingRateWeight";
meta.spInsert = objectQualifier + "proc_vDNNspot_Store_ShippingRateWeightInsert";
meta.spUpdate = objectQualifier + "proc_vDNNspot_Store_ShippingRateWeightUpdate";
meta.spDelete = objectQualifier + "proc_vDNNspot_Store_ShippingRateWeightDelete";
meta.spLoadAll = objectQualifier + "proc_vDNNspot_Store_ShippingRateWeightLoadAll";
meta.spLoadByPrimaryKey = objectQualifier + "proc_vDNNspot_Store_ShippingRateWeightLoadByPrimaryKey";
}
else
{
meta.Source = "vDNNspot_Store_ShippingRateWeight";
meta.Destination = "vDNNspot_Store_ShippingRateWeight";
meta.spInsert = "proc_vDNNspot_Store_ShippingRateWeightInsert";
meta.spUpdate = "proc_vDNNspot_Store_ShippingRateWeightUpdate";
meta.spDelete = "proc_vDNNspot_Store_ShippingRateWeightDelete";
meta.spLoadAll = "proc_vDNNspot_Store_ShippingRateWeightLoadAll";
meta.spLoadByPrimaryKey = "proc_vDNNspot_Store_ShippingRateWeightLoadByPrimaryKey";
}
this.m_providerMetadataMaps["esDefault"] = meta;
}
return(this.m_providerMetadataMaps["esDefault"]);
}
public static CachingProvider Instance()
{
if (_objProvider == null)
{
var _objProviderConfig = ProviderConfiguration.GetProviderConfiguration("caching");
var _objProviderInfo = (ProviderBase)_objProviderConfig.Providers[_objProviderConfig.DefaultProvider];
_objProvider = (CachingProvider)DataProviderFactory.CreateDataProvider(_objProviderInfo);
}
return(_objProvider);
}
private esProviderSpecificMetadata esDefault(string mapName)
{
if (!m_providerMetadataMaps.ContainsKey(mapName))
{
esProviderSpecificMetadata meta = new esProviderSpecificMetadata();
meta.AddTypeMap("NameKey", new esTypeMap("varchar", "System.String"));
meta.AddTypeMap("Description", new esTypeMap("nvarchar", "System.String"));
meta.AddTypeMap("StoreId", new esTypeMap("int", "System.Int32"));
meta.AddTypeMap("EmailTemplateId", new esTypeMap("smallint", "System.Int16"));
meta.AddTypeMap("SubjectTemplate", new esTypeMap("nvarchar", "System.String"));
meta.AddTypeMap("BodyTemplate", new esTypeMap("nvarchar", "System.String"));
ProviderConfiguration providerConfiguration = ProviderConfiguration.GetProviderConfiguration("data");
Provider provider = (Provider)providerConfiguration.Providers[providerConfiguration.DefaultProvider];
string objectQualifier = provider.Attributes["objectQualifier"];
if ((objectQualifier != string.Empty) && (objectQualifier.EndsWith("_") == false))
{
objectQualifier += "_";
}
if (objectQualifier != string.Empty)
{
meta.Source = objectQualifier + "vDNNspot_Store_StoreEmailTemplate";
meta.Destination = objectQualifier + "vDNNspot_Store_StoreEmailTemplate";
meta.spInsert = objectQualifier + "proc_vDNNspot_Store_StoreEmailTemplateInsert";
meta.spUpdate = objectQualifier + "proc_vDNNspot_Store_StoreEmailTemplateUpdate";
meta.spDelete = objectQualifier + "proc_vDNNspot_Store_StoreEmailTemplateDelete";
meta.spLoadAll = objectQualifier + "proc_vDNNspot_Store_StoreEmailTemplateLoadAll";
meta.spLoadByPrimaryKey = objectQualifier + "proc_vDNNspot_Store_StoreEmailTemplateLoadByPrimaryKey";
}
else
{
meta.Source = "vDNNspot_Store_StoreEmailTemplate";
meta.Destination = "vDNNspot_Store_StoreEmailTemplate";
meta.spInsert = "proc_vDNNspot_Store_StoreEmailTemplateInsert";
meta.spUpdate = "proc_vDNNspot_Store_StoreEmailTemplateUpdate";
meta.spDelete = "proc_vDNNspot_Store_StoreEmailTemplateDelete";
meta.spLoadAll = "proc_vDNNspot_Store_StoreEmailTemplateLoadAll";
meta.spLoadByPrimaryKey = "proc_vDNNspot_Store_StoreEmailTemplateLoadByPrimaryKey";
}
this.m_providerMetadataMaps["esDefault"] = meta;
}
return(this.m_providerMetadataMaps["esDefault"]);
}
