StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Calling a Generic BO

Calling a Generic BO

Terry Bottorff — Wed, 08 Dec 2010 09:40:21 GMT

I have a generic BO with the following Sub:

Public Sub FillAllData(ByVal objbo As Object)

Using cmd As New SqlCommand

cmd.CommandType = CommandType.Text

cmd.CommandText = String.Format("Select * from {0}", Me.TableNameAndSchema)

objbo.FillDataTable(cmd)

End Using

End Sub

Then I add a BO to my project called CowboysBO which I make sure Inherits from my generic BO. Then I call the sub using the following:

Me.CowboysBO1.FillAllData(Me.CowboysBO1)

Is my logic OK or should I be doing something else? I will use the sub to fill several different BO's and that is why I thought I needed the objbo. The above code seems to work but I don't want to get Bitten.

TIA.......

RE: Calling a Generic BO

Edhy Rijo — Wed, 08 Dec 2010 09:40:21 GMT

You are welcome Terry.

I am glad you found the problem. And keep in mind that SF BOs are greatly flexible, extensible and powerful, little by little I found the logic used behind them very nice and worthy specially when working with several projects at the same time.

RE: Calling a Generic BO

Terry Bottorff — Wed, 08 Dec 2010 09:28:24 GMT

I found the error that was causing the wrong data to load. Thank you again for your help.

RE: Calling a Generic BO

Terry Bottorff — Wed, 08 Dec 2010 06:12:50 GMT

I had my code just like yours but I was not getting the correct data. Therefore, I wanted to make sure I could do it the way you indicated and that I originally had, but I must have something not quite right in my other code which is giving me the wrong data. I did put a break on the code but I think I was looking for the BO that was being used and did not find it and did not pay any attention to the table being used.

Thank you again for your excellent help.

RE: Calling a Generic BO

Edhy Rijo — Tue, 07 Dec 2010 22:01:37 GMT

Terry,

Your code is using the objbo.FillDataTable(cmd) instead of Me.FillDataTable(cmd).

Here is how it should be. If you put a break in Me.FillDataTable(cmd) then see the value of cmd.Commandtext, notice that the correct table for the instance of the BO is used, remember "Generic", each BO is created for a specific table, hence the String.Format() code, so when you drop a BO and run the FillAllData() it will work just fine. It is a good idea to take a look at the SF source code to learn how they use this generic logic for the FillBy... methods in the BO class.
[quote]

    Public Overridable Sub FillAllData()
        Using cmd As New SqlCommand()
            cmd.CommandType = CommandType.Text
            cmd.CommandText = String.Format("Select * From {0}", Me.TableNameAndSchema)
 
            Me.FillDataTable(cmd)
        End Using
    End Sub

[/quote]

RE: Calling a Generic BO

Terry Bottorff — Tue, 07 Dec 2010 20:33:19 GMT

OK but I think I am having trouble with it filling the correct BO since I am using the same Sub to fill multiple BO's but I will try again and see what happens. Thanks.

RE: Calling a Generic BO

Edhy Rijo — Tue, 07 Dec 2010 18:51:31 GMT

Hi Terry,

You don't need to pass any parameter nor the current BO.

Your current class, by inheriting the base BO it will know from which BO the method is executing, so when you reference Me in the base BO code it will be using whatever BO you have inherited from the base.

It may sound too easy, but it works and it is the way it is :)