Example #1
0
        /// <summary>
        /// Get a SqlGeography instance with same
        /// information as provided WebPolygon.
        /// </summary>
        /// <param name="polygon">This polygon.</param>
        /// <returns>
        /// A SqlGeography instance with same
        /// information as provided WebPolygon.
        /// </returns>
        public static SqlGeography GetGeography(this WebPolygon polygon)
        {
            Boolean       isFirstLinearRing;
            String        comma;
            StringBuilder reverseWkt;

            try
            {
                return(SqlGeography.Parse(new SqlString(polygon.GetWkt())));
            }
            catch (Exception)
            {
            }

            try
            {
                // Try with points in reverse order.
                reverseWkt = new StringBuilder("POLYGON()");

                if (polygon.IsNotNull() &&
                    polygon.LinearRings.IsNotEmpty())
                {
                    isFirstLinearRing = true;
                    foreach (WebLinearRing linearRing in polygon.LinearRings)
                    {
                        if (linearRing.Points.IsNotEmpty())
                        {
                            if (isFirstLinearRing)
                            {
                                isFirstLinearRing = false;
                                reverseWkt.Insert(8, "()");
                            }
                            else
                            {
                                reverseWkt.Insert(8, "(), ");
                            }

                            comma = String.Empty;

                            foreach (WebPoint point in linearRing.Points)
                            {
                                reverseWkt.Insert(9, point.X.WebToStringR().Replace(",", ".") + " " + (point.Y.WebToStringR().Replace(",", ".")) + comma);

                                comma = ", ";
                            }
                        }
                    }
                }

                return(SqlGeography.Parse(new SqlString(reverseWkt.ToString())));
            }
            catch (Exception)
            {
            }

            return(null);
        }
Example #2
0
 /// <summary>
 /// Get a SqlGeometry instance with same
 /// information as provided WebPolygon.
 /// </summary>
 /// <param name="polygon">This polygon.</param>
 /// <returns>
 /// A SqlGeometry instance with same
 /// information as provided WebPolygon.
 /// </returns>
 public static SqlGeometry GetGeometry(this WebPolygon polygon)
 {
     return(SqlGeometry.Parse(new SqlString(polygon.GetWkt())));
 }