USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIPJOBINFO_4

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@JOBTITLE	nvarchar(100)	IN
@CAREERLEVELCODEID	uniqueidentifier	IN
@JOBCATEGORYCODEID	uniqueidentifier	IN
@STARTDATE	date	IN
@ENDDATE	date	IN
@JOBDIVISION	nvarchar(100)	IN
@JOBDEPARTMENT	nvarchar(100)	IN
@JOBSCHEDULECODEID	uniqueidentifier	IN
@JOBRESPONSIBILITY	nvarchar(250)	IN
@ISPRIVATERECORD	bit	IN
@SYNCENDDATETORELATIONSHIP	bit	IN

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIPJOBINFO_4 (
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @JOBTITLE nvarchar(100),
    @CAREERLEVELCODEID uniqueidentifier,
    @JOBCATEGORYCODEID uniqueidentifier,
    @STARTDATE date,
    @ENDDATE date,
    @JOBDIVISION nvarchar(100),
    @JOBDEPARTMENT nvarchar(100),
    @JOBSCHEDULECODEID uniqueidentifier,
    @JOBRESPONSIBILITY nvarchar(250),
    @ISPRIVATERECORD bit,
    @SYNCENDDATETORELATIONSHIP bit
)
as

    set nocount on;

    if @CHANGEAGENTID is null  
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()

    begin try

        if @STARTDATE > @CURRENTDATE
            raiserror('BBERR_STARTDATEFUTURE', 13, 1)


        -- handle updating the data

        update dbo.RELATIONSHIPJOBINFO set
            JOBTITLE = @JOBTITLE,
            CAREERLEVELCODEID = @CAREERLEVELCODEID,
            JOBCATEGORYCODEID = @JOBCATEGORYCODEID,
            STARTDATE = @STARTDATE,
            ENDDATE = @ENDDATE,
            JOBDIVISION = @JOBDIVISION,
            JOBDEPARTMENT = @JOBDEPARTMENT,
            JOBSCHEDULECODEID = @JOBSCHEDULECODEID,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = @CURRENTDATE,
            JOBRESPONSIBILITY = @JOBRESPONSIBILITY,
            ISPRIVATERECORD = @ISPRIVATERECORD
        where ID = @ID

        if @SYNCENDDATETORELATIONSHIP = 1
        begin
            declare @RELATIONSHIPSETID uniqueidentifier;

            select @RELATIONSHIPSETID = RELATIONSHIPSETID 
            from dbo.RELATIONSHIPJOBINFO 
            where ID = @ID;

            update dbo.RELATIONSHIP
            set ENDDATE = @ENDDATE
            where RELATIONSHIPSETID = @RELATIONSHIPSETID;
        end
    end try

    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;