USP_SIMPLEDATALIST_DEFAULTMATCHINGGIFTCONDITION
This simple datalist returns the default matching gift condition for the constituent based on the relationship to the matching gift organization.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ORGANIZATIONID | uniqueidentifier | IN | ORGANIZATIONID |
| @CONSTITUENTID | uniqueidentifier | IN | CONSTITUENTID |
Definition
Copy
CREATE procedure dbo.USP_SIMPLEDATALIST_DEFAULTMATCHINGGIFTCONDITION
(
@ORGANIZATIONID uniqueidentifier = null,
@CONSTITUENTID uniqueidentifier = null
)
as
set nocount on;
declare @COUNT int
declare @RELATIONSHIPTYPE uniqueidentifier
select @COUNT = count(ID) from dbo.MATCHINGGIFTCONDITION where ORGANIZATIONID = @ORGANIZATIONID;
if @COUNT = 1
begin
select
ID as VALUE,
dbo.UFN_MATCHINGGIFTCONDITIONTYPECODE_GETDESCRIPTION(MATCHINGGIFTCONDITIONTYPECODEID) as LABEL
from
dbo.MATCHINGGIFTCONDITION
where
ORGANIZATIONID = @ORGANIZATIONID;
end
else
begin
set @RELATIONSHIPTYPE = null
select @RELATIONSHIPTYPE = RELATIONSHIPTYPECODEID from dbo.RELATIONSHIP where RELATIONSHIPCONSTITUENTID = @CONSTITUENTID and RECIPROCALCONSTITUENTID = @ORGANIZATIONID and ISMATCHINGGIFTRELATIONSHIP = 1;
if @RELATIONSHIPTYPE is not null begin
select
MATCHINGGIFTCONDITION.ID as VALUE,
dbo.UFN_MATCHINGGIFTCONDITIONTYPECODE_GETDESCRIPTION(MATCHINGGIFTCONDITION.MATCHINGGIFTCONDITIONTYPECODEID) as LABEL
from
dbo.MATCHINGGIFTCONDITION
inner join dbo.MATCHINGGIFTCONDITIONRELATIONSHIP on MATCHINGGIFTCONDITIONRELATIONSHIP.MATCHINGGIFTCONDITIONID = MATCHINGGIFTCONDITION.ID
where
MATCHINGGIFTCONDITIONRELATIONSHIP.RELATIONSHIPTYPECODEID = @RELATIONSHIPTYPE;
end
end