Page History

-- =============================================
-- Author:      Asamco BV, Alexander Toufexis
-- Create date: 30/4/2020
-- Description: updates markup (uses _as_UpdateMarkup), but allows for WH "all".
-- =============================================
createALTER or ALTER   PROCEDURE [dbo].[_as_UpdateMarkup_allowAll]
    @StockCode varchar(100)
    ,@WHCode varchar(100)
    ,@MarkupPerc float
    ,@PriceListID int = 154
AS
BEGIN

DECLARE @WHCode2 varchar(100)

IF @WHCode <> 'all'
	BEGIN
		exec [_as_UpdateMarkup] @StockCode, @WHCode, @MarkupPerc, @PriceListID, 1;
	END
ELSE --@WHCode
	BEGIN
	-- all linked WHs:
		DECLARE MyCursor CURSOR 
	FORWARD_ONLY
	FOR
	SELECT W.Code FROM WhseStk WS
		LEFT JOIN WhseMst W ON WS.WHWhseID = W.WhseLink
		LEFT JOIN StkItem S ON WS.WHStockLink = S.StockLink
		WHERE S.Code = @StockCode

	OPEN MyCursor

	FETCH NEXT FROM MyCursor INTO @WHCode2
				
	WHILE @@FETCH_STATUS = 0 
		BEGIN	
			exec [_as_UpdateMarkup] @StockCode, @WHCode2, @MarkupPerc, @PriceListID, 0;
		FETCH NEXT FROM MyCursor INTO @WHCode2
		END 
	CLOSE MyCursor
	DEALLOCATE MyCursor

	--1 time updating prices in evo
		DECLARE @StockLink int
		SELECT @StockLink FROM StkItem WHERE Code = @StockCode;
		exec _espUpdateSellPrices @StockLink;
	END	--ELSE @WHCOde <> all..




END