private void txtfunccodi_Leave(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(txtfuncodi.Text))
{
return;
}
var dr = FuncionarioDao.GetFullById(int.Parse(txtfuncodi.Text));
if (dr.Read())
{
txtfuncodi.Text = dr["FUNCODI"].ToString();
txtfunnome.Text = dr["FUNNOME"].ToString();
txtfundtna.Text = dr["FUNDTNA"].ToString();
txtfuncpf.Text = dr["FUNCPF"].ToString();
txtfunrg.Text = dr["FUNRG"].ToString();
txtfunsala.Text = dr["FUNSALA"].ToString();
txtfunfone.Text = dr["FUNFONE"].ToString();
txtfuncelular.Text = dr["FUNCELU"].ToString();
txtfuncel1.Text = dr["FUNCEL1"].ToString();
txtfuncep.Text = dr["ENDCEP"].ToString();
txtfunend.Text = dr["ENDENDE"].ToString();
txtfuncidade.Text = dr["MUNNOME"].ToString();
txtfunbairro.Text = dr["BAINOME"].ToString();
txtfunestado.Text = dr["ESTNOME"].ToString();
txtfunpais.Text = dr["PAINOME"].ToString();
txtfunnumero.Text = dr["FUNNUME"].ToString();
cblfundep.SelectedItem = Departamentos.FirstOrDefault(q => q.Split('-')[0].Trim() == dr["DEPCODI"].ToString());
cblfunfunc.SelectedItem = Funcoes.FirstOrDefault(q => q.Split('-')[0].Trim() == dr["FUNCCODI"].ToString());
cblfunhorario.SelectedItem = Horarios.FirstOrDefault(q => q.Split('-')[0].Trim() == dr["HORCODI"].ToString());
edicao = true;
}
else
{
edicao = false;
if ((MessageBox.Show("Registro não encontrado \n deseja cadastra-lo?", "Cadastro", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) == DialogResult.No))
{
limpar();
}
else
{
var tempoCodi = txtfuncodi.Text;
limpar();
txtfuncodi.Text = tempoCodi;
txtfunnome.Focus();
}
}
dr.Close();
}
