public HttpResponseMessage PostBeerRating(BeerRatings beerRating)
{
try
{
if (!ModelState.IsValid)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, ModelState));
}
db.BeerRatings.Add(beerRating);
db.SaveChanges();
var allRatings = db.BeerRatings.Where(r => r.BeerId == beerRating.BeerId).Select(r => r.Rating).ToList();
double averageRating = allRatings.Average();
var beer = db.Beers.FirstOrDefault(b => b.Id == beerRating.BeerId);
if (beer != null)
{
beer.AverageRatings = averageRating;
}
db.Entry(beer).State = EntityState.Modified;
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.Accepted, beer));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, ex));
}
}
public ActionResult Create([Bind(Include = "Beer,NewManufacturer,NewType")] CreateBeerViewModel newBeer)
{
if (ModelState.IsValid)
{
if (!String.IsNullOrEmpty(newBeer.NewManufacturer))
{
Manufacturer manufacturer = new Manufacturer
{
Name = newBeer.NewManufacturer
};
context.Manufacturers.Add(manufacturer);
context.SaveChanges();
newBeer.Beer.Manufacturer = manufacturer;
}
else
{
Manufacturer manufacturer = context.Manufacturers.Find(newBeer.Beer.ManufacturerID);
newBeer.Beer.Manufacturer = manufacturer;
}
newBeer.Beer.Type = newBeer.Beer.Type == "Create New" ? newBeer.NewType : newBeer.Beer.Type;
context.Beers.Add(newBeer.Beer);
context.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(newBeer));
}
public void Delete(int?id)
{
Brewery brew = db.Breweries.Find(id);
db.Breweries.Remove(brew);
db.SaveChanges();
}
public void Delete(int?id)
{
Beer b = db.Beers.Find(id);
db.Beers.Remove(b);
db.SaveChanges();
}
public void Delete(int?id)
{
SalesOrder so = db.SalesOrders.Find(id);
db.SalesOrders.Remove(so);
db.SaveChanges();
}
public IActionResult PutBeer([FromRoute] long id, [FromBody] Beer beer)
{
lock (Locks.orderLock)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (String.IsNullOrEmpty(beer.Name) ||
!beer.StyleId.HasValue ||
!beer.BreweryId.HasValue ||
!beer.Stock.HasValue ||
!beer.ResourceVersion.HasValue ||
beer.Stock.Value < 0)
{
return(BadRequest());
}
if (id != beer.Id)
{
beer.Id = id;
}
_context.Entry(beer).State = EntityState.Modified;
try
{
_context.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!BeerExists(id))
{
return(NotFound());
}
else
{
return(Conflict());
}
}
beer.ResourceVersion++;
_context.Entry(beer).State = EntityState.Modified;
try
{
_context.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
throw;
}
return(NoContent());
}
}
public static async void FetchData()
{
// REMOVE FOR PERSISTENT Data
Context.Database.EnsureDeleted();
// Ensure the Database is Created
Context.Database.EnsureCreated();
// Set URL of api Manager to point to the Brands API
// Load the Brands that Validate into the Local Storage
List <Brand> brands = await APIManager.GetBrandsAsync();
try
{
Context.Brand.AttachRange(brands);
Context.Brand.AddRange(brands);
}
catch (DbUpdateException exception)
{
Debug.WriteLine(exception.Message);
Context.Brand.UpdateRange(brands);
}
finally
{
Context.ChangeTracker.DetectChanges();
Context.SaveChanges();
}
// Load the Beverages that Validate into the Local Storage
List <Beverage> beverages = await APIManager.GetBeveragesAsync();
try
{
Context.Beverage.AttachRange(beverages);
Context.Beverage.AddRange(beverages);
}
catch (DbUpdateException exception)
{
Debug.WriteLine(exception.Message);
Context.Beverage.UpdateRange(beverages);
}
finally
{
Context.ChangeTracker.DetectChanges();
Context.SaveChanges();
}
// Release database resources
//Context?.Dispose();
}
public ActionResult Create([Bind(Include = "SlodID,NazwaSlodu,Barwa,Ekstraktywnosc")] Slod slod)
{
if (ModelState.IsValid)
{
db.Slody.Add(slod);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(slod));
}
public ActionResult Create([Bind(Include = "ID,Name,EmailAddress,FacebookUser,PermissionGroup")] User user)
{
if (ModelState.IsValid)
{
context.Users.Add(user);
context.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(user));
}
public ActionResult Create([Bind(Include = "StylID,NazwaStylu,Kod,OGmin,OGmax,FGmin,FGmax,ABVmin,ABVmax,IBUmin,IBUmax,EBCmin,EBCmax")] Styl styl)
{
if (ModelState.IsValid)
{
db.Style.Add(styl);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(styl));
}
public ActionResult Create([Bind(Include = "SupplierId,CompanyName,CompanyAddress,CompanyEmail,CompanyPhoneNumber")] Supplier supplier)
{
if (ModelState.IsValid)
{
db.Suppliers.Add(supplier);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(supplier));
}
public ActionResult Create([Bind(Include = "ID,Name,Brewery,Country,Type,Percent,Sorting")] Beer beer)
{
if (ModelState.IsValid)
{
db.Beers.Add(beer);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(beer));
}
public ActionResult Create([Bind(Include = "DrozdzeID,NazwaDrozdzy,Flokulacja,Fermentacja,Tolerancja,Odfermentowanie")] Drozdze drozdze)
{
if (ModelState.IsValid)
{
db.Drozdze.Add(drozdze);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(drozdze));
}
public ActionResult Create([Bind(Include = "DocumentTypeId,Description")] DocumentType documentType)
{
if (ModelState.IsValid)
{
db.DocumentTypes.Add(documentType);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(documentType));
}
public ActionResult Create([Bind(Include = "ChmielID,NazwaChmielu,AlfaKwasy")] Chmiel chmiel)
{
if (ModelState.IsValid)
{
db.Chmiele.Add(chmiel);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(chmiel));
}
public ActionResult Create([Bind(Include = "SalesOrderID,Units,TotalPrice,Brewery_BreweryId")] SalesOrder salesOrder)
{
if (ModelState.IsValid)
{
db.SalesOrders.Add(salesOrder);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Brewery_BreweryId = new SelectList(db.Breweries, "BreweryId", "Name", salesOrder.Brewery_BreweryId);
return(View(salesOrder));
}
public ActionResult Create([Bind(Include = "CustomerId,Identification,Name,LastName,Address,Email,PhoneNumber,DocumentTypeId")] Customer customer)
{
if (ModelState.IsValid)
{
db.Customers.Add(customer);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DocumentTypeId = new SelectList(db.DocumentTypes, "DocumentTypeId", "Description", customer.DocumentTypeId);
return(View(customer));
}
public ActionResult Create([Bind(Include = "EmployeeId,FirstName,LastName,Salary,DateOfBirth,StartTime,Email,DocumentTypeId,Document")] Employee employee)
{
if (ModelState.IsValid)
{
db.Employees.Add(employee);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DocumentTypeId = new SelectList(db.DocumentTypes, "DocumentTypeId", "Description", employee.DocumentTypeId);
return(View(employee));
}
public ActionResult Create([Bind(Include = "ID,UserID,BeerID,Score,Comment")] Rating rating)
{
if (ModelState.IsValid)
{
db.Ratings.Add(rating);
db.SaveChanges();
return(RedirectToAction("Index", "Home"));
}
ViewBag.BeerID = new SelectList(db.Beers, "ID", "Name", rating.BeerID);
ViewBag.UserID = new SelectList(db.Users, "ID", "Username", rating.UserID);
return(View(rating));
}
public ActionResult Create([Bind(Include = "ProductId,ProductCode,ProductName,Price,Stock,Image")] Product product)
{
HttpPostedFileBase http = Request.Files[0];
WebImage webImage = new WebImage(http.InputStream);
product.Image = webImage.GetBytes();
if (ModelState.IsValid)
{
db.Products.Add(product);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(product));
}
public ActionResult Edit(BeerViewModel beerViewModel)
{
if (ModelState.IsValid)
{
using (var beerContext = new BeerContext())
{
var beerToUpdate = beerContext.Beers.SingleOrDefault(b => b.BeerId == beerViewModel.BeerId);
if (beerToUpdate != null)
{
beerToUpdate.BeerName = beerViewModel.BeerName;
beerToUpdate.WhereTried = beerViewModel.WhereTried;
beerToUpdate.WhenTried = beerViewModel.WhenTried;
beerToUpdate.BeerStyleId = beerViewModel.BeerStyleId;
beerToUpdate.Country = beerViewModel.Country;
beerToUpdate.PercentABV = beerViewModel.PercentABV;
beerToUpdate.Rating = beerViewModel.Rating;
beerToUpdate.Description = beerViewModel.Description;
beerContext.SaveChanges();
return(RedirectToAction("Index"));
}
}
}
return(new HttpNotFoundResult());
}
protected override void Down(MigrationBuilder migrationBuilder)
{
using (var db = new BeerContext())
{
db.Orders.RemoveRange(db.Orders);
db.Clients.RemoveRange(db.Clients);
db.Beers.RemoveRange(db.Beers);
db.SaveChanges();
}
}
public ActionResult Create([Bind(Include = "ID,Username")] User user)
{
if (ModelState.IsValid)
{
var existing = db.Users.FirstOrDefault(u => u.Username.Equals(user.Username));
if (existing == null)
{
db.Users.Add(user);
db.SaveChanges();
}
else
{
user = existing;
}
CreateCookie(user);
return(RedirectToAction("Index", "Home"));
}
return(View(user));
}
public IActionResult PostOrder([FromRoute] long id, [FromRoute] long orderId)
{
lock (Locks.orderLock)
{
var user = _context.Users
.Include(u => u.Cart)
.Include(u => u.Cart.CartItems)
.SingleOrDefault(m => m.Id == id);
if (user == null ||
!user.Cart.CartItems.Any())
{
return(NotFound());
}
var cartBeerIds = user.Cart.CartItems.Select(c => c.BeerId);
var beers = _context.Beers.Where(b => cartBeerIds.Contains(b.Id));
bool correctOrder;
try
{
correctOrder = orderId == user.Cart.OrderId &&
user.Cart.CartItems.All(c =>
beers.First(b => b.Id == c.BeerId).Stock >= c.Count);
}
catch (InvalidOperationException)
{
return(Conflict());
}
if (!correctOrder)
{
return(Conflict());
}
foreach (var cartItem in user.Cart.CartItems)
{
var beer = beers.First(b => b.Id == cartItem.BeerId);
beer.Stock -= cartItem.Count;
_context.Entry(beer).State = EntityState.Modified;
_context.Entry(cartItem).State = EntityState.Deleted;
}
user.Cart.OrderId++;
_context.Entry(user.Cart).State = EntityState.Modified;
_context.SaveChanges();
return(NoContent());
}
}
public ActionResult Create([Bind(Include = "BeerID,Brew,NewWaterType,NewFermentableType,Variables")] CreateBrewViewModel newBrew)
{
if (ModelState.IsValid)
{
newBrew.Brew.Variables.WaterType =
newBrew.Brew.Variables.WaterType == "Create New" ? newBrew.NewWaterType : newBrew.Brew.Variables.WaterType;
newBrew.Brew.Variables.FermentableType =
newBrew.Brew.Variables.FermentableType == "Create New" ? newBrew.NewFermentableType : newBrew.Brew.Variables.FermentableType;
newBrew.Brew.CreatedDate = DateTime.Now;
User jim = context.Users.Find(1);
newBrew.Brew.CreatedBy = jim;
Beer beer = context.Beers.Find(newBrew.BeerID);
beer.Brews.Add(newBrew.Brew);
context.SaveChanges();
return(RedirectToAction("Details", "Beers", new { id = beer.ID }));
}
return(View(newBrew));
}
public ActionResult Delete(int id)
{
using (var beerContext = new BeerContext())
{
var beerToDelete = beerContext.Beers.SingleOrDefault(b => b.BeerId == id);
if (beerToDelete != null)
{
beerContext.Beers.Remove(beerToDelete);
beerContext.SaveChanges();
}
return(RedirectToAction("Index"));
}
}
public ActionResult Create(Beer beer)
{
if (ModelState.IsValid)
{
using (var beerContext = new BeerContext())
{
ViewBag.BeerStyles = beerContext.BeerStyles.Select(b => new SelectListItem
{
Value = b.BeerStyleId.ToString(),
Text = b.StyleOfBeer
}).ToList();
beerContext.Beers.Add(beer);
beerContext.SaveChanges();
return(RedirectToAction("Index"));
}
}
return(View(beer));
}
private void Seed()
{
using var context = new BeerContext(ContextOptions);
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
ProductDto one = new ProductDto {
ProductNo = "P001", Category = "Beer", EAN = "1", Name = "Name 1 Beer"
};
ProductDto two = new ProductDto {
ProductNo = "P002", Category = "Beer", EAN = "1", Name = "Name 2 Beer"
};
ProductDto three = new ProductDto {
ProductNo = "P003", Category = "Beer", EAN = "1", Name = "Name 3 Beer"
};
var productTranslator = new ProductTranslator();
context.Products.AddRange(productTranslator.ToModel(one), productTranslator.ToModel(two), productTranslator.ToModel(three));
context.SaveChanges();
}
public Beer Add(AddBeerCommand command)
{
var brewer = _context.Brewers.SingleOrDefault(brewer => brewer.Id == command.BrewerId);
if (brewer == null)
{
throw new CustomBadRequestException("Brewer does not exist");
}
var beer = new Beer
{
AlcoholLevel = command.AlcoholLevel,
Name = command.Name,
Price = command.Price,
IsActive = true,
Brewer = brewer
};
_context.Beers.Add(beer);
_context.SaveChanges();
return(beer);
}
public void SaveChanges()
{
_context.SaveChanges();
}