using System;

using System.Collections;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Diagnostics;

using System.IO;

using System.Reflection;

​

using Newtonsoft.Json;

using Newtonsoft.Json.Linq;

using Newtonsoft.Json.Converters;

using Newtonsoft.Json.Serialization;

​

    public class TestClass

    {

        static string GetJson()

        {

            var json = @"{'Fields':[

            {

              ""Sub_Status"": ""PENDING"",

              ""Status"": ""PENDING"",

              ""Patient_Gender"": ""M""

            },

            {

              ""Sub_Status"": ""Foo"",

              ""Status"": ""Bar"",

              ""Patient_Gender"": ""F""

            },

            {

              ""Sub_Status"": ""PENDING"",

              ""Status"": ""PENDING"",

            },

            {

              ""Sub_Status"": ""SHIPMENT"",

              ""Status"": ""SHIPMENT"",

              ""Patient_Gender"": ""M""

            },

            ]}";

            return json;

        }

​

        public static void Test()

        {

            var json = GetJson();

​

            var s = JToken.Parse(json);

​

            Console.WriteLine("Initial JSON: ");

            Console.WriteLine(s);

            Console.WriteLine("");

​

            var result1 = TestIntersect(s);

​

            var result2 = TestLinq(s);

​

            if (!JToken.DeepEquals(result1, result2))

                Console.WriteLine("WRONG result from Linq query.");

            else

                Console.WriteLine("Correct result from Linq query.");

​

            var resultAndFirst = TestAndFirstQuery(s);

​

            if (!JToken.DeepEquals(result1, resultAndFirst))

                Console.WriteLine("WRONG result from \"&& first\" query.");

            else

                Console.WriteLine("Correct result from \"&& first\" query.");

​

            var resultAndLast = TestAndLastQuery(s);

​

            if (!JToken.DeepEquals(result1, resultAndLast))

                Console.WriteLine("WRONG result from \"&& last\" query.");

            else

                Console.WriteLine("Correct result from \"&& last\" query.");

​

            var resultParenthesized = TestParenthesizedQuery(s);

​

            if (!JToken.DeepEquals(result1, resultParenthesized))

                Console.WriteLine("WRONG result from Parenthesized query");

            else

                Console.WriteLine("Correct result from Parenthesized query");

        }

​

        private static JToken TestParenthesizedQuery(JToken s)

        {

            try

            {

                var filter = "$.Fields[?((@.Status == 'Pending' || @.Status == 'PENDING' || @.Status == 'SHIPMENT' || @.Status == 'DISPENSED') && (@.Patient_Gender))]";

​

                Console.WriteLine("Testing JSONPath query with filter: ");

                Console.WriteLine(filter);

​

                var query = s.SelectTokens(filter);

                var result = query.ToList();

​

                var token = new JArray(result);

​

                Console.WriteLine(token);

​

                return token;

            }

            catch (JsonException ex)

            {

                Console.WriteLine(ex.Message);

                return null;

            }

        }

​

        private static JToken TestAndFirstQuery(JToken s)

        {

            var filter = "$.Fields[?(@.Patient_Gender && @.Status == 'Pending' || @.Status == 'PENDING' || @.Status == 'SHIPMENT' || @.Status == 'DISPENSED')]";

            var query = s.SelectTokens(filter);

            var result = query.ToList();

​

            var token = new JArray(result);

​

            Console.WriteLine("Testing JSONPath query with filter: ");

            Console.WriteLine(filter);

​

            Console.WriteLine(token);

​

            return token;

        }

​

        private static JToken TestAndLastQuery(JToken s)

        {

            var filter = "$.Fields[?(@.Status == 'Pending' || @.Status == 'PENDING' || @.Status == 'SHIPMENT' || @.Status == 'DISPENSED' && @.Patient_Gender)]";

            var query = s.SelectTokens(filter);

            var result = query.ToList();

​

            var token = new JArray(result);

​

            Console.WriteLine("Testing JSONPath query with filter: ");

            Console.WriteLine(filter);

​

            Console.WriteLine(token);

​

            return token;

        }

​

        private static JToken TestIntersect(JToken s)

        {

            var query1 = s.SelectTokens("$.Fields[?(@.Status == 'Pending' || @.Status == 'PENDING' || @.Status == 'SHIPMENT' || @.Status == 'DISPENSED')]");

            var query2 = s.SelectTokens("$.Fields[?(@.Patient_Gender)]");

            var query = query1.Intersect(query2);

​

            var result = query.ToList();

​

            var array = new JArray(result);

​

            Console.WriteLine("Testing LINQ INTERSECT query: ");

​

            Console.WriteLine(array);

​

            return array;

        }

​

        private static JToken TestLinq(JToken s)

        {

            var query = from t in s.SelectTokens("$.Fields[*]")

                        where (string)t["Patient_Gender"] != null

                        let status = (string)t["Status"]

                        where status == "Pending" || status == "PENDING" || status == "SHIPMENT" || status == "DISPENSED"

                        select t;

​

            var result = query.ToList();

​

            var array = new JArray(result);

​

            Console.WriteLine("Testing LINQ WHERE query: ");

​

            Console.WriteLine(array);

​

            return array;

        }

    }

    public class Program

    {

        public static void Main()

        {

            Console.WriteLine("Json.NET version: " + typeof(JsonSerializer).Assembly.FullName);

            Console.WriteLine("");

            TestClass.Test();

        }

    }

​