Pull request to incorporate timezones

[Tich1212]

Why: Previously we assumed all data was in UTC. Users want the ability to enter TS data into excel in local time and view TS data read from the DB in local time.

Related to issue #17 Related to issue #23

How:

• Store all times in TimeSeries as UTC.
• Store UTC offset in db.config.
• When parsing from excel, convert local times to UTC using offset and write to TimeSeries in UTC
• When reading from DB, store TimeSeries in memory as UTC, then convert to local when TimeSeries.WriteToConsole is called.

[Tich1212]

More Learning:

Translating between Windows TimeZoneInfo and the java timezone (which is a required input for our oracle retrieve) is difficult.

TimeZoneInfo uses timezones on your Windows system, most of which are daylight savings aware. Using TimeZoneInfo would limit the user to utilize daylight savings timezones only.

Next Approach:

Instead we can use NodaTime, which allows us to create ZonedDateTimes using the java timezones (olson). We can specify whether the timezone is daylight aware or not.