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