public static void UnassignRoom(int roomNumber, string patientName) { PatientTableAdapter taPatient = new PatientTableAdapter(); int patient_id = (int)taPatient.GetPatientID(patientName); RoomTableAdapter taRoom = new RoomTableAdapter(); taRoom.UpdateRoomStatus("available", roomNumber); int room_id = (int)taRoom.GetRoomID(roomNumber); Patient_RoomTableAdapter taPatientRow = new Patient_RoomTableAdapter(); taPatientRow.UnassignRoom(patient_id, room_id); }
public static void AssignRoom(int roomNumber, string patientName) { PatientTableAdapter taPatient = new PatientTableAdapter(); int patient_id = (int)taPatient.GetPatientID(patientName); RoomTableAdapter taRoom = new RoomTableAdapter(); taRoom.UpdateRoomStatus("occupied", roomNumber); int room_id = (int)taRoom.GetRoomID(roomNumber); Patient_RoomTableAdapter taPatientRoom = new Patient_RoomTableAdapter(); taPatientRoom.InsertRoomByPidScopeID(patient_id, room_id); }