private void CreateDefault()
{
MySqlDataReader reader = null;
MySqlCommand query = null;
try
{
query = new MySqlCommand(CREATE_TBL_USER, dbConn);
query.ExecuteNonQuery();
}
catch (MySqlException e)
{
PacChatServer.GetServer().Logger.Error(e);
if (RETRY_COUNT >= RETRY_LIMIT)
{
PacChatServer.GetCommandManager().ExecuteCommand(ConsoleSender.Instance, DefaultCommands.STOP);
return;
}
RETRY_COUNT++;
OpenConnection();
CreateDefault();
}
finally
{
Cleanup(reader);
}
RETRY_COUNT = 0;
}
public void ExecuteToDB(String query, Dictionary <string, object> parameters)
{
MySqlDataReader reader = null;
MySqlCommand command = null;
try
{
command = new MySqlCommand(query, dbConn);
foreach (KeyValuePair <string, object> parameter in parameters)
{
command.Parameters.AddWithValue(parameter.Key, parameter.Value);
}
command.ExecuteNonQuery();
}
catch (MySqlException e)
{
PacChatServer.GetServer().Logger.Error(e);
if (RETRY_COUNT >= RETRY_LIMIT)
{
PacChatServer.GetCommandManager().ExecuteCommand(ConsoleSender.Instance, DefaultCommands.STOP);
return;
}
RETRY_COUNT++;
OpenConnection();
ExecuteToDB(query, parameters);
}
finally
{
Cleanup(reader);
}
RETRY_COUNT = 0;
}