//public string BuildSQLQuery()
//{
//}
#endregion
#region Execute Query
/// <summary>
/// Executes SQL queries
/// </summary>
/// <param name="queryString">Accepts finished query string</param>
/// <returns>
/// Returns a Datatable with the results or null if it's an insert
/// </returns>
public DataTable ExecuteMySQLQuery(string queryString)
{
_dbCon = DBConnectionModel.Instance();
try
{
if (_dbCon.IsConnected("localhost", "autoDB", "root", "", "3306"))
{
var cmd = new MySqlCommand(queryString, _dbCon.Connection);
MySqlDataAdapter sqlDataAdapter = new MySqlDataAdapter(cmd);
DataTable dtRecord = new DataTable();
sqlDataAdapter.Fill(dtRecord);
return(dtRecord);
}
else
{
return(null);
}
}
catch (MySqlException sqlex)
{
Protocol.WriteToProtocol(0, "IsConnected() :" + sqlex.Message + sqlex.StackTrace, "DB Connection Error");
MessageBox.Show(sqlex.Message);
return(null);
}
finally
{
_dbCon.CloseSqlConnection();
}
}
public static DBConnectionModel Instance()
{
if (_instance == null)
{
_instance = new DBConnectionModel();
}
return(_instance);
}
