public void InsertArrivalTimes(IEnumerable<ArrivalTimeData> arrivalTimes)
{
using (var database = new DataClassesDataContext())
{
foreach (var arrivalTime in arrivalTimes)
{
var result = new ArrivalTime();
database.ArrivalTimes.InsertOnSubmit(result);
var restaurant = database.Restaurants.FirstOrDefault(r => r.Name == arrivalTime.Restaurant.Name);
if (restaurant == default(Restaurant))
{
restaurant = new Restaurant();
restaurant.Name = arrivalTime.Restaurant.Name;
database.Restaurants.InsertOnSubmit(restaurant);
}
result.Restaurant = restaurant;
result.TimeArrived = arrivalTime.TimeArrived;
database.ArrivalTimes.InsertOnSubmit(result);
}
database.SubmitChanges();
}
}
private void detach_ArrivalTimes(ArrivalTime entity)
{
this.SendPropertyChanging();
entity.Restaurant = null;
}
partial void UpdateArrivalTime(ArrivalTime instance);
partial void DeleteArrivalTime(ArrivalTime instance);
partial void InsertArrivalTime(ArrivalTime instance);
