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 Save() { using (PSBlogContext db = new PSBlogContext()) { db.SaveChanges(); } }
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 Add(T entity) { using (PSBlogContext db = new PSBlogContext()) { db.Set <T>().Add(entity); 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 void AddToUser(Blog entity, User user) { using (PSBlogContext db = new PSBlogContext()) { entity.UrlSlug = GenerateUniqueSlug <Blog>(entity.UrlSlug); entity.Owner = db.Users.Attach(user); db.Blogs.Add(entity); 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 AddPost(int blogId, Post post) { using (PSBlogContext db = new PSBlogContext()) { Blog blog = db.Blogs.First(b => b.Id == blogId); blog.Posts.Add(post); int rowsChanged = db.SaveChanges(); if (rowsChanged == 0) { //no rows are changed System.Diagnostics.Debugger.Break(); } } }
public void AddComment(string commentContent, string commentUserName, string blogSlug, string postSlug) { using (PSBlogContext db = new PSBlogContext()) { var selectedPost = db.Blogs .Include(b => b.Posts) .First(b => b.UrlSlug == blogSlug) .Posts .First(p => p.UrlSlug == postSlug); var selectedUser = db.Users.First(u => u.UserName == commentUserName); selectedPost.Comments.Add(new Comment { Content = commentContent, User = selectedUser }); 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(); } }