spAddUpdate_NetGroup

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@DisplayName	nvarchar(255)	IN
@Description	nvarchar(900)	IN
@NetAccountID	int	IN
@ClientRolesID	int	IN
@Deleted	bit	IN
@DeletedDate	datetime	IN
@DeletedUserID	int	IN
@GroupImageID	int	IN
@LockedOut	bit	IN
@LockedDate	datetime	IN
@LockedUserID	int	IN
@ShortDescription	nvarchar(100)	IN
@MemberApproval	int	IN
@PublishInDirectory	bit	IN
@InvitationOption	int	IN
Definition

Copy


            CREATE PROCEDURE [dbo].[spAddUpdate_NetGroup]
            (
                @PKID int output,
                @DisplayName nvarchar(255),
                @Description nvarchar(900),
                @NetAccountID int,
                @ClientRolesID int,
                @Deleted bit,
                @DeletedDate datetime,
                @DeletedUserID int,
                @GroupImageID int,
                @LockedOut bit,
                @LockedDate datetime,
                @LockedUserID int,
                @ShortDescription nvarchar(100),
                @MemberApproval int,
                @PublishInDirectory bit,
                @InvitationOption int

            )
                AS
                BEGIN
                    IF (@PKID<=0) 
                    BEGIN
                        INSERT INTO [NetGroup]
                        (
                        DisplayName,
                        Description,            
                        NetAccountID,
                        ClientRolesID,
                        Deleted,
                        DeletedDate,
                        DeletedUserID,
                        GroupImageID,
                        LockedOut,
                        LockedDate,
                        LockedUserID,
                        ShortDescription,
                        MemberApproval,
                        PublishInDirectory,
                        InvitationOption
                        )
                        VALUES
                        (
                        @DisplayName,
                        @Description,
                        @NetAccountID,
                        @ClientRolesID,
                        @Deleted,
                        @DeletedDate,
                        @DeletedUserID,
                        @GroupImageID,
                        @LockedOut,
                        @LockedDate,
                        @LockedUserID,
                        @ShortDescription,
                        @MemberApproval,
                        @PublishInDirectory,
                        @InvitationOption
                        )

                        SELECT @PKID = @@Identity

                        EXEC dbo.[spAddUpdate_NetGroupRelation] 0, @PKID, @NetAccountID, 3, NULL

                    END
                    ELSE 

                        UPDATE [NetGroup] SET
                        DisplayName = @DisplayName,
                        Description = @Description,
                        NetAccountID = @NetAccountID,
                        ClientRolesID = @ClientRolesID,
                        UpdateDate = getUTCDate(),
                        Deleted = @Deleted ,
                        DeletedDate = @DeletedDate,
                        DeletedUserID = @DeletedUserID,
                        GroupImageID = @GroupImageID,
                        LockedOut = @LockedOut,
                        LockedDate = @LockedDate,
                        LockedUserID = @LockedUserID,
                        ShortDescription = @ShortDescription,
                        MemberApproval = @MemberApproval,
                        PublishInDirectory = @PublishInDirectory,
                        InvitationOption = @InvitationOption
                        WHERE [ID]=@PKID
                END