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