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; }
private void comboBoxFornecedor_SelectedIndexChanged(object sender, EventArgs e) { int var = (comboBoxFornecedor.SelectedItem as ComboBoxItem).Value; foreach (var item in fornecedores) { if (item.Value == var) { fornecedor = new ClassFornecedor { nome = item.Text, IdFornecedor = item.Value, }; } } UpdateGridViewConsultas(); }
private ClassFornecedor getFornecedor(int enviarFornecedor) { conn.Open(); string queryInsertData = "SELECT * from Fornecedor WHERE IdFornecedor = " + enviarFornecedor; SqlCommand sqlCommand = new SqlCommand(queryInsertData, conn); SqlDataReader reader = sqlCommand.ExecuteReader(); ClassFornecedor forn = null; while (reader.Read()) { if ((int)reader["IdFornecedor"] == enviarFornecedor) { forn = new ClassFornecedor { nome = (string)reader["nome"], nif = ((reader["nif"] == DBNull.Value) ? null : (int?)reader["nif"]), contacto = ((reader["contacto"] == DBNull.Value) ? null : (int?)reader["contacto"]), email = ((reader["email"] == DBNull.Value) ? "" : (string)reader["email"]), rua = (string)reader["rua"], numeroMorada = ((reader["numeroMorada"] == DBNull.Value) ? null : (int?)reader["numeroMorada"]), andarPiso = ((reader["andarPiso"] == DBNull.Value) ? "" : (string)reader["andarPiso"]), localidade = (string)reader["localidade"], bairroLocal = ((reader["bairroLocal"] == DBNull.Value) ? "" : (string)reader["bairroLocal"]), codigoPostal = (reader["codPostalPrefixo"]) + "-" + (reader["codPostalSufixo"]), designacao = ((reader["designacao"] == DBNull.Value) ? "" : (string)reader["designacao"]), observacoes = ((reader["observacoes"] == DBNull.Value) ? "" : (string)reader["observacoes"]), IdFornecedor = (int)(reader["IdFornecedor"]) }; } } conn.Close(); return(forn); }
private void UpdateDataGridView() { try { fornecedor.Clear(); conn.Open(); com.Connection = conn; SqlCommand cmd = new SqlCommand("select * from Fornecedor ORDER BY nome", conn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { ClassFornecedor forn = new ClassFornecedor { nome = (string)reader["nome"], nif = ((reader["nif"] == DBNull.Value) ? null : (int?)reader["nif"]), contacto = ((reader["contacto"] == DBNull.Value) ? null : (int?)reader["contacto"]), email = ((reader["email"] == DBNull.Value) ? "" : (string)reader["email"]), rua = (string)reader["rua"], numeroMorada = ((reader["numeroMorada"] == DBNull.Value) ? null : (int?)reader["numeroMorada"]), andarPiso = ((reader["andarPiso"] == DBNull.Value) ? "" : (string)reader["andarPiso"]), localidade = (string)reader["localidade"], bairroLocal = ((reader["bairroLocal"] == DBNull.Value) ? "" : (string)reader["bairroLocal"]), codigoPostal = (reader["codPostalPrefixo"]) + "-" + (reader["codPostalSufixo"]), designacao = ((reader["designacao"] == DBNull.Value) ? "" : (string)reader["designacao"]), observacoes = ((reader["observacoes"] == DBNull.Value) ? "" : (string)reader["observacoes"]), }; fornecedor.Add(forn); } var bindingSource1 = new System.Windows.Forms.BindingSource { DataSource = fornecedor }; dataGridViewFornecedores.DataSource = bindingSource1; dataGridViewFornecedores.Columns[0].HeaderText = "Nome Fornecedor"; dataGridViewFornecedores.Columns[1].HeaderText = "Nif"; dataGridViewFornecedores.Columns[2].HeaderText = "Contacto"; dataGridViewFornecedores.Columns[3].HeaderText = "Email"; dataGridViewFornecedores.Columns[4].HeaderText = "Morada"; dataGridViewFornecedores.Columns[5].HeaderText = "Número"; dataGridViewFornecedores.Columns[6].HeaderText = "Andar/Piso"; dataGridViewFornecedores.Columns[7].HeaderText = "Localidade"; dataGridViewFornecedores.Columns[8].HeaderText = "Bairro/Local"; dataGridViewFornecedores.Columns[9].HeaderText = "Codigo Postal"; dataGridViewFornecedores.Columns[10].HeaderText = "Designação"; dataGridViewFornecedores.Columns[11].HeaderText = "Observações"; dataGridViewFornecedores.Columns[12].Visible = false; conn.Close(); dataGridViewFornecedores.Update(); dataGridViewFornecedores.Refresh(); } 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); } }