private string InitializeConnection(DatabaseConnectionInfo connectionInfo)
{
string result = null;
try
{
SqlConnection connection = new SqlConnection(connectionInfo.ConnectionString);
connection.Open();
this.sqlConnection = connection;
this.UserId = GetUserId();
}
catch (Exception ex)
{
if (ex is InvalidOperationException || ex is SqlException)
{
result = "There was an error connecting to the database. " + ex.Message;
}
else
{
throw;
}
}
return result;
}
private DatabaseConnectionInfo SettingsToConnectionInfo(Properties.Settings settings)
{
var connectionInfo = new DatabaseConnectionInfo
{
ServerName = settings.ServerName,
UseWindowsAuthentication = settings.UseWindowsAuthentication,
DatabaseName = settings.DatabaseName
};
if (!settings.UseWindowsAuthentication)
{
connectionInfo.UserName = settings.UserName;
connectionInfo.EncryptedPassword = settings.Password;
}
return connectionInfo;
}
private static void SettingsFromConnectionInfo(DatabaseConnectionInfo connectionInfo, Properties.Settings settings)
{
settings.ServerName = connectionInfo.ServerName;
settings.UseWindowsAuthentication = connectionInfo.UseWindowsAuthentication;
settings.DatabaseName = connectionInfo.DatabaseName;
if (!connectionInfo.UseWindowsAuthentication)
{
settings.UserName = connectionInfo.UserName;
if (connectionInfo.RememberPassword)
{
settings.Password = connectionInfo.EncryptedPassword;
}
}
else
{
settings.UserName = string.Empty;
settings.Password = string.Empty;
}
}