spa_agregarProductosOrden

USE [dbEmissary]
GO

/****** Object:  StoredProcedure [askerick].[spa_agregarProductosOrden]    Script Date: 16/10/2019 08:03:20 p. m. ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [askerick].[spa_agregarProductosOrden]
	(
	@numOrden int,
	@producto nvarchar (100),
	@cantidad nvarchar (100),
	@precio nvarchar (100),
	@precioTotal nvarchar (100),
	@peso nvarchar (100),
	@productoId nvarchar (100)
	)
AS
BEGIN
	UPDATE [dbEmissary].[askerick].[tblEmissary_ProductosOrdenes] SET @precioTotal = @precioTotal WHERE orden_id = @numOrden AND producto_id = @productoId

	IF @@ROWCOUNT = 0
	BEGIN
	INSERT INTO [dbEmissary].[askerick].[tblEmissary_ProductosOrdenes] (
       [orden_id]
      ,[producto]
	  ,[cantidad]
	  ,[precio]
	  ,[precioTotal]
	  ,[peso]
	  ,[producto_id]
	) VALUES (@numOrden,@producto,@cantidad,@precio,@precioTotal,@peso,@productoId)
	END
END
GO