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!"); }
}
