public Models.Event GetEventDetails(Guid eventId) { Models.Event eventDetails; using (var uow = _db.GetTransaction()) { eventDetails = _db.FirstOrDefault <Models.Event>("WHERE Id = @0", eventId); uow.Complete(); } return(eventDetails); }
public IEnumerable <Models.MessageBoard> GetMessageBoards(Guid eventId) { IEnumerable <Models.MessageBoard> resultSet; using (var uow = _db.GetTransaction()) { resultSet = _db.Query <Models.MessageBoard>("WHERE EventId = @0", eventId); uow.Complete(); } return(resultSet); }
public IEnumerable <Models.Rsvp> GetAll() { IEnumerable <Models.Rsvp> result; using (var uow = _db.GetTransaction()) { result = _db.Query <Models.Rsvp>(""); uow.Complete(); } return(result); }
public virtual void Create(IEnumerable <T> entity) { using (var uow = _db.GetTransaction()) { foreach (var e in entity) { _db.Insert(e); } uow.Complete(); } }
public Invite GetInviteFromSecurityCode(string securityCode) { Invite invite; using (var uow = _db.GetTransaction()) { invite = _db.FirstOrDefault <Invite>("WHERE SecurityCode = @0", securityCode); uow.Complete(); } return(invite); }
public void Create(Message message) { using (var uow = _db.GetTransaction()) { _db.Insert(message); foreach (var sig in message.Attributions) { _db.Insert(new MessageAttribution(message.Id, sig.Id)); } uow.Complete(); } }
private IEnumerable <Guid> GetUserEventIds(Guid userId) { IEnumerable <Guid> result; using (var uow = _db.GetTransaction()) { result = _db.Query <Guid>( @"SELECT e.EventId FROM core.UserEventMapping AS e INNER JOIN core.Users AS u ON e.UserId = e.EventId WHERE u.UserId = @0", userId); uow.Complete(); } return(result); }
public void UpdateFailedLoginAttempts <T>(Guid Id) { using (var uow = _db.GetTransaction()) { _db.Update <T>("SET LoginAttempts = LoginAttempts + 1" + "WHERE Id = @0", Id); uow.Complete(); } }
public IEnumerable <Guid> GetEventIdsUserHasAccessTo(Guid userId) { IEnumerable <Guid> eventIds = new List <Guid>(); using (var uow = _db.GetTransaction()) { eventIds = _db.Query <Guid>(@"SELECT EventId FROM core.UserEventMapping WHERE UserId = @0", userId); uow.Complete(); } return(eventIds); }
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(); } }