public void gravar()
{
if (validacao())
{
MySqlConnection con = new MySqlConnection(Config.Conexao);
MySqlCommand cmd = new MySqlCommand("insert into endereco(rua,bairro,cep,cidade,uf,complemento,numero) values(@a,@b,@c,@d,@e,@f,@g)");
cmd.Parameters.AddWithValue("@a", txtrua.Text);
cmd.Parameters.AddWithValue("@b", txtbairro.Text);
cmd.Parameters.AddWithValue("@c", txtcep.Text);
cmd.Parameters.AddWithValue("@d", txtcidade.Text);
cmd.Parameters.AddWithValue("@e", cbuf.Text);
cmd.Parameters.AddWithValue("@f", txtcomplemento.Text);
cmd.Parameters.AddWithValue("@g", Convert.ToInt32(txtnumero.Text));
con.Open();
cmd.Connection = con;
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
cmd.CommandText = "select max(id_endereco) from endereco";
int id = Convert.ToInt32(cmd.ExecuteScalar().ToString());
cmd.CommandText = "insert into pessoa_fisica(nome,email,cpf,telefone,id_endereco,rg,data_nascimento,genero,celular) values(@a,@b,@c,@d,@e,@f,@g,@h,@i)";
cmd.Parameters.AddWithValue("@a", txtnome.Text);
cmd.Parameters.AddWithValue("@b", txtemail.Text);
cmd.Parameters.AddWithValue("@c", txtcpf.Text);
string telefone = "", celular = "";
if (txttelefone.Text.Length == 14)
{
telefone = txttelefone.Text;
}
if (txtcelular.Text.Length == 14)
{
celular = txtcelular.Text;
}
cmd.Parameters.AddWithValue("@d", telefone);
cmd.Parameters.AddWithValue("@e", id);
cmd.Parameters.AddWithValue("@f", txtrg.Text);
cmd.Parameters.AddWithValue("@g", txtdata.Value);
cmd.Parameters.AddWithValue("@h", cbgenero.Text);
cmd.Parameters.AddWithValue("@i", celular);
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
cmd.CommandText = "select max(id_pessoa_fisica) from pessoa_fisica";
id = Convert.ToInt32(cmd.ExecuteScalar().ToString());
cmd.CommandText = "insert into cliente(id_pessoa_fisica) values(" + id + ")";
cmd.ExecuteNonQuery();
con.Close();
if (consulta != null)
{
consulta.PreencheGridGeral();
}
MessageBox.Show("Cliente Cadastrado com sucesso", "Atenção", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
}
