public void ScreenData(string filename)
{
string ExcelLocation = filename;
int ExcelPageNumber = 1;
var tcList = new List <ExcelModel>(); // Data which we really want to use in this test
var excelData = _excelManager.Read(ExcelLocation, ExcelPageNumber);
_excelHelper.HandleEmptyAndNullData(excelData, ExcelHelperRule.CUCUMBER);
_excelConverter.MapTestcase(excelData, tcList);
for (var i = 0; i < tcList.Count; i++)
{
_testcase.Add(tcList[i].TestcaseNumber);
_hotelid.Add(tcList[i].HotelID);
_checkin.Add(tcList[i].CheckIn);
_los.Add(tcList[i].Los);
_rateplan.Add(tcList[i].RatePlan);
_adult.Add(tcList[i].Adult);
_children.Add(tcList[i].Children);
_childage.Add(tcList[i].ChildAge);
_room.Add(tcList[i].Rooms);
_isallocc.Add(tcList[i].IsAllOcc);
_allownocc.Add(tcList[i].AllowOverideOcc);
_hotelid2.Add(tcList[i].HotelID2);
_roomid.Add(tcList[i].RoomID);
_channel.Add(tcList[i].Channel);
_currency.Add(tcList[i].Currency);
_rateplan2.Add(tcList[i].RatePlan2);
_occupancy.Add(tcList[i].Occupancy);
_maxextrabed.Add(tcList[i].MaxExtraBed);
_isfit.Add(tcList[i].IsFit);
_extrabed.Add(tcList[i].ExtraBad);
_sellex.Add(tcList[i].SellEx);
//breakdown task
_date.Add(tcList[i].Date);
_type.Add(tcList[i].Type);
_option.Add(tcList[i].Option);
_quantity.Add(tcList[i].Quantity);
_sellex2.Add(tcList[i].SellEx2);
_type2.Add(tcList[i].Type2);
_option2.Add(tcList[i].Option2);
_quantity2.Add(tcList[i].Quantity2);
_sellex3.Add(tcList[i].SellEx3);
}
}