"UpdateModuleOrder" Stored Procedure

Description:

This stored procedure is used by the TabLayout administration page to set the position of the specified module with respect to other modules in the same tab. The input parameters include the item's primary key (ModuleID), plus position parameters within the tab.

Definition:

    CREATE PROCEDURE UpdateModuleOrder
    (
        @ModuleID     int,
        @ModuleOrder  int,
        @PaneName     nvarchar(50)
    )
    AS

    UPDATE
        Modules

    SET
        ModuleOrder = @ModuleOrder,
        PaneName    = @PaneName

    WHERE
        ModuleID = @ModuleID
        
Database Tables Used:

Modules:  Each record in the Modules table represents a single module instance on a specific tab in the selected portal. The definition for the module type is pulled via the ModuleDefID field from the ModuleDefinitions table. The data for the module is stored in a database table for the selected module type, and indexed by ModuleID.

The primary key in this table is the ModuleID identity field.