def login_backend(self):
try:
self.database = MyDb()
self.choose = Choose()
userna = self.un_ent.get()
passw = self.ps_ent.get()
if userna == '' or passw == '':
messagebox.showerror("error",
"enter username or password first!")
else:
qry = '''select * from registration where username=%s and password=%s'''
values = (userna, passw)
user = self.database.get_data_p(qry, values)
if len(user) == 1:
messagebox.showinfo("Bomm", "Login successfull")
self.choose.window3()
# return True
else:
messagebox.showerror("Error", "Wrong password or username")
# return False
except Exception as e:
print(e)
def add_bus(self, bus_number, bus_company, driver_name, driver_contact,
total_seat, route, dep_time):
try:
self.database = MyDb()
# bus_number = self.ent_bn.get()
# bus_company = self.bc_ent.get()
# driver_name = self.dn_ent.get()
# driver_contact = self.dc_ent.get()
# total_seat = self.ts_ent.get()
# route = self.r_ent.get()
# dep_time = self.dt_ent.get()
if bus_number == '' or bus_company == '' or driver_name == '' or driver_contact == '' or total_seat == '' or route == '' or dep_time == '':
# messagebox.showerror('Error', ' Enter each boxes carefully!')
return False
else:
qry = '''insert into bus_register (bus_number, bus_company, driver_name, driver_contact, total_seat, route,dep_time) values(%s,%s,%s,%s,%s,%s,%s)'''
values = (bus_number, bus_company, driver_name, driver_contact,
total_seat, route, dep_time)
self.database.iud(qry, values)
# messagebox.showinfo('Done', 'Added bus successfully!')
self.treeview_method()
return True
except Exception as e:
print(e)
return False
def by_time(self, keyword):
try:
self.database = MyDb()
qry = "SELECT * FROM bus_register WHERE dep_time LIKE '" + keyword + "%'"
result = self.database.get_data(qry)
return result
except Exception as e:
print(e)
def data_treeview(self):
try:
self.database = MyDb()
qry = '''select * from bus_register '''
bus = self.database.get_data(qry)
return bus
except Exception as e:
print(e)
def getting(self):
try:
self.database = MyDb()
first_name = self.ent_name.get()
last_name = self.ent_ls.get()
username = self.ent_un.get()
password = self.ent_ps.get()
phone = self.ent_pn.get()
address = self.ent_ad.get()
if first_name == '' or last_name == '' or username == '' or password == '' or phone == '' or address == '':
messagebox.showerror('Error', ' Enter each boxes carefully!')
# return False
else:
qry = '''insert into registration (username,password,firstname,lastname,address,phone) values(%s,%s,%s,%s,%s,%s)'''
values = (username, password, first_name, last_name, address,
phone)
self.database.iud(qry, values)
messagebox.showinfo('Done', ' Registered successfully!')
# return True
except Exception as e:
print(e)
def __init__(self):
self.reg()
# self.mainsc()
self.choose = Choose()
self.database = MyDb()
def __init__(self):
self.booking()
self.database = MyDb()
def __init__(self):
self.update_index = ''
self.database = MyDb()