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 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 SendInvitation(String asking_userName, String asked_username, String message)
        {
            UserProfile loggedInProfile = UserProfile.GetUserProfile(asking_userName);

            String obj = String.Format("{0} {1} veut vous inviter dans son réseau !", loggedInProfile.FirstName, loggedInProfile.LastName);

            String messageToSend = message;

            messageToSend += "\n";

            Uri    uri  = HttpContext.Current.Request.Url;
            String host = uri.Scheme + Uri.SchemeDelimiter + uri.Host + ":" + uri.Port;
            String linkForInvitation = host + String.Format("/AcceptedInvitation.aspx?id_asking={0}&id_asked={1}", (Guid)(Membership.GetUser(asking_userName, false).ProviderUserKey), (Guid)(Membership.GetUser(asked_username, false).ProviderUserKey));

            messageToSend += "<br />Voici le lien pour accepter cette invitation : <br /> <a href=\"" + linkForInvitation + " \" class=\"btn\">Accepter la demande</a>";
            messageToSend += "\n";
            messageToSend += "<br />Sinon ignorez tout simplement ce message";
            messageToSend += "<br />Cordialement,";
            messageToSend += "<br />Votre équipe BindedIn";

            Business.MessageService.SendMessage((Guid)(Membership.GetUser(asking_userName, false).ProviderUserKey), (Guid)(Membership.GetUser(asked_username, false).ProviderUserKey), obj, messageToSend);

            bindedinEntities bie = SingletonEntities.Instance;

            relation_status newRelation = new relation_status();

            newRelation.status      = 1;
            newRelation.asked_date  = DateTime.Now;
            newRelation.asked_user  = (Guid)(Membership.GetUser(asked_username, false).ProviderUserKey);
            newRelation.asking_user = (Guid)(Membership.GetUser(asking_userName, false).ProviderUserKey);

            bie.relation_status.AddObject(newRelation);
            bie.SaveChanges();

            return(true);
        }