USP_DATAFORMTEMPLATE_EDIT_MICROSITE_THEME
The save procedure used by the edit dataform template "Microsite Setting Theme Edit Data Form".
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CHANGEAGENTID | uniqueidentifier | IN | Input parameter indicating the ID of the change agent invoking the procedure. |
| @SELECTEDTHEMEID | uniqueidentifier | IN | Selected them ID |
| @CLIENTSITESID | int | IN | Client site ID |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_MICROSITE_THEME (
@CHANGEAGENTID uniqueidentifier = null,
@SELECTEDTHEMEID uniqueidentifier,
@CLIENTSITESID integer
)
as
set nocount on;
if @CHANGEAGENTID is null
exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output
declare @CURRENTDATE datetime
set @CURRENTDATE = getdate()
begin try
-- handle updating the data
declare @VALUE nvarchar(36) = convert(nvarchar(36), @SELECTEDTHEMEID)
if exists(select 1 from dbo.[MICROSITESETTING] where [MICROSITESETTING] = 0)
begin
update dbo.[MICROSITESETTING]
set
[VALUE] = @VALUE,
[CHANGEDBYID] = @CHANGEAGENTID,
[DATECHANGED] = @CURRENTDATE
where [MICROSITESETTING] = 0
end
else
begin
insert dbo.[MICROSITESETTING] (
ID,
MICROSITESETTING,
VALUE,
ADDEDBYID,
CHANGEDBYID,
DATEADDED,
DATECHANGED
)
values (
newid(),
0,
@VALUE,
@CHANGEAGENTID,
@CHANGEAGENTID,
@CURRENTDATE,
@CURRENTDATE
)
end
end try
begin catch
exec dbo.USP_RAISE_ERROR
return 1
end catch
return 0;