Hi all,

It seems to be rather odd that when I am adding new feature settings in the featureDefinitions file and run the setup/default.aspx, the new setting did not gets added to the database. I can see it by inspecting the Settings object in debug mode.

The old settings can be updated successfully. But I could not figure how to added a new one.

Thanks in advance.

Derek Liang

<?xml version="1.0" encoding="utf-8" ?>
<featureDefinitions>
    <featureDefinition
        featureGuid="A8DDE31E-D80E-11DF-AC83-4F18DFD72085"
        supportedDatabases="MSSQL"
        resourceFile="Resources"
        featureNameReasourceKey="PropertyList"
        controlSource="xxx/Property.ascx"
        sortOrder="100"
        isCacheable="true"
        defaultCacheTime="0"
        excludeFromFeatureList="false"
        isSearchable="false"
        searchListNameResourceKey=""
        deleteProvider=""
        icon="blank.gif"
        >

        <featureSetting
        resourceFile="Resources"
        resourceKey="PageSizeSetting"
        defaultValue="5"
        controlType="TextBox"
        sortOrder="100"
        helpKey="PageSizeSettingHelp"
        regexValidationExpression="^[1-9][0-9]{0,4}$"
            />

        <featureSetting
            resourceFile="Resources"
            resourceKey="regexMLSNoSetting"
            defaultValue="MLS# (V\\d+),1"
            controlType="TextBox"
            sortOrder="110"
            />
...

Hi Joe,

I traced the program and find out that:

1. ModuleDefinitionSettings table has updated according to the featureDefinitions file.

2. ModuleSetting table is not updated.

3. when the user control requesting the Setting object, it is loaded from ModuleSetting table which only contains previous setting (not the updated one defined in the featureDefinitions file)

I am not sure if there is a simple solutions, but here is the code that I came up and was tested working:

SiteModuleControl.cs

        public Hashtable Settings
        {
            get
            {
                if (settings == null)
                {
                    settings = ModuleSettings.GetModuleSettings(ModuleId);
                    int moduleDefId = GetModule(ModuleId).ModuleDefId;
                    ArrayList defaultSettingList = ModuleSettings.GetDefaultSettings(moduleDefId);

                    foreach (CustomModuleSetting defaultSetting in defaultSettingList)
                    {
                        if (!settings.ContainsKey(defaultSetting.SettingName))
                        {
                            settings.Add(defaultSetting.SettingName, defaultSetting.SettingValue);
                        }
                    }

                }
                return settings;
            }
        }

        private Module GetModule(int moduleId)
        {
            if (currentPage == null) { return null; }

            foreach (Module m in currentPage.Modules)
            {
                if (m.ModuleId == moduleId) { return m; }
            }

            return null;
        }

A easy to read version. :)

declare cur cursor for select ModuleID from mp_Modules
declare @ModuleID int
declare @ModuleGuid uniqueidentifier

open cur

fetch next from cur into @ModuleID

while @@fetch_status = 0
begin

set @ModuleGuid = (select [Guid] from mp_Modules where ModuleID=@ModuleID)

insert mp_ModuleSettings
select
        @ModuleID ModuleID,
        SettingName, 
        SettingValue,
        ControlType,
        RegexValidationExpression,
       NEWID() SettingGuid,
        @ModuleGuid ModuleGuid,
        ControlSrc,
        SortOrder,
        HelpKey

from    mp_ModuleDefinitionSettings
        where  (ModuleDefID = (select ModuleDefID from mp_Modules where ModuleID=@ModuleID))
                and
              (SettingName not in(select SettingName from mp_ModuleSettings where ModuleID=@ModuleID))

    fetch next from cur into @ModuleID
end

close cur
deallocate cur

help please, I have a user control consisting of a EventCalendar, two GridView, two DropDownList and a ModalPopup. The fact is that the ModalPopup GridView and make use of a Theme of the project, which works fine but do not know how to integrate the web.

Greetings from Lima - Peru