public static string GetRoomStatus(int roomNumber)
{
RoomTableAdapter taRoom = new RoomTableAdapter();
string status = taRoom.CheckRoomStatus(roomNumber);
return(status);
}
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);
}
public static bool RemoveRoom(int roomNumber)
{
RoomTableAdapter taRoom = new RoomTableAdapter();
string status = taRoom.CheckRoomStatus(roomNumber);
if (status != "occupied")
{
taRoom.RemoveRoom(roomNumber);
return(true);
}
else
{
return(false);
}
}
public static bool AddNewRoom(Room newRoom)
{
RoomTableAdapter taRoom = new RoomTableAdapter();
string status = taRoom.CheckRoomStatus(newRoom.Number);
if (status == "available" || status == "occupied")
{
return(false);
}
else
{
taRoom.InsertRoomData(newRoom.Number, newRoom.Type, "available");
return(true);
}
}
public static List <Room> GetAvailableRooms()
{
RoomTableAdapter taRoom = new RoomTableAdapter();
var dtRoom = taRoom.GetData();
List <Room> allRooms = new List <Room>();
foreach (dsUltimateMedDB.RoomRow roomRow in dtRoom)
{
if (roomRow.Status == "available")
{
Room currentRoom = new Room
{
Status = roomRow.Status,
Number = roomRow.Room_no,
Type = roomRow.RoomType
};
currentRoom.AvailableRooms.Add(currentRoom);
allRooms.Add(currentRoom);
}
}
return(allRooms);
}
private void HardwareForm_Load(object sender, EventArgs e)
{
try
{
roomAdapter = new RoomTableAdapter();
customerAdapter = new CustomerTableAdapter();
hardwareAdapter = new HardwareTableAdapter();
hardwareTypeAdapter = new HardwareTypeTableAdapter();
roomAdapter.Connection = cnSql;
customerAdapter.Connection = cnSql;
hardwareAdapter.Connection = cnSql;
hardwareTypeAdapter.Connection = cnSql;
roomDataTable = new DataSet.RoomDataTable();
customerDataTable = new DataSet.CustomerDataTable();
hardwareDataTable = new DataSet.HardwareDataTable();
hardwareTypeDataTable = new DataSet.HardwareTypeDataTable();
roomAdapter.Fill(roomDataTable);
customerAdapter.Fill(customerDataTable);
hardwareAdapter.Fill(hardwareDataTable);
hardwareTypeAdapter.Fill(hardwareTypeDataTable);
enableForm(false);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
populateHardwaresList();
populateRoomsList();
populateCustomersList();
populateRoomsList();
populateHardwareTypesList();
}
