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