private void populatePatients() { Stack <Patient> patients = DbAdapter.getPatients(); this.patientsTable = new DataTable(); patientsTable.Columns.Add(new DataColumn("Id")); patientsTable.Columns.Add(new DataColumn("Imie")); patientsTable.Columns.Add(new DataColumn("Nazwisko")); patientsTable.Columns.Add(new DataColumn("Choroba")); patientsTable.Columns.Add(new DataColumn("Czy zakaźna?")); foreach (var patient in patients) { patientsTable.Rows.Add( patient.id, patient.name, patient.surname, patient.illness, patient.infectious ); } dataGridViewPatients.DataSource = this.patientsTable; dataGridViewPatients.ReadOnly = true; dataGridViewPatients.AutoGenerateColumns = true; dataGridViewPatients.AutoResizeColumns(); dataGridViewPatients.Refresh(); }
private void buttonSave_Click(object sender, EventArgs e) { try { var newReservation = new Reservation( null, this.dataGridViewPatientRooms.SelectedRows[0].Cells[0].Value.ToString(), this.dataGridViewPatientRooms.SelectedRows[0].Cells[1].Value.ToString(), this.dataGridViewPatientRooms.SelectedRows[0].Cells[2].Value.ToString(), this.dataGridViewPatients.SelectedRows[0].Cells[0].Value.ToString(), this.dataGridViewPatients.SelectedRows[0].Cells[1].Value.ToString(), this.dataGridViewPatients.SelectedRows[0].Cells[2].Value.ToString(), this.dataGridViewPatients.SelectedRows[0].Cells[3].Value.ToString(), this.dateTimePickerCheckInDate.Value.ToString(), this.dateTimePickerCheckOutDate.Value.ToString()); DialogResult dialogResult = MessageBox.Show("Czy na pewno chcesz dodać rezerwację z następującymi danymi? \n \n" + newReservation.ToString(), "Dodawanie rezerwacji", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dialogResult == DialogResult.Yes) { DbAdapter.addReservation(newReservation); Navigator.navigateToChild(new PatientRoomReservations(), this); } else if (dialogResult == DialogResult.No) { // nothing } } catch (Exception exc) { MessageBox.Show(exc.Message, "Wystąpił błąd", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void ReservePatientRoom_Load(object sender, EventArgs e) { this.populatePatientRooms(); this.populatePatients(); var equipement = DbAdapter.getEquipement(); foreach (var eq in equipement) { this.checkedListBoxEquipment.Items.Add(eq); } this.populateAutoComplete(this.patientsTable, new List <TextBox>() { this.textBoxId, this.textBoxFirstName, this.textBoxSurname, this.textBoxIllness }); this.populateAutoComplete(this.roomsTable, new List <TextBox>() { this.textBoxRoomNr, this.textBoxDepartment }); this.populateRoomsOccupancy(); this.dateTimePickerCheckInDate.Value = System.DateTime.Now; this.dateTimePickerCheckOutDate.Value = DateTime.Now; this.dateTimePickerCheckInDate.MinDate = DateTime.Now; this.dateTimePickerCheckOutDate.MinDate = DateTime.Now; this.buttonSave.Enabled = false; this.Refresh(); }
private void populateRoomsOccupancy() { Stack <RoomOccupancyDTO> roomsOccupancy = DbAdapter.getPatientRoomsOccupancy( this.dateTimePickerCheckInDate.Value, this.dateTimePickerCheckOutDate.Value); this.roomsOccupancyTable = new DataTable(); this.roomsOccupancyTable.Columns.Add(new DataColumn("Numer sali")); this.roomsOccupancyTable.Columns.Add(new DataColumn("Oddział")); this.roomsOccupancyTable.Columns.Add(new DataColumn("Budynek")); this.roomsOccupancyTable.Columns.Add(new DataColumn("Rezerwacja od")); this.roomsOccupancyTable.Columns.Add(new DataColumn("Rezerwacja do")); foreach (var roomOccupancy in roomsOccupancy) { this.roomsOccupancyTable.Rows.Add( roomOccupancy.room_number, roomOccupancy.department, roomOccupancy.building, roomOccupancy.date_from, roomOccupancy.date_to ); } }
private void populatePatientRooms() { Stack <PatientRoom> rooms = DbAdapter.getPatientRooms(); this.roomsTable = new DataTable(); this.roomsTable.Columns.Add(new DataColumn("Numer sali")); this.roomsTable.Columns.Add(new DataColumn("Oddział")); this.roomsTable.Columns.Add(new DataColumn("Budynek")); this.roomsTable.Columns.Add(new DataColumn("Sprzęt")); foreach (var room in rooms) { roomsTable.Rows.Add( room.room_number, room.department, room.building, null ); } // Filter table with data dataGridViewPatientRooms.DataSource = this.roomsTable; dataGridViewPatientRooms.ReadOnly = true; dataGridViewPatientRooms.AutoGenerateColumns = true; dataGridViewPatientRooms.AutoResizeColumns(); dataGridViewPatientRooms.Refresh(); }
public ReserveIsolationRoom() { InitializeComponent(); var equipement = DbAdapter.getEquipement(); foreach (var eq in equipement) { this.checkedListBox1.Items.Add(eq); } }
public static int login(string login, string haslo) { try { currentUser = DbAdapter.getUser(login, haslo); Console.WriteLine(currentUser.name); if (currentUser == null) { // Nie znaleziono u¿ytkownika return(0); } Navigator.navigateRoot(); return(1); } catch (Exception) { return(-1); } }
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(); }
private void buttonDelete_Click(object sender, EventArgs e) { try { var index = dataGridViewAllPatientRoomReservations.SelectedRows[0].Cells[0].Value.ToString(); DialogResult dialogResult = MessageBox.Show("Czy na pewno chcesz usunąć zaznaczoną rezerwację?", "Usuwanie", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dialogResult == DialogResult.Yes) { DbAdapter.deleteReservation(index); } else if (dialogResult == DialogResult.No) { } } catch (Exception eee) { Console.WriteLine(eee); } populateReservations(); }