private async Task <CompletionResult> _SetCompleted(string error = null, string result = null, bool?isCancelled = null)
{
var idParam = new SqlParameter("@MetaDataID", System.Data.SqlDbType.Int);
idParam.Value = _metaDataID;
var resultParam = new SqlParameter("@Result", System.Data.SqlDbType.NVarChar, 255);
resultParam.Value = NullableHelper.DBNullConvertFrom(result);
var cancelledParam = new SqlParameter("@isCanceled", System.Data.SqlDbType.Bit);
cancelledParam.Value = NullableHelper.DBNullConvertFrom(isCancelled);
var errorParam = new SqlParameter("@ErrorMessage", System.Data.SqlDbType.NVarChar, 4000);
errorParam.Value = NullableHelper.DBNullConvertFrom(error);
if (error != null)
{
return(CompletionResult.Error);
}
if (isCancelled == true)
{
return(CompletionResult.Cancelled);
}
await this.SSSBDb.Database.ExecuteSqlCommandAsync("EXEC [PPS].[sp_SetCompleted] @MetaDataID, @Result, @isCanceled, @ErrorMessage", new object[] { idParam, resultParam, cancelledParam, errorParam });
MetaData metaData = await GetMetaData(CancellationToken.None);
return(IsAllTasksCompleted(metaData));
}
public async Task <int> EndConversation(
SqlConnection dbconnection,
Guid?conversationHandle,
bool?withCleanup,
int?errorCode,
String errorDescription)
{
try
{
using (SqlCommand command = new SqlCommand())
{
command.Connection = dbconnection;
command.CommandText = "SSSB.EndConversation";
command.CommandType = CommandType.StoredProcedure;
if (!string.IsNullOrEmpty(errorDescription) && !errorCode.HasValue)
{
errorCode = 1;
}
command.Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 0, ParameterDirection.ReturnValue, true, 0, 0, "RETURN_VALUE", DataRowVersion.Current, null));
command.Parameters.Add(new SqlParameter("@conversationHandle", SqlDbType.UniqueIdentifier, 0, ParameterDirection.Input, true, 0, 0, "conversationHandle", DataRowVersion.Current, NullableHelper.DBNullConvertFrom(conversationHandle)));
command.Parameters.Add(new SqlParameter("@withCleanup", SqlDbType.Bit, 0, ParameterDirection.Input, true, 0, 0, "withCleanup", DataRowVersion.Current, NullableHelper.DBNullConvertFrom(withCleanup)));
command.Parameters.Add(new SqlParameter("@errorCode", SqlDbType.Int, 0, ParameterDirection.Input, true, 0, 0, "errorCode", DataRowVersion.Current, NullableHelper.DBNullConvertFrom(errorCode)));
command.Parameters.Add(new SqlParameter("@errorDescription", SqlDbType.NVarChar, 255, ParameterDirection.Input, true, 0, 0, "errorDescription", DataRowVersion.Current, NullableHelper.DBNullConvertFrom(errorDescription)));
await command.ExecuteNonQueryAsync();
return((Int32)command.Parameters[RETURN_VALUE_PARAMETER_NAME].Value);
}
}
catch (SqlException ex)
{
DBWrapperExceptionsHelper.ThrowError(ex, _log);
return(-1);
}
}
public async Task <IDataReader> ReceiveMessagesNoWaitAsync(
SqlConnection dbconnection,
String queueName,
int?fetchSize,
Guid?conversation_group,
CommandBehavior procedureResultBehaviour, CancellationToken cancellation)
{
try
{
using (SqlCommand command = new SqlCommand())
{
command.Connection = dbconnection;
command.CommandTimeout = 20;
command.CommandText = "SSSB.ImmediateReceiveMessagesFromQueue";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 0, ParameterDirection.ReturnValue, true, 0, 0, "RETURN_VALUE", DataRowVersion.Current, null));
command.Parameters.Add(new SqlParameter("@queueName", SqlDbType.NVarChar, 128, ParameterDirection.Input, true, 0, 0, "queueName", DataRowVersion.Current, NullableHelper.DBNullConvertFrom(queueName)));
command.Parameters.Add(new SqlParameter("@fetchSize", SqlDbType.Int, 0, ParameterDirection.Input, true, 0, 0, "fetchSize", DataRowVersion.Current, NullableHelper.DBNullConvertFrom(fetchSize)));
command.Parameters.Add(new SqlParameter("@conversation_group", SqlDbType.UniqueIdentifier, 0, ParameterDirection.Input, true, 0, 0, "conversation_group", DataRowVersion.Current, NullableHelper.DBNullConvertFrom(conversation_group)));
return(await command.ExecuteReaderAsync(procedureResultBehaviour, cancellation));
}
}
catch (SqlException ex)
{
cancellation.ThrowIfCancellationRequested();
DBWrapperExceptionsHelper.ThrowError(ex, _log);
}
return(null);
}
public async Task <string> GetServiceQueueName(String serviceName)
{
string queueName = string.Empty;
using (TransactionScope transactionScope = new TransactionScope(TransactionScopeOption.Suppress, TransactionScopeAsyncFlowOption.Enabled))
{
var dbconnection = await _connectionManager.CreateSSSBConnectionAsync(CancellationToken.None);
try
{
using (dbconnection)
using (var command = dbconnection.CreateCommand())
{
command.CommandText = "SSSB.GetServiceQueueName";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 0, ParameterDirection.ReturnValue, true, 0, 0, "RETURN_VALUE", DataRowVersion.Current, null));
command.Parameters.Add(new SqlParameter("@serviceName", SqlDbType.NVarChar, 128, ParameterDirection.Input, true, 0, 0, "serviceName", DataRowVersion.Current, NullableHelper.DBNullConvertFrom(serviceName)));
command.Parameters.Add(new SqlParameter("@queueName", SqlDbType.NVarChar, 128, ParameterDirection.InputOutput, true, 0, 0, "queueName", DataRowVersion.Current, NullableHelper.DBNullConvertFrom(queueName)));
await command.ExecuteNonQueryAsync();
if (command.Parameters["@queueName"].Value == DBNull.Value)
{
queueName = null;
}
else
{
queueName = (String)(command.Parameters["@queueName"].Value);
}
}
transactionScope.Complete();
return(queueName);
}
catch (SqlException ex)
{
DBWrapperExceptionsHelper.ThrowError(ex, _log);
return(null);
}
}
}
public async Task <int> ProcessPendingMessages(
SqlConnection dbconnection,
bool processAll = false,
String objectID = null
)
{
try
{
using (SqlCommand command = new SqlCommand())
{
command.Connection = dbconnection;
command.CommandText = "SSSB.ProcessPendingMessages";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 0, ParameterDirection.ReturnValue, true, 0, 0, "RETURN_VALUE", DataRowVersion.Current, null));
command.Parameters.Add(new SqlParameter("@ProccessALL", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "ProccessALL", DataRowVersion.Current, processAll));
command.Parameters.Add(new SqlParameter("@ObjectID", SqlDbType.VarChar, 50, ParameterDirection.Input, true, 0, 0, "ObjectID", DataRowVersion.Current, NullableHelper.DBNullConvertFrom(objectID)));
await command.ExecuteNonQueryAsync();
return((Int32)command.Parameters[RETURN_VALUE_PARAMETER_NAME].Value);
}
}
catch (SqlException ex)
{
DBWrapperExceptionsHelper.ThrowError(ex, _log);
return(-1);
}
}
public async Task <Guid?> BeginDialogConversation(
SqlConnection dbconnection,
String fromService,
String toService,
String contractName,
int?lifetime,
bool?withEncryption,
Guid?relatedConversationID,
Guid?relatedConversationGroupID)
{
Guid?conversationHandle = null;
try
{
using (SqlCommand command = new SqlCommand())
{
command.Connection = dbconnection;
command.CommandText = "SSSB.BeginDialogConversation";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 0, ParameterDirection.ReturnValue, true, 0, 0, "RETURN_VALUE", DataRowVersion.Current, null));
command.Parameters.Add(new SqlParameter("@fromService", SqlDbType.NVarChar, 255, ParameterDirection.Input, true, 0, 0, "fromService", DataRowVersion.Current, NullableHelper.DBNullConvertFrom(fromService)));
command.Parameters.Add(new SqlParameter("@toService", SqlDbType.NVarChar, 255, ParameterDirection.Input, true, 0, 0, "toService", DataRowVersion.Current, NullableHelper.DBNullConvertFrom(toService)));
command.Parameters.Add(new SqlParameter("@contractName", SqlDbType.NVarChar, 128, ParameterDirection.Input, true, 0, 0, "contractName", DataRowVersion.Current, NullableHelper.DBNullConvertFrom(contractName)));
command.Parameters.Add(new SqlParameter("@lifetime", SqlDbType.Int, 0, ParameterDirection.Input, true, 0, 0, "lifetime", DataRowVersion.Current, NullableHelper.DBNullConvertFrom(lifetime)));
command.Parameters.Add(new SqlParameter("@withEncryption", SqlDbType.Bit, 0, ParameterDirection.Input, true, 0, 0, "withEncryption", DataRowVersion.Current, NullableHelper.DBNullConvertFrom(withEncryption)));
command.Parameters.Add(new SqlParameter("@relatedConversationID", SqlDbType.UniqueIdentifier, 0, ParameterDirection.Input, true, 0, 0, "relatedConversationID", DataRowVersion.Current, NullableHelper.DBNullConvertFrom(relatedConversationID)));
command.Parameters.Add(new SqlParameter("@relatedConversationGroupID", SqlDbType.UniqueIdentifier, 0, ParameterDirection.Input, true, 0, 0, "relatedConversationGroupID", DataRowVersion.Current, NullableHelper.DBNullConvertFrom(relatedConversationGroupID)));
command.Parameters.Add(new SqlParameter("@conversationHandle", SqlDbType.UniqueIdentifier, 0, ParameterDirection.InputOutput, true, 0, 0, "conversationHandle", DataRowVersion.Current, NullableHelper.DBNullConvertFrom(conversationHandle)));
await command.ExecuteNonQueryAsync();
if (command.Parameters["@conversationHandle"].Value == DBNull.Value)
{
conversationHandle = null;
}
else
{
conversationHandle = (Guid)(command.Parameters["@conversationHandle"].Value);
}
return(conversationHandle);
}
}
catch (SqlException ex)
{
DBWrapperExceptionsHelper.ThrowError(ex, _log);
return(null);
}
}
public async Task <long?> SendPendingMessage(
SqlConnection dbconnection,
String objectID,
DateTime?activationDate,
String fromService,
String toService,
String contractName,
int?lifeTime,
bool?isWithEncryption,
byte[] messageBody,
String messageType
)
{
long?pendingMessageID = null;
try
{
using (SqlCommand command = new SqlCommand())
{
command.Connection = dbconnection;
command.CommandText = "SSSB.SendPendingMessage";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 0, ParameterDirection.ReturnValue, true, 0, 0, "RETURN_VALUE", DataRowVersion.Current, null));
command.Parameters.Add(new SqlParameter("@objectID", SqlDbType.VarChar, 50, ParameterDirection.Input, true, 0, 0, "objectID", DataRowVersion.Current, NullableHelper.DBNullConvertFrom(objectID)));
command.Parameters.Add(new SqlParameter("@activationDate", SqlDbType.DateTime, 0, ParameterDirection.Input, true, 0, 0, "activationDate", DataRowVersion.Current, NullableHelper.DBNullConvertFrom(activationDate)));
command.Parameters.Add(new SqlParameter("@fromService", SqlDbType.NVarChar, 255, ParameterDirection.Input, true, 0, 0, "fromService", DataRowVersion.Current, NullableHelper.DBNullConvertFrom(fromService)));
command.Parameters.Add(new SqlParameter("@toService", SqlDbType.NVarChar, 255, ParameterDirection.Input, true, 0, 0, "toService", DataRowVersion.Current, NullableHelper.DBNullConvertFrom(toService)));
command.Parameters.Add(new SqlParameter("@contractName", SqlDbType.NVarChar, 255, ParameterDirection.Input, true, 0, 0, "contractName", DataRowVersion.Current, NullableHelper.DBNullConvertFrom(contractName)));
command.Parameters.Add(new SqlParameter("@lifeTime", SqlDbType.Int, 0, ParameterDirection.Input, true, 0, 0, "lifeTime", DataRowVersion.Current, NullableHelper.DBNullConvertFrom(lifeTime)));
command.Parameters.Add(new SqlParameter("@isWithEncryption", SqlDbType.Bit, 0, ParameterDirection.Input, true, 0, 0, "isWithEncryption", DataRowVersion.Current, NullableHelper.DBNullConvertFrom(isWithEncryption)));
command.Parameters.Add(new SqlParameter("@messageBody", SqlDbType.VarBinary, -1, ParameterDirection.Input, true, 0, 0, "messageBody", DataRowVersion.Current, NullableHelper.DBNullConvertFrom(messageBody)));
command.Parameters.Add(new SqlParameter("@messageType", SqlDbType.NVarChar, 255, ParameterDirection.Input, true, 0, 0, "messageType", DataRowVersion.Current, NullableHelper.DBNullConvertFrom(messageType)));
command.Parameters.Add(new SqlParameter("@pendingMessageID", SqlDbType.BigInt, 0, ParameterDirection.InputOutput, true, 0, 0, "pendingMessageID", DataRowVersion.Current, NullableHelper.DBNullConvertFrom(pendingMessageID)));
await command.ExecuteNonQueryAsync();
if (command.Parameters["@pendingMessageID"].Value == DBNull.Value)
{
pendingMessageID = null;
}
else
{
pendingMessageID = (long)(command.Parameters["@pendingMessageID"].Value);
}
return(pendingMessageID);
}
}
catch (SqlException ex)
{
DBWrapperExceptionsHelper.ThrowError(ex, _log);
return(-1);
}
}
public async Task <int> SendMessageWithInitiatorConversationGroup(
SqlConnection dbconnection,
string fromService,
string toService,
string contractName,
int?lifeTime,
bool?isWithEncryption,
Guid initiatorConversationGroupID,
String messageType,
byte[] body,
bool?withEndDialog = null)
{
try
{
using (SqlCommand command = new SqlCommand())
{
command.Connection = dbconnection;
command.CommandText = "SSSB.SendMessageWithInitiatorConversationGroup";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 0, ParameterDirection.ReturnValue, true, 0, 0, "RETURN_VALUE", DataRowVersion.Current, null));
command.Parameters.Add(new SqlParameter("@fromService", SqlDbType.NVarChar, 255, ParameterDirection.Input, true, 0, 0, "fromService", DataRowVersion.Current, NullableHelper.DBNullConvertFrom(fromService)));
command.Parameters.Add(new SqlParameter("@toService", SqlDbType.NVarChar, 255, ParameterDirection.Input, true, 0, 0, "toService", DataRowVersion.Current, NullableHelper.DBNullConvertFrom(toService)));
command.Parameters.Add(new SqlParameter("@contractName", SqlDbType.NVarChar, 128, ParameterDirection.Input, true, 0, 0, "contractName", DataRowVersion.Current, NullableHelper.DBNullConvertFrom(contractName)));
command.Parameters.Add(new SqlParameter("@lifeTime", SqlDbType.Int, 0, ParameterDirection.Input, true, 0, 0, "lifeTime", DataRowVersion.Current, NullableHelper.DBNullConvertFrom(lifeTime)));
command.Parameters.Add(new SqlParameter("@withEncryption", SqlDbType.Bit, 0, ParameterDirection.Input, true, 0, 0, "isWithEncryption", DataRowVersion.Current, isWithEncryption ?? false));
command.Parameters.Add(new SqlParameter("@initiatorConversationGroupID", SqlDbType.UniqueIdentifier, 0, ParameterDirection.Input, false, 0, 0, "initiatorConversationGroupID", DataRowVersion.Current, initiatorConversationGroupID));
command.Parameters.Add(new SqlParameter("@messageType", SqlDbType.NVarChar, 255, ParameterDirection.Input, true, 0, 0, "messageType", DataRowVersion.Current, NullableHelper.DBNullConvertFrom(messageType)));
command.Parameters.Add(new SqlParameter("@body", SqlDbType.VarBinary, -1, ParameterDirection.Input, true, 0, 0, "body", DataRowVersion.Current, NullableHelper.DBNullConvertFrom(body)));
command.Parameters.Add(new SqlParameter("@withEndDialog", SqlDbType.Bit, 0, ParameterDirection.Input, true, 0, 0, "withEndDialog", DataRowVersion.Current, withEndDialog ?? false));
await command.ExecuteNonQueryAsync();
return((Int32)command.Parameters[RETURN_VALUE_PARAMETER_NAME].Value);
}
}
catch (SqlException ex)
{
DBWrapperExceptionsHelper.ThrowError(ex, _log);
return(-1);
}
}
public async Task <int> SendMessage(
SqlConnection dbconnection,
Guid?conversationHandle,
String messageType,
byte[] body)
{
try
{
using (SqlCommand command = new SqlCommand())
{
command.Connection = dbconnection;
command.CommandText = "SSSB.SendMessage";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 0, ParameterDirection.ReturnValue, true, 0, 0, "RETURN_VALUE", DataRowVersion.Current, null));
command.Parameters.Add(new SqlParameter("@conversationHandle", SqlDbType.UniqueIdentifier, 0, ParameterDirection.Input, true, 0, 0, "conversationHandle", DataRowVersion.Current, NullableHelper.DBNullConvertFrom(conversationHandle)));
command.Parameters.Add(new SqlParameter("@messageType", SqlDbType.NVarChar, 255, ParameterDirection.Input, true, 0, 0, "messageType", DataRowVersion.Current, NullableHelper.DBNullConvertFrom(messageType)));
command.Parameters.Add(new SqlParameter("@body", SqlDbType.VarBinary, -1, ParameterDirection.Input, true, 0, 0, "body", DataRowVersion.Current, NullableHelper.DBNullConvertFrom(body)));
await command.ExecuteNonQueryAsync();
return((Int32)command.Parameters[RETURN_VALUE_PARAMETER_NAME].Value);
}
}
catch (SqlException ex)
{
DBWrapperExceptionsHelper.ThrowError(ex, _log);
return(-1);
}
}