USP_DATAFORMTEMPLATE_EDITLOAD_FAFEVENTBATCHROW

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

  set nocount on;

  set @DATALOADED = 0
  set @TSLONG = 0
  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);
  end

  select
    @DATALOADED = 1,
    @TSLONG = TSLONG,
    @SEQUENCE = SEQUENCE,
    @COPYFROMEVENTID = COPYFROMEVENTID,
    @EVENTPROGRAMID = EVENTPROGRAMID,
    @NAME = NAME,
    @DESCRIPTION = DESCRIPTION,
    @STARTDATE = STARTDATE,
    @STARTTIME = STARTTIME,
    @ENDDATE = ENDDATE,
    @ENDTIME = ENDTIME,
    @REPORTYEAR = REPORTYEAR,
    @EVENTLOCATIONID = EVENTLOCATIONID,
    @EVENTLOCATIONNAME = EVENTLOCATIONNAME,
    @EVENTLOCATIONCONTACTID = EVENTLOCATIONCONTACTID,
    @EVENTLOCATIONCONTACTLASTNAME = EVENTLOCATIONCONTACTLASTNAME,
    @EVENTLOCATIONCONTACTFIRSTNAME = EVENTLOCATIONCONTACTFIRSTNAME,
    @EVENTLOCATIONCONTACTEMAILADDRESS = EVENTLOCATIONCONTACTEMAILADDRESS,
    @PREVIOUSYEAREVENTID = PREVIOUSYEAREVENTID,
    @EVENTTYPECODE = EVENTTYPECODE,
    @EVENTCATEGORYCODEID = EVENTCATEGORYCODEID,
    @SITEID = SITEID,
    @DEFAULTCONSTITUENTSITEID = DEFAULTCONSTITUENTSITEID,
    @LOOKUPEVENTID = LOOKUPEVENTID,
    @SUPPORTPHONE = SUPPORTPHONE,
    @SUPPORTURL = SUPPORTURL,
    @EVENTSUPPORTEMAIL = EVENTSUPPORTEMAIL,
    @APPEALID = APPEALID,
    @DESIGNATIONID = DESIGNATIONID,
    @EVENTURL = EVENTURL,
    @TOTALREVENUEGOAL = TOTALREVENUEGOAL,
    @REGISTRATIONSREVENUEGOAL = REGISTRATIONSREVENUEGOAL,
    @PARTICIPANTSREVENUEGOAL = PARTICIPANTSREVENUEGOAL,
    @HOUSEHOLDSREVENUEGOAL = HOUSEHOLDSREVENUEGOAL,
    @TEAMSREVENUEGOAL = TEAMSREVENUEGOAL,
    @COMPANIESREVENUEGOAL = COMPANIESREVENUEGOAL,
    @SPONSORSREVENUEGOAL = SPONSORSREVENUEGOAL,
    @DONORSRECRUITMENTGOAL = DONORSRECRUITMENTGOAL,
    @PARTICIPANTSRECRUITMENTGOAL = PARTICIPANTSRECRUITMENTGOAL,
    @HOUSEHOLDSRECRUITMENTGOAL = HOUSEHOLDSRECRUITMENTGOAL,
    @TEAMSRECRUITMENTGOAL = TEAMSRECRUITMENTGOAL,
    @COMPANIESRECRUITMENTGOAL = COMPANIESRECRUITMENTGOAL,
    @SPONSORSRECRUITMENTGOAL = SPONSORSRECRUITMENTGOAL
  from dbo.FAFEVENTBATCH
  where ID = @ID

  return 0;