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