USP_DATAFORMTEMPLATE_ADD_ORGANIZATION

The save procedure used by the add dataform template "Organization Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@NAME	nvarchar(100)	IN	Name
@WEBADDRESS	UDT_WEBADDRESS	IN	Website
@PICTURE	varbinary	IN	Image
@PICTURETHUMBNAIL	varbinary	IN
@INDUSTRYCODEID	uniqueidentifier	IN	Industry
@NUMEMPLOYEES	int	IN	No. of employees
@NUMSUBSIDIARIES	int	IN	No. of subsidiary orgs
@PARENTCORPID	uniqueidentifier	IN	Parent org
@ADDRESS_ADDRESSTYPECODEID	uniqueidentifier	IN	Address type
@ADDRESS_DONOTMAIL	bit	IN	Do not send mail to this address
@ADDRESS_COUNTRYID	uniqueidentifier	IN	Country
@ADDRESS_STATEID	uniqueidentifier	IN	State
@ADDRESS_ADDRESSBLOCK	nvarchar(150)	IN	Address
@ADDRESS_CITY	nvarchar(50)	IN	City
@ADDRESS_POSTCODE	nvarchar(12)	IN	ZIP
@PHONE_PHONETYPECODEID	uniqueidentifier	IN	Phone type
@PHONE_NUMBER	nvarchar(100)	IN	Phone number
@SKIP_ADDING_SECURITYGROUPS	bit	IN	Skip adding security groups
@EMAILADDRESS_EMAILADDRESSTYPECODEID	uniqueidentifier	IN	Email type
@EMAILADDRESS_EMAILADDRESS	UDT_EMAILADDRESS	IN	Email address
@OMITFROMVALIDATION	bit	IN	Omit from validation
@CART	nvarchar(10)	IN
@DPC	nvarchar(8)	IN
@LOT	nvarchar(5)	IN
@COUNTYCODEID	uniqueidentifier	IN
@CONGRESSIONALDISTRICTCODEID	uniqueidentifier	IN
@LASTVALIDATIONATTEMPTDATE	datetime	IN
@VALIDATIONMESSAGE	nvarchar(200)	IN
@CERTIFICATIONDATA	int	IN
@ADDRESS_DONOTMAILREASONCODEID	uniqueidentifier	IN	Reason
@ISPRIMARY	bit	IN	This is a primary organization
@SKIP_ADDING_SITES	bit	IN	Skip adding sites
@INFOSOURCECODEID	uniqueidentifier	IN	Information source

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_ORGANIZATION (
                        @ID uniqueidentifier = null output,
                        @CURRENTAPPUSERID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @NAME nvarchar(100),
                        @WEBADDRESS dbo.UDT_WEBADDRESS = '',
                        @PICTURE varbinary(max) = null,
                        @PICTURETHUMBNAIL varbinary(max) = null,
                        @INDUSTRYCODEID uniqueidentifier = null,        
                        @NUMEMPLOYEES int = 0,
                        @NUMSUBSIDIARIES int = 0,
                        @PARENTCORPID uniqueidentifier = null,
                        @ADDRESS_ADDRESSTYPECODEID uniqueidentifier = null,
                        @ADDRESS_DONOTMAIL bit = 0,
                        @ADDRESS_COUNTRYID uniqueidentifier = null,
                        @ADDRESS_STATEID uniqueidentifier = null,
                        @ADDRESS_ADDRESSBLOCK nvarchar(150) = '',
                        @ADDRESS_CITY nvarchar(50) = '',
                        @ADDRESS_POSTCODE nvarchar(12) = '',
                        @PHONE_PHONETYPECODEID uniqueidentifier = null,
                        @PHONE_NUMBER nvarchar(100) = '',
                        @SKIP_ADDING_SECURITYGROUPS bit=0,
                        @EMAILADDRESS_EMAILADDRESSTYPECODEID uniqueidentifier = null,
                        @EMAILADDRESS_EMAILADDRESS dbo.UDT_EMAILADDRESS = '',
                        @OMITFROMVALIDATION bit = 0,
                        @CART nvarchar(10) = '',
                        @DPC nvarchar(8) = '',
                        @LOT nvarchar(5) = '',
                        @COUNTYCODEID uniqueidentifier = null,
                        @CONGRESSIONALDISTRICTCODEID uniqueidentifier = null,
                        @LASTVALIDATIONATTEMPTDATE datetime = null,
                        @VALIDATIONMESSAGE nvarchar(200) = '',
                        @CERTIFICATIONDATA integer = 0,
                        @ADDRESS_DONOTMAILREASONCODEID uniqueidentifier = null,
                        @ISPRIMARY bit = 0,
                        @SKIP_ADDING_SITES bit = 0,
                        @INFOSOURCECODEID uniqueidentifier = null
                    ) as
                        set nocount on;

                        -- Verify the user has permission for the parent org

                        if dbo.UFN_CONSTITUENT_CANAPPUSERMODIFY(@PARENTCORPID, @CURRENTAPPUSERID) = 0
                        begin
                            raiserror ('ERR_PARENTORG_NOACCESS', 13, 1);
                            return 0;
                        end                
                        -- Verify the user has permission for the parent org

                        if dbo.UFN_CONSTITUENT_CANAPPUSERMODIFY(@PARENTCORPID, @CURRENTAPPUSERID) = 0
                        begin
                            raiserror ('ERR_PARENTORG_NOACCESS', 13, 1);
                            return 0;
                        end                        


                        exec dbo.USP_ORGANIZATION_ADD @ID output, 
                                                        @CURRENTAPPUSERID, 
                                                        @CHANGEAGENTID, 
                                                        @NAME,         
                                                        @WEBADDRESS, 
                                                        @PICTURE, 
                                                        @PICTURETHUMBNAIL, 
                                                        @INDUSTRYCODEID,
                                                        @NUMEMPLOYEES,
                                                        @NUMSUBSIDIARIES,
                                                        @PARENTCORPID,
                                                        @ADDRESS_ADDRESSTYPECODEID,
                                                        @ADDRESS_DONOTMAIL,
                                                        @ADDRESS_COUNTRYID,
                                                        @ADDRESS_STATEID,
                                                        @ADDRESS_ADDRESSBLOCK,
                                                        @ADDRESS_CITY,
                                                        @ADDRESS_POSTCODE,
                                                        @PHONE_PHONETYPECODEID,
                                                        @PHONE_NUMBER,
                                                        @SKIP_ADDING_SECURITYGROUPS,
                                                        @EMAILADDRESS_EMAILADDRESSTYPECODEID,
                                                        @EMAILADDRESS_EMAILADDRESS,
                        @OMITFROMVALIDATION,
                                                        @CART,
                                                        @DPC,
                                                        @LOT,
                                                        @COUNTYCODEID,
                                                        @CONGRESSIONALDISTRICTCODEID,
                                                        @LASTVALIDATIONATTEMPTDATE,
                                                        @VALIDATIONMESSAGE,
                                                        @CERTIFICATIONDATA,
                                                        @ADDRESS_DONOTMAILREASONCODEID,
                                                        @ISPRIMARY,
                                                        @SKIP_ADDING_SITES,
                                                        @INFOSOURCECODEID,
                                                        1;

                        return 0;