added model & dao for manual process