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