I have two book recommendations.
Enchantment by Guy Kawasaki
People Skills by Robert Bolton
I also agree with the How to Win Friends and Influence People book suggestion.
Also, I sense you are frustrated. Lighten up a bit and know that this will not always be. Be thankful for where you are...