package prjOracle_JCD;


public class jcdInsert
{

   public com.stc.codegen.logger.Logger logger;

   public com.stc.codegen.alerter.Alerter alerter;

   public com.stc.codegen.util.CollaborationContext collabContext;

   public com.stc.codegen.util.TypeConverter typeConverter;

   public void receive( com.stc.connector.appconn.file.FileTextMessage input, dtd.
otdInputDTD129034179.DBemployees otdInputDTD_DBemployees_1, otdOracle.
OtdOracleOTD otdOracle_1, com.stc.connector.appconn.file.FileApplication FileClient_1 )
       throws Throwable
   {
       FileClient_1.setText( "Inserting records into db_employee table .." );
       FileClient_1.write();
       otdInputDTD_DBemployees_1.unmarshalFromString( input.getText() );
       otdOracle_1.getDB_EMPLOYEE().insert();
       for (int i1 = 0; i1 < otdInputDTD_DBemployees_1.countX_sequence_A(); i1 += 1) {
           otdOracle_1.getDB_EMPLOYEE().setEMP_NO( new java.math.BigDecimal( otdInputDTD_DBemployees_1.getX_sequence_A( i1 ).getEmpNo() ) );
           otdOracle_1.getDB_EMPLOYEE().setLAST_NAME( otdInputDTD_DBemployees_1.getX_sequence_A( i1 ).getLastname() );
           otdOracle_1.getDB_EMPLOYEE().setFIRST_NAME( otdInputDTD_DBemployees_1.getX_sequence_A( i1 ).getFirstname() );
           otdOracle_1.getDB_EMPLOYEE().setRATE( (new Double( otdInputDTD_DBemployees_1.getX_sequence_A( i1 ).getRate() )).doubleValue() );
           otdOracle_1.getDB_EMPLOYEE().setLAST_UPDATE( java.sql.Date.valueOf( otdInputDTD_DBemployees_1.getX_sequence_A( i1 ).getLastDate() ) );
           otdOracle_1.getDB_EMPLOYEE().insertRow();
       }
       FileClient_1.setText( "Done Insert." );
       FileClient_1.write();
   }

}