private void generarToolStripMenuItem_Click(object sender, EventArgs e)
{
Form f = new Generar_Modificar_Reserva.AltaReserva(this);
f.Show();
this.Hide();
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text != "")
{
string ConnStr = ConfigurationManager.AppSettings["stringConexion"];
SqlConnection conn = new SqlConnection(ConnStr);
string sSel = string.Format(@"SELECT * FROM [GD2C2014].[CONTROL_ZETA].[RESERVA] res,
[GD2C2014].[CONTROL_ZETA].[HOTEL] hotel,
[GD2C2014].[CONTROL_ZETA].[REGIMEN] reg,
[GD2C2014].[CONTROL_ZETA].[LOCALIDAD] loc
where res.RESERVA_ID = '{0}'
and res.RESERVA_ID_HOTEL = hotel.HOTEL_ID
and res.RESERVA_ID_REGIMEN = reg.REG_ID
and loc.LOC_ID = hotel.HOTEL_ID_LOC", textBox1.Text);
SqlCommand cmd = new SqlCommand(sSel, conn);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
if (reader["RES_PRECIO_TOTAL"].ToString() == "")
{
SqlConnection con = new SqlConnection(ConnStr);
con.Open();
SqlCommand scCommand = new SqlCommand("CONTROL_ZETA.SP_ACT_PRECIO_RES", con);
scCommand.CommandType = CommandType.StoredProcedure;
scCommand.Parameters.Add("@id_reserva", SqlDbType.Int).Value = int.Parse(textBox1.Text);
if (scCommand.Connection.State == ConnectionState.Closed)
{
scCommand.Connection.Open();
}
scCommand.ExecuteNonQuery();
con.Close();
}
AltaReserva f = new AltaReserva(this, reader, conn);
f.Show();
if (!f.tieneError())
{
this.Hide();
}
}
else
{
MessageBox.Show("No existe la reserva especificada", "Error de ingreso de datos", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}