private void GetNeighborhoodClients(string neighborhoodView,
out List <string> neighborhoodClients, out List <string> neighborhoodBranches)
{
neighborhoodClients = new List <string>();
neighborhoodBranches = new List <string>();
using (var scope = new TransactionScope(TransactionScopeOption.Suppress))
using (var kiss = new SqlConnection(Kiss.GetConnection(_sql)))
using (var neighbors = new SqlCommand(neighborhoodView, kiss)
{
CommandType = CommandType.Text
})
{
kiss.Open();
using (var clientReader = neighbors.ExecuteReader())
{
if (clientReader.HasRows)
{
while (clientReader.Read())
{
neighborhoodClients.Add((string)clientReader["client_id"]);
neighborhoodBranches.Add((string)clientReader["branch_id"]);
}
}
}
kiss.Close();
scope.Complete();
}
}
public static object Retrieve(string sql, string retrieveProcedure,
SqlParameter[] retrieveParameters, string dataName)
{
object retrieveResult = null;
var sqltoDistr = Kiss.GetTimeout(KissTimeout.DISTRIBUTION_SQL_PROCESS);
using (var scope = new TransactionScope(TransactionScopeOption.Suppress))
using (var kiss = new SqlConnection(Kiss.GetConnection(sql)))
using (var retrieve =
new SqlCommand(retrieveProcedure, kiss)
{
CommandTimeout = sqltoDistr,
CommandType = CommandType.StoredProcedure
})
{
retrieve.Parameters.AddRange(retrieveParameters);
kiss.Open();
using (var dataReader = retrieve.ExecuteReader(CommandBehavior.SingleRow))
{
if (dataReader.HasRows)
{
dataReader.Read();
retrieveResult = dataReader[dataName];
}
}
kiss.Close();
scope.Complete();
}
return(retrieveResult);
}
private string GetLocalQueuePath()
{
string queuePath = null;
using (var scope = new TransactionScope(TransactionScopeOption.Suppress))
using (var kiss = new SqlConnection(Kiss.GetConnection(_sql)))
using (var self = new SqlCommand(VIEW_NEIGHBORS_SELF, kiss)
{
CommandType = CommandType.Text
})
{
kiss.Open();
using (var clientReader = self.ExecuteReader(CommandBehavior.SingleRow))
{
if (clientReader.HasRows)
{
clientReader.Read();
queuePath = string.Format(((string)clientReader["queue"]).ToLower(),
((string)clientReader["dns"]).ToLower(), _pathPostfix);
queuePath = queuePath.Replace(REPLACE_MSMQ_FORMATNAME, string.Empty);
}
}
kiss.Close();
scope.Complete();
}
return(queuePath);
}
public void Recover(MessageQueue recoveryQueue, string correlationId)
{
var conversations = LargeMessage.GetConversationsOfCorrelation(recoveryQueue, correlationId);
var dtctoPo = TimeSpan.FromSeconds(Kiss.GetTimeout(KissTimeout.PO_DTC_RECOVERY));
var sqltoPo = Kiss.GetTimeout(KissTimeout.PO_SQL_RECOVERY);
using (var scope = new TransactionScope(TransactionScopeOption.Required, dtctoPo))
using (var kiss = new SqlConnection(Kiss.GetConnection(_sql)))
using (var poRemoval =
new SqlCommand(PROCEDURE_PO_REMOVAL_ALL, kiss)
{
CommandTimeout = sqltoPo,
CommandType = CommandType.StoredProcedure
})
{
kiss.Open();
poRemoval.ExecuteNonQuery();
kiss.Close();
foreach (var conversation in conversations)
{
OnProcessMessage(KissTransactionMode.DTC, recoveryQueue, conversation);
}
scope.Complete();
}
}
protected static string[] RetrieveAll(string sql, string catalogView, RowProjection FormatRow)
{
string[] result;
var sqltoDistr = Kiss.GetTimeout(KissTimeout.DISTRIBUTION_SQL_RETRIEVE_ALL);
using (var scope = new TransactionScope(TransactionScopeOption.Suppress))
using (var kiss = new SqlConnection(Kiss.GetConnection(sql)))
using (var allIds = new SqlCommand(catalogView, kiss)
{
CommandTimeout = sqltoDistr,
CommandType = CommandType.Text
})
{
kiss.Open();
using (var idsTable = new DataTable())
using (var idsAdapter = new SqlDataAdapter(allIds))
{
idsAdapter.Fill(idsTable);
result = new string[idsTable.Rows.Count];
for (var i = 0; i < idsTable.Rows.Count; i++)
{
result[i] = FormatRow(idsTable.Rows[i]);
}
}
kiss.Close();
scope.Complete();
}
return(result);
}
public bool TransmitBundles()
{
bool transmitted;
long selfId;
DateTime?selfLastUpdate,
initialLastUpdate;
var dialogLifetime = Kiss.GetTimeout(KissTimeout.BUNDLE_SSSB);
var sqltoBundle = Kiss.GetTimeout(KissTimeout.KISS_SQL_STAGELIST);
WaitForSelfStage(false, null, out selfId, out initialLastUpdate);
QueryStageList(false);
transmitted = WaitForSelfStage(true, initialLastUpdate, out selfId, out selfLastUpdate);
if (transmitted)
{
GarbageCollectBundles();
using (var kiss = new SqlConnection(Kiss.GetConnection(_sql)))
using (var bundleTransmission =
new SqlCommand(PROCEDURE_BUNDLE_TRANSMISSION, kiss)
{
CommandTimeout = sqltoBundle, CommandType = CommandType.StoredProcedure
})
{
bundleTransmission.Parameters.AddWithValue("@dialog_lifetime", dialogLifetime);
kiss.Open();
bundleTransmission.ExecuteNonQuery();
kiss.Close();
}
}
return(transmitted);
}
private void RemoveAllBundlesAndStages()
{
var dtctoBundle = TimeSpan.FromSeconds(Kiss.GetTimeout(KissTimeout.BUNDLE_DTC_RECOVERY));
var sqltoBundle = Kiss.GetTimeout(KissTimeout.BUNDLE_SQL_RECOVERY);
using (var scope = new TransactionScope(TransactionScopeOption.Required, dtctoBundle))
using (var kiss = new SqlConnection(Kiss.GetConnection(_sql)))
using (var bundleRemoval =
new SqlCommand(PROCEDURE_BUNDLE_REMOVAL_ALL, kiss)
{
CommandTimeout = sqltoBundle,
CommandType = CommandType.StoredProcedure
})
using (var stageRemoval =
new SqlCommand(PROCEDURE_STAGE_REMOVAL_ALL, kiss)
{
CommandTimeout = sqltoBundle,
CommandType = CommandType.StoredProcedure
})
{
kiss.Open();
bundleRemoval.ExecuteNonQuery();
stageRemoval.ExecuteNonQuery();
kiss.Close();
scope.Complete();
}
}
private List <MessageQueue> GetNeighborhoodQueues(string neighborhoodView, string[] filter)
{
string queuePath;
var sortedFilter = filter != null && filter.Length > 0 ? new string[filter.Length] : null;
var neighborhoodQueues = new List <MessageQueue>();
if (sortedFilter != null)
{
filter.CopyTo(sortedFilter, 0);
Array.Sort(sortedFilter);
}
using (var scope = new TransactionScope(TransactionScopeOption.Suppress))
using (var kiss = new SqlConnection(Kiss.GetConnection(_sql)))
using (var neighbors = new SqlCommand(neighborhoodView, kiss)
{
CommandType = CommandType.Text
})
{
kiss.Open();
using (var clientReader = neighbors.ExecuteReader())
{
if (clientReader.HasRows)
{
while (clientReader.Read())
{
if ((sortedFilter == null) ||
(sortedFilter != null &&
Array.BinarySearch(sortedFilter, (string)clientReader["client_id"]) >= 0))
{
queuePath = string.Format(((string)clientReader["queue"]).ToLower(),
((string)clientReader["dns"]).ToLower(), _pathPostfix);
neighborhoodQueues.
Add(new MessageQueue {
Path = queuePath,
Formatter = new BinaryMessageFormatter()
});
}
}
}
}
kiss.Close();
scope.Complete();
}
return(neighborhoodQueues);
}
public void GarbageCollectBundles()
{
var sqltoBundle = Kiss.GetTimeout(KissTimeout.KISS_SQL_GARBAGE_COLLECTION);
using (var kiss = new SqlConnection(Kiss.GetConnection(_sql)))
using (var garbageCollectionExecution =
new SqlCommand(PROCEDURE_GARBAGE_COLLECTION, kiss)
{
CommandTimeout = sqltoBundle,
CommandType = CommandType.StoredProcedure
})
{
kiss.Open();
garbageCollectionExecution.ExecuteNonQuery();
kiss.Close();
}
}
public void Ping()
{
var dialogLifetime = Kiss.GetTimeout(KissTimeout.KISS_SSSB_PING);
var sqltoPing = Kiss.GetTimeout(KissTimeout.KISS_SQL_PING);
using (var kiss = new SqlConnection(Kiss.GetConnection(_sql)))
using (var ping = new SqlCommand(PROCEDURE_PING, kiss)
{
CommandTimeout = sqltoPing,
CommandType = CommandType.StoredProcedure
})
{
ping.Parameters.AddWithValue("@dialog_lifetime", dialogLifetime);
kiss.Open();
ping.ExecuteNonQuery();
kiss.Close();
}
}
private void QueryStageList(bool self)
{
var dialogLifetime = Kiss.GetTimeout(KissTimeout.KISS_SSSB_STAGELIST);
var sqltoBundle = Kiss.GetTimeout(KissTimeout.KISS_SQL_STAGELIST);
using (var kiss = new SqlConnection(Kiss.GetConnection(_sql)))
using (var stageListQuerying =
new SqlCommand(PROCEDURE_STAGE_LIST_QUERYING, kiss)
{
CommandTimeout = sqltoBundle, CommandType = CommandType.StoredProcedure
})
{
stageListQuerying.Parameters.AddWithValue("@self", self ? 1 : 0);
stageListQuerying.Parameters.AddWithValue("@dialog_lifetime", dialogLifetime);
kiss.Open();
stageListQuerying.ExecuteNonQuery();
kiss.Close();
}
}
public void Recover()
{
var sqltoBundle = Kiss.GetTimeout(KissTimeout.BUNDLE_SQL_RECOVERY);
using (var kiss = new SqlConnection(Kiss.GetConnection(_sql)))
using (var bundleRecovery =
new SqlCommand(PROCEDURE_BUNDLE_RECOVERY, kiss)
{
CommandTimeout = sqltoBundle,
CommandType = CommandType.StoredProcedure
})
{
bundleRecovery.Parameters.AddWithValue("@bundle_id", _id);
bundleRecovery.Parameters.AddWithValue("@client_id", _clientId);
kiss.Open();
bundleRecovery.ExecuteNonQuery();
kiss.Close();
}
}
protected void Process(string processProcedure, SqlParameter[] processParameters,
string dataName, out object scalarResult)
{
var sqltoDistr = Kiss.GetTimeout(KissTimeout.DISTRIBUTION_SQL_PROCESS);
using (var kiss = new SqlConnection(Kiss.GetConnection(_sql)))
using (var process =
new SqlCommand(processProcedure, kiss)
{
CommandTimeout = sqltoDistr,
CommandType = CommandType.StoredProcedure
})
{
process.Parameters.AddRange(processParameters);
process.Parameters.AddWithValue(dataName, _largeMessage.DataBuffer);
kiss.Open();
scalarResult = process.ExecuteScalar();
kiss.Close();
}
}
public void RegisterPC(bool deregister)
{
var dialogLifetime = Kiss.GetTimeout(KissTimeout.KISS_SSSB_PC_REGISTRATION);
var sqltoRegistration = Kiss.GetTimeout(KissTimeout.KISS_SQL_PC_REGISTRATION);
using (var kiss = new SqlConnection(Kiss.GetConnection(_sql)))
using (var pcRegistration =
new SqlCommand(PROCEDURE_PC_REGISTRATION, kiss)
{
CommandTimeout = sqltoRegistration,
CommandType = CommandType.StoredProcedure
})
{
pcRegistration.Parameters.AddWithValue("@deregister", deregister ? 1 : 0);
pcRegistration.Parameters.AddWithValue("@dialog_lifetime", dialogLifetime);
kiss.Open();
pcRegistration.ExecuteNonQuery();
kiss.Close();
}
}
protected override void OnProcessMessage(KissTransactionMode mode, MessageQueue queue, Guid conversation)
{
string[] extension;
MessageQueueTransaction msmqTransaction = null;
var convMessages = LargeMessage.GetMessagesOfConversation(queue, conversation);
var largeMessage = new LargeMessage(_msmqCapacity, null);
var dtctoPo = TimeSpan.FromSeconds(Kiss.GetTimeout(KissTimeout.PO_DTC_STORAGE));
var sqltoPo = Kiss.GetTimeout(KissTimeout.PO_SQL_STORAGE);
try
{
using (var scope = new TransactionScope(TransactionScopeOption.Required, dtctoPo))
using (var kiss = new SqlConnection(Kiss.GetConnection(_sql)))
using (var poStorage =
new SqlCommand(PROCEDURE_PO_STORAGE, kiss)
{
CommandTimeout = sqltoPo,
CommandType = CommandType.StoredProcedure
})
using (var poRemoval =
new SqlCommand(PROCEDURE_PO_REMOVAL, kiss)
{
CommandTimeout = sqltoPo,
CommandType = CommandType.StoredProcedure
})
{
if (mode == KissTransactionMode.DTC)
{
largeMessage.Receive(queue, null, convMessages,
Kiss.GetTimeout(KissTimeout.PO_RECEIVE_TIMEOUT));
}
else
{
using (var suppress = new TransactionScope(TransactionScopeOption.Suppress))
{
msmqTransaction = new MessageQueueTransaction();
msmqTransaction.Begin();
largeMessage.Receive(queue, msmqTransaction, convMessages,
Kiss.GetTimeout(KissTimeout.PO_RECEIVE_TIMEOUT));
suppress.Complete();
}
}
extension = largeMessage.DecodeExtension();
kiss.Open();
if (bool.Parse(extension[2]))
{
poRemoval.Parameters.AddWithValue("@po_id", extension[0]);
poRemoval.ExecuteNonQuery();
}
else
{
poStorage.Parameters.AddWithValue("@po_id", extension[0]);
poStorage.Parameters.AddWithValue("@po_sent", DateTime.FromBinary(long.Parse(extension[1])));
poStorage.Parameters.AddWithValue("@po_received", DateTime.Now);
poStorage.Parameters.AddWithValue("@po", largeMessage.DataBuffer);
poStorage.ExecuteNonQuery();
}
kiss.Close();
scope.Complete();
}
if (mode != KissTransactionMode.DTC)
{
msmqTransaction.Commit();
}
}
catch
{
if (msmqTransaction != null && mode == KissTransactionMode.MSMQ)
{
msmqTransaction.Abort();
}
throw;
}
finally
{
if (msmqTransaction != null)
{
msmqTransaction.Dispose();
}
}
}
private bool WaitForSelfStage(bool wait, DateTime?initialLastUpdate,
out long selfId, out DateTime?selfLastUpdate)
{
bool done;
SqlParameter sequenceNumber,
lastUpdate;
var dialogLifetime = Kiss.GetTimeout(KissTimeout.KISS_SSSB_STAGELIST);
var sqltoBundle = Kiss.GetTimeout(KissTimeout.KISS_SQL_STAGELIST);
selfId = ID_NO_ANSWER_FROM_BACKEND;
selfLastUpdate = null;
do
{
using (var kiss = new SqlConnection(Kiss.GetConnection(_sql)))
using (var stageRetrieval =
new SqlCommand(PROCEDURE_STAGE_RETRIEVAL, kiss)
{
CommandTimeout = sqltoBundle, CommandType = CommandType.StoredProcedure
})
{
stageRetrieval.Parameters.AddWithValue("@self", 1);
sequenceNumber = stageRetrieval.Parameters.Add("@sequence_number", SqlDbType.BigInt);
lastUpdate = stageRetrieval.Parameters.Add("@last_update", SqlDbType.DateTime);
sequenceNumber.Direction = lastUpdate.Direction = ParameterDirection.Output;
lastUpdate.IsNullable = true;
kiss.Open();
stageRetrieval.ExecuteNonQuery();
kiss.Close();
selfId = (long)sequenceNumber.Value;
selfLastUpdate = ((SqlDateTime)lastUpdate.SqlValue).IsNull ? null : (DateTime?)lastUpdate.Value;
if (wait)
{
if (initialLastUpdate == null)
{
done = selfId != ID_NO_ANSWER_FROM_BACKEND;
}
else
{
done = selfLastUpdate != initialLastUpdate;
}
}
else
{
done = selfId != ID_NO_ANSWER_FROM_BACKEND;
}
}
if (wait && !done)
{
Thread.Sleep(SLEEP_STAGE_RETRIEVAL);
}
dialogLifetime -= SLEEP_STAGE_RETRIEVAL / 1000;
} while (dialogLifetime >= 0 && wait && !done);
return(done);
}
protected override void OnProcessMessage(KissTransactionMode mode, MessageQueue queue, Guid conversation)
{
string[] extension;
string bundleSentChar;
DateTime bundleSent;
MessageQueueTransaction msmqTransaction = null;
var convMessages = LargeMessage.GetMessagesOfConversation(queue, conversation);
var largeMessage = new LargeMessage(_msmqCapacity, null);
var dtctoBundle = TimeSpan.FromSeconds(Kiss.GetTimeout(KissTimeout.BUNDLE_DTC_STORAGE));
var sqltoBundle = Kiss.GetTimeout(KissTimeout.BUNDLE_SQL_STORAGE);
try
{
using (var scope = new TransactionScope(TransactionScopeOption.Required, dtctoBundle))
using (var kiss = new SqlConnection(Kiss.GetConnection(_sql)))
using (var bundleStorage =
new SqlCommand(PROCEDURE_BUNDLE_STORAGE, kiss)
{
CommandTimeout = sqltoBundle,
CommandType = CommandType.StoredProcedure
})
{
if (mode == KissTransactionMode.DTC)
{
largeMessage.Receive(queue, null, convMessages,
Kiss.GetTimeout(KissTimeout.BUNDLE_RECEIVE_TIMEOUT));
}
else
{
using (var suppress = new TransactionScope(TransactionScopeOption.Suppress))
{
msmqTransaction = new MessageQueueTransaction();
msmqTransaction.Begin();
largeMessage.Receive(queue, msmqTransaction, convMessages,
Kiss.GetTimeout(KissTimeout.BUNDLE_RECEIVE_TIMEOUT));
suppress.Complete();
}
}
extension = largeMessage.DecodeExtension();
bundleSent = DateTime.FromBinary(long.Parse(extension[2]));
bundleSentChar = bundleSent.ToString(FORMAT_BUNDLE_SENT, DateTimeFormatInfo.InvariantInfo);
bundleStorage.Parameters.AddWithValue("@bundle_id", long.Parse(extension[0]));
bundleStorage.Parameters.AddWithValue("@client_id", extension[1]);
bundleStorage.Parameters.AddWithValue("@bundle_sent", bundleSent);
bundleStorage.Parameters.AddWithValue("@bundle_received", DateTime.Now);
bundleStorage.Parameters.AddWithValue("@bundle_sent_char", bundleSentChar);
bundleStorage.Parameters.AddWithValue("@bundle", largeMessage.DataBuffer);
kiss.Open();
bundleStorage.ExecuteNonQuery();
kiss.Close();
scope.Complete();
}
if (mode != KissTransactionMode.DTC)
{
msmqTransaction.Commit();
}
}
catch
{
if (msmqTransaction != null && mode == KissTransactionMode.MSMQ)
{
msmqTransaction.Abort();
}
throw;
}
finally
{
if (msmqTransaction != null)
{
msmqTransaction.Dispose();
}
}
}
