public static Tuple<MembershipPasswordFormat, string, string> ExtractPasswordData(MembershipUser user)
        {
            MembershipPasswordFormat passwordFormat;
            string passwordSalt;
            string password;

            ConnectionStringSettings connectionString = WebConfigurationManager.ConnectionStrings["DefaultConnection"];
            using(SqlConnection conn = new SqlConnection(connectionString.ConnectionString))
            {
                using(SqlCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText = "SELECT PasswordFormat, PasswordSalt, Password FROM aspnet_Membership WHERE [email protected]";
                    cmd.Parameters.AddWithValue("@UserId", user.ProviderUserKey);
                    conn.Open();
                    using(SqlDataReader rdr = cmd.ExecuteReader())
                    {
                        if(rdr != null && rdr.Read())
                        {
                            passwordFormat = (MembershipPasswordFormat) rdr.GetInt32(0);
                            passwordSalt = rdr.GetString(1);
                            password = rdr.GetString(2);
                        }
                        else
                        {
                            throw new Exception("Error extracting current password data from the database.");
                        }
                    }
                }
            }

            return new Tuple<MembershipPasswordFormat, string, string>(passwordFormat, passwordSalt, password);
        }

        public override MembershipUser CreateUser(string username, string password, string email, 
            string passwordQuestion, string passwordAnswer, bool isApproved, 
            object providerUserKey, out MembershipCreateStatus status)
        {

            bool created = false;
            MembershipUser membershipUser = null;

            try
            {
                created = membershipRepository.Add(username, password, email, out providerUserKey);

                membershipUser = new MembershipUser(this.Name, username, providerUserKey,
                    email, null, null, true, true, 
                    DateTime.Today, DateTime.Today, DateTime.Today, DateTime.Today, DateTime.Today);

                if (created)
                {
                    status = MembershipCreateStatus.Success;
                }
                else
                {
                    status = MembershipCreateStatus.UserRejected;
                }

            }
            catch (Exception)
            {
                status = MembershipCreateStatus.DuplicateUserName;
            }
            

            return membershipUser;
        }

        public ActionResult Create()
        {
            var Perfil = new PerfilUsuario();

            MembershipUserCollection Users = Membership.GetAllUsers();

            MembershipUser[] arr = new MembershipUser[Users.Count];

            Users.CopyTo(arr, 0);

            List<MembershipUser> Usuarios =  arr.ToList();

            List<PerfilUsuario> Perfiles = db.PerfilUsuarios.ToList();

            foreach (var item in Perfiles)
            {
                Usuarios.Remove(Membership.GetUser(item.Username));
            }

            ViewBag.Usuarios = Usuarios;

            var Sucursales = db.Sucursales.OrderBy(s => s.Nombre);

            ViewBag.Sucursales = Sucursales;

            return View(Perfil);
        }

 public override MembershipUser GetUser(object providerUserKey, bool userIsOnline)
 {
     MembershipUser user = new MembershipUser("AgileMindProvider", "test", "test", "test",
                                 string.Empty, string.Empty, true, false, DateTime.Now, DateTime.Now,
                                 DateTime.Now, DateTime.Now, DateTime.Now);
     return user;
 }

		public UserAccount(MembershipUser user)
		{
			UserName = user.UserName;
			Email = user.Email;
			PasswordQuestion = user.PasswordQuestion;
			
		}

        public static void SendPasswordEmail(MembershipUser user, string password, PasswordEmailType passwordEmailType)
        {
            assertExists(user);
            assertHasEmail(user);

            string body = passwordEmailTemplate.Replace("<%LoginName%>", user.UserName)
                                               .Replace("<%Password%>", password);

            body = ApplicationLayer.Utility.ShowOptionalTag(body, "passwordEmailType-firstTime",
                                                                   passwordEmailType == PasswordEmailType.FirstTime);
            body = ApplicationLayer.Utility.ShowOptionalTag(body, "passwordEmailType-reset",
                                                                   passwordEmailType == PasswordEmailType.Reset);
            body = ApplicationLayer.Utility.ShowOptionalTag(body, "passwordEmailType-changedByUser",
                                                                   passwordEmailType == PasswordEmailType.ChangedByUser);
            body = ApplicationLayer.Utility.ShowOptionalTag(body, "passwordEmailType-not-changedByUser",
                                                                   passwordEmailType != PasswordEmailType.ChangedByUser);

            MailMessage message = new MailMessage();

            string testRecipients = ConfigurationManager.AppSettings.Get("TestEmailRecipients");
            message.To.Add(testRecipients == null ? user.Email : testRecipients);

            message.Subject = "Your new Total Giro password";
            message.Body = body;
            message.IsBodyHtml = true;

            SmtpClient client = new SmtpClient();
            client.Send(message);
        }

 public User(MembershipUser user)
 {
     this.UserName = user.UserName;
     ProfileBase profile = ProfileBase.Create(user.UserName);
     this.FullName = profile.GetPropertyValue("FullName") as string;
     this.Email = user.Email;
 }

        public UserProfileManager(MembershipUser _user)
        {
            if (_user == null) {
                throw new ArgumentNullException("_user");
            }

            UserProfile newProfile = new UserProfile(_user.UserName);
            ProfileBase userProfile = ProfileBase.Create(_user.UserName);
            ProfileGroupBase addressGroup = userProfile.GetProfileGroup("Address");

            userProfile.Initialize(_user.UserName, true);

            newProfile.Properties.Add(new ProfileProperty("Nome", "Name", userProfile["Name"].ToString()));

            newProfile.Properties.Add(new ProfileProperty("Telefone", "Phone", addressGroup["Phone"].ToString()));
            newProfile.Properties.Add(new ProfileProperty("CEP", "CEP", addressGroup["CEP"].ToString()));
            newProfile.Properties.Add(new ProfileProperty("Endereço", "Street", addressGroup["Street"].ToString()));
            newProfile.Properties.Add(new ProfileProperty("Bairro", "Area", addressGroup["Area"].ToString()));
            newProfile.Properties.Add(new ProfileProperty("Estado", "State", addressGroup["State"].ToString()));
            newProfile.Properties.Add(new ProfileProperty("Cidade", "City", addressGroup["City"].ToString()));

            /*newProfile.Properties.Add(new ProfileProperty("FTP: Host", "FtpHost", ftpInfoGroup["FtpHost"].ToString()));
            newProfile.Properties.Add(new ProfileProperty("FTP: Usuário", "FtpUserName", ftpInfoGroup["FtpUserName"].ToString()));
            newProfile.Properties.Add(new ProfileProperty("FTP: Senha", "FtpPassword", ftpInfoGroup["FtpPassword"].ToString()));*/

            this.UserProfile = newProfile;
        }

 private UserViewModel User2UserViewModel(MembershipUser user)
 {
     var result = new UserViewModel {Name = user != null ? user.UserName : "Unknown user"};
     if (user != null)
         result.UserId = user.ProviderUserKey is Guid ? (Guid) user.ProviderUserKey : new Guid();
     return result;
 }

        public bool IsResetUrlValid(string hash, out MembershipUser user)
        {
            user = null;
            var isValid = false;
            if (!string.IsNullOrEmpty(hash))
            {
                ResetPasswordModel link = _resetPasswordRespository.Find(hash);

                isValid = (link != null && link.ExpireDate > DateTime.Now);
                if (isValid)
                {
                    user = Membership.Provider.GetUser(link.UserName, false);

                    if (user == null)
                    {
                        string userName = Membership.GetUserNameByEmail(link.UserName);
                        user = Membership.Provider.GetUser(userName, false);
                    }

                    if (user != null && user.IsLockedOut)
                    {
                        user.UnlockUser();
                    }
                }
            }

            return isValid;
        }

        public MembershipUser GetUser(String login)
        {
            using (RoleMembershipDataContext db = new RoleMembershipDataContext())
            {
                var result = from u in db.Users where (u.Login == login) select u;

                if (result.Count() == 0)
                {
                    return null;
                }

                User dbuser = result.FirstOrDefault();
                MembershipUser user = new MembershipUser("CustomMembershipProvider",
                                                         dbuser.Login,
                                                         dbuser.UserId,
                                                         String.Empty,
                                                         String.Empty,
                                                         String.Empty,
                                                         true,
                                                         false,
                                                         dbuser.CreatedDate,
                                                         DateTime.Now,
                                                         DateTime.Now,
                                                         DateTime.Now,
                                                         DateTime.Now);

                return user;
            }
        }

 public void ChangePassword(MembershipUser user, string newPassword)
 {
     throw new NotImplementedException();
     //var resetPassword = user.ResetPassword();
     //if(!user.ChangePassword(resetPassword, newPassword))
     //    throw new MembershipPasswordException("Could not change password.");
 }

        public static void SendActivateEmail(MembershipUser user)
        {
            Database db = DatabaseFactory.CreateDatabase("cnGrammit");

            //Create an activation DB record with a unique GUID that
            //Use that as a request variable to the activation page
            Guid activationGuid = Guid.NewGuid();

            DbCommand dbCommand = db.GetStoredProcCommand("usp_InsertUSER_ACTIVATION");
            db.AddInParameter(dbCommand, "@userID", DbType.Guid, user.ProviderUserKey);
            db.AddInParameter(dbCommand, "@GUID", DbType.Guid, activationGuid);
            db.AddOutParameter(dbCommand, "@ID", DbType.Int32, 2);
            db.ExecuteNonQuery(dbCommand);

            StringBuilder bodyMsg = new StringBuilder();

            bodyMsg.Append("So close... <br />  in order to complete enrollment with ScoreBored.net, you'll need to confirm your account.");
            bodyMsg.AppendFormat("<br />UserName: {0}", user.UserName);
            bodyMsg.Append("<br />Password Question: " + user.PasswordQuestion);

            bodyMsg.Append("<br />Click this link to activate your account: <a href=\"");
            bodyMsg.Append(HttpRuntime.Cache.Get("basePath").ToString());

            bodyMsg.Append("Login.aspx?a=" + HttpUtility.UrlEncode(activationGuid.ToString()) + "\">ACTIVATE</a>");

            MailGen mail = new MailGen();
            mail.SendMessage(user.Email, "[email protected]", "ScoreBored Account Activation", bodyMsg.ToString());
        }

 public UserFormViewModel(string[] allRoles, string[] userRoles, MembershipUser user, ViewMode mode)
 {
     AllRoles = allRoles;
     UserRoles = userRoles;
     User = user;
     Mode = mode;
 }

        public Profile(string providername,
                    string UserName,
                    object ProviderUserKey,
                    string Email,
                    string PasswordQuestion,
                    string Comment,
                    bool IsApproved,
                    bool IsLockedOut,
                    DateTime CreationDate,
                    DateTime LastLoginDate,
                    DateTime LastActivityDate,
                    DateTime LastPasswordChangedDate,
                    DateTime LastLockedOutDate,
                    string RoleId,
                    string RoleName)
        {
            this.UserName = UserName;
            this.ProviderUserKey = ProviderUserKey;
            this.Email = Email;
            this.PasswordQuestion = PasswordQuestion;
            this.Comment = Comment;
            this.IsApproved = IsApproved;
            this.IsLockedOut = IsLockedOut;
            this.CreationDate = CreationDate;
            this.LastLoginDate = LastLoginDate;
            this.LastActivityDate = LastActivityDate;
            this.LastPasswordChangedDate = LastPasswordChangedDate;
            this.LastLockedOutDate = LastLockedOutDate;
            this.RoleId = RoleId;
            this.RoleName = RoleName;

            _CurrentUser = new MembershipUser("DefaultMembershipProvider", this.UserName, this.ProviderUserKey, this.Email, this.PasswordQuestion, this.Comment, this.IsApproved, this.IsLockedOut, this.CreationDate, this.LastLoginDate, this.LastActivityDate, this.LastPasswordChangedDate, this.LastLockedOutDate);
        }

        public static DataSet GetUsersInRole(string roleName)
        {
            DataSet ds = (DataSet)HttpContext.Current.Session["dsUsersInRole"];

            if (ds == null)
            {
                // Get all users
                MembershipUserCollection userColl = Membership.GetAllUsers();
                MembershipUser[] users = new MembershipUser[userColl.Count];
                userColl.CopyTo(users, 0);
                ds = DataSetBuilder.CreateDataSetFromBusinessObjectList(
                    users, "UserName");

                // Add check-boxes
                string[] usersInRole = Roles.GetUsersInRole(roleName);
                DataColumn col = ds.Tables[0].Columns.Add("IsInRole", typeof(bool));
                foreach (DataRow row in ds.Tables[0].Rows)
                {
                    string userName = (string)row["UserName"];
                    row["IsInRole"] = Utility.IsNameInList(userName, usersInRole);
                }

                HttpContext.Current.Session["dsUsersInRole"] = ds;
            }

            return ds;
        }

 public static void MailCustomer(MembershipUser customer, string subject, string body)
 {
     // Send mail to customer
       string to = customer.Email;
       string from = BalloonShopConfiguration.CustomerServiceEmail;
       Utilities.SendMail(from, to, subject, body);
 }

 public static UserProfile GetFor(MembershipUser user)
 {
     using (DREAMContext db = new DREAMContext())
     {
         return db.UserProfiles.Find((Guid)user.ProviderUserKey);
     }
 }

        public void SetUpData()
        {
            // if the test user already exists delete it
            Membership.DeleteUser("user1");

            user = Membership.CreateUser("user1", "Password1!", "[email protected]");
        }

        public EditEventViewModel(string eventId)
        {
            EventId = Int32.Parse(eventId);
             		_memUser = Membership.GetUser(HttpContext.Current.User.Identity.Name);
            SiteUrl = HTTPUtils.GetFullyQualifiedApplicationPath() + "event/";

            using (var context = new DataContext())
            {
                ThisEvent = context.Events.FirstOrDefault(x => x.EventId == EventId);

                // Make sure we have a permalink set
                if (String.IsNullOrEmpty(ThisEvent.PermaLink))
                {
                    ThisEvent.PermaLink = ContentUtils.GetFormattedUrl(ThisEvent.Title);
                }

                EventCategories = context.EventCategories.Where(x => x.IsActive == true).ToList();

                UsersSelectedCategories = new List<string>();

                _thisUser = context.Users.FirstOrDefault(x => x.Username == _memUser.UserName);
            }

            // Get the admin modules that will be displayed to the user in each column
            getAdminModules();
        }