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