spAddUpdate_EventCalendarHighlight

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@ShowUpcoming	bit	IN
@ShowRecent	bit	IN
@UpcomingDays	int	IN
@RecentDays	int	IN
@UpcomingTitle	nvarchar(255)	IN
@RecentTitle	nvarchar(255)	IN
@MoreEventURL	nvarchar(255)	IN
@SiteContentID	int	IN
@ShowPrint	bit	IN
@Categories	nvarchar(2048)	IN
Definition

Copy

            CREATE    PROCEDURE [dbo].[spAddUpdate_EventCalendarHighlight]
        (
            @PKID            int output,
            @ShowUpcoming    bit,
            @ShowRecent        bit,
            @UpcomingDays    int,
            @RecentDays        int,
            @UpcomingTitle    nvarchar(255),
            @RecentTitle    nvarchar(255),
            @MoreEventURL    nvarchar(255),
            @SiteContentID    int,
            @ShowPrint        bit,
            @Categories        nvarchar(2048)
        )
        AS
        set nocount on
        begin transaction

        if (@PKID<=0)
            begin

                INSERT INTO dbo.EventCalendarHighlight
                (
                    ShowUpcoming,
                    ShowRecent,
                    UpcomingDays,
                    RecentDays,
                    UpcomingTitle,
                    RecentTitle,
                    MoreEventURL,
                    CreateDate,
                    SiteContentID,
                    ShowPrint,
                    Categories
                )

                VALUES
                (
                    @ShowUpcoming,
                    @ShowRecent,
                    @UpcomingDays,
                    @RecentDays,
                    @UpcomingTitle,
                    @RecentTitle,
                    @MoreEventURL,
                    getutcdate(),
                    @SiteContentID,
                    @ShowPrint,
                    @Categories
                )

                SELECT @PKID = @@Identity

            end 
        else 
            begin

                UPDATE dbo.EventCalendarHighlight SET
                    ShowUpcoming = @ShowUpcoming,
                    ShowRecent = @ShowRecent,
                    UpcomingDays = @UpcomingDays,
                    RecentDays = @RecentDays,
                    UpcomingTitle = @UpcomingTitle,
                    RecentTitle = @RecentTitle,
                    MoreEventURL = @MoreEventURL,
                    SiteContentID = @SiteContentID,
                    ShowPrint = @ShowPrint,
                    Categories = @Categories
                WHERE ID=@PKID

            end

        commit transaction