I agree with hypermellow: check GetAllPromotionAdverts. This error is usually caused when you try to append text to an int like so:
select "id="+id from mytable
You have to cast the int to an nvarchar like so:
select "id="+cast(id as nvarchar(max)) from mytable
Hope that helps ^_^
Andy