Akal Tech RSS Feed

Topic: Doing Left/Right Joins

Wed, 03 Sep 2008 21:34:32 GMT

Topic Description: One of the most frequent questions we get in email is how to do a left join. Here is a short code snippet that does just that.

using (Orders o = new Orders()) 
{ 
  o.Join_SalesPersonID_Users_Parent(JoinTypes.Left); 
  o.Find(); 
} 

Now if you using the strongly typed collection and you need to check if there is no associated User record you can do it like this:

foreach (Orders order in o.List) 
{ 
    if (!order.SalesPersonID.IsNull) 
    { 
        MessageBox.Show(order.SalesPersonID_Users_Parent.FirstName.Value 
            + "  " + 
            order.SalesPersonID_Users_Parent.LastName.Value 
            ); 
    } 
} 
 

Replies: 1
Last Reply: Wed, 03 Sep 2008 21:34:32 GMT
Reply By: Ish Singh

Topic: Dynamically specify object schema

Thu, 05 Jun 2008 21:07:32 GMT

Topic Description: You can specify the object's schema at run time. This can be very useful if you don't want to generate the classes or you are perhaps working with a temporary table that you do not want to map to a class. There can be several scenarios where a developer might want to perform operations on a database and wants to specify the schema at run time.

The following example shows how Business Logic Framework easily deals with this type of scenario:

1using (BaseBusinessObject bizObj = new BaseBusinessObject()) 
2{ 
3    bizObj.TableName = "Customers"; 
4 
5    // Add non primary key columns. 
6    new StringField(bizObj, "FirstName"); 
7    new StringField(bizObj, "LastName"); 
8 
9    // Add primary key column(s). 
10    Int32Field pk = new Int32Field(bizObj, "CustomerID"); 
11    bizObj.PrimaryKeyFields.Add(pk); 
12 
13    this.GridView.DataSource = bizObj.Find(); 
14    this.GridView.DataBind(); 
15} 
16 

You can also extend this code to create joins like shown below:

1using (BaseBusinessObject customerObject = new BaseBusinessObject()) 
2{ 
3    customerObject.TableName = "Customers"; 
4 
5    // Add non primary key columns. 
6    new StringField(customerObject, "FirstName"); 
7    new StringField(customerObject, "LastName"); 
8 
9    // Add primary key column(s). 
10    Int32Field pk = new Int32Field(customerObject, "CustomerID"); 
11    customerObject.PrimaryKeyFields.Add(pk); 
12 
13    // The following line ensures that the connection is shared between the two instances. 
14    BaseBusinessObject orderObject = new BaseBusinessObject(customerObject); 
15    orderObject.TableName = "Orders"; 
16 
17    Int32Field id = new Int32Field(orderObject, "CustomerID"); 
18    // You can still control the visibility or other properties just like you do if the class code was generated. 
19    id.Visible = false; 
20 
21    new DateTimeField(orderObject, "OrderDate"); 
22    new DecimalField(orderObject, "OrderAmount"); 
23 
24    customerObject.CreateJoin("CustomerID_Orders_Child", 
25        customerObject.Fields["CustomerID"], orderObject.Fields["CustomerID"], 
26        orderObject, JoinTypes.Inner, RelationshipTypes.Child); 
27 
28    this.GridView.DataSource = customerObject.Find(); 
29    this.GridView.DataBind(); 
30} 
31 

Replies: 2
Last Reply: Thu, 05 Jun 2008 21:07:32 GMT
Reply By: Javier Santana

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

Topic: Nice blog post that shows code generation from command line and also BulkDelete features

Sat, 24 May 2008 09:09:50 GMT

Thomas Waldron made a nice blog post on a few of the new features introduced in Quick Objects 3.3. The post shows the BulkDelete feature, and also how the Quick Objects Designer can be used to generate code from command line. The scenario that Thomas uses shows how Quick Objects Designer can work in a VSTS environment.

http://drowningintechnicaldebt.com/blogs/thomaswaldron/archive/2008/03/10/command-line-interface-for-quick-objects-designer.aspx

Reply: Re: Doing Left/Right Joins

Wed, 03 Sep 2008 21:34:32 GMT

If you want to create LEFT JOIN and still use LINQ thats very easy as well. Following is a quick example that shows how to do just that.

using (Orders orders = new Orders()) 
{ 
    orders.Join_SalesPersonID_Users_Parent(JoinTypes.Left); 
 
    // Return selective fields 
    var result = ( 
        from o in orders 
        select new { o.OrderAmount, o.OrderDate, o.OrderID,  
            SoldBy = o.SalesPersonID_Users_Parent.FirstName + " " + o.SalesPersonID_Users_Parent.LastName } 
        ).ToList(); 
    this.GridView1.DataSource = result; 
} 
 

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

Reply: Re: Dynamically specify object schema

Thu, 05 Jun 2008 21:07:32 GMT

I have a request.. please don't use the line numbers when posting code sample its not easy to copy paste.

Reply: Re: Dynamically specify object schema

Thu, 05 Jun 2008 21:05:49 GMT

Nice! Is it possible to do insert/update etc too and can you show some sample code for that?

1	using (BaseBusinessObject bizObj = new BaseBusinessObject())
2	{
3	bizObj.TableName = "Customers";
4
5	// Add non primary key columns.
6	new StringField(bizObj, "FirstName");
7	new StringField(bizObj, "LastName");
8
9	// Add primary key column(s).
10	Int32Field pk = new Int32Field(bizObj, "CustomerID");
11	bizObj.PrimaryKeyFields.Add(pk);
12
13	this.GridView.DataSource = bizObj.Find();
14	this.GridView.DataBind();
15	}
16

1	using (BaseBusinessObject customerObject = new BaseBusinessObject())
2	{
3	customerObject.TableName = "Customers";
4
5	// Add non primary key columns.
6	new StringField(customerObject, "FirstName");
7	new StringField(customerObject, "LastName");
8
9	// Add primary key column(s).
10	Int32Field pk = new Int32Field(customerObject, "CustomerID");
11	customerObject.PrimaryKeyFields.Add(pk);
12
13	// The following line ensures that the connection is shared between the two instances.
14	BaseBusinessObject orderObject = new BaseBusinessObject(customerObject);
15	orderObject.TableName = "Orders";
16
17	Int32Field id = new Int32Field(orderObject, "CustomerID");
18	// You can still control the visibility or other properties just like you do if the class code was generated.
19	id.Visible = false;
20
21	new DateTimeField(orderObject, "OrderDate");
22	new DecimalField(orderObject, "OrderAmount");
23
24	customerObject.CreateJoin("CustomerID_Orders_Child",
25	customerObject.Fields["CustomerID"], orderObject.Fields["CustomerID"],
26	orderObject, JoinTypes.Inner, RelationshipTypes.Child);
27
28	this.GridView.DataSource = customerObject.Find();
29	this.GridView.DataBind();
30	}
31