public int addRealTime(MySqlConnection conn, realtimeclass realtimeclass) { string sql = "INSERT INTO patientrealtime (p_id, p_systolic, p_diastolic, p_breathing, p_pulse, p_temperature)" + " VALUES (" + realtimeclass.P_id + " ," + realtimeclass.P_systolic + " , " + realtimeclass.P_diastolic + " , " + realtimeclass.P_breathing + " , " + realtimeclass.P_pulse + " , " + realtimeclass.P_temperature + ")"; MySqlCommand sqlComm = new MySqlCommand(sql, conn); return(sqlComm.ExecuteNonQuery()); }
public List <realtimeclass> getAlldetails(MySqlConnection conn) { List <realtimeclass> listdetail = new List <realtimeclass>(); string sql = "SELECT * FROM patientrealtime"; MySqlCommand sqlComm = new MySqlCommand(sql, conn); MySqlDataReader myReader; myReader = sqlComm.ExecuteReader(); while (myReader.Read()) { realtimeclass realtimeclass = new realtimeclass(); realtimeclass.Pm_id = (int)myReader.GetValue(0); realtimeclass.P_id = (int)myReader.GetValue(1); realtimeclass.P_systolic = (int)myReader.GetValue(2); realtimeclass.P_diastolic = (int)myReader.GetValue(3); realtimeclass.P_breathing = (int)myReader.GetValue(4); realtimeclass.P_pulse = (int)myReader.GetValue(5); realtimeclass.P_temperature = (int)myReader.GetValue(6); listdetail.Add(realtimeclass); } return(listdetail); }
private void timer1_Tick(object sender, EventArgs e) { DatabaseConnertor databaseConnertor = new DatabaseConnertor(); databaseConnertor.connect(); realtimeclass realtimeclass = new realtimeclass(); realtimeclass.P_id = int.Parse(pID.Text); realtimeclass.P_systolic = int.Parse(lbSys.Text); realtimeclass.P_diastolic = int.Parse(lbDia.Text); realtimeclass.P_breathing = int.Parse(lbBre.Text); realtimeclass.P_pulse = int.Parse(lbPul.Text); realtimeclass.P_temperature = int.Parse(lbTem.Text); realtimeHandler realtimeHandler = new realtimeHandler(); int recordCnt1 = realtimeHandler.addRealTime(databaseConnertor.getconn(), realtimeclass); bsrandomnum = random.Next(105, 145); bdrandomnum = random.Next(65, 100); prandomnum = random.Next(65, 75); //prandomnum = random.Next(0); brandomnum = random.Next(12, 20); trandomnum = random.Next(36, 37); lbSys.Text = bsrandomnum.ToString(); lbDia.Text = bdrandomnum.ToString(); lbPul.Text = prandomnum.ToString(); lbBre.Text = brandomnum.ToString(); lbTem.Text = trandomnum.ToString(); chart1.Series[0].Points.AddXY(bstime++, bsrandomnum); chart1.Series[0].Color = Color.LightGreen; chart1.Series[1].Points.AddXY(bdtime++, bdrandomnum); if (chart1.Series[0].Points.Count > 5) { chart1.Series[0].Points.Remove(chart1.Series[0].Points[0]); chart1.ChartAreas[0].AxisX.Minimum = chart1.Series[0].Points[0].XValue; chart1.ChartAreas[0].AxisX.Maximum = bstime; } chart2.Series[0].Points.AddXY(ptime++, prandomnum); chart2.Series[0].Color = Color.LightGreen; if (chart2.Series[0].Points.Count > 5) { chart2.Series[0].Points.Remove(chart2.Series[0].Points[0]); chart2.ChartAreas[0].AxisX.Minimum = chart2.Series[0].Points[0].XValue; chart2.ChartAreas[0].AxisX.Maximum = ptime; } chart3.Series[0].Points.AddXY(btime++, brandomnum); chart3.Series[0].Color = Color.LightGreen; if (chart3.Series[0].Points.Count > 5) { chart3.Series[0].Points.Remove(chart3.Series[0].Points[0]); chart3.ChartAreas[0].AxisX.Minimum = chart3.Series[0].Points[0].XValue; chart3.ChartAreas[0].AxisX.Maximum = btime; } chart4.Series[0].Points.AddXY(ttime++, trandomnum); chart4.Series[0].Color = Color.LightGreen; if (chart4.Series[0].Points.Count > 5) { chart4.Series[0].Points.Remove(chart4.Series[0].Points[0]); chart4.ChartAreas[0].AxisX.Minimum = chart4.Series[0].Points[0].XValue; chart4.ChartAreas[0].AxisX.Maximum = ttime; } if (lbPul.Text == "0") { timer.Stop(); // SoundPlayer player = new System.Media.SoundPlayer(); SoundPlayer player1 = new SoundPlayer(Properties.Resources.BedsideSoundss); player1.Play(); // player.Stop(); } else { System.Media.SoundPlayer player = new System.Media.SoundPlayer(Properties.Resources.BedsideSounds); player.Play(); } passingtext1 = lbSys.Text; passingtext2 = lbDia.Text; passingtext3 = lbPul.Text; passingtext4 = lbBre.Text; passingtext5 = lbTem.Text; passingtext6 = pID.Text; }