public IList <CMBillEntity> GetPagedData(Int32 startRowIndex, Int32 pageSize, String sortExpression) { IList <CMBillEntity> cMBillEntityList = new List <CMBillEntity>(); try { if (pageSize == -1) { pageSize = 1000000000; } if (String.IsNullOrEmpty(sortExpression)) { sortExpression = CMBillEntity.FLD_NAME_BillID + " " + SQLConstants.SORT_ORDER_DESCENDING; } startRowIndex = Convert.ToInt32(startRowIndex / pageSize) + 1; cMBillEntityList = FCCCMBill.GetFacadeCreate().GetIL(startRowIndex, pageSize, sortExpression, null, DatabaseOperationType.LoadPagedWithSortExpression); if (cMBillEntityList != null && cMBillEntityList.Count > 0) { totalRowCount = cMBillEntityList[0].TotalRowCount; } } catch (Exception ex) { } return(cMBillEntityList ?? new List <CMBillEntity>()); }
protected void lvCMBill_ItemCommand(object sender, ListViewCommandEventArgs e) { Int64 BillID; Int64.TryParse(e.CommandArgument.ToString(), out BillID); if (BillID > 0) { if (string.Equals(e.CommandName, "EditItem")) { _BillID = BillID; PrepareEditView(); if (CurrentCMBillEntity != null) { if (CurrentCMBillEntity.BillApprovalStatusID != MasterDataConstants.BillApprovalStatus.INITIATED) { } } } else if (string.Equals(e.CommandName, "DeleteItem")) { try { Int64 result = -1; String fe = SqlExpressionBuilder.PrepareFilterExpression(CMBillEntity.FLD_NAME_BillID, BillID.ToString(), SQLMatchType.Equal); CMBillEntity cMBillEntity = new CMBillEntity(); result = FCCCMBill.GetFacadeCreate().Delete(cMBillEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No); if (result == 0) { _BillID = 0; _CMBillEntity = new CMBillEntity(); PrepareInitialView(); BindCMBillList(); MiscUtil.ShowMessage(lblMessage, "Bill has been successfully deleted.", true); } else { MiscUtil.ShowMessage(lblMessage, "Failed to delete Bill.", true); } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } } }
protected void lvCMBill_ItemCommand(object sender, ListViewCommandEventArgs e) { Int64 BillID; Int64.TryParse(e.CommandArgument.ToString(), out BillID); if (BillID > 0) { if (string.Equals(e.CommandName, "EditItem")) { _BillID = BillID; String url = UrlHelper.BuildSecureUrl("~/CM/CMBill.aspx", string.Empty, UrlConstants.OVERVIEW_CM_BILL_ID, BillID.ToString()).ToString(); Response.Redirect(url); } else if (string.Equals(e.CommandName, "DeleteItem")) { try { Int64 result = -1; String fe = SqlExpressionBuilder.PrepareFilterExpression(CMBillEntity.FLD_NAME_BillID, BillID.ToString(), SQLMatchType.Equal); CMBillEntity cMBillEntity = new CMBillEntity(); result = FCCCMBill.GetFacadeCreate().Delete(cMBillEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No); if (result == 0) { _BillID = 0; _CMBillEntity = new CMBillEntity(); BindCMBillList(); MiscUtil.ShowMessage(lblMessage, "C MBill has been successfully deleted.", true); } else { MiscUtil.ShowMessage(lblMessage, "Failed to delete C MBill.", true); } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } } }
public IList <CMBillEntity> GetData() { IList <CMBillEntity> cMBillEntityList = new List <CMBillEntity>(); try { cMBillEntityList = FCCCMBill.GetFacadeCreate().GetIL(null, null, null, null, DatabaseOperationType.Load); if (cMBillEntityList != null && cMBillEntityList.Count > 0) { totalRowCount = cMBillEntityList[0].TotalRowCount; } } catch (Exception ex) { } return(cMBillEntityList ?? new List <CMBillEntity>()); }
protected void lvPRMWorkOrder_ItemDataBound(object sender, ListViewItemEventArgs e) { if (e.Item.ItemType == ListViewItemType.DataItem) { ListViewDataItem dataItem = (ListViewDataItem)e.Item; PRMWorkOrder_DetailedEntity ent = (PRMWorkOrder_DetailedEntity)dataItem.DataItem; HyperLink hypWorkOrderFloorwiseReport = (HyperLink)e.Item.FindControl("hypWorkOrderFloorwiseReport"); HyperLink hypWorkOrderNo = (HyperLink)e.Item.FindControl("hypWorkOrderNo"); HyperLink hypWorkOrderReport = (HyperLink)e.Item.FindControl("hypWorkOrderReport"); HyperLink hypWorkOrderAnnexureReport = (HyperLink)e.Item.FindControl("hypWorkOrderAnnexureReport"); HyperLink hypWorkOrderPaymentTerm = (HyperLink)e.Item.FindControl("hypWorkOrderPaymentTerm"); HyperLink lnkShowApprovalStatus = (HyperLink)e.Item.FindControl("lnkShowApprovalStatus"); LinkButton lnkBtnEdit = (LinkButton)e.Item.FindControl("lnkBtnEdit"); Button btnResetWorkOrderLV = (Button)e.Item.FindControl("btnResetWorkOrderLV"); hypWorkOrderPaymentTerm.NavigateUrl = UrlHelper.BuildSecureUrl("~/PRM/PRMWorkOrderPaymentTerm.aspx", string.Empty, UrlConstants.OVERVIEW_WORKORDER_ID, ent.WorkOrderID.ToString(), PRMWorkOrderEntity.FLD_NAME_WorkOrderNo, ent.WorkOrderNo).ToString(); hypWorkOrderNo.NavigateUrl = UrlHelper.BuildSecureUrl("~/PRM/PRMWorkOrderItemMap.aspx", string.Empty, UrlConstants.OVERVIEW_WORKORDER_ID, ent.WorkOrderID.ToString(), PRMWorkOrderEntity.FLD_NAME_WorkOrderNo, ent.WorkOrderNo).ToString(); hypWorkOrderReport.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.WORK_ORDER_REPORT, UrlConstants.OVERVIEW_WORKORDER_ID, ent.WorkOrderID.ToString()).ToString(); hypWorkOrderAnnexureReport.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.WORK_ORDER_REPORT_WITH_ANNEXURE, UrlConstants.OVERVIEW_WORKORDER_ID, ent.WorkOrderID.ToString()).ToString(); hypWorkOrderFloorwiseReport.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.WORK_ORDER_ITEM_FLOOR_DETAIL, UrlConstants.OVERVIEW_WORKORDER_ID, ent.WorkOrderID.ToString()).ToString(); APApprovalProcessEntity aPApprovalProcessEntity = APRobot.GetApprovalProcessByTypeAndReference(MasterDataConstants.APType.WORK_ORDER, ent.WorkOrderID); 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; } if (ent.WorkOrderStatusID == MasterDataConstants.WorkOrderStatus.APPROVED || ent.WorkOrderStatusID == MasterDataConstants.WorkOrderStatus.IN_APPROVE_PROCESS) { lnkBtnEdit.Visible = false; hypWorkOrderNo.NavigateUrl = String.Empty; hypWorkOrderPaymentTerm.NavigateUrl = String.Empty; } Panel pnlRequisitonNoLV = (Panel)e.Item.FindControl("pnlRequisitonNoLV"); Panel pnlMRRNoLV = (Panel)e.Item.FindControl("pnlMRRNoLV"); Panel pnlBillLV = (Panel)e.Item.FindControl("pnlBillLV"); if (ent.WorkOrderStatusID == MasterDataConstants.WorkOrderStatus.APPROVED || ent.WorkOrderStatusID == MasterDataConstants.WorkOrderStatus.CANCELED) { btnResetWorkOrderLV.Visible = true; } else { btnResetWorkOrderLV.Visible = false; } String fe_mrr = SqlExpressionBuilder.PrepareFilterExpression(PRMMaterialReceiveEntity.FLD_NAME_WorkOrderID, ent.WorkOrderID.ToString(), SQLMatchType.Equal); IList <PRMMaterialReceiveEntity> lstPRMMaterialReceive = FCCPRMMaterialReceive.GetFacadeCreate().GetIL(null, null, String.Empty, fe_mrr, DatabaseOperationType.LoadWithFilterExpression); if (lstPRMMaterialReceive != null && lstPRMMaterialReceive.Count > 0) { btnResetWorkOrderLV.Visible = false; 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"; pnlMRRNoLV.Controls.Add(hypMaterialReceive); pnlMRRNoLV.Controls.Add(new LiteralControl("<br/>")); } } String fe_req = SqlExpressionBuilder.PrepareFilterExpression("PRMWorkOrderItemMap." + PRMWorkOrderItemMapEntity.FLD_NAME_WorkOrderID, ent.WorkOrderID.ToString(), SQLMatchType.Equal); IList <PRMWorkOrderItemMap_DetailedEntity> lstPRMWorkOrderItemMap = FCCPRMWorkOrderItemMap_Detailed.GetFacadeCreate().GetIL(10000, 1, String.Empty, fe_req); if (lstPRMWorkOrderItemMap != null && lstPRMWorkOrderItemMap.Count > 0) { List <PRMWorkOrderItemMap_DetailedEntity> distinct = lstPRMWorkOrderItemMap .GroupBy(car => car.WorkOrderID) .Select(g => g.First()) .ToList(); foreach (PRMWorkOrderItemMap_DetailedEntity pRMWorkOrderItemMapEntity in distinct) { HyperLink hypRequisitionNo = new HyperLink(); hypRequisitionNo.Text = pRMWorkOrderItemMapEntity.RequisitionNo.ToString(); hypRequisitionNo.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.REQUISITION_REPORT, UrlConstants.REQUISITION_ID, pRMWorkOrderItemMapEntity.RequisitionID.ToString()).ToString(); hypRequisitionNo.Target = "_blank"; hypRequisitionNo.CssClass = "CommonButtonLink"; pnlRequisitonNoLV.Controls.Add(hypRequisitionNo); pnlRequisitonNoLV.Controls.Add(new LiteralControl("<br/>")); } } String fe_bill = SqlExpressionBuilder.PrepareFilterExpression(CMBillEntity.FLD_NAME_WorkOrderID, ent.WorkOrderID.ToString(), SQLMatchType.Equal); IList <CMBillEntity> lstBill = FCCCMBill.GetFacadeCreate().GetIL(null, null, String.Empty, fe_bill, DatabaseOperationType.LoadWithFilterExpression); if (lstBill != null && lstBill.Count > 0) { btnResetWorkOrderLV.Visible = false; foreach (CMBillEntity cMBillEntity in lstBill) { HyperLink hypBill = new HyperLink(); hypBill.Text = cMBillEntity.BillNo.ToString(); //hypBill.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.REQUISITION_REPORT, UrlConstants.REQUISITION_ID, pRMWorkOrderItemMapEntity.RequisitionID.ToString()).ToString(); hypBill.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.BILL_REPORT, UrlConstants.OVERVIEW_CM_BILL_ID, cMBillEntity.BillID.ToString()).ToString(); hypBill.Target = "_blank"; hypBill.CssClass = "CommonButtonLink"; pnlBillLV.Controls.Add(hypBill); pnlBillLV.Controls.Add(new LiteralControl("<br/>")); } } hypWorkOrderPaymentTerm.Target = "_blank"; hypWorkOrderReport.Target = "_blank"; hypWorkOrderAnnexureReport.Target = "_blank"; } }
private void SaveCMBillEntity() { if (ValidationInput()) { if (IsValid) { try { CMBillEntity cMBillEntity = BuildCMBillEntity(); Int64 result = -1; if (cMBillEntity.IsNew) { result = FCCCMBill.GetFacadeCreate().Add(cMBillEntity, DatabaseOperationType.Add, TransactionRequired.No); } else { String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(CMBillEntity.FLD_NAME_BillID, cMBillEntity.BillID.ToString(), SQLMatchType.Equal); result = FCCCMBill.GetFacadeCreate().Update(cMBillEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No); } if (result > 0) { #region Update WO Final Bill Status if (cMBillEntity.BillStatusID == MasterDataConstants.MDBillStatus.FINAL_BILL) { PRMWorkOrderEntity prmWorkOrderEntity = FCCPRMWorkOrder.GetFacadeCreate().GetByID(cMBillEntity.WorkOrderID); prmWorkOrderEntity.IsFinalBilled = true; String fe = SqlExpressionBuilder.PrepareFilterExpression(PRMWorkOrderEntity.FLD_NAME_WorkOrderID, prmWorkOrderEntity.WorkOrderID.ToString(), SQLMatchType.Equal); FCCPRMWorkOrder.GetFacadeCreate().Update(prmWorkOrderEntity, fe, DatabaseOperationType.Update, TransactionRequired.No); } #endregion #region Bill Requisition Item Map CMBillRequisitionItemMapEntity cMBillRequisitionItemMapEntity = new CMBillRequisitionItemMapEntity(); try { IList <ListViewDataItem> list = lvREQRequisitionItem.Items; if (list != null && list.Count > 0) { foreach (ListViewDataItem lvdi in list) { Decimal billPriceLV; TextBox txtBillPriceLV = (TextBox)lvdi.FindControl("txtBillPriceLV"); Decimal.TryParse(txtBillPriceLV.Text.Trim(), out billPriceLV); if (billPriceLV > 0) { Label lblRequisitionIDLV = (Label)lvdi.FindControl("lblRequisitionIDLV"); Label lblRequisitionPriceLV = (Label)lvdi.FindControl("lblRequisitionPriceLV"); Label lblRequisitionItemIDLV = (Label)lvdi.FindControl("lblRequisitionItemIDLV"); cMBillRequisitionItemMapEntity.BillID = result; cMBillRequisitionItemMapEntity.RequisitionID = Int64.Parse(lblRequisitionIDLV.Text); cMBillRequisitionItemMapEntity.RequisitionItemID = Int64.Parse(lblRequisitionItemIDLV.Text); cMBillRequisitionItemMapEntity.RequisitionPrice = Decimal.Parse(lblRequisitionPriceLV.Text.Trim()); if (billPriceLV > 0) { cMBillRequisitionItemMapEntity.BillPrice = Decimal.Parse(txtBillPriceLV.Text.Trim()); } FCCCMBillRequisitionItemMap.GetFacadeCreate().Add(cMBillRequisitionItemMapEntity, DatabaseOperationType.Add, TransactionRequired.No); //else //{ // cMBillRequisitionItemMapEntity.BillPrice = null; //} } } } } catch (Exception ex) { } #endregion CMBillEntity _cMBillEntity = CurrentCMBillEntity; _BillID = 0; _CMBillEntity = new CMBillEntity(); PrepareInitialView(); BindCMBillList(); if (cMBillEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Bill Information has been added successfully.", false); } else { MiscUtil.ShowMessage(lblMessage, "Bill Information has been updated successfully.", false); } String NavUrl = UrlHelper.BuildSecureUrl("~/CM/CMBillUploadInfo.aspx", string.Empty, UrlConstants.OVERVIEW_CM_BILL_ID, result.ToString()).ToString(); Response.Redirect(NavUrl); } else { if (cMBillEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Failed to add Bill Information.", false); } else { MiscUtil.ShowMessage(lblMessage, "Failed to update Bill Information.", false); } } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } } }