"DeleteModule" Stored Procedure

This stored procedure deletes the selected module data from the correlating module tables in the database.  The actual module configuration itself is stored in the configuration file, PortalCfg.xml.  The input parameter is ModuleID, the unique identifier for each of the tables.

    
   CREATE  PROCEDURE Portal_DeleteModule
   (
       @ModuleID       int
   )
   AS
         DELETE FROM Portal_Announcements
         WHERE ModuleID = @ModuleID
   
         DELETE FROM Portal_Contacts
         WHERE ModuleID = @ModuleID
   
         DELETE FROM Portal_Discussion
         WHERE ModuleID = @ModuleID
   
         DELETE FROM Portal_Documents
         WHERE ModuleID = @ModuleID
   
         DELETE FROM Portal_Events
         WHERE ModuleID = @ModuleID
   
         DELETE FROM Portal_HTMLText
         WHERE ModuleID = @ModuleID
   
         DELETE FROM Portal_Links
         WHERE ModuleID = @ModuleID
        

Module:  Each Module element in the configuration file 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 element, again in the xml configuration file.

The data stored within each module is stored in separate database tables for the selected module type, and indexed by ModuleID.