public void TestTemperatureHandler()
{
//connect database
DBConnector dbC = new DBConnector();
string resp = dbC.connect();
Assert.AreEqual("Done", resp);
TemperatureHandler thd = new TemperatureHandler();
Temperature temp = new Temperature();
Assert.IsInstanceOfType(temp, typeof(object));
DateTime currentDate = DateTime.Now;
int patientId = 1001;
temp.TemperatureValue = 37;
temp.TemperatureDate = currentDate;
temp.TemperatureTime = currentDate;
int resp1 = thd.addNewTemperature(dbC.getConn(), temp, patientId);
Assert.AreEqual(1, resp1);
int resp2 = thd.getLastIdTemperature(dbC.getConn(), patientId);
Assert.IsNotNull(resp2);
int tempId = 321;
double resp3 = thd.getLastTemperature(dbC.getConn(), patientId, tempId);
Assert.IsNotNull(resp3);
}
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());
}
}
