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()); }