void guardarPersona()
{
try
{
string genero = string.Empty;
if (RadioSexoM.Checked)
{
genero = "Masculino";
}
else
{
genero = "Femenino";
}
string tipoPersona = string.Empty;
if (RadioButton1.Checked)
{
tipoPersona = "1";
}
else if (RadioButton2.Checked)
{
tipoPersona = "2";
}
else if (RadioButton3.Checked)
{
tipoPersona = "3";
}
using (SqlConnection sqlCon = new SqlConnection(connectionString))
{
sqlCon.Open();
string query = "INSERT INTO persona (tipo_persona_id,nombre,cedula,edad,sexo,telefono,direccion) VALUES (@tipo_persona_id,@nombre,@cedula,@edad,@sexo,@telefono,@direccion)";
SqlCommand sqlCmd = new SqlCommand(query, sqlCon);
sqlCmd.Parameters.AddWithValue("@tipo_persona_id", tipoPersona);
sqlCmd.Parameters.AddWithValue("@nombre", (TxtNombre.FindControl("TxtNombre") as TextBox).Text.Trim());
sqlCmd.Parameters.AddWithValue("@cedula", (TxtCedula.FindControl("TxtCedula") as TextBox).Text.Trim());
sqlCmd.Parameters.AddWithValue("@edad", (TxtEdad.FindControl("TxtEdad") as TextBox).Text.Trim());
sqlCmd.Parameters.AddWithValue("@sexo", genero);
sqlCmd.Parameters.AddWithValue("@telefono", (TxTtelefono.FindControl("TxTtelefono") as TextBox).Text.Trim());
sqlCmd.Parameters.AddWithValue("@direccion", (TxtDireccion.FindControl("TxtDireccion") as TextBox).Text.Trim());
sqlCmd.ExecuteNonQuery();
lblSuccessMessage.Text = "Registro Con Exito";
lblSuccessMessage.Visible = true;
lblErrorMessage.Text = "";
lblErrorMessage.Visible = true;
sqlCmd.Parameters.Clear();
}
}
catch (Exception ex)
{
lblSuccessMessage.Text = "";
lblErrorMessage.Text = ex.Message;
}
}