public IList <OTIssueAssignedResourceEntity> GetPagedData(Int32 startRowIndex, Int32 pageSize, String sortExpression) { IList <OTIssueAssignedResourceEntity> oTIssueAssignedResourceEntityList = new List <OTIssueAssignedResourceEntity>(); try { if (pageSize == -1) { pageSize = 1000000000; } if (String.IsNullOrEmpty(sortExpression)) { sortExpression = OTIssueAssignedResourceEntity.FLD_NAME_IssueAssignedResourceID + " " + SQLConstants.SORT_ORDER_DESCENDING; } startRowIndex = Convert.ToInt32(startRowIndex / pageSize) + 1; oTIssueAssignedResourceEntityList = FCCOTIssueAssignedResource.GetFacadeCreate().GetIL(startRowIndex, pageSize, sortExpression, null, DatabaseOperationType.LoadPagedWithSortExpression); if (oTIssueAssignedResourceEntityList != null && oTIssueAssignedResourceEntityList.Count > 0) { totalRowCount = oTIssueAssignedResourceEntityList[0].TotalRowCount; } } catch (Exception ex) { } return(oTIssueAssignedResourceEntityList ?? new List <OTIssueAssignedResourceEntity>()); }
public IList <OTIssueAssignedResourceEntity> GetData() { IList <OTIssueAssignedResourceEntity> oTIssueAssignedResourceEntityList = new List <OTIssueAssignedResourceEntity>(); try { oTIssueAssignedResourceEntityList = FCCOTIssueAssignedResource.GetFacadeCreate().GetIL(null, null, null, null, DatabaseOperationType.Load); if (oTIssueAssignedResourceEntityList != null && oTIssueAssignedResourceEntityList.Count > 0) { totalRowCount = oTIssueAssignedResourceEntityList[0].TotalRowCount; } } catch (Exception ex) { } return(oTIssueAssignedResourceEntityList ?? new List <OTIssueAssignedResourceEntity>()); }
protected void odsOTIssue_Detailed_Selecting(object sender, ObjectDataSourceSelectingEventArgs e) { String fe = String.Empty; switch (PageAPType) { case MasterDataConstants.IssuePageType.ADHOC_ISSUE: fe = SqlExpressionBuilder.PrepareFilterExpression("OTIssue." + OTIssueEntity.FLD_NAME_IssueIdentityCategoryID, MasterDataConstants.IssueIdentityCategory.ADHOC_ISSUE.ToString(), SQLMatchType.Equal); lblIssueList.Text = "Adhoc Issue List"; break; case MasterDataConstants.IssuePageType.PROJECT_ADHOC_ISSUE: fe = SqlExpressionBuilder.PrepareFilterExpression("OTIssue." + OTIssueEntity.FLD_NAME_IssueIdentityCategoryID, MasterDataConstants.IssueIdentityCategory.PROJECT_ADHOC_ISSUE.ToString(), SQLMatchType.Equal); lblIssueList.Text = "Project Issue List"; break; case MasterDataConstants.IssuePageType.MY_ISSUE_LIST: fe = SqlExpressionBuilder.PrepareFilterExpression("OTIssue." + OTIssueEntity.FLD_NAME_CreatedByMemberID, CurrentMember.MemberID.ToString(), SQLMatchType.Equal); Int64 employeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); if (employeeID > 0) { String fe_assignToEmployee = SqlExpressionBuilder.PrepareFilterExpression("OTIssue." + OTIssueEntity.FLD_NAME_AssignedToEmployeeID, employeeID.ToString(), SQLMatchType.Equal); fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.OR, fe_assignToEmployee); String fe_resource1 = SqlExpressionBuilder.PrepareFilterExpression(ResourceEntity.FLD_NAME_ResourceCategoryID, MasterDataConstants.ResourceCategory.EMPLOYEE.ToString(), SQLMatchType.Equal); String fe_resource2 = SqlExpressionBuilder.PrepareFilterExpression(ResourceEntity.FLD_NAME_ReferenceID, employeeID.ToString(), SQLMatchType.Equal); String fe_resource = SqlExpressionBuilder.PrepareFilterExpression(fe_resource1, SQLJoinType.AND, fe_resource2); IList <ResourceEntity> lstResource = FCCResource.GetFacadeCreate().GetIL(null, null, String.Empty, fe_resource, DatabaseOperationType.LoadWithFilterExpression); if (lstResource != null && lstResource.Count > 0) { String fe_Assigned_Issue = SqlExpressionBuilder.PrepareFilterExpression(OTIssueAssignedResourceEntity.FLD_NAME_ResourceID, lstResource[0].ResourceID.ToString(), SQLMatchType.Equal); IList <OTIssueAssignedResourceEntity> lstIssueAssignedResource = FCCOTIssueAssignedResource.GetFacadeCreate().GetIL(null, null, String.Empty, fe_Assigned_Issue, DatabaseOperationType.LoadWithFilterExpression); if (lstIssueAssignedResource != null && lstIssueAssignedResource.Count > 0) { String compositeIssueID = String.Empty; foreach (OTIssueAssignedResourceEntity ent in lstIssueAssignedResource) { compositeIssueID += ent.IssueID + ","; } if (compositeIssueID.IsNotNullOrEmpty()) { compositeIssueID = compositeIssueID.Substring(0, compositeIssueID.Length - 1); String fe_issue = "OTIssue.IssueID in(" + compositeIssueID + ")"; fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.OR, fe_issue); } } } } lblIssueList.Text = "My Issue List"; break; default: fe = SqlExpressionBuilder.PrepareFilterExpression("OTIssue." + OTIssueEntity.FLD_NAME_IssueIdentityCategoryID, MasterDataConstants.IssueIdentityCategory.PROJECT_ADHOC_ISSUE.ToString(), SQLMatchType.Equal); break; } if (chbxFilter.Checked) { String fe1 = SqlExpressionBuilder.PrepareFilterExpression("OTIssue.Title", txtSearchText.Text.ToString(), SQLMatchType.LikeWithBothMath); String fe2 = SqlExpressionBuilder.PrepareFilterExpression("MDIssuePriority.Name", txtSearchText.Text.ToString(), SQLMatchType.LikeWithSuffixMath); String fe3 = SqlExpressionBuilder.PrepareFilterExpression("MDIssueStatus.Name", txtSearchText.Text.ToString(), SQLMatchType.LikeWithSuffixMath); Int64 issueID; Int64.TryParse(txtSearchText.Text.Trim().ToString(), out issueID); String fe6 = SqlExpressionBuilder.PrepareFilterExpression("OTIssue.IssueID", issueID.ToString(), SQLMatchType.Equal); String fe4 = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.OR, fe2); String fe5 = SqlExpressionBuilder.PrepareFilterExpression(fe3, SQLJoinType.OR, fe4); String fe7 = SqlExpressionBuilder.PrepareFilterExpression(fe5, SQLJoinType.OR, fe6); fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.AND, fe7); } e.InputParameters["filterExpression"] = fe; }