Locanto Automation Script

Locanto

package com.test.on;

import java.io.IOException;

import come.ExcelReadWrite.ExcelRead;

public class Locanto extends Wrapper {
	
	public static void locantoScript() throws Exception
	{
		int lrow=ExcelRead.getLastRow("Sheet1", "Upload_Sequence.xlsx");
		login();	
		handlePopUp();
		proceed();
		for(int i=1;i<=lrow;i++)
		{
		formFillUp(i);
		sleep(3000);
		navigateTo("http://singapore.locanto.sg/post/R/307/1/");
		
		}
		close();
		
	}
	public static void login() throws Exception
	{
		launchBrowser("Chrome");
		navigateTo("http://locanto.sg/");
		maximizeTheBrowserWindow();
		//Click on the Login button
		sleep(2000);
		click("linkText","Login / Register");
		//Entering the credentials
		sleep(2000);
		enterTextInTextbox("name","email",ExcelRead.username());
		enterTextInTextbox("name","pwd",ExcelRead.password());
		click("className","ysb");
		click("linkText","Post free ad");
		
	}
	
	public static void handlePopUp() throws Exception
	{
		if(elementPresent("linkText","No, stay on Locanto Singapore"))
		{
			click("linkText","No, stay on Locanto Singapore");
		}
	}
	
	public static void proceed() throws Exception
	{
		click("id","L_R");
		click("linkText","Houses for Rent");
		sleep(3000);
		clickByPartialLinkText("Proceed");	
		
	}
	
	public static void formFillUp(int i) throws IOException
	{
		enterTextInTextbox("name","price",ExcelRead.getvalue(6, i, "Sheet1", "Upload_Sequence.xlsx"));
		enterTextInTextbox("id","subject",ExcelRead.getvalue(12, i, "Sheet1", "Upload_Sequence.xlsx"));
		enterTextInTextbox("id","redactor-uuid-0",ExcelRead.getvalue(11, i, "Sheet1", "Upload_Sequence.xlsx"));
		uploadFile("className","js-upload",ExcelRead.getvalue(17, i, "Sheet1", "Upload_Sequence.xlsx"));
		sleep(3000);
		uploadFile("className","js-upload",ExcelRead.getvalue(18, i, "Sheet1", "Upload_Sequence.xlsx"));
		sleep(3000);
		uploadFile("className","js-upload",ExcelRead.getvalue(19, i, "Sheet1", "Upload_Sequence.xlsx"));
		sleep(3000);
		//Bed Room
		selectTextFromNormalDropDown("name","rooms",ExcelRead.getvalue(7, i, "Sheet1", "Upload_Sequence.xlsx")+" "+"BR");
		//selectvalueFromNormalDropDown("name","rooms",Integer.valueOf(ExcelRead.getvalue(7, i, "Sheet1", "Upload_Sequence.xlsx"))+1);
		enterTextInTextbox("name","size",ExcelRead.getvalue(5, i, "Sheet1", "Upload_Sequence.xlsx"));
		
		//enterTextInTextbox("name","psize","1450");
		
		Wrapper.selectTextFromNormalDropDown("className", "js-phone_number_select", "92223226");
		
		enterTextInTextbox("id","mapStreet",ExcelRead.getvalue(1, i, "Sheet1", "Upload_Sequence.xlsx")+" "+ExcelRead.getvalue(2, i, "Sheet1", "Upload_Sequence.xlsx"));
		
		enterTextInTextbox("id","geo_search_post","Singapore");
		
		enterTextInTextbox("id","mapZip",ExcelRead.getvalue(3, i, "Sheet1", "Upload_Sequence.xlsx"));
		click("name","post_directly");
		
	}
}