ABC_CoreBankingSystem.py

import mysql.connector as spc

co = spc.connect(host='localhost', user='toor', passwd='')


# Creating a Bank Account
def CreateAccount():
    # OTP Password = nsiruyegnabfpawh
    cu = co.cursor()
    # cu.execute("create database ABC_CBS;")
    cu.execute("use ABC_CBS;")
    # cu.execute("create table user_details(Aadhar bigint primary key, Mobile_No bigint, GMail_ID varchar(50), Password varchar(50), Name varchar(50), DateOfBirth date, Balance float default 0.0);")
    loop = True
    while loop:
        print()
        choice_2 = input("Would you like to create an Account? (Yes/No): ")
        print()
        if choice_2 == "Yes" or choice_2 == "yes":
            user_aadhar = int(input("Please enter your Aadhar Number (Must be 12-Digits): "))
            user_mobile_no = int(input("Please enter your Mobile Number (Must be 10-Digits): "))
            user_gmail_id = input("Please enter your G-Mail ID: ")
            try:
                while True:
                    if OTPVerification(user_gmail_id):
                        print('OTP verified successfully.')
                        print()
                        break
                    else:
                        print("OTP failed to verify. Please try again.")
                        continue
            except:
                print()
                print("Invalid G-Mail ID. Please try again.")
                continue

            while True:
                user_passwd = input("Please enter a Strong Password: ")
                user_passwd_r = input("Please re-enter your Password: ")
                print()
                if user_passwd == user_passwd_r:
                    break
                else:
                    print("Passwords don't match. Please try again.")
                    print()
                    continue
            user_name = input("Please enter your Name: ")
            user_dob = input("Please enter your Date of Birth (YYYY-MM-DD): ")
            query = "insert into user_details values(%s, %s, '%s', '%s', '%s', '%s', 0.0)" % (user_aadhar, user_mobile_no, user_gmail_id, user_passwd, user_name, user_dob)
            cu.execute(query)
            print()
            print("Account created!")

            loop2 = True
            while loop2:
                print()
                choice_3 = input("Would you like to create another account? (Yes/No): ")
                if choice_3 == "Yes" or choice_3 == "yes":
                    break
                elif choice_3 == "No" or choice_3 == "no":
                    loop = False
                    loop2 = False
                    print()
                else:
                    print()
                    print("Invalid choice. Please enter your choice again.")
                    continue
        elif choice_2 == "No" or choice_2 == "no":
            break
        else:
            print("Invalid choice. Please enter your choice again.")
        co.commit()


# Logging into an Account
def LoginAccount():
    cu = co.cursor()
    cu.execute("use ABC_CBS;")
    loop = True
    global logged_in
    logged_in = False
    while loop:
        cu.execute("select * from user_details;")
        data = cu.fetchall()
        count = 0
        print()
        temp_g = input("Please enter your G-Mail ID: ")
        temp_p = input("Please enter your password: ")
        for i in range(len(data)):
            if temp_g == data[i][2]:
                count = count + 1
        for i in range(len(data)):
            if count == 1:
                if temp_g == data[i][2] and temp_p == data[i][3]:
                    loop4 = True

                    while loop4:
                        if OTPVerification(temp_g):
                            print('OTP verified successfully.')
                            print()
                            print("Successfully logged in! Welcome back,", data[i][4])
                            logged_in = True
                            loop4 = False
                        else:
                            print("OTP failed to verify. Please try again.")
                            continue
                    break
            elif count == 0:
                print()
                print("No Accounts found. Please try again.")
                break
            elif count > 1 and temp_g == data[i][2] and temp_p == data[i][3]:
                print()
                print("Accounts with the same email has been found. Please enter your Aadhar Number to continue.")
                loop2 = True
                while loop2:
                    print()
                    temp_a = int(input("Please enter your Aadhar Number: "))
                    for i in range(len(data)):
                        if temp_g == data[i][2] and temp_p == data[i][3] and temp_a == data[i][0]:
                            print()
                            print("Successfully logged in! Welcome back,", data[i][4])
                            logged_in = True
                            loop2 = False
                            break
                    else:
                        print()
                        print("Invalid Aadhar. Please try again.")
                        loop2 = False
                        continue
                break
        else:
            print()
            print("Wrong G-Mail/Password. Please try again.")
            logged_in = False

        try:
            if temp_a:
                pass
        except:
            temp_a = None
        if logged_in:
            ManageAccount(temp_g, temp_a)
            print()
            loop3 = True
            while loop3:
                choice_2 = input("Do you wish to login to another account? (Yes/No): ")
                if choice_2 == 'Yes' or choice_2 == 'yes':
                    loop3 = False
                    loop = True
                    logged_in = False
                    continue
                elif choice_2 == 'No' or choice_2 == 'no':
                    loop = False
                    print()
                    break
                else:
                    print("Invalid choice. Please try again.")
                    print()
                    continue
        co.commit()


# Changing the Customer's G-Mail ID
def ChangeMobile(t_go):
    cu = co.cursor()
    cu.execute("use ABC_CBS;")
    i = 0
    loop = True
    new_mobile = None
    while loop:
        cu.execute("select * from user_details")
        data = cu.fetchall()
        print()
        t_a = int(input("Please enter your Aadhar Number: "))
        t_m = input("Please enter your new Mobile Number: ")
        while i < len(data):
            if t_a == data[i][0] and t_go == data[i][2]:
                query = "update user_details set Mobile_No = '%s' where Aadhar = %s" % (t_m, t_a)
                cu.execute(query)
                loop = False
                new_mobile = True
                break
            i = i + 1
        else:
            loop2 = True
            while loop2:
                choice_2 = input("Mobile Number not updated. Would you like to try again? (Yes/No): ")
                if choice_2 == "Yes" or choice_2 == "yes":
                    break
                elif choice_2 == "No" or choice_2 == "no":
                    loop = False
                    break
                else:
                    print("Invalid choice. Please try again.")
    if new_mobile:
        print()
        print("Mobile Number changed successfully.")

    co.commit()


# Changing the Customer's G-Mail ID
def ChangeGMail(t_go):
    cu = co.cursor()
    cu.execute("use ABC_CBS;")
    i = 0
    loop = True
    new_mail = None
    while loop:
        cu.execute("select * from user_details")
        data = cu.fetchall()
        print()
        t_a = int(input("Please enter your Aadhar Number: "))
        t_g = input("Please enter your new G-Mail ID: ")
        while True:
            if OTPVerification(t_g):
                print('OTP verified successfully.')
                print()
                break
            else:
                print("OTP failed to verify. Please try again.")
                print()
                continue
        while i < len(data):
            if t_a == data[i][0] and t_go == data[i][2]:
                query = "update user_details set GMail_ID = '%s' where Aadhar = %s" % (t_g, t_a)
                cu.execute(query)
                loop = False
                new_mail = True
                break
            i = i + 1
        else:
            loop2 = True
            while loop2:
                choice_2 = input("G-Mail not updated. Would you like to try again? (Yes/No): ")
                if choice_2 == "Yes" or choice_2 == "yes":
                    break
                elif choice_2 == "No" or choice_2 == "no":
                    loop = False
                    break
                else:
                    print("Invalid choice. Please try again.")
    if new_mail:
        print("G-Mail changed successfully.")

    co.commit()


# Changing the Customer's Password
def ChangePassword():
    cu = co.cursor()
    cu.execute("use ABC_CBS;")

    loop = True

    while loop:
        cu.execute("select * from user_details;")
        data = cu.fetchall()
        print()
        print("1. Change Password via G-Mail")
        print("2. Change Password via Aadhar Verification")
        print("3. Exit")
        print()
        choice_2 = int(input("Please enter your choice: "))
        print()
        if choice_2 == 1:
            temp_g = input("Please enter your G-Mail ID: ")
            otp_v = False
            while True:
                try:
                    if OTPVerification(temp_g):
                        print('OTP verified successfully.')
                        print()
                        otp_v = True
                        break
                except:
                    print("OTP failed to verify. Please try again.")
                    print()
                    continue

            while True:
                new_p = input("Please enter a Strong Password: ")
                new_pr = input("Please re-enter your Password: ")
                if new_p == new_pr:
                    break
                else:
                    print()
                    print("Passwords don't match. Please try again.")
                    print()
                    continue

            count = 0
            for i in range(len(data)):
                if temp_g == data[i][2]:
                    count = count + 1

            for i in range(len(data)):
                if count == 1 and otp_v:
                    query = "update user_details set Password = '%s' where GMail_ID = '%s';" % (new_p, temp_g)
                    cu.execute(query)
                    print()
                    print("Password changed successfully.")
                    loop = False
                    break
                elif count > 1:
                    print()
                    print("More than 2 Accounts with same G-Mail has been found.")
                    temp_a = int(input("Please enter your Aadhar Number: "))
                    for i in range(len(data)):
                        if temp_g == data[i][2] and temp_a == data[i][0]:
                            query = "update user_details set Password = '%s' where GMail_ID = '%s' and Aadhar = '%s';" % (new_p, temp_g, temp_a)
                            cu.execute(query)
                            print()
                            print("Password changed successfully.")
                            loop = False
                            break
                    else:
                        print('Invalid G-Mail ID/Aadhar. Please try again.')
                        print()
                    break
        elif choice_2 == 2:
            temp_g = input("Please enter your G-Mail ID: ")
            temp_a = int(input("Please enter your Aadhar Number: "))

            while True:
                new_p = input("Please enter a Strong Password: ")
                new_pr = input("Please re-enter your Password: ")
                if new_p == new_pr:
                    break
                else:
                    print()
                    print("Passwords don't match. Please try again.")
                    print()
                    continue

            for i in range(len(data)):
                if temp_g == data[i][2] and temp_a == data[i][0]:
                    query = "update user_details set Password = '%s' where GMail_ID = '%s' and Aadhar = '%s';" % (new_p, temp_g, temp_a)
                    cu.execute(query)
                    print()
                    print("Password changed successfully.")
                    loop = False
                    break
            else:
                print()
                print('Invalid G-Mail ID/Aadhar. Please try again.')
        elif choice_2 == 3:
            break
        else:
            print()
            print("Invalid choice. Please try again.")
    co.commit()


# Managing the Customer's Account
def ManageAccount(t_g, t_a):
    cu = co.cursor()
    cu.execute("use ABC_CBS;")
    loop = True
    while loop:
        print()
        print(
            "--------------------------------------------------------------------------------------------------------------")
        print("1. View Account Details")
        print("2. Deposit Money in Account")
        print("3. Change User Details")
        print("4. Exit")
        print(
            "--------------------------------------------------------------------------------------------------------------")
        print()
        choice_2 = int(input("Enter your choice: "))
        if choice_2 == 1:
            cu.execute("select * from user_details;")
            data = cu.fetchall()
            count = 0
            for i in range(len(data)):
                if t_g == data[i][2]:
                    count = count + 1
            for i in range(len(data)):
                if count == 1 and t_g == data[i][2]:
                    print()
                    print("Aadhar Number:", data[i][0])
                    print("Mobile Number:", data[i][1])
                    print("G-Mail ID:", data[i][2])
                    print("Name:", data[i][4])
                    print("Date Of Birth:", data[i][5])
                    print("Balance:", data[i][6])
                    break
                elif count > 1:
                    for i in range(len(data)):
                        if t_g == data[i][2] and t_a == data[i][0]:
                            print()
                            print("Aadhar Number:", data[i][0])
                            print("Mobile Number:", data[i][1])
                            print("G-Mail ID:", data[i][2])
                            print("Name:", data[i][4])
                            print("Date Of Birth:", data[i][5])
                            print("Balance:", data[i][6])
                            break
                    break
        elif choice_2 == 2:
            print()
            money = float(input("Please the enter amount you want to deposit: "))
            if t_a:
                pass
            else:
                t_a = int(input("Please enter your Aadhar Number: "))
            cu.execute("select * from user_details")
            data = cu.fetchall()
            count = 0
            for i in range(len(data)):
                if t_g == data[i][2]:
                    count = count + 1
            for i in range(len(data)):
                if count == 1 and t_g == data[i][2]:
                    query = "update user_details set Balance = Balance + %s where GMail_ID = '%s' and Aadhar = %s" % (money, t_g, t_a)
                    cu.execute(query)
                    print()
                    print(money, "deposited.")
                    break
                elif count > 1:
                    for i in range(len(data)):
                        if t_g == data[i][2] and t_a == data[i][0]:
                            query = "update user_details set Balance = Balance + %s where GMail_ID = '%s' and Aadhar = %s" % (money, t_g, t_a)
                            cu.execute(query)
                            print()
                            print(money, "deposited.")
                            break
                    break
            co.commit()
        elif choice_2 == 3:
            print()
            print("--------------------------------------------------------------------------------------------------------------")
            print("1. Change G-Mail ID")
            print("2. Change Mobile Number")
            print("3. Change Password")
            print("4. Go back to Main Menu")
            print("--------------------------------------------------------------------------------------------------------------")
            print()

            choice_3 = int(input("Enter your choice: "))
            if choice_3 == 1:
                ChangeGMail(t_g)
                logged_in = False
                loop = False
            elif choice_3 == 2:
                ChangeMobile(t_g)
                logged_in = False
                loop = False
            elif choice_3 == 3:
                ChangePassword()
                logged_in = False
                loop = False
            elif choice_3 == 4:
                continue

        elif choice_2 == 4:
            loop = False
        else:
            print()
            print("Invalid choice. Please try again. ")

    co.commit()


# OTP Verification
def OTPVerification(mail):
    from email.mime.multipart import MIMEMultipart
    from email.mime.text import MIMEText
    import random
    import smtplib as smtp

    smtp = smtp.SMTP('smtp.gmail.com', 587)
    smtp.starttls()
    smtp.login('abcbank2022.3@gmail.com', 'nsiruyegnabfpawh')
    otp = random.randrange(100000, 999999)

    body = '''
Hello Customer, <br>
<br>
               Greetings from ABC Bank. Your One Time Password(OTP) for Verification is given below.
<br>               
<br>
OTP is %s
    ''' % otp

    message = MIMEMultipart()
    message['To'] = mail
    message['From'] = "abcbank2022.3@gmail.com"
    message['Subject'] = '''OTP Verification'''
    html_body = MIMEText(body, 'html')
    message.attach(html_body)

    smtp.sendmail('abcbank2022.3@gmail.com', mail, message.as_string())

    print()
    print("OTP sent. Please check your mail.")
    print()
    iotp = int(input("Please enter the OTP sent in the given email: "))
    if iotp == otp:
        return True
    else:
        return False


print()
print("Welcome to ABC Bank, choose one of the options to get started:")
print()

while True:
    print('''--------------------------------------------------------------------------------------------------------------
1. Create an Account
2. Log into an existing Account
3. Forgot Password
4. Exit
--------------------------------------------------------------------------------------------------------------
    ''')
    choice = int(input("Enter your choice: "))
    if choice == 1:
        CreateAccount()
    elif choice == 2:
        LoginAccount()
    elif choice == 3:
        ChangePassword()
    elif choice == 4:
        break
    else:
        print()
        print("Invalid choice. Please select again:")
        print()

print()
print("Thank You for visiting ABC Bank, please come again!")
print()