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