private void GetRequestTaskList(RequestsDAL requestDAL)
{
var query = _filterTaskManager.BuildApprovalWorkflowHistoryQuery(RequestsList.ListName, this.ApproverFullName, DateTime.Now);
if (this.CountOnly)
{
TotalCount += requestDAL.CountByQuery(query);
}
else
{
var requestManagementList = requestDAL.GetByQuery(query);
if (requestManagementList != null && requestManagementList.Count > 0)
{
foreach (var requestManagement in requestManagementList)
{
var filterTask = new FilterTask(requestManagement);
filterTask.ApprovalStatusId = requestManagement.WFStatus == ApprovalStatus.Approved ? ApprovedStatusId
: requestManagement.WFStatus == ApprovalStatus.InProcess ? InProcessStatusId
: requestManagement.WFStatus == ApprovalStatus.Completed ? CompletedId
: requestManagement.WFStatus == ApprovalStatus.Rejected ? RejectedStatusId
: InProgressStatusId;
FilterTaskList.Add(filterTask);
}
}
}
}
private void GetOvertimeTaskList(OverTimeManagementDAL overTimeManagementDAL)
{
var query = $@"<Where>
<Or>
<And>
<Eq>
<FieldRef Name='{StringConstant.OverTimeManagementList.FirstApprovedByField}' LookupId='TRUE' />
<Value Type='User'>{_currentUserADId}</Value>
</Eq>
<Eq>
<FieldRef Name='{StringConstant.OverTimeManagementList.FirstApprovedDateField}' />
<Value IncludeTimeValue='FALSE' Type='DateTime'>{DateTime.Now.ToString(StringConstant.DateFormatForCAML)}</Value>
</Eq>
</And>
<And>
<Or>
<Eq>
<FieldRef Name='{StringConstant.CommonSPListField.ApprovalStatusField}' />
<Value Type='Text'>true</Value>
</Eq>
<Eq>
<FieldRef Name='{StringConstant.CommonSPListField.ApprovalStatusField}' />
<Value Type='Text'>false</Value>
</Eq>
</Or>
<And>
<Eq>
<FieldRef Name='{StringConstant.OverTimeManagementList.ApprovedByField}' LookupId='TRUE' />
<Value Type='User'>{_currentUserADId}</Value>
</Eq>
<Eq>
<FieldRef Name='{StringConstant.DefaultSPListField.ModifiedField}' />
<Value IncludeTimeValue='FALSE' Type='DateTime'>{DateTime.Now.ToString(StringConstant.DateFormatForCAML)}</Value>
</Eq>
</And>
</And>
</Or>
</Where>";
if (this.CountOnly)
{
TotalCount += overTimeManagementDAL.CountByQuery(query);
}
else
{
var overtimeManagementList = overTimeManagementDAL.GetByQuery(query);
if (overtimeManagementList != null && overtimeManagementList.Count > 0)
{
foreach (var overtimeManagement in overtimeManagementList)
{
var filterTask = new FilterTask(overtimeManagement);
filterTask.ApprovalStatusId = overtimeManagement.ApprovalStatus == "true" ? ApprovedStatusId
: overtimeManagement.ApprovalStatus == "false" ? RejectedStatusId
: InProgressStatusId;
FilterTaskList.Add(filterTask);
}
}
}
}
private void GetRequestTaskList(RequestsDAL requestDAL)
{
var requestByValue = "Mua hàng/Buy new materials or equipments";
List <int> delegatedItemIDs = this.DelegationList.Where(d => d.ListUrl == RequestsList.Url).Select(d => d.ListItemID).ToList();
var delegationQuery = _filterTaskManager.BuildApprovedByDelegationQuery(_currentUserInfoId, RequestsList.CommonCreatorField, "Lookup", delegatedItemIDs);
var query = $@"<Where>
<And>
<And>
{delegationQuery}
<Eq>
<FieldRef Name='{ApprovalFields.WFStatus}' />
<Value Type='Text'>{StringConstant.ApprovalStatus.InProcess}</Value>
</Eq>
</And>
<Or>
<And>
<Neq>
<FieldRef Name='{RequestsList.RequestTypeRefField}'/>
<Value Type='Lookup'>{requestByValue}</Value>
</Neq>
<Geq>
<FieldRef Name='{RequestsList.FinishDateField}' />
<Value IncludeTimeValue='FALSE' Type='DateTime'>{DateTime.Now.ToString(StringConstant.DateFormatForCAML)}</Value>
</Geq>
</And>
<And>
<Eq>
<FieldRef Name='{RequestsList.RequestTypeRefField}'/>
<Value Type='Lookup'>{requestByValue}</Value>
</Eq>
<Leq>
<FieldRef Name='{StringConstant.DefaultSPListField.CreatedField}' />
<Value IncludeTimeValue='FALSE' Type='DateTime'>{DateTime.Now.ToString(StringConstant.DateFormatForCAML)}</Value>
</Leq>
</And>
</Or>
</And>
</Where>";
if (this.CountOnly)
{
TotalCount += requestDAL.CountByQuery(query);
}
else
{
var requestManagementList = requestDAL.GetByQuery(query);
if (requestManagementList != null && requestManagementList.Count > 0)
{
foreach (var requestManagement in requestManagementList)
{
var filterTask = new FilterTask(requestManagement);
filterTask.ApprovalStatusId = ApprovalStatusId;
FilterTaskList.Add(filterTask);
}
}
}
}
private void GetNotOvertimeTaskList(NotOvertimeManagementDAL notOvertimeManagementDAL)
{
var dueDate = DateTime.Now.AddDays(1);
var query = $@"<Where>
<And>
<Or>
<Eq>
<FieldRef Name='{StringConstant.CommonSPListField.ApprovalStatusField}' />
<Value Type='Text'>Approved</Value>
</Eq>
<Eq>
<FieldRef Name='{StringConstant.CommonSPListField.ApprovalStatusField}' />
<Value Type='Text'>Rejected</Value>
</Eq>
</Or>
<And>
<Eq>
<FieldRef Name='{StringConstant.NotOvertimeList.DHField}' LookupId='TRUE' />
<Value Type='User'>{_currentUserADId}</Value>
</Eq>
<Eq>
<FieldRef Name='{StringConstant.DefaultSPListField.ModifiedField}' />
<Value IncludeTimeValue='FALSE' Type='DateTime'>{DateTime.Now.ToString(StringConstant.DateFormatForCAML)}</Value>
</Eq>
</And>
</And>
</Where>";
if (this.CountOnly)
{
TotalCount += notOvertimeManagementDAL.CountByQuery(query);
}
else
{
var notOvertimeManagementList = notOvertimeManagementDAL.GetByQuery(query);
if (notOvertimeManagementList != null)
{
foreach (var notOvertimeManagement in notOvertimeManagementList)
{
var filterTask = new FilterTask(notOvertimeManagement);
filterTask.ApprovalStatusId = notOvertimeManagement.ApprovalStatus == "Approved" ? ApprovedStatusId : RejectedStatusId;
FilterTaskList.Add(filterTask);
}
}
}
}
private void GetShiftTaskList(ShiftManagementDAL shiftManagementDAL)
{
int year = DateTime.Now.Year;
int month = DateTime.Now.Month;
int day = DateTime.Now.Day;
var query = $@"<Where>
<And>
<And>
<Eq>
<FieldRef Name='{StringConstant.ShiftManagementList.CommonAddApprover1Field}' LookupId='TRUE' />
<Value Type='User'>{_currentUserADId}</Value>
</Eq>
<Eq>
<FieldRef Name='{StringConstant.DefaultSPListField.ModifiedByField}' LookupId='TRUE' />
<Value Type='User'>{_currentUserADId}</Value>
</Eq>
</And>
<Eq>
<FieldRef Name='{StringConstant.DefaultSPListField.ModifiedField}' />
<Value IncludeTimeValue='FALSE' Type='DateTime'>{DateTime.Now.ToString(StringConstant.DateFormatForCAML)}</Value>
</Eq>
</And>
</Where>";
if (this.CountOnly)
{
TotalCount += shiftManagementDAL.CountByQuery(query);
}
else
{
var shiftManagementList = shiftManagementDAL.GetByQuery(query);
if (shiftManagementList != null && shiftManagementList.Count > 0)
{
foreach (var shiftManagement in shiftManagementList)
{
var filterTask = new FilterTask(shiftManagement);
filterTask.ApprovalStatusId = ApprovedStatusId;
FilterTaskList.Add(filterTask);
}
}
}
}
private void GetGuestReceptionTaskList(GuestReceptionManagementDAL guestReceptionManagementDAL)
{
var query = _filterTaskManager.BuildApprovalWorkflowHistoryQuery(GuestReceptionManagementList.ListName, this.ApproverFullName, DateTime.Now);
if (this.CountOnly)
{
TotalCount += guestReceptionManagementDAL.CountByQuery(query);
}
else
{
var guestReceptionManagementList = guestReceptionManagementDAL.GetByQuery(query);
if (guestReceptionManagementList != null && guestReceptionManagementList.Count > 0)
{
foreach (var guestReceptionManagement in guestReceptionManagementList)
{
var filterTask = new FilterTask(guestReceptionManagement);
filterTask.ApprovalStatusId = guestReceptionManagement.WFStatus == Status.Approved ? ApprovedStatusId
: guestReceptionManagement.WFStatus == ApprovalStatus.Rejected ? RejectedStatusId
: InProgressStatusId;
FilterTaskList.Add(filterTask);
}
}
}
}
private void GetMeetingRoomTaskList(RequisitionOfMeetingRoomDAL requisitionOfMeetingRoomDAL)
{
var query = _filterTaskManager.BuildApprovalWorkflowHistoryQuery(RequisitionOfMeetingRoomList.ListName, this.ApproverFullName, DateTime.Now);
if (this.CountOnly)
{
TotalCount += requisitionOfMeetingRoomDAL.CountByQuery(query);
}
else
{
var requisitionOfMeetingList = requisitionOfMeetingRoomDAL.GetByQuery(query);
if (requisitionOfMeetingList != null && requisitionOfMeetingList.Count > 0)
{
foreach (var requisitionOfMeeting in requisitionOfMeetingList)
{
var filterTask = new FilterTask(requisitionOfMeeting);
filterTask.ApprovalStatusId = requisitionOfMeeting.WFStatus == Status.Approved ? ApprovedStatusId
: requisitionOfMeeting.WFStatus == ApprovalStatus.Rejected ? RejectedStatusId
: InProgressStatusId;
FilterTaskList.Add(filterTask);
}
}
}
}
private void GetCertificateTaskList(RequestForDiplomaSupplyDAL certificateDAL)
{
var query = _filterTaskManager.BuildApprovalWorkflowHistoryQuery(RequestForDiplomaSuppliesList.ListName, this.ApproverFullName, DateTime.Now);
if (this.CountOnly)
{
TotalCount += certificateDAL.CountByQuery(query);
}
else
{
var certificateManagementList = certificateDAL.GetByQuery(query);
if (certificateManagementList != null && certificateManagementList.Count > 0)
{
foreach (var certificateManagement in certificateManagementList)
{
var filterTask = new FilterTask(certificateManagement);
filterTask.ApprovalStatusId = certificateManagement.WFStatus == Status.Approved ? ApprovedStatusId
: certificateManagement.WFStatus == ApprovalStatus.Rejected ? RejectedStatusId
: InProgressStatusId;
FilterTaskList.Add(filterTask);
}
}
}
}
private void GetBusinessTripTaskList(BusinessTripManagementDAL businessTripManagementDAL)
{
var query = _filterTaskManager.BuildApprovalTaskListQuery(StepModuleList.BusinessTripManagement.ToString(), _currentUserADId, DateTime.Now);
if (this.CountOnly)
{
TotalCount += businessTripManagementDAL.CountByQuery(query);
}
else
{
var businessTripManagementList = businessTripManagementDAL.GetByQuery(query);
if (businessTripManagementList != null && businessTripManagementList.Count > 0)
{
foreach (var businessTripManagement in businessTripManagementList)
{
var filterTask = new FilterTask(businessTripManagement);
filterTask.ApprovalStatusId = businessTripManagement.ApprovalStatus == Status.Approved ? ApprovedStatusId
: businessTripManagement.ApprovalStatus == Status.Rejected ? RejectedStatusId
: InProgressStatusId;
FilterTaskList.Add(filterTask);
}
}
}
}
