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