add methods list by state, delete inactive records, and delete