public IEnumerable <DismissalCaseListModel> GetDismissalCasesByStatus(AppealState appealState, int page, int pageSize)
{
var model = _dbSet.Include(d => d.Applicant).Include(d => d.Comments).OrderByDescending(d => d.EditedDate)
.Where(d => d.AppealState == appealState)
.AsEnumerable().Skip((page - 1) * pageSize).Take(pageSize)
.Select(d => new DismissalCaseListModel
{
Id = d.ID,
AppealState = d.AppealState,
ApplicantEmail = d.Applicant.Email,
ApplicantFullName = d.Applicant.FullName,
CreatedDate = d.CreatedDate,
CommentDate = d.EditedDate,
CommentedBy = d.Comments.OrderByDescending(c => c.CreatedDate).FirstOrDefault() != null ? d.Comments.OrderByDescending(c => c.CreatedDate).FirstOrDefault().UserName : string.Empty
})
.OrderByDescending(d => d.CommentDate)
.ToList();
return(model);
}
public IEnumerable <DismissalCaseListModel> GetDismissalCaseListModelByStatus(AppealState status, int page, int pageSize)
{
return(_unitOfWork.dismissalCaseRepository.GetDismissalCasesByStatus(status, page, pageSize));
}
public int GetAllDismissalCasesCountByStatus(AppealState appealState)
{
return(_unitOfWork.dismissalCaseRepository.GetCountByAppealState(appealState));
}
public int GetCountByAppealState(AppealState appealState)
{
return(_dbSet.Where(d => d.AppealState == appealState).Count());
}