The Bug Assalt is a cool gun. I don't have the time to mess with that. I spray bug killer with Permethrin on the windows. The higher percentage of Permethrin, the better. All insects gravitate towards the light. The windows bring light into a room, so the bugs spend a lot of time on the windows. Doing only the windows limits the amount of bug spray needed, and keeps people and pets out of the poison, especially if only used at the top half of the window. All you have to do then is vacuum the bugs off the window sill and floor below the window occasionally.
For fruit flies, put some Apple Cider Vinegar in a cup or glass with a drop or 2 of Dawn liquid mixed in. The Dawn breaks up the surface tension on the vinegar (or water) and the flies get sucked in and drowned the second they touch it. The vinegar is totally safe and biodegradable.