public void Handle()
{
using (var context = new PlanningPokerDbContext())
{
var eventRecord = new EventRecord(modelEvent);
context.EventRecords.Add(eventRecord);
context.SaveChanges();
modelEvent.id = eventRecord.Id;
var model = new ModelQuery().Execute();
var snapshot = new Snapshot
{
Id = modelEvent.id.Value,
Data = model.ToJson(),
EventRecord = eventRecord
};
context.Snapshots.Add(snapshot);
context.SaveChanges();
}
}
private static void PopulateDatabaseWithExampleValues()
{
using (var context = new PlanningPokerDbContext())
{
context.Database.ExecuteSqlCommand("DELETE FROM [EventRecord]");
context.Database.ExecuteSqlCommand("DELETE FROM [Snapshot]");
}
var events = ExampleEvents.Get();
foreach (var modelEvent in events)
{
new AddEventCommand(modelEvent).Handle();
}
}
public IEnumerable<ModelEvent> Execute()
{
using (var context = new PlanningPokerDbContext())
{
var events = context
.EventRecords
.OrderBy(r => r.Id)
.Select(r => new { r.Id, r.Data })
.ToArray()
.Select(r =>
{
var modelEvent = JsonConvert.DeserializeObject<ModelEvent>(r.Data);
modelEvent.id = r.Id;
return modelEvent;
})
.ToArray();
return events;
}
}