public static void Save()
{
var config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
SetValue(config, "ServerName", ServerName);
SetValue(config, "DatabaseName", DatabaseName);
SetValue(config, "UserName", UserName);
SetValue(config, "ConnectionTimeout", ConnectionTimeout.ToString(CultureInfo.InvariantCulture));
SetValue(config, "CommandTimeout", CommandTimeout.ToString(CultureInfo.InvariantCulture));
var value = (Password.Length > 0) ? SymCryptoHelper.TripleDESEncrypt(Password, Salt, Key, IV) : string.Empty;
SetValue(config, "Password", value);
SetValue(config, "LoginUserName", LoginUserName);
SetValue(config, "LoginPassword", LoginPassword);
SetValue(config, "AutoNewRow", AutoNewRow);
SetValue(config, "OfflineMode", OfflineMode);
SetValue(config, "OfflineServerName", OfflineServerName);
SetValue(config, "OfflineDatabaseName", OfflineDatabaseName);
SetValue(config, "OfflineUserName", OfflineUserName);
SetValue(config, "OfflineConnectionTimeout", OfflineConnectionTimeout.ToString(CultureInfo.InvariantCulture));
SetValue(config, "OfflineCommandTimeout", OfflineCommandTimeout.ToString(CultureInfo.InvariantCulture));
value = (OfflinePassword.Length > 0) ? SymCryptoHelper.TripleDESEncrypt(OfflinePassword, Salt, Key, IV) : string.Empty;
SetValue(config, "OfflinePassword", value);
SetValue(config, "SynchronizationProvider", GetStringValue("SynchronizationProvider"));
SetValue(config, "WSSynchronizationUrl", GetStringValue("WSSynchronizationUrl"));
SetValue(config, "WSUserName", GetStringValue("WSUserName"));
SetValue(config, "WSPassword", GetStringValue("WSPassword"));
SetValue(config, "WSDomain", GetStringValue("WSDomain"));
SetValue(config, "SkinName", SkinName);
SetValue(config, "AllowFormSkins", AllowFormSkins);
SetValue(config, "UseHedgehog", UseHedgehog);
SetValue(config, "HedgehogFile", HedgehogFile);
config.Save();
BuilderConnectionStrings();
}
/// <summary>
/// Constructs a connection string from the sql settings.
/// </summary>
/// <returns>Connection string.</returns>
public String ToConnectionString()
{
StringBuilder connectionString = new StringBuilder();
connectionString.Append(m_ConnectionString);
// Strip the last semicolon.
if (m_ConnectionString.EndsWith(";", StringComparison.OrdinalIgnoreCase))
{
connectionString.Remove(m_ConnectionString.Length - 1, 1);
}
if (!String.IsNullOrEmpty(InitialCatalog))
{
connectionString.Append(";Initial Catalog=");
connectionString.Append(InitialCatalog);
}
if (MinPoolSize != -1)
{
connectionString.Append(";Min Pool Size=");
connectionString.Append(MinPoolSize.ToString(CultureInfo.InvariantCulture));
}
if (MaxPoolSize != -1)
{
connectionString.Append(";Max Pool Size=");
connectionString.Append(MaxPoolSize.ToString(CultureInfo.InvariantCulture));
}
if (ConnectionTimeout != -1)
{
connectionString.Append(";Connection Timeout=");
connectionString.Append(ConnectionTimeout.ToString(CultureInfo.InvariantCulture));
}
return(connectionString.ToString());
}