Examples of com.knowgate.hipergate.Invoice

com.knowgate.hipergate.Invoice
@author Sergio Montoro Ten @version 5.0

  }


  DBSubset oAddrs = oComp.getAddresses(oConn);
  DBSubset oBanks = oComp.getActiveBankAccounts(oConn);
  
  Invoice oInvc = new Invoice();
  oInvc.put(DB.bo_active, (short) 1);
  oInvc.put(DB.gu_shop, sGuShop);
  oInvc.put(DB.id_currency, oProd.get(DB.id_currency));
  oInvc.put(DB.id_legal, oComp.getString(DB.id_legal));
  oInvc.put(DB.de_order, Gadgets.left(getStringNull(DB.nm_course,"")+"/"+oCntc.getStringNull(DB.tx_name,"")+" "+oCntc.getStringNull(DB.tx_surname,""),100));  
  oInvc.put(DB.gu_company, oComp.getString(DB.gu_company));
  oInvc.put(DB.nm_client, oComp.getString(DB.nm_legal));
  if (oAddrs.getRowCount()>0) {
    oInvc.put(DB.gu_bill_addr, oAddrs.getString(DB.gu_address,0));
    if (!oAddrs.isNull(DB.tx_email,0)) {
      oInvc.put(DB.tx_email_to, oAddrs.getString(DB.tx_email,0));      
    }
  } // fi
  if (oBanks.getRowCount()>0) {
    oInvc.put(DB.nu_bank, oBanks.getString(DB.nu_bank_acc,0));
  } // fi
    oInvc.store(oConn);


  oInvc.addProduct(oConn, oProd.getString(DB.gu_product), 1f);


  oInvc.put(DB.im_subtotal, oInvc.computeSubtotal(oConn));
  oInvc.put(DB.im_taxes, oInvc.computeTaxes(oConn));
  oInvc.put(DB.im_total, oInvc.computeTotal(oConn));
  oInvc.put(DB.im_paid, new BigDecimal(0d));
    oInvc.store(oConn);  
    
    DBCommand.executeUpdate(oConn, "UPDATE "+DB.k_x_course_bookings+" SET "+DB.gu_invoice+"='"+oInvc.getString(DB.gu_invoice)+"' WHERE "+DB.gu_acourse+"='"+getString(DB.gu_acourse)+"' AND "+DB.gu_contact+"='"+getString(DB.gu_contact)+"'");


    return oInvc;
  } // createInvoiceForCompany

View Full Code Here

  }


  DBSubset oAddrs = oCntc.getAddresses(oConn);
  DBSubset oBanks = oCntc.getActiveBankAccounts(oConn);
  
  Invoice oInvc = new Invoice();
  oInvc.put(DB.gu_shop, sGuShop);
  oInvc.put(DB.id_currency, oProd.get(DB.id_currency));
  oInvc.put(DB.id_legal, oCntc.getString(DB.sn_passport));
  oInvc.put(DB.de_order, Gadgets.left(getStringNull(DB.nm_acourse,"")+"/"+oCntc.getStringNull(DB.tx_name,"")+" "+oCntc.getStringNull(DB.tx_surname,""),100));  
  oInvc.put(DB.gu_contact, oCntc.getString(DB.gu_contact));
  oInvc.put(DB.nm_client, Gadgets.left(oCntc.getStringNull(DB.tx_name,"")+" "+oCntc.getStringNull(DB.tx_surname,""),200));
  if (oAddrs.getRowCount()>0) {
    oInvc.put(DB.gu_bill_addr, oAddrs.getString(DB.gu_address,0));
    if (!oAddrs.isNull(DB.tx_email,0)) {
      oInvc.put(DB.tx_email_to, oAddrs.getString(DB.tx_email,0));      
    }
  } // fi
  if (oBanks.getRowCount()>0) {
    oInvc.put(DB.nu_bank, oBanks.getString(DB.nu_bank_acc,0));
  } // fi
    oInvc.store(oConn);


  oInvc.addProduct(oConn, oProd.getString(DB.gu_product), 1f);


  oInvc.put(DB.im_subtotal, oInvc.computeSubtotal(oConn));
  oInvc.put(DB.im_taxes, oInvc.computeTaxes(oConn));
  oInvc.put(DB.im_total, oInvc.computeTotal(oConn));
  oInvc.put(DB.im_paid, new BigDecimal(0d));
    oInvc.store(oConn);  
      
    DBCommand.executeUpdate(oConn, "UPDATE "+DB.k_x_course_bookings+" SET "+DB.gu_invoice+"='"+oInvc.getString(DB.gu_invoice)+"' WHERE "+DB.gu_acourse+"='"+getString(DB.gu_acourse)+"' AND "+DB.gu_contact+"='"+getString(DB.gu_contact)+"'");
  
    return oInvc;
  } // createInvoiceForContact

View Full Code Here

  public Invoice getInvoice(JDCConnection oConn)
    throws SQLException, IllegalStateException {
    if (isNull(DB.gu_invoice))
      return null;
    else
      return new Invoice(oConn, getString(DB.gu_invoice));
  } // getInvoice

View Full Code Here

TOP

Related Classes of com.knowgate.hipergate.Invoice

com.knowgate.jdc.JDCConnection

com.knowgate.training.AcademicCourseBooking

java.sql.Statement

java.math.BigDecimal

java.sql.SQLException

java.sql.ResultSet

java.sql.PreparedStatement

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.