public Blog GetBlogWithCategoryTagsAndCommentsWithReplies(int id)
        {
            var blog = _context.Blogs
                       .Where(blog => blog.Id == id)
                       .Include(blog => blog.Category)
                       .Include(blog => blog.BlogTags)
                       .ThenInclude(blogtag => blogtag.Tag)
                       .Include(blog => blog.Comments)
                       .ThenInclude(comment => comment.User)
                       .Include(blog => blog.Comments)
                       .ThenInclude(comment => comment.Replies)
                       .ThenInclude(reply => reply.User)
                       .FirstOrDefault();


            blog.Comments = blog.Comments.Where(comment => comment.Confirmation == true).ToList();
            foreach (var comment in blog.Comments)
            {
                comment.Replies = comment.Replies.Where(reply => reply.Confirmation == true).ToList();
            }
            return blog;
        }