private void save()
{
//definição da string de conexão
using (SqlConnection connteste = new SqlConnection(this.stringConnection))
{
string cpfAuxinput = TextBoxCPF.Text;
cpfAuxinput = cpfAuxinput.Trim();
cpfAuxinput = cpfAuxinput.Replace(
".", "").Replace("-", "");
//Cria um objeto do tipo comando passando como parametro o comando sql e a string de conexão
SqlCommand cmd = new SqlCommand("usp_pescador_insert", connteste);
cmd.CommandType =
CommandType.StoredProcedure;
cmd.Parameters.AddRange(
new SqlParameter[] {
new SqlParameter("@pes_id",SqlDbType.Int),
new SqlParameter("@nome",SqlDbType.VarChar),
new SqlParameter("@rg",SqlDbType.VarChar),
new SqlParameter("SSP",SqlDbType.VarChar),
new SqlParameter("@cpf",SqlDbType.VarChar),
new SqlParameter("@apelido",SqlDbType.VarChar),
new SqlParameter("@dtnasc",SqlDbType.DateTime),
new SqlParameter("@tel",SqlDbType.VarChar),
new SqlParameter("@cel",SqlDbType.VarChar),
new SqlParameter("@endereco",SqlDbType.VarChar),
new SqlParameter("@bairro",SqlDbType.VarChar),
new SqlParameter("@cep",SqlDbType.VarChar),
new SqlParameter("@sexo",SqlDbType.VarChar),
new SqlParameter("@num",SqlDbType.NVarChar),
new SqlParameter("@compl",SqlDbType.VarChar),
new SqlParameter("@munic",SqlDbType.VarChar),
new SqlParameter("@col_id",SqlDbType.Int),
new SqlParameter("@res_cod",SqlDbType.Int),
new SqlParameter("@categoria",SqlDbType.VarChar),
new SqlParameter("@dtcad",SqlDbType.DateTime),
new SqlParameter("@dtvalidade",SqlDbType.DateTime),
new SqlParameter("@situacao",SqlDbType.VarChar),
new SqlParameter("@viacarteira",SqlDbType.Int)
});
cmd.Parameters[0].Direction =
ParameterDirection.InputOutput;
cmd.Parameters[0].Value =
this.id;
cmd.Parameters[1].Value =
this.TextBoxNome.Text;
cmd.Parameters[2].Value =
this.TextBoxRG.Text;
cmd.Parameters[3].Value =
this.TextBoxSSP.Text;
cmd.Parameters[4].Value = cpfAuxinput;
cmd.Parameters[5].Value =
this.TextBoxApelido.Text;
cmd.Parameters[6].Value =
Convert.ToDateTime(this.TextBoxNasc.Text);
cmd.Parameters[7].Value =
this.TextBoxTel.Text;
cmd.Parameters[8].Value =
this.TextBoxcelular.Text;
cmd.Parameters[9].Value =
this.TextBoxEndereco.Text;
cmd.Parameters[10].Value =
this.TextBoxbairro.Text;
cmd.Parameters[11].Value =
this.TextBoxCEP.Text;
cmd.Parameters[12].Value =
this.RadioButtonListsexo.SelectedValue;
cmd.Parameters[13].Value =
this.TextBoxnum.Text;
cmd.Parameters[14].Value =
this.TextBoxComplemento.Text;
cmd.Parameters[15].Value =
this.TextBoxMunicipio.Text;
cmd.Parameters[16].Value =
this.DropDownListColonias.SelectedValue;
cmd.Parameters[17].Value =
this.DropDownListAcudes.SelectedValue;
cmd.Parameters[18].Value =
this.RadioButtonListCategoria.SelectedValue;
cmd.Parameters[19].Value =
Convert.ToDateTime(this.TextBoxDtCadastro.Text);
cmd.Parameters[20].Value =
Convert.ToDateTime(this.TextBoxValidade.Text);
cmd.Parameters[21].Value =
this.RadioButtonListSituacao.SelectedValue;
cmd.Parameters[22].Value = 1;
try
{
//abre a conexao
connteste.Open();
//executa o comando com os parametros que foram adicionados acima
i = cmd.ExecuteNonQuery();
//fecha a conexao
connteste.Close();
}
catch (SqlException ex) { this.showMessage(ex.Message); }
catch (Exception ex) { this.showMessage(ex.Message); }
}
//Limpar WebForm
clearFields();
}
