private MySqlServer SetupMySqlServer(ErrorResultTO errors)
{
var server = new MySqlServer();
try
{
bool connected = server.Connect(Source.ConnectionString, CommandType.StoredProcedure,
String.IsNullOrEmpty(Service.Method.ExecuteAction)
? Service.Method.Name
: Service.Method.ExecuteAction);
if (!connected)
{
Dev2Logger.Log.Error(string.Format("Failed to connect with the following connection string: '{0}'",
Source.ConnectionString));
}
return(server);
}
catch (MySqlException sex)
{
// 2013.06.24 - TWR - added errors logging
var errorMessages = new StringBuilder();
errorMessages.Append(sex.Message);
errors.AddError(errorMessages.ToString());
Dev2Logger.Log.Error(errorMessages.ToString());
}
catch (Exception ex)
{
// 2013.06.24 - TWR - added errors logging
errors.AddError(string.Format("{0}{1}{2}", ex.Message, Environment.NewLine, ex.StackTrace));
Dev2Logger.Log.Error(ex);
}
return(server);
}
MySqlServer SetupMySqlServer(ErrorResultTO errors)
{
var server = new MySqlServer();
try
{
var connected = server.Connect(Source.ConnectionString, CommandType.StoredProcedure, ProcedureName);
if (!connected)
{
Dev2Logger.Error(string.Format(ErrorResource.FailedToConnectWithConnectionString,
Source.ConnectionString), GlobalConstants.WarewolfError);
}
return(server);
}
catch (MySqlException sex)
{
var errorMessages = new StringBuilder();
errorMessages.Append(sex.Message);
errors.AddError(errorMessages.ToString());
Dev2Logger.Error(errorMessages.ToString(), GlobalConstants.WarewolfError);
}
catch (Exception ex)
{
errors.AddError($"{ex.Message}{Environment.NewLine}{ex.StackTrace}");
Dev2Logger.Error(ex, GlobalConstants.WarewolfError);
}
return(server);
}