private void AddButton_Click(object sender, EventArgs e) { if (nameBox.Text == "" || genderBox.Text == "" || ageBox.Text == "" || addressBox.Text == "" || phoneBox.Text == "" || roomComboBox.Items.Count == 0 || doctorComboBox.Items.Count == 0 || testComboBox.Items.Count == 0) { MessageBox.Show("Please give all information"); return; } string name = nameBox.Text; string gender = genderBox.Text; string age = ageBox.Text; string address = addressBox.Text; string phone = phoneBox.Text; string roomNo = roomComboBox.SelectedItem.ToString(); string s = doctorComboBox.SelectedItem.ToString(); string[] values = s.Split(','); int doctorId = Convert.ToInt32(values[0]); s = testComboBox.SelectedItem.ToString(); values = s.Split(','); int testId = Convert.ToInt32(values[0]); string checkinDate = datePicker.Value.ToShortDateString(); patientDTO p = new patientDTO(name, gender, age, address, phone, roomNo, doctorId, testId, checkinDate); patientDAO pD = new patientDAO(); pD.createPatient(p); clearFields(); }
private void setComboBox() { roomComboBox.Items.Clear(); roomComboBox.Text = ""; doctorComboBox.Items.Clear(); doctorComboBox.Text = ""; testComboBox.Items.Clear(); testComboBox.Text = ""; roomDAO rD = new roomDAO(); DataSet ds = rD.getRooms(); LinkedList <string> listOfAllRooms = new LinkedList <string>(); foreach (DataRow row in ds.Tables[0].Rows) { string roomNo = row["roomNo"].ToString(); //roomComboBox.Items.Add(roomNo); listOfAllRooms.AddLast(roomNo); } patientDAO pD = new patientDAO(); ds = pD.getPatients(); LinkedList <string> listOfUsedRooms = new LinkedList <string>(); foreach (DataRow row in ds.Tables[0].Rows) { string roomNo = row["roomNo"].ToString(); //roomComboBox.Items.Add(roomNo); listOfUsedRooms.AddLast(roomNo); } LinkedList <string> listOfUnUsedRooms = new LinkedList <string>(); for (int i = 0; i < listOfAllRooms.Count; i++) { bool flag = true; for (int j = 0; j < listOfUsedRooms.Count; j++) { string allRoom = listOfAllRooms.ElementAt(i); string usedRoom = listOfUsedRooms.ElementAt(j); if (allRoom == usedRoom) { flag = false; break; } } if (flag) { listOfUnUsedRooms.AddLast(listOfAllRooms.ElementAt(i)); } } for (int i = 0; i < listOfUnUsedRooms.Count; i++) { string roomNo = listOfUnUsedRooms.ElementAt(i); roomComboBox.Items.Add(roomNo); } if (roomComboBox.Items.Count > 0) { roomComboBox.SelectedIndex = 0; } doctorDAO dD = new doctorDAO(); ds = dD.getDoctors(); foreach (DataRow row in ds.Tables[0].Rows) { int doctorId = Convert.ToInt32(row["doctorId"].ToString()); string name = row["name"].ToString(); doctorComboBox.Items.Add(doctorId + "," + name); } if (doctorComboBox.Items.Count > 0) { doctorComboBox.SelectedIndex = 0; } testDAO tD = new testDAO(); ds = tD.getTests(); foreach (DataRow row in ds.Tables[0].Rows) { int testId = Convert.ToInt32(row["testId"].ToString()); string name = row["name"].ToString(); string category = row["category"].ToString(); testComboBox.Items.Add(testId + "," + name + "," + category); } if (testComboBox.Items.Count > 0) { testComboBox.SelectedIndex = 0; } }