private void UpdateInfo() { MySqlCommand comm = new MySqlCommand(comGetInfo); comm.Parameters.AddWithValue("@id", flyID); comm.Parameters.AddWithValue("@lasttime", lastTime); try { //packetID, temp, pressure, gx,gz,gy,height,hum,co2,nh3,no2,speed,voltage,batch db.Command = comm; List <List <String> > result = db.ExecuteQuery(); pocketCount += result[0].Count(); List <double> temp = result[1].Where((string s) => { return(s != ""); }).Select((string s) => { return(double.Parse(s)); }).ToList(); List <double> press = result[2].Where((string s) => { return(s != ""); }).Select((string s) => { return(double.Parse(s)); }).ToList(); double gx = result[3].Where((string s) => { return(s != ""); }).Select((string s) => { return(double.Parse(s)); }).Last(); double gz = result[4].Where((string s) => { return(s != ""); }).Select((string s) => { return(double.Parse(s)); }).Last(); double gy = result[5].Where((string s) => { return(s != ""); }).Select((string s) => { return(double.Parse(s)); }).Last(); List <double> height = result[6].Where((string s) => { return(s != ""); }).Select((string s) => { return(double.Parse(s)); }).ToList(); List <double> hum = result[7].Where((string s) => { return(s != ""); }).Select((string s) => { return(double.Parse(s)); }).ToList(); List <double> co2 = result[8].Where((string s) => { return(s != ""); }).Select((string s) => { return(double.Parse(s)); }).ToList(); List <double> nh3 = result[9].Where((string s) => { return(s != ""); }).Select((string s) => { return(double.Parse(s)); }).ToList(); List <double> no2 = result[10].Where((string s) => { return(s != ""); }).Select((string s) => { return(double.Parse(s)); }).ToList(); List <double> speed = result[11].Where((string s) => { return(s != ""); }).Select((string s) => { return(double.Parse(s)); }).ToList(); List <double> voltage = result[12].Where((string s) => { return(s != ""); }).Select((string s) => { return(double.Parse(s)); }).ToList(); List <double> batch = result[13].Where((string s) => { return(s != ""); }).Select((string s) => { return(double.Parse(s)); }).ToList(); lastTime = result[14].Select((string s) => { return(double.Parse(s)); }).Count() != 0 ? result[14].Select((string s) => { return(double.Parse(s)); }).Max() : 0; double time = result[15].Select((string s) => { return(double.Parse(s)); }).Max(); plotTemp.AddPointsY(temp.ToArray()); plotPress.AddPointsY(press.ToArray()); plotHeight.AddPointsY(height.ToArray()); plotHum.AddPointsY(hum.ToArray()); plotCO.AddPointsY(co2.ToArray()); plotNH.AddPointsY(nh3.ToArray()); plotNO.AddPointsY(no2.ToArray()); plotVolt.AddPointsY(voltage.ToArray()); plotCharge.AddPointsY(batch.ToArray()); plotSpeed.AddPointsY(speed.ToArray()); gpsX.Text = gx.ToString(); gpsY.Text = gy.ToString(); gpsZ.Text = gz.ToString(); if (progressBar1.Maximum < pocketCount) { progressBar1.Maximum = pocketCount; } progressBar1.Value = pocketCount; analogClock1.Date = new DateTime((long)(time * 10000000)); lblFName.Text = flyName; } catch { } }
private void toolStripButton4_Click(object sender, EventArgs e) { Flight_List flist = new Flight_List(); flist.Show(this); try { var result = dbConnection.ExecuteQuery(new MySqlCommand(comGetFlights)); if (result.Count == 0) { return; } flist.IDs.Lines = result[0].ToArray(); flist.Names.Lines = result[1].ToArray(); flist.Starts.Lines = result[2].ToArray(); flist.Ends.Lines = result[3].ToArray(); } catch { MessageBox.Show("Error appeared on loading"); } }
private bool IsNewFlight(out int id) { bool result = false; try { MySqlCommand command = new MySqlCommand(comGetID); var recID = int.Parse(dbConnection.ExecuteQuery(command)[0][0]); if (recID != flyIDLastChecked) { id = recID; result = true; } else { id = flyIDLastChecked; } } catch { id = flyIDLastChecked; } return(result); }