USP_DATAFORMTEMPLATE_ADD_CMSSITESETTING_BULK

The save procedure used by the add dataform template "CMS Site Setting Bulk Add Data Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CLIENTSITESID	int	IN	Input parameter indicating the context ID for the record being added.
@XMLDATA	xml	IN	XML Data

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_CMSSITESETTING_BULK
(
    @ID uniqueidentifier = null output,
    @CLIENTSITESID int,
    @XMLDATA xml = null
)
as

set nocount on;

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


begin try

    begin transaction
        delete from dbo.CMSSITESETTING where CLIENTSITESID = @CLIENTSITESID

    insert into dbo.CMSSITESETTING ([ENUMID],[SETTING],[CLIENTSITESID],[VALUE])
    select 
    SSTS.SST.value('@ENUMID', 'int'),
    SSTS.SST.value('@SETTING', 'nvarchar(255)'),
    @CLIENTSITESID,
    SSTS.SST.value('@VALUE', 'nvarchar(1024)')
    from @XMLDATA.nodes('/SITESETTINGS/SITESETTING') SSTS(SST)
    commit

end try

begin catch
    exec dbo.USP_RAISE_ERROR
    return 1
end catch

return 0