public override void Remove(int id) { using (PSBlogContext db = new PSBlogContext()) { var userBlog = db.Blogs.Include(b => b.Owner).FirstOrDefault(blog => blog.Owner.Id == id); if (userBlog != null) { db.Entry(userBlog).State = EntityState.Deleted; } var userComments = db.Comments.Where(c => c.User.Id == id); foreach (var userComment in userComments) { db.Entry(userComment).State = EntityState.Deleted; } var selectedUser = db.Users.Include(u => u.Roles).FirstOrDefault(user => user.Id == id); if (selectedUser != null) { db.Entry(selectedUser).State = EntityState.Deleted; } db.SaveChanges(); } }
public virtual void Edit(T entity) { using (PSBlogContext db = new PSBlogContext()) { db.Entry(entity).State = EntityState.Modified; db.SaveChanges(); } }
public virtual void Remove(int id) { using (PSBlogContext db = new PSBlogContext()) { T entity = db.Set <T>().First(el => el.Id == id); db.Entry(entity).State = EntityState.Deleted; db.SaveChanges(); } }
public override void Remove(int id) { using (PSBlogContext db = new PSBlogContext()) { Blog blog = db.Blogs.First(b => b.Id == id); blog.Posts.RemoveAll(p => true); db.Entry(blog).State = EntityState.Deleted; db.SaveChanges(); } }
public override void Edit(Post entity) { using (PSBlogContext db = new PSBlogContext()) { Post post = db.Posts.First(p => p.Id == entity.Id); post.Title = entity.Title; post.Content = entity.Content; db.Entry(post).State = EntityState.Modified; db.SaveChanges(); } }
public override void Remove(int id) { using (PSBlogContext db = new PSBlogContext()) { Post entity = db.Posts.Include(p => p.Tags) .Include(p => p.Comments).First(el => el.Id == id); entity.Tags.RemoveAll(p => true); entity.Comments.RemoveAll(c => true); db.Entry(entity).State = EntityState.Deleted; db.SaveChanges(); } }
public void TakeAwayAdminRole(User user) { using (PSBlogContext db = new PSBlogContext()) { var adminRole = user.Roles.First(r => r.Name == Settings.Default.SuperAdminRole); bool status = user.Roles.Remove(adminRole); //db.Roles.Remove(adminRole); //_db.Entry(user).State = EntityState.Modified; int count = db.SaveChanges(); //var adminRole = user.Roles.First(role => role.Name == Settings.Default.SuperAdminRole); db.Entry(adminRole).State = EntityState.Deleted; count = db.SaveChanges(); } }
public void GrantAdminRole(User user) { using (PSBlogContext db = new PSBlogContext()) { var adminRole = new Role { Name = Settings.Default.SuperAdminRole }; db.Roles.Add(adminRole); if (!user.Roles.Any(role => role.Name == Settings.Default.SuperAdminRole)) { user.Roles.Add(adminRole); } db.Entry(user).State = EntityState.Modified; int count = db.SaveChanges(); } }