def testCustomer(): customer1 = customer("1", "12", "date", "10") customer2 = customer("2", "31", "date1", "11") customer3 = customer("3", "32", "date2", "14") customer4 = customer("4", "41", "date3", "100") assert customer1.returnCustomerId() == "1" assert customer2.returnCustomerId() == "2" assert customer3.returnCustomerId() == "3" assert customer4.returnCustomerId() == "4" assert customer1.returnCustomerName() == "12" assert customer2.returnCustomerName() == "31" assert customer3.returnCustomerName() == "32" assert customer4.returnCustomerName() == "41" assert customer1.returnCustomerCnp() == "date" assert customer2.returnCustomerCnp() == "date1" assert customer3.returnCustomerCnp() == "date2" assert customer4.returnCustomerCnp() == "date3" assert customer1.returnCustomerAdd() == "10" assert customer2.returnCustomerAdd() == "11" assert customer3.returnCustomerAdd() == "14" assert customer4.returnCustomerAdd() == "100"
def add(self): print "add" phoneQuery = self.PhoneEntry.get() name = self.NameEntry.get() address = self.AddressEntry.get(1.0, tk.END) if self.db.checkExist(phoneQuery): if tkMessageBox.askyesno(self.AddText, self.UpdatePrompt): self.db.add(phoneQuery, customer(name, phoneQuery, address)) else: self.search() else: self.db.add(phoneQuery, customer(name, phoneQuery, address))
def createListCustomers(self): id=0 while id<self.adjustedPossibleCustomers: id=id+1 actualCustomer=customer.customer(id) actualCustomer.maxPrice=(float(actualCustomer.maxPrice)+(float(self.weather.temprature)/200)) self.listCustomers.append(actualCustomer)
def log_in (self): #print(self.login_password.get()) self.c.execute("SELECT rowid FROM users WHERE login = ?", (str(self.login_username.get()),)) if len(self.c.fetchall()) == 0: myLabel = Label(self.screen2, text = 'This user is not found ').pack() else: a = customer.customer(str(self.login_username.get()))
def createListCustomers(self): id = 0 while id < self.adjustedPossibleCustomers: id = id + 1 actualCustomer = customer.customer(id) actualCustomer.maxPrice = (float(actualCustomer.maxPrice) + (float(self.weather.temprature) / 200)) self.listCustomers.append(actualCustomer)
def test_invalid_customer_id_test(system): print('test invalid customer id test') cus1 = customer('') errors = system.create_order('') assert len(system.customer) == 0 assert len(system.totalorder) == 0 assert 'customer_id' in errors assert errors['customer_id'] == 'Detected a invalid customer id!'
def login(): global cust global acc returnvalue = True cust_id = input("Enter Customer ID") password = input("Enter Password") con = cx_Oracle.connect('system/[email protected]/XE') cur = con.cursor() cur.execute( "SELECT * FROM customer_details where customer_no=:custid and cust_pass=:cust_pass", (cust_id, password)) results = cur.fetchall() if (int(cur.rowcount) > 0): for row in results: f_name = row[1] l_name = row[2] addrline1 = row[3] addrline2 = row[4] pincode = row[5] city = row[6] cust = customer(cust_id, f_name, l_name, addrline1, addrline2, pincode, city, password) print("Successfully login ") print("welcome " + f_name + " " + l_name) cur.execute("SELECT * FROM account where customer_no=:custid", (cust_id)) results = cur.fetchall() if (int(cur.rowcount) > 0): for row in results: acc_no = row[0] acc_type = row[1] openedDate = row[2] balance = row[3] closedDate = row[5] status = row[6] if (status == 'Active'): if (acc_type == 'saving'): cur.execute( "SELECT * FROM saving_account where acc_no=:accno", (acc_no)) results = cur.fetchall() if (int(cur.rowcount) > 0): for row in results: withdrawcount = row[1] acc = savingaccount(openedDate, acc_no, balance, cust_id, withdrawcount) else: acc = currentaccount(openedDate, acc_no, balance, cust_id) else: print('Your account is not active') returnvalue = False else: returnvalue = False print('wrong user name or password') con.commit() con.close() return returnvalue
def test_invalid_drinks_id_test(system): print('test invalid drinks id test') cus1 = customer(666) errors = system.create_order(666) errors = system.add_drinks('', 'samll', 2) assert len(system.customer) == 1 assert len(system.totalorder) == 1 assert 'drinks_foodid' in errors assert errors['drinks_foodid'] == 'Sorry, we do not have this drinks'
def test_invalid_drinks_size_test(system): print('test invalid drinks size test') cus1 = customer(666) errors = system.create_order(666) errors = system.add_drinks('coca', '', 2) assert len(system.customer) == 1 assert len(system.totalorder) == 1 assert 'drinks_size' in errors assert errors['drinks_size'] == 'Please enter a correct size!'
def test_invalid_drinks_number_test(system): print('test invalid drinks number test') cus1 = customer(666) errors = system.create_order(666) errors = system.add_drinks('coca', 'small', '') assert len(system.customer) == 1 assert len(system.totalorder) == 1 assert 'drinks_number' in errors assert errors['drinks_number'] == 'Please enter a correct number!'
def test_invalid_drinks_limit_test(system): print('test invalid drinks limit test') cus1 = customer(666) errors = system.create_order(666) errors = system.add_drinks('coca', 'small', 100) assert len(system.customer) == 1 assert len(system.totalorder) == 1 assert 'drinks_limit' in errors assert errors['drinks_limit'] == 'Sorry, exceed the maximum number!'
def test_invalid_drinks_inventory_test(system): print('test invalid drinks inventory test') cus1 = customer(666) errors = system.create_order(666) errors = system.add_drinks('lift', 'large', 2) assert len(system.customer) == 1 assert len(system.totalorder) == 1 assert 'drinks_inventory' in errors assert errors['drinks_inventory'] == 'Sorry, not enough inventory!'
def loadFromXML(self): tree = ET.parse("db.xml") root = tree.getroot() for child in root: name = child[0].text phoneNumber = child[1].text address = child[2].text Customer = customer.customer(name, phoneNumber, address) self.add(phoneNumber, Customer)
def create_order(self,customer_id): try: check_customer(customer_id) except OrderingError as error: return error.errors cus = customer(customer_id) self._orderid = self._orderid + 1 self._totalorder.append(order(customer_id)) self._customer.append(cus) return {}
def test_invalid_sides_inventory_test(system): print('test invalid sides inventory test') cus1 = customer(666) errors = system.create_order(666) errors = system.add_drinks('coca', 'small', 2) errors = system.add_sides('springroll', 'large', 1) assert len(system.customer) == 1 assert len(system.totalorder) == 1 assert 'sides_inventory' in errors assert errors['sides_inventory'] == 'Sorry, not enough inventory!'
def test_invalid_sides_id_test(system): print('test invalid sides id test') cus1 = customer(666) errors = system.create_order(666) errors = system.add_drinks('coca', 'small', 2) errors = system.add_sides('', 'large', 1) assert len(system.customer) == 1 assert len(system.totalorder) == 1 assert 'sides_foodid' in errors assert errors['sides_foodid'] == 'Sorry, we do not have this sides!'
def test_invalid_patties_limit_test(system): print('test invalid patties limit test') cus1 = customer(666) errors = system.create_order(666) errors = system.add_drinks('coca', 'small', 2) errors = system.add_sides('fries', 'large', 1) errors = system.add_patties('fish_patties', 100) assert len(system.customer) == 1 assert len(system.totalorder) == 1 assert 'patties_limit' in errors assert errors['patties_limit'] == 'Sorry, exceed the maximum number!'
def test_invalid_mains_type_test(system): print('test invalid mains type test') cus1 = customer(666) errors = system.create_order(666) errors = system.add_drinks('coca', 'small', 2) errors = system.add_sides('fries', 'large', 1) errors = system.order_a_mains('') assert len(system.customer) == 1 assert len(system.totalorder) == 1 assert 'mains_type' in errors assert errors['mains_type'] == 'Sorry, we do not have this mains!'
def test_invalid_sundaes_number_test(system): print('test invalid sundaes number test') cus1 = customer(666) errors = system.create_order(666) errors = system.add_drinks('coca', 'small', 2) errors = system.add_sides('fries', 'large', 1) errors = system.add_sundaes('chocolate', 'large', '') assert len(system.customer) == 1 assert len(system.totalorder) == 1 assert 'sundaes_number' in errors assert errors['sundaes_number'] == 'Please enter a correct number!'
def generator(CUST, seed, x, Q, Q2, Q3): for i in range(len(seed)): #for x in range(15): random.seed(seed[i]) idx = random.randint(0, 5) CUST[x] = customer(x + 1, a[idx], order_count, maxN) # ID = x+1, address = a[idx] CUST[x].makeRGB(seed[i]) Q.put(CUST[x]) Q2.put(CUST[x]) Q3.put(CUST[x]) x += 1
def add_customer_for_quote(): print("Add a new customer for quote") print("----------------------------") firstname = input("Firstname: ") surname = input("Surname: ") town = input("Town: ") telephone = input("Telephone number: ") # Aha! What is this next line? customer1 = customer(firstname, surname, town, telephone) customer_list.append(customer1) #print("Customer successfully added.") return customer1
def toLogin(self): em = self.email.text() pas = self.password.text() conn = pymysql.connect(host="localhost",user="******",password="",db="carRental") cur = conn.cursor() query = "SELECT `role` FROM `users` WHERE `email`=%s and `password`=%s" cur.execute(query, (em,pas)) result = cur.fetchone() if result is None: msg = QMessageBox() # msg.setIcon(QMessageBox.Information) # msg.setText("Record doesn't exist in database") # msg.setInformativeText("This is additional information") # msg.setWindowTitle("Not Found") # msg.setDetailedText("The details are as follows:") msg.about(self,'Not Found',"Record doesn't exist in database, please sign-up") else: log= result[0] conn.close() if log==2: self.close() self.screen = adminAddCar.adminAddCar(em) self.screen.show() elif log==3: self.close() self.screen = driverSal.driverSal(em) self.screen.show() else: conn = pymysql.connect(host="localhost",user="******",password="",db="carRental") cur = conn.cursor() query = "SELECT `id` FROM `users` WHERE `email`=%s" cur.execute(query, (em)) result = cur.fetchone() query = "SELECT `approve` FROM `books` WHERE `cu_id`=%s" cur.execute(query, result[0]) result1 = cur.fetchone() conn.close() if result1[0]=="pending": self.close() self.screen = pending.pending() self.screen.show() elif result1[0]=="Yes": self.close() self.screen = prebill.prebill(em) self.screen.show() else: self.close() self.screen = customer.customer(em) self.screen.show()
def test_invalid_patties_number_test(system): print('test invalid patties number test') cus1 = customer(666) errors = system.create_order(666) errors = system.add_drinks('coca', 'small', 2) errors = system.add_sides('fries', 'large', 1) errors = system.order_a_mains('Buger') errors = system.add_patties('fish_patties', '') assert len(system.customer) == 1 assert len(system.totalorder) == 1 assert 'patties_number' in errors assert errors['patties_number'] == 'Please enter a correct number!'
def main(): print "THIS IS MAIN" db = database() flag = True while flag: action = raw_input(actionPrompt) if action == "exit": break elif action == "new": phoneNumber = raw_input(phonePrompt) if not db.checkExist(phoneNumber): name = raw_input(namePrompt) address = raw_input(addressPrompt) db.add(phoneNumber, customer(name, phoneNumber, address)) else: print db.lookUp(phoneNumber) elif action == "search": phoneNumber = raw_input(phonePrompt) if not db.checkExist(phoneNumber): print invalidEntry addNew = raw_input(wishToAddPrompt) if addNew == "yes" or addNew == "y": name = raw_input(namePrompt) address = raw_input(addressPrompt) db.add(phoneNumber, customer(name, phoneNumber, address)) else: continue else: print db.lookUp(phoneNumber) elif action == "delete": phoneNumber = raw_input(phonePrompt) if not db.checkExist(phoneNumber): print invalidEntry continue else: db.delete(phoneNumber) elif action == "save": db.storeDBXML() elif action == "load": db.loadDBXML()
def add_new_reservation(self): a = self.hotel_name b = self.customer_name if (self.reserve_room(a, b)): #print('confirmation') number = input( 'Please Enter Your Phone Number To Complete Confirmation :') new_customer = customer.customer(b, number) #customer.customer.add_customer() self.send_text_message(number) print('Check Your Phone Please ') else: print('sorry no room available ')
def test_invalid_ingredient_inventory_test(system): print('test invalid ingredient inventory test') cus1 = customer(666) errors = system.create_order(666) errors = system.add_drinks('coca', 'small', 2) errors = system.add_sides('fries', 'large', 1) errors = system.order_a_mains('Buger') errors = system.add_patties('fish_patties', 1) errors = system.add_ingredient('onions', 1) assert len(system.customer) == 1 assert len(system.totalorder) == 1 assert 'ingredient_inventory' in errors assert errors['ingredient_inventory'] == 'Sorry, not enough inventory!'
def test_invalid_ingredient_id_test(system): print('test invalid ingredient id test') cus1 = customer(666) errors = system.create_order(666) errors = system.add_drinks('coca', 'small', 2) errors = system.add_sides('fries', 'large', 1) errors = system.order_a_mains('Buger') errors = system.add_patties('fish_patties', 1) errors = system.add_ingredient('', 1) assert len(system.customer) == 1 assert len(system.totalorder) == 1 assert 'ingredient_foodid' in errors assert errors['ingredient_foodid'] == 'Sorry, we do not have this ingredient!'
def test_successful_make_order2_test(system): print('test successful make order2 test') cus1 = customer(777) errors = system.create_order(777) errors = system.add_drinks('coca', 'large', 3) errors = system.add_sides('salad', 'small', 3) errors = system.order_a_mains('Buger') errors = system.add_patties('fish_patties', 1) errors = system.add_ingredient('tomato', 1) errors = system.add_buns(2) errors = system.add_mains assert len(system.customer) == 1 assert len(system.totalorder) == 1 assert errors == {}
def signUp(): print('in sign up') First_name = input("Enter First name") Last_name = input("Enter Last name") Address_line1 = input("Enter Your Address line 1") Address_line2 = input("Enter Your Address line 2") City = input("Enter your city") Pincode = input("Enter Pin code") Pincode = int(Pincode) # State = raw_input("Enter state") # Account_type = input("Enter account type 'saving / current / fixed deposit/ loan'") password = input("Enter password") cust = customer("0", First_name, Last_name, Address_line1, Address_line2, Pincode, City, password) cust_id = cust.signUp()
def test_invalid_customer_id_test(system): print('test invalid customer id test') cus1 = customer(666) errors = system.create_order(666) errors = system.add_drinks('coca', 'small', 2) errors = system.add_sides('fries', 'large', 1) errors = system.order_a_mains('Buger') errors = system.add_patties('fish_patties', 1) errors = system.add_ingredient('tomato', 1) errors = system.add_buns(2) errors = system.add_mains assert len(system.customer) == 1 assert len(system.totalorder) == 1 errors = system.staff_serivce('', 'Preparing') assert 'customer_id' in errors assert errors['customer_id'] == 'Please enter a valid customer id!'
def test_invalid_updated_status_test(system): print('test invalid updated status test') cus1 = customer(666) errors = system.create_order(666) errors = system.add_drinks('coca', 'small', 2) errors = system.add_sides('fries', 'large', 1) errors = system.order_a_mains('Buger') errors = system.add_patties('fish_patties', 1) errors = system.add_ingredient('tomato', 1) errors = system.add_buns(2) errors = system.add_mains assert len(system.customer) == 1 assert len(system.totalorder) == 1 errors = system.staff_serivce(666, '') assert 'update_status' in errors assert errors['update_status'] == 'Please enter a valid status!'