update dao, routes and view for events page