Ejemplo n.º 1
0
        private void button2_Click(object sender, EventArgs e)
        {
            AmazonDynamoDBClient client  = new AmazonDynamoDBClient();
            DynamoDBContext      context = new DynamoDBContext(client);

            dataGridView1.DataSource = ComandoAWS.SearchDataTabelaServicos(context, "", "", "", "", "", "");
        }
Ejemplo n.º 2
0
        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()));
        }
Ejemplo n.º 3
0
        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);
                }
            }
        }
Ejemplo n.º 4
0
        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, "", "", "", "", "", "");
        }
Ejemplo n.º 5
0
        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!");
            }
        }