spAddUpdate_DonationSources
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PKID | int | INOUT | |
| @CurrentUsersID | int | IN | |
| @ClientDonationsID | int | IN | |
| @BackOfficeID | int | IN | |
| @Name | nvarchar(50) | IN | |
| @IsDefault | bit | IN | |
| @ShowInList | bit | IN |
Definition
Copy
CREATE PROCEDURE [dbo].[spAddUpdate_DonationSources]
(
@PKID int output,
@CurrentUsersID int,
@ClientDonationsID int,
@BackOfficeID int,
@Name nvarchar(50),
@IsDefault bit,
@ShowInList bit
)
AS
if (@PKID<=0) begin
INSERT INTO DonationSources
(
ClientDonationsID ,
BackOfficeID ,
[Name] ,
IsDefault,
ShowInList
)
VALUES
(
@ClientDonationsID ,
@BackOfficeID ,
@Name ,
@IsDefault,
@ShowInList
)
SELECT
@PKID = @@Identity
end else begin
UPDATE DonationSources SET
ClientDonationsID=@ClientDonationsID ,
BackOfficeID=@BackOfficeID ,
[Name]=@Name ,
IsDefault=@IsDefault,
ShowInList = @ShowInList
WHERE ID=@PKID
end