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();
}
}
public List<RestaurantData> GetRestaurants()
{
using (var database = new DataClassesDataContext())
{
return database.Restaurants.Select(r => new RestaurantData(r)).ToList();
}
}
public List<StatisticData> GetStatistics()
{
using (var database = new DataClassesDataContext())
{
return database.Statistics
.OrderBy(s => s.Name)
.Select(s => new StatisticData(s))
.ToList();
}
}
public StatisticData GetStatistic(string restaurant)
{
using (var database = new DataClassesDataContext())
{
return database.Statistics
.Where(s => s.Name == restaurant)
.Select(s => new StatisticData(s))
.First();
}
}
public List<TimeSpan> GetArrivalTimes(string restaurant)
{
using (var database = new DataClassesDataContext())
{
return database.ArrivalTimes
.Where(at => at.Restaurant.Name == restaurant)
.Select(at => at.Time.Value)
.ToList();
}
}