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);
}
