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