Currently I'm using a DevExpress grid with the Business Binding Source and it is working swimmingly ... except for one thing.

 

I can only use the actual fields defined in the table to bind to the grid.  I was hoping to be able to create a custom property and select that as the binding field for the column in the grid but that doesn't work.  Here is an illustration:

 

I have a table named Lead and that table is loosely associated with another table named DialRecalls.  I then created a stored procedure and linked these two tables together like so:

 SELECT lea_id,
     lea_FirstName,
     lea_LastName,
     lea_SortName,
     lea_Address,
     lea_City,
     lea_ST,
     lea_ZipCode,
     lea_Phone,
     lea_Phone2,
     lea_SourceID,
     SPACE(50)    AS lea_Source,
     lea_RegionID,
     SPACE(10)    AS lea_Region,
     lea_TelemarketerID,
     SPACE(3)     AS lea_TelemarketerName,
     dir_UserID   AS lea_RecallUserID,
     SPACE(3)     AS lea_RecallUserName,
     dir_RecallOn AS lea_RecallOn
   FROM Lead INNER JOIN DialRecalls ON lea_id = dir_lea_id
  WHERE lea_Status = 'L' AND
     dir_Active = 1   AND
    (dir_RecallOn >= @DateFrom AND dir_RecallOn <= @DateTo)     AND
     dir_UserID =     COALESCE(@dir_UserID, dir_UserID)         AND
     lea_ST      LIKE COALESCE(@lea_ST, lea_ST)           + '%' AND
     lea_City    LIKE COALESCE(@lea_City, lea_City)       + '%' AND
     lea_ZipCode LIKE COALESCE(@lea_ZipCode, lea_ZipCode) + '%' AND
     lea_Phone   LIKE COALESCE(@lea_Phone, lea_Phone)     + '%' AND
     lea_SourceID IN (SELECT cos_ID FROM @SourceIDs) AND
     lea_RegionID IN (SELECT cor_ID
                        FROM Contact_Regions
        WHERE cor_Region IN (SELECT cor_Region
                               FROM @Regions))
     ORDER BY dir_RecallOn 

I then used that stored procedure in the FillByStoredProcedure method and populated the business object with the addition fields that I needed to display (performed using the AS function in SQL) ... as you can see one of those fields is lea_RecallOn which actually came from the DialRecall.dir_RecallOn field. 

 

Next, I created a custom property on the business object like so

        [Browsable(false),
         BusinessFieldDisplayInEditor(),
         Description("DialRecalls.dir_RecallOn"),
         DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)]
        public DateTime lea_RecallOn
        {
            get
            {
                return (DateTime)this.CurrentRow["lea_RecallOn"];
            }

            set
            {
                this.CurrentRow["lea_RecallOn"] = value;
            }

        }

And finally, I went into the grid designer, created a new column, and bound it to the "lea_RecallOn" field.  The problem is that the grid does not recognize any field that is not part of the strong typed data table created with the BO Mapper.

So, is there anyway to create a property that the grid can see without created a fake property in the DDT and building with the BO Mapper?  

I did get around this by creating a lea_RecallOn column in the datatable and running the above stored procedure ... the grid then picked up the date which originated in the DialRecall table.  I then excluded the field from the Insert and Update operations using the business object properties.

Any recommendations?

 

C. T. 

Charles T. Blankenship
Senior Consultant
Novant Consulting, Inc.
704.975.7152
http://www.novantconsulting.com

Hi Charles.

See if this one helps:

http://forum.strataframe.net/FindPost17401.aspx

Boa noite.

After pounding my head on the desk for a while ... I went down and watched Hardball with Chris Matthews ... and came up with this.

There does not seem to be a performance hit with this solution and it does exactly what I want it to ... I just thought the BBS would be a bit more straight forward. 

The problem it seems is that DevExpress XtraGrid does not care about custom properties ... they don't show up in the designer when populating the grid either ... which is a clue.

This solution takes the lea_id out of the grid, which comes directly from the table and uses that to seek to the primary key of the business object and then pluck the value out of the custom property and push it into the unbound column.


        private void grvLeads_CustomColumnDisplayText(object sender,  DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e)
        {
            ColumnView view = sender as ColumnView;

            if (e.Column.FieldName == "lea_Phone")
            {
                string phone = (string)view.GetRowCellValue(e.RowHandle, view.Columns["lea_Phone"]);
                e.DisplayText = string.Format("{0###) ###-####}", Convert.ToDouble(phone));
            }

            if (e.Column.FieldName == "lea_RecallOn")
            {
                int leadID = (int)view.GetRowCellValue(e.RowHandle, view.Columns["lea_id"]);
                oLead.SeekToPrimaryKey(leadID);
                e.DisplayText = string.Format("{0:d}",oLead.lea_RecallOn);
            }
        }

Charles T. Blankenship
Senior Consultant
Novant Consulting, Inc.
704.975.7152
http://www.novantconsulting.com

Howdy CT,

Hi Charles,

I was working outside yesterday and did not see your post until now.  I also use DevExpress grids a lot and with several Custom Field Properties (which is one of the most useful features of the SF BO).

Follow Ben's recommendation overriding the GetCustomBindablePropertyDescriptors() and you should be good to go.

Edhy Rijo

Well ... I hate to be dense in public but would one of you please speak C#?  Here is my custom property ...

        [Browsable(false),
         BusinessFieldDisplayInEditor(),
         Description("DialRecalls.dir_RecallOn"),
         DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)]
        public DateTime lea_RecallOn
        {
            get
            {
                return (DateTime)this.CurrentRow["lea_RecallOn"];
            }

            set
            {
                this.CurrentRow["lea_RecallOn"] = value;
            }

        }       



Charles T. Blankenship
Senior Consultant
Novant Consulting, Inc.
704.975.7152
http://www.novantconsulting.com

This mebbe?

protected override FieldPropertyDescriptor[] GetCustomBindablePropertyDescriptors()
{
    FieldPropertyDescriptor[] fpd = {new ReflectionPropertyDescriptor("lea_RecallOn", typeof(Lead))};
    return fpd;
}

Charles T. Blankenship
Senior Consultant
Novant Consulting, Inc.
704.975.7152
http://www.novantconsulting.com

Yep ... that worked ... it is a good thing this is not 1692 in Winston, Salem ... if it were I'd have all of you burned as witches ... as this worked like magic.

Charles T. Blankenship
Senior Consultant
Novant Consulting, Inc.
704.975.7152
http://www.novantconsulting.com

Well, I knock down on weed and another one grows in its place ... the reason I wanted to perform an ID lookup after the initial join was to prevent the slowdown of the query just for looking up the name of the Telemarketer.  So, I created a custom property, gave it a descriptor and bound that column to the XtraGrid.  The data shows up without incident.

However ...

since I'm placing a value into one of the fields of the business object the business object is now "dirty" and it screws up the maintenance form toolbar button states. 

Furthermore, each time the Undo button is pressed all of the Telemarketer names are erased from the column as they are in effect, changes to be rejected from the table.

How does one go about resetting the editing status of that particular field ... or ... keep it from registering a dirty business object altogether.

Thanks,

Charles T. Blankenship
Senior Consultant
Novant Consulting, Inc.
704.975.7152
http://www.novantconsulting.com

YourBO.CurrentDatatable.AcceptChanges()