spDelete_ClientUserDashboardPanel

Parameters

Parameter	Parameter Type	Mode	Description
@PKID	int	IN
@CurrentUsersID	int	IN

Definition

Copy




CREATE  PROCEDURE dbo.spDelete_ClientUserDashboardPanel
    (
        @PKID int,
        @CurrentUsersID int
    )
AS

DECLARE @Pane nvarchar(1000)
DECLARE @Index nvarchar(1000)
DECLARE @SiteContentID int
DECLARE @ClientUsersID int

    Select
    @Pane = Dockinglocation,
    @Index = DockingIndex, 
    @SiteContentID = SiteContentID,
    @ClientUsersID = ClientUsersID
    FROM dbo.ClientUserDashboardPanel 
    WHERE ID = @PKID

    UPDATE 
    dbo.ClientUserDashboardPanel 
    SET 
    DockingIndex = DockingIndex -1 
    WHERE 
    DockingLocation = @Pane
    AND
    DockingIndex > @Index
    AND
    SiteContentID = @SiteContentID
    AND
    ClientUsersID = @ClientUsersID


    DELETE FROM ClientUserDashboardPanel where ID = @PKID

RETURN