def test_billing_details(setup):
setup.full_name_details(get_cell_data(8,2))
setup.phone_details(get_cell_data(9,2))
setup.email_details(get_cell_data(10,2))
setup.country_details()
setup.add_line_details(get_cell_data(11,2),get_cell_data(12,2))
setup.city_details(get_cell_data(13,2))
setup.state_details()
setup.postcode_details(get_cell_data(15,2))
def test_input_first_and_last_name(setup):
setup.input_name_from_excel(get_cell_data(1,2),get_cell_data(2,2))
def test_passenger1_name(setup):
setup.pass1_name_excel(get_cell_data(3,2),get_cell_data(4,2))
def test_city(setup):
setup.travel_from_to(get_cell_data(5,2),get_cell_data(6,2))
def test_input_income_details(cal_setup):
logger.info("started to input data from excel sheet")
cal_setup.no_of_young_dep(get_cell_data(22,2))
cal_setup.no_of_other_dep(get_cell_data(23,2))
cal_setup.wage_amount(get_cell_data(24,2))
cal_setup.fed_tax_withheld(get_cell_data(25,2))
cal_setup.state_tax_withheld(get_cell_data(26,2))
cal_setup.local_tax_withheld(get_cell_data(27,2))
cal_setup.interest_income_amount(get_cell_data(28,2))
cal_setup.ordinary_div_amt(get_cell_data(29,2))
cal_setup.quali_div_amt(get_cell_data(30,2))
cal_setup.passive_inc_amt(get_cell_data(31,2))
cal_setup.short_term_cap_gain(get_cell_data(32,2))
cal_setup.long_term_cap_gain(get_cell_data(33,2))
cal_setup.tax_rate_percentage(get_cell_data(34,2))
cal_setup.ira_deduction_amt(get_cell_data(37,2))
cal_setup.mortgage_amt(get_cell_data(38,2))
cal_setup.charity_amt(get_cell_data(39,2))
cal_setup.collage_edu_amt(get_cell_data(40,2))