async public Task <Product> Find(List <Criteria> criterias) { string recid = criterias[0].Value; string query = Global.BuildQuery($"U_VSIS_PRODUCT('{recid}')"); string data = await _serviceLayerConnector.getQueryResult(query); ExpandoObject record = Global.parseQueryToObject(data); Product product = toProduct(record); return(product); }
async public Task <List <Model.LegacyFiscalOperations> > List(List <Criteria> criterias, long page = -1, long size = -1) { var filter = Global.parseCriterias(criterias, _FieldMap, _FieldType); string query = Global.MakeODataQuery(SL_TABLE_NAME, null, filter.Length == 0 ? null : filter, null, page, size); string data = await _serviceLayerConnector.getQueryResult(query); List <ExpandoObject> lista = Global.parseQueryToCollection(data); List <Model.LegacyFiscalOperations> result = new List <Model.LegacyFiscalOperations>(); if (lista != null) { foreach (dynamic o in lista) { Model.LegacyFiscalOperations record = new Model.LegacyFiscalOperations() { RecId = Guid.Parse(o.Code), CRFCode = o.U_CRFCODE, CFOP = o.U_CFOP }; result.Add(record); } } return(result); }
async public Task <SalesTaxCodes> Find(List <Criteria> criterias) { string code = criterias[0].Value; string query = Global.BuildQuery($"{SL_TABLE_NAME}('{code}')"); string data = await _serviceLayerConnector.getQueryResult(query); ExpandoObject record = Global.parseQueryToObject(data); SalesTaxCodes result = null; if (record != null) { result = toRecord(record); } return(result); }
async public Task <List <Model.ChartOfAccounts> > List(List <Criteria> criterias, long page = -1, long size = -1) { List <string> filter = new List <string>(); if (criterias?.Count != 0) { foreach (var c in criterias) { string field = _FieldMap[c.Field.ToLower()]; string type = _FieldType[c.Field.ToLower()]; if (type == "T") { filter.Add($"{field} {c.Operator.ToLower()} '{c.Value}'"); } else if (type == "N") { filter.Add($"{field} {c.Operator.ToLower()} {c.Value}"); } } } string query = Global.MakeODataQuery("ChartOfAccounts", null, filter.Count == 0 ? null : filter.ToArray(), null, page, size); string data = await _serviceLayerConnector.getQueryResult(query); List <ExpandoObject> lista = Global.parseQueryToCollection(data).ToList(); List <Model.ChartOfAccounts> result = new List <Model.ChartOfAccounts>(); if (lista != null) { foreach (dynamic o in lista) { result.Add(toChartOfAccounts(o)); } } return(result); }
async private Task <bool> tableExists() { bool result = false; string query = $"UserTablesMD('{name.ToUpper()}')"; string data = await _serviceLayerConnector.getQueryResult(query); dynamic table = Global.parseQueryToObject(data); if (table != null) { if (table.TableName == name.ToUpper()) { result = true; } } return(result); }
async public Task <List <Store> > List(List <Criteria> criterias, long page, long size) { string query = Global.BuildQuery("BusinessPlaces"); string data = await _serviceLayerConnector.getQueryResult(query); List <ExpandoObject> lista = Global.parseQueryToCollection(data); List <Store> result = new List <Store>(); foreach (dynamic o in lista) { result.Add(new Store() { code = o.BPLID, name = o.BPLName }); } return(result); }