public bool CreateQueue(QueueInfo queue, out string errorMessage) { errorMessage = string.Empty; if (string.IsNullOrWhiteSpace(CurrentServer)) { errorMessage = ERROR_SERVER_IS_NOT_DEFINED; return(false); } if (string.IsNullOrWhiteSpace(CurrentDatabase)) { errorMessage = ERROR_DATABASE_IS_NOT_DEFINED; return(false); } try { Guid brokerId = SqlScripts.ExecuteScalar <Guid>(ConnectionString, SqlScripts.SelectServiceBrokerIdentifierScript(CurrentDatabase)); SqlScripts.ExecuteScript(ConnectionString, SqlScripts.CreateServiceQueueScript(brokerId, queue)); } catch (Exception ex) { errorMessage = ExceptionHelper.GetErrorText(ex); } return(string.IsNullOrEmpty(errorMessage)); }
public int GetServiceBrokerPortNumber() { if (string.IsNullOrWhiteSpace(CurrentServer)) { throw new InvalidOperationException(ERROR_SERVER_IS_NOT_DEFINED); } return(SqlScripts.ExecuteScalar <int>(ConnectionString, SqlScripts.SelectServiceBrokerPortNumberScript())); }
public bool DaJetMQExists() { if (string.IsNullOrWhiteSpace(CurrentServer)) { throw new InvalidOperationException(ERROR_SERVER_IS_NOT_DEFINED); } return(SqlScripts.ExecuteScalar <bool>(ConnectionString, SqlScripts.DaJetMQExistsScript())); }
public string GetUserCertificateBinaryData() { if (string.IsNullOrWhiteSpace(CurrentServer)) { throw new InvalidOperationException(ERROR_SERVER_IS_NOT_DEFINED); } return(SqlScripts.ExecuteScalar <string>(ConnectionString, SqlScripts.SelectCertificateBinaryDataScript())); }
public void CreateQueue(string name) { if (string.IsNullOrWhiteSpace(CurrentServer)) { throw new InvalidOperationException(ERROR_SERVER_IS_NOT_DEFINED); } Guid brokerId = SqlScripts.ExecuteScalar <Guid>(ConnectionString, SqlScripts.SelectServiceBrokerIdentifierScript()); SqlScripts.ExecuteScript(ConnectionString, SqlScripts.CreateServiceQueueScript(brokerId, name)); }
public string ReceiveMessage(string queueFullName) { if (string.IsNullOrWhiteSpace(CurrentServer)) { throw new InvalidOperationException(ERROR_SERVER_IS_NOT_DEFINED); } string connectionString = AlterDatabaseConnectionString(); string message = SqlScripts.ExecuteScalar <string>(connectionString, SqlScripts.SimpleReceiveMessageScript(queueFullName)); return(message); }
public IMessageConsumer CreateMessageConsumer(string queueName) { if (string.IsNullOrWhiteSpace(CurrentServer)) { throw new InvalidOperationException(ERROR_SERVER_IS_NOT_DEFINED); } Guid brokerId = SqlScripts.ExecuteScalar <Guid>(ConnectionString, SqlScripts.SelectServiceBrokerIdentifierScript()); string queueFullName = SqlScripts.CreateQueueName(brokerId, queueName); return(new MessageConsumer(CurrentServer, queueFullName)); }
public void SetupServiceBroker() { if (string.IsNullOrWhiteSpace(CurrentServer)) { throw new InvalidOperationException(ERROR_SERVER_IS_NOT_DEFINED); } SqlScripts.ExecuteScript(ConnectionString, SqlScripts.CreateDatabaseScript()); Guid brokerId = SqlScripts.ExecuteScalar <Guid>(ConnectionString, SqlScripts.SelectServiceBrokerIdentifierScript()); SqlScripts.ExecuteScript(ConnectionString, SqlScripts.CreateDatabaseUserScript(brokerId)); SqlScripts.ExecuteScript(ConnectionString, SqlScripts.CreateChannelsTableScript()); }
public void SendMessage(string routeName, string payload) { if (string.IsNullOrWhiteSpace(CurrentServer)) { throw new InvalidOperationException(ERROR_SERVER_IS_NOT_DEFINED); } Guid handle = SqlScripts.ExecuteScalar <Guid>(ConnectionString, SqlScripts.SelectDialogHandleScript(routeName)); string sql = SqlScripts.SendMessageToChannelScript(); Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("handle", handle); parameters.Add("message", payload); SqlScripts.ExecuteScript(ConnectionString, sql, parameters); }
public bool DaJetMQExists() { if (string.IsNullOrWhiteSpace(CurrentServer)) { throw new InvalidOperationException(ERROR_SERVER_IS_NOT_DEFINED); } bool result = false; try { result = SqlScripts.ExecuteScalar <bool>(ConnectionString, SqlScripts.DaJetMQExistsScript()); } catch (Exception error) { // TODO: handle error result = false; } return(result); }