public void Signup(PERSON pObj) { TwitterDBContext twitterDBContext = new TwitterDBContext(); twitterDBContext.People.Add(pObj); twitterDBContext.SaveChanges(); }
public PERSON SearchUser(string id) { TwitterDBContext twitterDBContext = new TwitterDBContext(); var result = twitterDBContext.People.Where(m => m.user_id == id && m.active == true).First(); return(result); }
public void FollowUser(FOLLOWING following) { TwitterDBContext twitterDBContext = new TwitterDBContext(); twitterDBContext.FOLLOWINGs.Add(following); twitterDBContext.SaveChanges(); }
public int Login(Person pObj) { TwitterDBContext twitterDBContext = new TwitterDBContext(); var result = twitterDBContext.People.Where(m => m.user_id == pObj.user_id && m.password == pObj.password && m.active == true).Count(); return(result); }
public void DeactivateAccount(string id) { TwitterDBContext twitterDBContext = new TwitterDBContext(); var result = twitterDBContext.People.Where(m => m.user_id == id).First(); result.active = false; twitterDBContext.SaveChanges(); }
public void UnFollowUser(string id, string user) { TwitterDBContext twitterDBContext = new TwitterDBContext(); var delObj = twitterDBContext.FOLLOWINGs.Where(m => m.user_id == user && m.following_id == id).First(); twitterDBContext.FOLLOWINGs.Remove(delObj); twitterDBContext.SaveChanges(); }
public void EditProfile(PERSON pObj) { TwitterDBContext twitterDBContext = new TwitterDBContext(); var person = twitterDBContext.People.Where(m => m.user_id == pObj.user_id).FirstOrDefault(); person.fullName = pObj.fullName; person.email = pObj.email; person.password = pObj.password; twitterDBContext.SaveChanges(); }
public Profile NewTweet(Tweet tweet, string user) { TwitterDBContext twitterDBContext = new TwitterDBContext(); Assignment1.TWEET tObj = new TWEET(); tObj.user_id = user; tObj.message = tweet.message; tObj.created = DateTime.Now; twitterDBContext.TWEETs.Add(tObj); twitterDBContext.SaveChanges(); var person = twitterDBContext.People.Where(m => m.user_id == user).FirstOrDefault(); Profile pObj = new Profile(); var selfTweets = person.TWEETs; pObj.selfTweets = new List <Tweet>(); foreach (var item in selfTweets) { pObj.selfTweets.Add(new Tweet { created = item.created, message = item.message, user_id = item.user_id }); } var following = person.FOLLOWINGs1; pObj.following = new List <Person>(); foreach (var item in following) { pObj.following.Add(new Person { user_id = item.following_id }); } pObj.allTweets = new List <Tweet>(); pObj.allTweets.AddRange(pObj.selfTweets); foreach (var item in pObj.following) { var followingTweet = twitterDBContext.TWEETs.Where(m => m.user_id == item.user_id); foreach (var value in followingTweet) { pObj.allTweets.Add(new Tweet { created = value.created, message = value.message, user_id = value.user_id }); } } pObj.allTweets = pObj.allTweets.OrderByDescending(m => m.created).ToList(); return(pObj); }
public ActionResult UnFollowUser(string id) { if (id == Session["user"].ToString()) { return(Json("UnFollow option is for other user's profile!", JsonRequestBehavior.AllowGet)); } try { string user = Session["user"].ToString(); TwitterDBContext twitterDBContext = new TwitterDBContext(); dalLayer.UnFollowUser(id, user); return(Json(id + " - unfollowed!", JsonRequestBehavior.AllowGet)); } catch (Exception ex) { throw ex; } }
public Profile LoadProfilePage(string id) { TwitterDBContext twitterDBContext = new TwitterDBContext(); var person = twitterDBContext.People.Where(m => m.user_id == id).FirstOrDefault(); Profile profilePage = new Profile(); profilePage.user_id = person.user_id; var selfTweets = person.TWEETs; profilePage.selfTweets = new List <Tweet>(); foreach (var item in selfTweets) { profilePage.selfTweets.Add(new Tweet { created = item.created, message = item.message, tweet_id = item.tweet_id }); } profilePage.selfTweets = profilePage.selfTweets.OrderByDescending(m => m.created).ToList(); var following = person.FOLLOWINGs1; profilePage.following = new List <Person>(); foreach (var item in following) { profilePage.following.Add(new Person { user_id = item.following_id }); } var followers = person.FOLLOWINGs; profilePage.followers = new List <Person>(); foreach (var item in followers) { profilePage.followers.Add(new Person { user_id = item.user_id }); } profilePage.fullName = person.fullName; profilePage.email = person.email; profilePage.joined = person.joined; return(profilePage); }
public Profile DeleteTweet(Tweet tweet, string user) { TwitterDBContext twitterDBContext = new TwitterDBContext(); var tObj = twitterDBContext.TWEETs.Where(m => m.tweet_id == tweet.tweet_id).FirstOrDefault(); twitterDBContext.TWEETs.Remove(tObj); twitterDBContext.SaveChanges(); var person = twitterDBContext.People.Where(m => m.user_id == user).FirstOrDefault(); Profile pObj = new Profile(); var selfTweets = person.TWEETs; pObj.selfTweets = new List <Tweet>(); foreach (var item in selfTweets) { pObj.selfTweets.Add(new Tweet { created = item.created, message = item.message, user_id = item.user_id }); } pObj.selfTweets = pObj.selfTweets.OrderByDescending(m => m.created).ToList(); return(pObj); }
public RetweetTagHelper(TwitterDBContext context, UserManager <User> userManager) { _context = context; _userManager = userManager; }
public Message(TwitterDBContext context) { _context = context; }
public Tweet(TwitterDBContext context, UserManager <User> userManager) { _context = context; _userManager = userManager; }
public ChatHub(UserManager <User> userManager, TwitterDBContext context) { _userManager = userManager; _context = context; }
public Profile LoadProfileHome(string id) { TwitterDBContext twitterDBContext = new TwitterDBContext(); var person = twitterDBContext.People.Where(m => m.user_id == id).FirstOrDefault(); Profile profileHome = new Profile(); profileHome.user_id = person.user_id; var selfTweets = person.TWEETs; profileHome.selfTweets = new List <Tweet>(); foreach (var item in selfTweets) { profileHome.selfTweets.Add(new Tweet { created = item.created, message = item.message, user_id = item.user_id, tweet_id = item.tweet_id }); } var following = person.FOLLOWINGs1; profileHome.following = new List <Person>(); foreach (var item in following) { profileHome.following.Add(new Person { user_id = item.following_id }); } profileHome.allTweets = new List <Tweet>(); profileHome.allTweets.AddRange(profileHome.selfTweets); foreach (var item in profileHome.following) { var followingTweet = twitterDBContext.TWEETs.Where(m => m.user_id == item.user_id); foreach (var value in followingTweet) { profileHome.allTweets.Add(new Tweet { created = value.created, message = value.message, user_id = value.user_id, tweet_id = value.tweet_id }); } } profileHome.allTweets = profileHome.allTweets.OrderByDescending(m => m.created).ToList(); var followers = person.FOLLOWINGs; profileHome.followers = new List <Person>(); foreach (var item in followers) { profileHome.followers.Add(new Person { user_id = item.user_id }); } profileHome.tweetCount = person.TWEETs.Count; profileHome.followersCount = person.FOLLOWINGs.Count; profileHome.followingCount = person.FOLLOWINGs1.Count; profileHome.fullName = person.fullName; profileHome.email = person.email; profileHome.joined = person.joined; var twitterUsers = twitterDBContext.People; profileHome.twitterUsers = new List <Person>(); foreach (var item in twitterUsers) { profileHome.twitterUsers.Add(new Person { user_id = item.user_id }); } return(profileHome); }
public HomeController(TwitterDBContext context, UserManager <User> userManager, IHostingEnvironment appEnvironment) { _context = context; _userManager = userManager; _appEnvironment = appEnvironment; }
public TweetsController(UserManager <User> userManager, TwitterDBContext context) { _context = context; _userManager = userManager; }
public ProfileController(UserManager <User> userManager, TwitterDBContext context) { _userManager = userManager; _context = context; }
public Reply(TwitterDBContext context) { _context = context; }
public HomeController(TwitterDBContext context, UserManager <User> userManager) { _context = context; _userManager = userManager; }
public MessagesController(UserManager <User> userManager, TwitterDBContext context) { _userManager = userManager; _context = context; }