USP_DATAFORMTEMPLATE_EDIT_RECEIPTPREFERENCE
The save procedure used by the edit dataform template "Receipt Preference Edit Form".
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CHANGEAGENTID | uniqueidentifier | IN | Input parameter indicating the ID of the change agent invoking the procedure. |
| @RECURRINGGIFTPAYMENTPREFERENCECODE | tinyint | IN | Recurring gift payments |
| @PLEDGEPAYMENTPREFERENCECODE | tinyint | IN | Pledge payments |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_RECEIPTPREFERENCE (
@CHANGEAGENTID uniqueidentifier = null,
@RECURRINGGIFTPAYMENTPREFERENCECODE tinyint,
@PLEDGEPAYMENTPREFERENCECODE tinyint
)
as
set nocount on;
declare @CURRENTDATE datetime;
set @CURRENTDATE = getdate();
if @CHANGEAGENTID is null
exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;
begin try
if (select count(ID) from dbo.RECEIPTPREFERENCEINFO) > 0
begin
update
dbo.RECEIPTPREFERENCEINFO
set
RECURRINGGIFTPAYMENTPREFERENCECODE = @RECURRINGGIFTPAYMENTPREFERENCECODE,
PLEDGEPAYMENTPREFERENCECODE = @PLEDGEPAYMENTPREFERENCECODE,
DATECHANGED = @CURRENTDATE,
CHANGEDBYID = @CHANGEAGENTID;
end
else
begin
insert into dbo.RECEIPTPREFERENCEINFO(ID,RECURRINGGIFTPAYMENTPREFERENCECODE,PLEDGEPAYMENTPREFERENCECODE,DATEADDED,DATECHANGED,ADDEDBYID,CHANGEDBYID)
values(newid(),@RECURRINGGIFTPAYMENTPREFERENCECODE,@PLEDGEPAYMENTPREFERENCECODE,@CURRENTDATE,@CURRENTDATE,@CHANGEAGENTID,@CHANGEAGENTID);
end
end try
begin catch
exec dbo.USP_RAISE_ERROR;
return 1;
end catch
return 0;