ALTER PROCEDURE [dbo].[ConvertToRetailer] (
	@WholesalerID int,
	@stawtus bit
)

AS

SET NOCOUNT ON

IF @status = 1 then
BEGIN
	UPDATE 	WHOLESALERS
	SET	WholeSaleEndDate = getdate(),
		statusChangedOn = getdate(), 
		[ModifiedOn] = getdate()
	WHERE	WHOLESALERID = @WholesalerID

	DECLARE @userid int

	select 	@userid = u.userid
	from 	users u
	inner join
		wholesalers w
	on 	u.userid = w.userid
	where 	w.wholesalerid = @WholesalerID

	update 	users set iswholesaler = 0,
		[ModifiedOn] = getdate()
	where 	userid = @userid

END
else
BEGIN
	UPDATE	WHOLESALERS
	SET	WholeSaleStartDate = getdate(),
		statusChangedOn = getdate(), 
		[ModifiedOn] = getdate()
	WHERE	WHOLESALERID = @WholesalerID
end