USP_FAFEVENT_INITIALIZE_PARAMETER

CREATE procedure dbo.USP_FAFEVENT_INITIALIZE_PARAMETER
as
begin

IF NOT EXISTS (select 1 from dbo.RELATIONSHIPTYPECODE R where R.DESCRIPTION = 'FAF Organization') 
    EXEC USP_RELATIONSHIPTYPECODE_CREATEENTRY @DESCRIPTION  ='FAF Organization', @ACTIVE =1;

  --2. create entries in FAFRELATIONSHIPTYPE

DECLARE @CHANGEAGENTID uniqueidentifier,
  @ID uniqueidentifier,
  @NAME nvarchar(100);

EXEC USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID OUTPUT;
set @ID = 'BA63E70D-D049-4285-8C1A-35774C92EBF6';
set @NAME = 'FAF Fundraising Group';

IF NOT EXISTS(Select 1 from GROUPTYPE where ID=@ID)
    INSERT INTO GROUPTYPE (ID,ISACTIVE,CANBEDONOR,INCLUDEMEMBERGIVING,NAME,DESCRIPTION,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED)
    VALUES(@ID,1,0,0,@NAME,'',@CHANGEAGENTID, @CHANGEAGENTID, GETDATE(), GETDATE())

/*initialize the value of EmailAsUserName: use email address as usernames*/
if exists(select * from dbo.Setting where Name = 'EmailAsUserName')
    begin
     if exists(select * from dbo.Setting where Name = 'EmailAsUserName' and Value = 'False')
        update dbo.Setting set Value = 'True', UpdateDate = getdate(),CHANGEDBYID = @CHANGEAGENTID where Name = 'EmailAsUserName'
    end
else
    insert into dbo.Setting(ID, Name, Value, CreateDate, UpdateDate, ADDEDBYID, CHANGEDBYID)
    values (128, 'EmailAsUserName', 'True', getdate(), getdate(), @CHANGEAGENTID, @CHANGEAGENTID)

end