public ActionResult ViewSale(int? id = 0)
        {
            ViewBag.Customers = _context.Customers.ToList();
            ViewBag.FoodItems = _context.FoodItems.ToList();
            Sale sale = _context.Sale.Find(id);
            CreateSaleViewModel vm = new CreateSaleViewModel();
            vm.Sale_FoodItems = new List<Sale_FoodItem>();
            vm.Customer_Id = sale.Customer_Id;
            vm.Amount = sale.Amount;
            vm.Sale_Id = sale.Sale_Id;

            vm.Amount_Pay = sale.Amount_Pay;
            vm.Grand_Total = sale.Grand_Total;
            vm.Left_Amount = sale.Left_Amount;
            vm.Remaining_Amount = sale.Remaining_Amount;

            vm.Created_Date = sale.Created_Date;
            vm.Is_Paid = sale.Is_Paid == true ? "Yes" : "No";
            foreach (var item in _context.Sale_FoodItems.Where(m => m.Sale_Id == sale.Sale_Id))
            {
                Sale_FoodItem foodItem = new Sale_FoodItem();
                foodItem.Amount = item.Amount;
                foodItem.Quantity = item.Quantity;
                foodItem.Rate = item.Rate;
                foodItem.Id = item.Sale_FoodItem_Id;
                foodItem.Name = item.Food_Item.Name;
                vm.Sale_FoodItems.Add(foodItem);
            }

            return View(vm);
        }
        public JsonResult InsertCustomer(Sale_FoodItem customer)
        {
            //Sale_FoodItemRelation viewModel = new Sale_FoodItemRelation();
            //viewModel.Quantity = customer.Sale_FoodItems.FirstOrDefault().Quantity;

            //viewModel.Rate= customer.Sale_FoodItems.FirstOrDefault().Rate;
            //viewModel.Amount = customer.Sale_FoodItems.FirstOrDefault().Amount;
            //viewModel.Created_Date = DateTime.UtcNow;
            //viewModel.Modified_Date = DateTime.UtcNow;


            //_context.Sale_FoodItems .Add(viewModel);
            _context.SaveChanges();


            return Json(customer);
        }