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);
}
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 static void UploadPicture(string username, string picture)
{
using (var db = new FindLoveDbEntities())
{
User userPicture = db.User.FirstOrDefault(x => x.UserName == username);
userPicture.Picture = picture;
db.SaveChanges();
}
}
public static void RemoveMessage(int MessageId)
{
using (var db = new FindLoveDbEntities())
{
var msg = db.Message.FirstOrDefault(x => x.Id == MessageId);
db.Message.Remove(msg);
db.SaveChanges();
}
}
public static List <Message> GetAllPostsForUser(User ActiveUser)
{
using (var db = new FindLoveDbEntities())
{
var result = from i in db.Message
where i.ReceiverId == ActiveUser.Id
select i;
return(result.ToList());
}
}
/* Method returns true if friend is already categorised. */
public bool IsFriendCategorised(string ActiveUserUsername, string FriendUserName)
{
int ActiveUserId;
int FriendId;
using (var userRep = new UserRepository())
{
ActiveUserId = userRep.GetUserByUserName(ActiveUserUsername).Id;
FriendId = userRep.GetUserByUserName(FriendUserName).Id;
}
using (var db = new FindLoveDbEntities())
{
var p = db.Category.FirstOrDefault(x => x.ActiveUserId == ActiveUserId && x.FriendId == FriendId);
return(p == null);
}
}
public static void AddNewMessage(User sender, int recieverId, string message)
{
using (var userRep = new UserRepository())
{
var senderId = sender.Id;
using (var db = new FindLoveDbEntities())
{
var newMessage = new Message();
newMessage.Message1 = message;
newMessage.ReceiverId = recieverId;
newMessage.SenderId = senderId;
db.Message.Add(newMessage);
db.SaveChanges();
}
}
}
/* Returns true if two users are already friends */
public static bool CheckIfUsersAreFriends(string SenderUserName, string RecieverUserName)
{
using (var userRep = new UserRepository())
{
var senderId = userRep.GetUserByUserName(SenderUserName).Id;
var recieverId = userRep.GetUserByUserName(RecieverUserName).Id;
using (var db = new FindLoveDbEntities())
{
var result = from r in db.Friend
where r.SenderId == senderId && r.ReceiverId == recieverId || r.SenderId == recieverId && r.ReceiverId == senderId
select r;
return(result.ToList().Count > 0);
}
}
}
public void SaveVisits(string VisitorUserName, string VisitedUserName)
{
using (var userRepo = new UserRepository())
{
var VisitorId = userRepo.GetUserByUserName(VisitorUserName).Id;
var VisitedId = userRepo.GetUserByUserName(VisitedUserName).Id;
var date = DateTime.Now;
using (var db = new FindLoveDbEntities())
{
var visit = new Visitors();
visit.VisitedUserId = VisitedId;
visit.VisitorUserId = VisitorId;
visit.Date = date;
db.Visitors.Add(visit);
db.SaveChanges();
}
}
}
public List <string> GetAllCategoriesForUser(string userName)
{
int userId;
var returnList = new List <string>();
using (var userRep = new UserRepository())
{
userId = userRep.GetUserByUserName(userName).Id;
}
using (var db = new FindLoveDbEntities())
{
returnList = (from r in db.Category
where r.ActiveUserId == userId
select r.Category1).Distinct().ToList();
}
return(returnList);
}
public void AddCategoryToFriend(string activeUserName, string friendUserName, string category)
{
int activeUserId;
int friendId;
using (var userRep = new UserRepository())
{
activeUserId = userRep.GetUserByUserName(activeUserName).Id;
friendId = userRep.GetUserByUserName(friendUserName).Id;
}
using (var db = new FindLoveDbEntities())
{
var friendCategory = new Category();
friendCategory.ActiveUserId = activeUserId;
friendCategory.FriendId = friendId;
friendCategory.Category1 = category;
db.Category.Add(friendCategory);
db.SaveChanges();
}
}
public void UpdatePerson(string currentUser, User person)
{
using (var FindLoveDb = new FindLoveDbEntities())
{
User currentU = FindLoveDb.User.FirstOrDefault(x => x.UserName == currentUser);
currentU.FirstName = person.FirstName;
currentU.LastName = person.LastName;
currentU.UserName = person.UserName;
currentU.Password = person.Password;
currentU.Description = person.Description;
currentU.Age = person.Age;
currentU.Sex = person.Sex;
currentU.InterestedMen = person.InterestedMen;
currentU.InterestedWomen = person.InterestedWomen;
currentU.Active = person.Active;
currentU.Visible = person.Visible;
FindLoveDb.SaveChanges();
}
}
public List <Category> ReturnAllFriendsWithCategory(string userName)
{
int userId;
var returnList = new List <Category>();
using (var userRepo = new UserRepository())
{
userId = userRepo.GetUserByUserName(userName).Id;
}
using (var db = new FindLoveDbEntities())
{
var result = from r in db.Category
where r.ActiveUserId == userId
select r;
foreach (var item in result)
{
returnList.Add(item);
}
}
return(returnList);
}
public UserRepository()
{
this.Context = new FindLoveDbEntities();
}
public SearchRepository()
{
Context = new FindLoveDbEntities();
}
public FriendReqRepository()
{
Context = new FindLoveDbEntities();
}
