public virtual int Count(View_EVoucherUserPagingFilterModelDTO pagingModel)
{
Org_UserOrg org_UserOrg = _orgUserOrgRepo.Get(x => x.UserName == pagingModel.UserName);
if (org_UserOrg == null)
{
return(0);
}
if (pagingModel.IsExpiryDate == 1)
{
return(_vRepo.SelectWhere(x => x.CodeUser == org_UserOrg.Code &&
x.Status == pagingModel.Status &&
x.EndDate >= System.DateTime.Today
).Count());
}
else if (pagingModel.IsExpiryDate == 2)
{
return(_vRepo.SelectWhere(x => x.CodeUser == org_UserOrg.Code &&
x.Status == pagingModel.Status &&
x.EndDate < System.DateTime.Today
).Count());
}
else
{
return(_vRepo.SelectWhere(x => x.CodeUser == org_UserOrg.Code &&
x.Status == pagingModel.Status
).Count());
}
/* var query = this.PagingFilter(_vRepo.SelectAll(), pagingModel);
* return query.Count();*/
}
/* public IEnumerable<View_EVoucherUserDTO> GetUserVoucher(View_EVoucherUserPagingFilterModelDTO pagingModel)
* {
* var query = this.PagingFilter(_vRepo.SelectWhere(x => x.CodeUser == pagingModel.CodeUser
* && x.Status == pagingModel.Status)
* , pagingModel);
* return query.OrderBy(x => x.Id).Skip(pagingModel.Start - 1).Take(pagingModel.Length).ProjectTo<View_EVoucherUserDTO>().ToList();
* }
*/
public IEnumerable <View_EVoucherUserDTO> GetUserVoucher(View_EVoucherUserPagingFilterModelDTO pagingModel)
{
Org_UserOrg org_UserOrg = _orgUserOrgRepo.Get(x => x.UserName == pagingModel.UserName);
if (org_UserOrg == null)
{
return(null);
}
if (pagingModel.IsExpiryDate == 1)
{
return(_vRepo.SelectWhere(x => x.CodeUser == org_UserOrg.Code &&
x.Status == pagingModel.Status &&
x.EndDate >= System.DateTime.Today)
.OrderBy(x => x.EndDate)
.ProjectTo <View_EVoucherUserDTO>().ToList());
}
else if (pagingModel.IsExpiryDate == 2)
{
return(_vRepo.SelectWhere(x => x.CodeUser == org_UserOrg.Code &&
x.Status == pagingModel.Status &&
x.EndDate < System.DateTime.Today)
.OrderBy(x => x.EndDate)
.ProjectTo <View_EVoucherUserDTO>().ToList());
}
else
{
return(_vRepo.SelectWhere(x => x.CodeUser == org_UserOrg.Code &&
x.Status == pagingModel.Status)
.OrderBy(x => x.EndDate)
.ProjectTo <View_EVoucherUserDTO>().ToList());
}
/*var query = this.PagingFilter(_vRepo.SelectWhere(x => x.CodeUser == pagingModel.CodeUser
* && x.Status == pagingModel.Status)
* , pagingModel);
* return query.OrderBy(x => x.Id).Skip(pagingModel.Start - 1).Take(pagingModel.Length).ProjectTo<View_EVoucherUserDTO>().ToList();*/
}
