StrataFrame Forum / StrataFrame Application Framework / Business Objects and Data Access (How do I?)

Question about the design architecture

Michael Gonzalez — Tue, 09 Mar 2010 17:42:04 GMT

Does SF implement proper layered separation of concerns (SoC), such as the presentation (PLL), business (BLL), and data layers (DAL)?

Additionally, does the BLL use a Domain Model pattern with a separate Repository pattern for mapping entities to data access operations?

Also, does the PLL use an SoC pattern, such as MVC, MVP, or PM?

And finally, can I use dependency injection?

Thanks.

System.ObjectDisposedException

Rich Grimes — Tue, 09 Mar 2010 09:11:01 GMT

Hi Folks

We just started receiving quite a few of these errors and they seem to only occur when we do data access. Have you ever seen this before?

Thanks!

Rich

[quote]

** Summary **

---------------

This message contains events 1 to 2 from the total of 2 events scheduled for this notification. There were 0 events left in the buffer at the beginning of this notification.

** Application Information **

---------------

Application domain: /LM/W3SVC/33230916/Root/129122460609687500

Trust level: Full

Application Virtual Path: /...

Application Path: D:\... Machine name: ....

** Events **

---------------

Event code: 3005

Event message: An unhandled exception has occurred.

Event time: 3/5/2010 7:38:42 PM

Event time (UTC): 3/6/2010 12:38:42 AM

Event ID: be9467923d77453ba4be3a5d151aec09 Event sequence: 46459 Event occurrence: 285 Event detail code: 0

Process information:

Process ID: 7872

Process name: w3wp.exe

Account name: NT AUTHORITY\NETWORK SERVICE

Exception information:

Exception type: System.ObjectDisposedException

Exception message: Safe handle has been closed

Request information:

Request URL: https://xxx

Request path: /XXX/LookUpPages/TransportationMode.aspx

User host address: XXX.XXX.XXX.XXX

User: 1254567890

Is authenticated: True

Authentication Type: Forms

Thread account name: NT AUTHORITY\NETWORK SERVICE

Thread information:

Thread ID: 1

Thread account name: NT AUTHORITY\NETWORK SERVICE

Is impersonating: False

Stack trace: at System.Runtime.InteropServices.SafeHandle.DangerousAddRef(Boolean& success)

at SNINativeMethodWrapper.SNIPacketReset(SafeHandle pConn, IOType ioType, SafeHandle packet)

at System.Data.SqlClient.TdsParserStateObject.WriteSni()

at System.Data.SqlClient.TdsParserStateObject.WritePacket(Byte flushMode)

at System.Data.SqlClient.TdsParserStateObject.ExecuteFlush()

at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean isCommandProc)

at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)

at MicroFour.StrataFrame.Data.DbDataSourceItem.GetDataTable(DbCommand Command, OnChangeEventHandler CallBack)

at MicroFour.StrataFrame.Data.SqlDataSourceItem.GetDataTable(DbCommand Command, OnChangeEventHandler CallBack)

at MicroFour.StrataFrame.Data.DbDataSourceItem.ExecuteStoredProcedure(String SprocName, DbCommandExecutionType ExecutionType, DbParameter[] Parameters)

at MicroFour.StrataFrame.Business.BusinessLayer.FillByStoredProcedure(String ProcedureName, DbParameter[] Parameters)

at BO.Lookup.TravelMode.Fill()

at LookUpPages_TransportationMode.Page_Load(Object sender, EventArgs e)

at System.Web.UI.Control.OnLoad(EventArgs e)

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

[/quote]

[quote]

---------------

Event code: 3005

Event message: An unhandled exception has occurred.

Event time: 3/5/2010 7:38:43 PM

Event time (UTC): 3/6/2010 12:38:43 AM

Event ID: b7c1c9a7dd87485787c6d62a5206d596 Event sequence: 46461 Event occurrence: 286 Event detail code: 0

Process information:

Process ID: 7872

Process name: w3wp.exe

Account name: NT AUTHORITY\NETWORK SERVICE

Exception information:

Exception type: System.ObjectDisposedException

Exception message: Safe handle has been closed

Request information:

Request URL: https://....

Request path: /XXX/GeneralError.aspx

User host address: XXX.XXX.XXX.XX

User: 124567890

Is authenticated: True

Authentication Type: Forms

Thread account name: NT AUTHORITY\NETWORK SERVICE

Thread information:

Thread ID: 1

Thread account name: NT AUTHORITY\NETWORK SERVICE

Is impersonating: False

Stack trace: at BO.PCSDataPackage.IsSubPackage(Int64 DataPackageID)

at Controls_Header.Page_Load(Object sender, EventArgs e)

at System.Web.UI.Control.OnLoad(EventArgs e)

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

[/quote]

The given key was not present in the dictionary error

Edhy Rijo — Fri, 29 May 2009 20:15:13 GMT

Hi,

I am working with a DataGridView in a child form, if I cancel the childform with the follwing code:

[codesnippet]DialogResult = Windows.Forms.DialogResult.Cancel[/codesnippet]

Then I get the following exception:

[codesnippet]
KeyNotFoundException
The given key was not present in the dictionary.

Source : mscorlib

Stack Trace:
at System.ThrowHelper.ThrowKeyNotFoundException()
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at MicroFour.StrataFrame.Business.BusinessLayer.get__CurrentDataTable(Boolean IsSharedTable)
at MicroFour.StrataFrame.Business.BusinessBindingSource.RemoveBOHandlers()
at MicroFour.StrataFrame.Business.BusinessBindingSource.Dispose(Boolean disposing)
at System.ComponentModel.Component.Dispose()
at System.ComponentModel.Container.Dispose(Boolean disposing)
at System.ComponentModel.Container.Dispose()
at CardTrackingSystem.frmActivateCardsItems.Dispose(Boolean disposing) in E:\Visual Studio 2008 Projects\StrataFrame\Card Tracking System Projects\CardTrackingSystem.NET\CTS Solution\Card Tracking System\Dialogs\Transaction Forms\Activate Cards\frmActivateCardsItems.Designer.vb:line 10
at System.Windows.Forms.Form.Close()
at MicroFour.StrataFrame.UI.Windows.Forms.ChildFormDialog.ShowDialog(Object[] Arguments)
at MicroFour.StrataFrame.UI.Windows.Forms.ChildFormDialog.ShowDialog()
at CardTrackingSystem.frmActivateCards.cmdAddCards_Click(Object sender, EventArgs e) in E:\Visual Studio 2008 Projects\StrataFrame\Card Tracking System Projects\CardTrackingSystem.NET\CTS Solution\Card Tracking System\Dialogs\Transaction Forms\Activate Cards\frmActivateCards.vb:line 800
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
at System.Windows.Forms.ToolStripButton.OnClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ToolStrip.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativewindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativewindow.WndProc(Message& m)
at System.Windows.Forms.Nativewindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

[/codesnippet]

The DataGridView is being populated with a BBS and the error only happens if the grid has some data. I don't know what "Key" it may be looking for? Also I would like to note that the BO assigned to the BBS has come Custom Field Properties which are not used in the DataGridView.

Error during deleting BO record in a Form

Luiz Lima — Sat, 20 Feb 2010 09:05:45 GMT

Hi,

I have a form with a ParentBO and 3 children (I´m using DevExpress grid with BBS).
When I try to delete the record by Form, appears this message below.

I´ve been looking for some configurations on my BOParent or Form and .. Nothing....:crying:
This occurs when BoChildren are filled or not.

Some help guys?

--------------------------------------------------------------------------------------------------------
NullReferenceException
Object reference not set to an instance of an object.

Source : MicroFour StrataFrame Business

Stack Trace:
at MicroFour.StrataFrame.Business.BusinessLayer.DeleteChildRecords(Boolean OnlyMarkAsDeleted)
at MicroFour.StrataFrame.Business.BusinessLayer.DeleteCurrentRow(Boolean CheckSecurity, Boolean OnlyMarkAsDeleted)
at MicroFour.StrataFrame.UI.Windows.Forms.BaseForm.Delete(Boolean OnlyMarkAsDeleted, Boolean CheckSecurity)
at MicroFour.StrataFrame.UI.Windows.Forms.MaintenanceFormToolStrip.cmdDelete_Click(Object sender, EventArgs e)
at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
at System.Windows.Forms.ToolStripButton.OnClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ToolStrip.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativewindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativewindow.WndProc(Message& m)
at System.Windows.Forms.Nativewindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
--------------------------------------------------------------------------------------------------------

multi-table BO question

Keith Chisarik — Thu, 25 Feb 2010 14:26:34 GMT

Since I need to have a view to map my business objects to when pulling data from many tables, what (if any) is the advantage of populating via a SPROC versus using the view I already have defined for mapping?

I like (in theory) not having to keep the SPROC and views in sync. In admittedly limited testing performance seems equal.

Thanks in advance for your opinions, as always.

Method A (mapped to view, populate via SPROC, passing in parameters):

[quote]

Public Sub FillBySprocGetRosterValues(ByVal p_rosterPK As Integer)

Dim cmd As New SqlCommand()

cmd.CommandType = CommandType.StoredProcedure

cmd.CommandText = "dbo.sdsi_GetRosterValues"

'-- Create the parms

cmd.Parameters.AddWithValue("@rosterPK", p_rosterPK).SqlDbType = SqlDbType.Int

'-- Return the results

Me.FillDataTable(cmd)

End Sub

[/quote]

Method 2 (Map to view, populate BO using the view):

[quote]

Public Sub FillBySessionPK(ByVal p_sessionPK As Integer)

'-- Establish locals

Dim loCommand As New SqlCommand()

'-- Build the query

loCommand.CommandText = "SELECT * FROM vwAllAcademiesBySession WHERE sxa_session_fk = @param1"

'-- Add the parameter

loCommand.Parameters.Add("@param1", SqlDbType.Int)

loCommand.Parameters("@param1").Value = p_sessionPK

'-- Execute the command to fill the business object

Me.FillDataTable(loCommand)

End Sub

[/quote]

TransactionKey property

Ertan Deniz — Fri, 11 Apr 2008 08:39:28 GMT

I think this key is used to get DbTransaction object from Transaction Collection.

(DataBasics.DataSources[""].Transactions).

Normally, When BusinessLayer.TransactionBegin is called a DbTransaction Object is added to the collection with a default key value. This default transaction will be used.

When do I need simultaneous transactions ? I mean, When will be more than one transactions in that collection. So I will follow a key.

Question on Tutorial

Bo Harris — Wed, 24 Feb 2010 10:03:29 GMT

Working through the tutorial and got the CustomerMaintenance form up and running. However when I click on "New" an InvalidCastException is thrown.

Exception message states "Unable to cast object of type 'System.DBNull' to type 'System.String'." Offending line of code is in the 'get' accessor for the CustomerID field and reads - "[font=Courier New]return (System.String)this.CurrentRow["CustomerID"];[/font]".

I know I can put in some code in the get accessor to check for DbNull but was just wondering if there is a property or something that can be set to true so that the generated code will automatically account for null scenarios.

BO's vs Table Adaptors for reporting (DevExpress XtraReports)

Peter Jones — Thu, 27 Mar 2008 00:00:14 GMT

Hi,

A bit of general input please.

I’m currently investigating how we will implement reporting using DevExpress XtraReports. We are going down the XtraReports path because we use DevExpress controls and, hoperfully, just keeping our development toolset to StrataFrame and DevExpress will make life easier and XtraReports looks like giving us all we want in a report writer.

I’ve been back through the forum looking at all the ‘reporting’ posts and it seems as though using SF BO’s for reporting has been successfully implemented around the place although, I must admit, I haven’t been able to manage that trick yet. However, what I have seen so far concerns me in that getting data into a report appears to involve first getting a report’s data into the BO’s used in a report then doing a table copy to get the data from the BO’s into the report itself. I see this as being somewhat inefficient and, as our system it used by quite a few reporting users during production (average inserts of 40 or so new transactions every minute into an 11 million row transaction file) then efficiency is always front of mind. The application uses thin clients under terminal services so, in our case, there’s no advantage in storing copies of data in BO’s that are local to the user’s PC.

It seems to me that using Table Adaptors to execute stored procedures to get the data into our reports is the best way to go but I wonder if anyone would care to comment on the benefits of using SF BO’s over Table Adaptors and/or the disadvantages of Table Adaptors. Indeed, maybe my understading that report data must first populate BO's then be copied as a table into the report is off target.

Cheers, Peter

BO and BBS with Sharpshooter

Ross L. Rooker, Sr. — Thu, 12 Mar 2009 10:50:21 GMT

Trying to confirm something about Sharpshooter filter parameters within Sharpshooter itself.

I have a VIEW that defines what tables need to be related and how. Created a SF BO to be able to map the VIEW to a BO. Then created a Custom BBS on the BO.

Naturally until a call is made to fill the BO no data is filled.

If you reference the BBS in the Sharpshooter report as a Datasource, then put filter expression on the report as parameters, will Sharpshooter return:

A. All data to fill the BO and then filter based on the Sharpshooter filter expressions? , or

B. Does Sharpshooter generate a SQL SELECT with the parameters already built into the SELECT statement thereby returning only the ropws needed?

From what I can see, I believe "A." is what Sharpshooter does.

BBS does not show Custom Field (CFP)

Luiz Lima — Thu, 18 Feb 2010 05:04:32 GMT

Hi,

I created some CFPs but they don´t appears on my selection field when I use a BBS with DevExpress Grid.

Anybody can help me?

Tks

How configure businessobject to use view?

dgsoft — Wed, 13 Jan 2010 09:55:05 GMT

Hi,
I have some view and want to use business object to provide access to this view (bind to grid, use as datasource and so on)
So,
I create view using DDT, then deploy it
Then I create new business object, start Business object mapper
Select business object
Click "Configure"
Then using "DDT" option in optiongroup - click "Select" - and there only tables are listed.

The question is:
How can I create business object based on view?

Thanks
Denis

Cannot insert explicit value for identity column

Buluc Celik — Mon, 15 Feb 2010 08:47:21 GMT

Hi,

I am getting the following error while trying to insert a record using businessObject1.save():

Cannot insert explicit value for identity column in table 'MyTable' when IDENTITY_INSERT is set to OFF.

I tracked the problem and found out that the SQL generated to insert the record has the auto-increment primary id field set to NULL.

Things I tried:

1. I setted the ID field to readonly from the Business Object Mapper -> same error
2. I captured the exact SQL, removed the ID field and run it on SQL Server Management Studio -> worked at that run
3. I added the ID field to FieldsToExcludeFromInsert property of the business object -> the application gave the error: Cannot create INSERT command because the updating DataTable does not contain columns for all PrimaryKeyFields.

I compared the business object I created for that application with a business object from the samples - which also has a auto-increment primary key field (cust_pk), and it seems to have the same structure. I didn't see any difference that could be the reason of the problem I am having.

I am still trying to find the problem, but any help would be very much appreciated.

Thanks,

Buluc

Auditor Class

Aaron Young — Wed, 18 Nov 2009 15:33:55 GMT

Hi,

Is anyone using the Auditor class?

I have added the following code to the BeforeSave and AfterSave business object events but nothing happens:-

Auditor.InsertAuditRecords(this);

I have enabled auditing for both the business object and the current user but the following returns false:-

Auditor.ShouldAuditDataChanges(this);

I think I am having another dumb moment but I can't see what is wrong.

Thanks,

Aaron

ListView, BO, and passing a Dictionary to the BO's Fill()

Alex Luyando — Wed, 10 Feb 2010 13:24:09 GMT

H-

Having an issue filling a listView based on a BO filled using a stored procedure. Will try to distill the scenario below, hopefully not omitting any key elements.

[b]--- Intro --------------------------------[/b]
The BO has a fill method with the following signature.

public void FillAfterRefresh(Dictionary tdictParameters)

The dictionary passed in includes values used as parameters in the call to the stored procedure.

The form has a listVview on it, that I want to populate using the result set returned by the stored procedure. It is set to manually populate, and I've specified the appropriate BO class and the above fill method.

For testing/debugging purposes I've thrown a few controls on the form as well and bound them to BO fields.

[b]--- Observations/Problems ---------------------------------[/b]
1.) If I drop an instance of the BO onto the form, and call the above Fill method, passing a reference to a dictionary in as the lone argument, the fill works great (confirmed via the debugger and by being able to view the results in the test controls on the form).

2.) When I attempt to set the List View Population Settings, I see my fill method, but the parameter shows as (Dictionary`2). Not sure what's up with this? (But, willing to run it anyway since it compiles.) Note: See attached PNG.

3.) If I try to call the listview's requery, passing in the dictionary (either in the requery call or in the ListPopulating event using e.Parameters[0].Value = this.oDictUserInfo;) I get an immediate error at runtime:

Dynamically populating the ListView failed. Could not create and fill the business object of type 'IndexReviewSystem.Business_Objects.Reporting_Objects.boIRSPredictiveCompositionNullProblems'

Inner Exception Message: "Dynamically populating the ListView failed. Type 'System.Collections.Generic.Dictionary`2[[System.String' could not be found."

Can someone help me make sense of this?

I feel I have a workaround as I can put a BO on the form, fill it, then copy the filled datatable to the listview's internal datatable. I feel, however, I shouldn't need to do that… I'd really like to understand what's going on.

TIA

Regarding Strata Frame and CoreLab MySQL

Mike Rogers — Fri, 14 Mar 2008 18:06:08 GMT

I was wondering if anybody has used CoreLabs MySql control with StrataFrame.

Mike

Best practice question on Date columns

Ross L. Rooker, Sr. — Mon, 08 Feb 2010 21:13:18 GMT

If we have a BO that has a datetime column that we may at times want to use the date picker against in Strataframe what is the best method of setting the default in the BO Mapper and what is the difference between each method? IE... advantages, etc: FYI I mainly have used the first method which seems to work for SQL and Oracle.

First Setting: NULL VALUE OPTION = Return Alternate on Null / Set Null on Alternate (Value Type) and the NULL REPLACEMENT VALUE = new DateTime(1800, 1, 1)

Second setting: NULL VALUE OPTION = Return Alernate on Null and the NULL REPLACEMENT VALUE = Convert.ToDateTime("1800-01-01 00:00:00.000")

ExecuteNonQuery issue with creating Temp Table

Victor Sousa — Mon, 08 Feb 2010 18:23:17 GMT

I keep getting the following error whenever i try to access a temp table that was created using the ExecuteNonQuery method:

Invalid object name '#tList'.

I have the code within a data retrieval method of a BO.

[codesnippet]
this.FillDataTable(cmd);

if (this.MoveFirst())
{
this.ExecuteNonQuery("CREATE TABLE #tList (poitemsextended_pk int, po_no varchar(10), part_no varchar(30))");

SqlCommand tcmd = new SqlCommand();
do
{

tcmd.CommandText = "INSERT INTO #tList (poitemsextened_pk, po_no, part_no) VALUES (@poitemsextended_pk, @po_no, @part_no)";

int poiepk = this.CurrentRow["PoIEpk"] == DBNull.Value ? 0 : (int)this.CurrentRow["PoIEpk"];

tcmd.Parameters.AddWithValue("@poitemsextended_pk", poiepk).SqlDbType = SqlDbType.Int;
tcmd.Parameters.AddWithValue("@po_no", this.po_no).SqlDbType = SqlDbType.VarChar;
tcmd.Parameters.AddWithValue("@part_no", this.part_no).SqlDbType = SqlDbType.VarChar;

this.ExecuteNonQuery(tcmd);

} while (this.MoveNext());

[/codesnippet]

The error is returned on this.ExecuteNonQuery(tcmd) at the end.

I've tried passing the insert as a string instead of an SqlCommad but i get the same error. I've also tried creating a global table prefixing tList with ## with same results.

Any help would be greatly appreciated.

BOM-generated bug with FieldChangingEvents and Nullable Fields

Kirk M Sherhart — Wed, 13 May 2009 13:42:46 GMT

If a field has a Null Type of "Return and Set Alternate on Null..." and the Property Changing Events (either single or multiple) are generated, then the following code is generated.

[codesnippet]public System.String FIELD1
{
get
{
object loValue;
loValue = this.CurrentRow["FIELD1"];
if (loValue == DBNull.Value)
{
return "";
}
else
{
return (System.String)loValue;
}
}
set
{
MyBOFieldChangingEventArgs e = new MyBOFieldChangingEventArgs(MyBOFieldNames.FIELD1, value);
this.OnFieldPropertyChanging(this, e);
if (value != "") <=== :w00t:*** Note: e is not used!!!! ***
{
this.CurrentRow["FIELD1"] = value;
}
else
{
this.CurrentRow["FIELD1"] = DBNull.Value;
}
}
}
[/codesnippet]

The e.FieldValue is not used after returning from the event!!!! The e.FieldValue should be cast/set to value (as it is if the field is not nullable.)

Detecting DB Connection State

Bill Cunnien — Tue, 02 Feb 2010 10:25:39 GMT

Good morning,

I am revisiting a topic that may have been touched on before (I did search for it, but could not find any direct forum entries). I apologize if I am re-walking on some old ground.

I'd like to have a mechanism to alert the user that a database connection has been lost or regained. Is it possible to get this information from the DataLayer? Or, do I need to create my own test (perhaps in its own thread?) and bubble up the response to the currently running application thread? Ideally, I prefer a graceful message to the end-user that the connection to the database is down and all data access functionality has been temporarily stopped. After the connection is reestablished, the system would generate a message to the end-user that the connection is back online and work can continue normally. For a similar functionality, consider the message Outlook provides when the Exchange server cannot be communicated with.

Thanks!
Bill

Truncating string values on Save

Peter Jones — Fri, 22 Jan 2010 00:45:33 GMT

Hi,

We had a curious issue today. A form exceptioned because column length value (by mistake) in the database was too short - just 20 characters when it should have been 100.

The database was corrected but in testing I noted that when I entered 40 characters what is saved to the database is 22 characters. If enter 40 characters in EM then no problems so it is something in the form. So, I assume the truncation must be happening in the BO and what I didn't do is remap and compile the BO after I changed the column length.

So, a few questions:

1) Does SF trim form data to the maximum a column can accept during the Save operation.

2) If 1 is true then after changing column lengths does the associated BO need to be recompiled.

3) If 2) is true then it would appear there may be a bug in the SF code in that a nvarChar(20) column is being saved with 22 characters not the 20 as was originally mapped.

BTW we use DevExpress but I can't see how that would effect things.

Cheers, Peter

How to properly dispose a BO?

Edhy Rijo — Wed, 30 Sep 2009 10:47:09 GMT

I have a process that will load a couple of million records in BO to do a duplicate record search. My process will import thousands (360K+) of records and then I need to make sure those records does not exist in the database, so instead of querying the data 360k+, I load a BO with all possible duplicate records to check against and this is the million records BO.

Now the problem is that even when I do a BO.Clear to remove those records the application keeps using a lot of memory (over 1gb) and that memory is not released until the whole application is closed, so when the import process starts again, it will blow up with a not enough memory to complete the process.

So what should I do in order to make sure that the memory used once the million record BO is filled is released when using BO.Clear?

Also I am open to suggestions to change my approach if I need to.

Thanks!

UpdateUsingStoredProcedure on a subclassed BO

Michel Levy — Wed, 27 Jan 2010 07:01:21 GMT

Hi,

In my project, all BO come from a BO library, in which they are all set with UpdateUsingStoredProcedure as True.

When I set UpdateUsingStoredProcedure as False on a BO on a form, this setting seems to be overridden by the setting of the BO in the BO library: saving by formSave raises an error (unable to find the update SP on the database).

I need to dynamically set it to False in the overriding function Save, before calling MyBase.Save

Is it anything I don't understand on subclassing in .Net?

About GridControl (DevExpress), please help me

Robinson Robinsonit Robinson_niit — Wed, 27 Aug 2008 12:43:36 GMT

[code]
'
'get value of current row
'
Private Sub loadQByID_Grid()
Dim ds As New DataSet()
Dim dr As DataGridViewRow = gv.CurrentRow
Dim str As Integer = Convert.ToInt16(dr.Cells(0).Value.ToString())
Try
ds = getQuestionByID(str)
txtContent.Text = ds.Tables(0).Rows(0).Item(1)
Catch ex As Exception
Dim strError As String = "Error : " + ex.Message()
End Try
End Sub
[/code]

This above code, I use DataGridView.
I want to use GridControl (DevExpress).
But when I used it, I don't see any object [b]DataGridViewRow[/b] and method [b]CurrentRow[/b]
How do I use GridControl (DevExpress) to get value of current row.
Please help me
Regards
PS: you can use C# to solve

My BO don't move when I use the BrowseDialog and OLEDB VFP Table

Elio Reyes — Thu, 02 Oct 2008 13:57:33 GMT

Hi

When the Browse Dialog is working, I can search, sort results... Everything is Ok, but When I use SF Browse Info Panel or try to get the result pointer from the search... The BO is steel in the first record.

Thanks SF

Transactional Replication and NextID Tables

Bill Cunnien — Thu, 14 Jan 2010 08:45:12 GMT

We are reconsidering placing a second SQL Server in our remote office. In order to have all data available we would like to implement transactional replication. The scenario will allow us to have read/write options at both offices. I will adjust the SF application to recognize which server to use based on the physical location of the user. That should not be a problem.

Now, we also have a nice little setup for incrementing a number of different record IDs (order ID, packing list number, credit memo ID, etc.). I created a NextID table that allows us to have some nice control over these numbers used to track our various records. It works great.

Enter transactional replication.

What will happen to our nice NextID setup? In what ways do I need to change our approach in order to have the same basic functionality. I fear that a person in the remote location will create a new record and be handed an ID that is the same as the ID just handed out to the user in the main office. Impending crash detected.

Thanks for your input!!
Bill

How to SUM child BO field into parent

Luiz Lima — Thu, 07 Jan 2010 11:56:10 GMT

Hi,

I´d like to sum a field value from a Child BO into its parent.
Is there a method to do that automatically?

Example:

BoOrders
field: orderTotalProduct

BoOrdersItens
field: orderItemTotalProduct

While the user input orderItemTotalProduct, the field orderTotalProduct would receive the sum from child (in the EditState set as Adding or Editing).

Tks ;)

CopyDataFrom does not work

Rainer Kempf, RK — Fri, 08 Jan 2010 05:08:01 GMT

Hi,

I have a problem with CopyDataFrom. I have some DataSet and DataTable filled with data. Then I want to export this data through BusinessObject to SQL Server. I have correct data in the BO.CurrentDataTable, but after Save() I have no data on SQLServer. Save operation returns success.
I have a next code

Dim loBBDS As BestbuyImportDataSet = CType(toDS, BestbuyImportDataSet)
If loBBDS.vbestbuy.Count > 0 Then
Dim loVBestbuyBO As MKS.GoliathNet.BusinessObjects.ErpBestbuy.vbestbuyBO = New vbestbuyBO
loVBestbuyBO.mmks_deletemanufacturerartikels(_pmks_businessObject.driver_manufacturer_pk_id)

loVBestbuyBO.CopyDataFrom(loBBDS.vbestbuy, MicroFour.StrataFrame.Business.BusinessCloneDataType.ClearAndFillFromCompleteTable)
If loVBestbuyBO.IsDirty Then
MessageBox.Show("IsDirty")
End If

If loVBestbuyBO.Save() = MicroFour.StrataFrame.Data.SaveUndoResult.Success Then
MessageBox.Show("SaveSuccess")
End If

So step by step.
loBBDS.vbestbuy.count has 6000 records
After CopyDataFrom - businessObject CurrentDataTable has also 6000 records
IsDirty - FALSE!!!
Save() is Success! And NO DATA ON SQL SERVER!

Any help!
Thanks!

Generic BO?

Ian Hammond — Mon, 04 Jan 2010 05:16:28 GMT

My application can read a user defined database whose structure is not known until runtime. A separate application allows the user to create the database and saves information in a known configuration database which comprises the field names and the type of controls to be created on the WinForm top display the data. I'm not sure where to start to create a generic BO (if possible) that can perform the CRUD operations on the 'unknown ' database structure. Can anyone point me in the right direction,

Many thanks for your time

Custom field enum data type throwing cast error

Rob Toyias — Thu, 16 Aug 2007 12:24:47 GMT

I am receving an error retreving a value from a field that has been customized to map to an enum. In the BOM I set the ACTIONTYPECODE field to use the InspectionType Field Data Type. No problems there. I build partial and get the following code in my .Designer file:

[Browsable(false),BusinessFieldDisplayInEditor(),Description("ACTIONTYPECODE"),DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)]
public InspectionType ACTIONTYPECODE
{
get
{
return (InspectionType)this.CurrentRow["ACTIONTYPECODE"];
}
set
{
this.CurrentRow["ACTIONTYPECODE"] = value;
}
}

and here is the enum:

public enum InspectionType
{
Foo= 0,
Bar= 1,
Zip= 2
}

Nothing too complex. Stepping through the cose I can assign a value to ACTIONTYPECODE without issue. But when I hit the 'Get' I end up with this error:

Cannot unbox 'this.CurrentRow["ACTIONTYPECODE"]' as a 'InspectionType'

Now this would make sense to me since the field seems to be stored as a string and last time I tried I had to do something like this: (InspectionType)Enum.Parse(typeof(InspectionType), "Foo"); to cast a string as an enum. What am I screwing up? :ermm:

BBS & Report Sharphooter perfromance issue.

Larry Caylor — Tue, 15 Dec 2009 16:04:12 GMT

Attached is a sample program that creates two Report Sharpshooter reports; one using a SF BBS as the data source and one that uses a dataset. Aside from the data source both reports are identical. The sample program uses the SF Sample database as its data source. What I've found is that when a BBS is used as a data source, it takes RSS longer to render the report and the rendering time increases dramatically as the number of records increases. The SF sample DB only contins around 19K customer records but this is sufficient to demonstrate the difference. On my development system the BBS based report takes about 43 seconds to render while the dataset based report takes about 6 seconds. The tests were run outside of VS. Is this to be expected when using a BBS as a report data source or am I missing something that could improve performance? The sample was created using SF 1.7.0.2 and RSS 4.0.3.5.

Restoring SF Project onto another machine

Gerard O Carroll — Tue, 22 Dec 2009 11:13:53 GMT

This is a continuation on from another thread as I have not this resolved. On previous thread, I had copied from my local PC up to a server, and restored all datatabses, Source Projects and the SF database. Everything seemed to restore ok ecept the Business Object Mapper stuff. I manually reset up all the Business Objects to resolve the issue.

I now have copied down all the stuff from the Server to my local PC, and again just cannot get the Business Object Mapper stuff working on my local PC . Initially when it came down, even though all database tables were ok, and had new fields etc , the Buisness Object mapper looked as if it was hanging on to an older version (e.g. New fields I had added on are no longer in the Businee Object Mapper, and it is showing up fields that had been deleted while ago.)

To recap,

I backed up a)My Source b)My App Database c)Strataframe database

I then restored a) b) and c) onto my local PC

I must be missing something !!!!

Concurrency Using RowVersion Problem

Jeff Pagley — Fri, 21 Mar 2008 09:46:47 GMT

Hi Guys,

As I have said before, I am a part time programmer and seem to be little rusty all of the time. With that said, after following the help instructions, I am unable to get SF concurrency using RowVersioning to work. User A and User B are editing the same record at the same time using the code below. User A saves the record. Then User B saves the record and the BO does not throw an exception. What am I doing wrong? Thanks for the help!

I have the following properties set on the ContactsBO:

CollisionNoficationType = ThrowException

RowVersionOrTimestampColumn = ContactRowVersion (datatype int - allow nulls)

UpdateConcurrencyType = OptimisticRowVersion

Code Below..............................

Using loBO As New ContactsBO

loBO.FillByPrimaryKey(contactID)

If loBO.IsEmpty Then

Return False

Else

loBO.Edit()

loBO.UserID = GlobalVariables.CurrentUserID

loBO.Save()

Return True

End If

End Using

Catch ex As MicroFour.StrataFrame.Data.DataLayerException

MsgBox("DataLayerException ex = " & ex.Message)

Return False

Catch ex As MicroFour.StrataFrame.Data.DataLayerSavingException

MsgBox("DataLayerSavingExeption ex = " & ex.Message)

Return False

Catch ex As MicroFour.StrataFrame.Data.RowNotUpdatedException

MsgBox("RowNotUpdateExeption ex = " & ex.Message)

Return False

Catch ex As Exception

Ems.HandleException(Me, ex)

Return False

End Try

BBS & Role Based Security

Larry Caylor — Mon, 14 Dec 2009 19:56:43 GMT

I've been having performance issues with Report Sharpshooter when using a BBS as a datasource (see http://forum.strataframe.net/Topic20268-14-1.aspx). I was putting together a small test app and couldn't reporduce the performance issue until I noticed that my test app was a standard SF application without security. When I put together a test using a SF app with security, the performance issue was back. It would appear that there is something going on when Role Based security is added that impacts the rendering time for Report Sharpshooter. Are there any BO properites that I should be setting in this situation?

Business Object from Joined Tables

Gerard O Carroll — Fri, 11 Dec 2009 10:42:12 GMT

I have many requirements to be able to show on a ListView/Combobox the results from multiple joined tables. (e.g.Show Transactions but join in the Stock Description from a joined file). I have gone through a lot of the threads here to get hints , and have it working fine on a Combobox , but would like to ensure there are no Gotchas for any of the other list types , or maybe there is a better way.

[codesnippet]1. Say my data is required from two Tables, Tran and Products, where Products gives the description
2. I have set up a 'Dummy' business Object which will be used for ALL my Joined Tables (Query ? Can I do this with just one Dummy Business Object for ALL my lists)
3. I have a Stored Proccdure which Joins the Tables Tran and Products
4. I specify the Dummy Business Object as the BusinessObjectType in the PopulationDataSourceSettings 9With a different Stored procedure depending on the Tables)
(When entering the Columns, I [u][b]type in the column names [/b][/u]as they will not be in the buisness Object when it is initially set up)
5. My main concern is that I am using in effect a Multi Table Business Object (whereas when Business Objects are being set up they are limited to One Table only) and wonder if this will cause any problems in SF[/codesnippet]

Any comments would be helpful

Setting AutoAdjustmaxLength in base class

Gerard O Carroll — Mon, 07 Dec 2009 04:16:51 GMT

I want to set the AutoAdjustMaxLength to true in my Base Class Textbox. Where is the best place to put this and also to ensure it does not fire for Text Boxes that are not bound to a Business Object

Subclassing a SF ComboBox

Gerard O Carroll — Wed, 25 Nov 2009 05:45:41 GMT

I have subclassed a SF combo box as:

[codesnippet]public class ComboBox : MicroFour.StrataFrame.UI.Windows.Forms.ComboBox
{
}[/codesnippet]

However, when I use this, I get an error. Do I need to run the base code for ListPopulatingEvent (as I use this) or any other code in my subclassed control ?

Error trying to Restore Strataframe database

Gerard O Carroll — Thu, 12 Nov 2009 05:35:07 GMT

I am trying to move my app from one Machine to another. I have backed up the StrataFrame database on Machine1. When I do a restore on Machine2 I get message in SSMS:

[codesnippet]Restore failed for Server Server2
The backup Set holds a backup of a database other than the existing 'StrataFrame' database.[/codesnippet]

The same thing happens for the StarataframeSample database. But if I backup my own database, it restores fine onto Server2. Anybody throw any light on whats happening here ?

c# keyword in table using business object mapper

Victor Sousa — Tue, 17 Nov 2009 21:18:35 GMT

How do I use the business object mapper on an SQL table which contains a field that is a key work in c#?
The field name is void.

I do not have control of these field names. I need to query data from an existing ERP system.

Is there anyway to use the @ prefix on the field names?

I actually do not need this field in the result set. Is there a way to instruct the BOM to use only certain fields for the BO definition?

Business Object Performance

Paul Chase — Fri, 06 Nov 2009 11:36:49 GMT

I have a routine that is importing Foxpro Data. This week made some changes and added a few larger tables(more records and more fields) to the import routine that has been running for months. These "new" tables are by no means crazy huge as the largest one is right around 75,000 records and 30 or so fields. This routine has been running at night so I never really noticed if this has always been an issue. however while debugging changes noticed that the performance was lacking..

Once I started looking onto it I was very suprised at the perfomance vs a plain datatable. I did expect a business object to have some additional overhead over a vanilla datatable , however I was expecting a very minimal difference compared to the results I am seeing. Perhaps I am missing something easy like not setting a business object property or I am looking at something completly wrong. Whatever it is there seems to be a huge performance difference that I would like to get to the bottom of it.

To take anything I was doing out of the mix I created a test project that uses the stataframe sample orderitems table as a source and destination bo. I then created a standard plain old vanilla BO mapped to the items table. The only business object property that is changed from default is the "allowsnullvaluesonnewrow" is set to true.

Basically I fill a 'source' business object Then loop through the 'source' business object and create a new row on a destination object and sets the value of a field on the destination object from the source .

[codesnippet]

Business Object Example

'Set Start Time

starttime = DateTime.Now

'Loop through filled Business Object

For Each bo As itemsbo In SourceBO.GetEnumerable

'Create New Row in Destination Business Object

DestinationBO.NewRow()

'Set Value of 1 field

DestinationBO.orit_Quantity = bo.orit_Quantity

'Set Stop Time

stoptime = DateTime.Now

'Set Elapsed

elapsed_time = stoptime.Subtract(starttime)

[/codesnippet]

[codesnippet]

Same routine using a vanilla datatable.

'Set Start Time

starttime = DateTime.Now

'Loop through filled Business Object

For Each bo As itemsbo In SourceBO.GetEnumerable

lorow = dt.NewRow

'-- Set Value of 1 fld

lorow("orit_Quantity") = bo.orit_Quantity

'-- Add the new row to the data table

dt.Rows.Add(lorow)

'Set Stop Time

stoptime = DateTime.Now

'Set Elapsed

elapsed_time = stoptime.Subtract(starttime)

[/codesnippet]

Here are my results based on 50,000 records from the strataframe order items table. These times do not include any filling of data or saving of data.

Use a bo to create a new row and set no values .54 seconds

use a bo to create a new row and set the value of one field 5.04 seconds

use a bo to create a new row and set the value of two fields 9.51 seconds

use a bo to create a new row and set the value of 3 fields 14.17 seconds

----------------Data Table--------

Use a datatable to create a new row and set no values .21 seconds

use a dt to create a new row and set the value of one field .31 seconds

use a dt to create a new row and set the value of two field .45 seconds

use a dt to create a new row and set the value of 3 fields .51 seconds

Storing and then binding to a collection

Charles R Hankey — Thu, 05 Nov 2009 12:31:05 GMT

Hear me out. This is either an interesting idea or the Vicodin the dentist gave me yesterday is messing with me.

I am writing an app that fills in insurance policies using PDF forms. The forms are very structured in that Additional Insured - for example - may have 12 fields named ADDINSURED1 ( to 12) on the PDF form. There are perhaps 100 distinct fields like this on the 50 or so forms that need to be filled out, and some fields appear on more than one form. There are potentially, therefore, in the normalized tabular data world 100 child tables of the policy table. But the number of possible children is quite fixed ( by the PDF forms - which I do not in any way control ) and is always between 2 and 21.

All data entry is done on the policy form (and in the future options will exist for reading / translating data into the policy storage structure from other systems ). Then about 50 forms are all filled out, another 50 static PDFs added, all the forms sequenced a certain way and it is all joined into one big PDF. ( iTextsharper is the indispensible tool for all this and once you get the hang of it it is quite elegant and very fast )

Creating a data-entry interface for this is the challenge, and it is preferred that there be some other approach than 100 child tables.

I have chosen, so far, to use multiline text boxes for the data entry, and then parse the rows into the fields for that datum so that a textbox for Additional Insured could hold up to 18 lines and would fill the 18 text fields on the form.

This is working quite well and the client loves it.

The problem of course is that since the data is just string, dates, currency amount, logicals etc cannot be easily validated and interface gives no help.

But if I could store collections of however many items there were to enter and then easily bind to the collection items, it would be ideal

For example, a possible 5 dates in a collection would be stored in one sql column - a byte() {} I suppose ? - and then read out and bound to 5 controls on the form.

My question is has anyone done anything like that and are there any hints for an elegant and reasonably generic way to accomplish this collection binding ?

Ideas would be appreciated. This is a situation where there is enough of this kind of stuff that it would be worth figuring out, but I think on an instance basis it could come in handy in a lot of places.

Thoughts?