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(); }