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