public IEnumerable <E_VoucherCodeLineDTO> GetUserVoucher(EvoucherCodeLinePagingFilterModelDTO pagingModel) { var query = this.PagingFilter(_vRepo.SelectWhere(x => x.EvoucheBudgetDetailId == pagingModel.EvoucheBudgetDetailId && x.Status == pagingModel.Status) , pagingModel); return(query.OrderBy(x => x.Id).Skip(pagingModel.Start - 1).Take(pagingModel.Length).ProjectTo <E_VoucherCodeLineDTO>().ToList()); }
public RespondData GetUserVoucher(long EvoucheBudgetDetailId, int Status) { EvoucherCodeLinePagingFilterModelDTO filter = new EvoucherCodeLinePagingFilterModelDTO(); filter.EvoucheBudgetDetailId = EvoucheBudgetDetailId; filter.Status = Status; return(Success(this._service.GetUserVoucher(filter))); }
protected IQueryable <E_VoucherCodeLine> PagingFilter(IQueryable <E_VoucherCodeLine> query, EvoucherCodeLinePagingFilterModelDTO 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 IEnumerable <E_VoucherCodeLineDTO> GetPaging(EvoucherCodeLinePagingFilterModelDTO pagingModel) { var query = this.PagingFilter(_vRepo.SelectAll(), pagingModel); return(query.OrderBy(x => x.Id).Skip(pagingModel.Start - 1).Take(pagingModel.Length).ProjectTo <E_VoucherCodeLineDTO>().ToList()); }
public virtual int Count(EvoucherCodeLinePagingFilterModelDTO pagingModel) { var query = this.PagingFilter(_vRepo.SelectAll(), pagingModel); return(query.Count()); }