Dear core team,

I have a problem (sorry if my question was already answered).

I am developing CMS module (in C#, SQL 2005). And I want each role (ie Admin, Editor ...) have different permission. For example : Admin has full control but Editor only can edit some article and i can set permission for each role in Settings Page. Now, DNN has just 2 permisson in each module :View & Edit. If i want add more permission, i can manualy add it on Permission table in Database.  But I want to add data into Permission table automatically as UDT or Feedback module.

I have tried using IUpgradeable & InitPermission but It does not work. That's is my code:

public string UpgradeModule(string Version)

{

       InitPermissions();

       return Version;

}

private void InitPermissions()
        {
            bool _canEdit = false;
            int moduleDefId;
            DotNetNuke.Security.Permissions.PermissionController pc = new DotNetNuke.Security.Permissions.PermissionController();
            ArrayList permissions = pc.GetPermissionByCodeAndKey("CMS_CODE", null);
            DotNetNuke.Entities.Modules.DesktopModuleController dc = new DesktopModuleController();
            DotNetNuke.Entities.Modules.DesktopModuleInfo desktopInfo;
            desktopInfo = dc.GetDesktopModuleByName("CMS");
            DotNetNuke.Entities.Modules.Definitions.ModuleDefinitionController mc = new DotNetNuke.Entities.Modules.Definitions.ModuleDefinitionController();
            DotNetNuke.Entities.Modules.Definitions.ModuleDefinitionInfo mInfo;
            mInfo = mc.GetModuleDefinitionByName(desktopInfo.DesktopModuleID, "CMS");
            moduleDefId = mInfo.ModuleDefID;
            foreach (DotNetNuke.Security.Permissions.PermissionInfo p in permissions)
            {
                if ((p.PermissionKey == "EDITARTICLE")&&(p.ModuleDefID == moduleDefId))
                {
                    _canEdit = true;
                }
            }
            if (!_canEdit)
            {
                DotNetNuke.Security.Permissions.PermissionInfo p = new DotNetNuke.Security.Permissions.PermissionInfo();
                p.ModuleDefID = moduleDefId;
                p.PermissionCode = CMS_CODE;
                p.PermissionKey = "EDITARTICLE";
                p.PermissionName = "Can edit";
                pc.AddPermission(p);
            }
        }
    }

So what i wrong and how can i make it work.

Thanks & Regards

I guess that you miss understand my question. Of course, I know how to create Role. All I want is to create more permission similar to View and Edit. Example: I add 2 more permissions - Moderate Feedback Posts  &  Manage Feedback Lists.  So that I can select which user can view, edit, Moderate Feedback Posts  &  Manage Feedback Lists.  

And how can i make my module has its permissions (Create, Approve, Publish ...).

 

Although I prefer to use PermissionController.GetPermissionsByModuleDefID (ByVal ModuleDefID as Integer) to obtain an ArrayList of the current permissions for the specific ModuleDefID rather than permissions for all ModuleDefID's you're code looks like it should work provided that the ModuleDefID that you are getting is correct. I'm wondering if the code is actually getting called.

• Have you set a break point in the code to see if it is getting hit when the module is installed?
• Am I correct that the UpgradeModule method is located in your BusinessClassController and the name of the controller class properly referenced in your .dnn manifest file?
• Have you checked that following installation of the module, the module definition is showing Upgradable as one of its Supported Features. Do you have at least one xx.xx.xxSqlDataProvider file included in the install package and referenced in the .dnn manifest?
• Since the UpgradeModule method is not directly called from the installation code but rather by an event which has been placed in the EventQueue table and run when the application restarts immediately following the install, you should be able to look at this table to see if the event was created and that it actually ran to completion. The event would have "UpgradeModule" in the ProcessorCommand column and infomation about the BusinessClassController name, DesktopModuleID, etc. in the Attributes column.  If the event was successfully run the IsCompleted column should be True.

For comparison, here's the code I usually use (in VB - sorry). The identifiers Permission.Code, Permission.ModerateKey, etc. are simply constants:

Public Function UpgradeModule(ByVal Version As String) As String Implements DotNetNuke.Entities.Modules.IUpgradeable.UpgradeModule
   Dim Result As String
   Dim dmc As New Entities.Modules.DesktopModuleController
   Dim dmi As Entities.Modules.DesktopModuleInfo = dmc.GetDesktopModuleByModuleName(Consts.ModuleName)
   If dmi Is Nothing Then
           Result = Version & " - " & "failure to obtain DesktopModuleInfo object for ModuleName " & Consts.ModuleName
   Else
       If Version = "04.00.00" Then
            Try
                Dim mdc As New Entities.Modules.Definitions.ModuleDefinitionController
                Dim mdi As Entities.Modules.Definitions.ModuleDefinitionInfo = mdc.GetModuleDefinitionByName(dmi.DesktopModuleID, dmi.FriendlyName)
                Dim ModuleDefID As Integer = mdi.ModuleDefID
                Dim pc As New Permissions.PermissionController
                Dim pi As Permissions.PermissionInfo
                Dim ModulePermissions As ArrayList = pc.GetPermissionsByModuleDefID(ModuleDefID)

                Dim PostPermissionIsDefined, ModeratePermissionIsDefined As Boolean
                For Each pi In ModulePermissions
                    If pi.PermissionCode = Permission.Code And pi.PermissionKey = Permission.PostKey Then PostPermissionIsDefined = True
                    If pi.PermissionCode = Permission.Code And pi.PermissionKey = Permission.ModerateKey Then ModeratePermissionIsDefined = True
                Next

                If Not PostPermissionIsDefined Then
                    pi = New Permissions.PermissionInfo
                    With pi
                       .ModuleDefID = ModuleDefID
                       .PermissionCode = Permission.Code
                       .PermissionKey = Permission.PostKey
                        .PermissionName = Permission.PostName
                    End With
                    pc.AddPermission(pi)
                End If

                If Not ModeratePermissionIsDefined Then
                     pi = New Permissions.PermissionInfo
                     With pi
                        .ModuleDefID = ModuleDefID
                        .PermissionCode = Permission.Code
                        .PermissionKey = Permission.ModerateKey
                        .PermissionName = Permission.ModerateName
                     End With
                     pc.AddPermission(pi)
                End If
                Result = Version & " - " & Permission.Code & " permissions " & Permission.PostName & " and " & Permission.ModerateName & " successfully added"
            Catch ex As Exception
                Result = Version & " - " & "Error in adding " & Permission.Code & " permissions: " & ex.Message
            End Try
       'other code to run here . . .
       End If
    End If
    Return Result
End Function

---

Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner