public override void SaveProviderRepositoryInfo(string providerFactoryKey, ProviderRepositoryInfo providerRepositoryInfo)
{
using (ProviderDataContext dc = ProviderFactory.GetInstance <DataContextFactory>(ProviderRepositoryFactory.Instance.Providers[this.Parameters["dataContextProviderRepositoryName"]]).GetProviders <DataContextProviderBase>()[this.Parameters["dataContextProviderName"]].DataContext as ProviderDataContext)
{
dc.ExecuteCommand(String.Format("DELETE FROM ProviderParameters WHERE FKProviders IN (SELECT Id FROM Providers WHERE Key = '{0}')", providerFactoryKey));
dc.ExecuteCommand(String.Format("DELETE FROM Providers WHERE Key = '{0}'", providerFactoryKey));
foreach (ProviderSettings provider in providerRepositoryInfo.ProviderSettings)
{
var newProvider = new ProviderValueObject();
newProvider.Key = providerFactoryKey;
newProvider.Name = provider.Name;
newProvider.Type = provider.Type;
newProvider.IsDefault = (providerRepositoryInfo.DefaultProviderName == provider.Name);
dc.Providers.InsertOnSubmit(newProvider);
dc.SubmitChanges();
foreach (var item in provider.Parameters.Keys)
{
if (item.ToString().ToUpper() != "NAME" && item.ToString().ToUpper() != "TYPE")
{
var newParameter = new ProviderParameterValueObject();
newParameter.FKProviders = newProvider.Id;
newParameter.Name = item.ToString();
newParameter.Value = provider.Parameters[item.ToString()];
dc.ProviderParameters.InsertOnSubmit(newParameter);
}
}
dc.SubmitChanges();
}
}
}
private string GetDefaultProviderName(string providerKey)
{
string providerName = string.Empty;
using (ProviderDataContext dc = ProviderFactory.GetInstance <DataContextFactory>(ProviderRepositoryFactory.Instance.Providers[this.Parameters["dataContextProviderRepositoryName"]]).GetProviders <DataContextProviderBase>()[this.Parameters["dataContextProviderName"]].DataContext as ProviderDataContext)
{
ProviderValueObject result = dc.Providers.Where(p => p.IsDefault).SingleOrDefault();
if (result != null)
{
providerName = result.Name;
}
}
return(providerName);
}
private Dictionary <string, ProviderSettings> GetProviders(string providerKey)
{
var result = new Dictionary <String, ProviderSettings>();
using (ProviderDataContext dc = ProviderFactory.GetInstance <DataContextFactory>(ProviderRepositoryFactory.Instance.Providers[this.Parameters["dataContextProviderRepositoryName"]]).GetProviders <DataContextProviderBase>()[this.Parameters["dataContextProviderName"]].DataContext as ProviderDataContext)
{
foreach (ProviderValueObject provider in dc.Providers.Where(p => p.Key == providerKey).ToList())
{
var newProviderSettings = new ProviderSettings(provider.Name, provider.Type);
foreach (ProviderParameterValueObject parameter in dc.ProviderParameters.Where(p => p.FKProviders == provider.Id).ToList())
{
newProviderSettings.Parameters.Add(parameter.Name, parameter.Value);
}
result.Add(newProviderSettings.Name, newProviderSettings);
}
}
return(result);
}
