private void txtCPF_Leave(object sender, EventArgs e) { Validacoes v = new Validacoes(); if (!string.IsNullOrEmpty(txtCPF.Text)) { if (v.ValidaCPF(txtCPF.Text) == 1) { pictureBox1.Visible = true; pictureBox2.Visible = false; } else { pictureBox1.Visible = false; pictureBox2.Visible = true; } } else { pictureBox1.Visible = true; pictureBox2.Visible = false; } }
/* * SALVAR RETORNA: * 0 - OK * 1 - ERRO */ public int salvar(bool edit) { #region Validaçoes //Valida CPFe email string c = ConfigurationManager.ConnectionStrings["Comercial.Properties.Settings.COMERCIALConnectionString"].ConnectionString; Validacoes valida = new Validacoes(); if (!string.IsNullOrEmpty(txtCPF.Text) && !string.IsNullOrEmpty(txtComissao.Text)) { int cpf = valida.ValidaCPF(txtCPF.Text); bool email = true; if (!string.IsNullOrEmpty(txtEmail.Text)) { email = valida.ValidaEmail(txtEmail.Text); } if (cpf == 1) { MessageBox.Show("CPF Inválido.", "Erro", MessageBoxButtons.OK, MessageBoxIcon.Error); return(1); } if (email == false) { MessageBox.Show("E-mail Inválido.", "Erro", MessageBoxButtons.OK, MessageBoxIcon.Error); return(1); } if (Convert.ToDouble(txtComissao.Text) < 0) { MessageBox.Show("Comissão Inválida.", "Erro", MessageBoxButtons.OK, MessageBoxIcon.Error); return(1); } } else { throw new Exception("campo vazio"); } #endregion DataRowView x; x = (DataRowView)vENDEDORBindingSource.Current; #region Salva Usuario if (edit == false) { if (!string.IsNullOrEmpty(txtUsu.Text) && !string.IsNullOrEmpty(txtSenha.Text)) { SqlConnection conn = new SqlConnection(c); conn.Open(); SqlCommand cmd = new SqlCommand("select * from usuario where usuario = @usu", conn); SqlParameter param = new SqlParameter(); param.ParameterName = "@usu"; param.Value = txtUsu.Text; cmd.Parameters.Add(param); SqlDataReader reader = cmd.ExecuteReader(); reader.Read(); if (reader.HasRows) { MessageBox.Show("Usuário ja cadastrado.", "Erro", MessageBoxButtons.OK, MessageBoxIcon.Error); return(1); } else { COMERCIALDataSetTableAdapters.USUARIOTableAdapter usu = new Comercial.COMERCIALDataSetTableAdapters.USUARIOTableAdapter(); usu.Insert(txtUsu.Text, txtSenha.Text, "N", "S"); } reader.Dispose(); reader.Close(); conn.Close(); conn.Dispose(); } SqlConnection conn1 = new SqlConnection(c); conn1.Open(); SqlCommand cmd1 = new SqlCommand("select * from usuario where usuario = @usu", conn1); SqlParameter param1 = new SqlParameter(); param1.ParameterName = "@usu"; param1.Value = txtUsu.Text; cmd1.Parameters.Add(param1); SqlDataReader reader1 = cmd1.ExecuteReader(); reader1.Read(); x["CodUSUARIO"] = reader1["codusuario"]; reader1.Dispose(); reader1.Close(); conn1.Close(); conn1.Dispose(); } #endregion x["CEP"] = txtcep.getText; x["ATIVO"] = "S"; if (radioButton1.Checked) { x["SEXO"] = "M"; } else { x["SEXO"] = "F"; } txtSenha.Text = ""; txtUsu.Text = ""; return(0); }