Forum:

Dialog box data show in primefaces datatable when click on commandButton

Greenhorn

Posts: 1

posted 7 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

I am new in this site. Thank you for support. When i click on 'Add Invoice' button open a dialog box. input data in dialog box. After click on 'Save Invoice' all the data of dialog box is render in primfaces datatable. After that click on 'Save Invoices' all data of primefaces datatable and HTML table data are store in ipsDetail and Invoice object of Managed Bean class.

XHTML file :

<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml"
	xmlns:h="http://java.sun.com/jsf/html"
	xmlns:f="http://java.sun.com/jsf/core"
	xmlns:p="http://primefaces.org/ui"
	xmlns:ui="http://java.sun.com/jsf/facelets">
<h:head>
	<title>Invoice Data</title>
	<style type="text/css">
.Alingment {
	text-align: right;
	width: 100px;
}

.TotalClass {
	font-weight: bold;
	text-align: right;
}

td {
	text-align: right;
}
</style>
</h:head>
<body>

<h:form id="form">
		<h3>Tax Invoice</h3>
		<table border="1">
			<tr>
				<td  ><p:outputLabel
						style="font-weight: bold;" value="Email" />
<p:inputText
						value="#{invoiceBean.email}" /></td>
			</tr>
			<tr>
				<td><p:outputLabel style="font-weight: bold;"
						value="Invoice No" />
<p:inputText
						value="#{invoiceBean.invoiceNumber}" /></td>
				<td><p:outputLabel style="font-weight: bold;" value="Date" /><br />
					<p:calendar value="#{invoiceBean.date}" /></td>
			</tr>
			<tr>
				<td><p:outputLabel style="font-weight: bold;"
						value="Delivery Note" />
<p:inputText
						value="#{invoiceBean.deliveryNote}" /></td>
				<td><p:outputLabel style="font-weight: bold;"
						value="Mode Of Payments" />
<p:selectOneMenu
						value="#{invoiceBean.modeOfPayment}">
						<f:selectItem itemLabel="Cash" itemValue="cash" />
						<f:selectItem itemLabel="Cheque" itemValue="cheque" />
					</p:selectOneMenu></td>
			</tr>
			<tr>
				<td><p:outputLabel style="font-weight: bold;"
						value="Supplier Ref." />
<p:inputText
						value="#{invoiceBean.supplierReference}" /></td>
				<td><p:outputLabel style="font-weight: bold;"
						value="Other References" />
<p:inputText
						value="#{invoiceBean.otherReference}" /></td>
			</tr>

<tr>

</tr>
			<tr>

</tr>
			<tr>
				<td  ><p:outputLabel
						style="font-weight: bold;" value="Buyer Address" />
<p:inputTextarea
						rows="12" /></td>
			</tr>
			<tr>
				<td><p:outputLabel style="font-weight: bold;"
						value="Buyer Name" />
<p:inputText
						value="#{invoiceBean.buyerName}" /></td>
				<td><p:outputLabel style="font-weight: bold;" value="Date" /><br />
					<p:calendar /></td>
			</tr>
			<tr>
				<td><p:outputLabel style="font-weight: bold;"
						value="Dispatch Document No" />
<p:inputText /></td>
				<td><p:outputLabel style="font-weight: bold;" value="Dated" /><br />
					<p:calendar value="#{invoiceBean.dispatchDocumentDate}" /></td>
			</tr>
			<tr>
				<td><p:outputLabel style="font-weight: bold;"
						value="Dispatch Through" />
<p:inputText
						value="#{invoiceBean.dispatchThrough}" /></td>
				<td><p:outputLabel style="font-weight: bold;"
						value="Destination" />
<p:inputText
						value="#{invoiceBean.destination}" /></td>
			</tr>
			<tr>
				<td ><p:outputLabel style="font-weight: bold;"
						value="Terms Of Delivery" />
<p:inputTextarea
						value="#{invoiceBean.termsOfdelivery}" cols="43" /></td>
			</tr>
		</table>
		<br />

<p:dataTable id="invoiceTable" var="ipsDetail"
			value="#{invoiceBean.ipsDetails}" border="1" editable="true">

<p:column headerText="Sr. No.">
				<h:outputText value="#{ipsDetail.serialNumber}" />
			</p:column>

<p:column headerText="Description of Goods">
				<h:outputText value="#{ipsDetail.descriptionOfGoodsOrService}" />
			</p:column>

<p:column headerText="HSN Code">
				<h:outputText value="#{ipsDetail.hsnCode}" />
			</p:column>

<p:column headerText="Quantity">
				<h:outputText value="#{ipsDetail.quantity}" />
			</p:column>

<p:column headerText="Rate">
				<h:outputText value="#{ipsDetail.rate}" />
			</p:column>

<p:column headerText="Percentage Discount">
				<h:outputText value="#{ipsDetail.percentDiscount}" />
			</p:column>

<p:column headerText="Amount">
				<h:outputText value="#{invoiceBean.amount}" />
			</p:column>

<p:column>
				<p:rowEditor />
			</p:column>

<f:facet name="footer">
				<p:commandButton value="Add Invoice" type="button"
					onclick="PF('addInvoice').show();" />
			</f:facet>
		</p:dataTable>

<p:dialog header="Add Invoice" widgetVar="addInvoice" minHeight="40">
				<table border="1">
					<tr>
						<td><h:outputText value="Sr. No." /></td>
						<td><h:outputText value="Description Of Goods Or Services" /></td>
						<td><h:outputText value="HSN Code" /></td>
						<td><h:outputText value="Quantity" /></td>
						<td><h:outputText value="Rate" /></td>
						<td><h:outputText value="Percentage Discount" /></td>
						<td><h:outputText value="Amount" /></td>
					</tr>
					<tr>
						<td><p:inputText value="#{invoiceBean.serialNumber}" size="3"
								styleClass="Alingment" /></td>
						<td><h:inputTextarea
								value="#{ipsDetail.descriptionOfGoodsOrService}" cols="45" /></td>
						<td><h:inputText value="#{ipsDetail.hsnCode}" size="6"
								styleClass="Alingment" /></td>
						<td><h:inputText value="#{ipsDetail.quantity}" size="3"
								styleClass="Alingment" /></td>
						<td><h:inputText value="#{ipsDetail.rate}"
								styleClass="Alingment" /></td>
						<td><h:inputText value="#{ipsDetail.percentDiscount}"
								size="2" styleClass="Alingment" /></td>
						<td><h:inputText value="#{invoiceBean.amount}"
								styleClass="Alingment" /></td>
					</tr>
				</table>
				<p:commandButton value="Save New Invoice" action="#{invoiceBean.addRow}"
					update="invoiceTable" process="@this invoiceTable"
					oncomplete="jQuery('.ui-datatable-data tr').last().find('span.ui-icon-pencil').each(function(){jQuery(this).click()});" onclick="PF('addInvoice').hide();" />
		</p:dialog>

<p:commandButton value="Save Invoices" ajax="false"
			action="#{invoiceBean.saveInvoiceData}" onclick="tickAllRows()" />

</h:form>
</body>
</html>

Managed Bean :

package com.billing.managebeans;

import java.io.Serializable;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import javax.faces.bean.ManagedBean;
import javax.faces.bean.SessionScoped;
import javax.faces.bean.ViewScoped;
import javax.faces.component.UIComponent;
import javax.faces.component.behavior.AjaxBehavior;
import javax.faces.context.FacesContext;
import javax.faces.event.AbortProcessingException;
import javax.faces.event.PhaseId;

import org.primefaces.component.datatable.DataTable;
import org.primefaces.event.RowEditEvent;
import org.primefaces.util.ComponentUtils;

import com.billing.beans.Invoice;
import com.billing.beans.InvoiceProductsServicesDetail;
import com.billing.dao.InvoiceDao;

@ManagedBean(name = "invoiceBean", eager = true)
@SessionScoped
public class InvoiceBean implements Serializable {

/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	private String invoiceNumber;
	private Date date;
	private String deliveryNote;
	private String modeOfPayment;
	private int supplierReference;
	private String otherReference;
	private String buyerName;
	private Date dispatchDocumentDate;
	private String dispatchThrough;
	private String destination;
	private String email;
	private String termsOfdelivery;
	private String buyerOrderNumber;
	private int amount;

private int serialNumber;
	private String descriptionOfGoodsOrService;
	private String hsnCode;
	private int quantity;
	private int rate;
	private int percentDiscount;
	private float vat;
	private float serviceTax;

private int total;

private List<Invoice> invoices;
	private List<InvoiceProductsServicesDetail> ipsDetails;
	private Invoice invoice;
	private InvoiceProductsServicesDetail ipsDetail;

public List<Invoice> getInvoices() {

InvoiceDao invoiceDao = new InvoiceDao();
		invoices = invoiceDao.getInvoiceData();

return invoices;
	}

public void setInvoices(List<Invoice> invoices) {
		if (invoices != null) {
			this.invoices.add(new Invoice());
		}
	}

public void saveInvoiceData() {
		InvoiceDao invoiceDao = new InvoiceDao();
		invoice = new Invoice();
		ipsDetail = new InvoiceProductsServicesDetail();
		FacesContext facesContext = FacesContext.getCurrentInstance();
		try {
			DataTable table = (DataTable) facesContext.getViewRoot()
					.findComponent("form:invoiceTable");
			Object invoiceBean = table.getRowData();

if (invoice != null && ipsDetail != null) {
				invoice.setInvoiceNumber(getInvoiceNumber());
				invoice.setDate(date);
				invoice.setDeliveryNote(deliveryNote);
				invoice.setModeOfPayment(modeOfPayment);
				invoice.setSupplierReference(supplierReference);
				invoice.setOtherReference(otherReference);
				invoice.setBuyerName(buyerName);
				invoice.setBuyerOrderNumber(buyerOrderNumber);
				invoice.setOrderDate(new Date());
				invoice.setDispatchDocumentDate(dispatchDocumentDate);
				invoice.setDispatchThrough(dispatchThrough);
				invoice.setDestination(destination);
				invoice.setTermsOfdelivery(termsOfdelivery);
				invoice.setEmail(email);
				invoice.setTotal(total);
				// invoiceDao.insertInvoice(invoice);

System.out.println(getAmount());

ipsDetail
						.setDescriptionOfGoodsOrService(getDescriptionOfGoodsOrService());
				ipsDetail.setHsnCode(hsnCode);
				ipsDetail.setInvoiceId(invoice.getId());
				ipsDetail.setPercentDiscount(percentDiscount);
				ipsDetail.setQuantity(quantity);
				ipsDetail.setRate(rate);
				ipsDetail.setSerialNumber(serialNumber);
				ipsDetail.setServiceTax((float) 12.36);
				ipsDetail.setVat(5);
				invoiceDao.insertIpsDetail(ipsDetail);

System.out.println("InvoiceBean.insertInvoice");
			}
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

}

public void addRow() {

ipsDetail = new InvoiceProductsServicesDetail();

if (descriptionOfGoodsOrService != null
				&& hsnCode != null 	&& quantity != 0 && rate != 0) {
			ipsDetail.setSerialNumber(serialNumber);
			ipsDetail
					.setDescriptionOfGoodsOrService(descriptionOfGoodsOrService);
			ipsDetail.setHsnCode(hsnCode);
			ipsDetail.setPercentDiscount(percentDiscount);
			ipsDetail.setQuantity(quantity);
			ipsDetail.setRate(rate);

ipsDetails.add(ipsDetail);
		}

FacesContext facesContext = FacesContext.getCurrentInstance();
		try {

DataTable table = (DataTable) facesContext.getViewRoot()
					.findComponent("form:invoiceTable");

UIComponent uiTable = ComponentUtils.findParentForm(facesContext,
					table);

final AjaxBehavior behavior = new AjaxBehavior();
			RowEditEvent rowEditEvent = new RowEditEvent(uiTable, behavior,
					table.getRowData());

rowEditEvent.setPhaseId(PhaseId.UPDATE_MODEL_VALUES);
			table.broadcast(rowEditEvent);

} catch (AbortProcessingException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

public InvoiceBean() {
		ipsDetails = new ArrayList<InvoiceProductsServicesDetail>();
	}

public InvoiceProductsServicesDetail getIpsDetail() {
		return ipsDetail;
	}

public void setIpsDetail(InvoiceProductsServicesDetail ipsDetail) {
		this.ipsDetail = ipsDetail;
	}

public void setIpsDetails(List<InvoiceProductsServicesDetail> ipsDetails) {
		if (ipsDetails != null) {
			this.ipsDetails.addAll(ipsDetails);
		}

}

public List<InvoiceProductsServicesDetail> getIpsDetails() {
		return ipsDetails;
		// return new InvoiceDao().getIpsData() ;
	}

public String getInvoiceNumber() {
		return invoiceNumber;
	}

public void setInvoiceNumber(String invoiceNumber) {
		this.invoiceNumber = invoiceNumber;
	}

public Date getDate() {
		return date;
	}

public void setDate(Date date) {
		this.date = date;
	}

public String getDeliveryNote() {
		return deliveryNote;
	}

public void setDeliveryNote(String deliveryNote) {
		this.deliveryNote = deliveryNote;
	}

public String getModeOfPayment() {
		return modeOfPayment;
	}

public void setModeOfPayment(String modeOfPayment) {
		this.modeOfPayment = modeOfPayment;
	}

public int getSupplierReference() {
		return supplierReference;
	}

public void setSupplierReference(int supplierReference) {
		this.supplierReference = supplierReference;
	}

public String getOtherReference() {
		return otherReference;
	}

public void setOtherReference(String otherReference) {
		this.otherReference = otherReference;
	}

public String getBuyerName() {
		return buyerName;
	}

public void setBuyerName(String buyerName) {
		this.buyerName = buyerName;
	}

public Date getDispatchDocumentDate() {
		return dispatchDocumentDate;
	}

public void setDispatchDocumentDate(Date dispatchDocumentDate) {
		this.dispatchDocumentDate = dispatchDocumentDate;
	}

public String getDispatchThrough() {
		return dispatchThrough;
	}

public void setDispatchThrough(String dispatchThrough) {
		this.dispatchThrough = dispatchThrough;
	}

public String getDestination() {
		return destination;
	}

public void setDestination(String destination) {
		this.destination = destination;
	}

public String getEmail() {
		return email;
	}

public void setEmail(String email) {
		this.email = email;
	}

public String getTermsOfdelivery() {
		return termsOfdelivery;
	}

public void setTermsOfdelivery(String termsOfdelivery) {
		this.termsOfdelivery = termsOfdelivery;
	}

public int getSerialNumber() {
		return serialNumber;
	}

public void setSerialNumber(int serialNumber) {
		this.serialNumber = serialNumber;
	}

public String getDescriptionOfGoodsOrService() {
		return descriptionOfGoodsOrService;
	}

public void setDescriptionOfGoodsOrService(
			String descriptionOfGoodsOrService) {
		this.descriptionOfGoodsOrService = descriptionOfGoodsOrService;
	}

public String getHsnCode() {
		return hsnCode;
	}

public void setHsnCode(String hsnCode) {
		this.hsnCode = hsnCode;
	}

public int getQuantity() {
		return quantity;
	}

public void setQuantity(int quantity) {
		this.quantity = quantity;
	}

public int getRate() {
		return rate;
	}

public void setRate(int rate) {
		this.rate = rate;
	}

public int getPercentDiscount() {
		return percentDiscount;
	}

public void setPercentDiscount(int percentDiscount) {
		this.percentDiscount = percentDiscount;
	}

public float getVat() {
		return vat;
	}

public void setVat(float vat) {
		this.vat = vat;
	}

public float getServiceTax() {
		return serviceTax;
	}

public void setServiceTax(float serviceTax) {
		this.serviceTax = serviceTax;
	}

public String getBuyerOrderNumber() {
		return buyerOrderNumber;
	}

public void setBuyerOrderNumber(String buyerOrderNumber) {
		this.buyerOrderNumber = buyerOrderNumber;
	}

public Invoice getInvoice() {
		return invoice;
	}

public void setInvoice(Invoice invoice) {
		this.invoice = invoice;
	}

public int getAmount() {
		return amount;
	}

public void setAmount(int amount) {
		this.amount = amount;
	}

public int getTotal() {
		return total;
	}

public void setTotal(int total) {
		this.total = total;
	}
}

InvoiceDao Class:

package com.billing.dao;

import java.util.List;

import org.hibernate.SQLQuery;

import com.billing.beans.Invoice;
import com.billing.beans.InvoiceProductsServicesDetail;

public class InvoiceDao extends AbstractDao {
	Invoice invoice = new Invoice();

public List<Invoice> getInvoiceData() {

List<Invoice> invcList;
		try {

startReadOperation();
			System.out.println("InvoiceDao.getInvoiceData");
			String sql = "SELECT * FROM invoice";
			SQLQuery query = session.createSQLQuery(sql);
			query.addEntity(Invoice.class);
			invcList = query.list();
		} catch (Exception e) {

e.printStackTrace();
			return null;
		} finally {
			endReadOperation();
		}
		return invcList;
	}

public void insertInvoice(Invoice invoice) {

try {
			startOperation();
			session.saveOrUpdate(invoice);
			System.out.println("InvoiceDao.insertInvoice");

} catch (Exception e) {
			e.printStackTrace();
		} finally {

endOperation();
		}

}

public List<InvoiceProductsServicesDetail> getIpsData() {

List<InvoiceProductsServicesDetail> ipsList;
		try {
			startReadOperation();
			System.out.println("InvoiceProductsServicesDetailDao.getIpsData()");
			String sql = "SELECT * FROM invoice_products_services_detail";
			SQLQuery query = session.createSQLQuery(sql);
			query.addEntity(InvoiceProductsServicesDetail.class);
			ipsList = query.list();

} catch (Exception e) {

e.printStackTrace();
			return null;

} finally {
			endReadOperation();
		}
		return ipsList;
	}

public void insertIpsDetail(InvoiceProductsServicesDetail ipsDetail)
	{
		try{
			startOperation();
			session.saveOrUpdate(ipsDetail);
			System.out.println("InvoiceDao.insertIpsDetail");
		}catch(Exception e){
			e.printStackTrace();
		}
		finally{
			endOperation();
		}
	}
}

Here, Problem is ipsDetail elements NULL when click on 'Save Invoice' button in addRow() so that primefaces datatable not updated. So that i can not insert new invoice data in database table.

Tim Holloway

Saloon Keeper

Posts: 25482

180

I like...

posted 7 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Welcome to the JavaRanch, Hadu!

It's always a good idea when publishing sample code to reduce to the minimum amount of text you can rather than simply dumping the whole thing into the message.

You're dealing with people who don't get paid for their advice, and when your sample doesn't fit on the screen, a lot of people aren't going to spend the effort to bother reading through the whole thing.

I didn't, but I've seen problems like this enough that I'll give my standard answer and we'll see if it helps.

First, understand that unlike traditional GUIs, such as Swing, displaying a Dialog Box in JSF doesn't cause any server interaction (unless you explicitly request it via AJAX). That is because the Dialog Box - and its field contents - are rendered when the page is initially displayed, but kept hidden. The "show()" dialog method therefore doesn't construct or populate the dialog, just makes what's already in the web page visible.

Typically, I'll have an "onshow()" method defined for the dialog that issues an AJAX request. This request will inform the server to locate a record to be edited (or construct a new, blank one), and populate its fields in the dialog controls (via AJAX partial page update).

This is done before the dialog actually becomes visible, so the dialog show in ready-to-edit form.

If the user later clicks the dialog's "Save" button, another AJAX request is made. This one submits the dialog's control values (the dialog is almost always defined in an h:form). The normal JSF lifecycle is run (data validation, valuechangelisteners fired as needed, backing bean values update) and the AJAX listener (action) method is then invoked. This action method can then post the user's input data out the the database.

In real life, this is a little more complex, since if the action fails for some reason (for example, adding a duplicate record), then feedback mechanisms are required to tell the client not to hide the form, but to display an error message and allow correction of form data. Or whatever failure actions you think appropriate.

Sometimes the only way things ever got fixed is because people became uncomfortable.

I'm still in control here. LOOK at this tiny ad!

Free, earth friendly heat - from the CodeRanch trailboss

https://www.kickstarter.com/projects/paulwheaton/free-heat