示例#1
0
        public UserTweetsVM GetTweet(int tweetID)
        {
            UserTweetsVM obj = db.tsp_GetTweet(tweetID).Select(x => new UserTweetsVM
            {
                content             = x.Content,
                datetime            = (DateTime)x.TweetDate,
                likeCount           = (int)x.likeCount,
                nickname            = x.Nickname,
                parentTweetUsername = x.ParentTweetUsername,
                profileImg          = x.ProfileImage,
                retweetCount        = (int)x.retweetCount,
                tweetID             = (int)x.TweetID,
                userID   = (int)x.UserID,
                imgTweet = x.TweetImg,
                username = x.Username
            }).SingleOrDefault();

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