public EventMessage GetMessage(EventMessageIdentifier identifier)
{
var sqlIdentifier = identifier as SqlEventMessageIdentifier;
if (sqlIdentifier == null)
{
return(null);
}
EventMessage message = null;
using (var connection = new SqlConnection(_connectionString))
{
connection.Open();
using (var command = new SqlCommand(Sql.GetMessage, connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@messageId", SqlDbType.Int).Value = sqlIdentifier.Id;
using (SqlDataReader reader = command.ExecuteReader())
{
if (reader.Read())
{
message = ReadMessage(reader);
}
}
}
}
return(message);
}
public EventMessages GetMessages(EventMessageIdentifier startIdentifier, EventMessageIdentifier endIdentifier)
{
var messages = new EventMessages();
var sqlStartIdentifier = startIdentifier as SqlEventMessageIdentifier;
var sqlEndIdentifier = endIdentifier as SqlEventMessageIdentifier;
if (sqlStartIdentifier == null || sqlEndIdentifier == null)
{
return(messages);
}
var eventFilter = GetEventFilter();
if (eventFilter == null)
{
GetMessages(messages, sqlStartIdentifier, sqlEndIdentifier);
}
else
{
GetMessages(messages, sqlStartIdentifier, sqlEndIdentifier, eventFilter);
}
return(messages);
}
protected void HandleEventMessage(EventMessageIdentifier identifier)
{
_messageNotifyHandler.HandleEventMessage(identifier);
}