void Apply(EntrySelfAssessmentUpdated @event) { if (_selfAssessments.ContainsKey(@event.SelfAssessment.SkillId)) { if (_selfAssessments[@event.SelfAssessment.SkillId].ContainsKey(@event.SelfAssessment.CreatedAt.ToUnixTimeMilliseconds())) { // Self assessment already exists, update. _selfAssessments[@event.SelfAssessment.SkillId][@event.SelfAssessment.CreatedAt.ToUnixTimeMilliseconds()] = @event.SelfAssessment; } } }
private void OnEntrySelfAssessmentUpdated(IDbTransaction tx, ICommit commit, EntrySelfAssessmentUpdated @event) { var sqlParams = new { @event.SelfAssessment.EntryId, @event.SelfAssessment.SkillId, @event.SelfAssessment.SelfAssessmentLevelId, @event.SelfAssessment.Score }; const string sql = @" UPDATE [dbo].[EntryProjector.SelfAssessment] SET [SelfAssessmentLevelId] = @SelfAssessmentLevelId ,[Score] = @Score WHERE [EntryId] = @EntryId AND [SkillId] = @SkillId;" ; tx.Connection.Execute(sql, (object)sqlParams, tx); }