Custom Profile not being created

EDN Admin · Dec 16, 2011

Hi,
I have successfully setup a custom membership provider that write to my own SQL database and would now like to store additional profile data in the same database. I have the standard asp.net 4.0 createuserwizard controls on my registration page.
To this end i have.
Create a custom profile provider that inherits from Profile Provider.
Amended the web.config
Created a set of stored procedures

When a user registers, my tblMember (custom membership) is populated as before but the Profiles table for my custom profile never gets populated.
Im assuming this should happen automatically once a user is authenticated and no page behind code is need, to initially create the profile record, as this is wired up in the web.config file.

Ive also tried placing a breakpoint in the custom profile class on method GetPropertyValues and SetPropertyValues but these never get hit during/after registration.
They do get hit if i put code in the Registration.aspx page in CreateUserWizard1_CreatedUser - such as
ProfileCommon p = Profile.GetProfile(mycustomember.UserName); - although they arent qute working correctly yet, the code does get callled.

Should i be using the code or similar above to create the profile record or should this be happening automatically - my membership record is created automically without any code behind, so im assuming the profile would follow the same route - although i
know i will have to set the additional profile properties in the code behind once the profile has been automatically created.

Also my database isnt in the app_data folder, as some example show.
Also i dont have all the aspnet....tables/spros that are needed when the out of the box profile is used - do i still need to have these present, even though im using a custom profile.

Code attached below (custom profile and web.config)
namespace HDI.AspNet.Membership 
{ 
public sealed class HDIMembershipProfile : ProfileProvider 
 
{ 
 
#region "class variables" 
private string _applicationName; 
private string _connectionString; 
#endregion 
 
 
public override void Initialize(string name, NameValueCollection config) 
{ 
 
_connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["PP_Connect"].ConnectionString; 
_applicationName = "/"; 
 
// Get values from config file 
if (config == null) 
{ 
throw new ArgumentNullException("config"); 
} 
 
 
if (name == null || name.Length == 0) 
{ 
name = "HDIProfileProvider"; 
} 
 
 
if (string.IsNullOrEmpty("description")) 
{ 
config.Remove("description"); 
} 
 
//Set application and connecetionstring 
 
 
base.Initialize(name, config); 
} 
 
public override int DeleteInactiveProfiles(ProfileAuthenticationOption authenticationOption, DateTime userInactiveSinceDate) 
{ 
throw new NotImplementedException(); 
} 
 
public override int DeleteProfiles(string[] usernames) 
{ 
throw new NotImplementedException(); 
} 
 
public override int DeleteProfiles(ProfileInfoCollection profiles) 
{ 
throw new NotImplementedException(); 
} 
 
public override ProfileInfoCollection FindInactiveProfilesByUserName(ProfileAuthenticationOption authenticationOption, string usernameToMatch, DateTime userInactiveSinceDate, int pageIndex, int pageSize, out int totalRecords) 
{ 
throw new NotImplementedException(); 
} 
 
public override ProfileInfoCollection FindProfilesByUserName(ProfileAuthenticationOption authenticationOption, string usernameToMatch, int pageIndex, int pageSize, out int totalRecords) 
{ 
throw new NotImplementedException(); 
} 
 
public override ProfileInfoCollection GetAllInactiveProfiles(ProfileAuthenticationOption authenticationOption, DateTime userInactiveSinceDate, int pageIndex, int pageSize, out int totalRecords) 
{ 
throw new NotImplementedException(); 
} 
 
public override ProfileInfoCollection GetAllProfiles(ProfileAuthenticationOption authenticationOption, int pageIndex, int pageSize, out int totalRecords) 
{ 
throw new NotImplementedException(); 
} 
 
public override int GetNumberOfInactiveProfiles(ProfileAuthenticationOption authenticationOption, DateTime userInactiveSinceDate) 
{ 
throw new NotImplementedException(); 
} 
 
public override string ApplicationName 
{ 
get 
{ 
return _applicationName; 
} 
set 
{ 
_applicationName = value; 
} 
} 
 
 
 
/// <summary> 
/// Get property values 
/// </summary> 
/// <param name="context </param> 
/// <param name="settingsProperties </param> 
/// <returns></returns> 
public override SettingsPropertyValueCollection GetPropertyValues(SettingsContext context, SettingsPropertyCollection settingsProperties) 
{ 
string _userName = (string)context["UserName"]; 
bool _isAuthenticated = (bool)context["IsAuthenticated"]; 
 
SqlConnection _sqlConnection = new SqlConnection(_connectionString); 
SqlCommand _sqlCommand = new SqlCommand("Profile_Sel", _sqlConnection); 
_sqlCommand.CommandType = CommandType.StoredProcedure; 
SqlDataReader _sqlDataReader; 
 
_sqlCommand.Parameters.Add("username", SqlDbType.VarChar, 50).Value = _userName; 
_sqlCommand.Parameters.Add("applicationName", SqlDbType.NVarChar, 50).Value = _applicationName; 
_sqlCommand.Parameters.Add("isAnonymous", SqlDbType.Bit).Value = !_isAuthenticated; 
 
SettingsPropertyValueCollection _settingsValues = new SettingsPropertyValueCollection(); 
 
try 
{ 
_sqlConnection.Open(); 
_sqlDataReader = _sqlCommand.ExecuteReader(CommandBehavior.CloseConnection); 
_sqlDataReader.Read(); 
 
foreach (SettingsProperty _property in settingsProperties) 
{ 
// Check reader for data 
if (_sqlDataReader.HasRows) 
{ 
SettingsPropertyValue _settingsPropertyValue = new SettingsPropertyValue(_property); 
 
switch (_property.Name) 
{ 
case "UserName": 
_settingsPropertyValue.PropertyValue = _sqlDataReader["UserName"]; 
break; 
 
case "MemberTitleId": 
_settingsPropertyValue.PropertyValue = _sqlDataReader["MemberTitleId"]; 
break; 
 
case "GenderId": 
_settingsPropertyValue.PropertyValue = _sqlDataReader["GenderId"]; 
break; 
 
case "DateOfBirth": 
break; 
 
case "FirstName": 
_settingsPropertyValue.PropertyValue = _sqlDataReader["FirstName"]; 
break; 
 
case "LastName": 
break; 
 
case "TownId": 
break; 
 
case "Latitiude": 
 
break; 
case "Longitude": 
 
break; 
 
default: 
throw new Exception("unsupported property"); 
} 
 
_settingsValues.Add(_settingsPropertyValue); 
} 
 
} 
} 
 
catch (SqlException e) 
{ 
} 
 
return _settingsValues; 
 
} 
 
 
/// <summary> 
/// Set property values 
/// </summary> 
/// <param name="context </param> 
/// <param name="settingsPropertyValues </param> 
public override void SetPropertyValues(SettingsContext context, SettingsPropertyValueCollection settingsPropertyValues) 
{ 
string _userName = (string)context["UserName"]; 
bool _isAuthenticated = (bool)context["IsAuthenticated"]; 
 
SqlConnection _sqlConnection = new SqlConnection(_connectionString); 
SqlCommand _sqlCommand = new SqlCommand("ProfileData_Upd", _sqlConnection); 
_sqlCommand.CommandType = CommandType.StoredProcedure; 
 
_sqlCommand.Parameters.Add("userName", SqlDbType.NVarChar, 50).Value = _userName; 
_sqlCommand.Parameters.Add("applicationName", SqlDbType.NVarChar, 50).Value = _applicationName; 
_sqlCommand.Parameters.Add("isAnonymous", SqlDbType.Bit).Value = !_isAuthenticated; 
 
 
 
foreach (SettingsProperty settingsPropertyValue in settingsPropertyValues) 
{ 
 
switch (settingsPropertyValue.Name) 
{ 
 
case "MemberTitleId": 
_sqlCommand.Parameters.Add("MemberTitleId", SqlDbType.Int, 0).Value = int.Parse (settingsPropertyValue.ToString()) ; 
 
break; 
 
case "GenderId": 
_sqlCommand.Parameters.Add("GenderId", SqlDbType.Int, 0).Value = int.Parse(settingsPropertyValue.ToString()); 
break; 
 
case "DateOfBirth": 
_sqlCommand.Parameters.Add("DateOfBirth", SqlDbType.DateTime, 0).Value = DateTime.Parse(settingsPropertyValue.ToString()); 
break; 
 
case "FirstName": 
_sqlCommand.Parameters.Add("FirstName", SqlDbType.VarChar, 50).Value = settingsPropertyValue.ToString(); 
break; 
 
case "LastName": 
_sqlCommand.Parameters.Add("LastName", SqlDbType.VarChar, 50).Value = settingsPropertyValue.ToString(); 
break; 
 
case "TownId": 
_sqlCommand.Parameters.Add("TownId", SqlDbType.Int, 0).Value = int.Parse(settingsPropertyValue.ToString()); 
break; 
 
case "Latitiude": 
_sqlCommand.Parameters.Add("Latitude", SqlDbType.Real, 0).Value = (Single)settingsPropertyValue.DefaultValue; 
break; 
 
case "Longitude": 
_sqlCommand.Parameters.Add("Longitude", SqlDbType.Real, 0).Value = (Single)settingsPropertyValue.DefaultValue; 
break; 
 
default: 
throw new Exception("unsupported property"); 
} 
} 
 
try 
{ 
_sqlConnection.Open(); 
_sqlCommand.ExecuteNonQuery(); 
} 
 
catch (SqlException e) 
{ 
throw new Exception(e.Message); 
} 
 
finally 
{ 
_sqlConnection.Close(); 
} 
} 
} 
}

web.config
<profile enabled="true" defaultProvider ="HDIMembershipProfile 
<providers> 
<clear /> 
<add name ="HDIMembershipProfile" 
type ="HDI.AspNet.Membership.HDIMembershipProfile" 
connectionStringName="PP_Connect" 
application="/" /> 
 
</providers> 
<properties > 
<add name="UserId" type="System.Guid"/> 
<add name="MemberTitleId" type="System.Int32"/> 
<add name="GenderId" type="System.Int32"/> 
<add name="DateOfBirth" type="System.DateTime"/> 
<add name="FirstName" type="System.String"/> 
<add name="LastName" type="System.String"/> 
 
</properties>
</profile>

Any help greatly appreciated
Steve

View the full article

Custom Profile not being created

EDN Admin

Well-known member