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