USE [Projekt]
GO
/****** Object:  StoredProcedure [dbo].[Dodaj_zamowienie]    Script Date: 02.06.2019 20:03:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Mikolaj
-- Create date: 
-- Description:	
-- =============================================
ALTER PROCEDURE [dbo].[Dodaj_zamowienie] 
	-- Add the parameters for the stored procedure here
	@email AS NVARCHAR(MAX),
	@typ_wysylki AS NVARCHAR(MAX),
	@data_zamowienia AS DATE,
	@nazwa_ksiazki AS NVARCHAR(MAX)
	
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for procedure here
	BEGIN TRANSACTION
	DECLARE @ksiazka AS INT
	SELECT @ksiazka = id FROM Ksiazka WHERE tytul = @nazwa_ksiazki
	IF @ksiazka IS NULL

	BEGIN
		PRINT('KSIAZKA NIE ISTNIEJE')
		RETURN 0
	END


	 
	DECLARE @uzytkownik AS INT
	SELECT @uzytkownik = id FROM Uzytkownik WHERE email = @email
	IF @uzytkownik IS NULL
	BEGIN
		PRINT('Uzytkownik nie istnieje')
		RETURN 0
	END


	DECLARE @wysylka AS INT 
	SELECT @wysylka = id FROM Wysylka WHERE nazwa = @typ_wysylki

	IF @wysylka IS NULL 
	BEGIN
		PRINT('Typ wysylki nie istnieje')
		RETURN 0
	END

	INSERT INTO Zamowienie VALUES (@data_zamowienia, @wysylka, @uzytkownik)

	DECLARE @zamowienie AS INT
	SELECT @zamowienie = max(id) FROM Zamowienie 

	INSERT INTO Zamowienie_Ksiazka VALUES (@zamowienie,@ksiazka)

	IF @@ERROR <> 0 
	BEGIN
	ROLLBACK TRANSACTION 
	RETURN 11
	END

	COMMIT TRANSACTION 
END