spAdd_CustomPDParts

Parameters

Parameter	Parameter Type	Mode
@Name	nvarchar(128)	IN
@DestktopSrc	nvarchar(256)	IN
@EditControl	nvarchar(256)	IN
@RequiresSSL	bit	IN
@Description	nvarchar(500)	IN
@CanCopy	bit	IN
@RealmTypeID	int	IN
@UniqueContent	bit	IN

Definition

Copy



        CREATE PROCEDURE dbo.spAdd_CustomPDParts
        (
             @Name            nvarchar(128),
            @DestktopSrc    nvarchar(256),
            @EditControl    nvarchar(256),
            @RequiresSSL    bit,
            @Description    nvarchar(500),
            @CanCopy        bit,
            @RealmTypeID    int,
            @UniqueContent  bit
        )
        AS

        declare @PKID int
        select @PKID=coalesce(max(id)+1, 10001) from contentTypes where id>10000

        insert into dbo.ContentTypes (ID, Name, DesktopSrc, EditControl, MobileSrc, RequiresSSL, Custom, CustomPD, CanCopy, [Description], RealmTypeID,UniqueContent) 
            values (@PKID, @Name, @DestktopSrc, @EditControl, 'MobileModules/SomeModule.ascx', @RequiresSSL, 1, 1, @CanCopy, @Description, @RealmTypeID,@UniqueContent)

        insert into dbo.ClientContentTypes (ClientsID, ContentTypesID) values (1, @PKID)

        return @PKID