HYTOS

            //Autodesk.AutoCAD.ApplicationServices.Document acDoc = Autodesk.AutoCAD.ApplicationServices.Application.DocumentManager.MdiActiveDocument;

            //Database acCurDb = acDoc.Database;

            //Editor acDocEd = acDoc.Editor;

            //using (Transaction acTrans = acCurDb.TransactionManager.StartTransaction())

            //{

            //    Entity objDb = (Entity)acTrans.GetObject(objectId, OpenMode.ForWrite);

            //    Entity startNodeEntityForPipe = Pipe.GetStartNodeEntityForPipe(objDb);

            //    //ArrayList arrayList = new ArrayList();

            //    //ArrayList arrayList2 = new ArrayList();

            //    //PIDUtils.VBUtils.GetUserDefineAttributes(startNodeEntityForPipe.ObjectId, ref arrayList, ref arrayList2);

            //    //PIDUtils.VBUtils.GetUserDefineAttributes(objDb.ObjectId, ref arrayList, ref arrayList2);

            //    //NamedXDataBlock namedXDataBlock = XDataUtilities.GetNamedBlock(objDb, "ReferenceObject");

            //    XData xData = XDataUtilities.GetXData<Entity>(objDb);

            //    XData xData2 = XDataUtilities.GetXData<Entity>(startNodeEntityForPipe);

            //    acTrans.Commit();

            //}

            //PLABFO

        public static DataTable SelectUDADetails()

        {

            DataTable dt = new DataTable();

            using (SqlConnection connection = new SqlConnection())

            {

                connection.ConnectionString = GetAvevaConnectionString_Admin();

                connection.Open();

                using (SqlCommand cmd = connection.CreateCommand())

                {

                    cmd.CommandText = string.Format(@"

                    SELECT * FROM {0}

                    ;", "UDADetails");

                    using (SqlDataReader dr = cmd.ExecuteReader())

                        dt.Load(dr);

                }

                connection.Close();

            }

            return dt;

        }

using System.Data;

        public static Dictionary<PID.Utilities.PipeLabelName, PID.Utilities.PipeLabelHelper.PipeDisplayLabelField> GetPipeAttribute()

        {

            return PID.Utilities.PipeLabelHelper.GetPipeDisplayLabelFields().ToDictionary(x => x.Key, y => y.Value);

        }

        public static DataTable GetSymbolAttributes()

        {

            DataTable dt = new DataTable();

            dt.Columns.Add("Name");

            dt.Columns.Add("DisplayType");

            dt.Columns.Add("Type");

            #region UDA

            DataTable udaDT = Project_DB.SelectUDADetails();

            DataRow[] rows = udaDT.Select("LovDescription != 'Project Symbol' AND LovDescription != 'Standard Symbol'");

            foreach (DataRow item in rows)

                udaDT.Rows.Remove(item);

            udaDT = udaDT.DefaultView.ToTable(true, "UDAName");

            foreach (DataRow item in udaDT.Rows)

                dt.Rows.Add(item["UDAName"], "User Defined Attribute", "UDA");

            #endregion

            return dt;

        }