public override byte[] AsBinary(DbGeometry geometryValue)
        {
            if (geometryValue == null)
            throw new ArgumentNullException("geometryValue");

              var providerValue = new MySqlGeometry();
              MySqlGeometry.TryParse(geometryValue.ProviderValue.ToString(), out providerValue);

              return providerValue.Value;
        }

        /// <summary>
        ///     Parsing the THREEJS Geometry of an Object ... (including the color ...)
        /// </summary>
        /// <param name="geo"></param>
        /// <param name="model"></param>
        /// <param name="color"></param>
        public static void EvaluateAndSaveGeometry(DbGeometry geo, DtObject model, Color color)
        {
            // Create 3DPoints
            var splitpointlist = geo.Vertices
                .Select((x, i) => new { Index = i, Value = x })
                .GroupBy(x => x.Index / 3)
                .Select(x => x.Select(v => v.Value).ToList())
                .ToList();

            var points = splitpointlist.Select(item => new Point3D(item[0], item[1], item[2])).ToList();

            // Add the information as AttributeGroup
            model.AttributeGroups["geometry"].AddProperty("threejspoints", points);
            model.AttributeGroups["geometry"].AddProperty("geometryindices", geo.Faces);
            model.AttributeGroups["geometry"].AddProperty("color", color);
        }

        public override string GetSpatialTypeName(DbGeometry geometryValue)
        {
            if (geometryValue == null)
            throw new ArgumentNullException("geometryValue");

              var mysqlValue = GeometryFromProviderValue(geometryValue);

              return mysqlValue.SpatialTypeName;
        }

        public override double? GetMeasure(DbGeometry geometryValue)
        {
            if (geometryValue == null)
            throw new ArgumentNullException("geometryValue");

              var mysqlValue = GeometryFromProviderValue(geometryValue);

              return mysqlValue.Measure;
        }

        private void WorkerOnDoWork(object sender, DoWorkEventArgs doWorkEventArgs)
        {
            // Shoe ProgressBar
            Dispatcher.BeginInvoke((Action)delegate () {
                _control.LoadingGrid.Visibility = Visibility.Visible;
                _control.statusLabel.Content = "Status: Loading ...";
            });

            if (InputPorts[0] == null || ControlElements[0] == null || InputPorts[0].Data == null) return;

            if (InputPorts[0].Data.GetType() == typeof(DtoShortProject))
            {
                
                var project = InputPorts[0].Data as DtoShortProject;

                if (project != null)
                {
                    projectId = project.Id;
                    var topo = _controller.IntBase.APICore.Projects.GetTopology(project.Id);
                    if (topo == null)
                        return;
                    var model = _controller.IntBase.APICore.DtObjects.GetObjectGeometryAsThreeJs(topo.Id);
                    // var model = _controller.IntBase.APICore.DtObjects.GetObjectGeometry(topo.Id);

                    if (model.Objects == null)
                        return;

                    foreach (var elem in model.Objects)
                    {
                        var geom = new DbGeometry();
                        var jObject = elem.AttributeGroups["geometry"]["threejs"] as JObject;
                        if (jObject != null)
                        {
                            geom.Vertices = jObject.SelectToken("vertices").ToList().Select(value => value.Value<double>()).ToList();
                            geom.Faces = jObject.SelectToken("faces").ToList().Select(value => value.Value<uint>()).ToList();

                            var colorid = (int)jObject.SelectToken("metadata")["colorid"];
                            var colorInteger = model.Colors[colorid];
                            var color = Color.FromArgb((int)colorInteger);

                            GeometryWriter.EvaluateAndSaveGeometry(geom, elem, color);
                        }
                    }
                    
                    // model.Colors
                    // Color c = Color.FromArgb(someInt);

                    // var model = _controller.IntBase.APICore.DtObjects.GetObjectGeometry(topo.Id);
                    _elements = (List<DtObject>) model.Objects;
                }
                // _elements = _controller.IntBase.APICore.GetElementsFromTopologyId(project.Id);
                // OutputPorts[0].Data = _elements;
            }

            if (InputPorts[0].Data.GetType() == typeof(DtoDivision))
            {
                var dtoDivision = InputPorts[0].Data as DtoDivision;
                if (dtoDivision?.TopologyDivisionId != null)
                {
                    var model = _controller.IntBase.APICore.DtObjects.GetObjectGeometryAsThreeJs((Guid)dtoDivision.TopologyDivisionId);
                    projectId = dtoDivision.ProjectId;

                    foreach (var elem in model.Objects)
                    {
                        var geom = new DbGeometry();
                        var jObject = elem.AttributeGroups["geometry"]["threejs"] as JObject;
                        if (jObject != null)
                        {
                            geom.Vertices = jObject.SelectToken("vertices").ToList().Select(value => value.Value<double>()).ToList();
                            geom.Faces = jObject.SelectToken("faces").ToList().Select(value => value.Value<uint>()).ToList();

                            var colorid = (int)jObject.SelectToken("metadata")["colorid"];
                            var colorInteger = model.Colors[colorid];
                            var color = Color.FromArgb((int)colorInteger);

                            GeometryWriter.EvaluateAndSaveGeometry(geom, elem, color);
                        }
                    }
                    _elements = (List<DtObject>)model.Objects;
                }
            }

            doWorkEventArgs.Result = _elements;
        }

        public override DbGeometry SymmetricDifference(DbGeometry geometryValue, DbGeometry otherGeometry)
        {
            if (geometryValue == null)
            throw new ArgumentNullException("geometryValue");

              if (otherGeometry == null)
            throw new ArgumentNullException("otherGeometry");

              var mysqlValue = GeometryFromProviderValue(geometryValue);

              var mysqlOtherValue = GeometryFromProviderValue(otherGeometry);

              return mysqlValue.SymmetricDifference(mysqlOtherValue);
        }

 public override DbGeometry PointAt(DbGeometry geometryValue, int index)
 {
     throw new System.NotImplementedException();
 }

        public override DbGeometry InteriorRingAt(DbGeometry geometryValue, int index)
        {
            if (geometryValue == null)
            throw new ArgumentNullException("geometryValue");

              var mysqlValue = GeometryFromProviderValue(geometryValue);

              return mysqlValue.InteriorRingAt(index);
        }

        public override int GetCoordinateSystemId(DbGeometry geometryValue)
        {
            if (geometryValue == null)
            throw new ArgumentNullException("geometryValue");

              var mysqlValue = GeometryFromProviderValue(geometryValue);

              return mysqlValue.CoordinateSystemId;
        }

        public override DbGeometry GetConvexHull(DbGeometry geometryValue)
        {
            if (geometryValue == null)
            throw new ArgumentNullException("geometryValue");

              var mysqlValue = GeometryFromProviderValue(geometryValue);

              return mysqlValue.ConvexHull;
        }

        public override double Distance(DbGeometry geometryValue, DbGeometry otherGeometry)
        {
            if (geometryValue == null)
            throw new ArgumentNullException("geometryValue");

              if (otherGeometry == null)
            throw new ArgumentNullException("otherGeometry");

              DbGeometry mysqlValue = DbGeometry.FromText(geometryValue.ProviderValue.ToString());

              Double? result = mysqlValue.Distance(otherGeometry);
              if (result != null)
            return result.Value;
              return 0;
        }

 public override bool Disjoint(DbGeometry geometryValue, DbGeometry otherGeometry)
 {
     throw new System.NotImplementedException();
 }

        public override DbGeometryWellKnownValue CreateWellKnownValue(DbGeometry geometryValue)
        {
            if (geometryValue == null)
            throw new ArgumentNullException("geometryValue");

              var mysqlValue = GeometryFromProviderValue(geometryValue);

              return mysqlValue.WellKnownValue;
        }

        public override bool Contains(DbGeometry geometryValue, DbGeometry otherGeometry)
        {
            if (geometryValue == null)
             throw new ArgumentNullException("geometryValue");

               if (otherGeometry == null)
             throw new ArgumentNullException("otherGeometry");

               DbGeometry mysqlValue = DbGeometry.FromText(geometryValue.ProviderValue.ToString());
               return mysqlValue.Contains(otherGeometry);
        }

        public override DbGeometry Buffer(DbGeometry geometryValue, double distance)
        {
            if (geometryValue == null)
            throw new ArgumentNullException("geometryValue");

              DbGeometry mysqlValue = DbGeometry.FromText(geometryValue.ProviderValue.ToString());
              return mysqlValue.Buffer(distance);
        }

        public override DbGeometry GetStartPoint(DbGeometry geometryValue)
        {
            if (geometryValue == null)
            throw new ArgumentNullException("geometryValue");

              var mysqlValue = GeometryFromProviderValue(geometryValue);

              return mysqlValue.StartPoint;
        }

        public override double? GetYCoordinate(DbGeometry geometryValue)
        {
            if (geometryValue == null)
            throw new ArgumentNullException("geometryValue");

              var providerValue = new MySqlGeometry();
              MySqlGeometry.TryParse(geometryValue.ProviderValue.ToString(), out providerValue);
              return providerValue.YCoordinate;
        }

        public override int GetDimension(DbGeometry geometryValue)
        {
            if (geometryValue == null)
            throw new ArgumentNullException("geometryValue");

              var mysqlValue = GeometryFromProviderValue(geometryValue);

              return mysqlValue.Dimension;
        }

 public override string AsGml(DbGeometry geometryValue)
 {
     throw new NotImplementedException();
 }

        public override DbGeometry GetExteriorRing(DbGeometry geometryValue)
        {
            if (geometryValue == null)
            throw new ArgumentNullException("geometryValue");

              var mysqlValue = GeometryFromProviderValue(geometryValue);

              return mysqlValue.ExteriorRing;
        }