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