/// <summary>
/// Gets and bulk updates timezones. Called when the "Get and bulk update timezones" button is pressed.
/// Expects the CreateTimezone method to be run first.
/// </summary>
private bool GetAndBulkUpdateTimezones()
{
// Prepare the parameters
string where = "TimeZoneName LIKE N'MyNewTimezone%'";
// Get the data
DataSet timezones = TimeZoneInfoProvider.GetTimeZones(where, null);
if (!DataHelper.DataSourceIsEmpty(timezones))
{
// Loop through the individual items
foreach (DataRow timezoneDr in timezones.Tables[0].Rows)
{
// Create object from DataRow
TimeZoneInfo modifyTimezone = new TimeZoneInfo(timezoneDr);
// Update the properties
modifyTimezone.TimeZoneDisplayName = modifyTimezone.TimeZoneDisplayName.ToUpper();
// Save the changes
TimeZoneInfoProvider.SetTimeZoneInfo(modifyTimezone);
}
return(true);
}
return(false);
}
/// <summary>
/// Fill drop down list.
/// </summary>
/// <param name="ds">Data set with time zones</param>
/// <param name="dataValue">Data value field</param>
private void FillDropdown(string dataValue)
{
if (drpTimeZoneSelector.Items.Count == 0)
{
DataSet ds = TimeZoneInfoProvider.GetTimeZones(null, "TimeZoneGMT", -1, "TimeZoneID ,TimeZoneGMT, TimeZoneName, TimeZoneDisplayName");
if (!DataHelper.DataSourceIsEmpty(ds))
{
string text = null;
foreach (DataRow row in ds.Tables[0].Rows)
{
text = String.Format("(UTC{0:+00.00;-00.00}) {1}", row["TimeZoneGMT"], row["TimeZoneDisplayName"]);
drpTimeZoneSelector.Items.Add(new ListItem(text, row[dataValue].ToString()));
}
}
// Add none record if needed
if (AddNoneItemsRecord)
{
drpTimeZoneSelector.Items.Insert(0, new ListItem(GetString("General.SelectNone"), ""));
}
}
}