Kandahar no longer most dangerous: general