public void errorWriter(MySqlException oMySQLException)
{
TheLogger.Log("ExecSql Error in " + oMySQLException.TargetSite + " due to : " + oMySQLException.Message + "\n");
string errorText = oMySQLException.ToString();
errorWriter(errorText);
}
//Everything that goes wrong with MySql will raise an MySqlException. Since this is also used in connectToDb() the query is optional.
public void HandleException(MySqlException exception, string query = "")
{
Console.WriteLine("!!EXCEPTION THROWN: \n" + exception.ToString());
if (query.Length != 0)
{
Console.WriteLine("Query executed: " + query);
}
}
/// <summary>
/// Brings up a window with the given error.
/// </summary>
/// <param name="error">Error.</param>
void errorHandle(MySqlException error)
{
NSAlert oAlert = new NSAlert();
// Set the buttons
oAlert.InvokeOnMainThread(delegate
{
oAlert.AddButton("Ok");
});
// Show the message box and capture
oAlert.MessageText = "There's a problem with the query!";
oAlert.InformativeText = error.ToString();
oAlert.AlertStyle = NSAlertStyle.Informational;
}
//
// WriteToEventLog
// A helper function that writes exception detail to the event log. Exceptions
// are written to the event log as a security measure to avoid private database
// details from being returned to the browser. If a method does not return a status
// or boolean indicating the action succeeded or failed, a generic exception is also
// thrown by the caller.
//
private void WriteToEventLog(MySqlException e, string action)
{
using (EventLog log = new EventLog())
{
log.Source = eventSource;
log.Log = eventLog;
string message = exceptionMessage + "\n\n";
message += Resources.LocalizedText.LogAction + action + "\n\n";
message += Resources.LocalizedText.LogException + e.ToString();
log.WriteEntry(message);
}
}
//
// WriteToEventLog
// A helper function that writes exception detail to the event log. Exceptions
// are written to the event log as a security measure to avoid private database
// details from being returned to the browser. If a method does not return a status
// or boolean indicating the action succeeded or failed, a generic exception is also
// thrown by the caller.
//
private void WriteToEventLog(MySqlException e, string action)
{
EventLog log = new EventLog();
log.Source = eventSource;
log.Log = eventLog;
string message = exceptionMessage + "\n\n";
message += "Action: " + action + "\n\n";
message += "Exception: " + e.ToString();
log.WriteEntry(message);
}
/// <summary>
/// Handles MySql exception.
/// If WriteExceptionsToEventLog is set, will write exception info
/// to event log.
/// It throws provider exception (original exception is stored as inner exception)
/// </summary>
/// <param name="e">exception</param>
/// <param name="action"> name of the function that throwed the exception</param>
private void HandleMySqlException(MySqlException e, string action)
{
if (WriteExceptionsToEventLog)
{
using (EventLog log = new EventLog())
{
log.Source = eventSource;
log.Log = eventLog;
string message = "An exception occurred communicating with the data source.\n\n";
message += "Action: " + action;
message += "Exception: " + e.ToString();
log.WriteEntry(message);
}
}
throw new ProviderException(exceptionMessage, e);
}
public static Exception GenerarDesdeMySqlException(MySqlException ex)
{
switch (ex.Number)
{
case 1042:
return(new SinConexionException(ex));
case 1062:
return(new ElementoDuplicadoException(ex));
case 1451:
return(new NoSePuedeEliminarException("porque existe una referencia.", ex));
default:
Console.WriteLine(ex.Number);
Console.WriteLine(ex.ToString( ));
return(null);
}
}
public void NoDatabaseConnection(MySqlException ex)
{
MessageBox.Show("No connection to Database\nAppliction will be closed\n" + ex.ToString());
this.Close();
}
public void SQLError(MySqlException ex)
{
switch (ex.ErrorCode)
{
case 0:
SMain.Enqueue(string.Format("Cannot connect to MySQL Database :\tIP : {0}\tPort : {1}\tDatabase : {2}", Settings.SQL_IP, Settings.SQL_PORT, Settings.SQL_DBName));
break;
case 1045:
SMain.Enqueue(string.Format("Login failure for MySQL Database, check details!"));
break;
case 1053:
SMain.Enqueue(string.Format("MySQL Server is shutting down.."));
break;
case 1054:
SMain.Enqueue(string.Format("MySQL Column not found in table."));
break;
case 1055:
SMain.Enqueue(string.Format("MySQL Item isn't in GROUP BY."));
break;
case 1056:
SMain.Enqueue(string.Format("MySQL Cannot GROUP BY on table."));
break;
case 1059:
SMain.Enqueue(string.Format("MySQL Identifier name is too long."));
break;
case 1060:
SMain.Enqueue(string.Format("MySQL Column duplicate in statement."));
break;
case 1061:
SMain.Enqueue(string.Format("MySQL Key Name duplicate in statement."));
break;
case 1062:
SMain.Enqueue(string.Format("MySQL Duplicate entry for key in statement."));
break;
case 1063:
SMain.Enqueue(string.Format("MySQL Incorrect column specifier."));
break;
case 1065:
SMain.Enqueue(string.Format("MySQL Empty Query."));
break;
case 1077:
SMain.Enqueue(string.Format("MySQL Shutting down.."));
break;
case 1078:
SMain.Enqueue(string.Format("MySQL Aborting : Reason receive Signal."));
break;
case 1079:
SMain.Enqueue(string.Format("MySQL Shutdown complete."));
break;
case 1102:
SMain.Enqueue(string.Format("MySQL Incorrect database name."));
break;
case 1105:
SMain.Enqueue("MySQL Unknown Error.");
break;
case 1146:
SMain.Enqueue(string.Format("Table does not exist on MySQL Database."));
break;
default:
SMain.Enqueue(string.Format("MySQL insert characterinfo data error : {0}", ex.ToString()));
break;
}
}
/// <summary>
/// Gestion des erreurs
/// Envoie un message dans une console
/// </summary>
/// <param name="ex">MySqlException</param>
private void gestionErr(MySqlException ex)
{
Console.WriteLine("Error: {0}", ex.ToString());
Console.WriteLine("Press enter to close...");
Console.ReadLine();
}
