public List <HospitalBed> ReadEmptyBedsInRoom(HospitalBed roomId)
{
var query = string.Format("SELECT * FROM HospitalBedRepository WHERE Campus='{0}' AND FloorNo='{1}' AND Wing='{2}' AND Room='{3}' AND PatientId IS NULL",
roomId.Campus, roomId.Floor, roomId.Wing, roomId.RoomNumber);
return(bedReader.FetchBedNumbers(conString, query));
}
public async Task PutPatient(Patient patient, [AllowNull, MaybeNull] HospitalBed bed = null)
{
var parameters = new DialogParameters();
parameters.Add("patient", patient);
parameters.Add("units", State.Value.AvailableUnits);
parameters.Add("preSelectedBed", bed);
var dialog = Dialog.Show <PainelDialogs.PutPatientOnBed>("Put Patient", parameters, new DialogOptions()
{
MaxWidth = MaxWidth.Medium, FullWidth = true
});
var result = await dialog.Result;
if (!result.Cancelled)
{
var data = ((Guid PatientId, int CareUnitId, int HospitalBedId))result.Data;
var ok = await PatientService.PutPatientOnBed(data.PatientId, data.HospitalBedId, data.CareUnitId);
if (!ok)
{
Snackbar.Add($"Could not put {patient?.Name} on bed {bed?.HospitalBedId}", Severity.Error);
}
}
}
private void buttonReturnBed_Click(object sender, EventArgs e)
{
if (dataViewBed.SelectedRows.Count > 0)
{
int bedID = Convert.ToInt16(dataViewBed.SelectedRows[0].Cells[0].Value);
int state = Convert.ToInt16(dataViewBed.SelectedRows[0].Cells[2].Value);
if (state == 1)
{
DialogResult dialogResult = MessageBox.Show("Xác nhận trả giường", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dialogResult == DialogResult.Yes)
{
HospitalBed updateHB = HospitalBed.GetHospitalBed(bedID);
updateHB.Patient = 0;
updateHB.State = 0;
if (HospitalBed.UpdateHospitalBed(updateHB) > 0)
{
MessageBox.Show("Trả giường thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
else
{
MessageBox.Show("Giường bệnh trống", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
refreshDataViewBed();
}
}
protected async Task DischargePatient(HospitalBed bed)
{
var parameters = new DialogParameters();
var patient = bed.Patient;
parameters.Add("patient", patient);
parameters.Add("units", State.Value.AvailableUnits);
parameters.Add("preSelectedBed", bed);
var dialog = Dialog.Show <PainelDialogs.DischargePatient>($"Discharge Patient: {patient.Name}", parameters, new DialogOptions()
{
MaxWidth = MaxWidth.Medium, FullWidth = true
});
var result = await dialog.Result;
if (!result.Cancelled)
{
var data = ((Guid PatientId, int CareUnitId, int HospitalBedId))result.Data;
var ok = await PatientService.DischargePatientFromBed(
patientId : data.PatientId,
hospitalBedId : data.HospitalBedId,
careUnitId : data.CareUnitId);
if (!ok)
{
Snackbar.Add($"Could not discharge {patient?.Name} on bed {bed?.HospitalBedId}", Severity.Error);
}
}
}
public void Given_Valid_Arguments_When_Update_Invoked_Then_True_Asserted()
{
HospitalBedRegistration();
PatientRegistration();
HospitalBed beds = new HospitalBed
{
BedNumber = 10,
Campus = "PIC",
Floor = "2F",
RoomNumber = "201",
Wing = "2A",
Occupancy = "111"
};
string json = JsonConvert.SerializeObject(beds);
json = "{\"bed\":" + json + "}";
client.Headers[HttpRequestHeader.ContentType] = "application/json";
var response = client.UploadString(url + "UpdateBed", "PUT", json);
Assert.AreEqual("{}", response);
json = CreateHospitalBed();
client.Headers[HttpRequestHeader.ContentType] = "application/json";
response = client.UploadString(url + "UpdateBed", "PUT", json);
DeleteHospitalBeds();
var patientId = "{\"patientId\":\"111\"}";
client.Headers[HttpRequestHeader.ContentType] = "application/json";
client.UploadString("http://localhost:51625/PatientRegistrationService.svc/PatientRegistrationService/" + "DeletePatient", "DELETE", patientId);
}
public void Given_Invalid_Critical_Alert_Bed_Subscription_When_AlertUsers_Invoked_Then_Invalid_Result_Asserted()
{
Callbacks callbacks = new Callbacks();
HospitalBed bed = new HospitalBed
{
BedNumber = 10, Campus = "PIC", Floor = "2", Occupancy = "Pat111", Wing = "2A", RoomNumber = "12"
};
AlertMonitorList subList = AlertMonitorList.Instance;
subList.Subscribe(bed.ToString(), callbacks.CallbackFunc);
PatientAlert alerts = new PatientAlert
{
CriticalAlerts = new List <DeviceAlert>(),
MuteAlert = false,
PatientId = "Pat111",
WarningAlerts = new List <DeviceAlert>()
};
alerts.CriticalAlerts.Add(new DeviceAlert
{
DeviceId = "Dev111",
Message = "Critical",
Value = 56
});
alertManager.AlertUsers(alerts);
Assert.AreNotEqual("TestPassed", alerts.PatientId);
subList.Unsubscribe(bed.ToString());
}
public List <HospitalBed> ReadEmptyBedsInFloor(HospitalBed floorId)
{
var query = string.Format("SELECT * FROM HospitalBedRepository WHERE Campus='{0}' AND FloorNo='{1}' AND PatientId IS NULL",
floorId.Campus, floorId.Floor);
return(bedReader.FetchBedNumbers(conString, query));
}
//Refresh datagridview in hospital bed tab
private void refreshDataViewBed()
{
try
{
// Get hospital bed's datatable
DataTable bedTable = HospitalBed.GetListHospitalBed();
// Add Vietnamese column's name
bedTable.Columns.Add("Mã giường bệnh", typeof(string), "[BEDID]");
bedTable.Columns.Add("Mã bệnh nhân", typeof(string), "[PATIENT]");
bedTable.Columns.Add("Trạng thái", typeof(string), "IIF([STATE] = 0, 'Trống', 'Có người')");
// Set data source to dataview for searching
dataViewBed.DataSource = bedTable.DefaultView;
// Hide English columns'name
for (int i = 0; i < 3; i++)
{
dataViewBed.Columns[i].Visible = false;
}
}
catch
{
MessageBox.Show("Lỗi dữ liệu", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public List <HospitalBed> ReadOccupiedBedsInWing(HospitalBed wingId)
{
var query = string.Format("SELECT * FROM HospitalBedRepository WHERE Campus='{0}' AND FloorNo='{1}' AND Wing='{2}' AND PatientId IS NOT NULL",
wingId.Campus, wingId.Floor, wingId.Wing);
return(bedReader.FetchBedNumbers(conString, query));
}
public bool Exists(HospitalBed bed)
{
var query =
$"SELECT * FROM HospitalBedRepository WHERE Campus='{bed.Campus}' AND FloorNo='{bed.Floor}' AND Wing='{bed.Wing}' AND Room='{bed.RoomNumber}'";
var beds = bedReader.FetchBedNumbers(conString, query);
return(beds.Any());
}
private static void ParseCampusFloor(string[] bedInfo, ref HospitalBed hospitalBed)
{
if (bedInfo.Any())
{
hospitalBed.Campus = bedInfo[0];
}
if (bedInfo.Count() > 1)
{
hospitalBed.Floor = bedInfo[1];
}
}
private static void ParseWingRoom(string[] bedInfo, ref HospitalBed hospitalBed)
{
if (bedInfo.Count() > 2)
{
hospitalBed.Wing = bedInfo[2];
}
if (bedInfo.Count() > 3)
{
hospitalBed.RoomNumber = bedInfo[3];
}
}
public List <HospitalBed> ReadEmptyBedsInCampus(HospitalBed campusId)
{
List <HospitalBed> beds = new List <HospitalBed>();
campusId.Floor = "1F";
campusId.Wing = "1A";
campusId.RoomNumber = "11";
campusId.BedNumber = 1;
beds.Add(campusId);
return(beds);
}
public HospitalBed Read(HospitalBed bed)
{
var query = string.Format("SELECT * FROM HospitalBedRepository WHERE Campus='{0}' AND FloorNo='{1}' AND Wing='{2}' AND Room='{3}' AND BedNo='{4}'", bed.Campus, bed.Floor, bed.Wing, bed.RoomNumber, bed.BedNumber);
var beds = bedReader.FetchBedNumbers(conString, query);
if (beds.Any())
{
return(beds.First());
}
return(new HospitalBed());
}
private HospitalBed CreateBed()
{
HospitalBed bed = new HospitalBed
{
BedNumber = 10,
Campus = "PIC",
Floor = "2",
RoomNumber = "12",
Wing = "2A"
};
return(bed);
}
public bool Delete(HospitalBed bed)
{
var emptyBeds = ReadEmptyBedsInRoom(bed);
if (emptyBeds.Count >= bed.BedNumber)
{
var query = string.Format(
"DELETE TOP({0}) FROM HospitalBedRepository WHERE Campus='{1}' AND FloorNo='{2}' AND Wing='{3}' AND Room='{4}' AND PatientId is NULL ", bed.BedNumber, bed.Campus, bed.Floor, bed.Wing, bed.RoomNumber);
return(SqlCommands.ExecuteCommand(query, conString));
}
return(false);
}
private void buttonBedAdd_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("Xác nhận thêm giường", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dialogResult == DialogResult.Yes)
{
if (HospitalBed.InsertHospitalBed() > 0)
{
MessageBox.Show("Thêm giường bệnh thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.None);
}
}
refreshDataViewBed();
}
private void SetHospitalBedDetail(HospitalBed hbDetail)
{
textBoxHospitalBedID.Text = hbDetail.BedID.ToString();
textBoxPatientID.Text = hbDetail.Patient.ToString();
if (hbDetail.State == 0)
{
comboBoxState.SelectedIndex = 0;
}
else
{
comboBoxState.SelectedIndex = 1;
}
}
public List <HospitalBed> ReadEmptyBedsInRoom(HospitalBed roomId)
{
List <HospitalBed> beds = new List <HospitalBed>();
roomId.BedNumber = 1;
beds.Add(roomId);
roomId.BedNumber = 2;
beds.Add(roomId);
roomId.BedNumber = 3;
beds.Add(roomId);
roomId.BedNumber = 4;
beds.Add(roomId);
return(beds);
}
public bool Update(HospitalBed bed)
{
string query;
if (bed.Occupancy.Any())
{
query = string.Format("UPDATE HospitalBedRepository SET PatientId='{0}' WHERE Campus='{1}' AND FloorNo='{2}' AND Wing='{3}' AND Room='{4}' AND BedNo='{5}'", bed.Occupancy, bed.Campus, bed.Floor, bed.Wing, bed.RoomNumber, bed.BedNumber);
}
else
{
query = string.Format("UPDATE HospitalBedRepository SET PatientId=NULL WHERE Campus='{0}' AND FloorNo='{1}' AND Wing='{2}' AND Room='{3}' AND BedNo='{4}'", bed.Campus, bed.Floor, bed.Wing, bed.RoomNumber, bed.BedNumber);
}
return(SqlCommands.ExecuteCommand(query, conString));
}
public List <HospitalBed> ReadEmptyBedsInFloor(HospitalBed floorId)
{
List <HospitalBed> beds = new List <HospitalBed>();
floorId.Wing = "1A";
floorId.RoomNumber = "11";
floorId.BedNumber = 1;
beds.Add(floorId);
floorId.Wing = "2A";
floorId.RoomNumber = "22";
floorId.BedNumber = 2;
beds.Add(floorId);
return(beds);
}
private void InitializeBed(ref List <HospitalBed> bedList, HospitalBed bed)
{
if (!bedList.Any())
{
bedList.Add(new HospitalBed
{
BedNumber = 0,
Campus = bed.Campus,
Floor = bed.Floor,
Occupancy = bed.Occupancy,
RoomNumber = bed.RoomNumber,
Wing = bed.Wing
});
}
}
public List <HospitalBed> ReadEmptyBedsInWing(HospitalBed wingId)
{
List <HospitalBed> beds = new List <HospitalBed>();
wingId.RoomNumber = "11";
wingId.BedNumber = 1;
beds.Add(wingId);
wingId.RoomNumber = "22";
wingId.BedNumber = 2;
beds.Add(wingId);
wingId.RoomNumber = "33";
wingId.BedNumber = 3;
beds.Add(wingId);
return(beds);
}
public List <HospitalBed> ReadOccupiedBedsInFloor(HospitalBed floorId)
{
List <HospitalBed> beds = new List <HospitalBed>();
floorId.Wing = "1A";
floorId.RoomNumber = "11";
floorId.BedNumber = 1;
floorId.Occupancy = "111";
beds.Add(floorId);
floorId.Wing = "2A";
floorId.RoomNumber = "22";
floorId.BedNumber = 2;
floorId.Occupancy = "222";
beds.Add(floorId);
return(beds);
}
private static void HospitalBedRegistration()
{
string url = "http://localhost:51449/HospitalBedRegistrationService.svc/HospitalBedRegistrationService/";
HospitalBed beds = new HospitalBed
{
BedNumber = 10,
Campus = "PIC",
Floor = "2F",
RoomNumber = "201",
Wing = "2A"
};
string json = JsonConvert.SerializeObject(beds);
json = "{\"beds\":" + json + "}";
client.Headers[HttpRequestHeader.ContentType] = "application/json";
var response = client.UploadString(url + "RegisterBeds", "POST", json);
}
private List <HospitalBed> ParseHospitalBeds(SqlDataReader reader)
{
List <HospitalBed> beds = new List <HospitalBed>();
while (reader.Read())
{
HospitalBed bed = new HospitalBed();
bed.Campus = reader["Campus"].ToString();
bed.Floor = reader["FloorNo"].ToString();
bed.Wing = reader["Wing"].ToString();
bed.RoomNumber = reader["Room"].ToString();
bed.BedNumber = Convert.ToInt32(reader["BedNo"]);
bed.Occupancy = reader["PatientId"].ToString();
beds.Add(bed);
}
return(beds);
}
public HospitalBed ParseHospitalBed(string bed)
{
HospitalBed hospitalBed = new HospitalBed();
char[] spearator = { '-', ' ' };
String[] bedInfo = bed.Split(spearator, StringSplitOptions.RemoveEmptyEntries);
ParseCampusFloor(bedInfo, ref hospitalBed);
ParseWingRoom(bedInfo, ref hospitalBed);
if (bedInfo.Count() > 4)
{
hospitalBed.BedNumber = Convert.ToInt32(bedInfo[4]);
}
return(hospitalBed);
}
private string CreateHospitalBeds()
{
//id=PIC-2F-2A-201-5
HospitalBed beds = new HospitalBed
{
BedNumber = 10,
Campus = "PIC",
Floor = "2F",
RoomNumber = "201",
Wing = "2A"
};
string json = JsonConvert.SerializeObject(beds);
json = "{\"beds\":" + json + "}";
return(json);
}
public List <HospitalBed> ReadOccupiedBedsInWing(HospitalBed wingId)
{
List <HospitalBed> beds = new List <HospitalBed>();
wingId.RoomNumber = "11";
wingId.BedNumber = 1;
wingId.Occupancy = "111";
beds.Add(wingId);
wingId.RoomNumber = "22";
wingId.BedNumber = 2;
wingId.Occupancy = "222";
beds.Add(wingId);
wingId.RoomNumber = "33";
wingId.BedNumber = 3;
wingId.Occupancy = "333";
beds.Add(wingId);
return(beds);
}
public List <HospitalBed> ReadOccupiedBedsInRoom(HospitalBed roomId)
{
List <HospitalBed> beds = new List <HospitalBed>();
roomId.BedNumber = 1;
roomId.Occupancy = "111";
beds.Add(roomId);
roomId.BedNumber = 2;
roomId.Occupancy = "222";
beds.Add(roomId);
roomId.BedNumber = 3;
roomId.Occupancy = "333";
beds.Add(roomId);
roomId.BedNumber = 4;
roomId.Occupancy = "444";
beds.Add(roomId);
return(beds);
}
