1-) MSSQL RMOS -

USE [RmosFront]

GO

 

/****** Object:  Table [dbo].[RHAddress]    Script Date: 18.04.2018 09:37:09 ******/

SET ANSI_NULLS ON

GO

 

SET QUOTED_IDENTIFIER ON

GO

 

CREATE Procedure RHAddress_Kaydet

(

@RHReservation_id int = NULL,

@RHAddress_id int = NULL,

@RHAddress_city nvarchar(50) = NULL,

@RHAddress_state nvarchar(50) = NULL,

@RHAddress_country nvarchar(50) = NULL,

@RHAddress_country_code nvarchar(50) = NULL,

@RHAddress_phone nvarchar(50) = NULL,

@RHAddress_email nvarchar(50) = NULL,

@RHAddress_street nvarchar(50) = NULL,

@RHAddress_street_2 nvarchar(50) = NULL

)

AS

BEGIN

 

IF @RHAddress_id IS NULL

BEGIN

INSERT INTO RHAddress

(RHReservation_id, RHAddress_city, RHAddress_state, RHAddress_country, RHAddress_country_code, RHAddress_phone, RHAddress_email, RHAddress_street, RHAddress_street_2)

VALUES (@RHReservation_id,@RHAddress_city,@RHAddress_state,@RHAddress_country,@RHAddress_country_code,@RHAddress_phone,@RHAddress_email,@RHAddress_street,@RHAddress_street_2)

END

ELSE

BEGIN

UPDATE RHAddress

SET RHReservation_id = @RHReservation_id, RHAddress_city = @RHAddress_city, RHAddress_state = @RHAddress_state, RHAddress_country = @RHAddress_country, RHAddress_country_code = @RHAddress_country_code,

RHAddress_phone = @RHAddress_phone, RHAddress_email = @RHAddress_email, RHAddress_street = @RHAddress_street, RHAddress_street_2 = @RHAddress_street_2

Where RHAddress_id = @RHAddress_id

END

 

END