Bank.py

from datetime import datetime
import pandas
import os
import random
import string
account_numbers_list=[]

class Validation:
    def __init__(self):
        self.first_name=""
        self.last_name=""
        self.phone=""
        self.birthday=""
        self.nationalcode=""
        self.inventory=""
        self.email=""
        self.account_num=""
        

    #Validation of name (must be letter)
    def validation_name(self):
        while (True):
            for character in self.first_name:
                if character not in string.ascii_letters  :
                    print( "Error\n!!!You are not allowed to use characters <<!/@^%#@*()!1-9,...>> in this field!!!")
                    self.first_name=input("Name again:")
                    break
                else:
                    return True
                
#Validation of last name (must be letter)
    def validation_lastname(self):
        while(True):
            for chracters in self.last_name:
                if chracters not in string.ascii_letters:
                    print( "Error\n!!!You are not allowed to use characters <<!/@^%#@*()!1-9,...>> in this field!!!")
                    self.last_name=input("Name again:")
                    break
                else:
                    return True


    #Validation of Phone (must be statred with "09" and has 11 chracters)
    def validation_Phone(self):
        while (True):
            if len(self.phone)!=9:
                print("Error\n!!! length phone is invalid !!!")
                self.phone=input("Phone again:09")
            for character in self.phone:
                if  character not in string.digits:
                    print("Error\n!!! Your phone is invalid !!!")
                    self.phone=input("Phone again:09")
                    break
                else:
                    return True
                
    #Validation of date (must be like: 1900-12-30)
    def validation_date(self):
        while(True):
            try:
                datetime.strptime(self.birthday,"%Y-%m-%d")
                return True
            except:
                print("Error\n!!! Your date of birthday is invalid !!!")
                self.birthday=input("Birthday again:")
                break

    # must be int and not be Empty
    def validation_inventory(self):
        while(True):
            if  not self.inventory.isdigit():
                print("Error\n!!! Your inventory is invalid you just enter number !!!")
                self.inventory=input("inventory again:")
                continue
            else: 
                self.inventory=int(self.inventory)
                return True
            


    #Validation of Nationalcode
    def validation_nationalcode(self):
        while (True):
            if len(self.nationalcode)!=9:
                print("Error\n!!! length nationalcode is invalid !!!")
                self.nationalcode=input("National Code again:0")
            for character in self.nationalcode:
                if  character not in string.digits:
                    print("Error\n!!! Your NationalCode has invalid characters!!!\njust use number")
                    self.nationalcode=input("National Code again:0")
                    break
                else:
                    return True

    #Validation of email 
    # 1)Email should have @ and .
    # 2)Email should have a @ just once
    # 3)Email should have a . in domain (gmail.com)
    # 4)Email should have a something before and after @ and couldn't be empty.
    # 5)Email should have domain for gmail(just gamil.com)
    def validation_email(self):
        while(True):
           
            if "@"  not in self.email or "." not in self.email:
                print("Error\n!!! Your Email is invalid !!!")
                self.email=input("Email again:").lower()
                continue
            if self.email.count("@")!=1:
                print("Error\n!!! Your Email is invalid \n You can not use to <@> more than onece!!!")
                self.email=input("Email again:").lower()
                continue
                
            if self.email.split("@")[0]=="" or self.email.split("@")[1]=="":
                print("Error\n!!! Your Email is invalid \n You must enter something after or befor <@>!!!")
                self.email=input("Email again:").lower()
                continue
            if "." not in self.email.split("@")[1] or "" in self.email.split("@")[1].split("."):
                print("Error\n!!! Your Email is invalid \n You must use to < . > in domain name !!!")
                self.email=input("Email again:").lower()
                continue
            if self.email.split("@")[1] !="gmail.com":
                print("Error\n!!! Your Email is invalid \n not incorrect <gmail.com> !!!")
                self.email=input("Email again:").lower()
                continue
            return True
    # Making Account numbers
    def validation_accountnumber(self):
        while(True):
            temp=''
            try:
                for i in range(int(self.account_num)):
                    temp+=str(random.randint(0,9))
                if temp not in account_numbers_list:
                    account_numbers_list.append(temp)
                    print(f"make the account number sucssesfully! ---------> {temp}")
                    break
                else:
                    print("this account number was exise in\npls wait make another...")
                    continue
            except:
                print("Error ! just enter number")
                self.account_num=input("length Account Number again (default=16):")
                continue

class SaveToExcel:
    def __init__(self, excel_file=r"Bank.xlsx", text_file=r"Bank.txt"):
        # path_=os.getcwd()
        # self.text_file=path_ + "/Bank.txt"
        # self.excel_file=path_ + "/Bank.xlsx"
        path_=os.path.dirname(os.path.abspath(__file__))
        self.text_file=os.path.join(path_,"Bank.txt")
        self.excel_file=os.path.join(path_,"Bank.xlsx")
        if not os.path.exists(self.excel_file):
            dataformat=pandas.DataFrame(columns=["First Name","Last Name","Phone","Birthday","NationalCode","Inventory","Email","Account Number"])
            dataformat.to_excel(self.excel_file, index=False)
        if not os.path.exists(self.text_file):
            open(self.text_file,"w").close()
        
    def save_to_text(self, first_name, last_name, phone, birthday, nationalcode, inventory, email, account_num):
        with open(self.text_file, "a", encoding="utf-8") as txt:
            txt.write(f"{first_name}\t{last_name}\t{phone}\t{birthday}\t{nationalcode}\t{inventory}\t{email}\t{account_num}\n")
        print("Adding user Succesfully!")
    def save_to_excel(self):
        datas=pandas.read_csv(self.text_file, sep="\t", header=None, names=["First Name","Last Name","Phone","Birthday","NationalCode","Inventory","Email","Account Number"], dtype=str)
        if os.path.exists(self.excel_file):
            before_data=pandas.read_excel(self.excel_file)
            if ((before_data["First Name"]==datas["First Name"][0])&(before_data["Last Name"]==datas["Last Name"][0])).any():
                 print("user exists")
        datas=pandas.concat([before_data,datas], ignore_index=True)
        datas["Phone"]="09"+datas["Phone"].astype(str)
        datas["NationalCode"]="0"+datas["NationalCode"].astype(str)
        datas["Account Number"]=""+datas["Account Number"].astype(str)
        datas.to_excel(self.excel_file, index=False)
        print("Saved to Excel Succesfully!")
    def final_save_excel(self, first_name, last_name, phone, birthday, nationalcode, inventory, email, account_num):
        data_read=pandas.read_excel(self.excel_file, dtype=str)
        if ((data_read["First Name"]==first_name)&(data_read["Last Name"]==last_name)&(data_read["Phone"]==phone)).any():
            print("______ERROR______\nUser exists")
            return
        self.save_to_text(first_name, last_name, phone, birthday, nationalcode, inventory, email, account_num)
        self.save_to_excel()

valid=Validation()
saving_excel=SaveToExcel()

class User:
    def __init__(self, first_name="", last_name="", phone="", birthday="", nationalcode="", inventory="", email="", account_num=""):
        self.first_name=first_name
        self.last_name=last_name
        self.phone=phone
        self.birthday=birthday
        self.nationalcode=nationalcode
        self.inventory=inventory
        self.email=email
        self.account_num=account_num
#1
    def creat_user(self):
        valid.first_name=input("Name:")
        valid.validation_name()
        valid.last_name=input("Last Name:")
        valid.validation_lastname()
        valid.phone=input("Phone:09")
        valid.validation_Phone()
        valid.birthday=input("Birthday (Like this:1900-12-30):")
        valid.validation_date()
        valid.nationalcode=input("National Code:0")
        valid.validation_nationalcode()
        valid.inventory=input("Inventory:")
        valid.validation_inventory()
        valid.email=input("Email:").lower()
        valid.validation_email()
        valid.account_num=input("length Account Number (default=16):")
        valid.validation_accountnumber()
        saving_excel.final_save_excel(valid.first_name,
                                    valid.last_name,
                                    valid.phone,
                                    valid.birthday,
                                    valid.nationalcode,
                                    valid.inventory,
                                    valid.email,
                                    account_numbers_list[-1]
                                    )
        exit("__________DONE__________")
#2
    def deposit_account(self):
        deposit_src=input("Enter account number:").strip()
        path_=os.path.dirname(os.path.abspath(__file__))
        excel_file=os.path.join(path_,"Bank.xlsx")
        if not os.path.exists(excel_file):
            print("__ERROR___\nYOU FIRST MAKE ACCOUNT!")
            return
        data=pandas.read_excel(excel_file,dtype=str)
        source=data[data['Account Number']==deposit_src]
        get_amount=None
        try:
            get_amount=int(input(f"How much do you put into \n{str(source["First Name"].values[0])}\n{str(source["Last Name"].values[0])}\n{str(source["Account Number"].values[0])}\n:"))
        except:
            print("Error!\nNot found it\nFirst crean account")
            return
        if get_amount>0 and int(source["Inventory"].values[0])>=get_amount:
            result_src=data[data['Account Number']==deposit_src]
            try:
                inventory_src=int(result_src['Inventory'].values[0])
            except:
                print("Error!")
            nvt_caculate_src=inventory_src+get_amount
            data=pandas.read_excel(excel_file,dtype=str)
            data['Inventory']=data['Inventory'].astype(int)
            src_index=data.index[data['Account Number']==deposit_src][0]
            data.at[src_index, 'Inventory']=nvt_caculate_src
            data.to_excel(excel_file, index=False)
            print("_______________CONGRATULATIONS________________\n____________Money deposit completed successfully_____________\n_________________Inventory update successfully________________")
            print(f"to {str(source["First Name"].values[0])} {str(source["Last Name"].values[0])} with {str(source["Account Number"].values[0])} with {get_amount}$")
#3
    def withdarawal_account(self):
        deposit_src=input("Enter account number:").strip()
        path_=os.path.dirname(os.path.abspath(__file__))
        excel_file=os.path.join(path_,"Bank.xlsx")
        if not os.path.exists(excel_file):
            print("__ERROR___\nYOU FIRST MAKE ACCOUNT!")
            return
        data=pandas.read_excel(excel_file,dtype=str)
        source=data[data['Account Number']==deposit_src]
        get_amount=None
        try:
            get_amount=int(input(f"How much do you put into \n{str(source["First Name"].values[0])}\n{str(source["Last Name"].values[0])}\n{str(source["Account Number"].values[0])}\n:"))
        except:
            print("Error!\nNot found it\nFirst crean account")
            return
        if get_amount>0 and int(source["Inventory"].values[0])>=get_amount :
            result_src=data[data['Account Number']==deposit_src]
            try:
                inventory_src=int(result_src['Inventory'].values[0])
            except:
                print("Error!")
            nvt_caculate_src=inventory_src-get_amount
            if nvt_caculate_src>=0:
                data=pandas.read_excel(excel_file,dtype=str)
                data['Inventory']=data['Inventory'].astype(int)
                src_index=data.index[data['Account Number']==deposit_src][0]
                data.at[src_index, 'Inventory']=nvt_caculate_src
                data.to_excel(excel_file, index=False)
                print("_______________CONGRATULATIONS________________\n____________Money withdrawal completed successfully_____________\n_________________Inventory update successfully________________")
                print(f"{str(source["First Name"].values[0])} {str(source["Last Name"].values[0])} with {str(source["Account Number"].values[0])} withdraval {get_amount}$")
            else:
                print("Not enough inventory")
#4 
    def edit_info_account(self):
        deposit_src=input("Enter account number:").strip()
        path_=os.path.dirname(os.path.abspath(__file__))
        excel_file=os.path.join(path_,"Bank.xlsx")
        if not os.path.exists(excel_file):
            print("__ERROR___\nYOU FIRST MAKE ACCOUNT!")
            return
        data=pandas.read_excel(excel_file,dtype=str)
        if deposit_src not in data["Account Number"].values:
            print("this account number not found")
            return
        src_index=data.index[data['Account Number']==deposit_src][0]
        while True:
            print("which field you want to change it?\n1)first name\n2)last name\n3)phone\n4)birthday\n5)nationalcode\n6)Email\n")
            try:
                get_=int(input("pls Enter number(1-6):"))
            except:
                print("ERROR!\njust enter number")
                return
            if get_==1:
                valid.first_name=input("pls enter new name:")
                valid.validation_name()
                data.at[src_index,"First Name"]=valid.first_name

            elif get_==2:
                valid.last_name=input("pls enter new last name:")
                valid.validation_lastname()
                data.at[src_index,"Last Name"]=valid.last_name
            elif get_==3:
                valid.phone=input("pls enter new phone:09")
                valid.validation_Phone()
                data.at[src_index,"Phone"]="09"+str(valid.phone)
            elif get_==4:
                valid.birthday=input("pls enter new Birthday:")
                valid.validation_date()
                data.at[src_index,"Birthday"]=valid.birthday
            elif get_==5:
                valid.nationalcode=input("pls enter new nationalcode:0")
                valid.validation_nationalcode()
                data.at[src_index,"NationalCode"]="0"+valid.nationalcode
            elif get_==6:
                valid.email=input("pls enter new email:")
                valid.validation_email()
                data.at[src_index,"Email"]=valid.email

            print("_____________________Edited successfully_________________________")
            data.to_excel(excel_file, index=False)
#5   
    def show_money(self):
        
        deposit_src=input("Enter account number to see value of money:").strip()
        path_=os.path.dirname(os.path.abspath(__file__))
        excel_file=os.path.join(path_,"Bank.xlsx")
        if not os.path.exists(excel_file):
            print("__ERROR___\nYOU FIRST MAKE ACCOUNT!")
            return
        try:
            data=pandas.read_excel(excel_file,dtype=str)
        except:
            print("Error!")
            return
        try:
            source=data[data['Account Number']==deposit_src]
        except:
            print("Error!")
            return
        try:
            inventory_src=int(source['Inventory'].values[0])
        except:
            print("Error!")
            return
        print("_____________________________Total value money____________________________")
        print(f"{ source['First Name'].values[0]} {source['Last Name'].values[0]} =========> {inventory_src}$")
#6
    def transfer_money(self, excel_file=r"Bank.xlsx"):
        path_=os.path.dirname(os.path.abspath(__file__))
        path_excel=os.path.join(path_,"Bank.xlsx")
        data=pandas.read_excel(path_excel, dtype=str)
        while True:
            deposit_src=input("Source account number:").strip()
            source=data[data['Account Number']==deposit_src]
            

            if source.empty :
                print("Error!\n not found source in excel!")
                continue
            
            print("______FOUND ACCOUNT_______")
            print(source)
            try:
                get_user=int(input("<<<CONFIRM INFORMATION>>>\n 1)Next\t 2)Cancel\t=>"))
            except:
                print("ERROR!")
                continue
            if get_user==1:
                print("_____next____")
                break
            elif get_user==2:
                exit("____EXIT____")
                return
            else:
                print("JUST ENTER NUM 1/2")
                continue
        while True:
            deposit_dst=input("Destination account number:").strip()
            destination=data[data['Account Number']==deposit_dst]
            

            if destination.empty :
                print("Error!\n not found destination in excel!")
                continue
            
            print("______FOUND ACCOUNT_______")
            print(destination)
            try:
                get_user_=int(input("<<<CONFIRM INFORMATION>>>\n 1)Next\t 2)Cancel\t=>"))
            except:
                print("ERROR!")
                continue
            if get_user_==1:
                print("_____next____")
                get_amount=int(input(f"How much do you put into \n{str(destination["First Name"].values[0])}\n{str(destination["Last Name"].values[0])}\n{str(destination["Account Number"].values[0])}\n:"))
                if get_amount>0 and int(source["Inventory"].values[0])>=get_amount:
                    path_=os.path.dirname(os.path.abspath(__file__))
                    excel_file=os.path.join(path_,"Bank.xlsx")
                    if not os.path.exists(excel_file):
                        print("__ERROR___\nYOU FIRST MAKE ACCOUNT!")
                        return
                    data=pandas.read_excel(excel_file,dtype=str)
                    result_src=data[data['Account Number']==deposit_src]
                    result_dst=data[data['Account Number']==deposit_dst]
                    try:
                        inventory_src=int(result_src['Inventory'].values[0])
                        inventory_dst=int(result_dst['Inventory'].values[0])
                    except:
                        print("Error!")
                    nvt_caculate_src=inventory_src-get_amount
                    nvt_caculate_dst=inventory_dst+get_amount
                    data=pandas.read_excel(excel_file,dtype=str)
                    data['Inventory']=data['Inventory'].astype(int)
                    src_index=data.index[data['Account Number']==deposit_src][0]
                    dst_index=data.index[data["Account Number"]==deposit_dst][0]
                    data.at[src_index, 'Inventory']=nvt_caculate_src
                    data.at[dst_index, 'Inventory']=nvt_caculate_dst
                    data.to_excel(excel_file, index=False)
                    print("_______________CONGRATULATIONS________________\n____________Money transfer completed successfully_____________\n_________________Inventory update successfully________________")
                    print(f"FROM {str(source["First Name"].values[0])} {str(source["Last Name"].values[0])} with {str(source["Account Number"].values[0])}----------TO------------{str(destination["First Name"].values[0])} {str(destination["Last Name"].values[0])} with {str(destination["Account Number"].values[0])}")

                else:
                        print("You can't make the payment")
                break
            elif get_user_==2:
                exit("____EXIT____")
                return
            else:
                print("JUST ENTER NUM 1/2")
                continue

def Home_page():
    user_bank=User()
    print("___________________WELCOME_______________________")
    print("1)Creat an account\n2)Deposit to the account\n3)Withdraw from the account\n4)Change account details\n5)View account balance\n6)Transfer to another person's account")
    try:
        choice=int(input("Enter your choices (1-6):"))
    except:
        print("Error!\njust enter number")
    if choice==1:
        user_bank.creat_user()
    elif choice==2:
        user_bank.deposit_account()
    elif choice==3:
        user_bank.withdarawal_account()
    elif choice==4:
        user_bank.edit_info_account()
    elif choice==5:
        user_bank.show_money()
    elif choice==6:
        user_bank.transfer_money()

Home_page()