public IList <ACTemporaryJournal_DetailedEntity> GetPagedData(Int32 startRowIndex, Int32 pageSize, String sortExpression, String filterExpression) { IList <ACTemporaryJournal_DetailedEntity> aCTemporaryJournal_DetailedEntityList = new List <ACTemporaryJournal_DetailedEntity>(); try { if (String.IsNullOrEmpty(sortExpression)) { sortExpression = "TemporaryJournalID"; } Int32 currentPage = Convert.ToInt32(startRowIndex / pageSize) + 1; //startRowIndex = Convert.ToInt32( startRowIndex / pageSize) + 1; if (pageSize == -1) { pageSize = 1000000000; } aCTemporaryJournal_DetailedEntityList = FCCACTemporaryJournal_Detailed.GetFacadeCreate().GetIL(pageSize, currentPage, sortExpression, filterExpression); if (aCTemporaryJournal_DetailedEntityList != null && aCTemporaryJournal_DetailedEntityList.Count > 0) { totalRowCount = aCTemporaryJournal_DetailedEntityList[0].TotalRowCount; } } catch (Exception ex) { } return(aCTemporaryJournal_DetailedEntityList ?? new List <ACTemporaryJournal_DetailedEntity>()); }
protected void lvACTemporaryJournalMaster_ItemDataBound(object sender, ListViewItemEventArgs e) { if (e.Item.ItemType == ListViewItemType.DataItem) { ListViewDataItem dataItem = (ListViewDataItem)e.Item; ACTemporaryJournalMaster_DetailedEntity ent = (ACTemporaryJournalMaster_DetailedEntity)dataItem.DataItem; HyperLink hypCreateDate = (HyperLink)e.Item.FindControl("hypCreateDate"); HyperLink lnkShowApprovalStatus = (HyperLink)e.Item.FindControl("lnkShowApprovalStatus"); HyperLink hypJournalReport = (HyperLink)e.Item.FindControl("hypJournalReport"); hypJournalReport.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.MANUAL_JOURNAL_REPORT, UrlConstants.OVERVIEW_TEMPORARY_JOURNAL_MASTER_ID, ent.TemporaryJournalMasterID.ToString()).ToString(); APApprovalProcessEntity aPApprovalProcessEntity = APRobot.GetApprovalProcessByTypeAndReference(MasterDataConstants.APType.TEMPORARY_JOURNAL, ent.TemporaryJournalMasterID); if (aPApprovalProcessEntity.APApprovalProcessID > 0) { lnkShowApprovalStatus.NavigateUrl = UrlHelper.BuildSecureUrl( "~/AP/APView.aspx", string.Empty, APApprovalProcessEntity.FLD_NAME_APApprovalProcessID, aPApprovalProcessEntity.APApprovalProcessID.ToString() ).ToString(); lnkShowApprovalStatus.Target = "_blank"; } else { lnkShowApprovalStatus.NavigateUrl = String.Empty; lnkShowApprovalStatus.Enabled = false; } Label lblDetailLV = (Label)e.Item.FindControl("lblDetailLV"); String feItem = SqlExpressionBuilder.PrepareFilterExpression("ACTemporaryJournal." + ACTemporaryJournalEntity.FLD_NAME_TemporaryJournalMasterID, ent.TemporaryJournalMasterID.ToString(), SQLMatchType.Equal); IList <ACTemporaryJournal_DetailedEntity> lst = FCCACTemporaryJournal_Detailed.GetFacadeCreate().GetIL(10000, 1, String.Empty, feItem); if (lst != null && lst.Count > 0) { foreach (ACTemporaryJournal_DetailedEntity aCTemporaryJournal_DetailedEntity in lst) { lblDetailLV.Text += aCTemporaryJournal_DetailedEntity.ACAccountAccountName + ", "; Panel pnlOtherInfo = (Panel)e.Item.FindControl("pnlOtherInfo"); if (aCTemporaryJournal_DetailedEntity.RequisitionID > 0) { HyperLink hypRequisitionLV = new HyperLink(); String st = "Requisition :"; hypRequisitionLV.Text = "<font color=\"black\"><b>" + st + "</font></b>" + aCTemporaryJournal_DetailedEntity.RequisitionNo; hypRequisitionLV.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.REQUISITION_REPORT, UrlConstants.REQUISITION_ID, aCTemporaryJournal_DetailedEntity.RequisitionID.ToString()).ToString(); hypRequisitionLV.Target = "_blank"; hypRequisitionLV.CssClass = "CommonButtonLink"; pnlOtherInfo.Controls.Add(hypRequisitionLV); pnlOtherInfo.Controls.Add(new LiteralControl("<br/>")); } if (aCTemporaryJournal_DetailedEntity.WorkOrderID > 0) { HyperLink hypWorkOrderLV = new HyperLink(); String st = "Work Order :"; hypWorkOrderLV.Text = "<font color=\"black\"><b>" + st + "</font></b>" + aCTemporaryJournal_DetailedEntity.WorkOrderNo; hypWorkOrderLV.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.WORK_ORDER_REPORT, UrlConstants.OVERVIEW_WORKORDER_ID, aCTemporaryJournal_DetailedEntity.WorkOrderID.ToString()).ToString(); hypWorkOrderLV.Target = "_blank"; hypWorkOrderLV.CssClass = "CommonButtonLink"; pnlOtherInfo.Controls.Add(hypWorkOrderLV); pnlOtherInfo.Controls.Add(new LiteralControl("<br/>")); } if (aCTemporaryJournal_DetailedEntity.BillID > 0) { HyperLink hypBillLV = new HyperLink(); String st = "Bill :"; hypBillLV.Text = "<font color=\"black\"><b>" + st + "</font></b>" + aCTemporaryJournal_DetailedEntity.BillNo; hypBillLV.NavigateUrl = String.Empty; hypBillLV.Target = "_blank"; hypBillLV.CssClass = "CommonButtonLink"; pnlOtherInfo.Controls.Add(hypBillLV); pnlOtherInfo.Controls.Add(new LiteralControl("<br/>")); } } lblDetailLV.Text = lblDetailLV.Text.Substring(0, lblDetailLV.Text.Length - 2); } hypCreateDate.NavigateUrl = UrlHelper.BuildSecureUrl("~/AC/ACTemporaryJournal.aspx", string.Empty, UrlConstants.OVERVIEW_TEMPORARY_JOURNAL_MASTER_ID, ent.TemporaryJournalMasterID.ToString()).ToString(); hypCreateDate.Target = "_blank"; hypJournalReport.Target = "_blank"; } }