private void btnAdd_Click(object sender, EventArgs e)
{
DatabaseConnertor databaseConnertor = new DatabaseConnertor();
databaseConnertor.connect();
setalarm setalarm = new setalarm();
setalarm.P_id = int.Parse(AlarmPatientIdTextBox.Text);
setalarm.P_min_pulse_rate = int.Parse(tbminP.Text);
setalarm.P_max_pulse = int.Parse(tbmaxP.Text);
setalarm.P_min_temperature = int.Parse(tbminT.Text);
setalarm.P_max_temperature = int.Parse(tbmaxT.Text);
setalarm.P_min_breathing_rate = int.Parse(tbminB.Text);
setalarm.P_max_breathing = int.Parse(tbmaxB.Text);
setalarm.P_min_blood_sys = int.Parse(tbminS.Text);
setalarm.P_max_sys = int.Parse(tbmaxS.Text);
setalarm.P_min_blood_dias = int.Parse(tbminD.Text);
setalarm.P_max_dias = int.Parse(tbmaxD.Text);
setalarmHandler setalarmHandler = new setalarmHandler();
int recordCnt = setalarmHandler.addSetAlarm(databaseConnertor.getconn(), setalarm);
MessageBox.Show(recordCnt + " record has been inserted !!");
this.Close();
SetAlarmLimit setAlarmLimit = new SetAlarmLimit();
setAlarmLimit.Show();
}
public int addSetAlarm(MySqlConnection conn, setalarm setalarm)
{
string sql = "INSERT INTO patientlimit (p_id, p_min_blood_sys, p_min_temperature, p_min_blood_dias, p_min_breathing_rate, p_min_pulse_rate, p_max_pulse, p_max_sys, p_max_dias, p_max_temperature, p_max_breathing)"
+ " VALUES (" + setalarm.P_id + " ," + setalarm.P_min_blood_sys + " , " + setalarm.P_min_temperature
+ " , " + setalarm.P_min_blood_dias + " , " + setalarm.P_min_breathing_rate + " , " + setalarm.P_min_pulse_rate
+ " , " + setalarm.P_max_pulse + " , " + setalarm.P_max_sys + " , " + setalarm.P_max_dias + " , " + setalarm.P_max_temperature
+ " , " + setalarm.P_max_breathing + ")";
MySqlCommand sqlComm = new MySqlCommand(sql, conn);
return(sqlComm.ExecuteNonQuery());
}
