public async Task <IActionResult> ShowMyBunch() { // get current user var currUser = await GetCurrentUserAsync(); var usersId = currUser.Id; var myBunch = _context.UserFollow .Include(u => u.ReceivingUser) .Include(u => u.RequestingUser) .Where(u => u.RequestingUserId == usersId).ToList(); var myFollowers = _context.UserFollow .Include(u => u.ReceivingUser) .Include(u => u.RequestingUser) .Where(u => u.ReceivingUserId == usersId).ToList(); UserFollowsViewModel userFollowsViewModel = new UserFollowsViewModel() { User = currUser, UsersIFollow = myBunch, UsersFollowingMe = myFollowers }; return(View(userFollowsViewModel)); }
public async Task <IActionResult> Index() { // get current user var currUser = await GetCurrentUserAsync(); UserFollowsViewModel userFollowsViewModel = new UserFollowsViewModel() { User = currUser }; return(View(userFollowsViewModel)); }
public async Task <IActionResult> SeeMemoirs(string userid, AppUser user) { var muncherMemoirs = _context.Memoir.Include(m => m.AppUser).Where(m => m.AppUserId == userid); var memoirList = await muncherMemoirs.ToListAsync(); UserFollowsViewModel userFollowsViewModel = new UserFollowsViewModel() { MuncherMemoirs = memoirList, UserId = userid, User = user }; return(View(userFollowsViewModel)); }
public async Task <IActionResult> MemoirDetails(int id, string userid, AppUser user) { var memoir = await _context.Memoir .Include(m => m.AppUser) .FirstOrDefaultAsync(m => m.MemoirId == id); UserFollowsViewModel userFollowsViewModel = new UserFollowsViewModel() { FeaturedMemoir = memoir, UserId = userid, User = user }; return(View(userFollowsViewModel)); }
public async Task <IActionResult> Search(string searchTerm) { // get current user var currUser = await GetCurrentUserAsync(); var usersId = currUser.Id; string sql1 = $@" select * from AspNetUsers au where not au.Id = '{usersId}' and au.Id not in (select au.Id from AspNetUsers au left join UserFollow uf on au.Id = uf.ReceivingUserId where uf.RequestingUserId = '{usersId}')"; var everyoneNotMe = _context.AppUser.FromSql(sql1).ToList(); List <AppUser> usersToFollow = new List <AppUser>(); foreach (var person in everyoneNotMe) { if (person.FirstName.Contains(searchTerm, StringComparison.InvariantCultureIgnoreCase) || person.LastName.Contains(searchTerm, StringComparison.InvariantCultureIgnoreCase) || person.PrimaryLocation.Contains(searchTerm, StringComparison.InvariantCultureIgnoreCase)) { usersToFollow.Add(person); } } UserFollowsViewModel userFollowsViewModel = new UserFollowsViewModel() { UsersToFollow = usersToFollow, User = currUser }; return(View(userFollowsViewModel)); }