Added ConnectionStatistics structure

Created a new structure for use in maintaining the server statistics as
returned from the SQLConnection. SQL.Query maintains two versions, one
which holds the stats from the last connection, and another which holds
the stats from all of the connections since the program started.
Moved all Add___Forms to their own namespace

Added AddBuilding, AddCompany, and AddContact to namespace
TII_NewDatabase.AddNewForms to reflect their position within the project
folder.
Combined Opening Forms Events

Moved All open form events to a single function, which rolls into a
switch-case based on the name of the button which was clicked. Removed
button specific events.
Added Building List to AddInspection

Add inspection has a listbox that can be filtered down based on the
textbox above, and which utilized the DatabaseList BuildingList from the
main form.
Set up Controls on AddInspection
Mdified Building.ElevatorList

Now returns a List<Elevator> rather than a List<string>. Modified
MainForm at the only other place this was used.
Added Vertical Lift Type to Elevator

Added another listing for the Type Enumerator for Vertical Lifts. Also
updated the comments for each enum, since I had failed to do so earlier.
AddInspection Elevator List will populate

Upon selecting a building from the list on the left side of the form,
the elevator information for that building will be loaded in the form.
The user can mark the elevators as appropriate.
Enabled Set All Inspections Dropbox

The user can select an item from the dropbox and it will fill in that
status for every elevator in the grid above.
Created an Inspection Class

For use in the Add Inspection Form. Follows the same basic format as the
other BaseObject derived classes.
Expanded AddInspection Form

Now loads the elevators for the selected building correctly, and started
work on validating entries.
Bug Fix & Exception Handling in Query class

The Database Table "Inspection" had modified a column outside of the
program - "InspectionType" became "Type". This caused an exception to be
thrown in the GetTable Method of Query. The Exception was thrown before
the form loaded, so it was handled by the form without alerting the
user, and furthermore allowed the SQLConnection to remain open, which
then failed the very next time the connection was tried.
Fix: a "Finally" was added to the Try..Catch in GetTable to close the
table regardless of what happens, and corrected the explicit references
to  InspectionType. Also made the Exception a bit more clear to assist
with Debugging.
Bug Fix in SQLColumn

When a column was created using SQLColumn(string, string), instead of
assigning "NULL" to the SQLColumn.Value, it was assigned to the
parameter passed in, with the result that SQLColumn.Value remained null.
This would result in improperly formatted SQL Queries.
Fix for Crash on Startup

In the event that no filters were enabled at startup (neither companies
from DC or MD are shown), the form bails out at the point in the load
method where the first item in the listbox is selected, which would then
trigger the information to load. We now check to see that there are
items in the listbox, and if not, do not select an item programatically.
Loading of the form would then be deferred until a checkbox item is
modified.
BugFix: Wrong ID loaded in Elevator Class

Copy/Paste oversight resulted in the Elevator class loading the Building
ID both as the Elevator ID and the Building ID.
Added ElevatorID Property to Inspection class

Overlooked the need for exposing the elevator_id value. Also moved the
methods around to make StyleCop happy.
Typo in BaseObject

Resulted in a failure after every commit, since the SQL statement was
trying to insert into a table that did not exist.
DatabaseObject now inserts UserName

Username is based on the WorkstationID of the computer that made the
connection. Can't use the UserName from the Credentials, because those
are null after the initial connection is made.
Completed AddInspection Form

Add Inspection Form now commits the new inspection information to the
database. Added in the use of a dictionary to hold the relations between
the elevator IDs and the Elevator Numbers, rather than re-query at the
time of the insertion.