1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38
|
CREATE PROCEDURE [dbo].AjoutVendeur
(@Codepostal char(5),
@Ville varchar(50),
@Nom varchar(50),
@Prenom varchar(50),
@Adresse text,
@Telephone char(10),
@FaxGsm char(10),
@Email varchar(70),
@Password varchar(10),
@NewsLetter bit,
@Identity int output,
@VilleOk int output)
AS
SET @VilleOk =(SELECT VilleID FROM dbo.Ville WHERE CodePostal=@CodePostal AND Ville=@Ville)
IF NOT @VilleOk IS NULL
BEGIN
INSERT INTO dbo.Vendeur
(Nom, Prenom, Adresse, VilleID, Telephone, FaxGsm, Email, Password, NewsLetter)
VALUES (@Nom, @Prenom, @Adresse, @VilleOk, @Telephone, @FaxGsm, @Email, @Password, @NewsLetter);
END
ELSE
BEGIN
INSERT INTO dbo.Ville
(CodePostal, Ville)
VALUES (@CodePostal, @Ville);
SET @Identity = SCOPE_IDENTITY()
INSERT INTO dbo.Vendeur
(Nom, Prenom, Adresse, VilleID, Telephone, FaxGsm, Email, Password, NewsLetter)
VALUES (@Nom, @Prenom, @Adresse, @Identity,@Telephone, @FaxGsm, @Email, @Password, @NewsLetter);
END
GO |
Partager