public async Task <IActionResult> ByBrand([FromQuery] int BrandId)
        {
            IEnumerable <ProductDto> products = null;

            try
            {
                products = await _ProductFacade.GetProductsByBrand(BrandId);
            }
            catch (HttpRequestException)
            {
                _logger.LogWarning("Exception Occured using Product Facade");
                products = null;
            }

            IEnumerable <ProductViewModel> viewModel = products.Select(p => new ProductViewModel
            {
                ProductId   = p.ProductId,
                Name        = p.Name,
                Description = p.Description,
                Quantity    = p.Quantity,
                BrandId     = p.BrandId,
                Brand       = p.Brand,
                CategoryId  = p.CategoryId,
                Category    = p.Category,
                Price       = p.Price
            });

            ViewData["Brand"] = products.First().Brand;

            return(View(viewModel));
        }