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