def InsertProduct(self, form):
self.PName = form.cleaned_data.get('PName')
self.Design = form.cleaned_data.get('Design')
self.NPieces = form.cleaned_data.get('NPieces')
self.Qstock = form.cleaned_data.get('Qstock')
self.Price = form.cleaned_data.get('Price')
self.color = form.cleaned_data.get('color')
self.KFabric = form.cleaned_data.get('KFabric')
self.SFabric = form.cleaned_data.get('SFabric')
self.DFabric = form.cleaned_data.get('DFabric')
self.IsKameezFront = form.cleaned_data.get('IsKameezFront')
self.IsKameezBack = form.cleaned_data.get('IsKameezBack')
self.IsDupatta = form.cleaned_data.get('IsDupatta')
self.IsShalwar = form.cleaned_data.get('IsShalwar')
self.Image = form.cleaned_data.get('Image')
ImageByte = self.Image.read()
t1 = database()
querry = '''set nocount on; insert into Images (Image) values (%s);
select SCOPE_IDENTITY() as id'''
data = (ImageByte, )
id = t1.Insert_ReadId(querry, data)
data = (self.PName, self.Design, self.NPieces, self.Qstock, self.Price,
self.color, self.KFabric, self.SFabric, self.DFabric,
self.IsKameezFront, self.IsKameezBack, self.IsDupatta,
self.IsShalwar, id)
querry = '''insert into Product([Product Name],[Design Code],[Number Of Pieces]
,[Quantity in Stock],[Product Price],Color,[Kameez Fabric],[Shalwar Fabric],
[Dupatta Fabric],IsKameezFrontEmbroided,IsKameezBackEmbroided
,IsDupattaEmbroided,IsShalwarEmbroided,Image
) values(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)'''
t1.Insert(querry, data)
def GetCart(self, userid):
querry = '''
select Product.[Product ID],Product.[Product Name],Cart.Qunatity,Image from cart inner join Product on Product.[Product ID]=Cart.ProductId where UserId={}
'''.format(userid)
d1 = database()
x = d1.read(querry)
return x
def GetProductList(self):
d1 = database()
Querry2 = "select [Product ID],[Product Name],Image from product"
data = d1.read(Querry2)
data = self.GenerateProductView(data)
return data
def RemoveFromCart(self, userid, ProductId):
querry = "delete from Cart where UserId='{}' and ProductId='{}'".format(
userid, ProductId)
ProductId = int(ProductId)
d1 = database()
d1.Delete(querry)
return None
def LoadDetails(self, id):
d1 = database()
Querry = '''select Product.[Product Name],Designs.DesignName,Color.color ,Product.[Number Of Pieces]
,Product.[Quantity in Stock],Product.[Product Price]
,x.Fabric,y.Fabric,Fabric.Fabric,Product.IsKameezFrontEmbroided,Product.IsKameezBackEmbroided
,Product.IsDupattaEmbroided,Product.IsShalwarEmbroided from Product inner join color on Color.id=Product.Color
inner join Designs on Product.[Design Code]=Designs.DesignCode
inner join
Fabric on Fabric.id=Product.[Dupatta Fabric]inner join
Fabric as x on x.id=Product.[Kameez Fabric]inner join
Fabric as y on y.id=Product.[Shalwar Fabric] where [Product ID]=''' + id
print(Querry)
x = d1.read(Querry)
self.PName = x[0][0]
self.Design = x[0][1]
self.color = x[0][2]
self.NPieces = x[0][3]
self.Qstock = x[0][4]
self.Price = x[0][5]
self.KFabric = x[0][6]
self.SFabric = x[0][7]
self.DFabric = x[0][8]
self.IsKameezFront = x[0][9]
self.IsKameezBack = x[0][10]
self.IsDupatta = x[0][11]
self.IsShalwar = x[0][12]
def IsInStock(self, ProductId, Qty):
querry = "select [Quantity in Stock] from Product where [Product ID]=" + ProductId
d1 = database()
x = d1.read(querry)
x = int(x[0][0])
if x < int(Qty):
return False
else:
return True
def Authenticate(self, username, password):
Querry = "select * from Users where UserName='******' and Password='******' ".format(
username, password)
d1 = database()
x = d1.read(Querry)
if len(x) == 1:
self.ReadUser(x)
return True
else:
return False
def UpdateCart(self, userid, ProductId, Qty):
querry = '''update Cart set Qunatity=%s where UserId=%s and ProductId=%s'''
ProductId = int(ProductId)
Qty = int(Qty)
data = (
Qty,
userid,
ProductId,
)
d1 = database()
d1.Update(querry, data)
return None
def CheckQty(self, uid):
list = []
querry = '''Select Cart.ProductId,Cart.Qunatity,Product.[Product ID],Product.[Quantity in Stock],Product.[Product Name] from Cart inner join Product on Product.[Product ID]=Cart.ProductId where UserId={}'''.format(
uid)
d1 = database()
x = d1.read(querry)
for i in x:
if i[1] > i[3]:
list2 = []
list2.append(i[4])
list2.append("Only {} pieces available in stock".format(i[3]))
list.append(list2)
return list
def AddToCart(self, userid, ProductId, Qty):
check = self.IsInStock(ProductId, Qty)
if check:
querry = '''exec cartupdate %s,%s,%s'''
ProductId = int(ProductId)
Qty = int(Qty)
data = (
userid,
ProductId,
Qty,
)
d1 = database()
d1.Insert(querry, data)
else:
raise OverflowError("Quantity out of range")
return None
def RegisterNewUser(self, form):
self.Name = form.cleaned_data.get('Name')
self.Contact = form.cleaned_data.get('Contact')
self.UserName = form.cleaned_data.get('UserName')
self.Password = form.cleaned_data.get('Password')
self.Image = form.cleaned_data.get('Image')
imgbytes = self.Image.read()
data = (
self.Name,
self.UserName,
self.Password,
self.Contact,
imgbytes,
)
Querry = "exec RegisterUser %s,%s,%s,%s,%s"
d1 = database()
id = d1.Insert(Querry, data)
self.Authenticate(self.UserName, self.Password)
return None
def GetOrder(self, uid):
Querry = "select * from CustomerOrder where CustomerId=" + str(uid)
d1 = database()
x = d1.read(Querry)
return x
def OrderDetail(self, uid, billno):
d1 = database()
Querry = '''SET NOCOUNT ON; exec OrderDetail {},{} '''.format(
uid, billno)
x = d1.read(Querry)
return x
def RemoveCart(self, userid):
querry = "delete from Cart where UserId='{}'".format(userid)
d1 = database()
d1.Delete(querry)
return None
def GetAccountTypes(self):
d1=database()
querry="select * from AccountType"
x=d1.read(querry)
return x
def GetDealers(self):
d1=database()
querry="select * from DealerTypes"
x=d1.read(querry)
return x
def GetUserId(self, username):
Querry = "select UserId from Users where UserName='******'".format(
username)
d1 = database()
x = d1.read(Querry)
return x[0][0]
def calculatebill(self, uid):
querry = "select FORMAT(sum(Product.[Product Price]*Cart.Qunatity), 'c', 'en-pk')as TotalBill from Cart inner join Product on Cart.ProductId=Product.[Product ID] where Cart.UserId=" + str(
uid)
d1 = database()
x = d1.read(querry)
return x[0][0]
def checkoutcart(self, userid):
querry = '''exec checkoutcart %s'''
data = (userid, )
d1 = database()
x = d1.Insert(querry, data)
return None
def GetProductImage(self, id):
querry = "select * from Images where id=%s"
data = (id, )
t1 = database()
img = t1.read_p(querry, data)
return img[0]