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