public int AircraftPositionUpdate(AircraftPositionDesignator ap)
{
lock (db.DBCommand)
{
db.DBCommand.CommandText = "UPDATE " + AircraftPositionDesignator.TableName + " SET Hex = @Hex, Call = @Call, Lat = @Lat, Lon = @Lon, Alt = @Alt, Track = @Track, Speed = @Speed, LastUpdated = @LastUpdated WHERE Hex = @Hex AND LastUpdated = @LastUpdated";
db.DBCommand.Parameters.Clear();
db.DBCommand.Parameters.Add(ap.AsString("Hex"));
db.DBCommand.Parameters.Add(ap.AsString("Call"));
db.DBCommand.Parameters.Add(ap.AsDouble("Lat"));
db.DBCommand.Parameters.Add(ap.AsDouble("Lon"));
db.DBCommand.Parameters.Add(ap.AsDouble("Alt"));
db.DBCommand.Parameters.Add(ap.AsDouble("Track"));
db.DBCommand.Parameters.Add(ap.AsDouble("Speed"));
db.DBCommand.Parameters.Add(ap.AsUNIXTime("LastUpdated"));
return(db.ExecuteNonQuery(db.DBCommand));
}
}
public int AircraftPositionInsert(AircraftPositionDesignator ap)
{
lock (db.DBCommand)
{
db.DBCommand.CommandText = "INSERT INTO " + AircraftPositionDesignator.TableName + " (Hex, Call, Lat, Lon, Alt, Track, Speed, LastUpdated) VALUES (@Hex, @Call, @Lat, @Lon, @Alt, @Track, @Speed, @LastUpdated)";
db.DBCommand.Parameters.Clear();
db.DBCommand.Parameters.Add(ap.AsString("Hex"));
db.DBCommand.Parameters.Add(ap.AsString("Call"));
db.DBCommand.Parameters.Add(ap.AsDouble("Lat"));
db.DBCommand.Parameters.Add(ap.AsDouble("Lon"));
db.DBCommand.Parameters.Add(ap.AsDouble("Alt"));
db.DBCommand.Parameters.Add(ap.AsDouble("Track"));
db.DBCommand.Parameters.Add(ap.AsDouble("Speed"));
db.DBCommand.Parameters.Add(ap.AsUNIXTime("LastUpdated"));
return(db.ExecuteNonQuery(db.DBCommand));
}
}