Sample java Coding for BOP4 - WsAPP

import com.cordys.cpc.bsf.busobject.BSF;

import com.cordys.cpc.bsf.busobject.BusObjectConfig;

import com.cordys.cpc.bsf.busobject.BusObjectIterator;

import com.cordys.cpc.bsf.busobject.QueryObject;

import com.cordys.cpc.bsf.busobject.exception.BsfConstraintViolationException;

import com.eibus.xml.nom.Node;

import com.eibus.xml.xpath.XPath;

import java.util.Date;

1

public void onBeforeInsert()

{

this.setSTATUS("SubmittedForApproval");

this.setCREATED_BY_ID(BSF.getUser().split(",")[0].split("=")[1]);

try{

this.setCREATED_BY_NAME(BSF.getLDAPDirectory().read(BSF.getAuthenticatedUser()).getAttribute("description").getStringValue());

}catch(Exception e)

{

this.setCREATED_BY_NAME(BSF.getUser().split(",")[0].split("=")[1]);

}

this.setCREATED_BY_NAME(BSF.getUser().split(",")[0].split("=")[1]);

this.setRM_ID(BSF.getUser().split(",")[0].split("=")[1]);

try{

this.setRM_NAME(BSF.getLDAPDirectory().read(BSF.getAuthenticatedUser()).getAttribute("description").getStringValue());

}catch(Exception e)

{

this.setRM_NAME(BSF.getUser().split(",")[0].split("=")[1]);

}

this.setCREATED_DATE(new Date());

}

2

public void onAfterInsert()

{

this.getObjectManager()._commitTransactionDirect(true);

CPA_CALLPUTMASTER_AUDIT audit = new CPA_CALLPUTMASTER_AUDIT();

audit.setAPPROVAL_ID(this.getAPPROVAL_ID());

audit.setCREATED_DATE(this.getCREATED_DATE());

audit.setIS_ACTIVE(this.getIS_ACTIVE());

audit.insert();

}

3

public void onInsert()

{

String user = BSF.getUser();

user = user.substring(3, user.indexOf(","));

String Query="select count(1)No from CPA_SEGMENTMASTER where upper(SEGMENT_CODE) ='"+this.getSEGMENT_CODE().toUpperCase()+"'";

QueryObject qo=new QueryObject(Query);

qo.setResultClass(CPA_SEGMENTMASTER.class);

if(qo.getObject().getIntProperty("NO")>0)

throw new BsfConstraintViolationException("Duplicate record pending for authorization");

}

4 Ws-App Validation

public void onInsert()

{

if(this.getISSUE_START_AMOUNT()<1)

throw new BsfConstraintViolationException("Issue Start Amount is Mandatory!");

if(this.getISSUE_END_AMOUNT()<1)

throw new BsfConstraintViolationException("Issue End Amount is Mandatory!");

if(this.getCOMPANY_CODE()==null)

throw new BsfConstraintViolationException("Company Code is Mandatory.");

super.onInsert();

}

//on form

function ASBA_ISSUE_MASTERModel_OnSOAPFault(eventObject)

{

eventObject.showError=false;

application.showError(eventObject.faultString);

}

5 Update WS

public static void updateCamWithWorkflowStatus(double CAM_ID, String WORKFLOW_STATUS){

String query = "select * from T_CAM where CAM_ID=:camId";

QueryObject queryObject = new QueryObject(query);

queryObject.addParameter("camId", "T_CAM.CAM_ID", QueryObject.PARAM_DOUBLE, CAM_ID);

queryObject.setResultClass(T_CAM.class);

T_CAM cam = (T_CAM)queryObject.getObject();

if (WORKFLOW_STATUS == "APPROVED")

cam.setCAM_REVISION_DATE(new Date());

cam.setWORKFLOW_STATUS(WORKFLOW_STATUS);

cam.update();

}

6 To check if the status is approved or rejected

public void onBeforeUpdate()

{

if(!(Node.getData(XPath.getFirstMatch(".//RULE_APPROVAL_STATUS",null,this._getObjectData())).equalsIgnoreCase("approved") ||Node.getData(XPath.getFirstMatch(".//RULE_APPROVAL_STATUS",null,this._getObjectData())).equalsIgnoreCase("Rejected")))

{

this.setAPPROVED_BYID("");

this.setAPPROVED_BY("");

}

else

{

}

7 To insert into audit table (All the records by using one statement)

//DT_DEFERRAL base class

public void onAfterInsert()

{

DT_DEFERRAL_AUDIT audit=new DT_DEFERRAL_AUDIT();

this.sys_mapAttributes(this, audit, null,SETTERMODE_NORMAL);

audit.setAUDIT_ACTION("CREATED");

audit.setAUDIT_ACTION_DATE(new Date());

audit.insert();

}

}

8

BusObjectIterator prodDocs = T_PRODUCT_DOCUMENTS.getTProductDocumentsObjectsForProductId(this.getPRODUCT_ID());

while(prodDocs.hasMoreElements()){

T_PRODUCT_DOCUMENTS prodDoc = prodDocs.nextElement();

String documentName = prodDoc.getDOCUMENT_IDObject().getDOCUMENT_NAME();

if(T_CAM_CHECKLIST.getTCamChecklistObjectsForCamIdNDocumentName(this.getCAM_ID(), documentName).hasMoreElements()) continue;

T_CAM_CHECKLIST camCheckList = new T_CAM_CHECKLIST();

camCheckList.setCAM_ID(this.getCAM_ID());

camCheckList.setDOCUMENT_NAME(documentName);

camCheckList.insert();

}

9 Search Query

String strQuery = "SELECT * FROM T_PARAMETER where 1 = 1";

//if(!searchBy.trim().equals("") && !value.trim().equals("") ){

if(searchBy != null && !searchBy.trim().equals("") && value != null && !value.trim().equals("")){

strQuery += "and upper("+searchBy+") LIKE upper('%"+value+"%') order by "+searchBy;

}

else if(!searchBy.trim().equals("") && value.trim().equals("")){

strQuery += "order by "+searchBy;

}

QueryObject queryObject = new QueryObject(strQuery);

return queryObject.getObjects();

10

String QryString = " SELECT MAX(agent_code) as AGENT_CODE FROM HMS_AGENT_MASTER where agent_code like '"+searchString+"%'";

QueryObject qry = new QueryObject(QryString);

qry.setResultClass(HMS_AGENT_MASTER.class);

rslt= (HMS_AGENT_MASTER)qry.getObject();

maxAgtCode = rslt.getAGENT_CODE();