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)); }