public ActionResult Edit(List <int> BarId, string BeerName, string BeerBreweryName, string BeerStyle, string BeerAbv, int BeerIbu, int id) { BeerDetailsViewModel viewModel = new BeerDetailsViewModel(_db, id); viewModel.CurrentBeer.BeerName = BeerName; viewModel.CurrentBeer.BeerBreweryName = BeerBreweryName; viewModel.CurrentBeer.BeerStyle = BeerStyle; viewModel.CurrentBeer.BeerAbv = Convert.ToDouble(BeerAbv); viewModel.CurrentBeer.BeerIbu = BeerIbu; var beersToRemove = _db.Taplists.Where(entry => entry.BeerId == id).ToList(); foreach (var beer in beersToRemove) { if (beer != null) { _db.Taplists.Remove(beer); } } foreach (var barId in BarId) { Bar bar = _db.Bars.FirstOrDefault(item => item.BarId == barId); Taplist newTaplist = new Taplist(id, bar.BarId); _db.Taplists.Add(newTaplist); } _db.SaveChanges(); return(RedirectToAction("Details", new { id = viewModel.CurrentBeer.BeerId })); }
public ActionResult Edit(Bar bar, List <int> BeerId, string BarName, string BarRating, string BarWebsite, string BarStreet, string BarCity, string BarState, string BarZip, string BarPhone, string BarLatitude, string BarLongitude, string BarNeighborhood, int id) { BarDetailsViewModel viewModel = new BarDetailsViewModel(_db, id); viewModel.CurrentBar.BarName = BarName; viewModel.CurrentBar.BarRating = int.Parse(BarRating); viewModel.CurrentBar.BarWebsite = BarWebsite; viewModel.CurrentBar.BarStreet = BarStreet; viewModel.CurrentBar.BarCity = BarCity; viewModel.CurrentBar.BarState = BarState; viewModel.CurrentBar.BarZip = BarZip; viewModel.CurrentBar.BarPhone = BarPhone; viewModel.CurrentBar.BarLatitude = Convert.ToDouble(BarLatitude); viewModel.CurrentBar.BarLongitude = Convert.ToDouble(BarLongitude); viewModel.CurrentBar.BarNeighborhood = BarNeighborhood; var barsToRemove = _db.Taplists.Where(entry => entry.BarId == id).ToList(); foreach (var bars in barsToRemove) { if (bars != null) { _db.Taplists.Remove(bars); } } foreach (int beerId in BeerId) { Taplist newTaplist = new Taplist(beerId, viewModel.CurrentBar.BarId); _db.Taplists.Add(newTaplist); } _db.SaveChanges(); return(RedirectToAction("Details", new { id = viewModel.CurrentBar.BarId })); }
public ActionResult Delete(int id) { Beer beer = _db.Beers.FirstOrDefault(beers => beers.BeerId == id); Taplist joinEntry = _db.Taplists.FirstOrDefault(entry => entry.BeerId == id); if (joinEntry != null) { _db.Taplists.Remove(joinEntry); } _db.Beers.Remove(beer); _db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Create(Beer beer, List <int> BarId) { _db.Beers.Add(beer); foreach (int barId in BarId) { Taplist newTaplist = new Taplist(beer.BeerId, barId); _db.Taplists.Add(newTaplist); } _db.SaveChanges(); return(RedirectToAction("Index")); }