def Delete_Delivery():
Delivery_ID = request.json['DID']
Conditon = "DELIVERY_ID = '" + str(Delivery_ID) + "'"
connector = SQL(server_name, server_admin, server_password)
connector.delete_query(table='DELIVERY', sql_condition=Conditon)
connector.close_connection()
return "1"
def Accept_Request():
reqType = request.json['type']
ManagerID = request.json['MID']
connector = SQL(server_name, server_admin, server_password)
if reqType == 'Delivery':
Deliver_id = request.json['DID']
Condition = "DELIVERY_ID = '" + str(Deliver_id) + "'"
connector.delete_query(table='delivery_verification',
sql_condition=Condition)
connector.update_query(
table='DELIVERY',
columns_values_dict={'MANAGER_ID': str(ManagerID)},
sql_condition=Condition)
elif reqType == 'Store':
Store_id = request.json['SID']
store_branch_id = request.json['BID']
Condition = "STORE_branch_ID = '" + str(store_branch_id) + "'"
connector.delete_query(table='store_verification',
sql_condition=Condition)
connector.update_query(
table='Store_branch',
columns_values_dict={'MANAGER_ID': str(ManagerID)},
sql_condition=Condition)
connector.close_connection()
return "1"
def RemoveFromCart():
sql = SQL(server_name, server_admin)
dentist_id = request.json['DentistID']
product_id = request.json['ProductID']
sql.delete_query(
'DentistCart',
f" DENTIST_ID = {dentist_id} and PRODUCT_ID = {product_id}")
sql.close_connection()
return "1"
def Delete_Store():
Store_ID = request.json['SID']
Mid = request.json['MID']
Conditon = "STORE_ID = '" + str(
Store_ID) + "'" + " AND MANAGER_ID = '" + str(Mid) + "'"
print(Conditon)
connector = SQL(server_name, server_admin, server_password)
connector.delete_query(table='STORE_branch', sql_condition=Conditon)
connector.close_connection()
return "1"
def Reject_Request():
reqType = request.json['type']
ManagerID = request.json['MID']
connector = SQL(server_name, server_admin, server_password)
if reqType == 'Delivery':
Deliver_id = request.json['DID']
Condition = "DELIVERY_ID = '" + str(Deliver_id) + "'"
connector.delete_query(table='delivery_verification',
sql_condition=Condition)
elif reqType == 'Store':
Store_id = request.json['SID']
Condition = "STORE_ID = '" + str(Store_id) + "'"
connector.delete_query(table='store_verification',
sql_condition=Condition)
connector.close_connection()
return "1"
def ClearCart():
sql = SQL(server_name, server_admin)
dentist_id = request.json['DentistID']
sql.delete_query('DentistCart', f" DENTIST_ID = {dentist_id}")
sql.close_connection()
return "1"
