USP_DATAFORMTEMPLATE_EDIT_RESERVATIONSECURITYDEPOSITREFUNDPAYMENT_2

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@DATE	datetime	IN
@AMOUNT	money	IN
@CHECKDATE	UDT_FUZZYDATE	IN
@CHECKNUMBER	nvarchar(20)	IN
@NOTES	nvarchar(255)	IN

Definition

Copy


create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_RESERVATIONSECURITYDEPOSITREFUNDPAYMENT_2 (
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @DATE datetime,
    @AMOUNT money,
    @CHECKDATE dbo.UDT_FUZZYDATE,
    @CHECKNUMBER nvarchar(20),
    @NOTES nvarchar(255)
)
as

    set nocount on;

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

    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()

    begin try
        update dbo.CREDITPAYMENTCHECKPAYMENTMETHODDETAIL
            set 
                CHECKNUMBER = @CHECKNUMBER,
                CHECKDATE = @CHECKDATE,
                NOTES = @NOTES,
                CHANGEDBYID = @CHANGEAGENTID,
                DATECHANGED = @CURRENTDATE
            where ID = @ID;
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;