public List <TweetMessage> GetAllTweets(string userName) { List <TweetMessage> lstTweetMessage = new List <TweetMessage>(); try { using (_dbContext = new TwitterCloneEntities()) { var tweets = _dbContext.Tweets.ToList();// .Where(x => x.User_Id.Trim().ToUpper() == userName.ToUpper().Trim()); lstTweetMessage = tweets.Select(t => new TweetMessage { Tweet_Id = t.Tweet_Id, Message = t.Message, User_Id = t.User_Id, Created = t.Created ?? DateTime.Now, IsUserTweet = t.User_Id.Trim().ToUpper() == userName.ToUpper().Trim() ? true : false }).ToList(); } } catch (Exception ex) { } return(lstTweetMessage); }
/// <summary> /// Retrieves a lit of tweets based on user id /// </summary> /// <param name="userId"></param> /// <returns></returns> private List <Tweet> GetTweets(int userId) { using (TwitterCloneEntities db = new TwitterCloneEntities()) { return(db.Tweets.Where(x => x.UserId == userId).OrderBy(x => x.TweetTime).ToList()); } }
public bool SaveTweet(TweetMessage tweetMsg) { bool IsSuccess = false; try { using (_dbContext = new TwitterCloneEntities()) { var tweets = _dbContext.People.Where(x => x.User_Id.Trim().ToUpper() == tweetMsg.User_Id.Trim().ToUpper()).FirstOrDefault(); var tweet = _dbContext.Tweets.Where(x => x.Tweet_Id == tweetMsg.Tweet_Id).FirstOrDefault(); if (tweet == null && tweetMsg.Tweet_Id == 0) { tweet = new Tweet(); tweet.User_Id = tweetMsg.User_Id; tweet.Message = tweetMsg.Message; tweet.Created = DateTime.Now; _dbContext.Entry(tweet).State = System.Data.Entity.EntityState.Added; } else { tweet.Message = tweetMsg.Message; } IsSuccess = true; _dbContext.SaveChanges(); } } catch (Exception ex) { } return(IsSuccess); }
public TweetModel GetTweetMessageDetails(string userName) { TweetModel tweetModel = new TweetModel(); try { using (_dbContext = new TwitterCloneEntities()) { var tweets = _dbContext.Tweets.Where(x => x.User_Id.Trim().ToUpper() == userName.ToUpper().Trim()); var following = _dbContext.Followings.Where(x => x.User_Id.Trim().ToUpper() == userName.ToUpper().Trim()); var followers = _dbContext.Followings.Where(x => x.Following_id.Trim().ToUpper() == userName.ToUpper().Trim()); if (tweets != null) { tweetModel.TotalTweets = tweets.Count(); } if (followers != null) { tweetModel.TotalFollowers = followers.Count(); } if (following != null) { tweetModel.TotalFollowing = following.Count(); } } } catch (Exception ex) { } return(tweetModel); }
public List <Tweet> GetTweets(string userId) { List <Tweet> tweets = new List <Tweet>(); List <Tweet> FollowingTweets = new List <Tweet>(); List <Following> followings = new List <Following>(); using (TwitterCloneEntities db = new TwitterCloneEntities()) { tweets = (from t in db.Tweets where t.UserId == userId select t ).OrderBy(x => x.CreatedDate).ToList(); followings = (from f in db.Followings where f.UserId == userId select f ).ToList(); foreach (var item in followings) { FollowingTweets = (from t in db.Tweets where t.UserId == item.FollowingId select t ).OrderBy(x => x.CreatedDate).ToList(); foreach (var tweet in FollowingTweets) { tweets.Add(tweet); } } } return(tweets); }
public void AddUser(Person item) { using (TwitterCloneEntities db = new TwitterCloneEntities()) { db.People.Add(item); db.SaveChanges(); } }
public Person ValidateUser(string name, string pw) { using (TwitterCloneEntities db = new TwitterCloneEntities()) { Person people = db.People.FirstOrDefault(i => i.UserId == name && i.Password == pw && i.Active == true); return(people); } }
public Person Validate(string uname, string pwd) { using (TwitterCloneEntities db = new TwitterCloneEntities()) { Person obj = db.People.FirstOrDefault(i => i.UserId == uname && i.Password == pwd && i.Active == true); return(obj); } }
public Person SearchUser(string uname) { using (TwitterCloneEntities db = new TwitterCloneEntities()) { Person obj = db.People.FirstOrDefault(i => i.UserId.Contains(uname)); return(obj); } }
public void DeleteTweet(int tweetId) { using (TwitterCloneEntities db = new TwitterCloneEntities()) { Tweet twt; twt = GetTweetById(tweetId); db.Entry(twt).State = EntityState.Deleted; db.SaveChanges(); } }
public Tweet GetTweetById(int Id) { Tweet twt = new Tweet(); using (TwitterCloneEntities db = new TwitterCloneEntities()) { twt = (from a in db.Tweets where a.TweetId == Id select a).SingleOrDefault(); } return(twt); }
public List <string> GetUserList() { List <string> lstUser = new List <string>(); using (_dbContext = new TwitterCloneEntities()) { lstUser = _dbContext.People.Select(x => x.User_Id).ToList(); } return(lstUser != null ? lstUser : new List <string>()); }
public bool UserAlreadyExists(string userId) { bool isUserExist = false; using (_dbContext = new TwitterCloneEntities()) { var items = _dbContext.People.Where(x => x.User_Id.ToLower().Trim() == userId.ToLower().Trim()).FirstOrDefault(); isUserExist = (items == null) ? false : true; } return(isUserExist); }
public ActionResult AddTweet(string tweetText) { using (TwitterCloneEntities db = new TwitterCloneEntities()) { var tweet = new Tweet(); tweet.TweetText = tweetText; tweet.TweetTime = DateTime.Now; tweet.UserId = (int)Session["Id"]; db.Tweets.Add(tweet); db.SaveChanges(); } return(RedirectToAction("Index", "Dashboard")); }
public List <Tweet> GetTweets(string userId) { List <Tweet> tweets = new List <Tweet>(); using (TwitterCloneEntities db = new TwitterCloneEntities()) { tweets = (from t in db.Tweets where t.UserId == userId select t ).OrderBy(x => x.CreatedDate).ToList(); } return(tweets); }
public int GetUserTweetCount(string id) { int count = 0; List <Tweet> twt = new List <Tweet>(); using (TwitterCloneEntities db = new TwitterCloneEntities()) { twt = (from a in db.Tweets where a.UserId == id select a).OrderBy(x => x.CreatedDate).ToList(); if (twt != null && twt.Count > 0) { count = twt.Count; } } return(count); }
public int GetUserFollowingCount(string userId) { int count = 0; List <Following> userFollowing = new List <Following>(); using (TwitterCloneEntities db = new TwitterCloneEntities()) { userFollowing = (from a in db.Followings where a.UserId == userId select a).ToList(); if (userFollowing != null && userFollowing.Count > 0) { count = userFollowing.Count; } } return(count); }
public void SaveTweet(Tweet tweet) { using (TwitterCloneEntities db = new TwitterCloneEntities()) { if (tweet.TweetId == 0) { db.Tweets.Add(tweet); } else { Tweet t; t = GetTweetById(tweet.TweetId); } db.SaveChanges(); } }
public void UpdateUser(Person person) { using (TwitterCloneEntities db = new TwitterCloneEntities()) { if (!string.IsNullOrWhiteSpace(person.UserId)) { Person p; p = SearchUser(person.UserId); p.Active = person.Active; p.Email = person.Email; p.FullName = person.FullName; p.Password = person.Password; db.People.Attach(p); db.Entry(p).State = EntityState.Modified; } db.SaveChanges(); } }
public bool RegisterOrUpdateUser(PersonModel personModel) { bool isRegistered = false; try { using (_dbContext = new TwitterCloneEntities()) { Person person = _dbContext.People.Where(x => x.User_Id.ToUpper().Trim() == personModel.User_Id.ToUpper().Trim()).FirstOrDefault(); if (person == null) { Person user = new Person(); user.User_Id = personModel.User_Id; user.Passowrd = personModel.Password; user.FullName = personModel.FullName; user.Email = personModel.Email; user.Joined = DateTime.Now; user.Active = true; _dbContext.People.Add(user); } else { if (string.IsNullOrEmpty(personModel.Password.Trim())) { person.Passowrd = personModel.Password; } person.FullName = personModel.FullName; person.Email = personModel.Email; _dbContext.Entry <Person>(person).State = System.Data.Entity.EntityState.Modified; } _dbContext.SaveChanges(); isRegistered = true; } } catch (Exception ex) { isRegistered = false; } return(isRegistered); }
public int GetUserFollowersCount(string userId) { int result = 0; List <Following> followings = new List <Following>(); using (TwitterCloneEntities db = new TwitterCloneEntities()) { followings = (from f in db.Followings where f.FollowingId == userId select f ).ToList(); if (followings != null && followings.Count > 0) { result = followings.Count; } } return(result); }
public void SaveTweet(Tweet tweet) { using (TwitterCloneEntities db = new TwitterCloneEntities()) { if (tweet.TweetId == 0) { db.Tweets.Add(tweet); } else { Tweet twt; twt = GetTweetById(tweet.TweetId); twt.Message = tweet.Message; db.Tweets.Attach(twt); db.Entry(twt).State = EntityState.Modified; } db.SaveChanges(); } }
public int GetUserTweetCount(string userId) { int result = 0; List <Tweet> tweets = new List <Tweet>(); using (TwitterCloneEntities db = new TwitterCloneEntities()) { tweets = (from t in db.Tweets where t.UserId == userId select t ).OrderBy(x => x.CreatedDate).ToList(); if (tweets != null && tweets.Count > 0) { result = tweets.Count; } } return(result); }
public PersonModel GetProfile(string userId) { PersonModel prModel = new PersonModel(); using (_dbContext = new TwitterCloneEntities()) { var items = _dbContext.People.Where(x => x.User_Id.Trim() == userId.Trim()).FirstOrDefault(); if (items != null) { prModel.User_Id = items.User_Id; prModel.Password = items.Passowrd; prModel.FullName = items.FullName; prModel.Email = items.Email; prModel.Joined = items.Joined; prModel.Active = items.Active; } } return(prModel); }
public ActionResult Authorize(User userModel) { if (string.IsNullOrWhiteSpace(userModel.UserName) || string.IsNullOrWhiteSpace(userModel.Password)) { return(View("Index", userModel)); } using (TwitterCloneEntities db = new TwitterCloneEntities()) { var userDetails = db.Users.Where(x => x.UserName == userModel.UserName && x.Password == userModel.Password).FirstOrDefault(); if (userDetails == null) { return(View("Index", userModel)); } Session["Id"] = userDetails.UserId; Session["UserName"] = userDetails.UserName; Session["FullName"] = string.Format($"{userDetails.FirstName} {userDetails.LastName}"); return(RedirectToAction("Index", "Dashboard")); } }
public string DeleteTweet(int tweetId) { string strUserName = string.Empty; try { using (_dbContext = new TwitterCloneEntities()) { var tweet = _dbContext.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; _dbContext.Tweets.Remove(tweet); } _dbContext.SaveChanges(); } } catch (Exception ex) { } return(strUserName); }
public List <Tweet> GetTweets(string userId) { List <Tweet> userTweet = new List <Tweet>(); List <Following> userFollower = new List <Following>(); List <Tweet> userFollowedTweet = new List <Tweet>(); using (TwitterCloneEntities db = new TwitterCloneEntities()) { userTweet = (from a in db.Tweets where a.UserId == userId select a).OrderBy(b => b.CreatedDate).ToList(); userFollower = (from a in db.Followings where a.UserId == userId select a).ToList(); foreach (var item in userFollower) { userFollowedTweet = (from a in db.Tweets where a.UserId == item.FollowingId select a).OrderBy(b => b.CreatedDate).ToList(); foreach (var tweet in userFollowedTweet) { userTweet.Add(tweet); } } } return(userTweet); }
public TweetMessage EditTweet(int tweetId) { TweetMessage _editTweet = new TweetMessage(); try { using (_dbContext = new TwitterCloneEntities()) { var tweet = _dbContext.Tweets.Where(x => x.Tweet_Id == tweetId).FirstOrDefault();//_context.TWEETs.Where(x => x.tweet_id == tweetMsg.TweetId).FirstOrDefault(); _editTweet.User_Id = tweet.User_Id; _editTweet.Message = tweet.Message; _editTweet.Tweet_Id = tweet.Tweet_Id; _editTweet.Created = DateTime.Now; _dbContext.Entry(_editTweet).State = System.Data.Entity.EntityState.Modified; _dbContext.SaveChanges(); } } catch (Exception ex) { } return(_editTweet); }
public AppRepository() { _dbContext = new TwitterCloneEntities(); }