routes/ auth.py

import pandas as pd
from utils.file_initializer import CUSTOMERS_FILE

def sign_up(name, email, password, preferences, allergies, occasion):
    customers = pd.read_excel(CUSTOMERS_FILE)
    if email in customers["Email"].values:
        return "Email already exists!"
    customers = customers.append(
        {"Name": name, "Email": email, "Password": password, "Preferences": preferences, "Allergies": allergies, "Occasion": occasion},
        ignore_index=True
    )
    customers.to_excel(CUSTOMERS_FILE, index=False)
    return "Sign-Up Successful!"

def login(email, password):
    customers = pd.read_excel(CUSTOMERS_FILE)
    if email in customers["Email"].values:
        user = customers[customers["Email"] == email]
        if user.iloc[0]["Password"] == password:
            return "Login Successful!", user.iloc[0]
    return "Invalid Credentials!", None