USP_DATAFORMTEMPLATE_ADD_FAFEVENTBATCHROW

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@BATCHID	uniqueidentifier	IN
@SEQUENCE	int	IN
@COPYFROMEVENTID	uniqueidentifier	IN
@EVENTPROGRAMID	uniqueidentifier	IN
@NAME	nvarchar(100)	IN
@DESCRIPTION	nvarchar(255)	IN
@STARTDATE	date	IN
@STARTTIME	UDT_HOURMINUTE	IN
@ENDDATE	date	IN
@ENDTIME	UDT_HOURMINUTE	IN
@REPORTYEAR	UDT_YEAR	IN
@EVENTLOCATIONID	uniqueidentifier	IN
@EVENTLOCATIONNAME	nvarchar(100)	IN
@EVENTLOCATIONCONTACTID	uniqueidentifier	IN
@EVENTLOCATIONCONTACTFIRSTNAME	nvarchar(50)	IN
@EVENTLOCATIONCONTACTLASTNAME	nvarchar(100)	IN
@EVENTLOCATIONCONTACTEMAILADDRESS	UDT_EMAILADDRESS	IN
@PREVIOUSYEAREVENTID	uniqueidentifier	IN
@EVENTTYPECODE	tinyint	IN
@EVENTCATEGORYCODEID	uniqueidentifier	IN
@SITEID	uniqueidentifier	IN
@DEFAULTCONSTITUENTSITEID	uniqueidentifier	IN
@LOOKUPEVENTID	nvarchar(100)	IN
@SUPPORTPHONE	nvarchar(100)	IN
@SUPPORTURL	UDT_WEBADDRESS	IN
@EVENTSUPPORTEMAIL	UDT_EMAILADDRESS	IN
@APPEALID	uniqueidentifier	IN
@DESIGNATIONID	uniqueidentifier	IN
@EVENTURL	nvarchar(200)	IN
@TOTALREVENUEGOAL	money	IN
@REGISTRATIONSREVENUEGOAL	money	IN
@PARTICIPANTSREVENUEGOAL	money	IN
@HOUSEHOLDSREVENUEGOAL	money	IN
@TEAMSREVENUEGOAL	money	IN
@COMPANIESREVENUEGOAL	money	IN
@SPONSORSREVENUEGOAL	money	IN
@DONORSRECRUITMENTGOAL	int	IN
@PARTICIPANTSRECRUITMENTGOAL	int	IN
@HOUSEHOLDSRECRUITMENTGOAL	int	IN
@TEAMSRECRUITMENTGOAL	int	IN
@COMPANIESRECRUITMENTGOAL	int	IN
@SPONSORSRECRUITMENTGOAL	int	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_FAFEVENTBATCHROW
(
  @ID uniqueidentifier = null output,
  @BATCHID uniqueidentifier,
  @SEQUENCE int = null,
  @COPYFROMEVENTID uniqueidentifier = null,
  @EVENTPROGRAMID uniqueidentifier = null,
  @NAME nvarchar(100),
  @DESCRIPTION nvarchar(255) = '',
  @STARTDATE date,
  @STARTTIME UDT_HOURMINUTE,
  @ENDDATE date,
  @ENDTIME UDT_HOURMINUTE,
  @REPORTYEAR UDT_YEAR = null,
  @EVENTLOCATIONID uniqueidentifier = null,
  @EVENTLOCATIONNAME nvarchar(100) = '',
  @EVENTLOCATIONCONTACTID uniqueidentifier = null,
  @EVENTLOCATIONCONTACTFIRSTNAME nvarchar(50) = '',
  @EVENTLOCATIONCONTACTLASTNAME nvarchar(100) = '',
  @EVENTLOCATIONCONTACTEMAILADDRESS UDT_EMAILADDRESS = '',
  @PREVIOUSYEAREVENTID uniqueidentifier = null,
  @EVENTTYPECODE tinyint = 0,
  @EVENTCATEGORYCODEID uniqueidentifier = null,
  @SITEID uniqueidentifier = null,
  @DEFAULTCONSTITUENTSITEID uniqueidentifier = null,
  @LOOKUPEVENTID nvarchar(100) = '',
  @SUPPORTPHONE nvarchar(100) = '',
  @SUPPORTURL UDT_WEBADDRESS = '',
  @EVENTSUPPORTEMAIL UDT_EMAILADDRESS = '',
  @APPEALID uniqueidentifier = null,
  @DESIGNATIONID uniqueidentifier = null,
  @EVENTURL nvarchar(200) = '',
  @TOTALREVENUEGOAL money = 0,
  @REGISTRATIONSREVENUEGOAL money = 0,
  @PARTICIPANTSREVENUEGOAL money = 0,
  @HOUSEHOLDSREVENUEGOAL money = 0,
  @TEAMSREVENUEGOAL money = 0,
  @COMPANIESREVENUEGOAL money = 0,
  @SPONSORSREVENUEGOAL money = 0,
  @DONORSRECRUITMENTGOAL int = 0,
  @PARTICIPANTSRECRUITMENTGOAL int = 0,
  @HOUSEHOLDSRECRUITMENTGOAL int = 0,
  @TEAMSRECRUITMENTGOAL int = 0,
  @COMPANIESRECRUITMENTGOAL int = 0,
  @SPONSORSRECRUITMENTGOAL int = 0,
  @CHANGEAGENTID uniqueidentifier = null,
  @CURRENTAPPUSERID uniqueidentifier
)
as

set nocount on;

if @ID is null
    set @ID = newid()

if @CHANGEAGENTID is null  
    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

declare @CURRENTDATE datetime
set @CURRENTDATE = getdate()

declare @DEFAULTSITEID uniqueidentifier,
        @USERDEFAULTSITEID uniqueidentifier,
        @SITEREQUIRED bit

set @SITEREQUIRED = dbo.UFN_SITEREQUIREDFORUSER(@CURRENTAPPUSERID);
select @USERDEFAULTSITEID = SITEID from dbo.APPUSER where APPUSER.ID = @CURRENTAPPUSERID
SET @DEFAULTSITEID = dbo.UFN_APPUSER_DEFAULTSITEFORUSER(@CURRENTAPPUSERID);

if @SITEREQUIRED = 1
begin
  if @USERDEFAULTSITEID is null
    raiserror('You are not assigned to a default site. To continue, contact your administrator and verify your default site setup.', 13,1);
  else
    if @DEFAULTSITEID is null
      raiserror('Your default site is not included in your role?s record access.  To continue, contact your administrator and update your role.', 13,1);
    else if @DEFAULTSITEID <> isnull(@SITEID, '00000000-0000-0000-0000-000000000000')
      raiserror('You did not assign your default site to the event. To continue, edit site security and add your default site.', 13,1)
end

begin
if @EVENTURL is not null
  set @EVENTURL = ltrim(rtrim(@EVENTURL))
  if len(@EVENTURL) =1
    raiserror('EVENTURLLENGTH',13,1)
  else if patindex('%[^0-9a-zA-Z_-]%',@EVENTURL) <> 0 and len(@EVENTURL) > 1
    raiserror('EVENTURLVALID',13,1)
end


begin try

  if not exists (select 1 from dbo.FAFEVENTBATCH (NOLOCK) where ID=@ID)
  begin
    insert into dbo.FAFEVENTBATCH
      (ID, BATCHID, SEQUENCE, COPYFROMEVENTID, EVENTPROGRAMID, NAME, DESCRIPTION, STARTDATE, STARTTIME, ENDDATE, ENDTIME, REPORTYEAR, EVENTLOCATIONID,
       EVENTLOCATIONNAME, EVENTLOCATIONCONTACTID, EVENTLOCATIONCONTACTLASTNAME, EVENTLOCATIONCONTACTFIRSTNAME, PREVIOUSYEAREVENTID, EVENTTYPECODE,
       EVENTCATEGORYCODEID, SITEID, DEFAULTCONSTITUENTSITEID, LOOKUPEVENTID, SUPPORTPHONE, SUPPORTURL, EVENTSUPPORTEMAIL, APPEALID, DESIGNATIONID,
       EVENTURL, TOTALREVENUEGOAL, REGISTRATIONSREVENUEGOAL, EVENTLOCATIONCONTACTEMAILADDRESS,
       PARTICIPANTSREVENUEGOAL, HOUSEHOLDSREVENUEGOAL, TEAMSREVENUEGOAL, COMPANIESREVENUEGOAL, SPONSORSREVENUEGOAL, DONORSRECRUITMENTGOAL,
 PARTICIPANTSRECRUITMENTGOAL, HOUSEHOLDSRECRUITMENTGOAL, TEAMSRECRUITMENTGOAL, COMPANIESRECRUITMENTGOAL, SPONSORSRECRUITMENTGOAL,
       ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
      values
      (@ID, @BATCHID, @SEQUENCE, @COPYFROMEVENTID, @EVENTPROGRAMID, @NAME, @DESCRIPTION, @STARTDATE, @STARTTIME, @ENDDATE, @ENDTIME, @REPORTYEAR, @EVENTLOCATIONID,
       @EVENTLOCATIONNAME, @EVENTLOCATIONCONTACTID, @EVENTLOCATIONCONTACTLASTNAME, @EVENTLOCATIONCONTACTFIRSTNAME, @PREVIOUSYEAREVENTID, @EVENTTYPECODE,
       @EVENTCATEGORYCODEID, @SITEID, @DEFAULTCONSTITUENTSITEID, @LOOKUPEVENTID, @SUPPORTPHONE, @SUPPORTURL, @EVENTSUPPORTEMAIL, @APPEALID, @DESIGNATIONID,
       @EVENTURL, @TOTALREVENUEGOAL, @REGISTRATIONSREVENUEGOAL, @EVENTLOCATIONCONTACTEMAILADDRESS,
       @PARTICIPANTSREVENUEGOAL, @HOUSEHOLDSREVENUEGOAL, @TEAMSREVENUEGOAL, @COMPANIESREVENUEGOAL, @SPONSORSREVENUEGOAL, @DONORSRECRUITMENTGOAL,
       @PARTICIPANTSRECRUITMENTGOAL, @HOUSEHOLDSRECRUITMENTGOAL, @TEAMSRECRUITMENTGOAL, @COMPANIESRECRUITMENTGOAL, @SPONSORSRECRUITMENTGOAL,
       @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)
  end

end try

begin catch
    exec dbo.USP_RAISE_ERROR
    return 1
end catch

return 0