public void displayData(string[] patientData)
{
DbConnector dbConn = new DbConnector();
dbConn.connect();
Patient ptient = new Patient();
ptient.Wing = patientData[0];
ptient.Floor = patientData[1];
ptient.Bay = patientData[2];
ptient.Bed = patientData[3];
label15.Text = patientData[0];
label16.Text = patientData[1];
label17.Text = patientData[2];
label18.Text = patientData[3];
PatientHandler patHnd = new PatientHandler();
string checkId = patHnd.getPatientDetails(dbConn.getConn(), ptient, "patientId");
string checkName = patHnd.getPatientDetails(dbConn.getConn(), ptient, "patientName");
string checkAge = patHnd.getPatientDetails(dbConn.getConn(), ptient, "patientAge");
string checkGender = patHnd.getPatientDetails(dbConn.getConn(), ptient, "patientGender");
label11.Text = checkId;
label12.Text = checkName;
label13.Text = checkAge;
label14.Text = checkGender;
latestValues();
}
public void getBasicPatientDetails()
{
if ((comboBox1.SelectedItem).ToString() != " - SELECT WING - " &&
(comboBox2.SelectedItem).ToString() != " - SELECT FLOOR - " &&
(comboBox3.SelectedItem).ToString() != " - SELECT BAY - " &&
(comboBox4.SelectedItem).ToString() != " - SELECT BED - ")
{
DbConnector dbConn = new DbConnector();
dbConn.connect();
Patient ptient = new Patient();
ptient.Wing = (comboBox1.SelectedItem).ToString();
ptient.Floor = (comboBox2.SelectedItem).ToString();
ptient.Bay = (comboBox3.SelectedItem).ToString();
ptient.Bed = (comboBox4.SelectedItem).ToString();
PatientHandler patHnd = new PatientHandler();
string checkId = patHnd.getPatientDetails(dbConn.getConn(), ptient, "patientId");
string checkName = patHnd.getPatientDetails(dbConn.getConn(), ptient, "patientName");
string checkAge = patHnd.getPatientDetails(dbConn.getConn(), ptient, "patientAge");
string checkGender = patHnd.getPatientDetails(dbConn.getConn(), ptient, "patientGender");
label1.Text = checkId;
label2.Text = checkName;
label3.Text = checkAge;
label4.Text = checkGender;
label34.Text = (comboBox1.SelectedItem).ToString() + " → " + (comboBox2.SelectedItem).ToString() + " → " +
(comboBox3.SelectedItem).ToString();
label36.Text = (comboBox4.SelectedItem).ToString().Remove(0, 4);
}
else
{
label1.Text = "No record found";
label2.Text = "No record found";
label3.Text = "No record found";
label4.Text = "No record found";
label34.Text = "- Wing → Floor - → Bay - ";
label36.Text = "-";
}
}
public void patientDBtable(int num)
{
DbConnector dbConn = new DbConnector();
dbConn.connect();
Patient ptient = new Patient();
PatientHandler patientHnd = new PatientHandler();
if (num == 1)
{
ptient.Name = textBox13.Text;
}
else if (num == 2)
{
ptient.Wing = "%";
ptient.Floor = "%";
ptient.Bay = "%";
ptient.Bed = "%";
}
dataGridView1.DataSource = patientHnd.listPatient(dbConn.getConn(), ptient, num);
dataGridView1.Columns[0].HeaderText = "ID";
dataGridView1.Columns[1].HeaderText = "NAME";
dataGridView1.Columns[2].HeaderText = "AGE";
dataGridView1.Columns[3].HeaderText = "GENDER";
dataGridView1.Columns[4].HeaderText = "BEDSIDE ID";
dataGridView1.Columns[5].HeaderText = "WING";
dataGridView1.Columns[6].HeaderText = "FLOOR";
dataGridView1.Columns[7].HeaderText = "BAY";
dataGridView1.Columns[8].HeaderText = "BED";
dataGridView1.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView1.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView1.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView1.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView1.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView1.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView1.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
public void pictureBox1_Click(object sender, EventArgs e)
{
string wingSelected = (comboBox1.SelectedItem).ToString();
string floorSelected = (comboBox2.SelectedItem).ToString();
string baySelected = (comboBox3.SelectedItem).ToString();
string bedSelected = (comboBox4.SelectedItem).ToString();
DbConnector dbConn = new DbConnector();
dbConn.connect();
Patient ptient = new Patient();
ptient.Wing = wingSelected;
ptient.Floor = floorSelected;
ptient.Bay = baySelected;
ptient.Bed = bedSelected;
PatientHandler patHnd = new PatientHandler();
string checkId = patHnd.getPatientDetails(dbConn.getConn(), ptient, "patientId");
if (checkId != "No record found")
{
string[] patientData = new string[4] {
wingSelected, floorSelected, baySelected, bedSelected
};
PatientModuleReadingsConfiguration passPatientData = new PatientModuleReadingsConfiguration();
passPatientData.Show();
passPatientData.displayData(patientData);
}
else
{
MessageBox.Show("No patient found !");
}
}
private void textBox22_TextChanged(object sender, EventArgs e)
{
if (textBox22.Text != "")
{
if (Int32.TryParse(textBox22.Text, out int theId) && Int32.Parse(textBox22.Text) >= 0)
{
DbConnector dbConn = new DbConnector();
dbConn.connect();
PatientHandler patHnd = new PatientHandler();
label51.Text = patHnd.getPatientDetailsById(dbConn.getConn(), Int32.Parse(textBox22.Text), "patientName");
label52.Text = patHnd.getPatientDetailsById(dbConn.getConn(), Int32.Parse(textBox22.Text), "patientAge");
label53.Text = patHnd.getPatientDetailsById(dbConn.getConn(), Int32.Parse(textBox22.Text), "patientGender");
if (label51.Text == "No record found")
{
label47.Text = "Invalid Patient ID";
label47.ForeColor = Color.Red;
label47.Visible = true;
button11.Enabled = false;
button12.Enabled = false;
button13.Enabled = false;
button14.Enabled = false;
}
else
{
label47.Text = "Valid Patient ID";
label47.ForeColor = Color.Green;
label47.Visible = true;
button11.Enabled = true;
button12.Enabled = true;
button13.Enabled = true;
button14.Enabled = true;
}
}
else
{
label47.Text = "Invalid Patient ID";
label47.ForeColor = Color.Red;
label47.Visible = true;
button11.Enabled = false;
button12.Enabled = false;
button13.Enabled = false;
button14.Enabled = false;
}
}
else
{
label51.Text = "No record found";
label52.Text = "No record found";
label53.Text = "No record found";
button11.Enabled = false;
button12.Enabled = false;
button13.Enabled = false;
button14.Enabled = false;
label47.Text = "Validate Medical Staff ID";
label47.ForeColor = Color.Black;
label47.Visible = false;
}
}
//Add new patient button
private void button5_Click(object sender, EventArgs e)
{
DbConnector dbConn = new DbConnector();
dbConn.connect();
Patient ptient = new Patient();
ModuleReadings mConfig = new ModuleReadings();
if (textBox1.Text != "" && textBox2.Text != "" && (comboBox1.SelectedItem).ToString() != "- SELECT -" &&
(comboBox2.SelectedItem).ToString() != "- SELECT -" && (comboBox3.SelectedItem).ToString() != "- SELECT -" &&
(comboBox4.SelectedItem).ToString() != "- SELECT -" && (comboBox5.SelectedItem).ToString() != "- SELECT -" &&
textBox3.Text != "" && textBox4.Text != "" && textBox5.Text != "" && textBox6.Text != "" &&
textBox7.Text != "" && textBox8.Text != "" && textBox9.Text != "" && textBox10.Text != "" &&
textBox11.Text != "" && textBox12.Text != "")
{
if (int.TryParse(textBox2.Text, out int theAge) && Int32.Parse(textBox2.Text) < 150)
{
ptient.Name = textBox1.Text;
ptient.Age = Int32.Parse(textBox2.Text);
ptient.Gender = (comboBox1.SelectedItem).ToString();
ptient.Wing = (comboBox2.SelectedItem).ToString();
ptient.Floor = (comboBox3.SelectedItem).ToString();
ptient.Bay = (comboBox4.SelectedItem).ToString();
ptient.Bed = (comboBox5.SelectedItem).ToString();
mConfig.MinPulse = Int32.Parse(textBox3.Text);
mConfig.MaxPulse = Int32.Parse(textBox4.Text);
mConfig.MinBreath = Int32.Parse(textBox6.Text);
mConfig.MaxBreath = Int32.Parse(textBox5.Text);
mConfig.MinSystolic = Int32.Parse(textBox8.Text);
mConfig.MaxSystolic = Int32.Parse(textBox7.Text);
mConfig.MinDiastolic = Int32.Parse(textBox9.Text);
mConfig.MaxDiastolic = Int32.Parse(textBox10.Text);
mConfig.MinTemp = float.Parse(textBox11.Text);
mConfig.MaxTemp = float.Parse(textBox12.Text);
mConfig.PulseIntTime = Int32.Parse(textBox23.Text);
mConfig.BreathIntTime = Int32.Parse(textBox24.Text);
mConfig.PressureIntTime = Int32.Parse(textBox25.Text);
mConfig.TempIntTime = Int32.Parse(textBox26.Text);
mConfig.PRModifiedTime = DateTime.Now.ToString();
mConfig.BRModifiedTime = DateTime.Now.ToString();
mConfig.BPModifiedTime = DateTime.Now.ToString();
mConfig.TempModifiedTime = DateTime.Now.ToString();
PatientHandler patHnd = new PatientHandler();
int recordCnt = patHnd.addNewPatient(dbConn.getConn(), ptient);
patHnd.updatePatientBedsideIdAndReadings(dbConn.getConn(), ptient, mConfig);
MessageBox.Show(recordCnt + " Patient Registered Successfully !");
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "60";
textBox4.Text = "100";
textBox5.Text = "20";
textBox6.Text = "12";
textBox7.Text = "120";
textBox8.Text = "80";
textBox9.Text = "60";
textBox10.Text = "80";
textBox11.Text = "35.2";
textBox12.Text = "36.9";
textBox23.Text = "1";
textBox24.Text = "2";
textBox25.Text = "3";
textBox26.Text = "5";
comboBox1.SelectedIndex = 0;
comboBox2.SelectedIndex = 0;
comboBox3.SelectedIndex = 0;
comboBox4.SelectedIndex = 0;
comboBox5.SelectedIndex = 0;
patientDBtable(1);
}
else
{
MessageBox.Show("Invalid format for Age !");
}
}
else
{
MessageBox.Show("Please fill up all fields to register.");
}
}
public void runMonitor(object sender, EventArgs e)
{
var pulseRate = checkBox1.Checked;
var breathingRate = checkBox2.Checked;
var bloodPressure = checkBox3.Checked;
var temperature = checkBox4.Checked;
var criticalColor = Color.FromArgb(255, 8, 8);
var inRiskColor = Color.FromArgb(255, 214, 8);
var normalColor = Color.FromArgb(8, 255, 86);
line = sr.ReadLine();
if (line == null)
{
sr = new StreamReader("CSV/ModuleReadingsA.csv");
line = sr.ReadLine();
}
DbConnector dbConn = new DbConnector();
dbConn.connect();
Patient ptient = new Patient();
PatientHandler patHnd = new PatientHandler();
ptient.Wing = (comboBox1.SelectedItem).ToString();
ptient.Floor = (comboBox2.SelectedItem).ToString();
ptient.Bay = (comboBox3.SelectedItem).ToString();
ptient.Bed = (comboBox4.SelectedItem).ToString();
string getPatientId = patHnd.getPatientDetails(dbConn.getConn(), ptient, "patientId");
int minPulse = 60;
int maxPulse = 100;
int minBreath = 12;
int maxBreath = 20;
int minSystolic = 80;
int maxSystolic = 120;
int minDiastolic = 60;
int maxDiastolic = 80;
float minTemp = 35.2F;
float maxTemp = 36.1F;
int pulseIntervalTime = 1;
int breathIntervalTime = 1;
int bloodPressureIntervalTime = 1;
int temperatureIntervalTime = 1;
if (getPatientId != "No record found")
{
ModuleReadingsHandler mRHand = new ModuleReadingsHandler();
minPulse = Int32.Parse(mRHand.getModuleReading(dbConn.getConn(), "pulseRMin", getPatientId));
maxPulse = Int32.Parse(mRHand.getModuleReading(dbConn.getConn(), "pulseRMax", getPatientId));
pulseIntervalTime = Int32.Parse(mRHand.getModuleReading(dbConn.getConn(), "pulseRIntTime", getPatientId));
minBreath = Int32.Parse(mRHand.getModuleReading(dbConn.getConn(), "breathRMin", getPatientId));
maxBreath = Int32.Parse(mRHand.getModuleReading(dbConn.getConn(), "breathRMax", getPatientId));
breathIntervalTime = Int32.Parse(mRHand.getModuleReading(dbConn.getConn(), "breathRIntTime", getPatientId));
minSystolic = Int32.Parse(mRHand.getModuleReading(dbConn.getConn(), "systolicMin", getPatientId));
maxSystolic = Int32.Parse(mRHand.getModuleReading(dbConn.getConn(), "systolicMax", getPatientId));
minDiastolic = Int32.Parse(mRHand.getModuleReading(dbConn.getConn(), "diastolicMin", getPatientId));
maxDiastolic = Int32.Parse(mRHand.getModuleReading(dbConn.getConn(), "diastolicMax", getPatientId));
bloodPressureIntervalTime = Int32.Parse(mRHand.getModuleReading(dbConn.getConn(), "bloodPIntTime", getPatientId));
minTemp = float.Parse(mRHand.getModuleReading(dbConn.getConn(), "tempMin", getPatientId));
maxTemp = float.Parse(mRHand.getModuleReading(dbConn.getConn(), "tempMax", getPatientId));
temperatureIntervalTime = Int32.Parse(mRHand.getModuleReading(dbConn.getConn(), "tempIntTime", getPatientId));
}
PatientReadings pRead = new PatientReadings();
PatientReadingsHandler pReadHnd = new PatientReadingsHandler();
try
{
string[] data = line.Split(',');
readingsList.Add(Int32.Parse(data[0]));
//Pulse Rate Readings
if (counter == pulseRateCounter && pulseRate != false)
{
label10.Text = data[0];
label14.Text = (maxPulse).ToString();
label15.Text = (minPulse).ToString();
if (Int32.Parse(data[0]) == 0)
{
labelBorder(10, "Critical");
label14.ForeColor = criticalColor;
label15.ForeColor = criticalColor;
}
else if (Int32.Parse(data[0]) > maxPulse || Int32.Parse(data[0]) < minPulse)
{
labelBorder(10, "Risky");
if (Int32.Parse(data[0]) > maxPulse)
{
label14.ForeColor = inRiskColor;
label15.ForeColor = normalColor;
}
else
{
label14.ForeColor = normalColor;
label15.ForeColor = inRiskColor;
}
}
else if (Int32.Parse(data[0]) >= minPulse && Int32.Parse(data[0]) <= maxPulse)
{
labelBorder(10, "Normal");
label14.ForeColor = normalColor;
label15.ForeColor = normalColor;
}
pulseRateCounter = pulseRateCounter + pulseIntervalTime;
}
//Breathing Rate Readings
if (counter == breathingRateCounter && breathingRate != false)
{
label11.Text = data[1];
label16.Text = (maxBreath).ToString();
label17.Text = (minBreath).ToString();
if (Int32.Parse(data[1]) == 0)
{
labelBorder(11, "Critical");
label16.ForeColor = criticalColor;
label17.ForeColor = criticalColor;
}
else if ((Int32.Parse(data[1]) > maxBreath || Int32.Parse(data[1]) < minBreath))
{
labelBorder(11, "Risky");
if (Int32.Parse(data[1]) > maxBreath)
{
label16.ForeColor = inRiskColor;
label17.ForeColor = normalColor;
}
else
{
label16.ForeColor = normalColor;
label17.ForeColor = inRiskColor;
}
}
else if (Int32.Parse(data[1]) >= minBreath && Int32.Parse(data[1]) <= maxBreath)
{
labelBorder(11, "Normal");
label16.ForeColor = normalColor;
label17.ForeColor = normalColor;
}
breathingRateCounter = breathingRateCounter + breathIntervalTime;
}
//Blood Pressure Readings
if (counter == bloodPressureCounter && bloodPressure != false)
{
label12.Text = data[2] + "/" + data[3];
label18.Text = (maxSystolic).ToString();
label19.Text = (minSystolic).ToString();
label20.Text = (maxDiastolic).ToString();
label21.Text = (minDiastolic).ToString();
if (Int32.Parse(data[2]) == 0 || (Int32.Parse(data[3]) == 0))
{
labelBorder(12, "Critical");
label18.ForeColor = criticalColor;
label19.ForeColor = criticalColor;
label20.ForeColor = criticalColor;
label21.ForeColor = criticalColor;
}
else if ((Int32.Parse(data[2]) > maxSystolic || Int32.Parse(data[2]) < minSystolic) || (Int32.Parse(data[3]) > maxDiastolic || Int32.Parse(data[3]) < minDiastolic))
{
labelBorder(12, "Risky");
if (Int32.Parse(data[2]) > maxSystolic)
{
label18.ForeColor = inRiskColor;
label19.ForeColor = normalColor;
}
else if (Int32.Parse(data[2]) < minSystolic)
{
label18.ForeColor = normalColor;
label19.ForeColor = inRiskColor;
}
if (Int32.Parse(data[3]) > maxDiastolic)
{
label20.ForeColor = inRiskColor;
label21.ForeColor = normalColor;
}
else if (Int32.Parse(data[3]) < minDiastolic)
{
label20.ForeColor = normalColor;
label21.ForeColor = inRiskColor;
}
}
else if (Int32.Parse(data[2]) >= minSystolic && Int32.Parse(data[2]) <= maxSystolic && Int32.Parse(data[3]) >= minSystolic && Int32.Parse(data[3]) <= maxSystolic)
{
labelBorder(12, "Normal");
label18.ForeColor = normalColor;
label19.ForeColor = normalColor;
label20.ForeColor = normalColor;
label21.ForeColor = normalColor;
}
bloodPressureCounter = bloodPressureCounter + bloodPressureIntervalTime;
}
//Temperature Readings
if (counter == temperatureCounter && temperature != false)
{
label13.Text = data[4] + "°C";
label22.Text = (maxTemp).ToString();
label23.Text = (minTemp).ToString();
if (float.Parse(data[4]) == 0)
{
labelBorder(13, "Critical");
label22.ForeColor = criticalColor;
label23.ForeColor = criticalColor;
}
else if (float.Parse(data[4]) > maxTemp || float.Parse(data[4]) < minTemp)
{
labelBorder(13, "Risky");
if (float.Parse(data[4]) > maxTemp)
{
label22.ForeColor = inRiskColor;
label23.ForeColor = normalColor;
}
else
{
label22.ForeColor = normalColor;
label23.ForeColor = inRiskColor;
}
}
else if (float.Parse(data[4]) >= minTemp && float.Parse(data[4]) <= maxTemp)
{
labelBorder(13, "Normal");
label22.ForeColor = normalColor;
label23.ForeColor = normalColor;
}
temperatureCounter = temperatureCounter + temperatureIntervalTime;
}
if (getPatientId != "No record found")
{
pRead.PatientId = Int32.Parse(getPatientId);
pRead.PulseRate = Int32.Parse(data[0]);
pRead.BreathingRate = Int32.Parse(data[1]);
pRead.Systolic = Int32.Parse(data[2]);
pRead.Diastolic = Int32.Parse(data[3]);
pRead.Temperature = float.Parse(data[4]);
pRead.DateTime = DateTime.Now.ToString();
pReadHnd.addPatientReading(dbConn.getConn(), pRead);
}
}
catch (Exception ex)
{
Console.WriteLine("DID NOT RECEIVE ANY DETECTION OF THE READING : " + ex);
run_Monitor.Stop();
}
if (counter == 5)
{
counter = 0;
pulseRateCounter = 0;
bloodPressureCounter = 0;
breathingRateCounter = 0;
temperatureCounter = 0;
}
else
{
counter++;
}
realCounter++;
}
