def __init__(self, master, **kwargs):
self.master = master
tk.Frame.__init__(self, self.master, **kwargs)
deposit_window = tk.Toplevel(self.master)
self.sql_obj = Customer(**kwargs)
deposit_window.title("deposit box")
deposit_window.geometry("400x150")
Label(deposit_window, text="ID number for deposit: ").grid(row=0,
column=0)
id_field = Entry(deposit_window,
bg='light gray',
width=30,
bd=2,
selectborderwidth=5)
id_field.grid(row=0, column=3)
Label(deposit_window, text="How many sheets: ").grid(row=1, column=0)
sheet_field = Entry(deposit_window,
bg='light gray',
width=30,
bd=2,
selectborderwidth=5)
sheet_field.grid(row=1, column=3)
account_deposit_action_with_arg = partial(self.deposit, id_field,
sheet_field)
Button(deposit_window,
text='Deposit',
command=account_deposit_action_with_arg).place(x=10, y=60)
def __init__(self, master, **kwargs):
self.master = master
tk.Frame.__init__(self, self.master, **kwargs)
show_window = tk.Toplevel(self.master)
self.sql_obj = Customer(**kwargs)
show_window.title("show box")
list_name = self.sql_obj.show()
Label(show_window, text=list_name).grid()
class WithdrawForm(tk.Frame):
def __init__(self, master, **kwargs):
self.master = master
tk.Frame.__init__(self, self.master, **kwargs)
withdraw_window = tk.Toplevel(self.master)
self.sql_obj = Customer(**kwargs)
withdraw_window.title("dump box")
withdraw_window.geometry("400x150")
Label(withdraw_window, text="ID number for withdraw: ").grid(row=0,
column=0)
id_field = Entry(withdraw_window,
bg='light gray',
width=30,
bd=2,
selectborderwidth=5)
id_field.grid(row=0, column=3)
account_withdraw_action_with_arg = partial(self.withdraw, id_field)
Button(withdraw_window,
text="withdraw",
command=account_withdraw_action_with_arg).place(x=10, y=60)
def withdraw(self, id_field):
id_search = id_field.get()
if self.sql_obj.withdraw(id_search):
showinfo("notification box", "successfully operation")
else:
showinfo("notification box",
"failed operation because customer not found ")
def __init__(self, master, **kwargs):
self.master = master
tk.Frame.__init__(self, self.master, **kwargs)
withdraw_window = tk.Toplevel(self.master)
self.sql_obj = Customer(**kwargs)
withdraw_window.title("dump box")
withdraw_window.geometry("400x150")
Label(withdraw_window, text="ID number for withdraw: ").grid(row=0,
column=0)
id_field = Entry(withdraw_window,
bg='light gray',
width=30,
bd=2,
selectborderwidth=5)
id_field.grid(row=0, column=3)
account_withdraw_action_with_arg = partial(self.withdraw, id_field)
Button(withdraw_window,
text="withdraw",
command=account_withdraw_action_with_arg).place(x=10, y=60)
class DumpForm(tk.Frame):
def __init__(self, master, **kwargs):
self.master = master
tk.Frame.__init__(self, self.master, **kwargs)
dump_window = tk.Toplevel(self.master)
self.sql_obj = Customer(**kwargs)
dump_window.title("dump box")
dump_window.geometry("400x150")
Label(dump_window, text="ID number for dump: ").grid(row=0, column=0)
id_field = Entry(dump_window,
bg='light gray',
width=30,
bd=2,
selectborderwidth=5)
id_field.grid(row=0, column=3)
Label(dump_window, text="How many sheets: ").grid(row=1, column=0)
sheet_field = Entry(dump_window,
bg='light gray',
width=30,
bd=2,
selectborderwidth=5)
sheet_field.grid(row=1, column=3)
account_dump_action_with_arg = partial(self.dump, id_field,
sheet_field)
Button(dump_window, text="Dump",
command=account_dump_action_with_arg).place(x=10, y=60)
def dump(self, id_field, sheet_field):
sheet = sheet_field.get()
sheet = int(sheet)
id_search = id_field.get()
if self.sql_obj.open_search(id_search):
intended_data = self.sql_obj.open_search(id_search)
if self.sql_obj.sub_sheets(intended_data, id_search, sheet):
showinfo("notification box", "successfully operation")
else:
showinfo("notification box",
"failed operation because not enough money ")
else:
showinfo("notification box",
"failed operation because customer not found ")
def __init__(self, **kwargs):
self.master = tk.Tk()
self.master.geometry("400x200")
self.master.title("Operation Box")
self.sql_obj = Customer(**kwargs)
self.name_field = Entry(self.master,
bg='light gray',
width=30,
bd=2,
selectborderwidth=5)
self.name_field.grid(row=0, column=3)
self.last_name_field = Entry(self.master,
bg='light gray',
width=30,
bd=2,
selectborderwidth=5)
self.last_name_field.grid(row=1, column=3)
self.id_field = Entry(self.master,
bg='light gray',
width=30,
bd=2,
selectborderwidth=5)
self.id_field.grid(row=2, column=3)
self.account_number_field = Entry(self.master,
bg='light gray',
width=30,
bd=2,
selectborderwidth=5)
self.account_number_field.grid(row=3, column=3)
self.supply_field = Entry(self.master,
bg='light gray',
width=30,
bd=2,
selectborderwidth=5)
self.supply_field.grid(row=4, column=3)
name_label = Label(self.master, text="Name: ")
name_label.grid(row=0, column=0, sticky=W)
last_name_label = Label(self.master, text="LastName: ")
last_name_label.grid(row=1, column=0, sticky=W)
id_label = Label(self.master, text="ID Num: ")
id_label.grid(row=2, column=0, sticky=W)
account_number_label = Label(self.master, text="Bank Account Number: ")
account_number_label.grid(row=3, column=0, sticky=W)
supply_label = Label(self.master, text="supply: ")
supply_label.grid(row=4, column=0, sticky=W)
create_add_window_action_with_arg = partial(
self.add_button, self.name_field, self.last_name_field,
self.id_field, self.account_number_field, self.supply_field)
Button(self.master,
text='Add',
command=create_add_window_action_with_arg).place(x=10, y=145)
create_deposit_window_action_with_arg = partial(
create_deposit_window, self.master)
Button(self.master,
text='Deposit',
command=create_deposit_window_action_with_arg).place(x=45,
y=145)
create_dump_window_action_with_arg = partial(create_dump_window,
self.master)
Button(self.master,
text='Dump',
command=create_dump_window_action_with_arg).place(x=98, y=145)
create_withdraw_window_action_with_arg = partial(
create_withdraw_window, self.master)
Button(self.master,
text="Withdraw",
command=create_withdraw_window_action_with_arg).place(x=143,
y=145)
create_show_window_action_with_arg = partial(create_show_list,
self.master)
Button(self.master,
text="Show",
command=create_show_window_action_with_arg).place(x=207, y=145)
class MainGUI:
def __init__(self, **kwargs):
self.master = tk.Tk()
self.master.geometry("400x200")
self.master.title("Operation Box")
self.sql_obj = Customer(**kwargs)
self.name_field = Entry(self.master,
bg='light gray',
width=30,
bd=2,
selectborderwidth=5)
self.name_field.grid(row=0, column=3)
self.last_name_field = Entry(self.master,
bg='light gray',
width=30,
bd=2,
selectborderwidth=5)
self.last_name_field.grid(row=1, column=3)
self.id_field = Entry(self.master,
bg='light gray',
width=30,
bd=2,
selectborderwidth=5)
self.id_field.grid(row=2, column=3)
self.account_number_field = Entry(self.master,
bg='light gray',
width=30,
bd=2,
selectborderwidth=5)
self.account_number_field.grid(row=3, column=3)
self.supply_field = Entry(self.master,
bg='light gray',
width=30,
bd=2,
selectborderwidth=5)
self.supply_field.grid(row=4, column=3)
name_label = Label(self.master, text="Name: ")
name_label.grid(row=0, column=0, sticky=W)
last_name_label = Label(self.master, text="LastName: ")
last_name_label.grid(row=1, column=0, sticky=W)
id_label = Label(self.master, text="ID Num: ")
id_label.grid(row=2, column=0, sticky=W)
account_number_label = Label(self.master, text="Bank Account Number: ")
account_number_label.grid(row=3, column=0, sticky=W)
supply_label = Label(self.master, text="supply: ")
supply_label.grid(row=4, column=0, sticky=W)
create_add_window_action_with_arg = partial(
self.add_button, self.name_field, self.last_name_field,
self.id_field, self.account_number_field, self.supply_field)
Button(self.master,
text='Add',
command=create_add_window_action_with_arg).place(x=10, y=145)
create_deposit_window_action_with_arg = partial(
create_deposit_window, self.master)
Button(self.master,
text='Deposit',
command=create_deposit_window_action_with_arg).place(x=45,
y=145)
create_dump_window_action_with_arg = partial(create_dump_window,
self.master)
Button(self.master,
text='Dump',
command=create_dump_window_action_with_arg).place(x=98, y=145)
create_withdraw_window_action_with_arg = partial(
create_withdraw_window, self.master)
Button(self.master,
text="Withdraw",
command=create_withdraw_window_action_with_arg).place(x=143,
y=145)
create_show_window_action_with_arg = partial(create_show_list,
self.master)
Button(self.master,
text="Show",
command=create_show_window_action_with_arg).place(x=207, y=145)
def add_button(self, name_field, last_name_field, id_field,
bank_account_field, supply_field):
try:
id_field = int(id_field.get())
except ValueError:
showinfo("notification box",
"please input true data type and enter ID number again")
try:
name_field = str(name_field.get())
except ValueError:
showinfo("notification box",
"please input true data type and enter name again")
try:
last_name_field = str(last_name_field.get())
except ValueError:
showinfo("notification box",
"please input true data type and enter lastname again")
try:
bank_account_field = int(bank_account_field.get())
except ValueError:
showinfo(
"notification box",
"please input true data type and enter bank account number again "
)
try:
supply_field = int(supply_field.get())
except ValueError:
showinfo("notification box",
"please input true data type and enter supply again")
# data_list=[id_field,name_field,last_name_field,bank_account_field,supply_field]
if self.sql_obj.insert_table(id_field, name_field, last_name_field,
bank_account_field, supply_field):
showinfo("notification box", "customer adding successfully")
else:
showinfo("notification box", "customer existe ago")