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));
}
