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