private void GetRecruitmentTaskList(EmployeeRequirementSheetDAL recruitmentDAL) { // Ngay can nhan su <= NOW + 15 + 1 List <int> delegatedItemIDs = this.DelegationList.Where(d => d.ListUrl == EmployeeRequirementSheetsList.Url).Select(d => d.ListItemID).ToList(); var delegationQuery = _filterTaskManager.BuildApprovedByDelegationQuery(_currentUserInfoId, EmployeeRequirementSheetsList.Fields.PendingAtField, "Lookup", delegatedItemIDs); var query = $@"<Where> <And> <And> {delegationQuery} <Eq> <FieldRef Name='{ApprovalFields.WFStatus}' /> <Value Type='Text'>{StringConstant.ApprovalStatus.InProgress}</Value> </Eq> </And> <Or> <Eq> <FieldRef Name='{CommonSPListField.CommonReqDueDateField}' /> <Value IncludeTimeValue='FALSE' Type='DateTime'>{DateTime.Now.AddDays(16).ToString(StringConstant.DateFormatForCAML)}</Value> </Eq> <Or> <Eq> <FieldRef Name='{CommonSPListField.CommonReqDueDateField}' /> <Value IncludeTimeValue='FALSE' Type='DateTime'>{DateTime.Now.AddDays(17).ToString(StringConstant.DateFormatForCAML)}</Value> </Eq> <And> <Geq> <FieldRef Name='{CommonSPListField.CommonReqDueDateField}' /> <Value IncludeTimeValue='FALSE' Type='DateTime'>{DateTime.Now.ToString(StringConstant.DateFormatForCAML)}</Value> </Geq> <Lt> <FieldRef Name='{CommonSPListField.CommonReqDueDateField}' /> <Value IncludeTimeValue='FALSE' Type='DateTime'>{DateTime.Now.AddDays(16).ToString(StringConstant.DateFormatForCAML)}</Value> </Lt> </And> </Or> </Or> </And> </Where>"; if (this.CountOnly) { TotalCount += recruitmentDAL.CountByQuery(query); } else { var recruitmentManagementList = recruitmentDAL.GetByQuery(query); if (recruitmentManagementList != null && recruitmentManagementList.Count > 0) { foreach (var recruitmentManagement in recruitmentManagementList) { var filterTask = new FilterTask(recruitmentManagement); filterTask.ApprovalStatusId = ApprovalStatusId; FilterTaskList.Add(filterTask); } } } }
private void GetRecruitmentTaskList(EmployeeRequirementSheetDAL recruitmentDAL) { var query = _filterTaskManager.BuildApprovalWorkflowHistoryQuery(EmployeeRequirementSheetsList.ListName, this.ApproverFullName, DateTime.Now); if (this.CountOnly) { TotalCount += recruitmentDAL.CountByQuery(query); } else { var recruitmentManagementList = recruitmentDAL.GetByQuery(query); if (recruitmentManagementList != null && recruitmentManagementList.Count > 0) { foreach (var recruitmentManagement in recruitmentManagementList) { var filterTask = new FilterTask(recruitmentManagement); filterTask.ApprovalStatusId = recruitmentManagement.WFStatus == Status.Approved ? ApprovedStatusId : recruitmentManagement.WFStatus == ApprovalStatus.Rejected ? RejectedStatusId : InProgressStatusId; FilterTaskList.Add(filterTask); } } } }