def reg_student(name, password, cpassword, email): #return 1 if passwords not equal error if password != cpassword: return 1 if '@' not in email: return 2 for r in adb.view_student_t(): #students cant have same email if email == r[4]: return 4 else: adb.add_student(name, password, email) return False
def Add_client(self): c = 1 d = 1 while c != 0: fio = self.FIO_line.text() c = database.try_get_fio(fio) if c == 1: self.FIO_line.clear() break passport = self.serial_line.text() + self.number_line.text() address = self.addres_line.text() phone = self.phone_line.text() educ_form = self.FormBox.currentText() sex = self.SexBox.currentText() #hostel = self.hostel_line.text() hostel = self.HostelNumber.currentText() room = 'queue' if c == 0: database.add_student(fio, phone, passport, address, educ_form, sex, hostel) # if d == 0: # database.add_student_buffer(key,fio, phone, passport, address, educ_form, sex,room,hostel) # # from add_contract import Ui_add_contract # # self.window = QtWidgets.QMainWindow() # # self.ui = Ui_add_contract() # # self.ui.setupUi(self.window) # # self.window.show() # else: # from error_hostel import Ui_Error # self.window = QtWidgets.QMainWindow() # self.ui = Ui_Error() # self.ui.setupUi(self.window) # self.window.show() else: from error import Ui_Error self.window = QtWidgets.QMainWindow() self.ui = Ui_Error() self.ui.setupUi(self.window) self.window.show() self.FIO_line.clear() self.serial_line.clear() self.number_line.clear() self.addres_line.clear() self.phone_line.clear() self.HostelNumber.setCurrentIndex(0) self.FormBox.setCurrentIndex(-1) self.SexBox.setCurrentIndex(-1)
def register(): if session.has_key('user'): session.pop('user') if request.method=="GET": return render_template("register.html", loggedout=True) elif request.method=='POST': if request.form['button']=='Register': username=request.form['username'] password=request.form['password'] osis=request.form['osis'] digit=request.form['digit'] name=request.form['name'] email=request.form['email'] lunch=request.form['lunch'] exist=database.add_student(username,password) if exist: return render_template("register.html",loggedout=True,exists=exist) database.set_osis(username,osis) database.set_id(username,digit) database.set_name(username,name) database.set_email(username,email) database.set_period(username, int(lunch), [str(lunch), "Cafe", "Chi Kun Wang", "ZLN5", "0"+str(lunch)]) return redirect(url_for("profile")) return redirect(url_for("register"))
def reg_student(name, password, cpassword, email): #return 1 if passwords not equal error if password != cpassword: return 1 if '@' not in email: return 2 for r in adb.view_company_t(): #students cant have same email if email == r[4]: return 4 else: adb.add_student(name, password, email) return False
def add_student_pro(): # 파라미터 데이터 추출한다. stu_name = request.form['stu_name'] stu_age = request.form['stu_age'] stu_addr = request.form['stu_addr'] # print(f'{stu_name} {stu_age} {stu_addr}') # 저장한다. idx = db.add_student(stu_name, stu_age, stu_addr) result_dic = {'stu_idx': idx} html = render_template('add_student_pro.html', data_dic=result_dic) return html
def Add_client_contract(self): c = 1 d = 1 while c != 0: fio = self.FIO_line.text() c = database.try_get_fio(fio) if c == 1: self.FIO_line.clear() break passport = self.serial_line.text() + self.number_line.text() address = self.addres_line.text() phone = self.phone_line.text() educ_form = self.FormBox.currentText() sex = self.SexBox.currentText() while d != 0: hostel = self.HostelNumber.currentText() d = database.try_get_hostel(hostel) if d == 1: self.HostelNumber.setCurrentIndex(0) break room = 'queue' if c == 0: if d == 0: if sex == "Мужской" or sex == "Женский": key = database.add_student(fio, str(phone), str(passport), str(address), str(educ_form), str(sex), str(hostel)) database.add_student_buffer(key, fio, str(phone), str(passport), str(address), str(educ_form), str(sex), str(room), str(hostel)) self.openAdd_contract() #add_client.close() # from add_contract import Ui_add_contract # self.window = QtWidgets.QMainWindow() # self.ui = Ui_add_contract() # self.ui.setupUi(self.window) # self.window.show() self.FIO_line.clear() self.serial_line.clear() self.number_line.clear() self.addres_line.clear() self.phone_line.clear() self.HostelNumber.setCurrentIndex(0) self.FormBox.setCurrentIndex(-1) self.SexBox.setCurrentIndex(-1) else: from error_add_sex import Ui_Error self.window = QtWidgets.QMainWindow() self.ui = Ui_Error() self.ui.setupUi(self.window) self.window.show() else: from error_hostel import Ui_Error self.window = QtWidgets.QMainWindow() self.ui = Ui_Error() self.ui.setupUi(self.window) self.window.show() else: from error import Ui_Error self.window = QtWidgets.QMainWindow() self.ui = Ui_Error() self.ui.setupUi(self.window) self.window.show()
def c_add_student(): usn = int(input("Enter the usn : ")) name = input("Enter the name : ") sem = int(input("Enter the sem : ")) placed = int(input("Enter 1 for placed if not 0 ")) db.add_student(usn,name,sem,placed)
def c_add_student(): usn = int(input("Enter usn: ")) name = input("Enter name: ") sem = int(input("Enter sem: ")) placed = int(input("Enter 1 if Placed otherwise 0: ")) db.add_student(usn, name, sem, placed)
def c_add_student(regno, name, sem, placed): usn = input("enter the usn") name = input("enter the name") sem = input("enter the sem") placed = input("enter the place") db.add_student(usn, name, sem, placed)
def c_add_student(): usn = input("Enter student USN: ") name = input("Enter student name: ") sem = input("Enter student sem: ") placed = input("Student placement status: ") db.add_student(usn, name, sem, placed)