/// <summary> /// Run a stored procedure or sql query check /// </summary> /// <param name="commandType"></param> /// <param name="parameters"></param> public bool ExecuteSQLCheck(CommandType commandType, string statement, Dictionary <string, string> parameters = null) { try { switch (commandType) { case CommandType.StoredProcedure: return(SqlUtil.CheckStoredProc(statement, parameters)); case CommandType.Text: return(SqlUtil.CheckDynamicQuery(statement)); case CommandType.TableDirect: throw new Exception("Command type 'TableDirect' not implemented yet."); default: throw new Exception("Command type not recognized."); } } catch (Exception ex) { throw new Exception(CustomErrorResponse(ex)); } }