Ejemplo n.º 1
0
        private void UpdatePost(string name, FullPost post)
        {
            string filename = Server.MapPath("~/Content/" + name + ".md");

            string[] lines = System.IO.File.ReadAllLines(filename);
            post.Name       = name;
            post.Title      = lines[0].Split(':')[1].Trim();
            post.PostDate   = DateTime.ParseExact(lines[2].Split(':')[1].Trim(), "yyyy-MM-dd", null);
            post.UpdateDate = DateTime.Today;
            post.Tags       = lines[1].Split(':')[1].Split(',').Select(t => t.Trim()).ToArray();

            StringBuilder excerpt           = new StringBuilder();
            StringBuilder content           = new StringBuilder();
            bool          isExcerptRecorded = false;

            for (int i = 3; i < lines.Length; i++)
            {
                string line = lines[i];
                if (line.Trim() == "<!-- more -->")
                {
                    isExcerptRecorded = true;
                }

                content.AppendLine(line);
                if (!isExcerptRecorded)
                {
                    excerpt.AppendLine(line);
                }
            }
            post.Excerpt = excerpt.ToString().Trim();
            post.Content = content.ToString().Trim();
        }
Ejemplo n.º 2
0
        public async Task <IHttpActionResult> CreatePost([FromBody] FullPost postToCreate)
        {
            var createdPostId = await _mediator.SendAsync(new InsertPostCommand(postToCreate.Hyperlink,
                                                                                postToCreate.Description, postToCreate.ImagePath, postToCreate.Tags, postToCreate.Groups));

            return(Ok(createdPostId));
        }
Ejemplo n.º 3
0
        public void Update(string name)
        {
            FullPost         post       = DbSession.Get <FullPost>(name);
            HashSet <string> storedTags = new HashSet <string>();

            if (post == null)
            {
                post = new FullPost();
            }
            else
            {
                storedTags.UnionWith(post.Tags);
            }
            UpdatePost(name, post);

            // 有以前的tag列表说明数据库里有这一篇,使用更新
            if (storedTags.Count > 0)
            {
                DbSession.Update(post);
            }
            else
            {
                DbSession.Save(post);
            }

            // 抽取tag的区别
            HashSet <string> currentTags = new HashSet <string>(post.Tags);

            UpdateTags(currentTags, storedTags);

            // 更新全文索引
            UpdateIndex(post);
        }
Ejemplo n.º 4
0
        //Query6:Получить следующую структуру (передать Id поста в параметры)
        //Пост
        //Самый длинный коммент поста
        //Самый залайканный коммент поста
        //Количество комментов под постом где или 0 лайков или длина текста< 80
        public static PostStruct Query6(int postId)
        {
            PostStruct postStruct = new PostStruct();

            try
            {
                var      data        = GetEntities();
                FullPost currentPost = data.SelectMany(u => u.Posts)
                                       .Where(u => u.Id == postId)
                                       .FirstOrDefault();
                postStruct.LongestComm = currentPost.Comments
                                         .OrderBy(c => c.Body.Length)
                                         .LastOrDefault();
                postStruct.LikestComm = currentPost.Comments
                                        .OrderBy(c => c.Likes)
                                        .LastOrDefault();
                postStruct.LowRatedCommsCount = currentPost.Comments
                                                .Where(p => p.Likes == 0 || p.Body.Length < 80).ToList().Count();
            }
            catch (Exception ex)
            {
                Console.Clear();
                Console.WriteLine(ex.Message);
                Console.ReadKey();
            }

            return(postStruct);
        }
Ejemplo n.º 5
0
        protected override async void OnAppearing()
        {
            base.OnAppearing();

            var store = new Data.Real.PostsStore();

            _post = await store.GetPost(_id);

            if (!string.IsNullOrEmpty(_post.github))
            {
                ToolbarItems.Add(_gitHubButton);
            }
            if (!string.IsNullOrEmpty(_post.youtube))
            {
                ToolbarItems.Add(_youTubeButton);
            }

            Title          = $"{_post.Date.ToLocalTime():dd/MM/yyyy}";
            PostTitle.Text = _post.Title;
            _page          = "http://thatcsharpguy.com" + _id + "/m.html";


            Site.Source      = _page;
            Site.Navigating += ContentNavigating;
        }
Ejemplo n.º 6
0
        public async Task <IHttpActionResult> UpdatePostById([FromBody] FullPost postToUpdate)
        {
            await _mediator.SendAsync(new UpdatePostByIdCommand(postToUpdate.PostId,
                                                                postToUpdate.Hyperlink, postToUpdate.Description, postToUpdate.ImagePath,
                                                                postToUpdate.Tags, postToUpdate.Groups));

            return(Ok());
        }
Ejemplo n.º 7
0
        public ActionResult FullPost(int postId)
        {
            FullPost fullPost = new FullPost()
            {
                Post    = postsRepository.Get.FirstOrDefault(p => p.PostId == postId),
                Comment = commentsRepository.Get.Where(p => p.PostId == postId),
            };

            fullPost.Post.Text    = fullPost.Post.Text.Replace("\r\n", "<br>");
            ViewBag.CountComments = fullPost.Comment.Count();
            return(View(fullPost));
        }
Ejemplo n.º 8
0
        private void UpdateIndex(FullPost post)
        {
            Field name    = new Field("Name", post.Name, Field.Store.YES, Field.Index.NOT_ANALYZED);
            Field title   = new Field("Title", post.Title, Field.Store.NO, Field.Index.ANALYZED);
            Field content = new Field("Content", post.Content, Field.Store.NO, Field.Index.ANALYZED);
            Field tags    = new Field("Tags", String.Join(" ", post.Tags), Field.Store.NO, Field.Index.ANALYZED);

            Document document = new Document();

            document.Add(name);
            document.Add(title);
            document.Add(content);
            document.Add(tags);

            Indexer.UpdateDocument(new Term("Name", post.Name), document);
            Indexer.Flush(true, true, true);
            Indexer.Optimize();
        }
Ejemplo n.º 9
0
 private void Show(FullPost fullPost)
 {
     if (fullPost != null)
     {
         Console.WriteLine(fullPost);
         if (fullPost.Comments != null && fullPost.Comments.Count() > 0)
         {
             Console.WriteLine("\tList of comments:");
             foreach (var item in fullPost.Comments)
             {
                 Console.WriteLine(item);
             }
         }
     }
     else
     {
         Console.WriteLine("Result: 0");
     }
 }
Ejemplo n.º 10
0
        //Query6:Получить следующую структуру (передать Id поста в параметры)
        //Пост
        //Самый длинный коммент поста
        //Самый залайканный коммент поста
        //Количество комментов под постом где или 0 лайков или длина текста< 80
        private PostStruct Query6(int postId)
        {
            PostStruct postStruct = new PostStruct();

            try
            {
                var      data        = getDataDelegate.Invoke();
                FullPost currentPost = data.SelectMany(u => u.Posts)
                                       .Where(u => u.Id == postId)
                                       .FirstOrDefault();
                postStruct.LongestComm = currentPost.Comments
                                         .OrderBy(c => c.Body.Length)
                                         .LastOrDefault();
                postStruct.LikestComm = currentPost.Comments
                                        .OrderBy(c => c.Likes)
                                        .LastOrDefault();
                List <Comment> subresult = currentPost.Comments
                                           .Where(p => p.Likes == 0 || p.Body.Length < 80).ToList();

                Console.WriteLine($"Current: {currentPost} \nAll comments: ");

                foreach (var item in currentPost.Comments)
                {
                    Console.WriteLine(item);
                }
                Console.WriteLine("\nSelected comments");
                foreach (var item in subresult)
                {
                    Console.WriteLine(item);
                }
                postStruct.LowRatedCommsCount = subresult.Count();
            }
            catch (Exception ex)
            {
                Console.Clear();
                Console.WriteLine(ex.Message);
                Console.ReadKey();
            }

            return(postStruct);
        }
Ejemplo n.º 11
0
        public static FullPostModel Map(FullPost post, IUrlHelper URL)
        {
            FullPostModel fpm = new FullPostModel();

            QuestionModel qm = new QuestionModel
            {
                comments     = Map(post.comments.Where(c => c.parentid == post.question.postid).ToList(), URL),
                body         = post.question.body,
                creationdate = post.question.creationdate,
                score        = post.question.score,
                title        = post.question.title,
                username     = post.question.username,
                userurl      = URL.Link(Config.UserRoute, new { id = post.question.userid })
            };
            List <AnswerModel> ams = new List <AnswerModel>();

            foreach (var answer in post.answers)
            {
                Console.WriteLine(answer.id);
                ams.Add(new AnswerModel
                {
                    comments     = Map(post.comments.Where(c => c.parentid == answer.postid).ToList(), URL),
                    body         = answer.body,
                    creationdate = answer.creationdate,
                    score        = answer.score,
                    username     = answer.username,
                    userurl      = URL.Link(Config.UserRoute, new { id = answer.userid })
                });
            }

            fpm = new FullPostModel
            {
                questionmodel = qm,
                answermodels  = ams,
                tags          = post.tags,
                url           = URL.Link(Config.PostRoute, new { id = post.question.postid })
            };
            return(fpm);
        }
Ejemplo n.º 12
0
        public int CreatePost(FullPost post)
        {
            using (MooDB db = new MooDB())
            {
                Problem problem;
                if (post.Problem == null)
                {
                    problem = null;
                }
                else
                {
                    problem = (from p in db.Problems
                               where p.ID == post.Problem
                               select p).SingleOrDefault<Problem>();
                    if (problem == null) throw new ArgumentException("无此题目");
                }

                Post newPost = new Post()
                {
                    Name = post.Name,
                    OnTop = false,
                    Problem = problem,
                    Locked = false,
                    ReplyTime = DateTime.Now
                };

                Access.Required(db, newPost, Function.CreatePost);

                db.Posts.AddObject(newPost);
                db.SaveChanges();
                return newPost.ID;
            }
        }
Ejemplo n.º 13
0
        public void ModifyPost(string id, FullPost post)
        {
            int iid = int.Parse(id);
            using (MooDB db = new MooDB())
            {
                Post thePost = (from p in db.Posts
                                where p.ID == iid
                                select p).SingleOrDefault<Post>();
                if (thePost == null) throw new ArgumentException("无此帖子");

                Access.Required(db, thePost, Function.ModifyPost);

                if (post.Name != null)
                {
                    thePost.Name = post.Name;
                }
                if (post.OnTop != null)
                {
                    thePost.OnTop = (bool)post.OnTop;
                }
                if (post.Locked != null)
                {
                    thePost.Locked = (bool)post.Locked;
                }

                db.SaveChanges();
            }
        }
Ejemplo n.º 14
0
        //public IList<User> GetUsers(Func<User, bool> predicate, int page, int pagesize)
        //{
        //    using (var db = new DatabaseContext())
        //    {
        //        return db.users.Where(predicate).ToList();
        //    }
        //}

        public FullPost GetPost(int id)
        {
            FullPost result = new FullPost();

            using (var db = new DatabaseContext())
            {
                var conn = (MySqlConnection)db.Database.GetDbConnection();
                conn.Open();

                var cmd = new MySqlCommand("call getfullpost(@1)", conn);
                cmd.Parameters.Add("@1", DbType.Int32).Value = id;
                using (var rdr = cmd.ExecuteReader())
                {
                    if (!rdr.Read())
                    {
                        return(null);
                    }
                    //question
                    Question question = new Question
                    {
                        id = rdr.GetInt32(rdr.GetOrdinal("id")),
                        acceptedanswerid = rdr.IsDBNull(rdr.GetOrdinal("acceptedanswerid"))?
                                           -1 : rdr.GetInt32(rdr.GetOrdinal("acceptedanswerid")),
                        body         = rdr.GetString(rdr.GetOrdinal("body")),
                        title        = rdr.GetString(rdr.GetOrdinal("title")),
                        score        = rdr.GetInt32(rdr.GetOrdinal("score")),
                        creationdate = rdr.GetDateTime(rdr.GetOrdinal("creationdate")),
                        postid       = rdr.GetInt32(rdr.GetOrdinal("postid")),
                        userid       = rdr.GetInt32(rdr.GetOrdinal("ownerid")),
                        username     = rdr.GetString(rdr.GetOrdinal("displayname"))
                    };



                    //tags
                    rdr.NextResult();
                    var tags = new List <string>();
                    while (rdr.Read())
                    {
                        tags.Add(rdr.GetString(rdr.GetOrdinal("tag")));
                    }

                    //answers
                    rdr.NextResult();
                    var answers = new List <Answer>();
                    while (rdr.Read())
                    {
                        answers.Add(new Answer
                        {
                            id           = rdr.GetInt32(rdr.GetOrdinal("id")),
                            body         = rdr.GetString(rdr.GetOrdinal("body")),
                            score        = rdr.GetInt32(rdr.GetOrdinal("score")),
                            creationdate = rdr.GetDateTime(rdr.GetOrdinal("creationdate")),
                            postid       = rdr.GetInt32(rdr.GetOrdinal("postid")),
                            userid       = rdr.GetInt32(rdr.GetOrdinal("ownerid")),
                            parentid     = rdr.GetInt32(rdr.GetOrdinal("parentid")),
                            username     = rdr.GetString(rdr.GetOrdinal("displayname"))
                        });
                    }

                    //comments
                    rdr.NextResult();
                    var comments = new List <Comment>();
                    while (rdr.Read())
                    {
                        comments.Add(new Comment
                        {
                            id           = rdr.GetInt32(rdr.GetOrdinal("id")),
                            body         = rdr.GetString(rdr.GetOrdinal("body")),
                            score        = rdr.GetInt32(rdr.GetOrdinal("score")),
                            creationdate = rdr.GetDateTime(rdr.GetOrdinal("creationdate")),
                            postid       = rdr.GetInt32(rdr.GetOrdinal("postid")),
                            userid       = rdr.GetInt32(rdr.GetOrdinal("ownerid")),
                            parentid     = rdr.GetInt32(rdr.GetOrdinal("parentid")),
                            username     = rdr.GetString(rdr.GetOrdinal("displayname")),
                        });
                    }

                    result = new FullPost
                    {
                        question = question,
                        tags     = tags,
                        answers  = answers,
                        comments = comments
                    };
                }

                return(result);
            }
        }
Ejemplo n.º 15
0
        //Query5:Получить следующую структуру (передать Id пользователя в параметры)
        //		User
        //		Последний пост пользователя(по дате)
        //		Количество комментов под последним постом
        //		Количество невыполненных тасков для пользователя
        //		Самый популярный пост пользователя(там где больше всего комментов с длиной текста больше 80 символов)
        //		Самый популярный пост пользователя(там где больше всего лайков)
        private UserStruct Query5(int userId)
        {
            UserStruct user = new UserStruct();

            try
            {
                var             data  = getDataDelegate.Invoke();
                SomeEntity      usr   = data.Where(u => u.Id == userId).FirstOrDefault();
                List <FullPost> posts = usr.Posts.ToList();

                if (posts != null && posts.Count() > 0)
                {
                    FullPost lastPost = posts.OrderByDescending(p => p.CreatedAt).First();
                    if (lastPost != null)
                    {
                        user.LastPost = lastPost;

                        if (lastPost.Comments != null)
                        {
                            user.LastPostCommentsCount = lastPost.Comments.Count();
                        }
                    }

                    List <FullPost> subresult = posts.OrderByDescending(p => p.Comments.Count())
                                                .Where(c => c.Comments.Where(e => e.Body.Length > 80).Count() > 0)
                                                .ToList();

                    if (subresult != null && subresult.Count() > 0)
                    {
                        user.MostPopularByComms = subresult.GroupJoin(subresult.SelectMany(c => c.Comments),
                                                                      p => p.Id,
                                                                      c => c.PostId,
                                                                      (p, cl) => new
                        {
                            PostItem    = p,
                            CommsCounts = cl.Select(a => a.Body)
                                          .Where(b => b.Length > 80)
                                          .Count()
                        }
                                                                      ).OrderBy(v => v.CommsCounts)
                                                  .Last().PostItem;
                    }



                    user.MostPopularByLikes = posts.OrderByDescending(p => p.Likes).First();
                }
                if (usr.Todos != null)
                {
                    user.UnCompletedTasksCount = usr.Todos.Where(t => t.IsComplete == false).Count();
                }
            }
            catch (Exception ex)
            {
                Console.Clear();
                Console.WriteLine(ex.Message);
                Console.ReadKey();
            }

            return(user);
        }