private void button1_Click(object sender, EventArgs e)
{
VistaHabitaciones form = new VistaHabitaciones();
form.Show();
this.Hide();
}
private void reservacionTermina(object sender, EventArgs e)
{
string i = (sender as Button).Text;
if (query("UPDATE habitacion SET estado = " + 1 + ", descripcion = 'Ocupado' WHERE id LIKE " + i + ";"))
{
var src = DateTime.Now;
int dias = 0;
double costo = 0;
string connStr = "server=localhost;user=root;database=dbHotel;port=3306;password="******"Connecting to MySQL...");
conn.Open();
string sql = "select datediff((SELECT fechaEntrada FROM reservacion WHERE fkIdHabitacion LIKE " + i + " AND fechaSalida IS NULL), NOW()) as resultado1, (SELECT costo FROM habitacion WHERE Id LIKE " + i + ")as resultado2;";
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
dias = rdr.GetInt32(rdr.GetOrdinal("resultado1"));
costo = rdr.GetDouble(rdr.GetOrdinal("resultado2"));
}
if (src.Hour >= 12 && src.Hour <= 24 || dias == 0)
{
dias++;
}
rdr.Close();
conn.Close();
Console.WriteLine("Done.");
if (query("UPDATE reservacion SET fechaSalida = NOW(), importe = " + (costo * dias) + " WHERE fkIdHabitacion LIKE " + i + " AND fechaSalida IS NULL;"))
{
VistaHabitaciones form = new VistaHabitaciones();
form.Show();
this.Hide();
MessageBox.Show("Sevicio a la habitacion " + this.Text + " terminado, importe: " + (costo * dias).ToString("G", CultureInfo.CreateSpecificCulture("eu-ES")));
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
conn.Close();
MessageBox.Show("Error 2 al terminar reservacion");
}
}
else
{
MessageBox.Show("Error 1 al terminar reservacion");
}
}
private void reservacionInicio(object sender, EventArgs e)
{
string i = (sender as Button).Text;
if (query("UPDATE habitacion SET estado = " + 0 + ", descripcion = 'Ocupado' WHERE id LIKE " + i + ";"))
{
if (query("INSERT INTO reservacion (fkIdHabitacion) VALUES (" + i + ");"))
{
VistaHabitaciones form = new VistaHabitaciones();
form.Show();
this.Hide();
}
else
{
MessageBox.Show("Error 2 al crear reservacion");
}
}
else
{
MessageBox.Show("Error 1 al crear reservacion");
}
}
