private filters addFilter(filters filtresIn, string key, string op, string value)
{
filters filtres = filtresIn;
if (filtres == null)
{
filtres = new filters();
}
complexFilter compfiltres = new complexFilter();
compfiltres.key = key;
associativeEntity ass = new associativeEntity();
ass.key = op;
ass.value = value;
compfiltres.value = ass;
List <complexFilter> tmpLst;
if (filtres.complex_filter != null)
{
tmpLst = filtres.complex_filter.ToList();
}
else
{
tmpLst = new List <complexFilter>();
}
tmpLst.Add(compfiltres);
filtres.complex_filter = tmpLst.ToArray();
return(filtres);
}
private static filters tanMageFilter(string mageField, string mageOperator, string mageValue, string limit)
{
complexFilter myComplexFilter = new complexFilter();
myComplexFilter.key = mageField;
myComplexFilter.value = new associativeEntity {
key = mageOperator,
value = mageValue
};
complexFilter myLimitFilter = new complexFilter();
myLimitFilter.key = "collection.limit";
myLimitFilter.value = new associativeEntity {
key = "eq",
value = limit
};
filters mageFilters = new filters();
mageFilters.complex_filter = new complexFilter[] {
myComplexFilter,
myLimitFilter
};
return(mageFilters);
}
public salesOrderListEntity[] get_open_orders()
{
MagentoService mservice = new MagentoService();
String mlogin = mservice.login("admin", "Interconnection123!");
filters mf = new filters();
complexFilter[] cpf = new complexFilter[1];
complexFilter mcpf = new complexFilter();
mcpf.key = "status";
associativeEntity mas = new associativeEntity();
mas.key = "in";
mas.value = "pending,processing,approved_clearsale,analysing_clearsale,pending_clearsale";
mcpf.value = mas;
cpf[0] = mcpf;
//mcpf = new complexFilter();
//mcpf.key = "status";
//mas = new associativeEntity();
//mas.key = "eq";
//mas.value = "processing";
//mcpf.value = mas;
//cpf[1] = mcpf;
//mcpf = new complexFilter();
//mcpf.key = "status";
//mas = new associativeEntity();
//mas.key = "eq";
//mas.value = "approved_clearsale";
//mcpf.value = mas;
//cpf[2] = mcpf;
//mcpf = new complexFilter();
//mcpf.key = "status";
//mas = new associativeEntity();
//mas.key = "eq";
//mas.value = "analysing_clearsale";
//mcpf.value = mas;
//cpf[3] = mcpf;
//mcpf = new complexFilter();
//mcpf.key = "status";
//mas = new associativeEntity();
//mas.key = "eq";
//mas.value = "pending_clearsale";
//mcpf.value = mas;
//cpf[4] = mcpf;
mf.complex_filter = cpf;
var soe = mservice.salesOrderList(mlogin, mf);
return(soe);
}
private filters magentoFilter(string filterField, string filterOperator, string filterValue)
{
filters mFilter = new filters();
complexFilter cmplxFilter = new complexFilter();
cmplxFilter.key = filterField;
cmplxFilter.value = new associativeEntity {
key = filterOperator, value = filterValue
};
mFilter.complex_filter = new complexFilter[] { cmplxFilter };
return(mFilter);
}
private void bbDownload_Click(object sender, EventArgs e)
{
if (cbLoja.SelectedItem == null)
{
MessageBox.Show("Obrigatório selecionar loja.", "Mensagem", MessageBoxButtons.OK, MessageBoxIcon.Information);
cbLoja.Focus();
return;
}
if (string.IsNullOrEmpty((cbLoja.SelectedItem as TRegistro_LojaVirtual).UserName))
{
MessageBox.Show("Não existe USERNAME cadastrado para loja.", "Mensagem", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (string.IsNullOrEmpty((cbLoja.SelectedItem as TRegistro_LojaVirtual).ApiKey))
{
MessageBox.Show("Não existe APIKEY cadastrado para loja.", "Mensagem", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
MagentoService api = new MagentoService();
string sessao = string.Empty;
try
{
sessao = api.login((cbLoja.SelectedItem as TRegistro_LojaVirtual).UserName, (cbLoja.SelectedItem as TRegistro_LojaVirtual).ApiKey);
filters mf = new filters();
complexFilter[] cpf = new complexFilter[0];
if (cbStatus.SelectedIndex > 0)
{
complexFilter mcpf = new complexFilter();
mcpf.key = "status";
associativeEntity mas = new associativeEntity();
mas.key = "=";
mas.value = cbStatus.SelectedValue.ToString();
mcpf.value = mas;
Array.Resize(ref cpf, cpf.Length + 1);
cpf[cpf.Length - 1] = mcpf;
}
if (!string.IsNullOrEmpty(dt_ini.Text.SoNumero()))
{
complexFilter mcpf = new complexFilter();
mcpf.key = "created_at";
associativeEntity mas = new associativeEntity();
mas.key = "from";
mas.value = DateTime.Parse(dt_ini.Text).ToString("yyyy-MM-dd") + " 00:00:00";
mcpf.value = mas;
Array.Resize(ref cpf, cpf.Length + 1);
cpf[cpf.Length - 1] = mcpf;
}
mf.complex_filter = cpf;
salesOrderListEntity[] lista = api.salesOrderList(sessao, mf);
if (lista.Length > 0)
{
TList_Pedido lPedido = new TList_Pedido();
lista.ToList().ForEach(p =>
{
object obj = new TCD_Pedido().BuscarEscalar(
new TpBusca[]
{
new TpBusca()
{
vNM_Campo = "a.Nr_PedidoOrigem",
vOperador = "=",
vVL_Busca = "'" + p.increment_id.Trim() + "'"
}
}, "a.nr_pedido");
lPedido.Add(new TRegistro_Pedido()
{
Nr_PedidoOrigem = p.increment_id,
Vl_totalpedido = decimal.Divide(int.Parse(p.grand_total.SoNumero()), 10000),
StatusMagento = p.status,
NM_Clifor = p.firstname.Trim() + " " + p.lastname.Trim(),
Nr_pedido = obj == null ? 0 : decimal.Parse(obj.ToString()),
DT_Pedido = DateTime.Parse(p.created_at)
});
});
bsPedLoja.DataSource = lPedido;
}
}
catch (Exception ex)
{ MessageBox.Show(ex.Message.Trim(), "Erro", MessageBoxButtons.OK, MessageBoxIcon.Error); }
finally
{
if (!string.IsNullOrWhiteSpace(sessao))
{
api.endSession(sessao);
}
}
}