USP_ADDUPDATE_SITEPAGE_BBPAYTEMPLATEVERSION

CREATE procedure dbo.USP_ADDUPDATE_SITEPAGE_BBPAYTEMPLATEVERSION
(
    @SITEPAGEID integer,
    @BBPAYTEMPLATEVERSION smallint,
  @ENVIRONMENTID uniqueidentifier
)
as
begin
  declare @CHANGEAGENTID uniqueidentifier;
  exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

  declare @CURRENTDATE datetime;
  set @CURRENTDATE = getdate();

  declare @EXISTINGID uniqueidentifier;
  select @EXISTINGID = ID from dbo.CMSSITEPAGEBBPAYTEMPLATEVERSION where SitePageID = @SITEPAGEID and EnvironmentId = @ENVIRONMENTID;

  if (@EXISTINGID is not null)
  begin
      update dbo.CMSSITEPAGEBBPAYTEMPLATEVERSION
      set 
      BBPAYTEMPLATEVERSION = @BBPAYTEMPLATEVERSION,
      DATECHANGED = @CURRENTDATE, 
      CHANGEDBYID = @CHANGEAGENTID,
      ENVIRONMENTID = @ENVIRONMENTID
      where ID = @EXISTINGID;
  end
  else
  begin 
      insert into dbo.CMSSITEPAGEBBPAYTEMPLATEVERSION(
      SitePageId, 
      BBPayTemplateVersion,
      EnvironmentId,
      ADDEDBYID, 
      CHANGEDBYID, 
      DATEADDED, 
      DATECHANGED)
      values(
      @SITEPAGEID, 
      @BBPAYTEMPLATEVERSION,
      @ENVIRONMENTID,
      @CHANGEAGENTID, 
      @CHANGEAGENTID, 
      @CURRENTDATE, 
      @CURRENTDATE);
  end
end