FilesExpand file tree

 master

/

customer.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

54 lines (46 loc) · 1.58 KB

 master

/

customer.py

Copy path

Top

File metadata and controls

• Code
• Blame

54 lines (46 loc) · 1.58 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

from database import DataBase

from product import Product

from order import Order

class Customer:

def __init__(self):

pass

def initialize(self,name,address,phone_no,pwd,data):

#self.id = id

self.name = name

self.address = address

self.phone_no = phone_no

self.pwd = pwd

self.data = data

def insert(self):

db = DataBase()

sql = "INSERT INTO customers (name, address, phone_no, pwd, data) VALUES (%s, %s, %s, %s, %s)"

values = (self.name,self.address,self.phone_no,self.pwd,self.data)

print(values)

db.insertRowInTable(sql,values)

def signup(self):

db = DataBase()

sql = "INSERT INTO customers (name, address, phone_no, pwd, data) VALUES (%s, %s, %s, %s, %s)"

values = (self.name,self.address,self.phone_no,self.pwd,self.data)

print(values)

db.insertRowInTable(sql,values)

def login(self,entered_phone_no,entered_pwd):

db = DataBase()

sql = "SELECT * FROM customers WHERE (phone_no = '{}')".format(entered_phone_no)

value = db.selectRowFromTable(sql)

print(value)

if(len(value)==0):

return 0

row = value[0]

if row[3] == entered_pwd :

self.initialize(row[0],row[1],row[2],row[3],row[4])

return 1

else:

return 0

def search(self,pattern):

product = Product()

res = product.search(pattern)

return res

def getAllOrders(self):

order = Order()

res = order.getAllOrders(self.phone_no)

return res