MARKUS

using Microsoft.SqlServer.Server;

using System;

using System.IO;

using System.IO.Compression;

using System.Runtime.Serialization.Json;

using System.Text;

namespace MarkupDataParse

{

    public class MarkupDataFunctions

    {

        [SqlFunction]

        public static string CompressString(string str)

        {

            string result = null;

            using (MemoryStream outStream = new MemoryStream())

            {

                using (GZipStream gzipStream = new GZipStream(outStream, CompressionMode.Compress))

                using (MemoryStream srcStream = new MemoryStream(Encoding.UTF8.GetBytes(str)))

                    srcStream.CopyTo(gzipStream);

                result = Convert.ToBase64String(outStream.ToArray());

            }

            return result;

        }

        [SqlFunction]

        public static string DecompressString(string str)

        {

            string result = null;

            str = str.Replace("|DZ|", "");

            byte[] buffer = Convert.FromBase64String(str);

            using (MemoryStream outStream = new MemoryStream())

            {

                using (GZipStream gzipStream = new GZipStream(new MemoryStream(buffer), CompressionMode.Decompress))

                    gzipStream.CopyTo(outStream);

                result = Encoding.UTF8.GetString(outStream.ToArray());

            }

            return result;

        }

        [SqlFunction]

        public static string GetMarkupText(string str)

        {

            string result = null;

            var markupdata = DecompressString(str);

            //var control = Newtonsoft.Json.JsonConvert.DeserializeObject<TextControl>(markupdata);

            //result = control.Text;

            DataContractJsonSerializer serializer = new DataContractJsonSerializer(typeof(TextControl));

            using (MemoryStream mstream = new MemoryStream(Encoding.Unicode.GetBytes(markupdata)))

            {

                var control = (TextControl)serializer.ReadObject(mstream);

                if (control.Text != null)

                {

                    result = control.Text;

                }

                else if(control.ArrowText != null)

                {

                    result = control.ArrowText;

                }

            }

            return result;

        }

    }

    public class TextControl

    {

        public string Text { get; set; }

        public string ArrowText { get; set; }

    }

}