added functional in dao and service classes