topic Re: how to reshuffle by Y axis and will group or arranged by X axis in .NET Forum

how to reshuffle by Y axis and will group or arranged by X axis

kite15 — Mon, 19 Mar 2018 13:01:54 GMT

Hi,

I have work on DBText and MText objects and collected some information to a list. Required to reshuffle the collected list as only Y axis Point3D value.

Can any one help me to suggest how to reshuffle and will group by X axis. Please, see the attached snap for better understanding.

here is my present code:

            List<MyMtxtData> myMtexts = new List<MyMtxtData>();
            using (Transaction tr = db.TransactionManager.StartTransaction())
            {
                foreach (ObjectId id in sset.GetObjectIds())
                {
                    DBObject obj = (DBObject)tr.GetObject(id, OpenMode.ForRead) as DBObject;
                    MyMtxtData myMtext = new MyMtxtData() { MyMtID = id };
                    if (obj.GetRXClass().DxfName == "MTEXT")
                    {
                        MText Mt = (MText)obj as MText;
                        myMtext.MyMtLocation = Mt.Location;
                        myMtext.MyMtContain = Mt.Contents;
                        myMtext.MyMtHgt = Mt.TextHeight;
                        myMtext.MyMtRot = Mt.Rotation;
                    }
                    else if (obj.GetRXClass().DxfName == "TEXT")
                    {
                        DBText Dt = (DBText)obj as DBText;
                        myMtext.MyMtLocation = Dt.Position;
                        myMtext.MyMtContain = Dt.TextString;
                        myMtext.MyMtHgt = Dt.Height;
                        myMtext.MyMtRot = Dt.Rotation;
                    }
                    myMtexts.Add(myMtext);
                }
                //myMtexts = myMtexts.OrderBy(x => x.MyMtLocation.Y).ThenBy(x => x.MyMtLocation.X).ToList();
                myMtexts = myMtexts.OrderByDescending(x => x.MyMtLocation.Y).ToList();
                tr.Dispose();
            }

Please, Help !!

Re: how to reshuffle by Y axis and will group or arranged by X axis

BKSpurgeon — Mon, 19 Mar 2018 14:26:43 GMT

Why not try something like this:

var result = myMtexts.GroupBy(text => Math.Round(text.MyMtLocation.X / 50)).OrderBy(group => group.Key).Select(group => group.OrderByDescending(text => text.MyMtLocation.X));

It groups everything in the x direction every 50 units, and then orders descending by Y.

(Warning: Untested code)

Re: how to reshuffle by Y axis and will group or arranged by X axis

BKSpurgeon — Mon, 19 Mar 2018 14:30:42 GMT

If you want a single list over all items in that order, then use the LINQ SelectMany() method on the end

Re: how to reshuffle by Y axis and will group or arranged by X axis

ActivistInvestor — Mon, 19 Mar 2018 18:30:17 GMT

Your problem is a bit difficult to solve in the form you present it because the width of each blue box is not clearly defined. You have to determine what the allowed ranges of the x-coordinates (either the insertion points or the min/max points of the bounding boxes) are for each grouping.

Once you've done that, OrderBy() or OrderByDescending() and GroupBy() should be all you need to solve the problem.

@kite15wrote:

Hi,

I have work on DBText and MText objects and collected some information to a list. Required to reshuffle the collected list as only Y axis Point3D value.

Can any one help me to suggest how to reshuffle and will group by X axis. Please, see the attached snap for better understanding.

here is my present code:

            List<MyMtxtData> myMtexts = new List<MyMtxtData>();
            using (Transaction tr = db.TransactionManager.StartTransaction())
            {
                foreach (ObjectId id in sset.GetObjectIds())
                {
                    DBObject obj = (DBObject)tr.GetObject(id, OpenMode.ForRead) as DBObject;
                    MyMtxtData myMtext = new MyMtxtData() { MyMtID = id };
                    if (obj.GetRXClass().DxfName == "MTEXT")
                    {
                        MText Mt = (MText)obj as MText;
                        myMtext.MyMtLocation = Mt.Location;
                        myMtext.MyMtContain = Mt.Contents;
                        myMtext.MyMtHgt = Mt.TextHeight;
                        myMtext.MyMtRot = Mt.Rotation;
                    }
                    else if (obj.GetRXClass().DxfName == "TEXT")
                    {
                        DBText Dt = (DBText)obj as DBText;
                        myMtext.MyMtLocation = Dt.Position;
                        myMtext.MyMtContain = Dt.TextString;
                        myMtext.MyMtHgt = Dt.Height;
                        myMtext.MyMtRot = Dt.Rotation;
                    }
                    myMtexts.Add(myMtext);
                }
                //myMtexts = myMtexts.OrderBy(x => x.MyMtLocation.Y).ThenBy(x => x.MyMtLocation.X).ToList();
                myMtexts = myMtexts.OrderByDescending(x => x.MyMtLocation.Y).ToList();
                tr.Dispose();
            }

Please, Help !!

Re: how to reshuffle by Y axis and will group or arranged by X axis

BKSpurgeon — Mon, 19 Mar 2018 22:00:08 GMT

var result = myMtexts.GroupBy(text => Math.Round(text.MyMtLocation.X / 50)).OrderBy(group => group.Key).Select(group => group.OrderByDescending(text => text.MyMtLocation.Y));

ooops! order by descending use the Y coordinate not the x.

Re: how to reshuffle by Y axis and will group or arranged by X axis

kite15 — Wed, 21 Mar 2018 10:04:29 GMT

Hello All,

Try with the provided codes. No luck!!

Have any suggestion.......

Thanks

Re: how to reshuffle by Y axis and will group or arranged by X axis

_gile — Wed, 21 Mar 2018 10:54:57 GMT

As @ActivistInvestor said, you have to define the 'column width' so that you can adjust the rounding factor.

Try this (it only deals with DBText):

var texts = selectionResult.Value
    .Cast<SelectedObject>()
    .Select(so => (DBText)tr.GetObject(so.ObjectId, OpenMode.ForWrite))
    .OrderBy(txt => Math.Round(txt.Position.X / 50.0)) // <- change this to suit your needs
    .ThenByDescending(txt => txt.Position.Y);

Re: how to reshuffle by Y axis and will group or arranged by X axis

kite15 — Wed, 21 Mar 2018 12:15:34 GMT

Hi _gile,

Checked [by debugging], its works as expected. Can you please, guide once more...

needs to cast the var texts as SelectionSet ???? Kindly, suggest....

var texts = selectionResult.Value
    .Cast<SelectedObject>()
    .Select(so => (DBText)tr.GetObject(so.ObjectId, OpenMode.ForWrite))
    .OrderBy(txt => Math.Round(txt.Position.X / 50.0)) // <- change this to suit your needs
    .ThenByDescending(txt => txt.Position.Y);

Thanks again....

Re: how to reshuffle by Y axis and will group or arranged by X axis

_gile — Wed, 21 Mar 2018 12:58:21 GMT

@kite15 wrote:

needs to cast the var texts as SelectionSet ???? Kindly, suggest....

No, this snippet is part of my testing command.

You can use this more generic extension method:

    public static class DBTextExtension
    {
        public static IEnumerable<DBText> SortByColumn(this IEnumerable<DBText> source, double columnWidth)
        {
            return source
                .OrderBy(txt => Math.Round(txt.Position.X / columnWidth))
                .ThenByDescending(txt => txt.Position.Y);
        }
    }

Re: how to reshuffle by Y axis and will group or arranged by X axis

kite15 — Thu, 22 Mar 2018 05:11:23 GMT

Thank you very much its works fine....