spAddUpdate_CustomPartContentType

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@CurrentUsersID	int	IN
@Name	nvarchar(128)	IN
@DesktopSrc	nvarchar(256)	IN
@EditControl	nvarchar(256)	IN
@ClassName	nvarchar(256)	IN
@Static	bit	IN
@AutoInstall	bit	IN
@Description	nvarchar(500)	IN
@Custom	bit	IN
@RequiresSSL	bit	IN
@ClientId	int	IN
@RealmTypeId	int	IN
@DISPLAYSCRIPT	nvarchar(max)	IN
@EDITORSCRIPT	nvarchar(max)	IN
@INITIALIZEFUNCTION	nvarchar(255)	IN
@ISSCRIPTTYPE	bit	IN

Definition

Copy



    CREATE procedure [dbo].[spAddUpdate_CustomPartContentType]
    (
        @PKID            int output,
      @CurrentUsersID    int,        
        @Name            nvarchar(128),
        @DesktopSrc        nvarchar(256),
        @EditControl    nvarchar(256),
        @ClassName        nvarchar(256),
        @Static            bit,
        @AutoInstall    bit,
        @Description    nvarchar(500) = '''',
        @Custom            bit = 0,
        @RequiresSSL    bit = 0,
        @ClientId        int,
        @RealmTypeId    int,
      @DISPLAYSCRIPT  nvarchar(max) = null,
      @EDITORSCRIPT   nvarchar(max) = null,  
      @INITIALIZEFUNCTION nvarchar(255) = null,
      @ISSCRIPTTYPE   bit = 0
    )
    as
    begin
        set nocount on
        begin tran T1

        declare @sql_error as int
        declare @magicNbr as int

        if (@PKID<=0) 
        begin
            set @magicNbr = 9999
            select @PKID = IsNull(max(ID), @magicNbr) + 1
            from ContentTypes 
            where ID > @magicNbr

            insert into ContentTypes(ID, Name,DesktopSrc, MobileSrc, EditControl, ClassName, Static, AutoInstall,
          Description, Custom, RequiresSSL, RealmTypeId, DISPLAYSCRIPT, EDITORSCRIPT, INITIALIZEFUNCTION, ISSCRIPTTYPE, CANCOPY)
          values(@PKID, @Name, @DesktopSrc, 'MobileModules/SomeModule.ascx', @EditControl, @ClassName, @Static, @AutoInstall,
          @Description, @Custom, @RequiresSSL, @RealmTypeId, @DISPLAYSCRIPT, @EDITORSCRIPT, @INITIALIZEFUNCTION, @ISSCRIPTTYPE, @ISSCRIPTTYPE)

            -------------- eStore Deprecation Code Change Start, Because for now We only need to STOP NEW Installation of eStore ----------------------


          if (@EditControl like '%Store_Shared_Editor.ascx' or @EditControl like '%Store_Master_Editor.ascx')
          begin
              update [dbo].[ContentTypes]
              set        Deprecated = 1,
                      DesktopSrc = 'admin/eStore/eStoreDisplay.ascx',
                      EditControl = 'admin/eStore/eStoreEditor.ascx'
              where    ID = @PKID
          end

          -------------- eStore Deprecation Code Change End ----------------------


          select @sql_error = @@error

            if @sql_error = 0 
            begin
                insert into dbo.ClientContentTypes(ClientsId, ContentTypesId)values(@ClientId, @PKID)
            end
        end else 
        begin
            update ContentTypes SET
          Name = @Name,
          DesktopSrc = @DesktopSrc,
          EditControl = @EditControl,
          ClassName = @ClassName,
          Static = @Static,
          AutoInstall = @AutoInstall,
          Description = @Description, 
          Custom = @Custom, 
          RequiresSSL = @RequiresSSL,
          RealmTypeId = @RealmTypeId,
          DISPLAYSCRIPT = @DISPLAYSCRIPT,
          EDITORSCRIPT = @EDITORSCRIPT,
          INITIALIZEFUNCTION = @INITIALIZEFUNCTION,
          ISSCRIPTTYPE = @ISSCRIPTTYPE
          where ID = @PKID
        end

        if @@error = 0                    
            commit tran T1
        else
            rollback tran T1
    end