public ActionResult DisplayFriends() { var db = new ApplicationDbContext(); var currentUser = User.Identity.GetUserId(); var senderProfile = db.Users.FirstOrDefault(p => p.Id == currentUser); var query = db.FriendModels.Where(p => p.FriendRequestReciever == currentUser && p.pendingRequest == 1).SelectMany(p => p.Sender).ToList(); var validationList2 = db.FriendModels.SelectMany(p => p.Sender).ToList(); var validationList = db.Users.SelectMany(p => p.FriendList).ToList(); if (validationList2 != null) { for (int i = 0; i < validationList.Count(); i++) { if (validationList[i].pendingRequest == 1 && validationList[i].FriendRequestReciever != currentUser && validationList2[i].Id == currentUser) { var _lista = validationList[i].FriendRequestReciever; var profile = db.Users.FirstOrDefault(p => p.Id == _lista); query.Add(profile); } } } var list = new SenderListModel { RequestsFrom = query }; return(View(list)); }
public ActionResult DisplayFriendRequests() { var db = new ApplicationDbContext(); var currentUser = User.Identity.GetUserId(); var senderProfile = db.Users.FirstOrDefault(p => p.Id == currentUser); var query = db.FriendModels.Where(p => p.FriendRequestReciever == currentUser && p.pendingRequest == 0).SelectMany(p => p.Sender).ToList(); var list = new SenderListModel { RequestsFrom = query }; return(View(list)); }