spAddUpdate_PageContent
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PKID | int | INOUT | |
| @CurrentUsersID | int | IN | |
| @SitePagesID | int | IN | |
| @SiteContentID | int | IN | |
| @ContentOrder | int | IN | |
| @PaneName | nvarchar(256) | IN |
Definition
Copy
CREATE PROCEDURE [dbo].[spAddUpdate_PageContent]
(
@PKID int output,
@CurrentUsersID int,
@SitePagesID int,
@SiteContentID int,
@ContentOrder int,
@PaneName nvarchar(256)
)
AS
Begin transaction
if (@PKID<=0) begin
-- bump up everyone after me
UPDATE PageContent SET
ContentOrder = ContentOrder + 1
WHERE
SitePagesId = @SitePagesID
AND
PaneName = @PaneName
AND
ContentOrder >= @ContentOrder
-- insert me
INSERT INTO PageContent
(
SitePagesID ,
SiteContentID ,
ContentOrder ,
PaneName
)
VALUES
(
@SitePagesID ,
@SiteContentID ,
@ContentOrder ,
@PaneName
)
SELECT
@PKID = @@Identity
/*exec spAuditThis @CurrentUsersID, 1, @Guid, 6*/
end else begin
UPDATE PageContent SET
SitePagesID=@SitePagesID ,
SiteContentID=@SiteContentID ,
ContentOrder=@ContentOrder ,
PaneName=@PaneName
WHERE ID=@PKID
/*exec spAuditThis @CurrentUsersID, 2, @Guid, 6*/
end
Update SitePages SET UpdateDate = GetUTCdate()
where ID = @SitePagesID
Commit transaction