private void RoomsStateUC_Load(object sender, EventArgs e) { try { dataGridViewClosedRooms.DataSource = hotelDbDataSet.apartament; HotelDbDataSet.apartamentDataTable openTable = new HotelDbDataSet.apartamentDataTable(); dataGridViewOpened.DataSource = openTable; HotelDbDataSet.apartamentDataTable apartaments = apartamentTableAdapter.GetData(); foreach (HotelDbDataSet.apartamentRow row in apartaments.Rows) { bool?state = lockHistoryTableAdapter1.ApartamentState((int)row[0]); if (state.HasValue) { if (state.Value) { hotelDbDataSet.apartament.ImportRow(row); } else { openTable.ImportRow(row); } } } } catch (Exception ex) { } }
private void ButtonSearch_Click(object sender, EventArgs e) { try { HotelDbDataSet.apartamentDataTable allfreerooms = apartamentTableAdapter.GetDataByFreeRooms( dateFrom.Value, dateTo.Value, dateFrom.Value, dateTo.Value, dateFrom.Value, dateTo.Value); var query = from o in allfreerooms where o.class_id == comboBoxClass.Text select o; DataView res = query.AsDataView(); dataGridViewFreeApart.DataSource = res; dataGridViewFreeApart.Columns["class_id"].Visible = false; dataGridViewFreeApart.Columns[0].HeaderCell.Value = "Room"; dataGridViewFreeApart.RowHeadersVisible = false; } catch (Exception ex) { MessageBox.Show(ex.Message); } }