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()