Chaos Ads Automation Script

Chaos Ads Script

import java.io.IOException;
import org.apache.commons.lang3.text.WordUtils;
import com.wrapper.Wrapper;
import add.info.PostalCode;
import excel.read.write.ExcelRead;
import excel.read.write.ExcelWrite;



public class ChaosAds extends Wrapper {
	public static String location;
	public static String parentWindow;
	public static void chaosAdsScript() throws IOException
	{
		
		int lrow=ExcelRead.getLastRow("Sheet1", "Upload_Sequence.xlsx");
		initialSetUp();
		for(int i=1;i<=lrow;i++)
		{
			//if(ExcelRead.getvalue(20, i, "Sheet1", "Upload_Sequence.xlsx").equalsIgnoreCase("Processed")==false)
			//{
				formFillUp(i);
				ExcelWrite.setvalue(20, i, "Sheet1", "Upload_Sequence.xlsx", "Processed");
				navigateTo("http://www.chaosads-singapore.com/post/add/category/15/");
				sleep(4500);
			//}
		}
		close();
				
	}
	
	public static void initialSetUp()
	{
		launchBrowser("Chrome");
		navigateTo("http://www.chaosads-singapore.com/post/add/category/15/");
		maximizeTheBrowserWindow();
		sleep(3000);
		
	}
	
	@SuppressWarnings("deprecation")
	public static void formFillUp(int i) throws IOException
	{
		parentWindow=driver.getWindowHandle();
		location=ExcelRead.getvalue(3, i, "Sheet1", "Upload_Sequence.xlsx").substring(0,2);
		String region=PostalCode.getPostalCodeRegion(location)+" "+"Region";
		selectTextFromNormalDropDown("name","location",PostalCode.getPostalCodeRegion(location)+" "+"Region");
		sleep(1500);
		//Central
		if(containsIgnoreCase(region,"Central Region"))
		{
			
			if(verifyTextFromNormalDropDown("name","location",WordUtils.capitalizeFully(ExcelRead.getvalue(13, i, "Sheet1", "Upload_Sequence.xlsx"))))
			{
				selectTextFromNormalDropDown("name","location",WordUtils.capitalizeFully(ExcelRead.getvalue(13, i, "Sheet1", "Upload_Sequence.xlsx")));
			}
			else
				
			{
				selectTextFromNormalDropDown("name","location","Central Area");
			}
		}
		
		//North East
		if(containsIgnoreCase(region,"North-East Region"))
		{
			
			if(verifyTextFromNormalDropDown("name","location",WordUtils.capitalizeFully(ExcelRead.getvalue(13, i, "Sheet1", "Upload_Sequence.xlsx"))))
			{
				selectTextFromNormalDropDown("name","location",WordUtils.capitalizeFully(ExcelRead.getvalue(13, i, "Sheet1", "Upload_Sequence.xlsx")));
			}
			else
				
			{
				selectTextFromNormalDropDown("name","location","North-Eastern Islands");
			}
		}	
		//Eastern Region
		else if(containsIgnoreCase(region,"East Region"))
			{
				if(containsIgnoreCase(WordUtils.capitalizeFully(ExcelRead.getvalue(13, i, "Sheet1", "Upload_Sequence.xlsx")),"SIMEI"))
						{
					selectTextFromNormalDropDown("name","location","Tampines");
						}
				else
				{
					if(verifyTextFromNormalDropDown("name","location",WordUtils.capitalizeFully(ExcelRead.getvalue(13, i, "Sheet1", "Upload_Sequence.xlsx"))))
					{
						selectTextFromNormalDropDown("name","location",WordUtils.capitalizeFully(ExcelRead.getvalue(13, i, "Sheet1", "Upload_Sequence.xlsx")));
					}
					else
						
					{
						selectTextFromNormalDropDown("name","location","Western Islands");
					}
				}
			}	
		
		//Western Region
		
		if(containsIgnoreCase(region,"West Region"))
		{
			
			if(verifyTextFromNormalDropDown("name","location",WordUtils.capitalizeFully(ExcelRead.getvalue(13, i, "Sheet1", "Upload_Sequence.xlsx"))))
			{
				selectTextFromNormalDropDown("name","location",WordUtils.capitalizeFully(ExcelRead.getvalue(13, i, "Sheet1", "Upload_Sequence.xlsx")));
			}
			else
				
			{
				selectTextFromNormalDropDown("name","location","Western Islands");
			}
		}		
		
		
			//North Region
		if(containsIgnoreCase(region,"North Region"))
		{
			
			
				selectTextFromNormalDropDown("name","location",WordUtils.capitalizeFully(ExcelRead.getvalue(13, i, "Sheet1", "Upload_Sequence.xlsx")));
			
		}	
		
		
		
		
		
		//selectTextFromNormalDropDown("name","location",WordUtils.capitalizeFully(ExcelRead.getvalue(13, i, "Sheet1", "Upload_Sequence.xlsx")));
		sleep(1500);
		enterTextInTextbox("name","title",ExcelRead.getvalue(12, i, "Sheet1", "Upload_Sequence.xlsx"));
		enterTextInTextbox("id","custom_rooms",ExcelRead.getvalue(7, i, "Sheet1", "Upload_Sequence.xlsx"));
		enterTextInTextbox("id","custom_bathrooms",ExcelRead.getvalue(8, i, "Sheet1", "Upload_Sequence.xlsx"));
		enterTextInTextbox("id","custom_fullSquare",ExcelRead.getvalue(5, i, "Sheet1", "Upload_Sequence.xlsx"));
		enterTextInTextbox("id","text",ExcelRead.getvalue(11, i, "Sheet1", "Upload_Sequence.xlsx"));
		enterTextInTextbox("id","price",ExcelRead.getvalue(6, i, "Sheet1", "Upload_Sequence.xlsx"));
		//First Upload
		clickByLinkText("Add a picture");
		sleep(2000);
		switchToChildWindow(parentWindow);
		uploadFile("id","file",ExcelRead.getvalue(17, i,"Sheet1", "Upload_Sequence.xlsx"));
		sleep(3500);
		submit("id","submit");
		sleep(9500);
		//Second Upload
		switchToParentWindow(parentWindow);
		clickByLinkText("Add a picture");
		sleep(2000);
		switchToChildWindow(parentWindow);
		uploadFile("id","file",ExcelRead.getvalue(18, i,"Sheet1", "Upload_Sequence.xlsx"));
		sleep(3500);
		submit("id","submit");
		sleep(9500);
		//Third Upload
		switchToParentWindow(parentWindow);
		clickByLinkText("Add a picture");
		sleep(2000);
		switchToChildWindow(parentWindow);
		uploadFile("id","file",ExcelRead.getvalue(19, i,"Sheet1", "Upload_Sequence.xlsx"));
		sleep(3500);
		submit("id","submit");
		sleep(9500);
		switchToParentWindow(parentWindow);
		sleep(2000);
		enterTextInTextbox("id","user_email","[email protected]");
		sleep(1000);
		enterTextInTextbox("id","user_name","Wendy Chua");
		sleep(1000);
		enterTextInTextbox("id","user_phone","92223226");	
		sleep(1000);
		submit("id","user_phone");
		sleep(3500);
	}
}