public int ValidaCNPJ() { String CnpjTrans = (String)txtCnpjTrans.Text.Replace(".", "").Replace("/", "").Replace("-", ""); //Valida CNPJ DataRowView x; x = (DataRowView)tRANSPORTADORABindingSource.Current; int cnpj = valida.ValidaCNPJ(CnpjTrans); return(cnpj); }
private void txtCnpjCli_Leave(object sender, EventArgs e) { Validacoes v = new Validacoes(); if (!string.IsNullOrEmpty(txtCnpjCli.Text) && txtCnpjCli.Text.Length == 14) { if (v.ValidaCNPJ(txtCnpjCli.Text) == 1) { pictureBox1.Visible = true; pictureBox2.Visible = false; txtCnpjCli.Focus(); } else { pictureBox1.Visible = false; pictureBox2.Visible = true; } } else { pictureBox1.Visible = true; pictureBox2.Visible = false; txtCnpjCli.Focus(); } }
public int salvar(bool edit) { DataRowView x; x = (DataRowView)cLIENTEBindingSource.Current; Validacoes valida = new Validacoes(); string c = ConfigurationManager.ConnectionStrings["Comercial.Properties.Settings.COMERCIALConnectionString"].ConnectionString; //Valida CNPJ if (!String.IsNullOrEmpty(txtCnpjCli.Text) && txtCnpjCli.Text.Trim().Length == 14) { int cnpj = valida.ValidaCNPJ(txtCnpjCli.Text); if (cnpj == 1) { //MessageBox.Show("CNPJ Inválido.", "Erro", MessageBoxButtons.OK, MessageBoxIcon.Error); //return 1; throw new Exception("cnpj invalido"); } } else { throw new Exception("cnpj invalido"); } // Valida IE if (!String.IsNullOrEmpty(txtIeCli.Text)) { string ie = txtIeCli.Text; string uf = cmbUfCli.SelectedItem.ToString(); int returnIe = ConsisteInscricaoEstadual(ie, uf); if (returnIe == 1) { //MessageBox.Show("I.E. Inválida.", "Erro", MessageBoxButtons.OK, MessageBoxIcon.Error); //return 1; throw new Exception("ie invalida"); } //if (string.IsNullOrEmpty(txtRazaoSocialCli.Text)) //{ // MessageBox.Show("Campo(s) obrigatório(s) não preenchido(s).", "Erro", MessageBoxButtons.OK, MessageBoxIcon.Error); // return 1; //} } // Valida limite de crédito // string va = txtLimCredCli.Te if(!String.IsNullOrEmpty(txtLimCredCli.Text)) { double valor = double.Parse(txtLimCredCli.Text,System.Globalization.NumberStyles.Currency); if (valor<=0) { throw new Exception("valor invalido"); } } // Valida email if (!string.IsNullOrEmpty(txtEmailCli.Text)) { Boolean emailOk = valida.ValidaEmail(txtEmailCli.Text); if (emailOk == false) { //MessageBox.Show("Email Inválido.", "Erro", MessageBoxButtons.OK, MessageBoxIcon.Error); //return 1; throw new Exception("email invalido"); } #region Salva Usuario if (edit == false) { if (!string.IsNullOrEmpty(txtUsuarioCli.Text) && !string.IsNullOrEmpty(txtSenhaCli.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 = txtUsuarioCli.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(txtUsuarioCli.Text, txtSenhaCli.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 = txtUsuarioCli.Text; cmd1.Parameters.Add(param1); SqlDataReader reader1 = cmd1.ExecuteReader(); reader1.Read(); x["CodUSUARIO"] = reader1["codusuario"]; reader1.Dispose(); reader1.Close(); conn1.Close(); conn1.Dispose(); } #endregion if (chckBxCred.Checked) { x["APROVADOCRED"] = "S"; } else { x["APROVADOCRED"] = "N"; } x["CEP"] = txtCepCli.getText; txtSenhaCli.Text = ""; txtUsuarioCli.Text = ""; } return 0; }
private void txtCnpjCli_Leave(object sender, EventArgs e) { Validacoes v = new Validacoes(); if (!string.IsNullOrEmpty(txtCnpjCli.Text) && txtCnpjCli.Text.Length==14) { if (v.ValidaCNPJ(txtCnpjCli.Text) == 1) { pictureBox1.Visible = true; pictureBox2.Visible = false; txtCnpjCli.Focus(); } else { pictureBox1.Visible = false; pictureBox2.Visible = true; } } else { pictureBox1.Visible = true; pictureBox2.Visible = false; txtCnpjCli.Focus(); } }
public int salvar(bool edit) { DataRowView x; x = (DataRowView)cLIENTEBindingSource.Current; Validacoes valida = new Validacoes(); string c = ConfigurationManager.ConnectionStrings["Comercial.Properties.Settings.COMERCIALConnectionString"].ConnectionString; //Valida CNPJ if (!String.IsNullOrEmpty(txtCnpjCli.Text) && txtCnpjCli.Text.Trim().Length == 14) { int cnpj = valida.ValidaCNPJ(txtCnpjCli.Text); if (cnpj == 1) { //MessageBox.Show("CNPJ Inválido.", "Erro", MessageBoxButtons.OK, MessageBoxIcon.Error); //return 1; throw new Exception("cnpj invalido"); } } else { throw new Exception("cnpj invalido"); } // Valida IE if (!String.IsNullOrEmpty(txtIeCli.Text)) { string ie = txtIeCli.Text; string uf = cmbUfCli.SelectedItem.ToString(); int returnIe = ConsisteInscricaoEstadual(ie, uf); if (returnIe == 1) { //MessageBox.Show("I.E. Inválida.", "Erro", MessageBoxButtons.OK, MessageBoxIcon.Error); //return 1; throw new Exception("ie invalida"); } //if (string.IsNullOrEmpty(txtRazaoSocialCli.Text)) //{ // MessageBox.Show("Campo(s) obrigatório(s) não preenchido(s).", "Erro", MessageBoxButtons.OK, MessageBoxIcon.Error); // return 1; //} } // Valida limite de crédito // string va = txtLimCredCli.Te if (!String.IsNullOrEmpty(txtLimCredCli.Text)) { double valor = double.Parse(txtLimCredCli.Text, System.Globalization.NumberStyles.Currency); if (valor <= 0) { throw new Exception("valor invalido"); } } // Valida email if (!string.IsNullOrEmpty(txtEmailCli.Text)) { Boolean emailOk = valida.ValidaEmail(txtEmailCli.Text); if (emailOk == false) { //MessageBox.Show("Email Inválido.", "Erro", MessageBoxButtons.OK, MessageBoxIcon.Error); //return 1; throw new Exception("email invalido"); } #region Salva Usuario if (edit == false) { if (!string.IsNullOrEmpty(txtUsuarioCli.Text) && !string.IsNullOrEmpty(txtSenhaCli.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 = txtUsuarioCli.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(txtUsuarioCli.Text, txtSenhaCli.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 = txtUsuarioCli.Text; cmd1.Parameters.Add(param1); SqlDataReader reader1 = cmd1.ExecuteReader(); reader1.Read(); x["CodUSUARIO"] = reader1["codusuario"]; reader1.Dispose(); reader1.Close(); conn1.Close(); conn1.Dispose(); } #endregion if (chckBxCred.Checked) { x["APROVADOCRED"] = "S"; } else { x["APROVADOCRED"] = "N"; } x["CEP"] = txtCepCli.getText; txtSenhaCli.Text = ""; txtUsuarioCli.Text = ""; } return(0); }