Mastering Oracle ADF 12C: From Beginner to Expert

Build a Search Taskflow and Create Edit Task flow..Call the Create Edit task flow from the Search Task flow

Hands on Lab document is available as attachment

ALTER TABLE EMPLOYEES ADD ( REGION_ID NUMBER, COUNTRY_ID CHAR(2));

SELECT 

    DEPARTMENTS.DEPARTMENT_ID DEPARTMENT_ID, 

    DEPARTMENTS.DEPARTMENT_NAME DEPARTMENT_NAME, 

    count(1) Employee_Count

FROM 

    DEPARTMENTS, 

    EMPLOYEES

    where DEPARTMENTS.DEPARTMENT_ID = EMPLOYEES.DEPARTMENT_ID

group by DEPARTMENTS.DEPARTMENT_ID,DEPARTMENT_NAME

import javax.faces.application.FacesMessage;

import javax.faces.context.FacesContext;

import oracle.adf.model.BindingContext;

import oracle.adf.model.binding.DCBindingContainer;

import oracle.binding.OperationBinding;

    public String Save() {

        // Add event code here...

        DCBindingContainer bindings = (DCBindingContainer)BindingContext.getCurrent().getCurrentBindingsEntry();

        OperationBinding operationBinding = bindings.getOperationBinding("Commit");

        operationBinding.execute(); 

        FacesContext ctx = FacesContext.getCurrentInstance();

        FacesMessage fm = new FacesMessage(FacesMessage.SEVERITY_INFO, "Saved Successfully", "");

        ctx.addMessage(null,fm);

        return null;

    }

In Managed Bean :

    public String Save() {

        // Add event code here...

        DCBindingContainer bindings = (DCBindingContainer)BindingContext.getCurrent().getCurrentBindingsEntry();

        OperationBinding operationBinding = bindings.getOperationBinding("saveEmployee");

        operationBinding.execute(); 

        FacesContext ctx = FacesContext.getCurrentInstance();

        FacesMessage fm = new FacesMessage(FacesMessage.SEVERITY_INFO, "Saved Successfully", "");

        ctx.addMessage(null,fm);

        return null;

    }

In AM Impl :

    public void saveEmployee() {   

        ViewObjectImpl vo   = getEmployeesView1();

        vo.getCurrentRow().setAttribute("Salary", 35000);

        this.getTransaction().commit();

    }

Create Method :

        System.out.println("Create Method is called");

        SequenceImpl sq = new SequenceImpl("EMPLOYEES_SEQ",this.getDBTransaction());

        this.setAttribute("EmployeeId", sq.getSequenceNumber().intValue());

Remove Method:

  this.setAttribute("Salary",new BigDecimal("10") );

DoDml Method:

if (operation == DML_INSERT)

            System.out.println("DML Insert  is called");

        else if (operation == DML_UPDATE)

            System.out.println("DML Update  is called");

        else if (operation == DML_DELETE)

        {

            System.out.println("DML Delete  is called");

            operation = DML_UPDATE;

        }

In EmployeesViewImpl.java :

    public void filterByShippingDept () {

        final Integer departmentId = 50;

        setWhereClause( " DEPARTMENT_ID = " + departmentId);

        executeQuery();

    }

Binding Change :

<methodAction id="filterByShippingDept" RequiresUpdateModel="true" Action="invokeMethod"

                  MethodName="filterByShippingDept" IsViewObjectMethod="true" DataControl="CustomCodeAMDataControl"

                  InstanceName="data.CustomCodeAMDataControl.EmployeesView1"/>

In DepartmentsViewRowImpl.java

    public void applyRaise(BigDecimal raiseValue)

    {

      RowIterator rows = getEmployeesView();

      while (rows.hasNext())

      {

       EmployeesViewRowImpl currentRow = (EmployeesViewRowImpl) rows.next();

       currentRow.setSalary(  currentRow.getSalary().add(raiseValue));

      }

    }

ALTER TABLE EMPLOYEES ADD (

CREATED_ON DATE,

CREATED_BY VARCHAR2(50),

MODIFIED_ON DATE,

MODIFIED_BY VARCHAR2(50),

VERSION_NUMBER NUMBER(38,0));