protected override void LoadListOfMyRequests() { try { StringBuilder queryStringMyRequestBuilder = new StringBuilder(); queryStringMyRequestBuilder.Append(this.queryStringMyRequest); queryStringMyRequestBuilder.Append(this.orderByQueryString); List <Biz.Models.RequisitionOfMeetingRoom> myRequests = requisitionOfMeetingRoomDAL.GetByQuery(queryStringMyRequestBuilder.ToString()); this.gridMyRquests.DataSource = myRequests; this.gridMyRquests.DataBind(); this.Page.Session[MyRequestsSessionKey + this.moduleId] = myRequests; } catch (Exception ex) { ULSLogging.LogError(ex); ULSLogging.LogMessageToFile($"-- Error occurs on MeetingRoomListUserControl: {ex.Message}"); } }
private void GetMeetingRoomTaskList(RequisitionOfMeetingRoomDAL requisitionOfMeetingRoomDAL) { List <int> delegatedItemIDs = this.DelegationList.Where(d => d.ListUrl == RequisitionOfMeetingRoomList.Url).Select(d => d.ListItemID).ToList(); var delegationQuery = _filterTaskManager.BuildApprovedByDelegationQuery(_currentUserInfoId, RequisitionOfMeetingRoomList.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='{RequisitionOfMeetingRoomList.Fields.StartDate}' /> <Value IncludeTimeValue='FALSE' Type='DateTime'>{DateTime.Now.ToString(StringConstant.DateFormatForCAML)}</Value> </Eq> <Eq> <FieldRef Name='{RequisitionOfMeetingRoomList.Fields.StartDate}' /> <Value IncludeTimeValue='FALSE' Type='DateTime'>{DateTime.Now.AddDays(1).ToString(StringConstant.DateFormatForCAML)}</Value> </Eq> </Or> </And> </Where>"; if (this.CountOnly) { TotalCount += requisitionOfMeetingRoomDAL.CountByQuery(query); } else { var requisitionOfMeetingRoomList = requisitionOfMeetingRoomDAL.GetByQuery(query); if (requisitionOfMeetingRoomList != null && requisitionOfMeetingRoomList.Count > 0) { foreach (var requisitionOfMeetingRoom in requisitionOfMeetingRoomList) { var filterTask = new FilterTask(requisitionOfMeetingRoom); filterTask.ApprovalStatusId = ApprovalStatusId; 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); } } } }