private void UpdateDataGridView() { try { listaEncomendas.Clear(); conn.Open(); com.Connection = conn; SqlCommand cmd = new SqlCommand("select enc.IdEncomenda, enc.Nfatura, fornecedor.nome, enc.dataRegistoEncomenda, enc.dataEntregaPrevista, enc.dataEntregaReal from Fornecedor fornecedor JOIN Encomenda enc ON fornecedor.IdFornecedor = enc.idFornecedor WHERE enc.dataEntregaReal IS NULL ORDER BY enc.IdEncomenda", conn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { string dataRegistoEnc = DateTime.ParseExact(reader["dataRegistoEncomenda"].ToString(), "dd/MM/yyyy HH:mm:ss", null).ToString("dd/MM/yyyy"); string dataEntregaPrev = DateTime.ParseExact(reader["dataEntregaPrevista"].ToString(), "dd/MM/yyyy HH:mm:ss", null).ToString("dd/MM/yyyy"); string dataEntregaR = ""; if (reader["dataEntregaReal"].ToString() != "") { dataEntregaR = DateTime.ParseExact(reader["dataEntregaReal"].ToString(), "dd/MM/yyyy HH:mm:ss", null).ToString("dd/MM/yyyy"); } Encomendas encomendas = new Encomendas { IdEncomenda = (int)reader["IdEncomenda"], NFatura = (string)reader["Nfatura"], nome = (string)reader["nome"], dataRegisto = dataRegistoEnc, dataEntregaPrevista = dataEntregaPrev, dataEntregaReal = dataEntregaR, }; listaEncomendas.Add(encomendas); } var bindingSource1 = new System.Windows.Forms.BindingSource { DataSource = listaEncomendas }; dataGridViewEncomendas.DataSource = bindingSource1; dataGridViewEncomendas.Columns[0].HeaderText = "Número da Encomenda"; dataGridViewEncomendas.Columns[1].HeaderText = "Nome Fornecedor"; dataGridViewEncomendas.Columns[2].HeaderText = "Data de Registo da Encomanda"; dataGridViewEncomendas.Columns[3].HeaderText = "Data de Entrega Prevista"; dataGridViewEncomendas.Columns[4].HeaderText = "Data de Entrega Real"; dataGridViewEncomendas.Columns[5].Visible = false; conn.Close(); auxiliar = listaEncomendas; dataGridViewEncomendas.Update(); dataGridViewEncomendas.Refresh(); } catch (Exception) { if (conn.State == ConnectionState.Open) { conn.Close(); } MessageBox.Show("Por erro interno é impossível selecionar os dados!", "Atenção!", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public LinhaEncomenda(ClassFornecedor forn, Encomendas enc, RegistarEncomendas registarEncomendas) { InitializeComponent(); encomendas = enc; registar = registarEncomendas; fornecedor = forn; label11.Text = "Fornecedor: " + fornecedor.nome; conn.ConnectionString = @"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=SiltesSaude;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"; //var bindingSource2 = new System.Windows.Forms.BindingSource { DataSource = encomendas }; //dataGridViewEncomenda.DataSource = bindingSource2; }
public void reiniciar() { try { listaEnc.Clear(); cbEncomendas.Items.Clear(); auxiliar.Clear(); conn.Open(); com.Connection = conn; SqlCommand cmd = new SqlCommand("select * from Encomenda WHERE dataEntregaReal IS NULL order by Nfatura asc", conn); // cmd.Parameters.AddWithValue("@Null", DBNull.Value); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { string data = DateTime.ParseExact(reader["dataRegistoEncomenda"].ToString(), "dd/MM/yyyy HH:mm:ss", null).ToString("dd/MM/yyyy"); string dataPrevista = DateTime.ParseExact(reader["dataEntregaPrevista"].ToString(), "dd/MM/yyyy HH:mm:ss", null).ToString("dd/MM/yyyy"); ComboBoxItem item = new ComboBoxItem(); item.Text = (string)reader["Nfatura"]; item.Value = (int)reader["IdEncomenda"]; cbEncomendas.Items.Add(item); Encomendas enc = new Encomendas { NFatura = (string)reader["Nfatura"], //nome = (string)reader["idFornecedor"], dataRegisto = data, dataEntregaPrevista = dataPrevista, IdEncomenda = (int)reader["IdEncomenda"], }; listaEnc.Add(enc); } conn.Close(); } catch (Exception) { if (conn.State == ConnectionState.Open) { conn.Close(); } MessageBox.Show("Por erro interno é impossível visualizar os dados!", "Atenção!", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void dataGridViewEncomendas_MouseDoubleClick(object sender, MouseEventArgs e) { int i = dataGridViewEncomendas.CurrentCell.RowIndex; foreach (var enc in auxiliar) { if (enc.NFatura == (Convert.ToString(dataGridViewEncomendas.Rows[i].Cells[0].Value))) { encomendas = enc; } } if (encomendas != null) { txtNumeroEncomenda.Text = (encomendas.NFatura).ToString(); //txtNumeroEncomenda.Text = Convert.ToString(encomendas.IdEncomenda); txtFornecedor.Text = encomendas.nome; labelData.Text = encomendas.dataRegisto; txtDataEntregaPrevista.Text = encomendas.dataEntregaPrevista; // dataVEntregaReal.Value = DateTime.ParseExact(encomendas.dataEntregaReal, "dd/MM/yyyy", null) ; } }
private void btnGuardar_Click(object sender, EventArgs e) { try { if (VerificarDadosInseridos()) { int fornecedor = (comboBoxFornecedor.SelectedItem as ComboBoxItem).Value; DateTime data = dataEntregaPrevista.Value; // string observacoes = txtObservacoes.Text; string encomenda = txtNumeroEncomenda.Text; conn.Open(); string queryInsertData = "INSERT INTO Encomenda(Nfatura,idFornecedor,dataRegistoEncomenda,dataEntregaPrevista) VALUES(@Nfatura,@IdFornecedor,@DataRegistoEncomenda,@DataEntregaPrevista);"; SqlCommand sqlCommand = new SqlCommand(queryInsertData, conn); sqlCommand.Parameters.AddWithValue("@DataEntregaPrevista", data.ToString("MM/dd/yyyy")); sqlCommand.Parameters.AddWithValue("@DataRegistoEncomenda", inicio.ToString("MM/dd/yyyy")); sqlCommand.Parameters.AddWithValue("@IdFornecedor", fornecedor); sqlCommand.Parameters.AddWithValue("@Nfatura", encomenda); sqlCommand.ExecuteNonQuery(); MessageBox.Show("Encomenda registada com Sucesso!", "Sucesso!", MessageBoxButtons.OK, MessageBoxIcon.Information); conn.Close(); UpdateDataGridView(); conn.Open(); Encomendas enc = null; string nurEncomenda = txtNumeroEncomenda.Text; string queryInsertData1 = "SELECT * from Encomenda WHERE Nfatura = @Numfatura"; SqlCommand sqlCommand1 = new SqlCommand(queryInsertData1, conn); sqlCommand1.Parameters.AddWithValue("@Numfatura", nurEncomenda); SqlDataReader reader = sqlCommand1.ExecuteReader(); while (reader.Read()) { enc = new Encomendas { IdEncomenda = (int)reader["IdEncomenda"], NFatura = (string)reader["Nfatura"], }; } conn.Close(); LinhaEncomenda linha = new LinhaEncomenda(getFornecedor(fornecedor), enc, this); linha.Show(); limparCampos(); } } catch (SqlException) { if (conn.State == ConnectionState.Open) { conn.Close(); } MessageBox.Show("Por erro interno é impossível registar a encomenda!", "Atenção!", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void UpdateDataGridView() { listaEncomendas.Clear(); conn.Open(); com.Connection = conn; SqlCommand cmd = new SqlCommand("select enc.NFatura, fornecedor.nome, enc.dataRegistoEncomenda, enc.dataEntregaPrevista from Fornecedor fornecedor JOIN Encomenda enc ON fornecedor.IdFornecedor = enc.idFornecedor WHERE enc.dataEntregaReal IS NULL ORDER BY dataRegistoEncomenda", conn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { string dataRegistoEnc = DateTime.ParseExact(reader["dataRegistoEncomenda"].ToString(), "dd/MM/yyyy HH:mm:ss", null).ToString("dd/MM/yyyy"); string dataEntregaPrev = DateTime.ParseExact(reader["dataEntregaPrevista"].ToString(), "dd/MM/yyyy HH:mm:ss", null).ToString("dd/MM/yyyy"); Encomendas encomendas = new Encomendas { NFatura = (string)reader["NFatura"], nome = (string)reader["nome"], dataRegisto = dataRegistoEnc, dataEntregaPrevista = dataEntregaPrev, }; listaEncomendas.Add(encomendas); } var bindingSource1 = new System.Windows.Forms.BindingSource { DataSource = listaEncomendas }; dataGridViewEncomendas.DataSource = bindingSource1; dataGridViewEncomendas.Columns[0].HeaderText = "Número da Fatura"; dataGridViewEncomendas.Columns[1].HeaderText = "Nome Fornecedor"; dataGridViewEncomendas.Columns[2].HeaderText = "Data de Registo da Encomenda"; dataGridViewEncomendas.Columns[3].HeaderText = "Data de Entrega Prevista"; dataGridViewEncomendas.Columns[4].Visible = false; dataGridViewEncomendas.Columns[5].Visible = false; conn.Close(); dataGridViewEncomendas.Update(); dataGridViewEncomendas.Refresh(); conn.Open(); com.Connection = conn; SqlCommand cmd1 = new SqlCommand("select enc.NFatura, fornecedor.nome, enc.dataRegistoEncomenda, enc.dataEntregaPrevista from Fornecedor fornecedor JOIN Encomenda enc ON fornecedor.IdFornecedor = enc.idFornecedor ORDER BY dataRegistoEncomenda", conn); SqlDataReader reader1 = cmd1.ExecuteReader(); while (reader1.Read()) { string dataRegistoEnc = DateTime.ParseExact(reader1["dataRegistoEncomenda"].ToString(), "dd/MM/yyyy HH:mm:ss", null).ToString("dd/MM/yyyy"); string dataEntregaPrev = DateTime.ParseExact(reader1["dataEntregaPrevista"].ToString(), "dd/MM/yyyy HH:mm:ss", null).ToString("dd/MM/yyyy"); Encomendas encomendas = new Encomendas { NFatura = (string)reader1["NFatura"], nome = (string)reader1["nome"], dataRegisto = dataRegistoEnc, dataEntregaPrevista = dataEntregaPrev, }; todasEncomendas.Add(encomendas); } conn.Close(); }