USP_DATAFORMTEMPLATE_EDIT_AMPROIMPORTCONFIG

The save procedure used by the edit dataform template "AuctionMaestro Pro Import Configuration Edit 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.
@PDACCOUNTSYSTEMID	uniqueidentifier	IN	Account system
@NEWITEMDESIGNATIONID	uniqueidentifier	IN	New item designation
@FUNDITEMDESIGNATIONID	uniqueidentifier	IN	Fund-An-Item designation
@NEWCONSTITUENTSECURITYID	uniqueidentifier	IN	Default security group for new constituents
@NEWCONSTITUENTSITEID	uniqueidentifier	IN	Default site for new constituents

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_AMPROIMPORTCONFIG
                    (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @PDACCOUNTSYSTEMID uniqueidentifier,
                        @NEWITEMDESIGNATIONID uniqueidentifier,
                        @FUNDITEMDESIGNATIONID uniqueidentifier,
                        @NEWCONSTITUENTSECURITYID uniqueidentifier,
                        @NEWCONSTITUENTSITEID uniqueidentifier
                    )
                    as
                    set nocount on;

                    begin try
                        if @CHANGEAGENTID is null
                            exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                        declare @CHANGEDATE datetime = getdate();

                        if dbo.UFN_AMPROIMPORT_VALIDATEACCOUNTSYSTEMSITES(@ID, @PDACCOUNTSYSTEMID) = 0
                            raiserror('BB_ERR_INVALIDSITE', 13, 1);

                        if dbo.UFN_AUCTION_DESIGNATIONISVALID(@ID,@NEWITEMDESIGNATIONID) = 0
                            raiserror('BB_ERR_INVALIDITEMDESIGNATION', 13, 1);

                        if dbo.UFN_AUCTION_DESIGNATIONISVALID(@ID,@FUNDITEMDESIGNATIONID) = 0
                            raiserror('BB_ERR_INVALIDFUNDITEMDESIGNATION', 13, 1);

                        if exists(select * from dbo.AMPROIMPORTCONFIG where ID = @ID) 
                        begin
                            update dbo.AMPROIMPORTCONFIG
                                set PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID,
                                    NEWITEMDESIGNATIONID = @NEWITEMDESIGNATIONID,
                                    FUNDITEMDESIGNATIONID = @FUNDITEMDESIGNATIONID,
                                    NEWCONSTITUENTSECURITYID = @NEWCONSTITUENTSECURITYID,
                                    NEWCONSTITUENTSITEID = @NEWCONSTITUENTSITEID,
                                    CHANGEDBYID = @CHANGEAGENTID,
                                    DATECHANGED = @CHANGEDATE
                            where ID = @ID;
                        end
                        else
                        begin
                            insert into dbo.AMPROIMPORTCONFIG(ID, PDACCOUNTSYSTEMID, NEWITEMDESIGNATIONID, FUNDITEMDESIGNATIONID, NEWCONSTITUENTSECURITYID, NEWCONSTITUENTSITEID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                                values(@ID, @PDACCOUNTSYSTEMID, @NEWITEMDESIGNATIONID, @FUNDITEMDESIGNATIONID, @NEWCONSTITUENTSECURITYID, @NEWCONSTITUENTSITEID, @CHANGEAGENTID, @CHANGEAGENTID, @CHANGEDATE, @CHANGEDATE);
                        end

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