USE [LevelUp]
GO

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[p_BreakglassRequest_Update]') AND type in (N'P', N'PC'))
	DROP PROCEDURE [dbo].[p_BreakglassRequest_Update]
GO
CREATE PROCEDURE [dbo].[p_BreakglassRequest_Update]
	@Id int,
    @BreakglassUser varchar(50),
    @Applications varchar(1000),
    @StartDateTime datetime,
    @EndDateTime datetime,
    @Justification varchar(1500),
    @Status varchar(20),
    @ErrorMessage varchar(200),
    @ModifiedBy varchar(50),
    @ModifiedDateTime datetime,
    @ApprovedBy varchar(50),
    @ApprovedDateTime datetime,
    @CancelledBy varchar(50),
    @CancelledDateTime datetime,
    @RowVersion timestamp,
    @LastUpdateUser varchar(50) OUTPUT,
    @LastUpdateDateTime datetime OUTPUT
AS
BEGIN
    DECLARE @return INT
    SET @return = 0

	UPDATE dbo.BreakglassRequest
	SET BreakglassUser = @BreakglassUser,
        Applications = @Applications,
        StartDateTime = @StartDateTime,
        EndDateTime = @EndDateTime,
        Justification = @Justification,
        [Status] = @Status,
        ErrorMessage = @ErrorMessage,
        ModifiedBy = @ModifiedBy,
        ModifiedDateTime = @ModifiedDateTime,
        ApprovedBy = @ApprovedBy,
        ApprovedDateTime = @ApprovedDateTime,
        CancelledBy = @CancelledBy,
        CancelledDateTime = @CancelledDateTime
    WHERE
        Id = @Id
    AND [RowVersion] = @RowVersion

    IF @@rowcount = 0
        BEGIN
            SELECT  @LastUpdateUser = ModifiedBy,
                    @LastUpdateDateTime = ModifiedDateTime
            FROM    BreakglassRequest
            WHERE   Id = @Id

            SET @return = 1
        END

    RETURN @return
END
GO