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