public static ActionResult CheckSqlServerConnection(Session session)
{
session.Log("Start: CheckSqlServerConnection.");
session["SQL_CONNECTION_ESTABLISHED"] = "1";
try
{
string serverName = GetPropertyStringValue(session, "SQL_SERVER");
if (string.IsNullOrEmpty(serverName))
{
throw new Exception("Server name is empty. Please enter a correct value.");
}
string database = GetPropertyStringValue(session, "SQL_DATABASE");
if (string.IsNullOrEmpty(database))
{
throw new Exception("Database name is empty. Please enter a correct value.");
}
string userName = GetPropertyStringValue(session, "SQL_USER_ID");
if (string.IsNullOrEmpty(userName))
{
throw new Exception("Login is empty. Please enter a correct value.");
}
string password = GetPropertyStringValue(session, "SQL_PASSWORD");
if (string.IsNullOrEmpty(password))
{
throw new Exception("Password is empty. Please enter a correct value.");
}
string connectionString = GetPropertyStringValue(session, "DATABASE_CONNECTION_STRING");
session.Log("Connection string to SQL Server: {0}", connectionString);
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
SqlDatabaseValidator databaseValidator = new SqlDatabaseValidator(connection);
databaseValidator.Validate(database);
SqlDatabasePermissionValidator databasePermissionValidator = new SqlDatabasePermissionValidator(connection);
databasePermissionValidator.Validate(database, "CREATE TABLE");
}
}
catch (Exception e)
{
InitializeMessageBox(session, e.Message, ERROR_MESSAGE);
session.Log("Error: {0}; {1};", e.Message, e.StackTrace);
session["SQL_CONNECTION_ESTABLISHED"] = "0";
}
session.Log("Finish: CheckSqlServerConnection.");
return(ActionResult.Success);
}
public static ActionResult CheckSqlServerConnection(Session session)
{
session.Log("Start: CheckSqlServerConnection.");
session["SQL_CONNECTION_ESTABLISHED"] = "1";
try
{
string serverName = GetPropertyStringValue(session, "SQL_SERVER");
if (string.IsNullOrEmpty(serverName))
{
throw new Exception("Server name is empty. Please enter a correct value.");
}
string database = GetPropertyStringValue(session, "SQL_DATABASE");
if (string.IsNullOrEmpty(database))
{
throw new Exception("Database name is empty. Please enter a correct value.");
}
string userName = GetPropertyStringValue(session, "SQL_USER_ID");
if (string.IsNullOrEmpty(userName))
{
throw new Exception("Login is empty. Please enter a correct value.");
}
string password = GetPropertyStringValue(session, "SQL_PASSWORD");
if (string.IsNullOrEmpty(password))
{
throw new Exception("Password is empty. Please enter a correct value.");
}
string connectionString = GetPropertyStringValue(session, "DATABASE_CONNECTION_STRING");
session.Log("Connection string to SQL Server: {0}", connectionString);
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
SqlDatabaseValidator databaseValidator = new SqlDatabaseValidator(connection);
databaseValidator.Validate(database);
SqlDatabasePermissionValidator databasePermissionValidator = new SqlDatabasePermissionValidator(connection);
databasePermissionValidator.Validate(database, "CREATE TABLE");
}
}
catch (Exception e)
{
InitializeMessageBox(session, e.Message, ERROR_MESSAGE);
session.Log("Error: {0}; {1};", e.Message, e.StackTrace);
session["SQL_CONNECTION_ESTABLISHED"] = "0";
}
session.Log("Finish: CheckSqlServerConnection.");
return ActionResult.Success;
}