public void Delete(Guid messageBoardId, Guid messageId)
{
using (var uow = _db.GetTransaction())
{
_db.Execute(@"DELETE FROM core.Likes WHERE MessageId = @0",
messageId.ToString());
_db.Execute(@"DELETE FROM core.MessageAttributions WHERE MessageId = @0",
messageId.ToString());
_db.Execute(@"DELETE FROM core.Messages WHERE messageBoardId = @0 AND Id = @1",
messageBoardId.ToString(), messageId.ToString());
uow.Complete();
}
}
public void Create(Models.Rsvp rsvp)
{
using (var uow = _db.GetTransaction())
{
_db.Insert(rsvp);
foreach (var response in rsvp.Responses)
{
_db.Insert(response);
}
_db.Execute(@"UPDATE core.Guests
SET HasSentRsvp = 1
WHERE Id IN (@0)",
rsvp.Responses.Select(x => x.GuestId));
uow.Complete();
}
}
public void Create(IEnumerable <T> events, Guid userId)
{
using (var uow = _db.GetTransaction())
{
foreach (var e in events)
{
_db.Insert(e);
_db.Execute(@"INSERT INTO core.UserEventMapping (Id, UserId, EventId) VALUES
(@0, @1, @2)"
, Guid.NewGuid().ToString()
, userId.ToString()
, e.Id);
}
uow.Complete();
}
}
