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