private void button2_Click(object sender, EventArgs e) { AmazonDynamoDBClient client = new AmazonDynamoDBClient(); DynamoDBContext context = new DynamoDBContext(client); dataGridView1.DataSource = ComandoAWS.SearchDataTabelaServicos(context, "", "", "", "", "", ""); }
public List <String> getRotaFuncionario(String idFuncionario) { AmazonDynamoDBClient client = new AmazonDynamoDBClient(); DynamoDBContext context = new DynamoDBContext(client); IEnumerable <Servicos> rotaOrdemServico = ComandoAWS.SearchDataTabelaServicos(context, "", idFuncionario, "", "", "", ""); List <Servicos> rotaOrdemServicoList = rotaOrdemServico.ToList(); List <String> rota = new List <string>(); int j = 0; for (int i = 0; i < rotaOrdemServicoList.Count(); i++) { if (rotaOrdemServicoList[i].status == "aguardando retirada") { String conversaoEnderecoRota = Convert.ToString(rotaOrdemServicoList[i].enderecoDestinatario); rota.Insert(j, conversaoEnderecoRota); j++; Console.WriteLine("teste:" + rota); } } return(this.apiTracaRota(criaOrigem(), this.conversaoListaStringEnderecos(rota), criaKey())); }
private void comboBox3_DropDown(object sender, System.EventArgs e) { AmazonDynamoDBClient client = new AmazonDynamoDBClient(); DynamoDBContext context = new DynamoDBContext(client); comboBox1.Items.Clear(); List <Servicos> asList = ComandoAWS.SearchDataTabelaServicos(context, "", "", "", "", "", ""); for (int i = 0; i < asList.Count(); i++) { if (!comboBox3.Items.Contains(asList[i].status)) { comboBox3.Items.Add(asList[i].status); } } }
private void button1_Click(object sender, EventArgs e) { OpenFileDialog openFileDialog = new OpenFileDialog(); openFileDialog.Multiselect = true; openFileDialog.Filter = "xml files (*.xml)|*.xml"; openFileDialog.ShowDialog(); LeituraNotaFiscal leituraNotaFiscal = new LeituraNotaFiscal(); AmazonDynamoDBClient client = new AmazonDynamoDBClient(); DynamoDBContext context = new DynamoDBContext(client); progressBar1.Value = 0; for (int i = 0; i < openFileDialog.FileNames.Count(); i++) { progressBar1.Maximum = openFileDialog.FileNames.Count() - 1; String caminho = openFileDialog.FileNames[i].ToString(); String nrNotaEntrega = leituraNotaFiscal.LeituraNrNota(caminho); String idMotorista = ComandoAWS.SearchCidades(context, "cidadeDestinatario", leituraNotaFiscal.LeituraCidadeDestinatario(caminho), "id"); String nomeDestinatarioEntrega = leituraNotaFiscal.LeituraNomeDestinatario(caminho); String remetenteEntrega = leituraNotaFiscal.LeituraCidadeRemetente(caminho); String destinatarioEntrega = leituraNotaFiscal.LeituraCidadeDestinatario(caminho); String enderecoDestinatario = leituraNotaFiscal.LeituraEnderecoDestinatario(caminho); String status = "Aguardando Retirada"; try { ComandoAWS.AddJob(context, nrNotaEntrega, idMotorista, nomeDestinatarioEntrega, enderecoDestinatario, destinatarioEntrega, status); } catch { MessageBox.Show("Falha ao salvar!"); } progressBar1.Value = i; } dataGridView1.DataSource = ComandoAWS.SearchDataTabelaServicos(context, "", "", "", "", "", ""); }
private void button2_Click(object sender, EventArgs e) { AmazonDynamoDBClient client = new AmazonDynamoDBClient(); DynamoDBContext context = new DynamoDBContext(client); try { if (idFuncionario.Text != "") { dataGridView1.DataSource = ComandoAWS.SearchDataTabelaServicos(context, "", idFuncionario.Text, "", "", "", ""); } else if (cidadeDestinatario.Text != "") { dataGridView1.DataSource = ComandoAWS.SearchDataTabelaServicos(context, "", "", cidadeDestinatario.Text, "", "", ""); } else if (xml.Text != "") { dataGridView1.DataSource = ComandoAWS.SearchDataTabelaServicos(context, xml.Text, "", "", "", "", ""); } else { dataGridView1.DataSource = ComandoAWS.SearchDataTabelaServicos(context, "", "", "", "", "", ""); } idFuncionario.Clear(); cidadeDestinatario.Clear(); status.Clear(); comboBox1.SelectedIndex = -1; comboBox2.SelectedIndex = -1; comboBox3.SelectedIndex = -1; } catch { Console.WriteLine("Erro na busca!"); } }