Example #1
0
        public List <UserTweetsVM> GetUserLikedTweets(int userID)
        {
            List <UserTweetsVM> lista = db.tsp_UserLikedTweets(userID).Select(x => new UserTweetsVM
            {
                userID       = (int)x.UserID,
                content      = x.Content,
                datetime     = (DateTime)x.TweetDate,
                likeCount    = (int)x.likeCount,
                nickname     = x.Nickname,
                profileImg   = x.ProfileImage,
                retweetCount = (int)x.retweetCount,
                imgTweet     = x.TweetImg,
                username     = x.Username,
                tweetID      = (int)x.TweetID
            }).ToList();

            foreach (var item in db.tsp_ReplyCount().ToList())
            {
                foreach (var tweet in lista)
                {
                    if (tweet.tweetID == item.TweetID)
                    {
                        tweet.replyCount = (int)item.ReplyCount;
                        break;
                    }
                }
            }
            return(lista);
        }