Currency Conversion - Google Calculator API integration in ADF using GSON

First ,thanks to this post http://blog.caplin.com/2011/01/06/simple-currency-conversion-using-google-calculator-and-java/ .
I was looking for any API, webservice for retrieving live currency fluctuation, finally i came to this solution that integrates Google Calculator with Java to calculate currenct currency rates and i have integrated this with my Oracle ADF Application

I have created an application using bounded taskflow -

• Created a .jsff page with two input text , to get value of Base and Term currency and a button, on which rate is calculated

 

•  In order to use Goolge Calculator, we have to use GSON (open source java library (API) to convert JSON objects in POJO (pure java object)) 
• To access GSON library we have to add google-gson-stream-2.2.1.jar in our project library - Download Gson Jar
• this trick uses google calculator for calculating converion rate, as we all know Google Calculator is very smart, whenever we search like 1 USD ,it always shows results according to locale

As 1 USD searched in India-

As 1 USD searched in UK- 

• this is also hidden benefit for our application , we can pass locale to get changed values also- now see what is the code that get values from Google Calculator



   public void calculateFluctuationButton(ActionEvent actionEvent) throws Exception {  
     String google = "http://www.google.com/ig/calculator?en=hi&q=";  
     /**Get values from page component binding*/  
     String baseCurrency = baseCurrencyBind.getValue().toString();  
     String termCurrency = termCurrencyBind.getValue().toString();  
     String charset = "UTF-8";  
     /**Replace url using your values-*/  
     URL url = new URL(google + baseCurrency + "%3D%3F" + termCurrency);  
     /**Go to url directly to see you result*/  
     System.out.println(url);  
     Reader reader = new InputStreamReader(url.openStream(), charset);  
     Result result = new Gson().fromJson(reader, Result.class);  
     System.out.println(result);  
     // Get the value without the term currency.  
     String amount = result.getRhs().split("\\s+")[0];  
     System.out.println(amount);  
     resultBind.setValue(amount);  
   }  



• See in code i have passed currency notation from page (INR,USD ) to bean and passed it in url of google calculator and this url returns results

Download Complete Application -Sample ADF Application

Gmail Integration with Oracle ADF using Java Mail API

Gmail is a free secure webmail provided by google, can be accessed by using POP3 or IMAP4 protocol
we have option to integrate Gmail with Java using Java Mail API and I have tried same in Oracle
ADF.
I have developed an application that can send mail (with Attachements) using Gmail in Oracle ADF,
using bounded TaskFlow.

• First , in bounded taskflow ,a login page is created, and a page to send mail is created
• Now you can get values from page and use in bean- So I am not going to write these things
• Integration points starts when you get mail server properties- Managed Bean Code
• You have to use 2 JAR ,inorder to use Java Mail API

  1.mail.jar 2. Activation.jar- Download

Properties emailProperties;

public void setMailServerProperties() {
String emailPort = "587"; //gmail's smtp port
emailProperties = System.getProperties();
emailProperties.put("mail.smtp.port", emailPort);
emailProperties.put("mail.smtp.auth", "true");
emailProperties.put("mail.smtp.starttls.enable", "true");

}

• Now you have to create your message (With or Without attachments)--
   


public void createEmailMessageWidtAtchmnt() throws AddressException, MessagingException {
toWhom = toBind.getValue().toString();
subject = subjectBind.getValue().toString();
messagae = messageBind.getValue().toString();
String[] toEmails = { toWhom };

String emailSubject = subject;
String emailBody = messagae;

mailSession = Session.getDefaultInstance(emailProperties, null);
emailMessage = new MimeMessage(mailSession);

for (int i = 0; i < toEmails.length; i++) {
emailMessage.addRecipient(Message.RecipientType.TO, new InternetAddress(toEmails[i]));
}

emailMessage.setSubject(emailSubject);

//1) create MimeBodyPart object and set your message content
BodyPart messageBodyPart1 = new MimeBodyPart();
messageBodyPart1.setText(emailBody);

emailMessage.setContent(emailBody, "text/html"); //for a html email


}

• here I am getting values from page component binding so don't get confused by this- toBind
  subjectBind, messageBind are component binding of page
  
  
  
  
  
  
• Code snippet to create mail with attachements, you have to do little change in createEmailMessageWidtAtchmnt() to add files in mail . This code browse files from D drive
  
  of system .


//1) create MimeBodyPart object and set your message content
BodyPart messageBodyPart1 = new MimeBodyPart();
messageBodyPart1.setText(emailBody);

//2) create new MimeBodyPart object and set DataHandler object to this object
MimeBodyPart messageBodyPart2 = new MimeBodyPart();

String filename = "D://" + file_name; //change accordingly
System.out.println("Exact path--->" + filename);
DataSource source = new FileDataSource(filename);
messageBodyPart2.setDataHandler(new DataHandler(source));
messageBodyPart2.setFileName(filename);


//5) create Multipart object and add MimeBodyPart objects to this object
Multipart multipart = new MimeMultipart();
multipart.addBodyPart(messageBodyPart1);
multipart.addBodyPart(messageBodyPart2);

//6) set the multiplart object to the message object
emailMessage.setContent(multipart);

• To add files in mail in ADF you have to use af:inputFile component, and create a ValueChangeListener on component that get fileName when you browse any file from D drive of your system .
  
  
private String file_name;

public void uploadedFileAttachmentVCE(ValueChangeEvent valueChangeEvent) {
UploadedFile file = (UploadedFile)valueChangeEvent.getNewValue();
file_name = file.getFilename();
}

• From login page you will get login emailId and password, that is set in managed bean code to authenticate user- and send mail


public void sendEmail() {

String emailHost = "smtp.gmail.com";
String fromUser = emailId; //just the id alone without @gmail.com
String fromUserEmailPassword = pwd;
Transport transport = null;
try {
transport = mailSession.getTransport("smtp");
} catch (NoSuchProviderException e) {
System.out.println("No such Provider Exception");
}
try {
transport.connect(emailHost, fromUser, fromUserEmailPassword);
transport.sendMessage(emailMessage, emailMessage.getAllRecipients());
transport.close();
StringBuilder msgEmail = new StringBuilder("Email Sent");
FacesMessage msg = new FacesMessage(msgEmail.toString());
msg.setSeverity(FacesMessage.SEVERITY_INFO);
FacesContext.getCurrentInstance().addMessage("No Network Error !", msg);
System.out.println("Email sent successfully.");
} catch (MessagingException e) {
System.out.println("somthing went wrong-->Messaging Exception");

}

}

Download Complete Application and map these code to bean-Download Sample ADF Application

Creating and Executing ViewCriteria Programmatically

Sometimes you need dynamic ViewCriteria that you can handle at runtime ,
here is the solution ,you can create and apply ViewCriteria Programmatically-



Sample UseCase-

• Suppose you have Department VO
• You want to filter this VO for DepartmentId 10
• Do this using this code snippet


/**Get ViewObject*/
ViewObject vo = getAm().getDepartments1();
/**Create ViewCriteria on ViewObject*/
ViewCriteria vc = vo.createViewCriteria();
/**Create ViewCriteriaRow for that Criteria*/
ViewCriteriaRow vcRow = vc.createViewCriteriaRow();
/**Set the values for ViewCriteriaRow*/
vcRow.setAttribute("DepartmentId", 10);
/**Add row to ViewCriteria*/
vc.addRow(vcRow);
/**Apply Criteria on ViewObject*/
vo.applyViewCriteria(vc);
/**Execute ViewObject*/
vo.executeQuery();

public pcAMImpl getAm() {
pcAMImpl am = (pcAMImpl)resolvElDC("pcAMDataControl");
return am;
}