extract closeAllConnection private function
delete useless codes
abstract setPromotion private function
extract closeAllConnection private function