private void editaFornecedor(object sender, EventArgs e) { frmForn = sender as CadastraFornecedor; frmForn.btnEnviar.Click -= frmForn.btnEnviar_Click; frmForn.btnEnviar.Click += ConfirmaEditarFornecedor; frmForn.btnCancelar.Click += CancelaEditarFornecedor; frmForn.AutoScroll = true; frmForn.Parent = splitContainerContent.Panel2; frmForn.Dock = DockStyle.Fill; splitPrincipal.Panel2.Controls.Add(frmForn); frmForn.BringToFront(); }
private void btnEditar_Click(object sender, EventArgs e) { try { MySqlConnection objcon = new MySqlConnection("server=localhost;port=3306;User Id=root;database=splash_shark;Character Set=utf8"); // abre o banco objcon.Open(); string id = dataGridViewForn.CurrentRow.Cells[0].Value.ToString(); MySqlCommand endereco = new MySqlCommand("select id_endereco from fornecedorendereco where id_fornecedor = " + id, objcon); int idEnd = Convert.ToInt32(endereco.ExecuteScalar()); MySqlCommand objcmd1 = new MySqlCommand("select logradouro from endereco where id_endereco = " + idEnd, objcon); MySqlCommand objcmd2 = new MySqlCommand("select bairro from endereco where id_endereco = " + idEnd, objcon); MySqlCommand objcmd3 = new MySqlCommand("select cidade from endereco where id_endereco = " + idEnd, objcon); MySqlCommand objcmd4 = new MySqlCommand("select cep from endereco where id_endereco = " + idEnd, objcon); MySqlCommand objcmd5 = new MySqlCommand("select numero from endereco where id_endereco = " + idEnd, objcon); MySqlCommand objcmd6 = new MySqlCommand("select uf from endereco where id_endereco = " + idEnd, objcon); CadastraFornecedor frm = new CadastraFornecedor(); frm.lbId.Text = id; frm.txtNome.Text = dataGridViewForn.CurrentRow.Cells[1].Value.ToString(); frm.txtPseudonimo.Text = dataGridViewForn.CurrentRow.Cells[2].Value.ToString(); frm.txtEmail.Text = dataGridViewForn.CurrentRow.Cells[3].Value.ToString(); frm.txtCNPJ.Text = dataGridViewForn.CurrentRow.Cells[4].Value.ToString(); frm.txtInscEstadual.Text = dataGridViewForn.CurrentRow.Cells[5].Value.ToString(); frm.txtRua.Text = objcmd1.ExecuteScalar().ToString(); frm.txtBairro.Text = objcmd2.ExecuteScalar().ToString(); frm.txtCidade.Text = objcmd3.ExecuteScalar().ToString(); frm.txtCep.Text = objcmd4.ExecuteScalar().ToString(); frm.txtNum.Text = objcmd5.ExecuteScalar().ToString(); frm.txtEstado.SelectedItem = objcmd6.ExecuteScalar().ToString(); objcon.Close(); frm.BackColor = Color.FromArgb(240, 240, 240); frm.AutoScroll = true; frm.Left = 256; frm.Height = 500; frm.lbTitulo.Text = "Edita Fornecedor"; frm.btnCancelar.Visible = true; EventHandler handler = EditaForn; handler?.Invoke(frm, e); } catch { MessageBox.Show("Não há registros para editar!"); } }