private void OnEntryCreated(IDbTransaction tx, ICommit commit, EntryCreated @event)
{
var sqlParams = @event.ToDynamic();
sqlParams.Id = commit.AggregateId();
// Record who created the entry so it can be used when it is updated.
const string sql = @"
INSERT INTO [dbo].[ActivityProjector.Entry]
([EntryId]
,[UserId])
SELECT
@Id
,@UserId
WHERE NOT EXISTS(SELECT * FROM [dbo].[ActivityProjector.Entry] WHERE [EntryId] = @Id);" ;
tx.Connection.Execute(sql, (object)sqlParams, tx);
RecordActivity(tx, new Models.Activity {
UserId = @event.UserId,
Type = (int)ActivityType.EntryCreated,
When = @event.CreatedAt,
Link = commit.AggregateId().ToString()
});
}
private void OnEntryCreated(IDbTransaction tx, ICommit commit, EntryCreated @event)
{
var sqlParams = @event.ToDynamic();
sqlParams.Id = commit.AggregateId();
const string sql = @"
INSERT INTO [dbo].[PlacementProjector.Entry]
([Id]
,[PlacementId]
,[SkillSetId]
,[Title]
,[Description]
,[UserId]
,[Where]
,[When]
,[Shared])
SELECT TOP 1
@Id
,Id
,@SkillSetId
,@Title
,@Description
,@UserId
,[FullyQualifiedTitle]
,@When
,0 -- Not shared
FROM [PlacementProjector.Placement]
WHERE [FullyQualifiedTitle] = @Where
AND [UserId] = @UserId
AND NOT EXISTS(SELECT * FROM [dbo].[PlacementProjector.Entry] WHERE Id = @Id);" ;
tx.Connection.Execute(sql, (object)sqlParams, tx);
}
private void OnEntryCreated(IDbTransaction tx, ICommit commit, EntryCreated @event)
{
var sqlParams = @event.ToDynamic();
sqlParams.Id = commit.AggregateId();
const string sql = @"
INSERT INTO [dbo].[EntryProjector.Entry]
([Id]
,[SkillSetId]
,[Title]
,[Description]
,[UserId]
,[Where]
,[When]
,[CreatedAt]
,[LastUpdatedAt]
,[Shared])
SELECT
@Id
,@SkillSetId
,@Title
,@Description
,@UserId
,@Where
,@When
,@CreatedAt
,@LastUpdatedAt
,0 -- Not shared
WHERE NOT EXISTS(SELECT * FROM [dbo].[EntryProjector.Entry] WHERE Id = @Id);" ;
tx.Connection.Execute(sql, (object)sqlParams, tx);
}
public void Create(ActivityLogEntry entry)
{
entry.Date = DateTime.UtcNow;
_repo.Create(entry);
EntryCreated?.Invoke(this, new GenericEventArgs <ActivityLogEntry>(entry));
}
private void OnMessageReceived(object sender, IMessageEventArgs e)
{
var message = e.Message;
var jObject = JObject.Parse(message);
_objectCreator.CreateObject(jObject);
EntryCreated?.Invoke(this, new EventArgs());
}
/// <inheritdoc/>
public void Create(ActivityLog entry)
{
using var dbContext = _provider.CreateContext();
dbContext.ActivityLogs.Add(entry);
dbContext.SaveChanges();
EntryCreated?.Invoke(this, new GenericEventArgs <ActivityLogEntry>(ConvertToOldModel(entry)));
}
public async Task CreateAsync(ActivityLogEntry entry)
{
entry.Date = DateTime.UtcNow;
await _repo.CreateAsync(entry);
EntryCreated?.Invoke(this, new GenericEventArgs <ActivityLogEntry>(entry));
}
/// <inheritdoc/>
public async Task CreateAsync(ActivityLog entry)
{
await using var dbContext = _provider.CreateContext();
dbContext.ActivityLogs.Add(entry);
await dbContext.SaveChangesAsync().ConfigureAwait(false);
EntryCreated?.Invoke(this, new GenericEventArgs <ActivityLogEntry>(ConvertToOldModel(entry)));
}
void Apply(EntryCreated @event)
{
_isCreated = true;
SkillSetId = @event.SkillSetId;
Title = @event.Title;
Description = @event.Description;
Where = @event.Where;
When = @event.When;
UserId = @event.UserId;
CreatedAt = @event.CreatedAt;
LastUpdatedAt = @event.LastUpdatedAt;
}
private void OnEntryCreated(IDbTransaction tx, ICommit commit, EntryCreated @event)
{
var sqlParams = @event.ToDynamic();
sqlParams.Id = commit.AggregateId();
const string sql = @"
INSERT INTO [dbo].[WhereProjector.Entry]
([EntryId]
,[UserId]
,[Where])
SELECT
@Id
,@UserId
,@Where
WHERE NOT EXISTS(SELECT * FROM [dbo].[WhereProjector.Entry] WHERE [EntryId] = @Id);" ;
tx.Connection.Execute(sql, (object)sqlParams, tx);
CreateWhereProjection(tx, @event.UserId, @event.Where);
}
