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