public ActionResult Edit([Bind(Include = "Price, FoodId")] FoodInventaryViewModel food)
        {
            if (ModelState.IsValid)
            {
                var foodHistorial  = db.sp_GetFoodInventary();
                var foodViewModels = ConvertResultsToViewModels(foodHistorial);
                var foodHistory    = foodViewModels.FirstOrDefault(item => item.FoodId == food.FoodId);

                var fooddb = ConvertViewModelToFoodHistory(food, foodHistory.QuantityChanged);
                db.FoodHistory.Add(fooddb);
                db.SaveChanges();

                return(RedirectToAction("Index"));
            }
            ViewBag.FoodId = new SelectList(db.Food, "FoodId", "FoodName", food.FoodId);
            return(View(food));
        }
        private FoodHistory ConvertViewModelToFoodHistory(FoodInventaryViewModel foodInventaryViewModel, int quantityAvailable)
        {
            decimal.TryParse(foodInventaryViewModel.Price, out decimal price);
            FoodHistory foodHistory = new FoodHistory
            {
                Description       = "Se actualiza el inventario",
                FoodId            = foodInventaryViewModel.FoodId,
                ModificationDate  = DateTime.Now,
                Price             = price,
                QuantityChanged   = foodInventaryViewModel.QuantityChanged,
                QuantityAvailable = quantityAvailable + foodInventaryViewModel.QuantityChanged,
                Status            = 1,
                UserName          = User.Identity.GetUserName()
            };

            return(foodHistory);
        }