[#32]: implementation on DAO & Service layers