public void IntegraForcaDeVenda() { ProcessForm processForm = new ProcessForm("", layout); processForm.Show(); List<ForcaDeVenda> lForcaDeVenda = new List<ForcaDeVenda>(); IEnumerable<String> streamRead = File.ReadLines(System.Environment.CurrentDirectory.ToString() + "\\config.txt"); var connection = streamRead.First(); using (OleDbConnection con = new OleDbConnection(connection)) { try { con.Open(); using (OleDbCommand commandCount = new OleDbCommand("SELECT COUNT(*) FROM FORCA_VENDAS", con)) using (OleDbDataReader readerCount = commandCount.ExecuteReader()) { while (readerCount.Read()) { countRegister = readerCount.GetValue(0).ToString(); } } try{ using (OleDbCommand command = new OleDbCommand("SELECT ID_FV,ID_DISTRIBUIDOR,AREA_ATUACAO_FV,TIPO_FV,NOME_FV,EMAIL_FV,TEL_FV FROM FORCA_VENDAS", con)) using (OleDbDataReader reader = command.ExecuteReader()) { while (reader.Read()) { ForcaDeVenda forcaDeVenda = new ForcaDeVenda(); forcaDeVenda.id = reader.GetString(0); forcaDeVenda.distribuidorId = reader.GetString(1); forcaDeVenda.areaAtuacao = reader.GetString(2); forcaDeVenda.tipo = reader.GetString(3); forcaDeVenda.nome = reader.GetString(4); forcaDeVenda.email = reader.GetString(5); forcaDeVenda.telefone = reader.GetString(6); PostForcaDeVenda(forcaDeVenda); string msg = "Foram inseridos: " + lForcaDeVenda.Count().ToString() +" de "+countRegister+ " registros"; processForm.writeMessage(msg); processForm.Enabled = false; processForm.Enabled = true; lForcaDeVenda.Add(forcaDeVenda); } } con.Dispose(); } catch (Exception ex) { logErro.EscreverLog(layout, ex.Message.ToString()); //MessageBox.Show(ex.Message.ToString(), "Advetisament", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } catch (Exception ex) { logErro.EscreverLog(layout, ex.Message.ToString()); //MessageBox.Show(ex.Message.ToString(), "Advetisament", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } int countWrite = lForcaDeVenda.Count(); //MessageBox.Show("Foram inseridos "+countWrite.ToString()+" registros", "Advetisament", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); processForm.Close(); }
private void forçaDeVendaToolStripMenuItem_Click(object sender, EventArgs e) { ForcaDeVenda fv = new ForcaDeVenda(); fv.IntegraForcaDeVenda(); }
public void PostForcaDeVenda(ForcaDeVenda faturamento) { var param = Newtonsoft.Json.JsonConvert.SerializeObject(faturamento); var httpClient = new HttpClient(); HttpContent contentPost = new StringContent(param, Encoding.UTF8, "application/json"); var response = httpClient.PostAsync("https://chevron.exata.it/api/ForcaDeVenda", contentPost); //MessageBox.Show(param.ToString() + "response: " + response.Result.ToString(), "Advetisament", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); if (response.Result.StatusCode.ToString() != "Accepted") { logErro.EscreverLog(layout, response.Result.ToString()); } }
private void Timer_Tick(object sender, EventArgs e) { //MessageBox.Show("Começou!!!"); interval--; label1.Text = interval.ToString(); if(interval==0){ Timer.Stop(); CarteiraCliente carteiraCliente = new CarteiraCliente(); Cliente cliente = new Cliente(); EnderecoCliente enderecoCliente = new EnderecoCliente(); Estoque estoque = new Estoque(); Faturamento faturamento = new Faturamento(); ForcaDeVenda forcaDeVenda = new ForcaDeVenda(); FormaDePagamento formaDePagamento = new FormaDePagamento(); Pedido pedido = new Pedido(); Produto produto = new Produto(); TabelaPreco tabelaPreco = new TabelaPreco(); carteiraCliente.IntegraCarteiraCliente(); cliente.IntegraCliente(); enderecoCliente.IntegraEnderecoCliente(); estoque.IntegraEstoque(); faturamento.IntegraFaturamento(); forcaDeVenda.IntegraForcaDeVenda(); formaDePagamento.IntegraFormaDePagamento(); pedido.IntegraPedido(); produto.IntegraProduto(); tabelaPreco.IntegraTabelaPreço(); Timer.Enabled = true; //interval = 10; interval = int.Parse(System.Configuration.ConfigurationManager.AppSettings["Interval"]); //interval = ChevronClienteApplication. Timer.Start(); } }