USP_RECORDOPERATION_CONSTITUENTSUMMARYTILESUPDATESETTINGS

create procedure dbo.USP_RECORDOPERATION_CONSTITUENTSUMMARYTILESUPDATESETTINGS
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier,
    @SHOWTILES bit
)
as begin
    set nocount on;

    declare @CURRENTDATE datetime = getdate();
    declare @CURRENTSHOWTILES bit;

    select
      @CURRENTSHOWTILES = SHOWTILES
    from
      dbo.USERSETTINGSCONSTITUENTSUMMARYTILES
    where
      ID = @ID;

    if @CURRENTSHOWTILES is null
    begin
      insert into dbo.USERSETTINGSCONSTITUENTSUMMARYTILES
      (
        ID,
        SHOWTILES,
        ADDEDBYID,
        CHANGEDBYID,
        DATEADDED,
        DATECHANGED
      )
      values (
        @ID,
        @SHOWTILES,
        @CHANGEAGENTID,
        @CHANGEAGENTID,
        @CURRENTDATE,
        @CURRENTDATE
      )     
    end
    else
    begin
      update dbo.USERSETTINGSCONSTITUENTSUMMARYTILES
      set
        SHOWTILES = @SHOWTILES,
        DATECHANGED = @CURRENTDATE,
        CHANGEDBYID = @CHANGEAGENTID
      where
        ID = @ID
    end
end