public BeerModel SearchBeers(string name, int currentPageIndex, int?elementsPerPage) { if (elementsPerPage == null) { elementsPerPage = 8; } BeerModel beerModel = new BeerModel(); if (currentPageIndex == 0) { currentPageIndex = 1; } beerModel.Beers = (from customer in this.context.BeerRating select customer) .Where(x => x.Company.ToLower().Contains(name.ToLower()) || x.Name.ToLower().Contains(name.ToLower())) .OrderBy(x => x.BeerId) .Skip((currentPageIndex - 1) * elementsPerPage.Value) .Take(elementsPerPage.Value).ToList(); double pageCount = (double)((decimal)beerModel.Beers.Count() / Convert.ToDecimal(elementsPerPage)); beerModel.PageCount = (int)Math.Ceiling(pageCount); beerModel.CurrentPageIndex = currentPageIndex; return(beerModel); }
public BeerModel GetBeerDetail(int beerId) { try { using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand(@"SELECT * FROM Beer WHERE BeerId = @beerId", conn); cmd.Parameters.AddWithValue("@beerId", beerId); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { BeerModel beer = BeerReader(reader); return(beer); } } } catch (SqlException ex) { throw ex; } return(null); }
/// <summary> /// Retrieves beers. /// The query append should start with " " or ";". /// </summary> /// <param name="append"></param> /// <returns></returns> public IList <BeerModel> RetrieveBeers(string append) { string query = "SELECT * FROM Beers" + append; List <BeerModel> list = new List <BeerModel>(); lock (CONN_LOCK) { // dr[3] might have type DBNull. In this case, an InvalidCastException will be thrown. try { CONN.Open(); NpgsqlCommand command = new NpgsqlCommand(query, CONN); NpgsqlDataReader dr = command.ExecuteReader(); while (dr.Read()) { BeerModel beer = new BeerModel((int)dr[0], (bool)dr[1], (int)dr[2]); list.Add(beer); } } catch (NpgsqlException ex) { throw ex; } finally { CONN.Close(); } } return(list); }
/// <summary> /// /// </summary> /// <param name="beerModel"></param> /// <returns></returns> public async Task <BeerModel> Update(BeerModel beerModel) { var beerEntity = _mapper.Map <Beer>(beerModel); var beerAdded = await _beerDal.UpdateAsync(beerEntity); return(_mapper.Map <BeerModel>(beerAdded)); }
public List <BeerModel> GetBreweryBeers(int breweryId) { try { List <BeerModel> results = new List <BeerModel>(); using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand(@"SELECT * FROM Beer JOIN Brewery ON Brewery.BreweryId = Beer.BreweryId WHERE Brewery.BreweryId = @breweryId", conn); cmd.Parameters.AddWithValue("@breweryId", breweryId); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { BeerModel beer = BeerReader(reader); results.Add(beer); } return(results); } } catch (SqlException ex) { throw ex; } }
public IList <BeerModel> GetAllBeers() { List <BeerModel> beers = new List <BeerModel>(); // Use SQL Reader to get a list of all brewery models try { using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand(@"SELECT * FROM Beer", conn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { BeerModel beer = BeerReader(reader); beers.Add(beer); } } } catch (SqlException ex) { throw ex; } return(beers); }
public BeerModel UpdateBeer(BeerModel beer) { var entity = Beers.FirstOrDefault(b => b.Id.Equals(beer.Id.Value)); if (entity == null) { return(null); } var newEntity = new Beer { Id = beer.Id.Value, CreatedAt = beer.CreatedAt.Value, LastUpdate = beer.LastUpdate.Value, Label = beer.Label.Value, Description = beer.Description.Value, Stock = beer.Stock.Value }; Beers.Remove(entity); Beers.Add(newEntity); return(new BeerModel( newEntity.Id, newEntity.CreatedAt, newEntity.LastUpdate, newEntity.Label, newEntity.Description, newEntity.Stock )); }
public ActionResult DeleteConfirmed(int id) { BeerModel beerModel = db.BeerModels.Find(id); db.BeerModels.Remove(beerModel); db.SaveChanges(); return(RedirectToAction("Index")); }
public Task <int> InsertBeer(BeerModel beer) { string query = @"insert into dbo.BEER (name, description, color, style, abv) values (@name, @description, @color, @style, @abv); select cast(scope_identity() as int)"; return(_db.SaveData <int, BeerModel>(query, beer)); }
public ListDemo() { Model = new BeerModel (); X = 2; Y = 1; Width = Console.BufferWidth - 4; Height = Console.BufferHeight - 2; HasFocus = true; }
public ActionResult DeleteCategory(int id) { using (var entities = new BeerModel()) { var category = entities.Categories.FirstOrDefault(x => x.Id == id); entities.Categories.Remove(category); entities.SaveChanges(); return(RedirectToAction("Index")); } }
public ActionResult Edit([Bind(Include = "Id,Name,Type,Brewery")] BeerModel beerModel) { if (ModelState.IsValid) { db.Entry(beerModel).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(beerModel)); }
public ActionResult Create([Bind(Include = "Id,Name,Type,Brewery")] BeerModel beerModel) { if (ModelState.IsValid) { db.BeerModels.Add(beerModel); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(beerModel)); }
public JsonResult GetMoreInfo(int id) { using (var db = new BeerModel()) { var mod = db.Products.FirstOrDefault(x => x.Id == id); var model = new ViewModels.ViewSingleProductViewModel(); model.DeliveryTime = mod.DeliveryTime; model.UnitsInStock = mod.UnitsInStock; return(Json(model, JsonRequestBehavior.AllowGet)); } }
public async Task <IActionResult> Post(BeerModel beerModel) { if (ModelState.IsValid) { var beerResult = await _beerService.Add(beerModel); return(new CreatedAtRouteResult("Get", new { id = beerResult.BeerId })); } return(new BadRequestObjectResult(ModelState)); }
public bool UpdateBeer(BeerModel beer) { var beerToUpdate = GetBeer(beer.Id); beerToUpdate.Name = beer.Name ?? beerToUpdate.Name; beerToUpdate.Type = beer.Type ?? beerToUpdate.Type; beerToUpdate.alcoholPorcentage = beer.alcoholPorcentage ?? beerToUpdate.alcoholPorcentage; beerToUpdate.Price = beer.Price ?? beerToUpdate.Price; beerToUpdate.soldAmount = beerToUpdate.soldAmount; return(true); }
private void listViewLocations_SelectionChanged_1(object sender, SelectionChangedEventArgs e) { BeerModel place = (BeerModel)listViewLocations.SelectedItem; if (place != null && place.imagecount != "0") { textBlockNoImage.Visibility = Visibility.Collapsed; } else { textBlockNoImage.Visibility = Visibility.Visible; } }
// GET: Beer/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } BeerModel beerModel = db.BeerModels.Find(id); if (beerModel == null) { return(HttpNotFound()); } return(View(beerModel)); }
public IActionResult Put(int id, [FromBody] BeerModel beerModel) { try { Beer beer = beerModel.ToEntity(); beer.Id = id; logic.Update(beer); return(Ok()); } catch (Exception e) { return(NotFound(e.Message)); } }
public ActionResult SearchResult(string sortOrder, string searchProduct) { var viewmodel = new ShowAllProductsViewModel(); viewmodel.Search = searchProduct; using (var db = new BeerModel()) { viewmodel.ProductsList.AddRange(db.Products.Where(x => x.Description.ToUpper().Contains(searchProduct.ToUpper()) || x.Name.ToUpper().Contains(searchProduct.ToUpper()))); viewmodel = Sort(sortOrder, viewmodel); return(View(viewmodel)); } }
public ActionResult <BeerModel> UpdateBeer(int breweryId, int beerId, [FromBody] BeerModel beer) { try { return(Ok(_beerService.UpdateBeer(breweryId, beerId, beer))); } catch (NotFoundOperationException ex) { return(NotFound(ex.Message)); } catch (Exception ex) { return(StatusCode(StatusCodes.Status500InternalServerError, $"Something happend: {ex.Message}")); } }
public ActionResult <BeerModel> CreateBeer(int breweryId, [FromBody] BeerModel beer) { try { var beerCreated = _beerService.CreateBeer(breweryId, beer); return(CreatedAtRoute("GetBeer", new { breweryId = breweryId, videogameId = beerCreated.Id }, beerCreated)); } catch (NotFoundOperationException ex) { return(NotFound(ex.Message)); } catch (Exception ex) { return(StatusCode(StatusCodes.Status500InternalServerError, $"Something happend: {ex.Message}")); } }
public BeerModel AddBeer(BeerModel beer) { var entity = new Beer { Id = beer.Id.Value, CreatedAt = beer.CreatedAt.Value, LastUpdate = beer.LastUpdate.Value, Label = beer.Label.Value, Description = beer.Description.Value, Stock = beer.Stock.Value }; Beers.Add(entity); return(beer); }
//beers public BeerModel CreateBeer(BeerModel beer) { int newId; var lastBeer = beers.OrderByDescending(b => b.Id).FirstOrDefault(); if (lastBeer == null) { newId = 1; } else { newId = lastBeer.Id + 1; } beer.Id = newId; beers.Add(beer); return(beer); }
public void PutBeerOk() { var logicMock = new Mock <IBeerLogic>(MockBehavior.Strict); BeerController controller = new BeerController(logicMock.Object); BeerModel beerModel = new BeerModel() { BeerFactoryId = 1, Description = "Prueba", Name = "Prueba", Qualification = 1 }; logicMock.Setup(x => x.Update(It.IsAny <Beer>())); var result = controller.Put(1, beerModel); var okResult = result as OkObjectResult; logicMock.VerifyAll(); }
public IActionResult Post([FromBody] CreateBeerAction action) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var beer = new BeerModel { Id = _database.Count + 1, Brand = action.Brand, Type = action.Type, Quantity = action.Quantity, }; _database.TryAdd(beer.Id, beer); return(CreatedAtAction(nameof(Get), new { id = beer.Id }, beer)); }
/// <summary> /// Returns A List Of Users 'Favorite' Beer Names /// </summary> /// <param name="userId">User's Unique GUID</param> /// <returns>List Of Beer Names That User Has Given High Ratings</returns> public List <BeerModel> GetUserFavoriteBeerNames(string guid) { List <BeerModel> result = new List <BeerModel>(); try { // Get All Beer Ratings For The User's GUID using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand(@"SELECT Beer.BeerID, Beer.BreweryId, Beer.BeerName, BeerRating.UserId, BeerRating.BeerRating FROM Beer JOIN BeerRating ON BeerRating.BeerID = BeerRating.BeerID WHERE UserId = @user AND Beer.BeerID = BeerRating.BeerId AND BeerRating > 3", conn); cmd.Parameters.AddWithValue("@user", guid); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { BeerModel beer = new BeerModel(); beer.BeerId = (Convert.ToInt32(reader["BeerID"])); beer.BreweryId = (Convert.ToInt32(reader["BreweryId"])); beer.BeerName = (Convert.ToString(reader["BeerName"])); result.Add(beer); } } } catch (SqlException ex) { Console.WriteLine(ex.Message); } return(result); }
public void PostBeerOk() { var logicMock = new Mock <IBeerLogic>(MockBehavior.Strict); BeerController controller = new BeerController(logicMock.Object); BeerModel beerModel = new BeerModel() { BeerFactoryId = 1, Description = "Prueba", Name = "Prueba", Qualification = 1 }; logicMock.Setup(x => x.Add(It.IsAny <Beer>(), 1)).Returns(It.IsAny <Beer>()); var result = controller.Post(beerModel); var okResult = result as OkObjectResult; var value = okResult.Value as Beer; logicMock.VerifyAll(); }
public IActionResult Index() { List <Beer> beerList = _beerService.GetAll(); List <BeerModel> beerModeList = new List <BeerModel>(); foreach (Beer beer in beerList) { float[] ratings = _beerService.GetRating(beer.ID); beer.Rating = ratings[1] / ratings[0]; beer.TimesRated = Convert.ToInt32(ratings[0]); if (ratings[1] != 0) { _beerService.UpdateRating(ratings); } Brewery brewery = _breweryService.GetOne(beer.BreweryID); BeerModel beerModel = new BeerModel(beer, brewery); beerModeList.Add(beerModel); } return(View(beerModeList)); }
public BeerModel GetBeers(int currentPageIndex, int?elementsPerPage) { if (elementsPerPage == null) { elementsPerPage = 8; } BeerModel beerModel = new BeerModel(); beerModel.Beers = this.context.BeerRating.Where(x => x.IsApproved == true) .OrderBy(x => x.BeerId) .Skip((currentPageIndex - 1) * elementsPerPage.Value) .Take(elementsPerPage.Value).ToList(); double pageCount = (double)((decimal)this.context.Beer.Count() / Convert.ToDecimal(elementsPerPage)); beerModel.PageCount = (int)Math.Ceiling(pageCount); beerModel.CurrentPageIndex = currentPageIndex; return(beerModel); }
public void PutBeerNotExist() { var logicMock = new Mock <IBeerLogic>(MockBehavior.Strict); BeerController controller = new BeerController(logicMock.Object); BeerModel beerModel = new BeerModel() { BeerFactoryId = 1, Description = "Prueba", Name = "Prueba", Qualification = 1 }; logicMock.Setup(x => x.Update(It.IsAny <Beer>())).Throws(new Exception()); var result = controller.Put(1, beerModel); var okResult = result as NotFoundObjectResult; logicMock.VerifyAll(); Assert.AreEqual(404, okResult.StatusCode); }