[Added] get the offer from databse using named paramaters (id)