USP_GET_SITEPAGE_BBPAYTEMPLATEVERSION

create procedure dbo.USP_GET_SITEPAGE_BBPAYTEMPLATEVERSION
(
    @SITEPAGEID integer,
  @ENVIRONMENTID uniqueidentifier
)
as
begin

-- Returning the values as other names to match PageBBPayTemplateSettings object's properties so that Dapper can automatically map them to their types

    select 
    @SITEPAGEID as PageId,
    BBPAYTEMPLATEVERSION as VersionByte,
    @ENVIRONMENTID as EnvironmentId
  from dbo.CMSSITEPAGEBBPAYTEMPLATEVERSION T
  where 
        SitePageId = @SITEPAGEID
        and EnvironmentId = @ENVIRONMENTID;
end