private String IANAtimezone(String oTZ_id, String oTZ_name)
{
//Convert from Windows Timezone to Iana
//Eg "(UTC) Dublin, Edinburgh, Lisbon, London" => "Europe/London"
//http://unicode.org/repos/cldr/trunk/common/supplemental/windowsZones.xml
if (oTZ_id.Equals("UTC", StringComparison.OrdinalIgnoreCase))
{
log.Fine("Timezone \"" + oTZ_name + "\" mapped to \"Etc/UTC\"");
return("Etc/UTC");
}
NodaTime.TimeZones.TzdbDateTimeZoneSource tzDBsource = TimezoneDB.Instance.Source;
String retVal = null;
if (!tzDBsource.WindowsMapping.PrimaryMapping.TryGetValue(oTZ_id, out retVal) || retVal == null)
{
log.Fail("Could not find mapping for \"" + oTZ_name + "\"");
}
else
{
retVal = tzDBsource.CanonicalIdMap[retVal];
log.Fine("Timezone \"" + oTZ_name + "\" mapped to \"" + retVal + "\"");
}
return(retVal);
}
private String IANAtimezone(String oTZ_id, String oTZ_name)
{
//Convert from Windows Timezone to Iana
//Eg "(UTC) Dublin, Edinburgh, Lisbon, London" => "Europe/London"
//http://unicode.org/repos/cldr/trunk/common/supplemental/windowsZones.xml
if (oTZ_id.Equals("UTC", StringComparison.OrdinalIgnoreCase))
{
log.Fine("Timezone \"" + oTZ_name + "\" mapped to \"Etc/UTC\"");
return("Etc/UTC");
}
NodaTime.TimeZones.TzdbDateTimeZoneSource tzDBsource = TimezoneDB.Instance.Source;
TimeZoneInfo tzi = TimeZoneInfo.FindSystemTimeZoneById(oTZ_id);
String tzID = tzDBsource.MapTimeZoneId(tzi);
log.Fine("Timezone \"" + oTZ_name + "\" mapped to \"" + tzDBsource.CanonicalIdMap[tzID] + "\"");
return(tzDBsource.CanonicalIdMap[tzID]);
}
private String IANAtimezone(String oTZ_id, String oTZ_name)
{
//Convert from Windows Timezone to Iana
//Eg "(UTC) Dublin, Edinburgh, Lisbon, London" => "Europe/London"
//http://unicode.org/repos/cldr/trunk/common/supplemental/windowsZones.xml
if (oTZ_id.Equals("UTC", StringComparison.OrdinalIgnoreCase))
{
log.Fine("Timezone \"" + oTZ_name + "\" mapped to \"Etc/UTC\"");
return("Etc/UTC");
}
NodaTime.TimeZones.TzdbDateTimeZoneSource tzDBsource = TimezoneDB.Instance.Source;
TimeZoneInfo tzi = TimeZoneInfo.FindSystemTimeZoneById(oTZ_id);
String tzID = tzDBsource.MapTimeZoneId(tzi);
log.Fine("Timezone \"" + oTZ_name + "\" mapped to \"" + tzDBsource.CanonicalIdMap[tzID] + "\"");
//Google bug as logged at https://issuetracker.google.com/67170002; GitHub issue #349
//Until fixed, transpose Kolkata timezone to old Calcutta value
return(tzDBsource.CanonicalIdMap[tzID].Replace("Asia/Kolkata", "Asia/Calcutta"));
}
private Microsoft.Office.Interop.Outlook.TimeZone WindowsTimeZone(string ianaZoneId)
{
ianaZoneId = TimezoneDB.FixAlexa(ianaZoneId);
Microsoft.Office.Interop.Outlook.TimeZones tzs = oApp.TimeZones;
var utcZones = new[] { "Etc/UTC", "Etc/UCT", "UTC", "Etc/GMT" };
if (utcZones.Contains(ianaZoneId, StringComparer.OrdinalIgnoreCase))
{
log.Fine("Timezone \"" + ianaZoneId + "\" mapped to \"UTC\"");
return(tzs["UTC"]);
}
NodaTime.TimeZones.TzdbDateTimeZoneSource tzDBsource = TimezoneDB.Instance.Source;
// resolve any link, since the CLDR doesn't necessarily use canonical IDs
var links = tzDBsource.CanonicalIdMap
.Where(x => x.Value.Equals(ianaZoneId, StringComparison.OrdinalIgnoreCase))
.Select(x => x.Key);
// resolve canonical zones, and include original zone as well
var possibleZones = tzDBsource.CanonicalIdMap.ContainsKey(ianaZoneId)
? links.Concat(new[] { tzDBsource.CanonicalIdMap[ianaZoneId], ianaZoneId })
: links;
// map the windows zone
var mappings = tzDBsource.WindowsMapping.MapZones;
var item = mappings.FirstOrDefault(x => x.TzdbIds.Any(possibleZones.Contains));
if (item == null)
{
throw new System.ApplicationException("Timezone \"" + ianaZoneId + "\" has no mapping.");
}
log.Fine("Timezone \"" + ianaZoneId + "\" mapped to \"" + item.WindowsId + "\"");
return(tzs[item.WindowsId]);
}
private TimeZoneInfo getWindowsTimezoneFromDescription(String tzDescription)
{
try {
System.Collections.ObjectModel.ReadOnlyCollection <TimeZoneInfo> sysTZ = TimeZoneInfo.GetSystemTimeZones();
//First let's just search with what we've got
TimeZoneInfo tzi = sysTZ.FirstOrDefault(t => t.DisplayName == tzDescription || t.StandardName == tzDescription || t.Id == tzDescription);
if (tzi != null)
{
return(tzi);
}
log.Warn("Could not find timezone ID based on given description. Attempting some fuzzy logic...");
if (tzDescription.StartsWith("(GMT"))
{
log.Fine("Replace GMT with UTC");
String modTzDescription = tzDescription.Replace("(GMT", "(UTC");
tzi = sysTZ.FirstOrDefault(t => t.DisplayName == modTzDescription || t.StandardName == modTzDescription || t.Id == modTzDescription);
if (tzi != null)
{
return(tzi);
}
log.Fine("Removing offset prefix");
modTzDescription = System.Text.RegularExpressions.Regex.Replace(modTzDescription, @"^\(UTC[+-]\d{1,2}:\d{0,2}\)\s+", "").Trim();
tzi = sysTZ.FirstOrDefault(t => t.StandardName == modTzDescription || t.Id == modTzDescription);
if (tzi != null)
{
return(tzi);
}
}
//Try searching just by timezone offset. This would at least get the right time for the appointment, eg if the tzDescription doesn't match
//because they it is in a different language that the user's system data.
Int16?offset = null;
offset = TimezoneDB.GetTimezoneOffset(tzDescription);
if (offset != null)
{
List <TimeZoneInfo> tzis = sysTZ.Where(t => t.BaseUtcOffset.Hours == offset).ToList();
if (tzis.Count == 0)
{
log.Warn("No timezone ID exists for organiser's GMT offset timezone " + tzDescription);
}
else if (tzis.Count == 1)
{
return(tzis.First());
}
else
{
String tzCountry = tzDescription.Substring(tzDescription.LastIndexOf("/") + 1);
if (string.IsNullOrEmpty(tzCountry))
{
log.Warn("Could not determine country; and multiple timezones exist with same GMT offset of " + offset + ". Picking the first.");
return(tzis.FirstOrDefault());
}
else
{
List <TimeZoneInfo> countryTzis = tzis.Where(t => t.DisplayName.Contains(tzCountry)).ToList();
if (countryTzis.Count == 0)
{
log.Warn("Could not find timezone with GMT offset of " + offset + " for country " + tzCountry + ". Picking the first offset match regardless of country.");
return(tzis.FirstOrDefault());
}
else if (countryTzis.Count == 1)
{
return(countryTzis.First());
}
else
{
log.Warn("Could not find unique timezone with GMT offset of " + offset + " for country " + tzCountry + ". Picking the first.");
return(countryTzis.FirstOrDefault());
}
}
}
}
else
{
//Check if it's already an IANA value
NodaTime.TimeZones.TzdbDateTimeZoneSource tzDBsource = TimezoneDB.Instance.Source;
IEnumerable <NodaTime.TimeZones.TzdbZoneLocation> a = tzDBsource.ZoneLocations.Where(l => l.ZoneId == tzDescription);
if (a.Count() >= 1)
{
log.Debug("It appears to be an IANA timezone already!");
Microsoft.Office.Interop.Outlook.TimeZone tz = WindowsTimeZone(tzDescription);
if (tz != null)
{
return(TimeZoneInfo.FindSystemTimeZoneById(tz.ID));
}
}
}
} catch (System.Exception ex) {
log.Warn("Failed to get the organiser's timezone ID for " + tzDescription);
OGCSexception.Analyse(ex);
}
return(null);
}
