public static Boolean updateRelation(Guid askedUser, Guid askingUser)
{
bindedinEntities bie = SingletonEntities.Instance;
bie.Refresh(System.Data.Objects.RefreshMode.StoreWins, bie.relation_status);
var relation = from r in bie.relation_status
where r.asking_user == askingUser
where r.asked_user == askedUser
select r;
relation_status relationTrouve = relation.First();
relationTrouve.status = 3;
bie.SaveChanges();
return(true);
}
public static Boolean deleteRelation(Guid user1, Guid user2)
{
bindedinEntities bie = SingletonEntities.Instance;
bie.Refresh(System.Data.Objects.RefreshMode.StoreWins, bie.relation_status);
var relation = from r in bie.relation_status
where (r.asked_user == user1 && r.asking_user == user2) ||
(r.asked_user == user2 && r.asking_user == user1)
select r;
relation_status relationTrouve = relation.First();
relationTrouve.status = 4;
bie.SaveChanges();
return(true);
}
public static List <UserProfile> GetRelations(Guid userId)
{
bindedinEntities bie = SingletonEntities.Instance;
UserProfile profile = UserProfile.GetUserProfile(System.Web.HttpContext.Current.User.Identity.Name);
bie.Refresh(System.Data.Objects.RefreshMode.StoreWins, bie.relation_status);
// On récupère les utilisateurs qui sont en relation
var relations = from rel in bie.relation_status
where rel.status == 3
select rel;
List <UserProfile> userRelations = new List <UserProfile>();
UserProfile profil;
foreach (var relation in relations)
{
if (relation.status == 3)
{
if (relation.asked_user == userId)
{
profil = UserProfile.GetUserProfile(Membership.GetUser(relation.asking_user).UserName);
Guid userGuid = (Guid)Membership.GetUser(profil.UserName, false).ProviderUserKey;
profil.imageUrl = "/ShowImage.ashx?iduser="******"/ShowImage.ashx?iduser=" + userGuid.ToString();
userRelations.Add(profil);
}
}
}
return(userRelations);
}
public static int isInRelationWith(String username)
{
Guid askingRelation = (Guid)Membership.GetUser(username, false).ProviderUserKey;
Guid loggedRelation = (Guid)Membership.GetUser(System.Web.HttpContext.Current.User.Identity.Name, false).ProviderUserKey;
bindedinEntities bie = SingletonEntities.Instance;
bie.Refresh(System.Data.Objects.RefreshMode.StoreWins, bie.relation_status);
var listRelation = from r in bie.relation_status
where (r.asked_user == loggedRelation && r.asking_user == askingRelation) ||
(r.asked_user == askingRelation && r.asking_user == loggedRelation)
select r;
if (listRelation.Count() > 0)
{
return(listRelation.First().status);
}
else
{
return(-1);
}
}