USP_DATAFORMTEMPLATE_EDIT_ONLINEACCOUNTEMAILADDRESS

                CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_ONLINEACCOUNTEMAILADDRESS 
                (
                    @ID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier = null,
                    @ACCOUNTEMAILADDRESS nvarchar(200)
                )
                as
                    set nocount on;
                    begin try
                    --UPDATE Email Along with the Audit BEGINS


                        declare @CLIENTUSERID int=0,@RESETEMAILVERIFIEDSTATUS bit;

                        select @CLIENTUSERID=isnull(CU.ID,0),
                        @RESETEMAILVERIFIEDSTATUS=(case when ltrim(rtrim(EMAIL)) <> ltrim(rtrim(@ACCOUNTEMAILADDRESS)) then 1 else 0 end)
                        from dbo.CLIENTUSERS CU left join dbo.[NETCOMMUNITYCLIENTUSER] NCU on CU.[ID]  = NCU.[BBNCUSERID] 
                        where NCU.[CONSTITUENTID] = @ID;

                        if(@CLIENTUSERID<>0) 
                        begin
                                exec USP_UPDATE_EMAIL_BY_USERID @CLIENTUSERID,@ACCOUNTEMAILADDRESS,@RESETEMAILVERIFIEDSTATUS,-1;
                        end;

                    --UPDATE Email Along with the Audit ENDS

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

                return 0;