/*______________________________________________________________________________*/
/* */
CREATE PROCEDURE dbo.upd_underlying
/* */
/* Input : */
/* ======= */
/* */
@id_udl int,
@ric varchar(50) = null,
@name varchar(255) = null,
@id_type int = null,
@id_sector int = null,
@id_country int = null,
@isin varchar(15) = null,
@mds varchar(15) = null,
@id_stock_exchange int = null,
@id_market int = null,
@id_udl_out int out,
@type varchar(50) = null,
@country varchar(50) = null,
@id_place int,
@login varchar(25),
@password varchar(25)
/* */
/* Return : */
/* ======== */
/* 0 si OK */
/*______________________________________________________________________________*/
AS
BEGIN

DECLARE @localerr int

IF @login IS NULL OR @password IS NULL
BEGIN
RAISERROR ('this action require an authentification ! : %d', 16, 1, 55551)
RETURN 55551
END

IF NOT EXISTS(SELECT(1) FROM LOGIN WHERE login=@login and password=@password)
BEGIN
RAISERROR ('Login or password is/are not correct(s)! : %d', 16, 1, 55551)
RETURN 55551
END

IF NOT EXISTS(SELECT(1) FROM LOGIN WHERE login=@login AND id_place=@id_place)
BEGIN
RAISERROR ('You are not allowed to update underlyings on this place! : %d', 16, 1, 55551)
RETURN 55551
END

IF NOT EXISTS(SELECT(1) FROM LOGIN WHERE login=@login AND id_role=2)
BEGIN
RAISERROR ('You are not allowed to update underyings : %d', 16, 1, 55551)
RETURN 55551
END