public IActionResult Add(int id, [FromBody] AddBeerModel model)
{
// map model to entity
var beer = _mapper.Map <Beer>(model);
if (User.Identity.Name == null)
{
return(BadRequest(new { message = "User token error" }));
}
if (User.Identity.Name != id.ToString())
{
return(BadRequest(new { message = "Attempted to add beer to a different user" }));
}
beer.UserId = int.Parse(User.Identity.Name);
try
{
// create Beer
_beerService.Add(beer);
return(Ok());
}
catch (AppException ex)
{
// return error message if there was an exception
return(BadRequest(new { message = ex.Message }));
}
}
public void AddNewBeer(AddBeerModel beer)
{
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(@"INSERT INTO Beer (BreweryId, BeerName, BeerTypeId, BeerDescription, ABV, IBU, DateBrewed, BeerLabelImg)
VALUES ((SELECT Brewery.BreweryId FROM Brewery
WHERE Brewery.BreweryName = @breweryName),
@beerName,
(SELECT BeerTypes.BeerTypeId FROM BeerTypes
WHERE BeerTypes.BeerType = @beerTypeName), @beerDescription, @abv, @ibu, @dateBrewed, @beerLabelImg)", conn);
cmd.Parameters.AddWithValue("@breweryName", beer.BreweryName);
cmd.Parameters.AddWithValue("@beerName", beer.BeerName);
cmd.Parameters.AddWithValue("@beerTypeName", beer.BeerTypeName);
cmd.Parameters.AddWithValue("@beerDescription", beer.BeerDescription);
cmd.Parameters.AddWithValue("@abv", beer.ABV);
cmd.Parameters.AddWithValue("@ibu", beer.IBU);
cmd.Parameters.AddWithValue("@dateBrewed", beer.DateBrewed);
cmd.Parameters.AddWithValue("@beerLabelImg", beer.BeerLabelImg);
cmd.ExecuteNonQuery();
}
}
catch (SqlException ex)
{
Console.WriteLine(ex);
}
}
public bool AddNewBeer(AddBeerModel newBeer, string photoname)
{
//add image later
string SQL_AddBeer = "Insert into beers (name, description, abv, beer_type, brewery_id) Values(@Name, @Description, @AlcoholByVolume, @BeerType, @brewId);";
int beerID = 0;
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(SQL_AddBeer + _getLastIdSQL, conn);
cmd.Parameters.Add(new SqlParameter("@Name", newBeer.Name));
cmd.Parameters.Add(new SqlParameter("@Description", newBeer.Description));
//cmd.Parameters.Add(new SqlParameter("@image", newBeer.Image));
cmd.Parameters.Add(new SqlParameter("@AlcoholByVolume", newBeer.AlcoholByVolume));
cmd.Parameters.Add(new SqlParameter("@BeerType", newBeer.BeerType));
cmd.Parameters.Add(new SqlParameter("@brewId", newBeer.BreweryId));
beerID = (int)cmd.ExecuteScalar();
}
string picsetup = "insert into beerPhotos values(@photoname, @beerid,@breweryid)";
if (photoname == null)
{
photoname = "defaultPhoto.jpg";
}
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(picsetup, conn);
cmd.Parameters.AddWithValue("@photoname", photoname);
cmd.Parameters.AddWithValue("@beerid", beerID);
cmd.Parameters.AddWithValue("@breweryid", newBeer.BreweryId);
cmd.ExecuteNonQuery();
}
return(true);
}
public ActionResult AddBeer(AddBeerModel b, int brewId, string beertypes, HttpPostedFileBase photo)
{
if (beertypes != "null")
{
b.BeerType = beertypes;
}
//This first check redirects the user to the home page if they are not a brewer
if (Session["BreweryId"] == null)
{
RedirectToAction("Index");
}
b.BreweryId = brewId;
var filename = "";
if (photo != null)
{
if (!isValidContentType(photo.ContentType))
{
ViewBag.Error = "wrong format";
return(View("FileUpload"));
}
else
{
filename = $"{b.Name}.jpg";
var path = Path.Combine(Server.MapPath("~/Photos/Beers"), filename);
photo.SaveAs(path);
//return RedirectToAction("ManageBeers");
}
}
_brew.AddNewBeer(b, filename);
return(Redirect("ManageBeers"));
}
