USP_DATAFORMTEMPLATE_EDIT_ADDOPPORTUNITIESPREPROCESS_2

The save procedure used by the edit dataform template "Add Opportunities Preprocess 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.
@IDSETREGISTERID	uniqueidentifier	IN	Prospect plan selection
@OPPORTUNITYTYPECODEID	uniqueidentifier	IN	Type
@EXPECTEDASKAMOUNT	money	IN	Expected ask amount
@OPPORTUNITYDESIGNATIONS	xml	IN	Designations
@TRANSACTIONCURRENCYID	uniqueidentifier	IN	Currency
@OPPORTUNITYSTATUSCODE	tinyint	IN	Status
@EXPECTEDASKDATE	datetime	IN	Expected ask date
@ASKAMOUNT	money	IN	Ask amount
@ASKDATE	datetime	IN	Ask date
@LIKELIHOODTYPECODEID	uniqueidentifier	IN	Likelihood
@RESPONSEDATE	datetime	IN	Response date
@COMMENT	nvarchar(max)	IN	Comments

Definition

Copy



                  create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_ADDOPPORTUNITIESPREPROCESS_2 (
                      @ID uniqueidentifier,
                      @CHANGEAGENTID uniqueidentifier = null,
                      @IDSETREGISTERID uniqueidentifier,
                      @OPPORTUNITYTYPECODEID uniqueidentifier,
                      @EXPECTEDASKAMOUNT money,
                      @OPPORTUNITYDESIGNATIONS xml,
                      @TRANSACTIONCURRENCYID uniqueidentifier,
                      @OPPORTUNITYSTATUSCODE tinyint,
                      @EXPECTEDASKDATE datetime,
                      @ASKAMOUNT money,
                      @ASKDATE datetime,
                      @LIKELIHOODTYPECODEID uniqueidentifier,
                      @RESPONSEDATE datetime,
                      @COMMENT nvarchar(max)
                  )
                  as

                      set nocount on;

                      if @OPPORTUNITYSTATUSCODE = 0
                        begin
                            set @ASKAMOUNT = 0;
                            set @ASKDATE = null;
                            set @RESPONSEDATE = null;
                        end

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

                      declare @CURRENTDATE datetime = getdate()

                      begin try
                          update dbo.ADDOPPORTUNITIESPROCESS set
                              IDSETREGISTERID = @IDSETREGISTERID,
                              OPPORTUNITYTYPECODEID = @OPPORTUNITYTYPECODEID,
                              EXPECTEDASKAMOUNT = @EXPECTEDASKAMOUNT,
                              TRANSACTIONCURRENCYID = @TRANSACTIONCURRENCYID,
                              OPPORTUNITYSTATUSCODE = @OPPORTUNITYSTATUSCODE,
                              EXPECTEDASKDATE = @EXPECTEDASKDATE,
                              ASKAMOUNT = @ASKAMOUNT,
                              ASKDATE = @ASKDATE,
                              LIKELIHOODTYPECODEID = @LIKELIHOODTYPECODEID,
                              RESPONSEDATE = @RESPONSEDATE,
                              COMMENT = @COMMENT,                              
                              CHANGEDBYID = @CHANGEAGENTID,
                              DATECHANGED = @CURRENTDATE
                          where ID = @ID;

                          exec dbo.USP_ADDOPPORTUNITIESPROCESS_OPPORTUNITYDESIGNATIONS_UPDATEFROMXML @ID, @OPPORTUNITYDESIGNATIONS, @CHANGEAGENTID, @CURRENTDATE;
                      end try
                      begin catch
                          exec dbo.USP_RAISE_ERROR
                          return 1
                      end catch

                  return 0;