public static void PutBeersToDatabase(MenuContext context, int selectedVenueId, List <ParsedBeer> beersToBeAdded)
{
// TODO: probably better way to do this..
List <ParsedVenue> venue = context.Venues
.Where(v => v.VenueID == selectedVenueId)
.ToList();
// Add menu only if venue found from DB with venueID
if (venue.Count > 0)
{
ParsedVenue selectedVenue = venue[0];
List <Menu> menus = new List <Menu> {
};
foreach (var beer in beersToBeAdded)
{
// TODO: Do I need to also check if venue exists to avoid duplicate key error?
var existingBeer = context.Beers.Find(beer.BeerID);
if (existingBeer == null)
{
context.Add(new Menu {
ParsedVenue = selectedVenue, ParsedBeer = beer
});
}
else
{
context.Entry(existingBeer).CurrentValues.SetValues(beer);
}
}
context.SaveChanges();
}
}
public static async Task <object> PutVenuesToDatabase(MenuContext context, List <ParsedVenue> venues)
{
context.AddRange(venues);
context.SaveChanges();
return(null);
}
