Esempio n. 1
0
        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 }));
            }
        }
Esempio n. 2
0
        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);
            }
        }
Esempio n. 3
0
        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);
        }
Esempio n. 4
0
        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"));
        }