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);
}
