Пример #1
0
        public void ApplyFilterToData_MultiFiltersCombo_DataFiltered()
        {
            // arrange
            var row1    = "{\"MixrData\":{\"BedReserved\":\"gary\"},\"BedDescription\":\"Nikau Rm 5\",\"BedId\":\"05\",\"KeyValueGroup\":\"TPW_05\",\"AdmissionData\":{\"MixrData\":{},\"KeyValueGroup\":\"6719253\",\"Admission\":{\"OnLeave\":\"true\"}}}";
            var row2    = "{\"MixrData\":{},\"BedDescription\":\"Nikau Rm 10\",\"BedId\":\"10\",\"KeyValueGroup\":\"TPW_10\",\"AdmissionData\":{\"MixrData\":{},\"KeyValueGroup\":\"1111111\",\"Admission\":{\"OnLeave\":\"false\"}}}";
            var row3    = "{\"MixrData\":{},\"BedDescription\":\"Nikau Rm 2\",\"BedId\":\"02\",\"KeyValueGroup\":\"TPW_02\",\"AdmissionData\":{\"MixrData\":{},\"KeyValueGroup\":\"222222\",\"Admission\":{\"OnLeave\":\"false\"}}}";
            var rawData = "{\"Location\":{\"KeyValueGroup\":\"TPW\",\"Rows\":[" + row1 + "," + row2 + "," + row3 + "]}}";

            var expectedData = "{\"Location\":{\"KeyValueGroup\":\"TPW\",\"Rows\":[" + row1 + "]}}";

            var dataFilters = new List <DataFilter>
            {
                new DataFilter {
                    Active = true, FilterRoot = "Location.Rows", PropertyNameToFilterOn = "BedId", FilterItemValues = "05,02", FilterType = "Include"
                },
                new DataFilter {
                    Active = true, FilterRoot = "Location.Rows", PropertyNameToFilterOn = "BedDescription", FilterItemValues = "Nikau Rm 2", FilterType = "Exclude"
                }
            };

            // act
            var data = JsonManipulate.ApplyManipulationsToData(rawData, dataFilters, new List <DataSort>());

            // assert
            Assert.AreEqual(expectedData, data);
        }
Пример #2
0
        public void ApplySortToData_MultiSort_DataSorted()
        {
            // arrange
            var row1    = "{\"MixrData\":{\"BedReserved\":\"gary\"},\"BedDescription\":\"Nikau Rm 5\",\"BedId\":\"05\",\"KeyValueGroup\":\"TPW_05\",\"AdmissionData\":{\"MixrData\":{},\"KeyValueGroup\":\"6719253\",\"Admission\":{\"OnLeave\":\"true\"}}}";
            var row2    = "{\"MixrData\":{},\"BedDescription\":\"Nikau Rm 10\",\"BedId\":\"10\",\"KeyValueGroup\":\"TPW_10\",\"AdmissionData\":{\"MixrData\":{},\"KeyValueGroup\":\"1111111\",\"Admission\":{\"OnLeave\":\"false\"}}}";
            var row3    = "{\"MixrData\":{},\"BedDescription\":\"Nikau Rm 2\",\"BedId\":\"02\",\"KeyValueGroup\":\"TPW_02\",\"AdmissionData\":{\"MixrData\":{},\"KeyValueGroup\":\"222222\",\"Admission\":{\"OnLeave\":\"false\"}}}";
            var rawData = "{\"Location\":{\"KeyValueGroup\":\"TPW\",\"Rows\":[" + row1 + "," + row2 + "," + row3 + "]}}";

            var expectedData = "{\"Location\":{\"KeyValueGroup\":\"TPW\",\"Rows\":[" + row3 + "," + row1 + "," + row2 + "]}}";

            var DataSorts = new List <DataSort>
            {
                new DataSort {
                    Active = true, Direction = "asc", Field = "BedId", Order = 2
                },
                new DataSort {
                    Active = true, Direction = "asc", Field = "AdmissionData.Admission.OnLeave", Order = 1
                }
            };

            // act
            var data = JsonManipulate.ApplyManipulationsToData(rawData, new List <DataFilter>(), DataSorts);

            // assert
            Assert.AreEqual(expectedData, data);
        }
Пример #3
0
        public void ApplyFilterToData_NoFilters_DataUnchanged()
        {
            // arrange
            var row1    = "{\"MixrData\":{\"BedReserved\":\"gary\"},\"BedDescription\":\"Nikau Rm 5\",\"BedId\":\"05\",\"KeyValueGroup\":\"TPW_05\",\"AdmissionData\":{\"MixrData\":{},\"KeyValueGroup\":\"6719253\",\"Admission\":{\"OnLeave\":\"true\"}}}";
            var row2    = "{\"MixrData\":{},\"BedDescription\":\"Nikau Rm 10\",\"BedId\":\"10\",\"KeyValueGroup\":\"TPW_10\",\"AdmissionData\":{\"MixrData\":{},\"KeyValueGroup\":\"1111111\",\"Admission\":{\"OnLeave\":\"false\"}}}";
            var row3    = "{\"MixrData\":{},\"BedDescription\":\"Nikau Rm 2\",\"BedId\":\"02\",\"KeyValueGroup\":\"TPW_02\",\"AdmissionData\":{\"MixrData\":{},\"KeyValueGroup\":\"222222\",\"Admission\":{\"OnLeave\":\"false\"}}}";
            var rawData = "{\"Location\":{\"KeyValueGroup\":\"TPW\",\"Rows\":[" + row1 + "," + row2 + "," + row3 + "]}}";

            // act
            var data = JsonManipulate.ApplyManipulationsToData(rawData, new List <DataFilter>(), new List <DataSort>());

            // assert
            Assert.AreEqual(rawData, data);
        }