public static bool SaveTweet(TweetMessageViewModel tweetMsg)
        {
            bool IsSuccess = false;

            try
            {
                using (var _context = new TwitterCloneDBEntities())
                {
                    var tweets = _context.People.Where(x => x.user_id.Trim().ToUpper() == tweetMsg.userid.Trim().ToUpper()).FirstOrDefault();
                    var tweet  = tweets.TWEETs.Where(x => x.tweet_id == tweetMsg.TweetId).FirstOrDefault();//_context.TWEETs.Where(x => x.tweet_id == tweetMsg.TweetId).FirstOrDefault();
                    if (tweet == null && tweetMsg.TweetId == 0)
                    {
                        tweet         = new TWEET();
                        tweet.user_id = tweetMsg.userid;
                        tweet.message = tweetMsg.TweetMessage;
                        tweet.created = DateTime.Now;

                        _context.Entry(tweet).State = EntityState.Added;
                    }
                    else
                    {
                        tweet.message = tweetMsg.TweetMessage;
                    }
                    IsSuccess = true;

                    _context.SaveChanges();
                }
            }
            catch (Exception ex)
            {
            }

            return(IsSuccess);
        }
        public static TweetMessageViewModel EditTweet(int tweetId)
        {
            TweetMessageViewModel _editTweet = new TweetMessageViewModel();

            try
            {
                using (var _context = new TwitterCloneDBEntities())
                {
                    var tweet = _context.TWEETs.Where(x => x.tweet_id == tweetId).FirstOrDefault();//_context.TWEETs.Where(x => x.tweet_id == tweetMsg.TweetId).FirstOrDefault();
                    _editTweet.userid       = tweet.user_id;
                    _editTweet.TweetMessage = tweet.message;
                    _editTweet.TweetId      = tweet.tweet_id;
                    _editTweet.Created      = tweet.created;
                }
            }
            catch (Exception ex)
            {
            }

            return(_editTweet);
        }
 public bool SaveTweet(TweetMessageViewModel tweetMsg)
 {
     return(TwitterCloneDataAccess.SaveTweet(tweetMsg));
 }