spAddUpdate_AddressBookContacts

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@CurrentUsersID	int	IN
@ClientData	ntext	IN
@FirstName	nvarchar(100)	IN
@LastName	nvarchar(100)	IN
@OrgName	nvarchar(60)	IN
@EMail	nvarchar(100)	IN
@REID	int	IN
@EmailGreeting	ntext	IN
@Deleted	bit	IN
@ContactGroupID	int	IN

Definition

Copy




    CREATE PROCEDURE [dbo].[spAddUpdate_AddressBookContacts]
(
    @PKID        int output,
    @CurrentUsersID    int,
    @ClientData    ntext, 
    @FirstName    nvarchar(100),       
    @LastName    nvarchar(100),
    @OrgName    nvarchar(60),
    @EMail        nvarchar(100),
    @REID        int,
    @EmailGreeting    ntext,
    @Deleted    bit,
    @ContactGroupID int

)
AS

if (@PKID<=0) begin

    INSERT INTO AddressBookContacts
    (

        ClientUsersID    ,
        ClientData    ,
        FirstName    ,
        LastName    ,
        OrgName        ,
        EMail        ,
        REID        ,
        EMAILGREETING,
        CONTACTGROUPID            

    )

    VALUES
    (
        @CurrentUsersID    ,
        @ClientData    ,
        @FirstName    ,
        @LastName    ,
        @OrgName    ,
        @EMail        ,
        @REID        ,
        @EmailGreeting,
        @ContactGroupID    

    )

    SELECT @PKID = @@Identity

    end    
else 
    begin

    UPDATE AddressBookContacts SET

    ClientData=@ClientData        ,
    FirstName=@FirstName        ,
    LastName=@LastName        ,
    OrgName=@OrgName        ,
    EMail=@EMail            ,
    REID=@REID            ,
    EmailGreeting=@EmailGreeting    ,
    Deleted=@Deleted,
    ContactGroupID = @ContactGroupID

    WHERE ID=@PKID

    end