public ViewResult StatResto()
        {
            var vm = new List<StatViewModel>();

            var restaurants = restaurantRepository.All;

            foreach (var resto in restaurants)
            {
                StatViewModel stat = new StatViewModel();

                var ordersResto = orderpaidRepository.AllIncluding(p => p.Menus).Where(p => p.RestaurantId == resto.Id);
                double benefice = 0;

                foreach (var order in ordersResto)
                {
                    foreach (var menu in order.Menus)
                    {
                        benefice += menu.Prix;
                    }
                }

                stat.Benefice = benefice;
                stat.Title = resto.Name;

                vm.Add(stat);
            }

            return View(vm);
        }
        public ViewResult StatProduct()
        {
            var vm = new List<StatViewModel>();

            var types = producttypeRepository.All;

            var orders = orderpaidRepository.AllIncluding(p => p.Menus).ToList();

            foreach (var type in types)
            {
                StatViewModel stat = new StatViewModel();

                double benefice = 0;

                foreach (var order in orders)
                {
                    foreach (var menu in order.Menus)
                    {
                        if (menu.ProductTypeId == type.Id)
                        {
                            benefice += menu.Prix;
                        }
                    }
                }

                stat.Benefice = benefice;
                stat.Title = type.Description;

                vm.Add(stat);
            }

            return View(vm);
        }