Fixing an issue with retrieving closed stores.

This was another project that was sort of training for me, it involved updating a pair of web apps we currently use to better handle closed stores. At the time, a closed store would cause either of the apps to fail (displaying blank screens where it should show data).

Fixing this required rewriting the way we were pulling store data; the process only pulled open store information, and the nullreferenceexception thrown when a closed store was requested caused the apps to fail. I had to add a new connection to one of our Oracle databases, and directly pull store data from it, which was only done when a store wasn’t found through the normal process (in order to avoid any additional overhead). I also added improved error reporting (adding handling for some other exceptions we were seeing), as we ran into another scenario that we couldn’t pin down.