private void trackAlarmTimer_Tick(object sender, EventArgs e)
{
DBConnector dBc = new DBConnector();
dBc.connect();
BedsideHandler bedsideHandler = new BedsideHandler();
int alarmStatus8 = bedsideHandler.SelectAlarmStatusBedside(dBc.getConn(), BedsideLoginScreen.bedsideIDPass);
int alarmZeroStatus8 = bedsideHandler.SelectAlarmZeroStatusBedside(dBc.getConn(), BedsideLoginScreen.bedsideIDPass);
if ((alarmStatus8 == 1) || (alarmZeroStatus8 == 1))
{
if (alarmZeroStatus8 == 1)
{
if (!backgroundWorkerAlarmZero.IsBusy)
{
backgroundWorkerAlarmZero.RunWorkerAsync();
backgroundWorkerBeep.CancelAsync();
backgroundWorkerAlarmReading.CancelAsync();
}
}
else
{
if (!backgroundWorkerAlarmReading.IsBusy)
{
backgroundWorkerAlarmReading.RunWorkerAsync();
backgroundWorkerBeep.CancelAsync();
}
}
}
else
{
backgroundWorkerAlarmZero.CancelAsync();
backgroundWorkerAlarmReading.CancelAsync();
}
}
//go to the bedside main screen when bedside id currently is assigned to the patient
private void continueExistingBtn_Click(object sender, EventArgs e)
{
if (bedsideIdExistingComboBox.SelectedIndex == 0)
{
MessageBox.Show("Please select valid bedsideId");
return;
}
BedsideHandler bedsideHandler = new BedsideHandler();
DBConnector dbC = new DBConnector();
dbC.connect();
int bedsideId = int.Parse(bedsideIdExistingComboBox.SelectedItem.ToString());
int patientId = int.Parse(patientIdTextBox.Text);
bool status = bedsideHandler.continueBedside(dbC.getConn(), bedsideId, patientId);
if (status)
{
bedside_patient_id = patientId;
bedsideIDPass = bedsideId;
BedsideMainScreen bedsideMainScreen = new BedsideMainScreen();
bedsideMainScreen.Show();
Close();
}
}
public void setAssignPatientId()
{
assignPatientIdcomboBox.Visible = true;
assignBedsideIdBtn.Visible = true;
BedsideHandler bedsideHandler = new BedsideHandler();
bedsideHandler.FetchBedsidePatientId(assignPatientIdcomboBox);
}
//change the patientIdtextbox when bedsideIdExistingComboBox_SelectedIndex is Changed
private void bedsideIdExistingComboBox_SelectedIndexChanged(object sender, EventArgs e)
{
BedsideHandler bedsideHandler = new BedsideHandler();
DBConnector dbC = new DBConnector();
dbC.connect();
if (bedsideIdExistingComboBox.SelectedIndex != 0)
{
Patient existPatient = bedsideHandler.getSpecificPatientInBedside(dbC.getConn(), int.Parse(bedsideIdExistingComboBox.SelectedItem.ToString()));
patientIdTextBox.Text = existPatient.Id.ToString();
}
}
//show assign panel
private void assignBtn_Click(object sender, EventArgs e)
{
existingPanel.Hide();
showMenuPanel.Hide();
assignPanel.Show();
//create object bedside handler
BedsideHandler bedsideHandler = new BedsideHandler();
bool status = false;
//get all bedside id currently not assigned to patient
bedsideHandler.FetchBedsideId(bedsideIdAssignComboBox, status);
bedsideHandler.FetchBedsidePatientId(patientIDAssignComboBox);
}
//show existing panel
private void existingBtn_Click(object sender, EventArgs e)
{
existingPanel.Show();
showMenuPanel.Hide();
assignPanel.Hide();
//create object bedside handler
BedsideHandler bedsideHandler = new BedsideHandler();
bool status = true;
//get all bedside id currently assigned to patient
bedsideHandler.FetchBedsideId(bedsideIdExistingComboBox, status);
patientIdTextBox.Text = "";
}
private void muteAlarmBtn_Click(object sender, EventArgs e)
{
smsTrigger = 1;
DBConnector dBConn = new DBConnector();
dBConn.connect();
AlarmHandler alarmHandler = new AlarmHandler();
int id = alarmHandler.getLastId(dBConn.getConn(), BedsideLoginScreen.bedside_patient_id);
int result = alarmHandler.updateDateTimeMuted(dBConn.getConn(), BedsideLoginScreen.bedside_patient_id, id);
if (id > 0)
{
if (result == 1)
{
BedsideHandler bedsideHandler = new BedsideHandler();
int alarmResult = bedsideHandler.updateAlarmStatus(dBConn.getConn(), BedsideLoginScreen.bedsideIDPass, 0);
if (alarmResult == 1)
{
int alarmResultZero = bedsideHandler.updateAlarmZeroStatus(dBConn.getConn(), BedsideLoginScreen.bedsideIDPass, 0);
if (alarmResultZero == 1)
{
MessageBox.Show("Muted Alarm", "Muted Alarm", MessageBoxButtons.OK, MessageBoxIcon.Information);
alarmReadingStatus = false;
alarmZeroStatus = false;
if (backgroundWorkerAlarmReading.IsBusy)
{
backgroundWorkerAlarmReading.CancelAsync();
}
if (backgroundWorkerAlarmZero.IsBusy)
{
backgroundWorkerAlarmZero.CancelAsync();
}
backgroundWorkerBeep.RunWorkerAsync();
}
}
}
else
{
MessageBox.Show("Alarm cannot be muted", "Muted Alarm", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
//assign bedside id to a patient
private void proceedAssignBtn_Click(object sender, EventArgs e)
{
//if bedsideIdAssignComboBox selected index = 0, show warning message
if (bedsideIdAssignComboBox.SelectedIndex == 0)
{
MessageBox.Show("Please select valid bedside id", "Bedside ID", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
//patientIDAssignComboBox selected index = 0, show warning message
if (patientIDAssignComboBox.SelectedIndex == 0)
{
MessageBox.Show("Please select valid patient id", "Patient ID", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
//connect database
DBConnector dbC = new DBConnector();
dbC.connect();
//get current bedside id when user selected the combo box items
int bedsideId = int.Parse(bedsideIdAssignComboBox.SelectedItem.ToString());
//get current patient id when user selected the combo box items
int patientId = int.Parse(patientIDAssignComboBox.SelectedItem.ToString());
//create new object bedside handler
BedsideHandler bedsideHandler = new BedsideHandler();
//assign a bedside id to a patient
int assignResult = bedsideHandler.assignBedside(dbC.getConn(), bedsideId, patientId);
//if assignresult return value = 1
if (assignResult == 1)
{
//assign bedside id to patient
int statusResult = bedsideHandler.updateStatus(dbC.getConn(), bedsideId);
if (statusResult == 1)
{
//static int field get value from patientId
bedside_patient_id = patientId;
bedsideIDPass = bedsideId;
//create new object bedside main screen
BedsideMainScreen ms = new BedsideMainScreen();
//show bedside main screen
ms.Show();
//close login screen
Close();
}
else
{
//show error message if failed to access
MessageBox.Show("Failed to access", "Failed to access", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
//show error message if failed to access
MessageBox.Show("Failed to access", "Failed to access", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void centralbedsideIdcomboBox_SelectedIndexChanged(object sender, EventArgs e)
{
if (centralbedsideIdcomboBox.SelectedIndex > 0)
{
int index = centralbedsideIdcomboBox.SelectedIndex;
if (listBedside[index].Status)
{
DBConnector dBConn = new DBConnector();
dBConn.connect();
centralBedsideStatus.Text = "ONLINE";
centralBedsideStatus.ForeColor = Color.Green;
BedsideHandler bedsideHandler = new BedsideHandler();
bool status = bedsideHandler.checkExistBedside(dBConn.getConn(), listBedside[index].Id);
if (status)
{
assignPatientIdcomboBox.Visible = false;
assignBedsideIdBtn.Visible = false;
readingPanel.Show();
Patient patient = bedsideHandler.getSpecificPatientInBedside(dBConn.getConn(), listBedside[index].Id);
patientIdStatic = patient.Id;
centralPatientIdLabel.Text = patient.Id.ToString();
centralPatientIdLabel.ForeColor = Color.Black;
centralPatientNameLabel.Text = patient.FullName;
ReadingHandler readingHandler = new ReadingHandler();
bool statusReading = readingHandler.checkExistsReading(dBConn.getConn(), patient.Id);
if (statusReading)
{
Reading reading = readingHandler.getReading(dBConn.getConn(), patient.Id);
minBP.Text = reading.MinBloodPressure.ToString();
maxBP.Text = reading.MaxBloodPressure.ToString();
minBR.Text = reading.MinBreathing.ToString();
maxBR.Text = reading.MaxBreathing.ToString();
minPR.Text = reading.MinPulse.ToString();
maxPR.Text = reading.MaxPulse.ToString();
minTemp.Text = reading.MinTemperature.ToString();
maxTemp.Text = reading.MaxTemperature.ToString();
minBPtextBox.Text = reading.MinBloodPressure.ToString();
maxBPtextBox.Text = reading.MaxBloodPressure.ToString();
minBRtextBox.Text = reading.MinBreathing.ToString();
maxBRtextBox.Text = reading.MaxBreathing.ToString();
minPRtextBox.Text = reading.MinPulse.ToString();
maxPRtextBox.Text = reading.MaxPulse.ToString();
minTemptextBox.Text = reading.MinTemperature.ToString();
maxTemptextBox.Text = reading.MaxTemperature.ToString();
}
}
}
else
{
readingPanel.Hide();
centralBedsideStatus.Text = "OFFLINE";
centralBedsideStatus.ForeColor = Color.Red;
centralPatientIdLabel.Text = "No Assigned Patient ID";
centralPatientIdLabel.ForeColor = Color.Red;
centralPatientNameLabel.Text = "--";
minBP.Text = "--";
maxBP.Text = "--";
minBR.Text = "--";
maxBR.Text = "--";
minPR.Text = "--";
maxPR.Text = "--";
minTemp.Text = "--";
maxTemp.Text = "--";
minBPtextBox.Text = "";
maxBPtextBox.Text = "";
minBRtextBox.Text = "";
maxBRtextBox.Text = "";
minPRtextBox.Text = "";
maxPRtextBox.Text = "";
minTemptextBox.Text = "";
maxTemptextBox.Text = "";
}
//if (centralPatientIdLabel.Text == "No Assigned Patient ID")
//{
// assignPatientIdcomboBox.Items.Clear();
// setAssignPatientId();
//}
}
}
private async void readTemperatureData()
{
kayChart dataChart = new kayChart(temperatureLineGraph, 60);
dataChart.serieName = "Temperature";
string path = "../../../Patient-Monitoring-System/data files/temperatureCSV.csv";
string line;
try
{
StreamReader sr = new StreamReader(path);
line = sr.ReadLine();
while (line != null)
{
string[] columns = line.Split(',');
foreach (string column in columns)
{
if (run)
{
double value = double.Parse(column);
//add each value to database *DONT Delete*
DateTime currentDate = DateTime.Now;
DateTime currentTime = DateTime.Now;
DBConnector dBConn = new DBConnector();
dBConn.connect();
Temperature newTemperature = new Temperature();
newTemperature.TemperatureValue = value;
newTemperature.TemperatureDate = currentDate;
newTemperature.TemperatureTime = currentTime;
TemperatureHandler temperatureHandler = new TemperatureHandler();
ReadingHandler readingHandler = new ReadingHandler();
int result = temperatureHandler.addNewTemperature(dBConn.getConn(), newTemperature, BedsideLoginScreen.bedside_patient_id);
if (result != 1)
{
MessageBox.Show("Insert Data failed");
}
await Task.Delay(1500);
await Task.Factory.StartNew(() =>
{
dataChart.TriggeredUpdate(value);
});
if (value == 0)
{
if (smsTrigger == 1)
{
if (!backgroundWorkerSendSMS.IsBusy)
{
backgroundWorkerSendSMS.RunWorkerAsync();
}
}
temperatureLineGraph.Series["Temperature"].Color = Color.Red;
temperatureCurrentValue.ForeColor = Color.Red;
BedsideHandler bedsideHandler = new BedsideHandler();
int alarmResult = bedsideHandler.updateAlarmZeroStatus(dBConn.getConn(), BedsideLoginScreen.bedsideIDPass, 1);
alarmZeroStatus = true;
AlarmHandler alarmHandler = new AlarmHandler();
int specificId = alarmHandler.getSpecificId(dBConn.getConn(), value, "temperature");
if (specificId > 0)
{
bool triggerStatus = alarmHandler.triggerAlarm(dBConn.getConn(), value, BedsideLoginScreen.bedside_patient_id, 0, specificId, "Temperature");
if (triggerStatus)
{
listTemperature.Add(newTemperature);
}
}
}
else
if (value >= double.Parse(maxTemperatureLabel.Text) || value <= double.Parse(minTemperatureLabel.Text))
{
if (smsTrigger == 1)
{
if (!backgroundWorkerSendSMS.IsBusy)
{
backgroundWorkerSendSMS.RunWorkerAsync();
}
}
temperatureLineGraph.Series["Temperature"].Color = Color.Yellow;
temperatureCurrentValue.ForeColor = Color.Yellow;
BedsideHandler bedsideHandler = new BedsideHandler();
int alarmResult = bedsideHandler.updateAlarmStatus(dBConn.getConn(), BedsideLoginScreen.bedsideIDPass, 1);
alarmReadingStatus = true;
int id = readingHandler.getIdAlarmTrigger(dBConn.getConn(), value);
if (id > 0)
{
AlarmHandler alarmHandler = new AlarmHandler();
bool triggerStatus = alarmHandler.triggerAlarm(dBConn.getConn(), value, BedsideLoginScreen.bedside_patient_id, id, 0, "Temperature");
if (triggerStatus)
{
listTemperature.Add(newTemperature);
}
}
}
else
{
temperatureLineGraph.Series["Temperature"].Color = Color.Green;
temperatureCurrentValue.ForeColor = Color.Green;
}
temperatureCurrentValue.Text = value.ToString() + "°C";
}
else
{
break;
}
}
line = sr.ReadLine();
}
}
catch (FileNotFoundException e)
{
MessageBox.Show(e.ToString());
Console.WriteLine(e.ToString());
}
}
