Breaking News: Grepper is joining You.com. Read the official announcement!

bank management system in python that will allow the admin to delete the user's account and also view them

Stupid Snake answered on November 12, 2023 Popularity 1/10 Helpfulness 1/10

answer bank management system in python that will allow the admin to delete the user's account and also view them

bank management system in python that will allow the admin to delete the user's account and also view them

Comment

import sqlite3
from tkinter import Tk, Label, Listbox, Scrollbar, Button, Entry, messagebox, Text, END

# Database connection
conn = sqlite3.connect("bank_database.db")
cursor = conn.cursor()

# Create a table for user accounts if it doesn't exist
cursor.execute('''
    CREATE TABLE IF NOT EXISTS user_accounts (
        account_number INTEGER PRIMARY KEY,
        account_holder TEXT,
        balance REAL
    )
''')

# Tkinter setup
root = Tk()
root.title("Bank Management System")

# Function to fetch and display user accounts
def display_user_accounts():
    # Clear existing data in the Listbox
    user_accounts_listbox.delete(0, END)

    # Fetch user accounts from the database
    cursor.execute("SELECT * FROM user_accounts")
    user_accounts = cursor.fetchall()

    # Display user accounts in the Listbox
    for account in user_accounts:
        user_accounts_listbox.insert(END, f"{account[0]} - {account[1]} - ${account[2]}")

# Function to handle account deletion
def delete_account():
    account_number_to_delete = entry_account_number.get()

    # Check if the account number is empty
    if not account_number_to_delete:
        messagebox.showwarning("Warning", "Please enter an account number.")
        return

    # Ask for confirmation before deleting the account
    confirmation = messagebox.askyesno("Confirmation", f"Do you want to delete the account with number {account_number_to_delete}?")
    
    if confirmation:
        # Delete the user account from the database based on the account number
        cursor.execute("DELETE FROM user_accounts WHERE account_number=?", (account_number_to_delete,))
        conn.commit()

        # Display a message in the Text widget
        update_output(f"Deleted account with number: {account_number_to_delete}")

        # Refresh the displayed user accounts
        display_user_accounts()

# Function to update the Text widget
def update_output(message):
    output_text.insert(END, message + "\n")
    output_text.see(END)  # Scroll to the end to show the latest message

# Labels
Label(root, text="User Accounts").pack()

# Listbox to display user accounts
user_accounts_listbox = Listbox(root, height=10, width=50)
user_accounts_listbox.pack()

# Scrollbar for the Listbox
scrollbar = Scrollbar(root)
scrollbar.pack(side="right", fill="y")

# Configure Listbox to work with the Scrollbar
user_accounts_listbox.config(yscrollcommand=scrollbar.set)
scrollbar.config(command=user_accounts_listbox.yview)

# Button to refresh and display user accounts
refresh_button = Button(root, text="Refresh", command=display_user_accounts)
refresh_button.pack()

# Entry widget to input account number for deletion
Label(root, text="Enter Account Number to Delete:").pack()
entry_account_number = Entry(root)
entry_account_number.pack()

# Button to delete user account based on account number
delete_account_button = Button(root, text="Delete Account", command=delete_account)
delete_account_button.pack()

# Output Text Widget
Label(root, text="Admin Actions Log").pack()
output_text = Text(root, height=5, width=50)
output_text.pack()

# Initial display of user accounts
display_user_accounts()

# Run Tkinter event loop
root.mainloop()

# Close the database connection when done
conn.close()

Popularity 1/10 Helpfulness 1/10 Language python

Source: chat.openai.com

Tags: account admin bank python system view

Link to this answer
Share Copy Link

Contributed on Nov 12 2023

Stupid Snake

0 Answers Avg Quality 2/10

bank management system in python that will allow the admin to delete the user's account and also view them

Contents

More Related Answers

bank management system in python that will allow the admin to delete the user's account and also view them

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.