public void AddFriend(string user, string newFriend)
{
using (TempDBFriendListContext db = new TempDBFriendListContext())
{
db.Friends.Add(new Friend() { User = user, Friend1 = newFriend });
db.SaveChanges();
}
}
public IEnumerable<string> GetFriends(User user)
{
IEnumerable<string> friends = null;
using (TempDBFriendListContext db = new TempDBFriendListContext())
{
IEnumerable<string> temp = db.Friends.Where(x => x.User.Equals(user.UserName)).Select(x => x.Friend1).ToList();
IEnumerable<string> temp2 = db.Friends.Where(x => x.Friend1.Equals(user.UserName)).Select(x => x.User).ToList();
friends = temp.Union(temp2).ToList();
}
return friends;
}
public void RemoveFriend(string user, string friend)
{
using (TempDBFriendListContext db = new TempDBFriendListContext())
{
db.Friends.Remove(new Friend() { User = user, Friend1 = friend });
db.SaveChanges();
}
}