Module 17: BigBasket - Comparing Basket Data with Excel Info

Hi,

I have added products to basket and able to verify the subtotal. But unable to verify the product and quantity in the basket with the excel.
Could you please help me with the logic to cross verify.

package exercises;

import java.util.Arrays;
import java.util.List;
import java.util.concurrent.TimeUnit;

import org.openqa.selenium.By;
import org.openqa.selenium.Keys;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.WebElement;
import org.openqa.selenium.firefox.FirefoxDriver;
import org.openqa.selenium.interactions.Actions;
import org.testng.Assert;

public class BigBasket {

static WebDriver driver;
static int count=0;
public static void main(String[] args) throws Exception {

driver = new FirefoxDriver();
driver.manage().timeouts().implicitlyWait(10, TimeUnit.SECONDS);
driver.manage().window().maximize();
driver.navigate().to("https://bigbasket.com");

Xls_Reader xls = new Xls_Reader("D:\\Selenium\\WebDriver Practise\\BigBasket.xlsx");

driver.findElement(By.xpath("//*[@id='skip_explore']")).click();
Thread.sleep(1000);

int rows = xls.getRowCount("Sheet1");
int cols = xls.getColumnCount("Sheet1");

for(int rNum=2;rNum<=rows;rNum++){

String prod = xls.getCellData("Sheet1",0,rNum);
String quant = xls.getCellData("Sheet1",1,rNum);

addToBasket(prod,quant);

count++;

String cartItems = driver.findElement(By.xpath("//span[@class='uiv2-num-basket-items']")).getText().split(" ")[0].trim();
//System.out.println("Cart Items -- "+cartItems);
//System.out.println("Count of Items added: "+count);

if(count==Integer.parseInt(cartItems))
System.out.println("Basket Updated Correctly for "+count+" item(s)");
else
System.out.println("Basket is NOT Updated Correctly");

}


//View Cart
WebElement cartHover = driver.findElement(By.xpath("//div[@class='uiv2-basket-items']"));

Actions act = new Actions(driver);
act.moveToElement(cartHover).build().perform();
Thread.sleep(5000);

driver.findElement(By.xpath("//a[@class='uiv2-checkout-button-small fltr view_basket_checkout']")).click();
Thread.sleep(3000);

// U Must login :

driver.findElement(By.xpath("//*[@id='uiv2-loginform']/div[2]/span/input")).sendKeys("**********@***mail.com");
driver.findElement(By.xpath("//*[@id='password']")).sendKeys("********");
driver.findElement(By.xpath("//*[@id='password']")).sendKeys(Keys.ENTER);

Thread.sleep(3000);

//Verify SubTotal equals to addition of total prices in basket

List<WebElement> Sub_Amount_List = driver.findElements(By.xpath("//span[@class='uiv2-subtotal-rate']/span[2]"));

Double Final_SubTotal = Double.parseDouble(driver.findElement(By.xpath("//*[@id='finalSubTotal']")).getText().replace("Rs. ", "").trim());

Double Expected_SubTotal = 0.00;
for(int i=0;i<Sub_Amount_List.size();i++){
Expected_SubTotal = Expected_SubTotal + Double.parseDouble(Sub_Amount_List.get(i).getText());
}
System.out.println("Expected Sub Total : "+Expected_SubTotal);

System.out.println("Actual Sub Total : "+ Final_SubTotal);

Assert.assertEquals(Final_SubTotal,Expected_SubTotal);
System.out.println("Assert -- Final SubTotal is Equal To Expected SubTotal");

//To verify Basket against Excel ----*****Unable to Verify********

List<WebElement> part1_list = driver.findElements(By.xpath("//div[@class='uiv2-yourbasketitems-gridlist']/div/ul/li[2]/a[1]"));
List<WebElement> part2_list = driver.findElements(By.xpath("//div[@class='uiv2-yourbasketitems-gridlist']/div/ul/li[2]/a[2]"));

List<WebElement> quantity_list = driver.findElements(By.xpath("//input[@class='text-change-qty-search-popup'and @type='text']"));

for(int i=0;i<quantity_list.size();i++){
String full_name = part1_list.get(i).getText().trim() + " " + part2_list.get(i).getText().trim();
System.out.print(full_name);
String quant_indiv = quantity_list.get(i).getAttribute("value");
System.out.println(" ------- "+quant_indiv);


}

} //Function to add products to Baskets
public static void addToBasket(String productName, String productQuantity) throws Exception{

driver.findElement(By.xpath("//*[@id='id_q']")).clear();
driver.findElement(By.xpath("//*[@id='id_q']")).sendKeys(productName);
driver.findElement(By.xpath("//*[@id='auto_search']/div/form/input[2]")).click();

Thread.sleep(1000);

List<WebElement> searchResults = driver.findElements(By.xpath("//div[@id='facet-products-wrapper']/div[@id='products-container']/div/ul/li/div[3]/span/a"));

List<WebElement> quantityBoxes =driver.findElements(By.xpath("//div[@id='facet-products-wrapper']/div[@id='products-container']/div/ul/li/div[5]/div[2]/div/div[3]/input[@type='text']"));

//System.out.println("Quanity Boxes --- " + quantityBoxes.size());

for(int i=0;i<searchResults.size();i++){
String str = searchResults.get(i).getText();
//System.out.println(str);
//System.out.println(str.replace("\n", " ").trim());
//System.out.println(searchResults.get(i).getAttribute("href"));
//System.out.println(searchResults.get(i).isDisplayed());

}

List<WebElement> allButtons = driver.findElements(By.linkText("ADD"));
//System.out.println("Add Buttons -- "+allButtons.size());


int j=-1;
for(int i=0;i<searchResults.size();i++){
if(searchResults.get(i).isDisplayed())
j++;
if(productName.equalsIgnoreCase(searchResults.get(i).getText().replace("\n", " ").trim())){
quantityBoxes.get(i).clear();
quantityBoxes.get(i).sendKeys(productQuantity);
allButtons.get(j).click();
Thread.sleep(1000);
System.out.println("Successfully added --- "+searchResults.get(i).getText().replace("\n", " ").trim());

}
}

}

}