spAddUpdate_FundRaiserTeams

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@BackOfficeID	int	IN
@ReportsToID	int	IN
@FundRaiserID	int	IN
@Name	nvarchar(100)	IN
@CaptainID	int	IN
@FundRaiserPageID	int	IN
@Goal	money	IN
@Dirty	bit	IN
@Independent	bit	IN
@RootFundRaiserID	int	IN
Definition

Copy


            CREATE        PROCEDURE dbo.spAddUpdate_FundRaiserTeams
            (
                @PKID            int output,
                @BackOfficeID        int,
                @ReportsToID         int,
                @FundRaiserID         int,
                @Name            nvarchar(100),
                @CaptainID        int,
                @FundRaiserPageID    int,
                @Goal            money,
                @Dirty            bit,
                @Independent        bit,
                @RootFundRaiserID     int
            )
            AS

                begin transaction
                if (@PKID<=0)
                    begin

                    INSERT INTO FundRaiserTeams
                    (
                        [BackOfficeID]    ,
                        [FundRaiserID]     ,
                        [ReportsToID]     ,
                        [Name]        ,
                        [CaptainID]    ,
                        [FundRaiserPageID],
                        [Goal]        ,
                        [Dirty]        ,
                        [Independent]    ,
                        [RootFundRaiserID]
                    )VALUES(
                        @BackOfficeID        ,
                        @FundRaiserID         ,
                        @ReportsToID         ,
                        @Name            ,
                        @CaptainID        ,
                        @FundRaiserPageID    ,
                        @Goal            ,
                        @Dirty            ,
                        @Independent        ,
                        @RootFundRaiserID
                    )

                    SELECT
                        @PKID = @@Identity

                end else begin

                    UPDATE FundRaiserTeams SET
                        [BackOfficeID]        =@BackOfficeID,
                        [FundRaiserID]        =@FundRaiserID,
                        [ReportsToID]        =@ReportsToID,
                        [Name]            =@Name,
                        [CaptainID]        =@CaptainID,
                        [FundRaiserPageID]    =@FundRaiserPageID,
                        [Goal]            =@Goal,
                        [Dirty]            =@Dirty,
                        [Independent]        =@Independent,
                        [RootFundRaiserID]    =@RootFundRaiserID
                    WHERE ID=@PKID

                end

                commit transaction