/// <summary>
/// Adds an entity.
/// </summary>
/// <param name="stopTime"></param>
public void Add(StopTime stopTime)
{
string sql = "INSERT INTO stop_time VALUES (:feed_id, :trip_id, :arrival_time, :departure_time, :stop_id, :stop_sequence, :stop_headsign, :pickup_type, :drop_off_type, :shape_dist_traveled);";
using (var command = _connection.CreateCommand())
{
command.CommandText = sql;
command.Parameters.Add(new SQLiteParameter(@"feed_id", DbType.Int64));
command.Parameters.Add(new SQLiteParameter(@"trip_id", DbType.String));
command.Parameters.Add(new SQLiteParameter(@"arrival_time", DbType.Int64));
command.Parameters.Add(new SQLiteParameter(@"departure_time", DbType.Int64));
command.Parameters.Add(new SQLiteParameter(@"stop_id", DbType.String));
command.Parameters.Add(new SQLiteParameter(@"stop_sequence", DbType.Int64));
command.Parameters.Add(new SQLiteParameter(@"stop_headsign", DbType.String));
command.Parameters.Add(new SQLiteParameter(@"pickup_type", DbType.Int64));
command.Parameters.Add(new SQLiteParameter(@"drop_off_type", DbType.Int64));
command.Parameters.Add(new SQLiteParameter(@"shape_dist_traveled", DbType.String));
command.Parameters[0].Value = _id;
command.Parameters[1].Value = stopTime.TripId;
command.Parameters[2].Value = stopTime.ArrivalTime.TotalSeconds;
command.Parameters[3].Value = stopTime.DepartureTime.TotalSeconds;
command.Parameters[4].Value = stopTime.StopId;
command.Parameters[5].Value = stopTime.StopSequence;
command.Parameters[6].Value = stopTime.StopHeadsign;
command.Parameters[7].Value = stopTime.PickupType.HasValue ? (int?)stopTime.PickupType.Value : null;
command.Parameters[8].Value = stopTime.DropOffType.HasValue ? (int?)stopTime.DropOffType.Value : null;
command.Parameters[9].Value = stopTime.ShapeDistTravelled;
command.ExecuteNonQuery();
}
}
/// <summary>
/// Adds or replaces an entity in the given collection.
/// </summary>
public static void AddOrReplace(this IStopTimeCollection collection, Entities.StopTime entity)
{
if (!collection.Contains(entity))
{
collection.Add(entity);
}
}
/// <summary>
/// Returns a new StopTime object created from a previous stop time object
/// </summary>
public static StopTime From(StopTime other)
{
return(new StopTime()
{
ArrivalTime = other.ArrivalTime,
DepartureTime = other.DepartureTime,
DropOffType = other.DropOffType,
PickupType = other.PickupType,
ShapeDistTravelled = other.ShapeDistTravelled,
StopHeadsign = other.StopHeadsign,
StopId = other.StopId,
StopSequence = other.StopSequence,
Tag = other.Tag,
TripId = other.TripId,
PassengerBoarding = other.PassengerBoarding,
PassengerAlighting = other.PassengerAlighting,
ThroughPassengers = other.ThroughPassengers,
TotalPassengers = other.TotalPassengers
});
}