public ActionResult DeleteBeer(DeleteBeer b, int brewId, string beername, int beerId)
{
b.BreweryId = brewId;
b.Name = beername;
b.BeerId = beerId;
_brew.DeleteBeer(b);
return(Redirect("DeleteBeer"));
}
public ActionResult GetBeersToDelete()
{
int brewId = (int)Session["BreweryId"];
DeleteBeer b = new DeleteBeer();
b.DropDownBeers = _brew.GetAllBeersFromBrewery(brewId);
return(Json(b, JsonRequestBehavior.AllowGet));
}
public ActionResult DeleteBeer(int beerId)
{
DeleteBeer b = new DeleteBeer();
b.BeerId = beerId;
_brew.DeleteBeer(b);
return(Json(new { data = true }));
//return Redirect("DeleteBeer");
}
//---------DELETE BEERS------------
public ActionResult DeleteBeer()
{
if (Session["BreweryId"] == null)
{
RedirectToAction("Index ");
}
int brewId = (int)Session["BreweryId"];
DeleteBeer b = new DeleteBeer();
b.DropDownBeers = _brew.GetAllBeersFromBrewery(brewId);
return(View("DeleteBeer", b));
}
public bool DeleteBeer(DeleteBeer beer)
{
string SQL_DeleteBeer = "Delete from beerPhotos WHERE beer_id = @BeerId; Delete from reviews WHERE beer_id = @BeerId; Delete from beers where id = @BeerId;";
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(SQL_DeleteBeer, conn);
cmd.Parameters.Add(new SqlParameter("@BeerId", beer.BeerId));
cmd.ExecuteNonQuery();
}
return(true);
}
