private void btn_measurement_Click(object sender, EventArgs e) { if (active) { measurement meting = new measurement(cmb_patients.SelectedIndex, DateTime.Now, lbl_duimtop.Text, lbl_duimbot.Text, lbl_wijstop.Text, lbl_wijsmid.Text, lbl_wijsbot.Text, lbl_midtop.Text, lbl_midmid.Text, lbl_midbot.Text, lbl_ringtop.Text, lbl_ringmid.Text, lbl_ringbot.Text, lbl_pinktop.Text, lbl_pinkmid.Text, lbl_pinkbot.Text); try { if (conn.addMeasurement(meting)) { if (this.language.Equals("en")) { MessageBox.Show("Measurement Added"); } if (this.language.Equals("nl")) { MessageBox.Show("meting toegevoegd"); } } } catch { MessageBox.Show("Er is een fout opgetreden, probeer later opnieuw"); } } }
//gets history of one patient public List <measurement> getHistory(int id) { msCom = new MySqlCommand(); List <measurement> metingen = new List <measurement>(); measurement m1; msCom.Connection = msConn; msCom.CommandText = "select * from pr_meting where pr_meting.M_ID=\"" + id + "\" ORDER BY M_Datum DESC LIMIT 10;"; msCom.CommandType = CommandType.Text; connect(); msDr = msCom.ExecuteReader(); //check whether there are rows. if (msDr.HasRows) { while (msDr.Read()) { m1 = new measurement(msDr.GetInt32(0), msDr.GetDateTime(1), msDr.GetString(2), msDr.GetString(3), msDr.GetString(4), msDr.GetString(5), msDr.GetString(6), msDr.GetString(7), msDr.GetString(8), msDr.GetString(9), msDr.GetString(10), msDr.GetString(11), msDr.GetString(12), msDr.GetString(13), msDr.GetString(14), msDr.GetString(15)); metingen.Add(m1); } } deconnect(); return(metingen); }
public bool addMeasurement(measurement meting) { string strQuery = "INSERT INTO a2100359_project.pr_meting (M_ID, M_Datum, M_Duimtop, M_Duimbot," + "M_Wijstop, M_Wijsmid, M_Wijsbot, M_Midtop, M_Midmid, M_Midbot, M_Ringtop, M_Ringmid, M_Ringbot, M_Pinktop, M_Pinkmid, M_Pinkbot)" + "VALUES ('" + meting.Gebruiker + "','" + meting.Datum.ToString("yyyy-MM-dd HH:mm:ss") + "' , '" + meting.Duimtop + "', '" + meting.Duimbot + "', '" + meting.Wijstop + "', '" + meting.Wijsmid + "', '" + meting.Wijsbot + "', '" + meting.Midtop + "', '" + meting.Midmid + "', '" + meting.Midbot + "', '" + meting.Ringtop + "', '" + meting.Ringmid + "', '" + meting.Ringbot + "', '" + meting.Pinktop + "', '" + meting.Pinkmid + "', '" + meting.Pinkbot + "');"; msCom = new MySqlCommand(); msCom.Connection = msConn; msCom.CommandText = strQuery; //MessageBox.Show(strQuery); try { connect(); if (msCom.ExecuteNonQuery() == 1) { return(true); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { deconnect(); } return(false); }
public void loadUC(int id) { conn = new Connection(); List <measurement> metingen = conn.getHistory(id); for (int i = 0; i < metingen.Count; i++) { measurement meting = metingen.ElementAt(i); waarden[0, i] = Int32.Parse(meting.Wijstop); waarden[1, i] = Int32.Parse(meting.Midtop); waarden[2, i] = Int32.Parse(meting.Ringtop); waarden[3, i] = Int32.Parse(meting.Pinktop); waarden[4, i] = Int32.Parse(meting.Duimtop); } }