spAddUpdate_DonationDesignations

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@CurrentUsersID	int	IN
@ClientDonationsID	int	IN
@BackOfficeID	int	IN
@Name	nvarchar(512)	IN
@IsDefault	bit	IN
@BackOfficeIDGUID	uniqueidentifier	IN
@DisplayOrder	int	IN
Definition

Copy


        CREATE   PROCEDURE [dbo].[spAddUpdate_DonationDesignations]
          (
              @PKID                        INT OUTPUT,
              @CurrentUsersID          INT,        
              @ClientDonationsID    INT,
              @BackOfficeID            INT,
              @Name                        NVARCHAR(512),
              @IsDefault                BIT,
              @BackOfficeIDGUID      UNIQUEIDENTIFIER,
          @DisplayOrder            INT
          )
          AS

          IF (@PKID    <=    0) BEGIN

          INSERT INTO dbo.DonationDesignations
          (
              ClientDonationsID,
              BackOfficeID,
              [Name],
              IsDefault,
              BackOfficeIDGUID, 
          DisplayOrder
          )
          VALUES
          (
              @ClientDonationsID,
              @BackOfficeID,
              @Name,
              @IsDefault,
              @BackOfficeIDGUID, 
          @DisplayOrder
          )

          SELECT
              @PKID = @@Identity

          END 
          ELSE BEGIN

              UPDATE dbo.DonationDesignations SET

                  ClientDonationsID    =      @ClientDonationsID,
                  BackOfficeID          =      @BackOfficeID,
                  [Name]                    =      @Name,
                  IsDefault                =      @IsDefault,
                  BackOfficeIDGUID    =      @BackOfficeIDGUID, 
                  DisplayOrder          =      @DisplayOrder

              WHERE    ID    =    @PKID
          END