spAddUpdate_JobBoards

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@JobBoardName	nvarchar(510)	IN
@Guid	uniqueidentifier	IN
@SiteContentID	int	IN
@LegendText	nvarchar(510)	IN
@SearchLinkText	nvarchar(300)	IN
@SearchLegendText	nvarchar(510)	IN
@PostLinkText	nvarchar(300)	IN
@PostLegendText	nvarchar(510)	IN
@PostJobLegend	nvarchar(510)	IN
@RequiresApproval	bit	IN
Definition

Copy


CREATE  PROCEDURE dbo.spAddUpdate_JobBoards
        (
            @PKID                int output        ,
            @JobBoardName        nvarchar(510)    ,
            @Guid                uniqueidentifier,
            @SiteContentID        int                ,
            @LegendText            nvarchar(510)    ,
            @SearchLinkText        nvarchar(300)    ,
            @SearchLegendText    nvarchar(510)    ,
            @PostLinkText        nvarchar(300)    ,
            @PostLegendText        nvarchar(510)    ,
            @PostJobLegend        nvarchar(510)    ,
            @RequiresApproval    bit
        )
        AS

        begin transaction

        if (@PKID<=0)

        begin

            INSERT INTO JobBoards
            (
            JobBoardName        ,
            Guid                ,
            SiteContentID        ,
            LegendText            ,
            SearchLinkText        ,
            SearchLegendText    ,
            PostLinkText        ,
            PostLegendText        ,
            PostJobLegend        ,
            RequiresApproval
            )

            VALUES
            (
            @JobBoardName        ,
            @Guid                ,
            @SiteContentID        ,
            @LegendText            ,
            @SearchLinkText        ,
            @SearchLegendText    ,
            @PostLinkText        ,
            @PostLegendText        ,
            @PostJobLegend        ,
            @RequiresApproval
            )

            SELECT @PKID = @@Identity


        end 
        else 
        begin

            UPDATE JobBoards SET
                JobBoardName        =@JobBoardName        ,
                Guid                =@Guid                ,
                SiteContentID        =@SiteContentID        ,
                LegendText            =@LegendText        ,
                SearchLinkText        =@SearchLinkText    ,
                SearchLegendText    =@SearchLegendText    ,
                PostLinkText        =@PostLinkText        ,
                PostLegendText        =@PostLegendText    ,
                PostJobLegend        =@PostJobLegend        ,
                RequiresApproval    =@RequiresApproval

            WHERE ID=@PKID

        end

        commit transaction