USP_FAF_GROUPDATA_ADD

Add a Groupdata record for FAFteam

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@GROUPTYPEID	uniqueidentifier	IN
@NAME	nvarchar(100)	IN
@DESCRIPTION	nvarchar(300)	IN
@WEBADDRESS	UDT_WEBADDRESS	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.USP_FAF_GROUPDATA_ADD
(
        @ID uniqueidentifier output,
        @GROUPTYPEID uniqueidentifier,
        @NAME nvarchar(100) = null,
        @DESCRIPTION nvarchar(300) = '',
        @WEBADDRESS dbo.UDT_WEBADDRESS = '',
        @CHANGEAGENTID uniqueidentifier = null
)
as
begin
            declare @CURRENTDATE datetime;
            set @CURRENTDATE = getdate();

        begin try

     -- create the constituent record for the group

              insert into dbo.CONSTITUENT
              (
                ID, 
                ISGROUP, 
                KEYNAME, 
                   WEBADDRESS,
                ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED
              )
              values
              (
                @ID, 
                1, 
                @NAME, 
                   @WEBADDRESS,
                @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE
              );

        -- create the group record

              insert into dbo.GROUPDATA
              (
                ID,
                GROUPTYPECODE,
                GROUPTYPEID,
                STARTDATE,
                DESCRIPTION,
                ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED
              )
              values
              (
                @ID,
                1,
                @GROUPTYPEID,
                null,
                @DESCRIPTION,
                @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE
              )

        end try
        begin catch
            exec dbo.USP_RAISE_ERROR
            return 1
        end catch

return 0;
end