private void OnEntryRemoved(IDbTransaction tx, ICommit commit, EntryRemoved @event)
{
var sqlParams = @event.ToDynamic();
sqlParams.Id = commit.AggregateId();
// Get the original where entry.
const string sql1 = @"
SELECT [Where]
,[UserId]
FROM [dbo].[WhereProjector.Entry]
WHERE [EntryId] = @Id;" ;
var row = tx.Connection.QuerySingle <dynamic>(sql1, (object)sqlParams, tx);
var where = row.Where;
var userId = row.UserId;
const string sql2 = @"
DELETE FROM [dbo].[WhereProjector.Entry]
WHERE [EntryId] = @Id;" ;
tx.Connection.Execute(sql2, (object)sqlParams, tx);
DeleteWhereProjection(tx, userId, where);
}
private void OnEntryRemoved(IDbTransaction tx, ICommit commit, EntryRemoved @event)
{
var sqlParams = @event.ToDynamic();
sqlParams.Id = commit.AggregateId();
// Get the original where entry.
const string sql1 = @"
SELECT [UserId]
FROM [dbo].[ActivityProjector.Entry]
WHERE [EntryId] = @Id;" ;
var userId = tx.Connection.QuerySingle <int>(sql1, (object)sqlParams, tx);
const string sql2 = @"
DELETE FROM [dbo].[ActivityProjector.Entry]
WHERE [EntryId] = @Id;" ;
tx.Connection.Execute(sql2, (object)sqlParams, tx);
RecordActivity(tx, new Models.Activity {
UserId = userId,
Type = (int)ActivityType.EntryRemoved,
When = commit.CommitStamp,
Link = commit.AggregateId().ToString()
});
}
private void OnEntryRemoved(IDbTransaction tx, ICommit commit, EntryRemoved @event)
{
var sqlParams = @event.ToDynamic();
sqlParams.Id = commit.AggregateId();
const string sql = @"
DELETE FROM [dbo].[PlacementProjector.Entry]
WHERE [Id] = @Id;" ;
tx.Connection.Execute(sql, (object)sqlParams, tx);
}