public int SetInvitationStatusAfterSuccessfulRegistration(string refid, string userEmail)
        {
            int res = 0;

            try
            {
                UserRepository objUserRepository = new UserRepository();

                User user = objUserRepository.getUsersById(Guid.Parse(refid));

                Invitation objInvitation = new Invitation();
                objInvitation.SenderEmail = user.EmailId;
                objInvitation.FriendEmail = userEmail;
                objInvitation.Status      = "12";

                InvitationRepository objInvitationRepository = new InvitationRepository();
                res = objInvitationRepository.SetInvitationStatusBySenderEmailFreiendEmail(objInvitation);
            }
            catch (Exception ex)
            {
                logger.Error(ex.StackTrace);

                Console.WriteLine(ex.StackTrace);
                //Response.Redirect("Home.aspx");
            }
            return(res);
        }