spAddUpdate_FundRaiserSolicitors

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@BackOfficeID	int	IN
@ClientUsersID	int	IN
@FundRaiserID	int	IN
@TeamID	int	IN
@ReportsToID	int	IN
@Goal	money	IN
@RecruiterID	int	IN
@Inactive	bit	IN
@Dirty	bit	IN
@ConfirmationCode	uniqueidentifier	IN
@AthonUnits	int	IN
@AthonLocked	bit	IN
@Personalization	ntext	IN
@RootFundraiserID	int	IN
@GoalCurrencyISO4217	varchar(3)	IN
Definition

Copy

        CREATE procedure [dbo].[spAddUpdate_FundRaiserSolicitors]
        (
            @PKID    int output,
            @BackOfficeID    int,
            @ClientUsersID     int,
            @FundRaiserID     int,
            @TeamID         int,
            @ReportsToID     int,
            @Goal            money,
            @RecruiterID    int,
            @Inactive        bit,
            @Dirty            bit,
            @ConfirmationCode    uniqueidentifier,
            @AthonUnits        int,
            @AthonLocked    bit,
            @Personalization    ntext,
            @RootFundraiserID    int,
            @GoalCurrencyISO4217 varchar(3)
        )
        as
            begin transaction
            if (@PKID<=0)
                begin

                insert into FundRaiserSolicitors
                (
                    [BackOfficeID]        ,
                    [ClientUsersID]        ,
                    [FundRaiserID]         ,
                    [TeamID]         ,
                    [ReportsToID]         ,
                    [Goal]            ,
                    [RecruiterID]        ,
                    [Inactive]        ,
                    [Dirty]            ,
                    [ConfirmationCode]    ,
                    [AthonUnits]        ,
                    [AthonLocked]        ,
                    [Personalization]    ,
                    [RootFundraiserID]  ,
                    [GoalCurrencyISO4217]

                )values(
                    @BackOfficeID        ,
                    @ClientUsersID        ,
                    @FundRaiserID         ,
                    @TeamID         ,
                    @ReportsToID         ,
                    @Goal            ,
                    @RecruiterID        ,
                    @Inactive        ,
                    @Dirty            ,
                    @ConfirmationCode    ,
                    @AthonUnits        ,
                    @AthonLocked        ,
                    @Personalization    ,
                    @RootFundraiserID   ,
                    @GoalCurrencyISO4217
                )

                select
                    @PKID = @@Identity
                -- sec 2/8/07
                -- set RootFundraiserID for Solicitor
                -- UPDATE dbo.FundraiserSolicitors
                -- SET RootFundraiserID = dbo.fnGetFundRaiserIDForSolicitor(@PKID)

            end else begin

                update FundRaiserSolicitors set
                    BackOfficeID=@BackOfficeID,
                    ClientUsersID=@ClientUsersID,
                    FundRaiserID=@FundRaiserID,
                    TeamID=@TeamID,
                    ReportsToID=@ReportsToID,
                    Goal=@Goal,
                    RecruiterID=@RecruiterID,
                    Inactive=@Inactive,
                    Dirty=@Dirty,
                    ConfirmationCode=@ConfirmationCode,
                    AthonUnits=@AthonUnits,
                    AthonLocked=@AthonLocked,
                    Personalization=@Personalization,
                    RootFundraiserID=@RootFundraiserID
                where ID=@PKID

            end

            commit transaction