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 RespondData GetUserVoucher(View_EVoucherUserRS view_EVoucherUserRS)
{
View_EVoucherUserPagingFilterModelDTO filter = new View_EVoucherUserPagingFilterModelDTO();
filter.UserName = System.Web.HttpContext.Current.User.Identity.Name;
filter.Status = 1;
return(Success(this._service.GetUserVoucher(filter)));
}
public virtual RespondData Count(View_EVoucherUserRS view_EVoucherUserRS)
{
View_EVoucherUserPagingFilterModelDTO filter = new View_EVoucherUserPagingFilterModelDTO();
filter.UserName = System.Web.HttpContext.Current.User.Identity.Name;
filter.Status = 1;
var result = this._service.Count(filter);
return(Success(result));
}
/* 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();*/
}
public IEnumerable <View_EVoucherUserDTO> GetPaging(View_EVoucherUserPagingFilterModelDTO pagingModel)
{
var query = this.PagingFilter(_vRepo.SelectAll(), pagingModel);
return(query.OrderBy(x => x.Id).Skip(pagingModel.Start - 1).Take(pagingModel.Length).ProjectTo <View_EVoucherUserDTO>().ToList());
}
protected IQueryable <View_EVoucherUser> PagingFilter(IQueryable <View_EVoucherUser> query, View_EVoucherUserPagingFilterModelDTO 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);
}