Notes

public void readMappingSheet(Map<String,String> testDataValues){

String pathToMappingSheet= constants.pathToMappingSheet;
//Variable to be returned to downstream to fetch values from mapping sheet.
valueInMappingSheet = new LinkedHashMap<String,String>();



logger.debug("Parsing Mapping File placed in:- " + pathToMappingSheet);


List<String[]> mappingSheet;


String journeyIdInMappingSheet = testDataValues.get("journeyid");
logger.debug("JourneyId to mapping sheet -->" + journeyIdInMappingSheet);

try{
mappingSheet = parser.parseAll(new FileReader(pathToMappingSheet));
Map<Integer,String> columnsInMappingSheet = new LinkedHashMap<Integer,String>();

//Temp varaibles
int r = 1;
int testDataColumnNo = 0;

for (String[] row : mappingSheet) {

//assuming first column is always journeyID
String mappingSheetId = row[0];

if(r==1){
//Resetting the value
r=0;
for(int i=0;i<=row.length-1;i++)
{
String testDataColumn= row[i];
if(testDataColumn.equalsIgnoreCase("testdata")){
testDataColumnNo = i;

}
columnsInMappingSheet.put(i, row[i]);
}
logger.debug("Listed are the columns present in MappingSheet");

columnsInMappingSheet.forEach((k,v) -> //Java 8-> reducing entrySet Iteration
logger.debug(" key:: "+ k +" value:: "+ v));

}else if(journeyIdInMappingSheet.equals(mappingSheetId) && constants.hasFailure==false){



logger.debug(journeyIdInMappingSheet +" is matching with Matching Sheet..");
// logger.debug("nTotal No of Data present in a row : " +row.length);
for(int i=0;i<=row.length-1;i++){

if(testDataColumnNo==i && row[testDataColumnNo]!=null){
String columnValue = row[testDataColumnNo];

String testDataValue = testDataValues.get(columnValue.toLowerCase());
logger.debug(" Test Data Value " + testDataValue);
valueInMappingSheet.put(columnsInMappingSheet.get(i),testDataValue);
}else{
// System.out.println("nColumnName In mapping sheet " +columnsInMappingSheet.get(i));
logger.debug("n Mapping sheet Value: "+row[i]);
valueInMappingSheet.put(columnsInMappingSheet.get(i),row[i]);
}

}
// valueInMappingSheet.forEach((k,v) ->
// System.out.print("key <Mapping Sheet> : "+ k +" | value <Mapping Sheet> : "+ v + "n"));


/************ Class created to execute the mentioned keywords ****/

executeKeywordobj = new reusuableFunctions(valueInMappingSheet);



// Method[] n=new reusuableFunctions().getClass().getMethods();
// for (int i=0; i<n.length; i++)
// {
// System.out.println("name "+n[i].getName());
// if(n[i].getName().equals(valueInMappingSheet.get("KeyWord")))
// {
//Passing keyword alone
performactionobj = new performAction(valueInMappingSheet.get("KeyWord"),valueInMappingSheet.get("Use Case"),valueInMappingSheet.get("Expected Result") );

performAction.executeAction();

// }
// else
// {
// logger.info("Incorrect keyword in the mapping sheet.. Please check..");
// constants.hasFailure=true;
// constants.statusFlag="Failed: Incorrect keyword in the mapping sheet";
// }
//}






}else{
logger.info("n" + journeyIdInMappingSheet +" is mismatching with mappingSheet");
String mismatchJourneyID ="Journey " + journeyIdInMappingSheet + " provided is mismatching with mappingSheet ";

}
}
}catch(FileNotFoundException E)
{
logger.error("Mapping Sheet: Missing");
reusuableFunctions.dispayAlert("Mapping Sheet Missing in Mentioned Path");

}
}




}