Akal Tech RSS Feed

Topic: Live view of Quick Objects Time Zones and Business Logic Framework Integration

Fri, 13 Jun 2008 20:11:44 GMT

Topic Description: These forums actually have the capability to show the post date time values in your time zone. If you are a registered user click on your name (right next to "Welcome:" on the top right corner), or go to My Account -> My Info page and set your time zone.

Now if you visit the forums again, you will notice that the date time values are no longer UTC, they are being show in the time zone you have set in your account.

Here is the sample code that can help you turn the automatic time zone conversions when selecting records.

using (Orders o = new Orders()) 
{ 
    o.TranslateTimeZones = true; 
    o.TranslateTimeZoneMode = TranslateTimeZoneModes.OnSelect; 
    o.LocalTimeZone = 4; 
    o.Find(); 
    foreach (Orders order in o.List) 
    { 
        MessageBox.Show(order.OrderDate.ToString()); 
    } 
} 
 

Replies: 2
Last Reply: Fri, 13 Jun 2008 20:11:44 GMT
Reply By: Ish Singh

Reply: Re: Live view of Quick Objects Time Zones and Business Logic Framework Integration

Fri, 13 Jun 2008 20:11:44 GMT

Mike,

The LocalTimeZone property expects a TimeZone Key from the TimeZones data. Each time zone in in the TimeZones library has a unique Key and you can assign that number to the LocalTimeZone.

The way to get the current system's TimeZone is by using System.TimeZone.CurrentTimeZone which only provides the name of the zone. To get the key, use the following code:

Dim info As Akal.QuickObjects.TimeZones.TimeZoneInformation 
For Each info In Akal.QuickObjects.TimeZones.TimeZones.GetInstance() 
   If info.StandardName.ToLower() = System.TimeZone.CurrentTimeZone.StandardName.ToLower() Then 
      MessageBox.Show(info.Key.ToString() & " = " & info.StandardName) 
   End If 
Next 
 

Hope that helps.
Ish

Reply: Re: Live view of Quick Objects Time Zones and Business Logic Framework Integration

Thu, 12 Jun 2008 19:30:25 GMT

What is the code you would use to get the local time zone value to use in the
o.LocalTimeZone = 4;
line?

Is there some way to get from local environment settings through code?

Mike