search according to 2 dropdownlist selected item

hi

i have 2 dropdown list in my page  1-ddlzone1     2- ddldistrict1 and one button (search)

at first i select item from ddlzone1  click on search button according to below SP it search on database and show result

ALTER procedure [dbo].[GetCustomersPageWise]


  @PageIndex INT = 1
      ,@PageSize INT = 5
      ,@RecordCount INT OUTPUT
     ,@Region nvarchar(10)
     ,@District nvarchar(20)
AS
BEGIN
      SET NOCOUNT ON;
      SELECT ROW_NUMBER() OVER
      (
            ORDER BY [House_p].[Date] desc
      )AS RowNumber
      ,[House_p].[ID]
      ,[House_p].[Name]
      ,[House_p].[Image]
    ,[House_p].[Date] 
    
      ,[Model]
     INTO #Results
          FROM [House_p]
      JOIN [HOuse_info]      ON [House_p].[BehCode] = [HOuse_info].[BehCode] 
      WHERE [HOuse_info].Region = @Region  or @Region='0'
      SELECT @RecordCount = COUNT(*)
      FROM #Results
           
      SELECT * FROM #Results
      WHERE RowNumber BETWEEN(@PageIndex -1) * @PageSize + 1 AND(((@PageIndex -1) * @PageSize + 1) + @PageSize) - 1
     
      DROP TABLE #Results
END

now i want when users select item from ddlzone1  after that if they select item from ddldistict1 according to their selected item from ddlzone1 and ddldistrict1  it search in table and show result

now how i can change my SP

i changed below code in SP  but it didn't work

WHERE ([HOuse_info].Region = @Region  or @Region='0') or ([House_Info] .District=@District or @District='0')
      SELECT @RecordCount = COUNT(*)

BEst regards