// GET: Menu public ActionResult Index() { var rID = new RestaurantHelper().GetRestaurant(User.Identity.GetUserId()); if (rID == 0) { return(RedirectToAction("Index", "Restaurant")); } return(View(_context.Menus.Where(c => c.RestaurantID == rID).ToList())); }
// GET: MenuItem public ActionResult Index(int?id) { if (id == null) { var rID = new RestaurantHelper().GetRestaurant(User.Identity.GetUserId()); if (rID == 0) { return(RedirectToAction("Index", "Restaurant")); } var menus = _context.Database .SqlQuery <MenuItem>("SELECT ItemID, Status, Price, Description, Ingredients, CategoryID, MenuItems.MenuID, MenuItems.Name, " + "MenuItems.ImagePath FROM Menus, MenuItems where Menus.RestaurantID = " + rID + " And Menus.MenuID = MenuItems.MenuID") .ToList <MenuItem>(); return(View(menus));; } return(View(_context.MenuItems.Where(c => c.MenuID == id).ToList())); }
public ActionResult Edit(int?id) { var rID = new RestaurantHelper().GetRestaurant(User.Identity.GetUserId()); if (rID == 0) { return(RedirectToAction("Index", "Restaurant")); } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } _context.Configuration.ProxyCreationEnabled = false; MenuItem menuitem = _context.MenuItems.Include(c => c.Tags).SingleOrDefault(c => c.ItemID == id); if (menuitem == null) { return(HttpNotFound()); } var menus = _context.Menus.Where(c => c.RestaurantID == rID).ToList(); var categories = _context.Categories.Where(c => c.RestaurantID == rID).ToList(); var viewModel = new MenuItemViewModel { MenuItems = menuitem, Categories = categories, Menus = menus }; viewModel.tags = ""; foreach (Tag tagg in menuitem.Tags) { viewModel.tags = viewModel.tags + "," + tagg.TagName; } return(View(viewModel)); }
public ActionResult Save(Menu menu, HttpPostedFileBase file) { var rID = new RestaurantHelper().GetRestaurant(User.Identity.GetUserId()); if (rID == 0) { return(RedirectToAction("Index", "Restaurant")); } if (file != null) { string pic = System.IO.Path.GetFileName(Guid.NewGuid().ToString()); pic += file.FileName; string path = System.IO.Path.Combine( Server.MapPath("~/Images/Menu"), pic); menu.ImagePath = pic; file.SaveAs(path); } menu.RestaurantID = rID; _context.Menus.Add(menu); _context.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Create() { //Gets the restaurant ID of the current user var rID = new RestaurantHelper().GetRestaurant(User.Identity.GetUserId()); if (rID == 0) { return(RedirectToAction("Index", "Restaurant")); } var menus = _context.Menus.Where(c => c.RestaurantID == rID).ToList(); var categories = _context.Categories.Where(c => c.RestaurantID == rID).ToList(); var viewModel = new MenuItemViewModel { Categories = categories, Menus = menus }; viewModel.tags = ""; return(View(viewModel)); }
public RestaurantCRUD() { dalCrud = new RestaurantReviewDataLayer.RestaurantCRUD(); restHelper = new RestaurantHelper(); }