private void CancelBookingButton_Click(object sender, EventArgs e)
{
if (InfoDataGrid.SelectedRows.Count > 0)
{
if (Convert.ToDateTime(dates.Rows[InfoDataGrid.SelectedRows.Count - 1][2].ToString()) >= DateTime.Now.Date.AddDays(7))
{
connection = new SqlConnection(connectionString);
try
{
connection.Open();
dataAdapter = new SqlDataAdapter($"select Contracts.ID_contract, ID_room from Contracts inner join Organiations on [User_ID] = '{ID}' inner join " +
$" Hostel_number on Hostel_number.Contract_ID = ID_contract where ID_contract = Organiations.Contract_ID", connection);
DataSet Info = new DataSet();
dataAdapter.Fill(Info);
int rows = 0;
for (int index = 0; index < Info.Tables[0].Rows.Count; index++)
{
cmd = new SqlCommand($"update Hostel_number set Employment = 0, Booking_ID = null, Contract_ID = null, Condition_drinks = 0, Condition_food = 0, Condition_without = 1, Condition_Aid =0, Condition_Cleaning = 0 where ID_room = '{Info.Tables[0].Rows[InfoDataGrid.SelectedRows.Count - 1 + rows][1]}'", connection);
cmd.ExecuteNonQuery();
rows++;
}
cmd = new SqlCommand($"update Organiations set Contract_ID = null where User_ID = '{ID}' and Contract_ID = '{Info.Tables[0].Rows[InfoDataGrid.SelectedRows.Count - 1][0]}'", connection);
cmd.ExecuteNonQuery();
cmd = new SqlCommand($"delete from Contracts where ID_contract = '{Info.Tables[0].Rows[InfoDataGrid.SelectedRows.Count - 1][0]}'", connection);
cmd.ExecuteNonQuery();
InfoDataGrid.DataSource = null;
dataAdapter = new SqlDataAdapter($"select [ID_contract] as 'Номер договра', Time_CheckIn as 'Время заселения', Time_eviction as 'Время выселения', Quantity_peopole as 'Количество людей', Busy_rooms as 'Количество занятых номеров' from Contracts inner join Organiations on [User_ID] = '{ID}' where [Contracts].ID_contract = [Organiations].Contract_ID", connection);
DataSet Infogrid = new DataSet();
dataAdapter.Fill(Infogrid);
if (Infogrid.Tables[0].Rows.Count > 0)
{
InfoDataGrid.DataSource = Infogrid.Tables[0];
InfoDataGrid.Refresh();
}
MessageBox.Show("Бронь была отменена!");
}
catch (Exception ex)
{
MessageBox.Show("Ошибка");
}
finally
{
connection.Close();
}
}
else
{
MessageBox.Show("До даты заселения меньше 7 дней, отмена брони невозможна");
}
}
}
private void CancelBookingButton_Click(object sender, EventArgs e)
{
if (InfoDataGrid.SelectedRows.Count >= 0)
{
if (Convert.ToDateTime(dates.Rows[InfoDataGrid.SelectedRows.Count - 1][2].ToString()) >= DateTime.Now.Date.AddDays(7))
{
connection = new SqlConnection(connectionString);
try
{
connection.Open();
dataAdapter = new SqlDataAdapter($"select Reservations.ID_Booking, ID_room from Reservations inner join Tenant on [User_ID] = '{ID}' inner join Hostel_number on Hostel_number.Booking_ID = Tenant.Booking_ID where ID_Booking = Tenant.Booking_ID", connection);
DataSet Info = new DataSet();
dataAdapter.Fill(Info);
cmd = new SqlCommand($"update Hostel_number set Employment = 0, Booking_ID = null, Contract_ID = null, Condition_drinks = 0, Condition_food = 0, Condition_without = 1, Condition_Aid =0, Condition_Cleaning = 0 where ID_room = '{Info.Tables[0].Rows[InfoDataGrid.SelectedRows.Count - 1][1]}'", connection);
cmd.ExecuteNonQuery();
cmd = new SqlCommand($"delete from Tenant where [Booking_ID] = '{Info.Tables[0].Rows[InfoDataGrid.SelectedRows.Count - 1][0]}'", connection);
cmd.ExecuteNonQuery();
cmd = new SqlCommand($"delete from Reservations where ID_Booking = '{Info.Tables[0].Rows[InfoDataGrid.SelectedRows.Count - 1][0]}'", connection);
cmd.ExecuteNonQuery();
InfoDataGrid.DataSource = null;
dataAdapter = new SqlDataAdapter($"select [Class_hotel] as 'Класс отеля', All_quantity_people as 'Количество людей', Time_Check_In as 'Время заселения', Time_Eviction as 'Время выселения' from Reservations inner join Tenant on [User_ID] = '{ID}' where ID_Booking = Booking_ID", connection);
DataSet Infogrid = new DataSet();
dataAdapter.Fill(Infogrid);
InfoDataGrid.DataSource = Infogrid.Tables[0];
InfoDataGrid.Refresh();
MessageBox.Show("Бронь была отменена!");
}
catch (Exception ex)
{
MessageBox.Show("Ошибка");
}
finally
{
connection.Close();
}
}
else
{
MessageBox.Show("До даты заселения меньше 7 дней, отмена брони невозможна");
}
}
}