async public Task <Varsis.Data.Infrastructure.Pagination> TotalLinhas(long?size, List <Criteria> criterias)
{
List <string> filter = new List <string>();
int cont = 0;
if (criterias?.Count != 0)
{
foreach (var c in criterias)
{
cont++;
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}");
}
}
}
Varsis.Data.Infrastructure.Pagination page = new Varsis.Data.Infrastructure.Pagination();
string query = Global.MakeODataQuery("U_VSITENTIDADECONT/$count", null, filter.Count == 0 ? null : filter.ToArray(), null, 1, 0);
string data = await _serviceLayerConnector.getQueryResult(query);
page.Linhas = Convert.ToInt64(data);
page.Paginas = (Convert.ToInt64(data) / size.Value) + 1;
page.qtdPorPagina = size.Value == 0 ? Convert.ToInt64(data) : size.Value;
return(page);
}
async public Task <VSITENTIDADE> Find(List <Criteria> criterias)
{
string recid = criterias[0].Value;
string query = Global.BuildQuery($"U_VSITENTIDADE('{recid}')");
string data = await _serviceLayerConnector.getQueryResult(query);
ExpandoObject record = Global.parseQueryToObject(data);
VSITENTIDADE cadEntidade = toRecord(record);
Serviceb1.Integration.VSITENTIDADECONTService contatoS = new VSITENTIDADECONTService(_serviceLayerConnector);
List <Criteria> filtro = new List <Criteria>();
filtro.Add(new Criteria
{
Field = "codigo",
Operator = "eq",
Value = cadEntidade.codigo.ToString()
});
cadEntidade.contatos = await contatoS.List(filtro, 1, -1);
// Recupera as linhas da nota iscal
string[] filter = new string[]
{
$"Code eq '{recid}'"
};
query = Global.MakeODataQuery("U_VSITENTIDADE", null, filter);
data = await _serviceLayerConnector.getQueryResult(query);
return(cadEntidade);
}
async public Task <CfopToUsageMap> Find(List <Criteria> criterias)
{
string recid = criterias[0].Value;
string query = Global.BuildQuery($"{SL_TABLE_NAME}('{recid}')");
string data = await _serviceLayerConnector.getQueryResult(query);
ExpandoObject record = Global.parseQueryToObject(data);
CfopToUsageMap result = null;
if (record != null)
{
result = toRecord(record);
}
return(result);
}
async public Task <BusinessPartners> Find(List <Criteria> criterias)
{
string recid = criterias[0].Value;
string query = Global.BuildQuery($"{SL_TABLE_NAME}('{recid}')");
string data = await _serviceLayerConnector.getQueryResult(query);
ExpandoObject record = Global.parseQueryToObject(data);
BusinessPartners entity = null;
if (record != null)
{
entity = toRecord(record);
}
return(entity);
}
async public Task <Model.Connector.POSMonitorDetail> Find(List <Criteria> criterias)
{
string recid = criterias[0].Value;
string query = Global.BuildQuery($"U_VSPOSMONITORDET('{recid}')");
string data = await _serviceLayerConnector.getQueryResult(query);
ExpandoObject record = Global.parseQueryToObject(data);
Model.Connector.POSMonitorDetail detail = null;
if (record != null)
{
detail = toRecord(record);
}
return(detail);
}
async public Task <Model.Connector.POSBranchConfig> Find(List <Criteria> criterias)
{
string recid = criterias[0].Value;
string query = Global.BuildQuery($"{SL_TABLE_NAME}('{recid}')");
string data = await _serviceLayerConnector.getQueryResult(query);
ExpandoObject record = Global.parseQueryToObject(data);
Model.Connector.POSBranchConfig config = null;
if (record != null)
{
config = toRecord(record);
}
return(config);
}
async public Task <List <SalesInvoice> > List(List <Criteria> criterias, long page, long size)
{
var filter = parseCriterias(criterias);
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 <SalesInvoice> result = new List <SalesInvoice>();
if (lista != null)
{
foreach (dynamic o in lista)
{
result.Add(toRecord(o));
}
}
return(result);
}
async public Task <Invoice> Find(List <Criteria> criterias)
{
string recid = criterias[0].Value;
string query = Global.BuildQuery($"Invoice('{recid}')");
string data = await _serviceLayerConnector.getQueryResult(query);
ExpandoObject record = Global.parseQueryToObject(data);
Invoice invoice = toRecord(record);
// Recupera as linhas da nota iscal
string[] filter = new string[]
{
$"CardCode eq '{recid}'"
};
query = Global.MakeODataQuery("Invoice", null, filter);
data = await _serviceLayerConnector.getQueryResult(query);
return(invoice);
}
async public Task <VSITENTIDADECONT> Find(List <Criteria> criterias)
{
string recid = criterias[0].Value;
string query = Global.BuildQuery($"U_VSITENTIDADECONT('{recid}')");
string data = await _serviceLayerConnector.getQueryResult(query);
ExpandoObject record = Global.parseQueryToObject(data);
VSITENTIDADECONT entidade = toRecord(record);
// Recupera as linhas da nota iscal
string[] filter = new string[]
{
$"Code eq '{recid}'"
};
query = Global.MakeODataQuery("U_VSITENTIDADECONT", null, filter);
data = await _serviceLayerConnector.getQueryResult(query);
return(entidade);
}
async public Task <Store> Find(List <Criteria> criterias)
{
string recid = criterias[0].Value;
string query = Global.BuildQuery($"U_VSISSTORE('{recid}')");
string data = await _serviceLayerConnector.getQueryResult(query);
ExpandoObject record = Global.parseQueryToObject(data);
Store store = toRecord(record);
// Recupera as linhas da nota iscal
string[] filter = new string[]
{
$"U_PRODUCTCODE eq '{recid}'"
};
query = Global.MakeODataQuery("U_VSISPRODUCT", null, filter);
data = await _serviceLayerConnector.getQueryResult(query);
return(store);
}
async public Task <List <AccountIncomingInvoice> > List(List <Criteria> criterias, long page, long size)
{
string service = SL_SERVICE_NAME;
bool filteredByGroup = false;
var filter = this.parseCriteria(criterias.ToList());
string query = string.Empty;
if (criterias.FirstOrDefault(m => m.Field.ToLower() == "vendorgroup") != null)
{
filteredByGroup = true;
service = $"$crossjoin({SL_SERVICE_NAME},U_S3ADVVENDOR)";
string[] selectListArgs = new string[]
{
"Code,Name,U_TransId,U_LineId,U_Cod_Cli,U_Cod_Cli_Ori,U_Nota,U_Serie,U_Parcela,U_Vencto,U_Vencto_Ori,U_Dt_Recepcao,",
"U_Dt_Emissao,U_Dt_Agendamento,U_Dt_Pagto,U_Dt_Liquida,U_Dt_Lancto,U_Dt_Prev_Recto,U_Conta_Controle,U_Banco,",
"U_Empresa,U_Filial,U_Condicao_Pagto,U_Status,U_Situacao,",
"U_Meio_Pagto,U_Forma_Pagto,U_Tipo_Conta,U_Numero_Conta,U_Dig_Conta,U_Dig_Agencia,U_Agencia,",
"U_Valor_Bruto,U_Abat_Manual,U_Abat_Pagar,U_Desconto_Acordo,U_Desconto,U_Acrescimos,",
"U_Juros,U_Multa,U_Valor_Pago,U_Moeda,",
"U_Val_Tran_Moeda,U_Var_Cam_Real,U_Var_Cam_Nreal,U_Code_Pagto,U_Seu_Numero,U_Nosso_Numero,",
"U_Arquivo_Gerado,U_Arquivo_Importado,U_Usu_Gerou_Arquivo,U_Usu_Importou_Conf,U_Usu_Importou_Liq,U_Dt_geracao,U_Motivo_Baixa,",
"U_Numero_Boleto,U_Lote_EDI, U_Modelo_nf,U_Conta_Razao,U_Dt_confirma,U_Ocorrencia, U_Retencoes"
};
string selectList = string.Join("", selectListArgs);
string expand = $"$expand=U_VSRECTITULOS($select={selectList})";
query = $"{service}?{expand}&$filter={string.Join(" and ", filter)}";
query = Uri.EscapeUriString(query);
}
else
{
query = Global.MakeODataQuery(service, null, filter.Length == 0 ? null : filter);
}
var data = await _serviceLayerConnector.getQueryResult(query);
List <ExpandoObject> lista = Global.parseQueryToCollection(data);
List <AccountIncomingInvoice> result = new List <AccountIncomingInvoice>();
if (lista != null)
{
foreach (dynamic o in lista)
{
result.Add(toRecord(o, filteredByGroup));
}
}
return(result);
}
async public Task <List <POSInvoice> > List(List <Criteria> criterias, long page = -1, long size = -1)
{
var filter = this.ParseCriterias(criterias);
string query = Global.MakeODataQuery(SL_TABLE_NAME, null, filter.Count == 0 ? null : filter.ToArray(), null, page, size);
string data = await _serviceLayerConnector.getQueryResult(query);
List <ExpandoObject> lista = Global.parseQueryToCollection(data);
List <Model.Connector.POSInvoice> result = new List <Model.Connector.POSInvoice>();
lista.ForEach(i =>
{
result.Add(toRecord(i));
});
return(result);
}
async public Task <List <MaterialGroups> > List(List <Criteria> criterias, long page = -1, long size = -1)
{
List <string> filter = new List <string>();
int cont = 0;
if (criterias?.Count != 0)
{
foreach (var c in criterias)
{
cont++;
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("MaterialGroups");
string data = await _serviceLayerConnector.getQueryResult(query);
List <ExpandoObject> lista = Global.parseQueryToCollection(data);
List <MaterialGroups> result = new List <MaterialGroups>();
if (lista != null)
{
foreach (dynamic o in lista)
{
result.Add(toRecord(o));
}
}
return(result);
}
async public Task <List <AccountIncomingInvoiceTax> > List(List <Criteria> criterias, long page, long size)
{
var filter = Global.parseCriterias(criterias, _FieldMap, _FieldMap).ToArray();
var query = Global.MakeODataQuery(SL_SERVICE_NAME, null, filter.Length == 0 ? null : filter);
var data = await _serviceLayerConnector.getQueryResult(query);
List <ExpandoObject> lista = Global.parseQueryToCollection(data);
List <AccountIncomingInvoiceTax> result = new List <AccountIncomingInvoiceTax>();
if (lista != null)
{
foreach (dynamic o in lista)
{
result.Add(toRecord(o));
}
}
return(result);
}
