public bool EditEvent(Event evt, List <Invitation> invitations) { using (BookReadingContext context = new BookReadingContext()) { var result = (from i in context.Invitations where i.EventId == evt.EventId select i); context.Invitations.RemoveRange(result.ToList()); foreach (var item in invitations) { item.EventId = evt.EventId; context.Invitations.Add(item); } context.SaveChanges(); context.Entry(evt).State = EntityState.Modified; context.SaveChanges(); return(true); } }
public void AddUser(User user) { using (BookReadingContext context = new BookReadingContext()) { context.Users.Add(user); context.SaveChanges(); Role role = new Role(); role.User = user; role.AssignedRole = "User"; context.Roles.Add(role); context.SaveChanges(); } }
public void CreateEvent(Event evt, List <Invitation> invitations) { using (BookReadingContext context = new BookReadingContext()) { context.Events.Add(evt); context.SaveChanges(); int id = evt.EventId; foreach (var item in invitations) { item.EventId = id; context.Invitations.Add(item); } context.SaveChanges(); } }
public void AddComments(Comment comment) { using (BookReadingContext context = new BookReadingContext()) { context.Comments.Add(comment); context.SaveChanges(); } }
public void DeleteEvent(int eventId) { using (BookReadingContext context = new BookReadingContext()) { var result = (from e in context.Events where e.EventId == eventId select e).ToList().First(); context.Events.Remove(result); context.SaveChanges(); } }