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