public void addProductenInBestelling(ProductenInBestelling item)
        {
            ProductenInBestellingMapper mapper = new ProductenInBestellingMapper();

            try
            {
                mapper.addProductenInBestellingToDB(_connectionString, item);
            }
            catch (Exception ex)
            {
                mapper.updateProductenInBestellingToDB(_connectionString, item);
            }
        }
        public List <ProductenInBestellenVoorEigenaar> GetPersonalProductenInBestelling(int idBestelling)
        {
            ProductenInBestellingMapper mapper = new ProductenInBestellingMapper();

            return(mapper.getPersonalProductenInBestelling(_connectionString, idBestelling));
        }
        public bool DeleteProductenInBestelling(int idProduct, int idBestelling)
        {
            ProductenInBestellingMapper mapper = new ProductenInBestellingMapper();

            return(mapper.DeleteProductenInBestelling(_connectionString, idProduct, idBestelling));
        }
        public List <ProductenInBestellenVoorEigenaar> GetAllProductenInBestelling()
        {
            ProductenInBestellingMapper mapper = new ProductenInBestellingMapper();

            return(mapper.getAllProductenInBestelling(_connectionString));
        }
        //Producten in de bestelling
        public List <ProductenInBestelling> GetProductenInBestelling(int idBestelling)
        {
            ProductenInBestellingMapper mapper = new ProductenInBestellingMapper();

            return(mapper.getProductenInBestellingFromDB(_connectionString, idBestelling));
        }
        public double GetPrijsProductenInBestelling(int idBestelling)
        {
            ProductenInBestellingMapper mapper = new ProductenInBestellingMapper();

            return(mapper.GetTussenTotaal(_connectionString, idBestelling));
        }