Notes

LOGGER.debug("Inside deleteInvoiceDetails() method called from EmployeeDetailsDaoImpl");
Session session=getSession();
Transaction tx=null;


try {
Query
query=session.createQuery("SELECT pk_invoice_id FROM history inv WHERE inv.pk_invoice_id=:pk_invoice_id");
query.setParameter("pk_invoice_id",invoiceObj.getPk_invoice_id());
query.setMaxResults(1);
Integer pk_invoice_id=(Integer)query.uniqueResult();
if(pk_invoice_id!=null) {
query=session.createQuery("FROM history inv WHERE inv.pk_invoice_id=:pk_invoice_id");
query.setParameter("pk_invoice_id", pk_invoice_id);
query.setMaxResults(1);
List<history> list=query.list();
trn_invoice trnInvoiceObj=new trn_invoice();
trnInvoiceObj.setPk_invoice_id(list.get(0).getPk_invoice_id());
trnInvoiceObj.setAccount_id(75);
trnInvoiceObj.setInvoice_number(list.get(0).getInvoice_number());
trnInvoiceObj.setCompany_code(list.get(0).getCompany_code());
trnInvoiceObj.setFiscal_year(list.get(0).getFiscal_year());
trnInvoiceObj.setItem_number(list.get(0).getItem_number());
trnInvoiceObj.setFkInvoiceType(list.get(0).getFkInvoiceType());
trnInvoiceObj.setFkPostingKey(list.get(0).getFkPostingKey());
trnInvoiceObj.setFkCustomerId(list.get(0).getFkCustomerId());
trnInvoiceObj.setInvoice_total_amount(list.get(0).getInvoice_total_amount());
trnInvoiceObj.setInvoice_due_amount(list.get(0).getInvoice_due_amount());
trnInvoiceObj.setInvoice_created_date(list.get(0).getInvoice_created_date());
trnInvoiceObj.setDue_date(list.get(0).getDue_date());
trnInvoiceObj.setDiscount_1_percentage(list.get(0).getDiscount_1_percentage());
trnInvoiceObj.setDiscount_2_percentage(list.get(0).getDiscount_2_percentage());
trnInvoiceObj.setDiscount_3_percentage(list.get(0).getDiscount_3_percentage());
trnInvoiceObj.setDebit_credit_indicator(list.get(0).getDebit_credit_indicator());
trnInvoiceObj.setIs_open(list.get(0).getIs_open());
trnInvoiceObj.setApproval_status("rejected");
session.close();

Session ses1=getSession();
tx=ses1.beginTransaction();
ses1.update(trnInvoiceObj);
tx.commit();

//Transaction tx1=null;
//
//Session s2=getSession();
//tx1=s2.beginTransaction();
//query=s2.createQuery("DELETE FROM history inv WHERE pk_invoice_id=:pk_invoice_id");
//query.setParameter("fk_invoice_id", pk_invoice_id);
//query.executeUpdate();
//tx1.commit();
//return true;

}

} catch (Exception e) {
LOGGER.error("Error while saving entry : ",e);
}
return false;