{"id":5730,"date":"2021-11-24T16:11:01","date_gmt":"2021-11-24T15:11:01","guid":{"rendered":"https:\/\/solidt.eu\/site\/?p=5730"},"modified":"2021-12-23T16:52:16","modified_gmt":"2021-12-23T15:52:16","slug":"uniconta-filterbuilder","status":"publish","type":"post","link":"https:\/\/solidt.eu\/site\/uniconta-filterbuilder\/","title":{"rendered":"Uniconta FilterBuilder"},"content":{"rendered":"\n<div style=\"height: 250px; position:relative; margin-bottom: 50px;\" class=\"wp-block-simple-code-block-ace\"><pre class=\"wp-block-simple-code-block-ace\" style=\"position:absolute;top:0;right:0;bottom:0;left:0\" data-mode=\"csharp\" data-theme=\"monokai\" data-fontsize=\"14\" data-lines=\"Infinity\" data-showlines=\"true\" data-copy=\"false\">using System.Collections.Generic;\nusing System.Linq;\nusing Uniconta.Common;\n\nnamespace UnicontaAdapter.Helpers\n{\n    public class FilterBuilder\n    {\n        private readonly List&lt;PropValuePair> result = new();\n\n        private object ConvertValue(object src)\n        {\n            if (src is bool b)\n            {\n                return b ? \"1\" : \"0\";\n            }\n            return src;\n        }\n\n        private FilterBuilder AddWhere(string field, object value, CompareOperator op)\n        {\n            result.Add(PropValuePair.GenereteWhereElements(field, ConvertValue(value), op));\n            return this;\n        }\n\n        public FilterBuilder WhereEqual(string field, object value) => AddWhere(field, value, CompareOperator.Equal);\n        public FilterBuilder WhereNotEqual(string field, object value) => AddWhere(field, value, CompareOperator.NotEqual); \n        public FilterBuilder WhereStartsWith(string field, object value) => AddWhere(field, value, CompareOperator.StartsWith);\n        public FilterBuilder WhereContains(string field, object value) => AddWhere(field, value, CompareOperator.Contains);\n        public FilterBuilder WhereGreaterThan(string field, object value) => AddWhere(field, value, CompareOperator.GreaterThan);\n        public FilterBuilder WhereGreaterThanOrEqual(string field, object value) => AddWhere(field, value, CompareOperator.GreaterThanOrEqual);\n        public FilterBuilder WhereLessThan(string field, object value) => AddWhere(field, value, CompareOperator.LessThan);\n\n        public FilterBuilder Skip(int number)\n        {\n            result.Add(PropValuePair.GenereteSkipN(number));\n            return this;\n        }\n\n        public FilterBuilder Take(int number)\n        {\n            result.Add(PropValuePair.GenereteTakeN(number));\n            return this;\n        }\n\n        public FilterBuilder OrderBy(string field)\n        {\n            result.Add(PropValuePair.GenereteOrderByElement(field, false));\n            return this;\n        }\n\n        public FilterBuilder OrderByDescending(string field)\n        {\n            result.Add(PropValuePair.GenereteOrderByElement(field, true));\n            return this;\n        }\n\n        public IEnumerable&lt;PropValuePair> Build() => result.ToList();\n    }\n}\n<\/pre><\/div>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-5730","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/posts\/5730","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/comments?post=5730"}],"version-history":[{"count":4,"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/posts\/5730\/revisions"}],"predecessor-version":[{"id":5850,"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/posts\/5730\/revisions\/5850"}],"wp:attachment":[{"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/media?parent=5730"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/categories?post=5730"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/tags?post=5730"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}