spAddUpdate_EventCalendar

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@Name	nvarchar(255)	IN
@SiteContentID	int	IN
@PersonalPageDataID	int	IN
@DefaultDisplayMode	nvarchar(10)	IN
@ManagerRoles	nvarchar(4000)	IN
Definition

Copy


              CREATE    PROCEDURE [dbo].[spAddUpdate_EventCalendar]
            (
            @PKID            int output,
            @Name            nvarchar(255),
            @SiteContentID        int,
            @PersonalPageDataID    int,
            @DefaultDisplayMode nvarchar(10),
            @ManagerRoles nvarchar(4000)
            )
            AS

            begin transaction

            if (@PKID<=0)

            begin

            INSERT INTO dbo.EventCalendar
            (
                       Name,
                CreateDate,
                SiteContentID,
                PersonalPageDataID,
                DefaultDisplayMode,
                ManagerRoles
            )

            VALUES
            (
                       @Name,
                getutcdate(),
                @SiteContentID,
                @PersonalPageDataID,
                @DefaultDisplayMode,
                @ManagerRoles
            )

            SELECT
                @PKID = @@Identity

            end else begin

                UPDATE dbo.EventCalendar SET

                    Name             = @Name,
                    SiteContentID         = @SiteContentID,
                    PersonalPageDataID     = @PersonalPageDataID,
                    DefaultDisplayMode = @DefaultDisplayMode,
                    ManagerRoles = @ManagerRoles
                WHERE ID=@PKID

            end

            commit transaction