public bool TryDeleteQueue(QueueInfo queue, out string errorMessage)
{
errorMessage = string.Empty;
if (string.IsNullOrWhiteSpace(CurrentServer))
{
errorMessage = ERROR_SERVER_IS_NOT_DEFINED;
return(false);
}
UseDatabase(DAJET_MQ_DATABASE_NAME);
try
{
Dictionary <string, object> parameters = new Dictionary <string, object>()
{
{ "name", queue.Name }
};
SqlScripts.ExecuteProcedure(ConnectionString, "sp_delete_queue", parameters, out int result);
}
catch (Exception ex)
{
errorMessage = ExceptionHelper.GetErrorText(ex);
}
return(string.IsNullOrEmpty(errorMessage));
}
public Guid GetServiceBrokerIdentifier()
{
if (string.IsNullOrWhiteSpace(CurrentServer))
{
throw new InvalidOperationException(ERROR_SERVER_IS_NOT_DEFINED);
}
UseDatabase(DAJET_MQ_DATABASE_NAME);
SqlScripts.ExecuteProcedure(ConnectionString, "fn_service_broker_guid", null, out Guid brokerGuid);
return(brokerGuid);
}
public string GetQueueFullName(string queueName)
{
if (string.IsNullOrWhiteSpace(CurrentServer))
{
throw new InvalidOperationException(ERROR_SERVER_IS_NOT_DEFINED);
}
UseDatabase(DAJET_MQ_DATABASE_NAME);
Dictionary <string, object> parameters = new Dictionary <string, object>()
{
{ "name", queueName }
};
SqlScripts.ExecuteProcedure(ConnectionString, "fn_create_queue_name", parameters, out string queueFullName);
return(queueFullName);
}
