public bool CreateTasting(TastingCreate model) { var beer = new Beer() { BeerName = model.BeerName, Style = model.Style, Cost = model.Cost, ABV = model.ABV, Vintage = model.Vintage, }; var brewery = new Brewery() { BreweryName = model.BreweryName, BrewLocCity = model.BrewLocCity, BrewLocState = model.BrewLocState, }; var ctx = new ApplicationDbContext(); ctx.Beers.Add(beer); ctx.Breweries.Add(brewery); ctx.SaveChanges(); var beerID = ctx.Beers.OrderByDescending(p => p.BeerID).FirstOrDefault().BeerID; var breweryID = ctx.Breweries.OrderByDescending(p => p.BreweryID).FirstOrDefault().BreweryID; var tasting = new Tasting() { BeerID = beerID, BeerName = model.BeerName, BreweryName = model.BreweryName, BreweryID = breweryID, DateOfTasting = model.DateOfTasting, DateAdded = DateTime.Now, Rating = model.Rating, Comment = model.Comment, }; { ctx.Tastings.Add(tasting); if (ctx.SaveChanges() == 1) { AverageRating(beer.BeerName); AverageBreweryRating(brewery.BreweryName); return(true); } return(false); } }
public ActionResult Create(TastingCreate model) { if (!ModelState.IsValid) { return(View(model)); } var service = new TastingService(); if (service.CreateTasting(model)) { return(RedirectToAction("Index")); } ModelState.AddModelError("", "This review could not be added"); return(View(model)); }
public bool CreateTasting(TastingCreate model) { var entity = new Tasting() { OwnerId = _userId, TastingId = model.TastingId, TastingDate = model.TastingDate, Title = model.Title, Host = model.Host, CreatedUtc = DateTimeOffset.Now }; using (var ctx = new ApplicationDbContext()) { ctx.Tastings.Add(entity); return(ctx.SaveChanges() == 1); } }
public ActionResult Create(TastingCreate model) { if (!ModelState.IsValid) { return(View(model)); } var service = CreateTastingService(); if (service.CreateTasting(model)) { TempData["SaveResult"] = "Your Tasting was created."; return(RedirectToAction("Index")); } ; ModelState.AddModelError("", "Tasting could not be created."); return(View(model)); }