private void editaFuncionario(object sender, EventArgs e)
{
frmFunc = sender as CadastraFuncionario;
frmFunc.btnEnviar.Click -= frmFunc.btnEnviar_Click;
frmFunc.btnEnviar.Click += ConfirmaEditarFuncionario;
frmFunc.btnCancelar.Click += CancelaEditarFuncionario;
frmFunc.AutoScroll = true;
frmFunc.Parent = splitContainerContent.Panel2;
frmFunc.Dock = DockStyle.Fill;
splitPrincipal.Panel2.Controls.Add(frmFunc);
frmFunc.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 = dataGridViewFunc.CurrentRow.Cells[0].Value.ToString();
MySqlCommand endereco = new MySqlCommand("select id_endereco from funcionario where id_funcionario = " + 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);
MySqlCommand objcmd7 = new MySqlCommand("select nome from cargos where id_funcionario = " + id + " ORDER BY inicio_data DESC LIMIT 1", objcon);
MySqlCommand objcmd8 = new MySqlCommand("select valor_salario from salarios where id_funcionario = " + id + " ORDER BY inicio_data DESC LIMIT 1", objcon);
MySqlCommand objcmd9 = new MySqlCommand("select senha from funcionario where id_funcionario = " + id, objcon);
CadastraFuncionario frm = new CadastraFuncionario();
frm.lbId.Text = id;
frm.txtNome.Text = dataGridViewFunc.CurrentRow.Cells[1].Value.ToString();
frm.txtTelefone.Text = dataGridViewFunc.CurrentRow.Cells[2].Value.ToString();
frm.txtEmail.Text = dataGridViewFunc.CurrentRow.Cells[3].Value.ToString();
frm.txtRG.Text = dataGridViewFunc.CurrentRow.Cells[4].Value.ToString();
frm.txtCPF.Text = dataGridViewFunc.CurrentRow.Cells[5].Value.ToString();
frm.txtDataCont.Text = dataGridViewFunc.CurrentRow.Cells[6].Value.ToString();
frm.txtDataNasc.Text = dataGridViewFunc.CurrentRow.Cells[7].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();
frm.txtCargo.Text = objcmd7.ExecuteScalar().ToString();
frm.txtSalario.Text = objcmd8.ExecuteScalar().ToString();
if (dataGridViewFunc.CurrentRow.Cells[8].Value.ToString() == "M")
{
frm.btnMasc.Checked = true;
}
else
{
frm.btnFem.Checked = true;
}
objcon.Close();
frm.txtCargo.Enabled = false;
frm.txtSalario.Enabled = false;
frm.BackColor = Color.FromArgb(240, 240, 240);
frm.AutoScroll = true;
frm.Left = 256;
frm.Height = 500;
frm.lbTitulo.Text = "Edita Funcionário";
frm.btnCancelar.Visible = true;
EventHandler handler = EditaFunc;
handler?.Invoke(frm, e);
}
catch { MessageBox.Show("Não há registros para editar!"); }
}
