created get_all_offers method