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