Need Advice. Dead battery and broken driver's door handle.

[SiennaX5er]

Here is the situation. The battery in my X5 went bad. I got a new battery and as I was opening my driver's door to install the battery, the handle broke. The battery in there now is completely shot, and isn't even connected. The driver's door handle is broken and will not open the door. I can manually turn the key in the driver's door to unlock it. If I could get the car power, I could use my key to unlock the passenger door. Does anyone have any ideas as to how I could either get into the car or provide the car with power from the outside? Is there any way to pop the hood open from the outside? I would not be opposed to breaking my front grill to gain access to the engine bay. I'm going to call a locksmith soon but just thought I'd see if there was any other way.

Also, there is no way to manually open the tailgate with a key right?