public ActionResult Create([Bind(Include = "TabRecipe,RecipeId,TabId")] TabRecipes tabRecipes)
{
if (ModelState.IsValid)
{
db.TabRecipes.Add(tabRecipes);
db.SaveChanges();
var recipeItem = tabRecipes.RecipeId;
var tabItem = tabRecipes.TabId;
var tab = db.Tabs.Where(ord => ord.TabId == tabItem).Single();
var recipe = db.Recipe.Where(ord => ord.RecipeId == recipeItem).Single();
tab.Total += recipe.Price;
db.Entry(tab).State = EntityState.Modified;
db.SaveChanges();
var alcoholType = recipe.InventoryId;
var alcoholAmount = recipe.ReducedFromInventory;
var inventoryObject = db.Inventory.Where(itm => itm.InventoryId == alcoholType).Single();
inventoryObject.Stock -= alcoholAmount;
db.Entry(inventoryObject).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("IndexAllOrdersOnlyActive", "Tabs"));
}
ViewBag.RecipeId = new SelectList(db.Recipe, "RecipeId", "Name", tabRecipes.RecipeId);
ViewBag.TabId = new SelectList(db.Tabs, "TabId", "Name", tabRecipes.TabId);
return(View(tabRecipes));
}
public ActionResult DeleteConfirmed(int id)
{
TabRecipes tabRecipes = db.TabRecipes.Find(id);
db.TabRecipes.Remove(tabRecipes);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "TabRecipe,RecipeId,TabId")] TabRecipes tabRecipes)
{
if (ModelState.IsValid)
{
db.Entry(tabRecipes).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.RecipeId = new SelectList(db.Recipe, "RecipeId", "Name", tabRecipes.RecipeId);
ViewBag.TabId = new SelectList(db.Tabs, "TabId", "Name", tabRecipes.TabId);
return(View(tabRecipes));
}
// GET: TabRecipes/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TabRecipes tabRecipes = db.TabRecipes.Find(id);
if (tabRecipes == null)
{
return(HttpNotFound());
}
return(View(tabRecipes));
}
// GET: TabRecipes/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TabRecipes tabRecipes = db.TabRecipes.Find(id);
if (tabRecipes == null)
{
return(HttpNotFound());
}
ViewBag.RecipeId = new SelectList(db.Recipe, "RecipeId", "Name", tabRecipes.RecipeId);
ViewBag.TabId = new SelectList(db.Tabs, "TabId", "Name", tabRecipes.TabId);
return(View(tabRecipes));
}
