def search_in_database():
def back_page2():
search_frame.grid_forget()
page2()
global result
global acc_no
acc_no = entry11.get()
r = check_string_in_account_no(acc_no)
if len(acc_no) != 0 and r:
result = backend.check_acc_no(acc_no)
print(result)
if not result:
label = Label(search_frame, text="invalid account number")
label.grid(pady=2)
button = Button(search_frame, text="Exit", command=back_page2)
button.grid()
mainloop()
else:
backend.delete_acc(acc_no)
search_frame.grid_forget()
page2()
else:
label = Label(search_frame, text="Enter correct account number")
label.grid(pady=2)
button = Button(search_frame, text="Exit", command=back_page2)
button.grid()
def search_in_database():
def back_page2():
search_frame.grid_forget()
page2()
global result
global acc_no
acc_no = entry11.get()
r=check_string_in_account_no(acc_no)
if len(acc_no)!=0 and r:
result = backend.check_acc_no(acc_no)
print(result)
if not result:
label = Label(search_frame, text="invalid account number")
label.grid(pady=2)
button = Button(search_frame, text="Exit", command=back_page2)
button.grid()
mainloop()
else:
backend.delete_acc(acc_no)
search_frame.grid_forget()
page2()
else:
label = Label(search_frame, text="Enter correct account number")
label.grid(pady=2)
button = Button(search_frame, text="Exit", command=back_page2)
button.grid()
def search_in_database():
def back_page2():
search_frame.grid_forget()
page2()
global result
global acc_no
acc_no = entry11.get()
r = check_string_in_account_no(acc_no)
if len(acc_no) != 0 and r:
result = backend.check_acc_no(acc_no)
print(result)
if not result:
label = Label(search_frame, text="invalid account number")
label.grid(pady=2)
button = Button(search_frame, text="Exit", command=back_page2)
button.grid()
mainloop()
else:
def update_money():
new_money = entry12.get()
backend.update_balance(new_money, acc_no)
add_frame.grid_forget()
page2()
search_frame.grid_forget()
global add_frame
add_frame = Frame(tk)
add_frame.grid(padx=400, pady=300)
detail = backend.get_detail(acc_no)
label = Label(add_frame,
text='Account holder name: {}'.format(
detail[0][0]))
label.grid(row=0, pady=3)
label = Label(add_frame,
text='Current amount: {}'.format(detail[0][1]))
label.grid(row=1, pady=3)
label = Label(add_frame, text='Enter Money')
label.grid(row=2, pady=3)
global entry12
entry12 = Entry(add_frame)
entry12.grid(row=3, pady=3)
button = Button(add_frame, text='Add', command=update_money)
button.grid(row=4)
mainloop()
else:
label = Label(search_frame, text="Enter correct account number")
label.grid(pady=2)
button = Button(search_frame, text="Exit", command=back_page2)
button.grid()
mainloop()
def search_in_database():
def back_page2():
search_frame.grid_forget()
page2()
global result
global acc_no
acc_no = entry11.get()
r=check_string_in_account_no(acc_no)
if len(acc_no)!=0 and r:
result = backend.check_acc_no(acc_no)
print(result)
if not result:
label = Label(search_frame, text="invalid account number")
label.grid(pady=2)
button=Button(search_frame, text="Exit",command=back_page2)
button.grid()
mainloop()
else:
def update_money():
new_money=entry12.get()
backend.update_balance(new_money,acc_no)
add_frame.grid_forget()
page2()
search_frame.grid_forget()
global add_frame
add_frame=Frame(tk)
add_frame.grid(padx=400,pady=300)
detail = backend.get_detail(acc_no)
label = Label(add_frame, text='Account holder name: {}'.format(detail[0][0]))
label.grid(row=0, pady=3)
label = Label(add_frame, text='Current amount: {}'.format(detail[0][1]))
label.grid(row=1, pady=3)
label=Label(add_frame,text='Enter Money')
label.grid(row=2,pady=3)
global entry12
entry12=Entry(add_frame)
entry12.grid(row=3,pady=3)
button=Button(add_frame,text='Add',command=update_money)
button.grid(row=4)
mainloop()
else:
label = Label(search_frame, text="Enter correct account number")
label.grid(pady=2)
button = Button(search_frame, text="Exit", command=back_page2)
button.grid()
mainloop()
def search_in_database():
def back_page2():
search_frame.grid_forget()
page2()
global result
global acc_no
acc_no = entry11.get()
r = check_string_in_account_no(acc_no)
if len(acc_no) != 0 and r:
result = backend.check_acc_no(acc_no)
print(result)
if not result:
label = Label(search_frame, text="invalid account number")
label.grid(pady=2)
button = Button(search_frame, text="Exit", command=back_page2)
button.grid()
mainloop()
else:
def delete_check_frame():
check_frame.grid_forget()
page2()
search_frame.grid_forget()
balance = backend.check_balance(acc_no)
global check_frame
check_frame = Frame(tk)
check_frame.grid(padx=500, pady=300)
label = Label(check_frame,
text="Balance Is:{}".format(balance),
font="bold")
label.grid(row=0, pady=4)
button = Button(
check_frame,
text="Back",
command=delete_check_frame,
width=20,
height=2,
bg="red",
)
button.grid(row=1)
mainloop()
else:
label = Label(search_frame, text="Enter correct entry")
label.grid(pady=2)
button = Button(search_frame, text="Exit", command=back_page2)
button.grid()
mainloop()
def search_in_database():
def back_page2():
search_frame.grid_forget()
page2()
global result
global acc_no
acc_no = entry11.get()
r=check_string_in_account_no(acc_no)
if len(acc_no)!=0 and r:
result = backend.check_acc_no(acc_no)
print(result)
if not result:
label = Label(search_frame, text="invalid account number")
label.grid(pady=2)
button = Button(search_frame, text="Exit", command=back_page2)
button.grid()
mainloop()
else:
def delete_check_frame():
check_frame.grid_forget()
page2()
search_frame.grid_forget()
balance=backend.check_balance(acc_no)
global check_frame
check_frame=Frame(tk)
check_frame.grid(padx=500,pady=300)
label=Label(check_frame,text='Balance Is:{}'.format(balance),font='bold')
label.grid(row=0,pady=4)
button=Button(check_frame,text='Back',command=delete_check_frame,width=20,height=2,bg='red')
button.grid(row=1)
mainloop()
else:
label = Label(search_frame, text="Enter correct entry")
label.grid(pady=2)
button = Button(search_frame, text="Exit", command=back_page2)
button.grid()
mainloop()
def show_all_updateble_content():
def back_to_page2_from_update():
update_customer_frame.grid_forget()
page2()
# defining a function whose makes a update entry and submit butoon side to name button
def update_name():
# def a function eho updates name in database
def update_name_in_database():
new_name = entry_name.get()
r = check_string_in_account_no(new_name)
if len(new_name) != 0:
# function in backend that updates name in table
backend.update_name_in_bank_table(new_name, acc_no)
entry_name.destroy()
submit_button.destroy()
name_label.destroy()
else:
tkinter.messagebox.showinfo('Error', 'Please fill blanks')
entry_name.destroy()
submit_button.destroy()
name_label.destroy()
global entry_name
global name_label
name_label = Label(update_customer_frame, text='Enter new name')
name_label.grid(row=1, column=1)
entry_name = Entry(update_customer_frame)
entry_name.grid(row=1, column=2, padx=2)
global submit_button
submit_button = Button(update_customer_frame,
text='Update',
command=update_name_in_database)
submit_button.grid(row=1, column=3)
# defing a function who make gui fro age
def update_age():
# def a function eho updates name in database
def update_age_in_database():
new_age = entry_name.get()
r = check_string_in_account_no(new_age)
if len(new_age) != 0 and r:
# function in backend that updates name in table
backend.update_age_in_bank_table(new_age, acc_no)
entry_name.destroy()
submit_button.destroy()
age_label.destroy()
else:
tkinter.messagebox.showinfo('Error', 'Please enter age')
entry_name.destroy()
submit_button.destroy()
age_label.destroy()
global age_label
age_label = Label(update_customer_frame, text='Enter new Age:')
age_label.grid(row=2, column=1)
global entry_name
entry_name = Entry(update_customer_frame)
entry_name.grid(row=2, column=2, padx=2)
global submit_button
submit_button = Button(update_customer_frame,
text='Update',
command=update_age_in_database)
submit_button.grid(row=2, column=3)
# defing a function who make gui fro age
def update_address():
# def a function eho updates name in database
def update_address_in_database():
new_address = entry_name.get()
if len(new_address) != 0:
# function in backend that updates name in table
backend.update_address_in_bank_table(new_address, acc_no)
entry_name.destroy()
submit_button.destroy()
address_label.destroy()
else:
tkinter.messagebox.showinfo('Error', 'Please fill address')
entry_name.destroy()
submit_button.destroy()
address_label.destroy()
global address_label
address_label = Label(update_customer_frame,
text='Enter new Address:')
address_label.grid(row=3, column=1)
global entry_name
entry_name = Entry(update_customer_frame)
entry_name.grid(row=3, column=2, padx=2)
global submit_button
submit_button = Button(update_customer_frame,
text='Update',
command=update_address_in_database)
submit_button.grid(row=3, column=3)
acc_no = entry_acc.get()
r = check_string_in_account_no(acc_no)
if r:
result = backend.check_acc_no(acc_no)
if result:
search_frame.grid_forget()
global update_customer_frame
update_customer_frame = Frame(tk)
update_customer_frame.grid(padx=300, pady=300)
label = Label(update_customer_frame,
text='What do you want to update')
label.grid(row=0)
name_button = Button(update_customer_frame,
text='Name',
command=update_name)
name_button.grid(row=1, column=0, pady=6)
age_button = Button(update_customer_frame,
text='Age',
command=update_age)
age_button.grid(row=2, column=0, pady=6)
address_button = Button(update_customer_frame,
text='Address',
command=update_address)
address_button.grid(row=3, column=0, pady=6)
exit_button = Button(update_customer_frame,
text='Exit',
command=back_to_page2_from_update)
exit_button.grid(row=4)
mainloop()
else:
label = Label(search_frame, text='Invalid account number')
label.grid()
button = Button(search_frame,
text='Exit',
command=back_to_page2)
button.grid()
else:
label = Label(search_frame, text='Fill account number')
label.grid()
button = Button(search_frame, text='Exit', command=back_to_page2)
button.grid()
def show_all_updateble_content():
def back_to_page2_from_update():
update_customer_frame.grid_forget()
page2()
#defining a function whose makes a update entry and submit butoon side to name button
def update_name():
#def a function eho updates name in database
def update_name_in_database():
new_name=entry_name.get()
r=check_string_in_account_no(new_name)
if len(new_name)!=0:
#function in backend that updates name in table
backend.update_name_in_bank_table(new_name,acc_no)
entry_name.destroy()
submit_button.destroy()
name_label.destroy()
else:
tkinter.messagebox.showinfo('Error','Please fill blanks')
entry_name.destroy()
submit_button.destroy()
name_label.destroy()
global entry_name
global name_label
name_label=Label(update_customer_frame,text='Enter new name')
name_label.grid(row=1,column=1)
entry_name=Entry(update_customer_frame)
entry_name.grid(row=1,column=2,padx=2)
global submit_button
submit_button=Button(update_customer_frame,text='Update',command=update_name_in_database)
submit_button.grid(row=1,column=3)
#defing a function who make gui fro age
def update_age():
# def a function eho updates name in database
def update_age_in_database():
new_age = entry_name.get()
r=check_string_in_account_no(new_age)
if len(new_age)!=0 and r:
# function in backend that updates name in table
backend.update_age_in_bank_table(new_age, acc_no)
entry_name.destroy()
submit_button.destroy()
age_label.destroy()
else:
tkinter.messagebox.showinfo('Error','Please enter age')
entry_name.destroy()
submit_button.destroy()
age_label.destroy()
global age_label
age_label = Label(update_customer_frame, text='Enter new Age:')
age_label.grid(row=2, column=1)
global entry_name
entry_name = Entry(update_customer_frame)
entry_name.grid(row=2, column=2, padx=2)
global submit_button
submit_button = Button(update_customer_frame, text='Update', command=update_age_in_database)
submit_button.grid(row=2, column=3)
# defing a function who make gui fro age
def update_address():
# def a function eho updates name in database
def update_address_in_database():
new_address = entry_name.get()
if len(new_address)!=0:
# function in backend that updates name in table
backend.update_address_in_bank_table(new_address, acc_no)
entry_name.destroy()
submit_button.destroy()
address_label.destroy()
else:
tkinter.messagebox.showinfo('Error','Please fill address')
entry_name.destroy()
submit_button.destroy()
address_label.destroy()
global address_label
address_label = Label(update_customer_frame, text='Enter new Address:')
address_label.grid(row=3, column=1)
global entry_name
entry_name = Entry(update_customer_frame)
entry_name.grid(row=3, column=2, padx=2)
global submit_button
submit_button = Button(update_customer_frame, text='Update', command=update_address_in_database)
submit_button.grid(row=3, column=3)
acc_no=entry_acc.get()
r=check_string_in_account_no(acc_no)
if r:
result = backend.check_acc_no(acc_no)
if result:
search_frame.grid_forget()
global update_customer_frame
update_customer_frame=Frame(tk)
update_customer_frame.grid(padx=300,pady=300)
label=Label(update_customer_frame,text='What do you want to update')
label.grid(row=0)
name_button=Button(update_customer_frame,text='Name',command=update_name)
name_button.grid(row=1,column=0,pady=6)
age_button=Button(update_customer_frame,text='Age',command=update_age)
age_button.grid(row=2,column=0,pady=6)
address_button=Button(update_customer_frame,text='Address',command=update_address)
address_button.grid(row=3,column=0,pady=6)
exit_button=Button(update_customer_frame,text='Exit',command=back_to_page2_from_update)
exit_button.grid(row=4)
mainloop()
else:
label = Label(search_frame, text='Invalid account number')
label.grid()
button = Button(search_frame, text='Exit', command=back_to_page2)
button.grid()
else:
label=Label(search_frame,text='Fill account number')
label.grid()
button=Button(search_frame,text='Exit',command=back_to_page2)
button.grid()
