Move "with deleted" where statement creation to method

To keep the code DRY compliant later on.
Pass empty array when there is no where
add hard delete methods