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