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; }