protected IQueryable <E_VoucherCode> PagingFilter(IQueryable <E_VoucherCode> query, EvoucherCodePagingFilterModelDTO pagingModel)
        {
            bool?isValid = null;

            switch (pagingModel.IsValidate)
            {
            case "T":
                isValid = true;
                break;

            case "F":
                isValid = false;
                break;

            default:
                break;
            }
            query = this._vRepo.SelectWhere(x => (isValid.HasValue));
            return(query);
        }
        public virtual int Count(EvoucherCodePagingFilterModelDTO pagingModel)
        {
            var query = this.PagingFilter(_vRepo.SelectAll(), pagingModel);

            return(query.Count());
        }
        public IEnumerable <EVoucherCodeDTO> GetPaging(EvoucherCodePagingFilterModelDTO pagingModel)
        {
            var query = this.PagingFilter(_vRepo.SelectAll(), pagingModel);

            return(query.OrderBy(x => x.Id).Skip(pagingModel.Start - 1).Take(pagingModel.Length).ProjectTo <EVoucherCodeDTO>().ToList());
        }