spAddUpdate_DonationGivingLevels

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@CurrentUsersID	int	IN
@ClientDonationsID	int	IN
@Name	nvarchar(50)	IN
@Amount	money	IN
@IsAthon	bit	IN
@IsDefault	bit	IN

Definition

Copy



CREATE procedure dbo.spAddUpdate_DonationGivingLevels
    (
    @PKID        int output,
    @CurrentUsersID    int,        
        @ClientDonationsID    int,
        @Name        nvarchar(50),
        @Amount        money,
        @IsAthon    bit,
    @IsDefault bit = False
    )
    AS

    if (@PKID<=0) begin

      INSERT INTO DonationGivingLevels
      (
          ClientDonationsID    ,
          [Name]    ,
          Amount    ,
          IsAthon,
      IsDefault
      )

      VALUES
      (
          @ClientDonationsID    ,
          @Name    ,
          @Amount ,
          @IsAthon,
      @IsDefault
      )

      SELECT
          @PKID = @@Identity

    /*    exec spAuditThis @CurrentUsersID, 1, @Guid, 10*/

    end else begin

        UPDATE DonationGivingLevels SET
            ClientDonationsID=@ClientDonationsID    ,
            [Name]=@Name    ,
            Amount=@Amount    ,
            IsAthon=@IsAthon ,
      IsDefault = @IsDefault
        WHERE ID=@PKID

    /*    exec spAuditThis @CurrentUsersID, 2, @Guid, 10*/

    end