how to retreive user through its profile properties?

dazy · February 1st, 2010, 04:02 AM

Hi,

I want to customize the user search on Admin's ManageUser.aspx.

And add the First Name and Last Name along with Email and Username to the drop down list.

Have anyone done this before?

Can anyone tell me how can I modify the membership module to achieve this functionality?

Regards,
dazy

Lee Dumond · February 1st, 2010, 11:34 AM

What you are essentially trying to do is to query based on profile properties. Unfortunately, using the default SqlProfileProvider, this is not possible. This is because the profile data is serialized as a blob in the table, rather than in seperate columns, so you can't target specific properties in a query.

If you really need to do this, you need to use a custom profile provider that maps profile properties to a strictured database table. ScottGu has a blog post that explains how to do this here.

http://weblogs.asp.net/scottgu/archi...10/435038.aspx

dazy · February 1st, 2010, 12:37 PM

But I think I can do it by modifing the filteredUsers() function of ManageUser.aspx page.

Code:

MembershipUserCollection AllUsers = new MembershipUserCollection();
    MembershipUserCollection AllAdmins = new MembershipUserCollection();

private void GetUsersByName(String FN, String LN)
    {
       

        string[] AllAdmins = Roles.GetUsersInRole("Admin");

        
        if (FN != null)
        {
            
            foreach (MembershipUser User in AllUsers)
            {
                foreach (string Admin in AllAdmins)
                {
                    ProfileCommon profile = new ProfileCommon();
                    profile = profile.GetProfile(User.UserName);
                    if (FN == profile.FirstName)
                    
                    {
                        requiredUsers.Add(User);
                        
                    }
                }
                
            }
        
        }

       
        if (LN != null)
        {
           
            foreach (MembershipUser User in AllUsers)
            {
                foreach (string Admin in AllAdmins)
                {
                    ProfileCommon profile = new ProfileCommon();
                    profile = profile.GetProfile(User.UserName);
                    if (LN == profile.LastName)
                    {
                        requiredUsers.Add(User);
                        
                        
                    }
                }
            }
        
        
        }    
    
    }

But I guess there is some issue with the loops placement because in some conditions this code works and in others not.

What is your opinion about this solution?

Regards,
dazy.

Lee Dumond · February 1st, 2010, 12:51 PM

What are you trying to do by adding an AllAdmins collection here?

dazy · February 1st, 2010, 01:09 PM

I'm trying to retrieve all the admins on the ManageUsers.aspx page, so that I can edit or delete their accounts.

Regards,
dazy

Lee Dumond · February 1st, 2010, 01:19 PM

Okay, then why do you need to search by first name or last name then?

dazy · February 1st, 2010, 01:33 PM

Search by First and Last Name is the requirement of my project. It is like super admin can search the admins by their First Name, Last Name.

Regards,
dazy