public IList <REQRequisitionItem_DetailedEntity> GetPagedData(Int32 startRowIndex, Int32 pageSize, String sortExpression, String filterExpression) { IList <REQRequisitionItem_DetailedEntity> rEQRequisitionItem_DetailedEntityList = new List <REQRequisitionItem_DetailedEntity>(); try { if (String.IsNullOrEmpty(sortExpression)) { sortExpression = REQRequisitionItem_DetailedEntity.FLD_NAME_RequisitionItemID + " " + SQLConstants.SORT_ORDER_DESCENDING; } Int32 currentPage = Convert.ToInt32(startRowIndex / pageSize) + 1; //startRowIndex = Convert.ToInt32( startRowIndex / pageSize) + 1; if (pageSize == -1) { pageSize = 1000000000; } rEQRequisitionItem_DetailedEntityList = FCCREQRequisitionItem_Detailed.GetFacadeCreate().GetIL(pageSize, currentPage, sortExpression, filterExpression); if (rEQRequisitionItem_DetailedEntityList != null && rEQRequisitionItem_DetailedEntityList.Count > 0) { totalRowCount = rEQRequisitionItem_DetailedEntityList[0].TotalRowCount; } } catch (Exception ex) { } return(rEQRequisitionItem_DetailedEntityList ?? new List <REQRequisitionItem_DetailedEntity>()); }
protected void lvREQRequisition_ItemDataBound(object sender, ListViewItemEventArgs e) { if (e.Item.ItemType == ListViewItemType.DataItem) { ListViewDataItem dataItem = (ListViewDataItem)e.Item; REQRequisition_DetailedEntity ent = (REQRequisition_DetailedEntity)dataItem.DataItem; HyperLink hypRequisition = (HyperLink)e.Item.FindControl("hypRequisition"); Label lblRequisitionItem = (Label)e.Item.FindControl("lblRequisitionItem"); hypRequisition.NavigateUrl = UrlHelper.BuildSecureUrl("~/REQ/REQRequisitionItem.aspx", string.Empty, UrlConstants.OVERVIEW_PROJECT_ID, ent.ProjectID.ToString(), REQRequisitionEntity.FLD_NAME_RequisitionID, ent.RequisitionID.ToString(), REQRequisitionEntity.FLD_NAME_RequisitionNo, ent.RequisitionNo.ToString()).ToString(); String feReqItem = SqlExpressionBuilder.PrepareFilterExpression("REQRequisitionItem." + REQRequisitionItemEntity.FLD_NAME_RequisitionID, ent.RequisitionID.ToString(), SQLMatchType.Equal); IList <REQRequisitionItem_DetailedEntity> lst = FCCREQRequisitionItem_Detailed.GetFacadeCreate().GetIL(100000, 1, String.Empty, feReqItem); if (lst != null && lst.Count > 0) { foreach (REQRequisitionItem_DetailedEntity entREQRequisitionItem_DetailedEntity in lst) { lblRequisitionItem.Text += entREQRequisitionItem_DetailedEntity.MDItemItemName + ", "; } lblRequisitionItem.Text = lblRequisitionItem.Text.Substring(0, lblRequisitionItem.Text.Length - 2); } hypRequisition.Target = "_blank"; } }
private void SavePRMMaterialReceiveEntity() { if (IsValid) { try { PRMMaterialReceiveEntity pRMMaterialReceiveEntity = BuildPRMMaterialReceiveEntity(); #region Requisition String RequisitionNo = String.Empty; if (txtRequisition.Text.IsNotNullOrEmpty()) { RequisitionNo = "BL-" + txtRequisition.Text.ToString(); } Int64 resultRequisition = -1; Int64 resultRequisitionItem = -1; String fe = SqlExpressionBuilder.PrepareFilterExpression(REQRequisitionEntity.FLD_NAME_RequisitionNo, RequisitionNo, SQLMatchType.Equal); IList <REQRequisitionEntity> lstRequisition = FCCREQRequisition.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression); REQRequisitionItemEntity rEQRequisitionItemEntity = null; if (lstRequisition != null && lstRequisition.Count > 0) { rEQRequisitionItemEntity = BuildREQRequisitionItemEntity(lstRequisition[0].RequisitionID); pRMMaterialReceiveEntity.RequisitionID = lstRequisition[0].RequisitionID; } else { REQRequisitionEntity rEQRequisitionEntity = BuildREQRequisitionEntity(); resultRequisition = FCCREQRequisition.GetFacadeCreate().Add(rEQRequisitionEntity, DatabaseOperationType.Add, TransactionRequired.No); pRMMaterialReceiveEntity.RequisitionID = resultRequisition; if (resultRequisition > 0) { rEQRequisitionItemEntity = BuildREQRequisitionItemEntity(resultRequisition); } } if (rEQRequisitionItemEntity != null) { resultRequisitionItem = FCCREQRequisitionItem.GetFacadeCreate().Add(rEQRequisitionItemEntity, DatabaseOperationType.Add, TransactionRequired.No); } #endregion #region MRR Int64 resultOne = -1; if (pRMMaterialReceiveEntity.IsNew) { resultOne = FCCPRMMaterialReceive.GetFacadeCreate().Add(pRMMaterialReceiveEntity, DatabaseOperationType.Add, TransactionRequired.No); } else { String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(PRMMaterialReceiveEntity.FLD_NAME_MaterialReceiveID, pRMMaterialReceiveEntity.MaterialReceiveID.ToString(), SQLMatchType.Equal); resultOne = FCCPRMMaterialReceive.GetFacadeCreate().Update(pRMMaterialReceiveEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No); } #endregion if (resultOne > 0 && resultRequisitionItem > 0) { #region Material Receive Item Map Int64 resultTwo = -1; PRMMaterialReceiveItemMapEntity pRMMaterialReceiveItemMapEntity = BuildPRMMaterialReceiveItemMapEntity(resultOne, resultRequisitionItem); resultTwo = FCCPRMMaterialReceiveItemMap.GetFacadeCreate().Add(pRMMaterialReceiveItemMapEntity, DatabaseOperationType.Add, TransactionRequired.No); #endregion try { #region Inventory Int64 _employeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); Int64 _projectID = Int64.Parse(ddlProjectID.SelectedValue); INVStoreEntity storeEntity = INVManager.GetDefaultStore(_projectID); Int64 storeID = storeEntity.StoreID; INVStoreUnitEntity storeUnitEntity = INVManager.GetDefaultStoreUnit(storeID); Int64 storeUnitID = storeUnitEntity.StoreUnitID; String fe_requisitionItem = SqlExpressionBuilder.PrepareFilterExpression("REQRequisitionItem." + REQRequisitionItemEntity.FLD_NAME_RequisitionItemID, resultRequisitionItem.ToString(), SQLMatchType.Equal); IList <REQRequisitionItem_DetailedEntity> lst = FCCREQRequisitionItem_Detailed.GetFacadeCreate().GetIL(10000, 1, String.Empty, fe_requisitionItem); Int64 _itemID = 0; Decimal _rate = 0; Int64 brandID = MasterDataConstants.ItemDefaults.DEFAULT_BRAD; Int64 regionID = MasterDataConstants.ItemDefaults.DEFAULT_REGION; Int64 countryID = MasterDataConstants.ItemDefaults.DEFAULT_COUNTRY; if (lst != null && lst.Count > 0) { _itemID = lst[0].ItemID; brandID = (Int64)lst[0].BrandID; regionID = (Int64)lst[0].RegionID; countryID = (Int64)lst[0].CountryID; _rate = lst[0].Rate; } Boolean invResult = INVManager.AddItemsToStoreUnit(_itemID, brandID, regionID, countryID, "", Int64.Parse(txtReceiveQty.Text.ToString()), MiscUtil.GetLocalIP(), _employeeID, _rate, txtRequisition.Text, ddlWorkOrderID.SelectedItem.Text, resultOne.ToString(), "", Int64.Parse(ddlProjectID.SelectedValue), storeID, storeUnitID); #endregion } catch (Exception ex) { } _MaterialReceiveID = resultOne; PrepareInitialViewSave(); btnAddNew.Visible = true; if (pRMMaterialReceiveEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Material Receive Information has been added successfully.", false); } else { MiscUtil.ShowMessage(lblMessage, "Material Receive Information has been updated successfully.", false); } } else { if (pRMMaterialReceiveEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Failed to add Material Receive Information.", false); } else { MiscUtil.ShowMessage(lblMessage, "Failed to update Material Receive Information.", false); } } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } }
protected void lvAPMemberFeedback_ItemDataBound(object sender, ListViewItemEventArgs e) { if (e.Item.ItemType == ListViewItemType.DataItem) { ListViewDataItem dataItem = (ListViewDataItem)e.Item; APMemberFeedback_DetailedEntity ent = (APMemberFeedback_DetailedEntity)dataItem.DataItem; APApprovalProcessEntity aPApprovalProcessEntity = APRobot.GetApprovalProcessByID(ent.APApprovalProcessID); HyperLink lnkViewDetails = (HyperLink)e.Item.FindControl("lnkViewDetails"); HyperLink lnkShowApprovalStatus = (HyperLink)e.Item.FindControl("lnkShowApprovalStatus"); Label lblTitle = (Label)e.Item.FindControl("lblTitle"); Label lblAPType = (Label)e.Item.FindControl("lblAPType"); Label lblItemDetail = (Label)e.Item.FindControl("lblItemDetail"); lblTitle.Text = aPApprovalProcessEntity.Title; if (aPApprovalProcessEntity.APTypeID == MasterDataConstants.APType.REQUISITION) { lnkViewDetails.NavigateUrl = UrlHelper.BuildSecureUrl( "~/REQ/REQRequisitionDetailsWithApproval.aspx", string.Empty, UrlConstants.REQUISITION_ID, aPApprovalProcessEntity.ReferenceID.ToString(), APMemberFeedbackEntity.FLD_NAME_APMemberFeedbackID, ent.APMemberFeedbackID.ToString(), APMemberFeedbackEntity.FLD_NAME_APApprovalProcessID, ent.APApprovalProcessID.ToString() ).ToString(); String feReqItem = SqlExpressionBuilder.PrepareFilterExpression("REQRequisitionItem." + REQRequisitionItemEntity.FLD_NAME_RequisitionID, aPApprovalProcessEntity.ReferenceID.ToString(), SQLMatchType.Equal); IList <REQRequisitionItem_DetailedEntity> lst = FCCREQRequisitionItem_Detailed.GetFacadeCreate().GetIL(100000, 1, String.Empty, feReqItem); lblAPType.Text = "Requisition"; if (lst != null && lst.Count > 0) { lblItemDetail.Text = "Items ("; foreach (REQRequisitionItem_DetailedEntity entREQRequisitionItem_DetailedEntity in lst) { lblItemDetail.Text += entREQRequisitionItem_DetailedEntity.MDItemItemName + ", "; } lblItemDetail.Text += ")"; } } else if (aPApprovalProcessEntity.APTypeID == MasterDataConstants.APType.WORK_ORDER) { lnkViewDetails.NavigateUrl = UrlHelper.BuildSecureUrl( "~/PRM/PRMWorkOrderViewWithApproval.aspx", string.Empty, UrlConstants.OVERVIEW_WORKORDER_ID, aPApprovalProcessEntity.ReferenceID.ToString(), APMemberFeedbackEntity.FLD_NAME_APMemberFeedbackID, ent.APMemberFeedbackID.ToString(), APMemberFeedbackEntity.FLD_NAME_APApprovalProcessID, ent.APApprovalProcessID.ToString() ).ToString(); lblAPType.Text = "Work Order"; } else if (aPApprovalProcessEntity.APTypeID == MasterDataConstants.APType.BILL) { lnkViewDetails.NavigateUrl = UrlHelper.BuildSecureUrl( "~/CM/CMBillDetailsWithApproval.aspx", string.Empty, UrlConstants.OVERVIEW_CM_BILL_ID, aPApprovalProcessEntity.ReferenceID.ToString(), APMemberFeedbackEntity.FLD_NAME_APMemberFeedbackID, ent.APMemberFeedbackID.ToString(), APMemberFeedbackEntity.FLD_NAME_APApprovalProcessID, ent.APApprovalProcessID.ToString() ).ToString(); lblAPType.Text = "Bill"; } else if (aPApprovalProcessEntity.APTypeID == MasterDataConstants.APType.PAYABLE_STATEMENT) { lnkViewDetails.NavigateUrl = UrlHelper.BuildSecureUrl( "~/ACC/ACCPostPayableStatementDetailWithApproval.aspx", string.Empty, UrlConstants.OVERVIEW_POST_PAYABLE_STATEMENT_DETAIL_ID, aPApprovalProcessEntity.ReferenceID.ToString(), APMemberFeedbackEntity.FLD_NAME_APMemberFeedbackID, ent.APMemberFeedbackID.ToString(), APMemberFeedbackEntity.FLD_NAME_APApprovalProcessID, ent.APApprovalProcessID.ToString() ).ToString(); lblAPType.Text = "Payable Statement"; } else if (aPApprovalProcessEntity.APTypeID == MasterDataConstants.APType.TRF) { lnkViewDetails.NavigateUrl = UrlHelper.BuildSecureUrl( "~/INV/INVTransferItemDetailsWithApproval.aspx", string.Empty, UrlConstants.OVERVIEW_TRANSFER_ID, aPApprovalProcessEntity.ReferenceID.ToString(), APMemberFeedbackEntity.FLD_NAME_APMemberFeedbackID, ent.APMemberFeedbackID.ToString(), APMemberFeedbackEntity.FLD_NAME_APApprovalProcessID, ent.APApprovalProcessID.ToString() ).ToString(); lblAPType.Text = "TRF"; } else if (aPApprovalProcessEntity.APTypeID == MasterDataConstants.APType.BANK_DEPOSIT) { lnkViewDetails.NavigateUrl = UrlHelper.BuildSecureUrl( "~/AC/ACBankAccountDepositDetailsWithApproval.aspx", string.Empty, UrlConstants.OVERVIEW_BANK_ACCOUNT_DEPOSIT_ID, aPApprovalProcessEntity.ReferenceID.ToString(), APMemberFeedbackEntity.FLD_NAME_APMemberFeedbackID, ent.APMemberFeedbackID.ToString(), APMemberFeedbackEntity.FLD_NAME_APApprovalProcessID, ent.APApprovalProcessID.ToString() ).ToString(); lblAPType.Text = "BANK DEPOSIT"; } else if (aPApprovalProcessEntity.APTypeID == MasterDataConstants.APType.BANK_PAYMENT) { lnkViewDetails.NavigateUrl = UrlHelper.BuildSecureUrl( "~/AC/ACBankAccountPaymentDetailsWithApproval.aspx", string.Empty, UrlConstants.OVERVIEW_BANK_ACCOUNT_PAYMENT_ID, aPApprovalProcessEntity.ReferenceID.ToString(), APMemberFeedbackEntity.FLD_NAME_APMemberFeedbackID, ent.APMemberFeedbackID.ToString(), APMemberFeedbackEntity.FLD_NAME_APApprovalProcessID, ent.APApprovalProcessID.ToString() ).ToString(); lblAPType.Text = "BANK PAYMENT"; } else if (aPApprovalProcessEntity.APTypeID == MasterDataConstants.APType.TEMPORARY_JOURNAL) { lnkViewDetails.NavigateUrl = UrlHelper.BuildSecureUrl( "~/AC/ACJournalDetailsWithApproval.aspx", string.Empty, UrlConstants.OVERVIEW_TEMPORARY_JOURNAL_ID, aPApprovalProcessEntity.ReferenceID.ToString(), APMemberFeedbackEntity.FLD_NAME_APMemberFeedbackID, ent.APMemberFeedbackID.ToString(), APMemberFeedbackEntity.FLD_NAME_APApprovalProcessID, ent.APApprovalProcessID.ToString() ).ToString(); lblAPType.Text = "JOURNAL ENTRY"; } else if (aPApprovalProcessEntity.APTypeID == MasterDataConstants.APType.BANK_ACCOUNT_TRANSFER) { lnkViewDetails.NavigateUrl = UrlHelper.BuildSecureUrl( "~/AC/ACBankAccountTransferDetailsWithApproval.aspx", string.Empty, UrlConstants.OVERVIEW_BANK_ACCOUNT_TRANSFER_ID, aPApprovalProcessEntity.ReferenceID.ToString(), APMemberFeedbackEntity.FLD_NAME_APMemberFeedbackID, ent.APMemberFeedbackID.ToString(), APMemberFeedbackEntity.FLD_NAME_APApprovalProcessID, ent.APApprovalProcessID.ToString() ).ToString(); lblAPType.Text = "BANK ACCOUNT TRANSFER"; } else if (aPApprovalProcessEntity.APTypeID == MasterDataConstants.APType.MRR) { lnkViewDetails.NavigateUrl = UrlHelper.BuildSecureUrl( "~/PRM/PRMMaterialReceiveDetailsWithApproval.aspx", string.Empty, UrlConstants.OVERVIEW_MATERIAL_RECEIVE_ID, aPApprovalProcessEntity.ReferenceID.ToString(), APMemberFeedbackEntity.FLD_NAME_APMemberFeedbackID, ent.APMemberFeedbackID.ToString(), APMemberFeedbackEntity.FLD_NAME_APApprovalProcessID, ent.APApprovalProcessID.ToString() ).ToString(); lblAPType.Text = "MATERIAL RECEIVE"; } else if (aPApprovalProcessEntity.APTypeID == MasterDataConstants.APType.AGREEMENT) { lnkViewDetails.NavigateUrl = UrlHelper.BuildSecureUrl( "~/CRM/CRMAgreementDetailsWithApproval.aspx", string.Empty, UrlConstants.OVERVIEW_AGREEMENT_ID, aPApprovalProcessEntity.ReferenceID.ToString(), APMemberFeedbackEntity.FLD_NAME_APMemberFeedbackID, ent.APMemberFeedbackID.ToString(), APMemberFeedbackEntity.FLD_NAME_APApprovalProcessID, ent.APApprovalProcessID.ToString() ).ToString(); lblAPType.Text = "AGREEMENT"; } else if (aPApprovalProcessEntity.APTypeID == MasterDataConstants.APType.CONTACT_LIST) { lnkViewDetails.NavigateUrl = UrlHelper.BuildSecureUrl("~/BD/BDProcessAssignedResourceDetailsWithApproval.aspx", string.Empty, UrlConstants.OVERVIEW_PROCESS_ASSIGNED_RESOURCE_ID, aPApprovalProcessEntity.ReferenceID.ToString(), APMemberFeedbackEntity.FLD_NAME_APMemberFeedbackID, ent.APMemberFeedbackID.ToString(), APMemberFeedbackEntity.FLD_NAME_APApprovalProcessID, ent.APApprovalProcessID.ToString() ).ToString(); lblAPType.Text = "CONTACT_LIST"; } else if (aPApprovalProcessEntity.APTypeID == MasterDataConstants.APType.LOAN_APPLICATION) { lnkViewDetails.NavigateUrl = UrlHelper.BuildSecureUrl("~/HR/HREmployeeLoanApplicationDetailsWithApproval.aspx", string.Empty, UrlConstants.OVERVIEW_LOAN_APPLICATION_ID, aPApprovalProcessEntity.ReferenceID.ToString(), APMemberFeedbackEntity.FLD_NAME_APMemberFeedbackID, ent.APMemberFeedbackID.ToString(), APMemberFeedbackEntity.FLD_NAME_APApprovalProcessID, ent.APApprovalProcessID.ToString() ).ToString(); lblAPType.Text = "LOAN_APPLICATION"; } else if (aPApprovalProcessEntity.APTypeID == MasterDataConstants.APType.LEAVE_APPLICATION) { lnkViewDetails.NavigateUrl = UrlHelper.BuildSecureUrl("~/HR/HREmployeeLeaveApplicationWithApproval.aspx", string.Empty, UrlConstants.OVERVIEW_LEAVE_APPLICATION_ID, aPApprovalProcessEntity.ReferenceID.ToString(), APMemberFeedbackEntity.FLD_NAME_APMemberFeedbackID, ent.APMemberFeedbackID.ToString(), APMemberFeedbackEntity.FLD_NAME_APApprovalProcessID, ent.APApprovalProcessID.ToString() ).ToString(); lblAPType.Text = "LEAVE_APPLICATION"; } else if (aPApprovalProcessEntity.APTypeID == MasterDataConstants.APType.CUSTOM) { lnkViewDetails.NavigateUrl = "#"; lblAPType.Text = "Custom"; } lnkShowApprovalStatus.NavigateUrl = UrlHelper.BuildSecureUrl( "~/AP/APView.aspx", string.Empty, APApprovalProcessEntity.FLD_NAME_APApprovalProcessID, aPApprovalProcessEntity.APApprovalProcessID.ToString() ).ToString(); //lnkViewDetails.Target = "_blank"; lnkShowApprovalStatus.Target = "_blank"; } }
protected void lvREQRequisition_ItemDataBound(object sender, ListViewItemEventArgs e) { if (e.Item.ItemType == ListViewItemType.DataItem) { ListViewDataItem dataItem = (ListViewDataItem)e.Item; REQRequisition_DetailedEntity ent = (REQRequisition_DetailedEntity)dataItem.DataItem; HyperLink hypRequisition = (HyperLink)e.Item.FindControl("hypRequisition"); HyperLink hypEdit = (HyperLink)e.Item.FindControl("lnkBtnEdit"); HyperLink hypRequisitionReport = (HyperLink)e.Item.FindControl("hypRequisitionReport"); HyperLink hypCRMAdRequisitionReport = (HyperLink)e.Item.FindControl("hypCRMAdRequisitionReport"); HyperLink hypRequisitionDetail = (HyperLink)e.Item.FindControl("hypRequisitionDetail"); HyperLink lnkShowApprovalStatus = (HyperLink)e.Item.FindControl("lnkShowApprovalStatus"); Label lblRequisitionItem = (Label)e.Item.FindControl("lblRequisitionItem"); Label lblWorkOrderCreated = (Label)e.Item.FindControl("lblWorkOrderCreated"); if (ent.RequisitionStatusID == MasterDataConstants.RequisitionStatus.MIGRATE_TO_TRF) { String fe_TRF = SqlExpressionBuilder.PrepareFilterExpression(INVTransferEntity.FLD_NAME_RequisitionID, ent.RequisitionID.ToString(), SQLMatchType.Equal); IList <INVTransferEntity> iNVTransferEntityList = FCCINVTransfer.GetFacadeCreate().GetIL(null, null, String.Empty, fe_TRF, DatabaseOperationType.LoadWithFilterExpression); if (iNVTransferEntityList != null && iNVTransferEntityList.Count > 0) { Panel pnlTRFNoLV = (Panel)e.Item.FindControl("pnlTRFNoLV"); foreach (INVTransferEntity invTransferEntity in iNVTransferEntityList) { HyperLink hypTRFNoLV = new HyperLink(); hypTRFNoLV.Text = iNVTransferEntityList[0].TRFNo; hypTRFNoLV.NavigateUrl = UrlHelper.BuildSecureUrl("~/INV/INVTransferItem.aspx", string.Empty, UrlConstants.OVERVIEW_TRANSFER_ID, invTransferEntity.TransferID.ToString()).ToString(); hypTRFNoLV.Target = "_blank"; hypTRFNoLV.CssClass = "CommonButtonLink"; pnlTRFNoLV.Controls.Add(hypTRFNoLV); pnlTRFNoLV.Controls.Add(new LiteralControl("<br/>")); } } } Boolean IsAdvertisementRequisition = false; String feReqItem = SqlExpressionBuilder.PrepareFilterExpression("REQRequisitionItem." + REQRequisitionItemEntity.FLD_NAME_RequisitionID, ent.RequisitionID.ToString(), SQLMatchType.Equal); IList <REQRequisitionItem_DetailedEntity> lst = FCCREQRequisitionItem_Detailed.GetFacadeCreate().GetIL(100000, 1, String.Empty, feReqItem); if (lst != null && lst.Count > 0) { foreach (REQRequisitionItem_DetailedEntity entREQRequisitionItem_DetailedEntity in lst) { lblRequisitionItem.Text += entREQRequisitionItem_DetailedEntity.MDItemItemName + ", "; if (entREQRequisitionItem_DetailedEntity.ItemCategoryID == MasterDataConstants.ItemDefaults.DEFAULT_ADVERTIESMENT_ITEM_CATEGORY) { IsAdvertisementRequisition = true; } } lblRequisitionItem.Text = lblRequisitionItem.Text.Substring(0, lblRequisitionItem.Text.Length - 2); } IList <PRMWorkOrderNoByRequisition_CustomEntity> lstWONO = FCCPRMWorkOrderNoByRequisition_Custom.GetFacadeCreate().GetIL(Int64.Parse(ent.RequisitionID.ToString())); if (lstWONO != null && lstWONO.Count > 0) { lblWorkOrderCreated.Text = lstWONO[0].WorkOrderNo.ToString(); } String fe_req = SqlExpressionBuilder.PrepareFilterExpression("PRMWorkOrderItemMap." + PRMWorkOrderItemMapEntity.FLD_NAME_RequisitionID, ent.RequisitionID.ToString(), SQLMatchType.Equal); IList <PRMWorkOrderItemMap_DetailedEntity> lstPRMWorkOrderItemMap = FCCPRMWorkOrderItemMap_Detailed.GetFacadeCreate().GetIL(10000, 1, String.Empty, fe_req); if (lstPRMWorkOrderItemMap != null && lstPRMWorkOrderItemMap.Count > 0) { Panel pnlWorkOrderLV = (Panel)e.Item.FindControl("pnlWorkOrderLV"); List <PRMWorkOrderItemMap_DetailedEntity> distinct = lstPRMWorkOrderItemMap .GroupBy(car => car.WorkOrderID) .Select(g => g.First()) .ToList(); foreach (PRMWorkOrderItemMap_DetailedEntity pRMWorkOrderItemMapEntity in distinct) { HyperLink hypWorkOrder = new HyperLink(); hypWorkOrder.Text = pRMWorkOrderItemMapEntity.WorkOrderNo.ToString(); hypWorkOrder.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.WORK_ORDER_REPORT, UrlConstants.OVERVIEW_WORKORDER_ID, pRMWorkOrderItemMapEntity.WorkOrderID.ToString()).ToString(); hypWorkOrder.Target = "_blank"; hypWorkOrder.CssClass = "CommonButtonLink"; pnlWorkOrderLV.Controls.Add(hypWorkOrder); pnlWorkOrderLV.Controls.Add(new LiteralControl("<br/>")); String fe_mrr = SqlExpressionBuilder.PrepareFilterExpression(PRMMaterialReceiveEntity.FLD_NAME_WorkOrderID, pRMWorkOrderItemMapEntity.WorkOrderID.ToString(), SQLMatchType.Equal); IList <PRMMaterialReceiveEntity> lstPRMMaterialReceive = FCCPRMMaterialReceive.GetFacadeCreate().GetIL(null, null, String.Empty, fe_mrr, DatabaseOperationType.LoadWithFilterExpression); if (lstPRMMaterialReceive != null && lstPRMMaterialReceive.Count > 0) { Panel pnlMRRLV = (Panel)e.Item.FindControl("pnlMRRLV"); foreach (PRMMaterialReceiveEntity pRMMaterialReceiveEntity in lstPRMMaterialReceive) { HyperLink hypMaterialReceive = new HyperLink(); hypMaterialReceive.Text = pRMMaterialReceiveEntity.MRRNo; hypMaterialReceive.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", "MaterialReceiveReport", UrlConstants.OVERVIEW_MATERIAL_RECEIVE_ID, pRMMaterialReceiveEntity.MaterialReceiveID.ToString()).ToString(); hypMaterialReceive.Target = "_blank"; hypMaterialReceive.CssClass = "CommonButtonLink"; pnlMRRLV.Controls.Add(hypMaterialReceive); pnlMRRLV.Controls.Add(new LiteralControl("<br/>")); } } } } if (ent.RequisitionStatusID == MasterDataConstants.RequisitionStatus.APPROVED || ent.RequisitionStatusID == MasterDataConstants.RequisitionStatus.MIGRATE_TO_TRF) { hypEdit.Visible = false; } String NavigationUrl = String.Empty; NavigationUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", "RequisitionReport", UrlConstants.REQUISITION_ID, ent.RequisitionID.ToString()).ToString(); if (IsAdvertisementRequisition) { NavigationUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.CRM_AD_REQUISITION_REPORT, UrlConstants.REQUISITION_ID, ent.RequisitionID.ToString()).ToString(); } hypRequisitionReport.NavigateUrl = NavigationUrl; hypRequisitionReport.Target = "_blank"; hypEdit.NavigateUrl = UrlHelper.BuildSecureUrl("~/REQ/REQRequisition.aspx", string.Empty, "do", "Edit", UrlConstants.REQUISITION_ID, ent.RequisitionID.ToString()).ToString(); if (this.OverviewProjectID > 0) { hypRequisition.NavigateUrl = UrlHelper.BuildSecureUrl("~/BD/BDProjectRequisitionItem.aspx", string.Empty, UrlConstants.OVERVIEW_PROJECT_ID, this.OverviewProjectID.ToString(), REQRequisitionEntity.FLD_NAME_RequisitionID, ent.RequisitionID.ToString(), REQRequisitionEntity.FLD_NAME_RequisitionNo, ent.RequisitionNo.ToString()).ToString(); } else { hypRequisition.NavigateUrl = UrlHelper.BuildSecureUrl("~/REQ/REQRequisitionItem.aspx", string.Empty, UrlConstants.OVERVIEW_PROJECT_ID, this.OverviewProjectID.ToString(), REQRequisitionEntity.FLD_NAME_RequisitionID, ent.RequisitionID.ToString(), REQRequisitionEntity.FLD_NAME_RequisitionNo, ent.RequisitionNo.ToString()).ToString(); hypRequisitionDetail.NavigateUrl = UrlHelper.BuildSecureUrl("~/Site/REQRequisitionItemView.aspx", string.Empty, UrlConstants.OVERVIEW_PROJECT_ID, this.OverviewProjectID.ToString(), REQRequisitionEntity.FLD_NAME_RequisitionID, ent.RequisitionID.ToString(), REQRequisitionEntity.FLD_NAME_RequisitionNo, ent.RequisitionNo.ToString()).ToString(); } APApprovalProcessEntity aPApprovalProcessEntity = APRobot.GetApprovalProcessByTypeAndReference(MasterDataConstants.APType.REQUISITION, ent.RequisitionID); 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; } hypEdit.Target = "_blank"; hypRequisitionReport.Target = "_blank"; hypRequisitionDetail.Target = "_blank"; } }