private void OnPlacementCreated(IDbTransaction tx, ICommit commit, PlacementCreated @event)
{
RecordActivity(tx, new Models.Activity {
UserId = @event.UserId,
Type = (int)ActivityType.PlacementCreated,
When = @event.CreatedAt,
Link = commit.AggregateId().ToString()
});
}
void Apply(PlacementCreated @event)
{
_isCreated = true;
UserId = @event.UserId;
Title = @event.Title;
Start = @event.Start;
End = @event.End;
Reference = @event.Reference;
CreatedBy = @event.CreatedBy;
CreatedAt = @event.CreatedAt;
LastUpdatedBy = @event.LastUpdatedBy;
LastUpdatedAt = @event.LastUpdatedAt;
}
private void OnPlacementCreated(IDbTransaction tx, ICommit commit, PlacementCreated @event)
{
var sqlParams = new {
Id = commit.AggregateId(),
@event.UserId,
Where = @event.FullyQualifiedTitle
};
const string sql = @"
INSERT INTO [dbo].[WhereProjector.Placement]
([PlacementId]
,[UserId]
,[Where])
SELECT
@Id
,@UserId
,@Where
WHERE NOT EXISTS(SELECT * FROM [dbo].[WhereProjector.Placement] WHERE [PlacementId] = @Id);" ;
tx.Connection.Execute(sql, (object)sqlParams, tx);
CreateWhereProjection(tx, @event.UserId, @event.FullyQualifiedTitle);
}
private void OnPlacementCreated(IDbTransaction tx, ICommit commit, PlacementCreated @event)
{
var sqlParams = @event.ToDynamic();
sqlParams.Id = commit.AggregateId();
_logger.LogDebug($"Creating with CommitId:{commit.CommitId}, CommitSequence:{commit.CommitSequence}, StreamId:{commit.StreamId}, StreamRevision:{commit.StreamRevision}, Events:{commit.Events.FoldLeft("", (s, m) => $"{s}{m.Body} ")}, placement with id {commit.AggregateId()} with the values: Title:{@event.Title}, FullyQualifiedTitle:{@event.FullyQualifiedTitle}, Start:{@event.Start}, End:{@event.End}, Reference:{@event.Reference}, LastUpdatedBy:{@event.LastUpdatedBy}, LastUpdatedAt:{@event.LastUpdatedAt}, UserId:{@event.UserId}, CreatedAt:{@event.CreatedAt}, CreatedBy:{@event.CreatedBy}");
const string sql = @"
INSERT INTO [dbo].[PlacementProjector.Placement]
([Id]
,[UserId]
,[Title]
,[FullyQualifiedTitle]
,[Start]
,[End]
,[Reference]
,[CreatedBy]
,[CreatedAt]
,[LastUpdatedBy]
,[LastUpdatedAt])
SELECT
@Id
,@UserId
,@Title
,@FullyQualifiedTitle
,@Start
,@End
,@Reference
,@CreatedBy
,@CreatedAt
,@CreatedBy
,@CreatedAt
WHERE NOT EXISTS(SELECT * FROM [dbo].[PlacementProjector.Placement] WHERE Id = @Id);" ;
tx.Connection.Execute(sql, (object)sqlParams, tx);
}
