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