private void _SQLServerConfiguration(SqlInstances sqlInstances)
{
SQLServerConfiguration sSC = new SQLServerConfiguration(credentials);
sSC.SetComputerName(sqlInstances.Server);
sSC.SetInstance(sqlInstances.ServerInstance);
sSC.Query();
_PrintOutput(sSC.GetResults());
}
private bool TryConnectoToDatabase(SQLServerConfiguration sqlServerConfiguration)
{
if (sqlServerConfiguration.DatabaseConnectionType == DatabaseConnectionType.Advanced)
{
if (String.IsNullOrWhiteSpace(sqlServerConfiguration.ConnectionString))
{
return(false);
}
}
else if (sqlServerConfiguration.DatabaseConnectionType == DatabaseConnectionType.SQLServerAuthentication)
{
if (String.IsNullOrWhiteSpace(sqlServerConfiguration.DatabaseAddress))
{
return(false);
}
if (String.IsNullOrWhiteSpace(sqlServerConfiguration.DatabaseName))
{
return(false);
}
if (String.IsNullOrWhiteSpace(sqlServerConfiguration.DatabaseUsername))
{
return(false);
}
if (String.IsNullOrWhiteSpace(sqlServerConfiguration.DatabasePassword))
{
return(false);
}
sqlServerConfiguration.ConnectionString = $"Server={sqlServerConfiguration.DatabaseAddress};" +
$"Database={sqlServerConfiguration.DatabaseName};" +
$"User Id={sqlServerConfiguration.DatabaseUsername};" +
$"Password={sqlServerConfiguration.DatabasePassword};";
}
else if (sqlServerConfiguration.DatabaseConnectionType == DatabaseConnectionType.WindowsAuthentication)
{
if (String.IsNullOrWhiteSpace(sqlServerConfiguration.DatabaseAddress))
{
return(false);
}
if (String.IsNullOrWhiteSpace(sqlServerConfiguration.DatabaseName))
{
return(false);
}
sqlServerConfiguration.ConnectionString = $"Server={sqlServerConfiguration.DatabaseAddress};" +
$"Database={sqlServerConfiguration.DatabaseName};" +
$"Trusted_Connection=True;";
}
if (!DataAccess.Helper.TestConnection(sqlServerConfiguration.ConnectionString))
{
return(false);
}
_customSettings.ConnectionString = sqlServerConfiguration.ConnectionString;
DataAccess.Helper.ChangeConnectionString(sqlServerConfiguration.ConnectionString);
return(true);
}
public async Task CreateSqlServerConfiguration(CreateSQLServerConfigModel configModel)
{
var config = new SQLServerConfiguration
{
Application = configModel.Application,
AsynchronousProcessing = configModel.AsynchronousProcessing,
ConfigId = configModel.ConfigId,
DataSource = configModel.DataSource,
IsSecurityIntegrated = configModel.IsSecurityIntegrated,
ProtectedPassword = configModel.ProtectedPassword,
Provider = configModel.Provider,
UserId = configModel.UserId
};
await _ctx.SqlserverConfigurations.AddAsync(config);
await _ctx.SaveChangesAsync(CancellationToken.None);
}
private async Task <bool> ClearDatabase(SQLServerConfiguration sqlServerConfiguration)
{
return(await DataAccess.Helper.ClearDatabaseDataAsync(sqlServerConfiguration.ConnectionString));
}
private async Task <bool> GenerateDatabase(SQLServerConfiguration sqlServerConfiguration)
{
return(await DataAccess.Helper.CreateDatabaseModelAsync(sqlServerConfiguration.ConnectionString));
}
