public void updatePatientBedsideIdAndReadings(MySqlConnection conn, Patient ptient, ModuleReadings moduleRConf)
{
int theBedSideId = bedSideId(conn, ptient);
//Update bedside table
int patientId = 0;
string selectPatientIdSql = "SELECT patientId FROM `patient` WHERE bedsideId=" + theBedSideId + ";";
MySqlCommand sqlComm1 = new MySqlCommand(selectPatientIdSql, conn);
using (MySqlDataReader sqlReader = sqlComm1.ExecuteReader())
{
while (sqlReader.Read())
{
patientId = (int)sqlReader.GetValue(0);
}
}
string updateBedSideSql = "UPDATE `bedside` SET `status`=1, `patientId`=" + patientId + " WHERE `bedsideId`=" + theBedSideId + ";";
MySqlCommand sqlComm2 = new MySqlCommand(updateBedSideSql, conn);
sqlComm2.ExecuteNonQuery();
ModuleReadingsHandler mRHand = new ModuleReadingsHandler();
mRHand.updatePatientBedsideId(conn, moduleRConf, patientId, "New");
}
private void button1_Click(object sender, EventArgs e)
{
DbConnector dbConn = new DbConnector();
dbConn.connect();
string checkId = label11.Text;
ModuleReadingsHandler mRHand = new ModuleReadingsHandler();
if (textBox3.Text == mRHand.getModuleReading(dbConn.getConn(), "pulseRMin", checkId) &&
textBox4.Text == mRHand.getModuleReading(dbConn.getConn(), "pulseRMax", checkId) &&
textBox23.Text == mRHand.getModuleReading(dbConn.getConn(), "pulseRIntTime", checkId) &&
textBox6.Text == mRHand.getModuleReading(dbConn.getConn(), "breathRMin", checkId) &&
textBox5.Text == mRHand.getModuleReading(dbConn.getConn(), "breathRMax", checkId) &&
textBox24.Text == mRHand.getModuleReading(dbConn.getConn(), "breathRIntTime", checkId) &&
textBox8.Text == mRHand.getModuleReading(dbConn.getConn(), "systolicMin", checkId) &&
textBox7.Text == mRHand.getModuleReading(dbConn.getConn(), "systolicMax", checkId) &&
textBox9.Text == mRHand.getModuleReading(dbConn.getConn(), "diastolicMin", checkId) &&
textBox10.Text == mRHand.getModuleReading(dbConn.getConn(), "diastolicMax", checkId) &&
textBox25.Text == mRHand.getModuleReading(dbConn.getConn(), "bloodPIntTime", checkId) &&
textBox11.Text == mRHand.getModuleReading(dbConn.getConn(), "tempMin", checkId) &&
textBox12.Text == mRHand.getModuleReading(dbConn.getConn(), "tempMax", checkId) &&
textBox26.Text == mRHand.getModuleReading(dbConn.getConn(), "tempIntTime", checkId))
{
MessageBox.Show("No changes detected");
}
else
{
ModuleReadings mConfig = new ModuleReadings();
string thePatientId = checkId;
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();
mRHand.updatePatientBedsideId(dbConn.getConn(), mConfig, Int32.Parse(thePatientId), "New");
MessageBox.Show("Module Reading Changed Successfully !");
}
}