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)
