public IEnumerable <RefProductCategories> PagingAndFilterRefProductCategories(int pageSize, int pazeNow, string filter, bool sortBy)
        {
            PagingCategory pagingCategory = new PagingCategory();
            IEnumerable <RefProductCategories> listCatelogy = pagingCategory.PaginationGeneral(pageSize, pazeNow, sortBy, filter, db);

            return(listCatelogy);
        }
        public int CountRefProductCategoriesFilter(string filter, bool conditionCount)
        {
            pagingCategory = new PagingCategory();
            int countCatelogy = pagingCategory.CountProductFilter(filter, db, conditionCount);

            return(countCatelogy);
        }