public static List <User> ReturnAllFriends(User ActiveUser)
{
var returnList = new List <User>();
using (var db = new FindLoveDbEntities())
{
var result = from r in db.Friend
where (r.ReceiverId == ActiveUser.Id || r.SenderId == ActiveUser.Id) && r.Accepted
select r;
using (var userRep = new UserRepository())
{
foreach (var item in result)
{
if (item.ReceiverId == ActiveUser.Id)
{
var user = userRep.GetUserById(item.SenderId);
if (user.Active == true)
{
returnList.Add(user);
}
}
else
{
var user = userRep.GetUserById(item.ReceiverId);
if (user.Active == true)
{
returnList.Add(user);
}
}
}
}
}
return(returnList);
}
public List <User> GetFiveLatestVisitors(string userName)
{
var visitors = new List <Visitors>();
var activeUser = new User();
var latestUser = new List <User>();
using (var userRepository = new UserRepository())
{
activeUser = userRepository.GetUserByUserName(userName);
}
using (var db = new FindLoveDbEntities())
{
var result = (from r in db.Visitors
where r.VisitedUserId == activeUser.Id
orderby r.Date descending
select r).Take(5);
visitors = result.ToList();
}
using (var userRepository = new UserRepository())
{
foreach (var visitor in visitors)
{
latestUser.Add(userRepository.GetUserById(visitor.VisitorUserId));
}
}
return(latestUser);
}
public List <User> GetFriendsByCategory(string userName, string categoryName)
{
var users = new List <User>();
var categories = new List <Category>();
int userId;
using (var userRepo = new UserRepository())
{
userId = userRepo.GetUserByUserName(userName).Id;
using (var db = new FindLoveDbEntities())
{
categories = ReturnAllFriendsWithCategory(userName);
foreach (var category in categories)
{
if (string.Equals(category.Category1, categoryName, StringComparison.OrdinalIgnoreCase))
{
var user = userRepo.GetUserById(category.FriendId);
if (user.Active == true)
{
users.Add(user);
}
}
}
}
}
return(users);
}
