public static void UpdateBeer(Beer beerToUpdate, string newstyle, string newdistributor, string newbrewery) { using (AvalonContext context = new AvalonContext()) { context.Beers.Attach(beerToUpdate); context.Entry(beerToUpdate).Reference(o => o.Style).Load(); context.Entry(beerToUpdate).Reference(o => o.Brewery).Load(); context.Entry(beerToUpdate).Reference(o => o.Distributor).Load(); if (newstyle != String.Empty) { Style newStyle = context.Styles.Where(s => s.Name == newstyle).Include("Beers").FirstOrDefault(); beerToUpdate.Style = newStyle; beerToUpdate.StyleId = newStyle.Id; } if (newdistributor != String.Empty) { Distributor newDistributor = context.Distributors.Where(s => s.Name == newdistributor).Include("Breweries").Include("Beers").FirstOrDefault(); beerToUpdate.Distributor = newDistributor; beerToUpdate.DistributorId = newDistributor.Id; } if (newbrewery != String.Empty) { Brewery newBrewery = context.Breweries.Where(s => s.Name == newbrewery).Include("Beers").Include("Distributors").FirstOrDefault(); beerToUpdate.Brewery = newBrewery; beerToUpdate.BreweryId = newBrewery.Id; } context.Entry(beerToUpdate).State = EntityState.Modified; context.SaveChanges(); } }
public static void UpdateClient(Customer client) { using (var db = new AvalonContext()) { db.Entry(client).State = EntityState.Modified; db.SaveChanges(); } }