//PAGING AND FILTER PRODUCT
        #region
        public IEnumerable <Product> PagingAndFilterProduct(int pageSize, int pazeNow, string filter, bool sortBy)
        {
            PaginationImpl        p           = new PaginationImpl();
            IEnumerable <Product> listProduct = p.PaginationGeneral(pageSize, pazeNow, sortBy, filter, db);

            return(listProduct);
        }
        public int CountProductFilter(string filter, bool conditionCount)
        {
            if (filter.Equals(""))
            {
                return(0);
            }
            PaginationImpl p = new PaginationImpl();

            return(p.CountProductFilter(filter, db, conditionCount));
        }