USP_DATAFORMTEMPLATE_EDITLOAD_BBNCEVENTREGISTRATIONBATCHROW_3
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | |
| @DATALOADED | bit | INOUT | |
| @DONORID | uniqueidentifier | INOUT | |
| @LOGGEDINUSER | bit | INOUT | |
| @NETCOMMUNITYTRANSACTIONPROCESSORID | uniqueidentifier | INOUT | |
| @BBNCID | int | INOUT | |
| @BBNCTRANID | int | INOUT | |
| @ADDEDBY | nvarchar(255) | INOUT | |
| @ADDEDBYFORDISPLAY | nvarchar(255) | INOUT | |
| @BBNCDONORNAME | nvarchar(154) | INOUT | |
| @DONORNAME | nvarchar(154) | INOUT | |
| @REGISTRATIONDATE | datetime | INOUT | |
| @DONORINFORMATION | xml | INOUT | |
| @DONORADDRESSINFORMATION | xml | INOUT | |
| @DONORADDRESSUPDATE | bit | INOUT | |
| @DONORADDRESSADD | bit | INOUT | |
| @DONORADDRESSMAKEPRIMARY | bit | INOUT | |
| @DONORADDRESSTYPECODEID | uniqueidentifier | INOUT | |
| @PHONETYPES | xml | INOUT | |
| @REGISTRATIONS | xml | INOUT | |
| @GUESTS | xml | INOUT | |
| @GIFTINFORMATION | xml | INOUT | |
| @ORIGINPAGENAME | nvarchar(1000) | INOUT | |
| @ORIGINPAGEID | int | INOUT | |
| @ORIGINPAGENAMEFORDISPLAY | nvarchar(1000) | INOUT | |
| @ORIGINPAGEIDFORDISPLAY | int | INOUT | |
| @SEQUENCE | int | INOUT | |
| @TSLONG | bigint | INOUT | |
| @DONORADDRESSINFORMATIONALLFIELDS | xml | INOUT | |
| @DONORIDAUTOMATCH | nvarchar(255) | INOUT | |
| @DONORINFORMATIONALLFIELDS | xml | INOUT | |
| @ORIGINALDONORID | uniqueidentifier | INOUT | |
| @DONORSECURITYID | uniqueidentifier | INOUT | |
| @GUESTSECURITYID | uniqueidentifier | INOUT | |
| @DONORSITEID | uniqueidentifier | INOUT | |
| @GUESTSITEID | uniqueidentifier | INOUT | |
| @ADDITIONALDONATION | xml | INOUT | |
| @UNPAIDEVENTREGISTRATIONPAYMENT | bit | INOUT | |
| @PDACCOUNTSYSTEMID | uniqueidentifier | INOUT | |
| @ATTRIBUTECURRENCYID | uniqueidentifier | INOUT | |
| @DONORORGANIZATIONNAME | nvarchar(154) | INOUT | |
| @DONORORGANIZATIONID | uniqueidentifier | INOUT | |
| @DONORORGANIZATIONIDAUTOMATCH | nvarchar(255) | INOUT | |
| @ISORGANIZATION | bit | INOUT | |
| @APPEALCAMPAIGNS | xml | INOUT | |
| @BATCHSEPARATION | xml | INOUT | |
| @TRANSACTIONSOURCE | xml | INOUT | |
| @CONSENT | xml | INOUT |
Definition
Copy
create procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BBNCEVENTREGISTRATIONBATCHROW_3
(
@ID uniqueidentifier,
@DATALOADED bit = 0 output,
@DONORID uniqueidentifier = null output,
@LOGGEDINUSER bit = null output,
@NETCOMMUNITYTRANSACTIONPROCESSORID uniqueidentifier = null output,
@BBNCID int = null output,
@BBNCTRANID int = null output,
@ADDEDBY nvarchar(255) = null output,
@ADDEDBYFORDISPLAY nvarchar(255) = null output,
@BBNCDONORNAME nvarchar(154) = null output,
@DONORNAME nvarchar(154) = null output,
@REGISTRATIONDATE datetime = null output,
@DONORINFORMATION xml = null output,
@DONORADDRESSINFORMATION xml = null output,
@DONORADDRESSUPDATE bit = null output,
@DONORADDRESSADD bit = null output,
@DONORADDRESSMAKEPRIMARY bit = null output,
@DONORADDRESSTYPECODEID uniqueidentifier = null output,
@PHONETYPES xml = null output,
@REGISTRATIONS xml = null output,
@GUESTS xml = null output,
@GIFTINFORMATION xml = null output,
@ORIGINPAGENAME nvarchar(1000) = null output,
@ORIGINPAGEID int = null output,
@ORIGINPAGENAMEFORDISPLAY nvarchar(1000) = null output,
@ORIGINPAGEIDFORDISPLAY int = null output,
@SEQUENCE int = null output,
@TSLONG bigint = 0 output,
@DONORADDRESSINFORMATIONALLFIELDS xml = null output,
@DONORIDAUTOMATCH nvarchar(255) = null output,
@DONORINFORMATIONALLFIELDS xml = null output,
@ORIGINALDONORID uniqueidentifier = null output,
@DONORSECURITYID uniqueidentifier = null output,
@GUESTSECURITYID uniqueidentifier = null output,
@DONORSITEID uniqueidentifier = null output,
@GUESTSITEID uniqueidentifier = null output,
@ADDITIONALDONATION xml = null output,
@UNPAIDEVENTREGISTRATIONPAYMENT bit = null output,
@PDACCOUNTSYSTEMID uniqueidentifier = null output,
@ATTRIBUTECURRENCYID uniqueidentifier = null output,
@DONORORGANIZATIONNAME nvarchar(154) = null output,
@DONORORGANIZATIONID uniqueidentifier = null output,
@DONORORGANIZATIONIDAUTOMATCH nvarchar(255) = null output,
@ISORGANIZATION bit = null output,
@APPEALCAMPAIGNS xml = null output,
@BATCHSEPARATION xml = null output,
@TRANSACTIONSOURCE xml = null output,
@CONSENT xml = null output
)
as
set nocount on;
set @DATALOADED = 0;
set @TSLONG = 0;
select @ISORGANIZATION = cast(isnull([BATCHBBNCEVENTREGISTRATION].GIFTINFORMATION.exist('/GIFTINFORMATIONS/GIFTINFORMATION[ITEM[FIELDKEY/text() = "ISCORPORATE" and NEWVALUE/text() = "True"]]'),0) as bit)
from
dbo.BATCHBBNCEVENTREGISTRATION
where
BATCHBBNCEVENTREGISTRATION.ID = @ID;
select
@DATALOADED = 1,
@DONORID = case when @ISORGANIZATION =0 then [DONORID] else Null end,
@ORIGINALDONORID = [DONORID],
@LOGGEDINUSER = [LOGGEDINUSER],
@NETCOMMUNITYTRANSACTIONPROCESSORID = [NETCOMMUNITYTRANSACTIONPROCESSORID],
@BBNCID = [BBNCID],
@BBNCTRANID = [BBNCTRANID],
@ADDEDBY = [ADDEDBY],
@ADDEDBYFORDISPLAY = [ADDEDBY],
@BBNCDONORNAME = [BBNCDONORNAME],
@DONORNAME = case when @ISORGANIZATION =0 then case when [DONORID] is null then [BBNCDONORNAME] else dbo.UFN_CONSTITUENT_BUILDNAME([DONORID]) end else Null end,
@REGISTRATIONDATE = [REGISTRATIONDATE],
@DONORINFORMATION = case when DONORINFORMATION.exist('/DONORINFORMATIONS') = 1
then
case when DONORINFORMATION.exist('/DONORINFORMATIONS/DONORINFORMATION') = 1
then DONORINFORMATION.query('/DONORINFORMATIONS/DONORINFORMATION')
else
null
end
else
DONORINFORMATION
end,
@DONORINFORMATIONALLFIELDS = [DONORINFORMATIONALLFIELDS],
@DONORADDRESSINFORMATION = [DONORADDRESSINFORMATION],
@DONORADDRESSINFORMATIONALLFIELDS = [DONORADDRESSINFORMATIONALLFIELDS],
@DONORADDRESSUPDATE = [DONORADDRESSUPDATE],
@DONORADDRESSADD = [DONORADDRESSADD],
@DONORADDRESSMAKEPRIMARY = [DONORADDRESSMAKEPRIMARY],
@DONORADDRESSTYPECODEID = [DONORADDRESSTYPECODEID],
@PHONETYPES = [PHONETYPES],
@REGISTRATIONS = [REGISTRATIONS],
@GUESTS = [GUESTS],
@GIFTINFORMATION = case when GIFTINFORMATION.exist('/GIFTINFORMATIONS') = 1
then
case when GIFTINFORMATION.exist('/GIFTINFORMATIONS/GIFTINFORMATION') = 1
then GIFTINFORMATION.query('/GIFTINFORMATIONS/GIFTINFORMATION')
else
null
end
else
GIFTINFORMATION
end,
@ORIGINPAGENAME = [ORIGINPAGENAME],
@ORIGINPAGEID = [ORIGINPAGEID],
@ORIGINPAGENAMEFORDISPLAY = [ORIGINPAGENAME],
@ORIGINPAGEIDFORDISPLAY = [ORIGINPAGEID],
@DONORIDAUTOMATCH = case when @ISORGANIZATION =0 then [DONORIDAUTOMATCH] else Null end,
@DONORSECURITYID = [DONORSECURITYID],
@GUESTSECURITYID = [GUESTSECURITYID],
@DONORSITEID = [DONORSITEID],
@GUESTSITEID = [GUESTSITEID],
@ADDITIONALDONATION = [ADDITIONALDONATION],
@UNPAIDEVENTREGISTRATIONPAYMENT = [UNPAIDEVENTREGISTRATIONPAYMENT],
@SEQUENCE = [BATCHBBNCEVENTREGISTRATION].[SEQUENCE],
@TSLONG = [BATCHBBNCEVENTREGISTRATION].[TSLONG],
@PDACCOUNTSYSTEMID = [BATCHBBNCEVENTREGISTRATION].[PDACCOUNTSYSTEMID],
@ATTRIBUTECURRENCYID = [BATCHBBNCEVENTREGISTRATION].[ATTRIBUTECURRENCYID],
@DONORORGANIZATIONID = case when @ISORGANIZATION =1 then [DONORID] else Null end,
@DONORORGANIZATIONNAME =case when @ISORGANIZATION =1 then case when [DONORID] is null then [BBNCDONORNAME] else dbo.UFN_CONSTITUENT_BUILDNAME([DONORID]) end else Null end,
@DONORORGANIZATIONIDAUTOMATCH = case when @ISORGANIZATION =1 then [DONORIDAUTOMATCH] else Null end,
@APPEALCAMPAIGNS = case when GIFTINFORMATION.exist('/GIFTINFORMATIONS') = 1
then
case when GIFTINFORMATION.exist('/GIFTINFORMATIONS/APPEALCAMPAIGNS') = 1
then GIFTINFORMATION.query('/GIFTINFORMATIONS/APPEALCAMPAIGNS')
else
null
end
else
null
end,
@BATCHSEPARATION = case when DONORINFORMATION.exist('/DONORINFORMATIONS') = 1
then
case when DONORINFORMATION.exist('/DONORINFORMATIONS/BATCHSEPARATION') = 1
then DONORINFORMATION.query('/DONORINFORMATIONS/BATCHSEPARATION')
else
null
end
else
null
end,
@TRANSACTIONSOURCE = case when DONORINFORMATION.exist('/DONORINFORMATIONS') = 1
then
case when DONORINFORMATION.exist('/DONORINFORMATIONS/TRANSACTIONSOURCE') = 1
then DONORINFORMATION.query('/DONORINFORMATIONS/TRANSACTIONSOURCE')
else
null
end
else
null
end,
@CONSENT= CONSENT
from
dbo.BATCHBBNCEVENTREGISTRATION
where
BATCHBBNCEVENTREGISTRATION.ID = @ID;
exec dbo.USP_BBNC_DECRYPTGIFTDATA @GIFTINFORMATION = @GIFTINFORMATION output, @KEYISALREADYOPEN = 1;
return 0;