private List<ReportProducts> AllProducts()
        {
            List<ReportProducts> products = new List<ReportProducts>();
            try
            {

                List<Product> Allproduct = productGateway.GetAllProducts();
                    foreach (Product product in Allproduct)
                    {
                        Category category = categoryGateway.GetCategoryByID(product.CategoryID);
                        ReportProducts newProduct=new ReportProducts(){ BarCode = product.BarCode, Price = product.Price, ProductName = product.ProductName, Size = product.Size, Category = category.Name};

                        products.Add(newProduct);
                    }

                return products;
            }
            catch (Exception exception)
            {

                throw new Exception(exception.Message);
            }
        }
        private ReportProducts GetProduct(string bCode)
        {
            try
            {
                Product aProduct = productGateway.GetDataBarCode(bCode);
                Category aCategory = categoryGateway.GetCategoryByID(aProduct.CategoryID);
                ReportProducts product = new ReportProducts(){BarCode = aProduct.BarCode, Price = aProduct.Price, Category = aCategory.Name, Size = aProduct.Size, ProductName = aProduct.ProductName};
                return product;
            }
            catch (Exception exception)
            {

                throw new Exception(exception.Message);
            }
        }