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 List <TweetMessageViewModel> GetTweets(string userName) { List <TweetMessageViewModel> lsttmv = new List <TweetMessageViewModel>(); try { using (var _context = new TwitterCloneDBEntities()) { var users = _context.People.Where(x => x.user_id.Trim().ToUpper() == userName.ToUpper().Trim()); var tweets = _context.TWEETs.Where(x => x.user_id.Trim().ToUpper() == userName.ToUpper().Trim()); lsttmv = tweets.Select(t => new TweetMessageViewModel { TweetId = t.tweet_id, TweetMessage = t.message, userid = t.user_id, Created = t.created, isUserTweet = t.user_id.Trim().ToUpper() == userName.ToUpper().Trim() ? true : false }).ToList(); } } catch (Exception ex) { } return(lsttmv); }
public static Tweetdetails GetTweetMessageDetails(string userName) { Tweetdetails tmv = new Tweetdetails(); try { using (var _context = new TwitterCloneDBEntities()) { var tweets = _context.TWEETs.Where(x => x.user_id.Trim().ToUpper() == userName.ToUpper().Trim()); var follows = _context.People.Where(x => x.user_id.Trim().ToUpper() == userName.ToUpper().Trim()).FirstOrDefault(); if (tweets != null) { tmv.TotalTweets = tweets.Count(); } if (follows != null) { tmv.TotalFollowers = follows.People.Count(); tmv.TotalFollowing = follows.Person1.Count(); } } } catch (Exception ex) { } return(tmv); }
public static List <string> GetUserList(string UserName) { List <string> lstUser = new List <string>(); using (var _context = new TwitterCloneDBEntities()) { lstUser = _context.People.Select(x => x.user_id).ToList();//.Where(x => x.user_id.Trim().Contains(UserName)) } return(lstUser != null ? lstUser : new List <string>()); }
public static bool UserAlreadyExists(string userId) { bool isUserExist = false; using (var _context = new TwitterCloneDBEntities()) { var items = _context.People.Where(x => x.user_id.Trim() == userId.Trim()).FirstOrDefault(); isUserExist = (items == null) ? true : false; } return(isUserExist); }
public static bool UserLogin(LoginModel login) { bool isUserExist = false; using (var _context = new TwitterCloneDBEntities()) { var items = _context.People.Where(x => x.user_id == login.UserName && x.password == login.PassWord).FirstOrDefault(); isUserExist = (items != null && items.user_id != null) ? true : false; } return(isUserExist); }
public static SignUpViewModel GetProfile(string userId) { SignUpViewModel pr = new SignUpViewModel(); using (var _context = new TwitterCloneDBEntities()) { var items = _context.People.Where(x => x.user_id.Trim() == userId.Trim()).FirstOrDefault(); if (items != null && items.user_id != null) { pr.UserName = items.user_id; pr.Email = items.email; pr.FullName = items.fullName; pr.Password = items.password; } } return(pr); }
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 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); }