private static List <ProductModel> PrepareProducts(List <ProductModel> products)
        {
            foreach (ProductModel product in products)
            {
                GetProductImages(product);
                product.ProductType = ProductTypeProcessor.GetType(product.CategoryID);
            }

            return(products);
        }
        public static ProductModel GetProduct(int id)
        {
            var sql = $"select * from dbo.Product WHERE Id = {id};";

            var product = DataAccess.DataAccess.GetSingleData <ProductModel>(sql);

            //get product images
            GetProductImages(product);
            product.ProductType = ProductTypeProcessor.GetType(product.CategoryID);

            return(product);
        }