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));
}
