private void btnAltaRecorrido_Click(object sender, EventArgs e)
{
if (CodigoRecorrido.Text == "")
{
MessageBox.Show("Debe ingresar los valores obligatorios");
}
else
{
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["GD_CRUCEROS"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("LOS_QUE_VAN_A_APROBAR.CrearRecorrido", cn))
{
try
{
cn.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@CodigoRecorrido", SqlDbType.Decimal).Value = Decimal.Parse(CodigoRecorrido.Text);
cmd.Parameters["@CodigoRecorrido"].Precision = 18;
cmd.Parameters["@CodigoRecorrido"].Scale = 2;
cmd.Parameters.Add("@Descripcion", SqlDbType.VarChar, 50).Value = DescripcionRecorrido.Text;
cmd.ExecuteNonQuery();
MessageBox.Show("Nuevo recorrido satisfactorio");
cn.Close();
cn.Dispose();
AgregarTramo form = new AgregarTramo();
form.StartPosition = FormStartPosition.CenterScreen;
form.Show();
this.Dispose();
}
catch (FormatException)
{
MessageBox.Show("El codigo de recorrido debe ser numeros enteros positivos");
}
}
}
}
}
private void button4_Click(object sender, EventArgs e)
{
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["GD_CRUCEROS"].ConnectionString);
cn.Open();
SqlCommand sc = new SqlCommand("select top 1 Puerto_Llegada from LOS_QUE_VAN_A_APROBAR.RecorridoPorTramo join LOS_QUE_VAN_A_APROBAR.Tramo on (IdTramo = CodigoTramo) where CodigoRecorrido = @IdRecorrido order by orden desc ", cn);
sc.CommandType = CommandType.Text;
sc.Parameters.AddWithValue("@IdRecorrido", Convert.ToInt32(comboBoxModifReco.SelectedValue.ToString()));
string PuertoS = sc.ExecuteScalar().ToString();
cn.Close();
AgregarTramo fo = new AgregarTramo(Convert.ToInt32(comboBoxModifReco.SelectedValue.ToString()), PuertoS);
fo.StartPosition = FormStartPosition.CenterScreen;
fo.Show();
}