USP_DATAFORMTEMPLATE_ADD_RE7INTEGRATIONGIVINGSUMMARYCOMMIT
The save procedure used by the add dataform template "RE7 Integration Giving Summary Commit Add Form".
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | INOUT | The output parameter indicating the ID of the record added. |
| @CHANGEAGENTID | uniqueidentifier | IN | Input parameter indicating the ID of the change agent invoking the procedure. |
| @CONSTITUENTID | uniqueidentifier | IN | Constituent |
| @VALIDATEONLY | bit | IN | Validate only |
| @FIRSTGIFTAMOUNT | money | IN | First gift amount |
| @FIRSTGIFTDATE | datetime | IN | First gift date |
| @LATESTGIFTAMOUNT | money | IN | Latest gift amount |
| @LATESTGIFTDATE | datetime | IN | Latest gift date |
| @LARGESTGIFTAMOUNT | money | IN | Largest gift amount |
| @LARGESTGIFTDATE | datetime | IN | Largest gift date |
| @TOTALGIFTSGIVEN | int | IN | Total number of gifts |
| @TOTALGIFTAMOUNT | money | IN | Total giving |
| @FIRSTGIFTTYPE | nvarchar(100) | IN | First gift type |
| @FIRSTGIFTDESIGNATION | nvarchar(100) | IN | First gift designation |
| @LARGESTGIFTTYPE | nvarchar(100) | IN | Largest gift type |
| @LARGESTGIFTDESIGNATION | nvarchar(100) | IN | Largest gift designation |
| @LATESTGIFTTYPE | nvarchar(100) | IN | Latest gift type |
| @LATESTGIFTDESIGNATION | nvarchar(100) | IN | Latest gift designation |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_RE7INTEGRATIONGIVINGSUMMARYCOMMIT(
@ID uniqueidentifier = null output,
@CHANGEAGENTID uniqueidentifier = null,
@CONSTITUENTID uniqueidentifier,
@VALIDATEONLY bit = null,
@FIRSTGIFTAMOUNT money = 0,
@FIRSTGIFTDATE datetime = null,
@LATESTGIFTAMOUNT money = 0,
@LATESTGIFTDATE datetime = null,
@LARGESTGIFTAMOUNT money = 0,
@LARGESTGIFTDATE datetime = null,
@TOTALGIFTSGIVEN int = 0,
@TOTALGIFTAMOUNT money = 0,
@FIRSTGIFTTYPE nvarchar(100) = '',
@FIRSTGIFTDESIGNATION nvarchar(100) = '',
@LARGESTGIFTTYPE nvarchar(100) = '',
@LARGESTGIFTDESIGNATION nvarchar(100) = '',
@LATESTGIFTTYPE nvarchar(100) = '',
@LATESTGIFTDESIGNATION nvarchar(100) = ''
) as
set nocount on;
declare @CURRENTDATE datetime;
set @CURRENTDATE = getdate();
if @CHANGEAGENTID is null
exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output
begin try
if @VALIDATEONLY = 0
begin
if (exists(select 1 from dbo.RE7INTEGRATIONGIVINGSUMMARY where ID=@CONSTITUENTID)) begin
update dbo.RE7INTEGRATIONGIVINGSUMMARY set
FIRSTGIFTAMOUNT = @FIRSTGIFTAMOUNT,
FIRSTGIFTDATE = @FIRSTGIFTDATE,
LATESTGIFTAMOUNT = @LATESTGIFTAMOUNT,
LATESTGIFTDATE = @LATESTGIFTDATE,
LARGESTGIFTAMOUNT = @LARGESTGIFTAMOUNT,
LARGESTGIFTDATE = @LARGESTGIFTDATE,
TOTALGIFTSGIVEN = @TOTALGIFTSGIVEN,
TOTALGIFTAMOUNT = @TOTALGIFTAMOUNT,
FIRSTGIFTTYPE = @FIRSTGIFTTYPE,
FIRSTGIFTDESIGNATION = @FIRSTGIFTDESIGNATION,
LARGESTGIFTTYPE = @LARGESTGIFTTYPE,
LARGESTGIFTDESIGNATION = @LARGESTGIFTDESIGNATION,
LATESTGIFTTYPE = @LATESTGIFTTYPE,
LATESTGIFTDESIGNATION = @LATESTGIFTDESIGNATION,
DATECHANGED = @CURRENTDATE,
CHANGEDBYID = @CHANGEAGENTID
where
ID = @CONSTITUENTID;
end
else begin
insert into dbo.RE7INTEGRATIONGIVINGSUMMARY
(
ID,
FIRSTGIFTAMOUNT,
FIRSTGIFTDATE,
LATESTGIFTAMOUNT,
LATESTGIFTDATE,
LARGESTGIFTAMOUNT,
LARGESTGIFTDATE,
TOTALGIFTSGIVEN,
TOTALGIFTAMOUNT,
FIRSTGIFTTYPE,
FIRSTGIFTDESIGNATION,
LARGESTGIFTTYPE,
LARGESTGIFTDESIGNATION,
LATESTGIFTTYPE,
LATESTGIFTDESIGNATION,
ADDEDBYID,
CHANGEDBYID,
DATEADDED,
DATECHANGED
)
values
(
@CONSTITUENTID,
@FIRSTGIFTAMOUNT,
@FIRSTGIFTDATE,
@LATESTGIFTAMOUNT,
@LATESTGIFTDATE,
@LARGESTGIFTAMOUNT,
@LARGESTGIFTDATE,
@TOTALGIFTSGIVEN,
@TOTALGIFTAMOUNT,
@FIRSTGIFTTYPE,
@FIRSTGIFTDESIGNATION,
@LARGESTGIFTTYPE,
@LARGESTGIFTDESIGNATION,
@LATESTGIFTTYPE,
@LATESTGIFTDESIGNATION,
@CHANGEAGENTID,
@CHANGEAGENTID,
@CURRENTDATE,
@CURRENTDATE
);
end
set @ID = @CONSTITUENTID;
exec dbo.USP_WEALTHCAPACITY_UPDATE @CONSTITUENTID, @CHANGEAGENTID;
end;
end try
begin catch
exec dbo.USP_RAISE_ERROR;
return 1;
end catch
return 0;