public IHttpActionResult GetDishById(int id)
        {
            Dish dish = db.Dish.Find(id);
            DishViewModel dishViewModel = new DishViewModel();
            dishViewModel.Name = dish.Name;
            dishViewModel.Description = dish.Description;
            dishViewModel.Price = dish.Price;
            dishViewModel.Photo = dish.Photo;
            dishViewModel.Id = dish.Id;
            if (dish == null)
            {
                return NotFound();
            }

            return Ok(dishViewModel);
        }
 public List<DishViewModel> GetDishes()
 {
     var dishes = new List<DishViewModel>();
     foreach (var dish in db.Dish.ToList())
     {
         DishViewModel dishViewModel = new DishViewModel();
         dishViewModel.Name = dish.Name;
         dishViewModel.Description = dish.Description;
         dishViewModel.Price = dish.Price;
         dishViewModel.Photo = dish.Photo;
         dishViewModel.Id = dish.Id;
         dishes.Add(dishViewModel);
     }
     
     return dishes;
 }
        public IHttpActionResult GetOrderById(int id)
        {
            Order order = db.Order.Find(id);
            OrderViewModel orderViewModel = new OrderViewModel();
            orderViewModel.DishId = order.DishId;
            orderViewModel.Id = order.Id;
            orderViewModel.State = order.State;
            orderViewModel.UserName = order.UserName;
            orderViewModel.Date = order.Date;

            DishViewModel dish = new DishViewModel();
            dish.Id = order.Dish.Id;
            dish.Name = order.Dish.Name;
            dish.Description = order.Dish.Description;
            dish.Price = order.Dish.Price;
            dish.Photo = order.Dish.Photo;

            orderViewModel.Dish = dish;

            if (order == null)
            {
                return NotFound();
            }

            return Ok(orderViewModel);
        }
        public List<OrderViewModel> GetOrders(string username)
        {
            var orders = new List<OrderViewModel>();
            foreach (var order in db.Order.Where(order => order.UserName == username).ToList())
            {
                OrderViewModel orderViewModel = new OrderViewModel();
                orderViewModel.DishId = order.DishId;
                orderViewModel.Id = order.Id;
                orderViewModel.State = order.State;
                orderViewModel.UserName = order.UserName;
                orderViewModel.Date = order.Date;

                DishViewModel dish = new DishViewModel();
                dish.Id = order.Dish.Id;
                dish.Name = order.Dish.Name;
                dish.Description = order.Dish.Description;
                dish.Price = order.Dish.Price;
                dish.Photo = order.Dish.Photo;

                orderViewModel.Dish = dish;
                orders.Add(orderViewModel);
            }
            
            return orders;
        }