def ins(movname1, descr1, cast1, poster1, RatingSpinbox1, ageratingcombo, genrecombo ):
movname=movname1.get()
descr=descr1.get()
rating=RatingSpinbox1.get()
cast=cast1.get()
age_rating=ageratingcombo.get()
poster=poster1.get()
genre=genrecombo.get()
print(movname,descr,rating,cast,age_rating,poster,genre)
if(len(movname)!=0 and len(descr)!=0 and len(rating)!=0 and len(cast)!=0 and len(age_rating)!=0 and len(genre)!=0 and len(poster)!=0):
try:
t=querys(movname, descr, rating, cast, age_rating, genre, poster)
if(t==1):
messagebox.showinfo("Sucess", "Registration successfull")
root.withdraw()
adhome.create_AdHome(root)
else:
messagebox.showerror("UnSucess", "Registration Unsuccessfull")
except Exception as e: print(e)
else:
messagebox.showerror("Error", "Fields cannot be empty")
root.destroy()
adhome.vp_start_guih()
def sub(slotid, top):
global fin
flag = 0
chkM = 1
if (len(fin) == 0):
messagebox.showerror("Error", "No Seats selected")
else:
for i in fin:
if (i[1] == 'i'):
i[1] = 'v'
if (quer(slotid, i[0], i[1])):
flag = 1
else:
flag = 0
if flag == 1:
sts = ''
for i in range(len(fin)):
if i == 0:
sts += str(fin[i][2])
else:
sts += "," + str(fin[i][2])
st = "Seats Modified successfully\n Seat number : " + sts
messagebox.showinfo("Sucess", st)
top.destroy()
adhome.vp_start_guih()
def dele(top,movieid):
q=queryd("Delete from moviedet where movie_id={0}".format(movieid))
if q==1:
messagebox.showinfo("Success","movie deleted successfully")
top.destroy()
adhome.vp_start_guih()
else:
messagebox.showerror("Failure","Movie ALready running in theatres please delete it slots instance")
top.destroy()
adhome.vp_start_guih()
def delete_user(user):
tname=user.get()
try:
print("Delete FROM user where email='{0}'".format(tname))
q=query("Delete FROM User where email='{0}'".format(tname))
print(q)
except Exception as e:
print(e)
messagebox.showerror("Failed", "Could not Delete the user")
root.destroy()
adhome.vp_start_guih()
def ins(theater_name1, time1, showdate1, cost1, movieid):
print(theater_name1, time1, showdate1, cost1)
theater_name = theater_name1.get()
time = time1.get()
showdate = showdate1.get_date()
cost = cost1.get()
if (len(theater_name) != 0 and len(time) != 0 and len(str(showdate)) != 0
and len(cost) != 0):
regex = "^([01]?[0-9]|2[0-3]):[0-5][0-9]$"
pattern = re.compile(regex)
print(time)
print(re.search(pattern, str(time)))
if pattern.search(time):
try:
cost = int(cost)
try:
result = querys2(theater_name)
if result:
theater_id, capacity = result
movie_id = movieid
t, slot_id = querys(theater_id, time, showdate,
str(cost), movie_id)
if t == 1:
z = seats(slot_id, capacity)
else:
messagebox.showerror("Error",
"Could not add a slot")
if (t == 1):
messagebox.showinfo("Success",
"Show Creation successfull")
root.destroy()
adhome.vp_start_guih()
else:
messagebox.showerror(
"UnSucess", "Show Creation Unsuccessfull")
else:
messagebox.showerror("Error",
"Could not find that Theater")
except Exception as e:
print(e)
except Exception as e:
print(e)
messagebox.showerror("UnSucess", "Enter a number in cost")
else:
messagebox.showerror("Error", "time has to be in hh:mm format")
else:
messagebox.showerror("Error", "Fields cannot be empty")
def back(top):
top.destroy()
adhome.vp_start_guih()