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()); }