public static void executeQuery(string queryString, bool createDB = false)
{
int totalCount = 0;
retry : try
{
if (Server.useMySQL)
{
MySQL.execute(queryString, createDB);
}
else
{
if (!createDB) // Databases do not need to be created in SQLite.
{
SQLite.execute(queryString);
}
}
}
catch (Exception e)
{
if (!createDB || !Server.useMySQL)
{
totalCount++;
if (totalCount > 10)
{
File.AppendAllText("MySQL_error.log", DateTime.Now + " " + queryString + "\r\n");
Server.ErrorLog(e);
}
else
{
goto retry;
}
}
else
{
throw e;
}
}
finally
{
if (Server.useMySQL)
{
MySQL.ClearParams();
}
else
{
SQLite.ClearParams();
}
}
}
public static DataTable fillData(string queryString, bool skipError = false)
{
int totalCount = 0;
using (DataTable toReturn = new DataTable("toReturn"))
{
retry : try
{
if (Server.useMySQL)
{
MySQL.fill(queryString, toReturn);
}
else
{
SQLite.fill(queryString, toReturn);
}
}
catch (Exception e)
{
totalCount++;
if (totalCount > 10)
{
if (!skipError)
{
File.AppendAllText("MySQL_error.log", DateTime.Now + " " + queryString + "\r\n");
Server.ErrorLog(e);
}
}
else
{
goto retry;
}
}
finally
{
if (Server.useMySQL)
{
MySQL.ClearParams();
}
else
{
SQLite.ClearParams();
}
}
return(toReturn);
}
}
