USP_DATAFORMTEMPLATE_EDIT_BANKACCOUNTEFTINFO

The save procedure used by the edit dataform template "Bank Account EFT Info Edit Data Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@IMMEDIATEDESTINATIONNUMBER	nvarchar(10)	IN	Immediate destination
@IMMEDIATEDESTINATIONNAME	nvarchar(23)	IN	Immediate destination name
@IMMEDIATEORIGINNUMBEROPTIONCODE	tinyint	IN	Immediate origin
@IMMEDIATEORIGINNUMBER	nvarchar(10)	IN	Immediate origin
@IMMEDIATEORIGINNAMEOPTIONCODE	tinyint	IN	Immediate origin name
@IMMEDIATEORIGINNAME	nvarchar(23)	IN	Immediate origin name
@REFERENCECODE	nvarchar(8)	IN	Reference code
@COMPANYNAMEOPTIONCODE	tinyint	IN	Company name
@COMPANYNAME	nvarchar(16)	IN	Company name
@COMPANYIDPREFIX	tinyint	IN	Company ID prefix
@COMPANYID	nvarchar(9)	IN	Company ID
@CREATEOFFSETTINGTRANSACTIONS	bit	IN	Create offsetting transactions
@INCLUDECARRIAGERETURN	bit	IN	Include carriage return/line feed

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BANKACCOUNTEFTINFO (
    @ID uniqueidentifier
    ,@CHANGEAGENTID uniqueidentifier = null
    ,@IMMEDIATEDESTINATIONNUMBER nvarchar(10)
    ,@IMMEDIATEDESTINATIONNAME nvarchar(23)
    ,@IMMEDIATEORIGINNUMBEROPTIONCODE tinyint
    ,@IMMEDIATEORIGINNUMBER nvarchar(10)
    ,@IMMEDIATEORIGINNAMEOPTIONCODE tinyint
    ,@IMMEDIATEORIGINNAME nvarchar(23)
    ,@REFERENCECODE nvarchar(8)
    ,@COMPANYNAMEOPTIONCODE tinyint
    ,@COMPANYNAME nvarchar(16)
    ,@COMPANYIDPREFIX tinyint
    ,@COMPANYID nvarchar(9)
    ,@CREATEOFFSETTINGTRANSACTIONS bit
    ,@INCLUDECARRIAGERETURN bit
)
as

    set nocount on;

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

    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()

    if @IMMEDIATEORIGINNUMBEROPTIONCODE != 2
        set @IMMEDIATEORIGINNUMBER = '';

    if @IMMEDIATEORIGINNAMEOPTIONCODE != 1
        set @IMMEDIATEORIGINNAME = '';

    if @COMPANYNAMEOPTIONCODE != 1
        set @COMPANYNAME = '';

    begin try
        if exists(select 1 from dbo.BANKACCOUNTEFTINFO EFT where EFT.ID = @ID)
            update dbo.BANKACCOUNTEFTINFO set
                IMMEDIATEDESTINATIONNUMBER = @IMMEDIATEDESTINATIONNUMBER
                ,IMMEDIATEDESTINATIONNAME = @IMMEDIATEDESTINATIONNAME
                ,IMMEDIATEORIGINNUMBEROPTIONCODE = @IMMEDIATEORIGINNUMBEROPTIONCODE
                ,IMMEDIATEORIGINNUMBER = @IMMEDIATEORIGINNUMBER
                ,IMMEDIATEORIGINNAMEOPTIONCODE = @IMMEDIATEORIGINNAMEOPTIONCODE
                ,IMMEDIATEORIGINNAME = @IMMEDIATEORIGINNAME
                ,REFERENCECODE = @REFERENCECODE
                ,COMPANYNAMEOPTIONCODE = @COMPANYNAMEOPTIONCODE
                ,COMPANYNAME = @COMPANYNAME
                ,COMPANYIDPREFIX = @COMPANYIDPREFIX
                ,COMPANYID = @COMPANYID
                ,CREATEOFFSETTINGTRANSACTIONS = @CREATEOFFSETTINGTRANSACTIONS
                ,INCLUDECARRIAGERETURN = @INCLUDECARRIAGERETURN
                ,CHANGEDBYID = @CHANGEAGENTID
                ,DATECHANGED = @CURRENTDATE
            where ID = @ID
        else
            insert into dbo.BANKACCOUNTEFTINFO (
                ID
                ,IMMEDIATEDESTINATIONNUMBER
                ,IMMEDIATEDESTINATIONNAME
                ,IMMEDIATEORIGINNUMBEROPTIONCODE
                ,IMMEDIATEORIGINNUMBER
                ,IMMEDIATEORIGINNAMEOPTIONCODE
                ,IMMEDIATEORIGINNAME
                ,REFERENCECODE
                ,COMPANYNAMEOPTIONCODE
                ,COMPANYNAME
                ,COMPANYIDPREFIX
                ,COMPANYID
                ,CREATEOFFSETTINGTRANSACTIONS
                ,INCLUDECARRIAGERETURN
                ,CHANGEDBYID
                ,ADDEDBYID
                ,DATEADDED
                ,DATECHANGED)
            values (
                @ID
                ,@IMMEDIATEDESTINATIONNUMBER
                ,@IMMEDIATEDESTINATIONNAME
                ,@IMMEDIATEORIGINNUMBEROPTIONCODE
                ,@IMMEDIATEORIGINNUMBER
                ,@IMMEDIATEORIGINNAMEOPTIONCODE
                ,@IMMEDIATEORIGINNAME
                ,@REFERENCECODE
                ,@COMPANYNAMEOPTIONCODE
                ,@COMPANYNAME
                ,@COMPANYIDPREFIX
                ,@COMPANYID
                ,@CREATEOFFSETTINGTRANSACTIONS
                ,@INCLUDECARRIAGERETURN
                ,@CHANGEAGENTID
                ,@CHANGEAGENTID
                ,@CURRENTDATE
                ,@CURRENTDATE)
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;