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 bool RegisterUser(SignUpViewModel userInfo) { bool isRegistered = false; try { using (var _context = new TwitterCloneDBEntities()) { var items = _context.People.Where(x => x.user_id.ToUpper().Trim() == userInfo.UserName.ToUpper().Trim()).FirstOrDefault(); if (items == null) { Person user = new Person(); user.user_id = userInfo.UserName; user.password = userInfo.Password; user.fullName = userInfo.FullName; user.email = userInfo.Email; user.joined = DateTime.Now; user.active = true; _context.People.Add(user); } else { items.password = userInfo.Password; items.fullName = userInfo.FullName; } _context.SaveChanges(); isRegistered = true; } } catch (Exception ex) { isRegistered = false; } return(isRegistered); }
public static string DeleteTweet(int tweetId) { string strUserName = string.Empty; 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(); if (tweet != null && tweetId != 0) { strUserName = tweet.user_id; _context.TWEETs.Remove(tweet); //_context.Entry(tweet).State = EntityState.Deleted; } _context.SaveChanges(); } } catch (Exception ex) { } return(strUserName); }