public ActionResult <List <ProductDTO> > GetProducts()
 {
     try
     {
         var products = _query.GetAllProducts();
         return(Ok(products));
     }
     catch (Exception ex)
     {
         return(StatusCode(500, ex.Message));
     }
 }