Hi,

 

I am with Dynamic Regisrtation latest modules.

At the time of registration we are taking some values such as partner name, their email id etc.

That user input value i want to use in other third party module. For that can you please guide me how to get register user responce value; that he entered at the time of registration.

 

Hope to hear from your side soon.

Thanks,

-Ajit

Hi Ajit,

If you link your fields to Core DNN profile properties, you will be able to pull these values from other modules or other instances of Dynamic Registration. Here's what you can do: Edit the field and go to Advanced Field Options where you'll find DNN Core Field. You can either choose to link to existing profile properties from the drop down or you can click on Quick Create Property and a property will be created based on the short field name.

Then, when you're on another module, just link your fields to this property and it should populate with the existing value. Hope that helps!

Candace

Hi Cand,

Thank you for your quick and steps responce.

 

Well i had created a field "DBA name" and it is showing also created Property for that.

But which class we need to create instance to get the value of that field from your datasprings.Modules.Dynamicregistration namespace.

Since i m unable to access the "DB name " field from Userinfo class.

Can you quickly provide a quick example to access that field from Database; so that i can access all those field on another modules.

 

Hope to get it soon from your side soon.

Thanks,

-Ajit

 

 

 

 

HI Ajit, can you tell me which third party module it is? Can it accept SQL queries? What actually does the third party module consist of? Another words, what can it display and can it have custom fields or template fields that can connect to DNN core fields or use an SQL query? -- David

HI ,

We are developing our own module to get the registration field value to display purpose.

Such as company name, DBA, and other few field from Dynamic Registration module.

So, can you let me know ; How programming we can get those stuff. I created Property as per insturction; but still need to know from where i can access those Property(class name).

Please provide an example or piece of code to get the values.

Module can Accept SQL query as well.

Hope to hear from your side soon.

 

 

HI, in DR if you link the fields to DNN core profile properties, then the profile should note the following SQL tables (users, userprofile,profilepropertydefinition). From the "users" table, you get the userid, from "userprofile" table, you get their profile information which is also tied to the DNN "profilepropertydefinition" where you obtain the ID number of the profile. Here's an example of a stored procedure to add user roles as well as update or insert user profile property definition.

alter procedure usp_AddRoleUserAge (@UserID int,@BirthDate nvarchar(30))
as
begin
declare @RoleID int
--declare @ExpiryDate datetime
declare @EffectiveDate datetime
declare @CalcAge datetime
declare @IsTrialUsed bit

set @EffectiveDate = getdate()
--set @ExpiryDate = null
set @IsTrialUsed = 'True'
set @CalcAge = datediff(year,convert(datetime,@BirthDate),@EffectiveDate)
-- age range: (Under 18, 18-24, 25-30, 30+)
if (@CalcAge < 18)
begin
set @RoleID = 28
if exists(select roleid from userroles where userid = @UserID and roleid = @RoleID)
begin
delete from UserRoles where userid = @UserID and roleid = @RoleID
end
else
begin
insert into UserRoles(UserID,RoleID,IsTrialUsed,EffectiveDate)
values(@UserID,@RoleID,@IsTrialUsed,@EffectiveDate)
end
end

if (@CalcAge between 18 and 24)
begin
set @RoleID = 42
if exists(select roleid from userroles where userid = @UserID and roleid = @RoleID)
begin
delete from UserRoles where userid = @UserID and roleid = @RoleID
end
else
begin
insert into UserRoles(UserID,RoleID,IsTrialUsed,EffectiveDate)
values(@UserID,@RoleID,@IsTrialUsed,@EffectiveDate)
end
end

if (@CalcAge between 25 and 30)
begin
set @RoleID = 43
if exists(select roleid from userroles where userid = @UserID and roleid = @RoleID)
begin
delete from UserRoles where userid = @UserID and roleid = @RoleID
end
else
begin
insert into UserRoles(UserID,RoleID,IsTrialUsed,EffectiveDate)
values(@UserID,@RoleID,@IsTrialUsed,@EffectiveDate)
end
end

if (@CalcAge > 30)
begin
set @RoleID = 25
if exists(select roleid from userroles where userid = @UserID and roleid = @RoleID)
begin
delete from UserRoles where userid = @UserID and roleid = @RoleID
end
else
begin
insert into UserRoles(UserID,RoleID,IsTrialUsed,EffectiveDate)
values(@UserID,@RoleID,@IsTrialUsed,@EffectiveDate)
end
end

-- set the three DNN core profile fields (PrefStoryCommentNotification,NotificationEmails,InvitationEmails)
-- in table "UserProfile" to true; note: need to retrieve PropertyDefinitionID from "ProfilePropertyDefinition"
-- table
declare @PrefStoryCommentNotificationID int
declare @NotificationEmailsID int
declare @InvitationEmailsID int
declare @PublicBirthdayID int
declare @MMPhotoNotifyCmtID int
declare @MMGCommentNotifyID int
declare @BlogOwnerCommentNotifyID int
declare @BlogReaderCommentNotifyID int

set @PrefStoryCommentNotificationID = (select PropertyDefinitionID from ProfilePropertyDefinition
where PropertyName = 'PrefStoryCommentNotification')
set @NotificationEmailsID = (select PropertyDefinitionID from ProfilePropertyDefinition
where PropertyName = 'NotificationEmails')
set @InvitationEmailsID = (select PropertyDefinitionID from ProfilePropertyDefinition
where PropertyName = 'InvitationEmails')
set @PublicBirthdayID = (select PropertyDefinitionID from ProfilePropertyDefinition
where PropertyName = 'PublicBirthday')
set @MMPhotoNotifyCmtID = (select PropertyDefinitionID from ProfilePropertyDefinition
where PropertyName = 'MMPhotoNotifyCmt')
set @MMGCommentNotifyID = (select PropertyDefinitionID from ProfilePropertyDefinition
where PropertyName = 'MMGCommentNotify')
set @BlogOwnerCommentNotifyID = (select PropertyDefinitionID from ProfilePropertyDefinition
where PropertyName = 'BlogOwnerCommentNotify')
set @BlogReaderCommentNotifyID = (select PropertyDefinitionID from ProfilePropertyDefinition
where PropertyName = 'BlogReaderCommentNotify')

if not exists(select userid from UserProfile where userid = @UserID and
PropertyDefinitionID in

(@PrefStoryCommentNotificationID,@NotificationEmailsID,@InvitationEmailsID,@PublicBirthdayID,@MMPhotoNotifyCmtID,@MMGCommentNotifyID,@BlogOwnerComment

NotifyID,@BlogReaderCommentNotifyID))
begin
insert into UserProfile(UserID,PropertyDefinitionID,PropertyValue,Visibility,LastUpdatedDate)
values(@UserID,@PrefStoryCommentNotificationID,'True',2,getdate())
insert into UserProfile(UserID,PropertyDefinitionID,PropertyValue,Visibility,LastUpdatedDate)
values(@UserID,@NotificationEmailsID,'True',2,getdate())
insert into UserProfile(UserID,PropertyDefinitionID,PropertyValue,Visibility,LastUpdatedDate)
values(@UserID,@InvitationEmailsID,'True',2,getdate())
insert into UserProfile(UserID,PropertyDefinitionID,PropertyValue,Visibility,LastUpdatedDate)
values(@UserID,@PublicBirthdayID,'True',2,getdate())
insert into UserProfile(UserID,PropertyDefinitionID,PropertyValue,Visibility,LastUpdatedDate)
values(@UserID,@MMPhotoNotifyCmtID,'True',2,getdate())
insert into UserProfile(UserID,PropertyDefinitionID,PropertyValue,Visibility,LastUpdatedDate)
values(@UserID,@MMGCommentNotifyID,'True',2,getdate())
insert into UserProfile(UserID,PropertyDefinitionID,PropertyValue,Visibility,LastUpdatedDate)
values(@UserID,@BlogOwnerCommentNotifyID,'True',2,getdate())
insert into UserProfile(UserID,PropertyDefinitionID,PropertyValue,Visibility,LastUpdatedDate)
values(@UserID,@BlogReaderCommentNotifyID,'True',2,getdate())
end
end

See if this example SQL helps you out. -- David

Hi ,

What i understand from your query is that we can get those value from PropertyDefinintion.

 

Let me make more clear .

I had added three extra field for DR module (Company name, title and Relation) .

Now what i am doing in third party module to get these field details of login user ( register user from DR).

How i can acces those DR module value(company name, Title and Relation ) for current login user.

 

Which class or which sql table/SP will give me information about the complete RD module field value for logged in user.

 

Please let me know if you still need further.

Hope to hear from your side soon.

Thanks,

-Ajit

 

 

 

HI Ajit, if you add three extra field for DR module (company name, title and relation), you can go to Advance Field Options and use the "Quick Create Property" which would tie these fields and generate a DNN Core Profile. Try it out and you will see these fields under Admin / User Accounts / Manage profile properties (these fields will have a category of DynamicReg). Then when a user registers / update registration, they will have values associated and saved under their userprofile / propertydefinition tables. You now have three tables that are linked together by userid (users, userprofile,profilepropertydefinition). Since your third party module can use SQL queries, then you can query these tables and obtain the User information for any user and any fields that are part of the DNN Core profile.

If you want to be more complex, the actual dynamic registration tables you want to look at are (DynamicRegistration_question, DynamicRegistration_questionresponse). The question table has all your questions that are on the DR form (with key DynamicQuestionID) and with portalid / moduleid,etc. The questionresponse table has all the answers to the questions (pertaining to userid and DynamicQuestionID).

If you have SQL Server Manager, this would be a lot easier to look at. If not, you can go to host / sql and type in: select * from dynamicregistration_question and select * from dynamicregistration_questionresponse to see the assocation. -- David