示例#1
0
        private void populateReservations()
        {
            Stack <Reservation> reservations = DbAdapter.getReservations();

            this.reservationsTable = new DataTable();
            reservationsTable.Columns.Add(new DataColumn("Numer Rezerwacji"));
            reservationsTable.Columns.Add(new DataColumn("Numer sali"));
            reservationsTable.Columns.Add(new DataColumn("Oddział"));
            reservationsTable.Columns.Add(new DataColumn("Budynek"));
            reservationsTable.Columns.Add(new DataColumn("Id pacjenta"));
            reservationsTable.Columns.Add(new DataColumn("Imie pacjenta"));
            reservationsTable.Columns.Add(new DataColumn("Nazwisko pacjenta"));
            reservationsTable.Columns.Add(new DataColumn("Choroba"));
            reservationsTable.Columns.Add(new DataColumn("Data od"));
            reservationsTable.Columns.Add(new DataColumn("Data do"));



            foreach (var reservation in reservations)
            {
                reservationsTable.Rows.Add(
                    reservation.reservation_id,
                    reservation.room_number,
                    reservation.department,
                    reservation.building,
                    reservation.sick_id,
                    reservation.name,
                    reservation.surname,
                    reservation.illness,
                    reservation.date_from.Replace(" 00:00:00", ""),
                    reservation.date_to.Replace(" 00:00:00", "")
                    );;
            }

            dataGridViewAllPatientRoomReservations.DataSource          = this.reservationsTable;
            dataGridViewAllPatientRoomReservations.ReadOnly            = true;
            dataGridViewAllPatientRoomReservations.AutoGenerateColumns = true;
            dataGridViewAllPatientRoomReservations.AutoResizeColumns();
            dataGridViewAllPatientRoomReservations.Refresh();
        }