add comments to get offers for one day before and one day after the start/end date.
convert named query BC_READ_OFFERS_BY_AUTOMATIC_DELIVERY_TYPE to hibernate criteria