public void TablesUpload(string name)
{
switch (name)
{
case "client":
ConectionDB.Connection(@"SELECT clients_id, surname as ""Фамилия"", first_name as ""Имя"", last_name as ""Отчество"", identify as ""Документ"", email as ""E-mail"", phone as ""Телефон"" from clients", dgv);
dgv.Columns[0].Visible = false;
break;
case "rooms":
ConectionDB.Connection(@"select hotel_room.room_id, hotel_room.number_of_room as ""Номер комнаты"", type_of_number.type as ""Тип номера"", hotel_room.amount_of_sleeppoint as ""Количество спальных мест"", hotel_room.floor_of_room as ""Этаж"", hotel_room.state as ""Статус"", type_of_bed.name_type as ""Спальное место"" from hotel_room, type_of_number, type_of_bed where type_of_number.type_id = hotel_room.type_id and type_of_bed.type_id = hotel_room.type_of_bed_id", dgv);
dgv.Columns[0].Visible = false;
dgv.Columns[5].Visible = false;
break;
case "services":
ConectionDB.Connection("Select service_id, service_name as Услуга, price_of_service as Цена from services", dgvList);
dgvList.Columns[0].Visible = false;
break;
case "type":
ConectionDB.Connection("Select type_id, type_of_number.type as Тип, price as Стоимость from type_of_number", dgv);
dgv.Columns[0].Visible = false;
break;
case "bills":
ConectionDB.Connection("Select * final_bill", dgv);
dgv.Columns[0].Visible = false;
break;
default:
break;
}
}
private void btShowBills_Click(object sender, EventArgs e)
{
dgvControl1.Controls["btNew"].Visible = false;
dgvControl1.Controls["btEdit"].Visible = true;
dgvControl1.Show();
dgvControl1.BringToFront();
mainLabel.Text = "Квитанции";
ConectionDB.Connection(@"SELECT final_bill.final_bill_id, clients.surname as ""Клиент"", hotel_room.number_of_room as ""Номер гостиницы"", final_bill.number_of_days as ""Количество дней"", final_bill.final_summa as ""Стоимость"" FROM final_bill, clients, hotel_room where final_bill.clients_id = clients.clients_id and final_bill.room_id = hotel_room.room_id", dgv);
dgv.Columns[0].Visible = false;
dgvControl1.selectedId = 0;
}
private void btShowRequests_Click(object sender, EventArgs e)
{
dgvControl1.Controls["btEdit"].Visible = false;
dgvControl1.Show();
dgvControl1.BringToFront();
dgvControl1.Controls["btNew"].Visible = false;
mainLabel.Text = "Текущие заявки";
ConectionDB.Connection(@"select card_of_registration.card_id, clients.surname as ""Клиент"", hotel_room.number_of_room as ""Номер комнаты"", card_of_registration.data_set as ""Заселение"", card_of_registration.data_out as ""Выселение"", type_of_pay.name_type as ""Тип оплаты"" from card_of_registration, clients, hotel_room, type_of_pay where card_of_registration.clients_id = clients.clients_id and card_of_registration.room_id = hotel_room.room_id and card_of_registration.type_pay_id = type_of_pay.type_id", dgv);
dgvControl1.selectedId = 0;
dgv.Columns[0].Visible = false;
}