spAddUpdate_EmailProject

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@ClientsID	int	IN
@OwnerID	int	IN
@Name	nvarchar(255)	IN
@Description	nvarchar(256)	IN
@Type	smallint	IN
@FolderID	int	IN
@Guid	uniqueidentifier	IN
@CLIENTSITESID	int	IN

Definition

Copy


CREATE PROCEDURE [dbo].[spAddUpdate_EmailProject]
@PKID int OUTPUT,
@ClientsID int,
@OwnerID int,
@Name nvarchar(255),
@Description nvarchar(256),
@Type smallint,
@FolderID int,
@Guid uniqueidentifier,
@CLIENTSITESID int = 0
as

if @CLIENTSITESID <= 0
    select @CLIENTSITESID = Value from dbo.Setting where ID = 1

IF @PKID <=0 
    BEGIN
        INSERT INTO [dbo].[EmailProject]
           ([ClientsID]
           ,[OwnerID]
           ,[Name]
           ,[Description]
           ,[Type]
           ,[FolderID]
           ,[Guid]
           ,[CLIENTSITESID])
        VALUES
           (@ClientsID
           ,@OwnerID 
           ,@Name
           ,@Description
           ,@Type
           ,@FolderID
           ,@Guid
           ,@CLIENTSITESID)

        SET @PKID = @@IDENTITY
    END
ELSE
    BEGIN
        UPDATE [dbo].[EmailProject]
            SET [ClientsID] = @ClientsID
                ,[OwnerID] = @OwnerID
                ,[Name] = @Name
                ,[Description] = @Description
                ,[Type] = @Type
                ,[FolderID] = @FolderID
                ,[Guid] = @Guid
                ,[CLIENTSITESID] = @CLIENTSITESID
        WHERE [ID] = @PKID
    END