public List <Post> GetAllPosts(int blogId)
{
using (PSBlogContext db = new PSBlogContext())
{
return(db.Blogs.Include(b => b.Posts).First(b => b.Id == blogId).Posts.ToList());
}
}
public void Save()
{
using (PSBlogContext db = new PSBlogContext())
{
db.SaveChanges();
}
}
public virtual IList <T> FetchAll()
{
using (PSBlogContext db = new PSBlogContext())
{
return(db.Set <T>().ToList());
}
}
public virtual T FindById(int id)
{
using (PSBlogContext db = new PSBlogContext())
{
return(db.Set <T>().First(el => el.Id == id));
}
}
public bool IsUserHaveBlog(string userName)
{
using (PSBlogContext db = new PSBlogContext())
{
return(db.Blogs.Any(blog => blog.Owner.UserName == userName));
}
}
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 bool IsUserNameTaken(string username)
{
using (PSBlogContext db = new PSBlogContext())
{
return(db.Users.Any() && db.Users.ToList().Any(x => x.UserName == username));
}
}
public override User FindById(int id)
{
using (PSBlogContext db = new PSBlogContext())
{
return(db.Users.Include(u => u.Roles).First(user => user.Id == id));
}
}
public User FindByUserName(string username)
{
using (PSBlogContext db = new PSBlogContext())
{
return(db.Users.Include(u => u.Roles).FirstOrDefault(user => user.UserName == username));
}
}
public override IList <User> FetchAll()
{
using (PSBlogContext db = new PSBlogContext())
{
return(db.Users.Include(u => u.Roles).ToList());
}
}
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 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 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 Blog GetBlogBySlugUrl(string slugUrl)
{
using (PSBlogContext db = new PSBlogContext())
{
return(db.Blogs
.Include(x => x.Posts)
.Include(x => x.Posts.Select(p => p.Tags))
.Include(x => x.Owner)
.Single(b => b.UrlSlug == slugUrl));
}
}
public Blog GetUserBlog(string userName)
{
using (PSBlogContext db = new PSBlogContext())
{
return(db.Blogs
.Include(b => b.Posts)
.Include(b => b.Posts.Select(p => p.Tags))
.Include(b => b.Owner)
.FirstOrDefault(blog => blog.Owner.UserName == userName));
}
}
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();
}
}
protected string GenerateUniqueSlug <T>(string urlSlug) where T : class, IUrlSlug
{
using (PSBlogContext db = new PSBlogContext())
{
bool unique = !db.Set <T>().Any(x => x.UrlSlug == urlSlug);
if (!unique)
{
return(GenerateUniqueSlug <T>(urlSlug, 1));
}
return(urlSlug);
}
}
private string GenerateUniqueSlug <T>(string urlSlug, int numberTries) where T : class, IUrlSlug
{
using (PSBlogContext db = new PSBlogContext())
{
string newSlug = urlSlug + numberTries;
bool unique = !db.Set <T>().Any(x => x.UrlSlug == newSlug);
if (!unique)
{
newSlug = GenerateUniqueSlug <T>(newSlug, ++numberTries);
}
return(newSlug);
}
}
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 IEnumerable <string> GetRolesForUser(string username)
{
using (PSBlogContext db = new PSBlogContext())
{
var selectedUser = db.Users.Include(u => u.Roles).FirstOrDefault(user => user.UserName == username);
if (selectedUser == null)
{
return(null);
}
var roles = selectedUser.Roles.Select(role => role.Name);
var onemoretime = FindById(selectedUser.Id);
return(roles);
}
}
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 PostDetailsModel GetPostDetails(string blogSlug, string postSlug)
{
using (PSBlogContext db = new PSBlogContext())
{
Blog selectedBlog = db.Blogs
.Include(b => b.Posts)
.Include(b => b.Posts.Select(p => p.Comments))
.Include(b => b.Posts.Select(p => p.Comments.Select(c => c.User)))
.First(b => b.UrlSlug == blogSlug);
Post selectedPost = selectedBlog.Posts.First(p => p.UrlSlug == postSlug);
return(new PostDetailsModel {
Blog = selectedBlog, Post = selectedPost
});
}
}
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();
}
}
