Consider a .38 special or .357 magnum (shooting .38 Special) by smith and wesson. As reliable as a rock, if you stay away from environments where it is subject to abuse (not my first choice for Afghanistan).
Not as stylish as some, but effective, and reliable.
Not to mention very concealable.