def addmon():
with open("Prem.csv","r") as f:
csb=DictReader(f)
for row in csb:
mong=int(row['amount'])
mon =int(enbug.get())
ms=tk.messagebox.askquestion('Add money',f'Are you sure you want to add {mon}rs to your budget? ')
if ms == 'yes':
with open("Prem.csv","w") as g:
csb=DictWriter(g,fieldnames=['name','amount'])
csb.writeheader()
csb.writerow({
'name': 'budget',
'amount': f"{mon+mong}"
})
tk.messagebox.showinfo('info',f"Now you budget has been {mon+mong}rs !")
global l
l.grid_forget()
with open("Prem.csv","r") as fh:
csb=DictReader(fh)
for row in csb:
mongn=row['amount']
l=ttk.Label(framebug,text=f"Your current budget ramain {mongn} rs...")
l.grid(row=5,column=0,pady=5)
enbug.delete(0,'end')
white = pair_result['whiteStartingRank']
black = pair_result['blackStartingRank']
players[white][round_num_op] = black
players[black][round_num_op] = white
players[white][round_color] = 'w'
players[black][round_color] = 'b'
players[white][round_result] = pair_result['whiteResult']
players[black][round_result] = pair_result['blackResult']
white_score_delta = score_delta(players[white][round_result],
reward_win=REWARD_WIN)
black_score_delta = score_delta(players[black][round_result],
reward_win=REWARD_WIN)
players[white]['points'] = \
float(players[white]['points']) + white_score_delta
players[black]['points'] = \
float(players[black]['points']) + black_score_delta
output_fields = ('startingrank', 'rating', 'name', 'membernumber',
'points')
for i in range(1, max_round_seen + 1):
output_fields = output_fields + \
('round%sop' % i, 'round%scolor' % i, 'round%sresult' % i)
with open(argv[3], 'w') as f:
d = DictWriter(f, output_fields)
d.writeheader()
d.writerows(players.values())
def action4():
con=mysql.connector.connect(host="localhost",user="******",password="",database="project")
mycursor=con.cursor()
if choice=="education":
name=namestu.get()
classs=classstu.get()
mycursor=con.cursor()
mycursor.execute(f"SELECT Fee from {databasen} where {en[0]}=\"{name}\" and {en[1]}=\"{classs}\" ")
stu=mycursor.fetchone()
if stu != None:
fee=str(stu[0])
if int(fee) == 0:
messagebox.showerror('Error','Full fee deposit for this student')
else:
mycursor=con.cursor()
with open("Prem.csv",'r') as f:
csv=DictReader(f)
for row in csv:
if classs==row['class']:
mon=row['fee']
if int(money.get()) <= int(mon):
mycursor.execute(f"UPDATE {databasen} SET Fee={int(fee)-max(0,int(money.get()))} where {en[0]}=\"{name}\" AND {en[1]}=\"{classs}\" ")
else:
mycursor.execute(f"UPDATE {databasen} SET Fee=0 where {en[0]}=\"{name}\" AND {en[1]}=\"{classs}\" ")
messagebox.showinfo('Info',f'you have to return {int(money.get())-int(mon)} rupees to customer')
messagebox.showinfo('Info','fee deposit')
entryfee1.delete(0,"end")
entryfee2.delete(0,"end")
entryfee3.delete(0,"end")
else:
messagebox.showerror('Error','Name/class is not found in database')
if choice == 'housework':
nam=nmofc.get()
mycursor=con.cursor()
mycursor.execute(f"SELECT {en[1]},Payment_done from {databasen} where {en[0]}=\"{nam}\" ")
stu=mycursor.fetchone()
if stu != None:
if int(stu[0]) == 0:
messagebox.showerror('Error','Full bill paid')
else:
mycursor=con.cursor()
mon=money.get()
with open('Prem.csv','r') as f:
csb=DictReader(f)
for row in csb:
bud=row['amount']
if int(bud)<int(mon) or int(bud) == 0:
messagebox.showwarning('Warning','You have not sufficient budget')
return(0)
if int(mon) <= int(stu[0]):
mycursor=con.cursor()
mycursor.execute(f"UPDATE {databasen} SET {en[1]}=\"{str(int(stu[0])-max(0,int(mon)))}\" where {en[0]}=\"{nam}\" ")
mycursor=con.cursor()
mycursor.execute(f"UPDATE {databasen} SET Payment_done=\"{str(int(stu[1])+max(0,int(mon)))}\" where {en[0]}=\"{nam}\" ")
pay=int(bud)-int(mon)
else:
mycursor.execute(f"UPDATE {databasen} SET {en[1]}=\"0\" where {en[0]}=\"{nam}\"")
mycursor=con.cursor()
mycursor.execute(f"UPDATE {databasen} SET Payment_done=\"{str(int(stu[1])+max(0,int(mon)))}\" where {en[0]}=\"{nam}\" ")
messagebox.showinfo('Info',f'you are paying {int(mon)-int(stu[0])} rs more')
pay=int(bud)-int(stu[0])
with open('Prem.csv','w',newline="") as f:
csb=DictWriter(f,fieldnames=['name','amount'])
csb.writeheader()
csb.writerow({
'name':'budget',
'amount':pay
})
messagebox.showinfo('Info',f'Amount paid to {nam.upper()}')
nmofc.delete(0,"end")
entryfee3.delete(0,"end")
else:
messagebox.showerror('Error','Data is not found in database')
con.commit()
players[white][round_result] = pair_result['whiteResult']
players[black][round_result] = pair_result['blackResult']
white_score_delta = score_delta(players[white][round_result],
reward_win=REWARD_WIN)
black_score_delta = score_delta(players[black][round_result],
reward_win=REWARD_WIN)
players[white]['points'] = \
float(players[white]['points']) + white_score_delta
players[black]['points'] = \
float(players[black]['points']) + black_score_delta
output_fields = ('startingrank', 'rating',
'name', 'membernumber', 'points'
)
for i in range(1, max_round_seen+1):
output_fields = output_fields + \
('round%sop' % i, 'round%scolor' % i, 'round%sresult' % i)
with open(argv[3], 'w') as f:
d = DictWriter(
f,
output_fields
)
d.writeheader()
d.writerows(players.values())
