USP_DATAFORMTEMPLATE_EDITSAVE_TIMESHEETBATCHROW_2

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@VOLUNTEERID	uniqueidentifier	IN
@JOBOCCURRENCEID	uniqueidentifier	IN
@HOURSWORKED	decimal(20, 2)	IN
@STARTDATE	datetime	IN
@ENDDATE	datetime	IN
@SEQUENCE	int	IN
@VOLUNTEER_IMPORTLOOKUPID	nvarchar(100)	IN

Definition

Copy


                    create procedure dbo.USP_DATAFORMTEMPLATE_EDITSAVE_TIMESHEETBATCHROW_2
                    (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier,
                        @VOLUNTEERID uniqueidentifier,
                        @JOBOCCURRENCEID uniqueidentifier,
                        @HOURSWORKED decimal(20, 2),
                        @STARTDATE datetime,
                        @ENDDATE datetime,
                        @SEQUENCE int,
                        @VOLUNTEER_IMPORTLOOKUPID nvarchar(100)
                    )
                    as 
                    set nocount on;

                    declare @CHANGEDATE datetime

                    if @ID is null
                        set @ID = NewID();

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

                    set @CHANGEDATE = getdate();

                    begin try
                        update dbo.BATCHTIMESHEET
                            set VOLUNTEERID = @VOLUNTEERID,
                                JOBOCCURRENCEID = @JOBOCCURRENCEID,
                                HOURSWORKED = @HOURSWORKED,
                                STARTDATE = @STARTDATE,
                                ENDDATE = @ENDDATE,
                                SEQUENCE = @SEQUENCE,
                                CHANGEDBYID = @CHANGEAGENTID,
                                DATECHANGED = @CHANGEDATE
                        where ID = @ID;

                    end try
                    begin catch
                        exec dbo.USP_RAISE_ERROR;
                        return 1;
                    end catch

                    return 0;