private void verConsumiblesBtn_Click(object sender, EventArgs e)
{
String consultarConsumibles = "SELECT * FROM AEFI.TL_Consumible co, AEFI.TL_Consumible_Por_Estadia cpe WHERE cpe.ID_Estadia = @idEstadia AND cpe.ID_Consumible = co.ID_Consumible ";
String consultarIdEstadia = "SELECT ID_Estadia FROM AEFI.TL_Estadia e, AEFI.TL_Reserva r, AEFI.TL_Habitacion h WHERE r.ID_Habitacion = h.ID_Habitacion AND e.ID_Reserva = r.ID_Reserva AND h.numero = @numero AND e.Estado = 1 AND h.ID_Hotel =" + Program.idHotel;
consumiblesCmbBox.Enabled = true;
cantidadTxtBox.Enabled = true;
facturarBtn.Enabled = true;
try
{
conexion.Open();
SqlCommand comando = new SqlCommand(consultarIdEstadia, conexion);
comando.Parameters.Add(new SqlParameter("@numero", habitacionTxtBox.Text));
SqlDataReader reader = comando.ExecuteReader();
reader.Read();
if (reader.HasRows)
{
idEstadia = Convert.ToInt32(reader[0]);
}
else
{
MessageBox.Show("La habitación no posee una estadía activa", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
conexion.Close();
this.Hide();
FrmRegistrarConsumible r = new FrmRegistrarConsumible();
r.ShowDialog();
this.Close();
}
reader.Close();
comando = new SqlCommand(consultarConsumibles, conexion);
comando.Parameters.Add(new SqlParameter("@idEstadia", idEstadia));
SqlDataAdapter adapter = new SqlDataAdapter(comando);
DataTable dataTable = new DataTable();
adapter.Fill(dataTable);
consumibleDGV.DataSource = dataTable;
}
catch (SqlException exc)
{
MessageBox.Show(exc.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
conexion.Close();
}
}
private void btnRegistrarConsumibles_Click(object sender, EventArgs e)
{
FrmRegistrarConsumible r = new FrmRegistrarConsumible();
this.Hide();
r.ShowDialog();
this.Close();
}
private void verConsumiblesBtn_Click(object sender, EventArgs e)
{
String consultarConsumibles = "SELECT * FROM AEFI.TL_Consumible co, AEFI.TL_Consumible_Por_Estadia cpe WHERE cpe.ID_Estadia = @idEstadia AND cpe.ID_Consumible = co.ID_Consumible ";
String consultarIdEstadia = "SELECT ID_Estadia FROM AEFI.TL_Estadia e, AEFI.TL_Reserva r, AEFI.TL_Habitacion h WHERE r.ID_Habitacion = h.ID_Habitacion AND e.ID_Reserva = r.ID_Reserva AND h.numero = @numero AND e.Estado = 1 AND h.ID_Hotel =" + Program.idHotel;
consumiblesCmbBox.Enabled = true;
cantidadTxtBox.Enabled = true;
facturarBtn.Enabled = true;
try
{
conexion.Open();
SqlCommand comando = new SqlCommand(consultarIdEstadia, conexion);
comando.Parameters.Add(new SqlParameter("@numero", habitacionTxtBox.Text));
SqlDataReader reader = comando.ExecuteReader();
reader.Read();
if (reader.HasRows)
{
idEstadia = Convert.ToInt32(reader[0]);
}
else
{
MessageBox.Show("La habitación no posee una estadía activa", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
conexion.Close();
this.Hide();
FrmRegistrarConsumible r = new FrmRegistrarConsumible();
r.ShowDialog();
this.Close();
}
reader.Close();
comando = new SqlCommand(consultarConsumibles, conexion);
comando.Parameters.Add(new SqlParameter("@idEstadia", idEstadia));
SqlDataAdapter adapter = new SqlDataAdapter(comando);
DataTable dataTable = new DataTable();
adapter.Fill(dataTable);
consumibleDGV.DataSource = dataTable;
}
catch (SqlException exc)
{
MessageBox.Show(exc.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
conexion.Close();
}
}
