def get_car_by_licensenumber(): print("Enter a License Number") license_number = f_input() car = cc.get_car_by_id(license_number) if car: print_tablerow(car) else: print("not found")
def get_car_model_by_id(): print("Enter a id") c_id = f_input() car_model = cc.get_car_model_by_id(c_id) if car_model: print_tablerow(car_model) else: print("not found")
def add_car_model(): insert_dict = {} for column in cc.get_columns(): if column != "id": insert_dict[column] = input(f'{column}: ') car_model = cc.add_car_model(insert_dict) if car_model: print_tablerow(car_model) return car_model
def add_car(): insert_dict = {} for column in cc.get_columns(): if column == "date": insert_dict[column] = datetime.datetime.now() else: insert_dict[column] = input(f'{column}: ') car = cc.add_car(insert_dict) if car: print_tablerow(car) return car
def create_contact_person(): print('Add contact persons information') print('===============================') insert_dict = {} for column in cpc.get_columns(): if column != "id": insert_dict[column] = input(f'{column}: ') contact_person = cpc.add_cp(insert_dict) if contact_person: print_tablerow(contact_person) return contact_person
def add_associate(): insert_dict = {} for column in ac.get_columns(): if column != "id": insert_dict[column] = input(f'{column}: ') if column == 'contact_person_id': contact_person = create_contact_person() insert_dict[column] = contact_person.id divider() associate = ac.add_associate(insert_dict) if associate: print_tablerow(associate)
def add_customer(): insert_dict = {} for column in cc.get_columns(): if column != "id": insert_dict[column] = input(f'{column}: ') divider() customer = cc.add_customer(insert_dict) if customer: print_tablerow(customer) menu({ "1": { "info": "add car", "func": bind_add_customer_car(customer) } })
def show_associate_by_id(): print("Enter an Associate Id") a_id = f_input() associate = ac.show_associate_by_id(a_id) if associate: print_tablerow(associate) cp_id = associate.contact_person_id print(f'Do you want to show >{associate.name}s< contact person?\n' '1: Yes\n' '2: No') if int(f_input()) == 1: contact_person = cpc.show_cp_by_id(cp_id) print_tablerow(contact_person) else: return
def update_storage_column(column, storage): print("Enter new value: ") value = f_input() cc.update_storage_column(storage, column, value) print_tablerow(storage)
def update_internal_order_column(column, internal_order): print("Enter new value: ") value = f_input() cc.update_internal_order_column(internal_order, column, value) print_tablerow(internal_order)
def get_storage_by_id(): print("Enter a Storage Id") c_id = f_input() storage = cc.get_storage_by_id(c_id) print_tablerow(storage)
def get_employee_by_id(): print("Enter a Employee Id") c_id = f_input() employee = cc.get_employee_by_id(c_id) print_tablerow(employee)
def get_internal_order_by_id(): print("Enter a InternalOrder Id") c_id = f_input() internal_order = cc.get_internal_order_by_id(c_id) print_tablerow(internal_order)
def get_customer_by_id(): print("Enter a Customer Id") c_id = f_input() customer = cc.get_customer_by_id(c_id) print_tablerow(customer)
def update_customer_column(column, customer): print("Enter new value: ") value = f_input() cc.update_customer_column(customer, column, value) print_tablerow(customer)
def update_employee_column(column, employee): print("Enter new value: ") value = f_input() cc.update_employee_column(employee, column, value) print_tablerow(employee)
def get_order_by_id(): print("Enter a Order Id") c_id = f_input() order = cc.get_order_by_id(c_id) print_tablerow(order)
def update_contact_person_column(column, contact_person): print("Enter new value: ") value = f_input() cpc.update_cp_column(contact_person, column, value) print_tablerow(contact_person)
def update_associate_column(column, associate): print("Enter new value: ") value = f_input() ac.update_associate_column(associate, column, value) print_tablerow(associate)
def update_car_model_column(column, car_model): print("Enter new value: ") value = f_input() cc.update_car_model_column(car_model, column, value) print_tablerow(car_model)
def get_compatibility_by_id(): print("Enter a Compatibility Id") c_id = f_input() compatibility = cc.get_compatibility_by_id(c_id) print_tablerow(compatibility)
def update_order_product_column(column, order_product): print("Enter new value: ") value = f_input() cc.update_order_product_column(order_product, column, value) print_tablerow(order_product)
def update_compatibility_column(column, compatibility): print("Enter new value: ") value = f_input() cc.update_compatibility_column(compatibility, column, value) print_tablerow(compatibility)
def update_product_associate_column(column, product_associate): print("Enter new value: ") value = f_input() cc.update_product_associate_column(product_associate, column, value) print_tablerow(product_associate)