def DeleteInfo(self):
try:
sid = self.supcombo.currentIndex()
message = ""
if sid > 0:
con = Connections.Connection()
index = sid
record = self.sup_records[index - 1]
sid = record[0]
table_name = "supplierbrandinfo"
primary_values = {"SupplierId": sid}
query = con.CreateDeleteQuery(table_name, primary_values)
print(query)
res=ShowConfirmation(self)
if res==QMessageBox.Yes:
if con.InsertQuery(query):
message = "Deletion happened successfully"
self.PrepareComboItems()
else:
message = "Deletion Failure Due To: " + con.GetErrorMessage()
else:
message="Deletion not hsppened"
ShowMessageDialog(self, message)
except BaseException as ex:
print(ex)
def SubCatList(self):
try:
bid = self.brandcombo.currentIndex()
if bid > 0:
self.tableWidget.setColumnCount(2)
column_value = ("SubCategoryId", "SubCategoryName")
self.tableWidget.setHorizontalHeaderLabels(column_value)
record = self.brand_records[bid - 1]
brandId = record[0]
print(brandId)
con = Connections.Connection()
query = "select * from subcategoryinfo where SubCategoryId in (select SubCategoryId from brandsubcategoryinfo where BrandId= "
query += str(brandId) + ")"
print(query)
self.records = con.ExecuteQuery(query)
print(self.records)
row = 0
if self.records is not None:
self.tableWidget.setRowCount(len(self.records))
for ch in self.records:
self.tableWidget.setItem(row, 0,
QTableWidgetItem(str(ch[0])))
self.tableWidget.setItem(row, 1,
QTableWidgetItem(ch[1]))
except BaseException as ex:
print(ex)
def DeleteInfo(self):
try:
bid = self.brandcombo.currentIndex()
sid = self.subcatcombo.currentIndex()
message = ""
if bid > 0 and sid > 0:
con = Connections.Connection()
index = sid
record = self.subcat_records[index - 1]
sid = record[0]
table_name = "brandsubcategoryinfo"
primary_values = {"SrNo": sid}
query = con.CreateDeleteQuery(table_name, primary_values)
print(query)
res = ShowConfirmation(self)
if res == QMessageBox.Yes:
if con.InsertQuery(query):
message = "Deletion happened successfully"
self.PrepareComboItems()
else:
message = "Deletion Failure Due To: " + con.GetErrorMessage(
)
else:
message = "Deletion aborted"
else:
message = "Select Required Fields"
ShowMessageDialog(self, message)
except BaseException as ex:
print(ex)
def ChangeCombo(self):
try:
index = self.brandcombo.currentIndex()
if index > 0 and (index - 1) <= len(self.brand_records):
self.subcatcombo.clear()
self.subcatcombo.addItem("Choose SubCategory")
con = Connections.Connection()
record = self.brand_records[index - 1]
#subrecord=self.subcat_records[index-1]
self.bnameEdit.setText(record[1])
bid = record[0]
#self.subcatEdit.setText(subrecord[1])
column_values = ("BrandId", "SubCategoryName")
table1 = "subcategoryinfo"
table2 = "brandsubcategoryinfo"
query = con.CreateJoinQuery(column_values, table1, table2)
query += " where BrandId=" + str(bid)
print(query)
self.subcat_records = con.ExecuteQuery(query)
print(self.subcat_records)
if self.subcat_records is not None:
for record in self.subcat_records:
value = record[1] + "(" + str(record[0]) + ")"
self.subcatcombo.addItem(value)
else:
self.bnameEdit.setText("")
#self.subcatEdit.setText("")
except BaseException as ex:
print(ex)
def ViewDetails(self):
try:
message = ""
id = self.custidEdit.text()
if IsEmpty(id):
message = "Enter Customer Id"
elif not IsNumber(id):
message = "Enter Id In Digits"
else:
if id is not None:
column_headers = ("CustomerId", "CustomerName", "Contact",
"EmailId", "Address", "EntryDate")
self.tablewidget.setColumnCount(6)
self.tablewidget.setHorizontalHeaderLabels(column_headers)
con = Connections.Connection()
query = "select * from customerinfo where CustomerId=" + str(
id)
print(query)
row = 0
records = con.ExecuteQuery(query)
if len(records) > 0:
self.tablewidget.setRowCount(1)
for record in records:
self.tablewidget.setItem(
row, 0, QTableWidgetItem(str(record[0])))
self.tablewidget.setItem(
row, 1, QTableWidgetItem(record[1]))
self.tablewidget.setItem(
row, 2, QTableWidgetItem(str(record[2])))
self.tablewidget.setItem(
row, 3, QTableWidgetItem(str(record[3])))
self.tablewidget.setItem(
row, 4, QTableWidgetItem(str(record[4])))
self.tablewidget.setItem(
row, 5, QTableWidgetItem(str(record[5])))
message = "Record is Displayed"
else:
self.tablewidget.setRowCount(1)
self.tablewidget.setItem(
row, 0, QTableWidgetItem(str("No Record")))
self.tablewidget.setItem(
row, 1, QTableWidgetItem(str("No Record")))
self.tablewidget.setItem(
row, 2, QTableWidgetItem(str("No Record")))
self.tablewidget.setItem(
row, 3, QTableWidgetItem(str("No Record")))
self.tablewidget.setItem(
row, 4, QTableWidgetItem(str("No Record")))
self.tablewidget.setItem(
row, 5, QTableWidgetItem(str("No Record")))
message = "Record does not exist"
else:
message = "Enter a Valid Customer Id"
ShowMessageDialog(self, message)
except BaseException as ex:
print(ex)
def AddNewUser(self):
UName = self.UnameEdit.text()
UPass = self.PassEdit.text()
RoleName = ""
message = ""
if self.RbAdmin.isChecked():
RoleName = self.RbAdmin.text()
elif self.RbUser.isChecked():
RoleName = self.RbUser.text()
elif self.RbCashier.isChecked():
RoleName = self.RbCashier.text()
if IsEmpty(UName) or IsEmpty(UPass) or IsEmpty(RoleName):
message = "Please Fill All The Boxes"
else:
table_name = " logins "
column_values = {
"username": UName,
"password": UPass,
"rolename": RoleName
}
con = Connections.Connection()
print(1)
query = con.CreateInsertQuery(table_name, column_values)
if con.InsertQuery(query):
message = "New User Is Added"
else:
message = "Insertion Failure Due To: " + con.GetErrorMessage()
ShowMessageDialog(self, message)
def DeleteRecord(self):
try:
message=""
srow=self.tableWidget.currentRow()
bid=self.tableWidget.item(srow,0).text()
res=ShowConfirmation(self)
if res==QMessageBox.Yes:
if IsAlreadyPresent(bid):
message="SubCategory or Supplier Present of this brand"
else:
con=Connections.Connection()
table_name="brandinfo"
primary_value={"BrandId":bid}
query=con.CreateDeleteQuery(table_name,primary_value)
if con.InsertQuery(query):
self.PrepareTableData()
message="Deletion Happened Successfully"
else:
message="Deletion failure Due To: "+con.GetErrorMessage()
else:
message="Deletion Aborted"
ShowMessageDialog(self,message)
except BaseException as ex:
print(ex)
def View(self):
try:
message=""
sid=self.sidEdit.text()
if IsEmpty(sid):
message="Enter SubCategoryId"
elif not IsNumber(sid):
message="Enter Id in Digits"
if sid is not None:
con=Connections.Connection()
self.tableWidget.setColumnCount(1)
column_headers = "BrandName"
self.tableWidget.setHorizontalHeaderLabels(column_headers)
table_name="brandsubcategoryinfo"
column_value=("BrandId")
query=con.CreateSelectQuery(column_value,table_name)
query+="where SubCategoryId="+sid
print(query)
self.records=con.ExecuteQuery(query)
print(self.records)
if self.records is not None:
val=self.records[1]
#for record in self.records:
else:
message="SubCategory Id do not Exist"
ShowMessageDialog(self,message)
except BaseException as ex:
print(ex)
def UpdateCategory(self):
ShowConfirmation(self)
try:
cid = self.categorycombo.currentIndex()
message = ""
cname = self.cnameEdit.text()
if cid > 0:
index = cid
record = self.records[index - 1]
catId = record[0]
con = Connections.Connection()
table_name = "categoryinfo"
column_value = {"CategoryName": cname}
primary_value = {"CategoryId": catId}
query = con.CreateUpdateQuery(table_name, column_value,
primary_value)
if con.InsertQuery(query):
message = "Updation Happened In Database"
self.PrepareComboItems()
else:
print("Insertion Failure due to: " + con.GetErrorMessage())
ShowMessageDialog(self, message)
except BaseException as ex:
print(ex)
def AddDetails(self):
try:
message=""
subname=self.subcategorynameEdit.text()
catText=self.categorycombo.currentText()
if IsEmpty(subname):
message="Enter subcategory in box"
elif IsNumber(subname):
message = "Enter a valid subcategory name "
elif "Choose" not in catText:
catid = self.categorycombo.currentIndex()
record = self.records[catid - 1]
categoryid = record[0]
con=Connections.Connection()
table_name="subcategoryinfo"
column_values={"SubcategoryName":subname,"CategoryId":categoryid}
query=con.CreateInsertQuery(table_name,column_values)
print(query)
if con.InsertQuery(query):
message="Insertion happpenened successfully"
else:
message="Insertion Failure due to: "+con.GetErrorMessage()
else:
message="Select a category"
ShowMessageDialog(self,message)
except BaseException as ex:
print(ex)
def UpdateBrand(self):
try:
bid = self.brandIdCombo.currentIndex()
message = ""
bname = self.bnameEdit.text()
if bid > 0:
index = bid
record = self.records[index - 1]
brandId = record[0]
con = Connections.Connection()
table_name = "brandinfo"
column_value = {"BrandName": bname}
primary_value = {"BrandId": brandId}
query = con.CreateUpdateQuery(table_name, column_value,
primary_value)
if con.InsertQuery(query):
message = "Updation Happened In Database"
self.PrepareComboItems()
else:
print("Insertion Failure due to: " + con.GetErrorMessage())
ShowMessageDialog(self, message)
except BaseException as ex:
print(ex)
def PrepareTableData(self):
con=Connections.Connection()
query="select ItemId,ItemName,SubCategoryId,AvailableQty,price from iteminfo"
records=con.ExecuteQuery(query)
query="select * from iteminfo natural join subcategoryinfo"
cat_record= con.ExecuteQuery(query)
print(cat_record)
row=0
if records is not None :
self.tablewidget.setRowCount(len(records))
for record in records:
self.tablewidget.setItem(row,0,QTableWidgetItem(str(record[0])))
self.tablewidget.setItem(row,1,QTableWidgetItem(record[1]))
self.tablewidget.setItem(row, 3, QTableWidgetItem(str(record[3])))
self.tablewidget.setItem(row, 4, QTableWidgetItem(str(record[4])))
row+=1
row=0
if cat_record is not None:
for record in cat_record:
self.tablewidget.setItem(row, 2, QTableWidgetItem(record[5]))
print(record[5])
row+=1
else:
self.tablewidget.setRowCount(1)
self.tablewidget.setItem(row, 0, QTableWidgetItem("No Record"))
self.tablewidget.setItem(row, 1, QTableWidgetItem("No Record"))
self.tablewidget.setItem(row, 2, QTableWidgetItem("No Record"))
self.tablewidget.setItem(row, 3, QTableWidgetItem("No Record"))
self.tablewidget.setItem(row, 4, QTableWidgetItem("No Record"))
def UpdateSupplier(self):
res=ShowConfirmation(self)
sid=self.sidcombo.currentIndex()
message=""
if res==QMessageBox.Yes:
if sid>0:
record=self.sup_records[sid-1]
sid=record[0]
sname=self.snameEdit.text()
gstno = self.gstnoEdit.text()
contact=self.contactEdit.text()
email=self.emailEdit.text()
add=self.addEdit.text()
if IsEmpty(sname) or IsEmpty(gstno) or IsEmpty(contact) or IsEmpty(add):
message+="Enter all the required Details\n\n"
if not ValidContact(contact):
message+="Enter a valid ContactNo\n\n"
else:
con=Connections.Connection()
table_name="supplierinfo"
primary_value={'SupplierId':sid}
column_values={"SupplierName":sname,"GSTno":gstno,"contact":contact,"EmailId":email,"Address":add}
query=con.CreateUpdateQuery(table_name,column_values,primary_value)
print(query)
if con.InsertQuery(query):
message="Updation happened Successfully"
else:
message="Updation Error Due To: "+con.GetErrorMessage()
else:
message="Updation Cancelled"
ShowMessageDialog(self, message)
def AddDetails(self):
try:
message=""
if "Choose" not in self.subcategorycombo.currentText() and "Choose" not in self.brandcombo.currentText():
subcatid = self.subcategorycombo.currentIndex()
bid = self.brandcombo.currentIndex()
sub_record = self.subcategory_records[subcatid - 1]
subcategoryid = sub_record[0]
brand_record = self.brand_records[bid - 1]
brandid =brand_record[0]
con=Connections.Connection()
table_name="brandsubcategoryinfo"
column_values={"BrandId":brandid,"SubCategoryId":subcategoryid}
query=con.CreateInsertQuery(table_name,column_values)
if con.InsertQuery(query):
message="Insertion happpenened successfully"
else:
message="Insertion Failure due to: "+con.GetErrorMessage()
else:
message="Select All Required Choices"
ShowMessageDialog(self,message)
except BaseException as ex:
print(ex)
def ViewDetails(self):
try:
message = ""
gst = self.suppliergstEdit.text()
if IsEmpty(gst):
message = "Enter Supplier GST NO"
elif not ValidGST(gst):
message = "Enter a Valid GST NO"
else:
if gst is not None:
column_headers = ("SupplierId", "SupplierName", "GSTno",
"Contact", "EmailId", "Address")
self.tablewidget.setColumnCount(6)
self.tablewidget.setHorizontalHeaderLabels(column_headers)
con = Connections.Connection()
query = "select * from supplierinfo where GSTno=" + str(
gst)
print(query)
row = 0
records = con.ExecuteQuery(query)
if len(records) > 0:
self.tablewidget.setRowCount(1)
for record in records:
self.tablewidget.setItem(
row, 0, QTableWidgetItem(str(record[0])))
self.tablewidget.setItem(
row, 1, QTableWidgetItem(record[1]))
self.tablewidget.setItem(
row, 2, QTableWidgetItem(str(record[2])))
self.tablewidget.setItem(
row, 3, QTableWidgetItem(str(record[3])))
self.tablewidget.setItem(
row, 4, QTableWidgetItem(str(record[4])))
self.tablewidget.setItem(
row, 5, QTableWidgetItem(str(record[5])))
message = "Record is Displayed"
else:
self.tablewidget.setRowCount(1)
self.tablewidget.setItem(
row, 0, QTableWidgetItem(str("No Record")))
self.tablewidget.setItem(
row, 1, QTableWidgetItem(str("No Record")))
self.tablewidget.setItem(
row, 2, QTableWidgetItem(str("No Record")))
self.tablewidget.setItem(
row, 3, QTableWidgetItem(str("No Record")))
self.tablewidget.setItem(
row, 4, QTableWidgetItem(str("No Record")))
self.tablewidget.setItem(
row, 5, QTableWidgetItem(str("No Record")))
message = "Record does not exist"
else:
message = "Enter a Valid Supplier GST NO"
ShowMessageDialog(self, message)
except BaseException as ex:
print(ex)
def PrepareTableData(self):
con = Connections.Connection()
table_name = "supplierinfo"
column_values = ("SupplierId", "SupplierName", "GSTno", "contact",
"EmailId", "Address")
query = con.CreateSelectQuery(column_values, table_name)
#print(query)
self.sup_records = con.ExecuteQuery(query)
row = 0
if self.sup_records is not None:
self.tablewidget.setRowCount(len(self.sup_records))
for record in self.sup_records:
self.tablewidget.setItem(row, 0,
QTableWidgetItem(str(record[0])))
self.tablewidget.setItem(row, 1, QTableWidgetItem(record[1]))
self.tablewidget.setItem(row, 2,
QTableWidgetItem(str(record[2])))
self.tablewidget.setItem(row, 3, QTableWidgetItem(record[3]))
self.tablewidget.setItem(row, 4, QTableWidgetItem(record[4]))
self.tablewidget.setItem(row, 5,
QTableWidgetItem(str(record[5])))
row += 1
else:
self.tablewidget.setRowCount(len(self.sup_records))
for record in self.cust_records:
self.tablewidget.setItem(row, 0, QTableWidgetItem("No Record"))
self.tablewidget.setItem(row, 1, QTableWidgetItem("No Record"))
self.tablewidget.setItem(row, 2, QTableWidgetItem("No Record"))
self.tablewidget.setItem(row, 3, QTableWidgetItem("No Record"))
self.tablewidget.setItem(row, 4, QTableWidgetItem("No Record"))
self.tablewidget.setItem(row, 4, QTableWidgetItem("No Record"))
row += 1
def DeleteItem(self):
try:
id=self.itemidcombo.currentIndex()
message=""
if id>0:
record=self.item_records[id-1]
itemid=record[0]
con=Connections.Connection()
table_name="iteminfo"
primary_value={'ItemId':itemid}
query=con.CreateDeleteQuery(table_name,primary_value)
print(query)
res=ShowConfirmation(self)
if res == QMessageBox.Yes:
if con.InsertQuery(query):
message="Deletion Happened Successfully"
self.PrepareComboItems()
else:
message="Deletion Failure Due To: "+con.GetErrorMessage()
elif res == QMessageBox.No:
message="Item Not Deleted"
else:
message ="Good Job"
else:
message="Enter the Item To Be Deleted"
ShowMessageDialog(self,message)
except BaseException as ex:
print(ex)
def BrandList(self):
try:
sid = self.supcombo.currentIndex()
if sid > 0:
self.tableWidget.setColumnCount(2)
column_value = ("BrandId", "BrandName")
self.tableWidget.setHorizontalHeaderLabels(column_value)
record = self.supplier_records[sid - 1]
supId = record[0]
#print(subcatId)
con = Connections.Connection()
query = "select * from brandinfo where BrandId in (select BrandId from supplierbrandinfo where SupplierId= "
query += str(supId) + ")"
print(query)
self.records = con.ExecuteQuery(query)
print(self.records)
row = 0
if self.records is not None:
self.tableWidget.setRowCount(len(self.records))
for ch in self.records:
self.tableWidget.setItem(row, 0,
QTableWidgetItem(str(ch[0])))
self.tableWidget.setItem(row, 1,
QTableWidgetItem(ch[1]))
row += 1
except BaseException as ex:
print(ex)
def Login(self):
uname = self.unameEdit.text()
upass = self.passEdit.text()
message = ""
if IsEmpty(uname):
message += "Enter Username\n\n"
elif IsEmpty(upass):
message += "Enter Password\n\n"
else:
query = "select password,rolename,lastlogin from logins where username= '******'"
con = Connections.Connection()
record = con.ExecuteQuery(query)
if record is not None and len(record) > 0:
password = record[0][0]
if upass == password:
rolename = record[0][1]
if rolename == "Admin":
self.obj = AdminMainWindow.AdminMainWindow(uname)
self.obj.show()
if record[0][2] is None:
message = "Welcome Admin First Time"
else:
message = "Your Last Visit: " + str(record[0][2])
query = "update logins set lastlogin=sysdate() "
query += " where username= '******'"
con.InsertQuery(query)
self.close()
elif rolename == "User":
self.obj = UserMainWindow.UserMainWindow()
self.obj.show()
if record[0][2] is None:
message = "Welcome Employee First Time"
else:
message = "Your Last Visit: " + str(record[0][2])
query = "update logins set lastlogin=sysdate() "
query += " where username= '******'"
con.InsertQuery(query)
self.close()
elif rolename == "Cashier":
print(6)
self.obj = CashierMainWindow.CashierMainWindow(uname)
self.obj.show()
if record[0][2] is None:
message = "Welcome Cashier First Time"
else:
message = "Your Last Visit: " + str(record[0][2])
query = "update logins set lastlogin=sysdate() "
query += " where username= '******'"
con.InsertQuery(query)
self.close()
else:
message = "Invalid User Contact Administrator"
else:
message = "Invalid Password Given"
else:
message = "Invalid Username Given"
ShowMessageDialog(self, message)
def PrepareComboItems(self):
con = Connections.Connection()
query = " select BrandId,BrandName from brandinfo"
self.records = con.ExecuteQuery(query)
if len(self.records) > 0:
for record in self.records:
value = record[1] + "(" + str(record[0]) + ")"
self.brandIdCombo.addItem(value)
def PrepareComboBox(self):
con=Connections.Connection()
query="select CategoryId,CategoryName from categoryinfo"
self.records=con.ExecuteQuery(query)
if len(self.records)>0:
for record in self.records:
value=record[1]+"("+str(record[0])+")"
self.categorycombo.addItem(value)
def PrepareComboData(self):
con = Connections.Connection()
query = "select EmpId, EmpName from employeeinfo"
self.emp_records = con.ExecuteQuery(query)
if len(self.emp_records) > 0:
for record in self.emp_records:
value = record[1] + "(" + str(record[0]) + ")"
self.comboemp.addItem(value)
def ViewDetails(self):
try:
message = ""
bname = self.bnameEdit.text()
if IsEmpty(bname):
message = "Enter Brand Name"
elif IsNumber(bname):
message = "Enter Name In Alphabets"
else:
if bname is not None:
column_headers = ("SupplierName", "BrandName")
self.tablewidget.setColumnCount(2)
self.tablewidget.setHorizontalHeaderLabels(column_headers)
con = Connections.Connection()
query = "select * from supplierinfo where SupplierName='" + bname + "'"
row = 0
records = con.ExecuteQuery(query)
if len(records) > 0:
self.tablewidget.setRowCount(1)
for record in records:
self.tablewidget.setItem(
row, 0, QTableWidgetItem(str(record[0])))
self.tablewidget.setItem(
row, 1, QTableWidgetItem(record[1]))
self.tablewidget.setItem(
row, 2, QTableWidgetItem(str(record[2])))
self.tablewidget.setItem(
row, 3, QTableWidgetItem(str(record[3])))
self.tablewidget.setItem(
row, 4, QTableWidgetItem(str(record[4])))
self.tablewidget.setItem(
row, 5, QTableWidgetItem(str(record[5])))
message = "Record is Displayed"
else:
self.tablewidget.setRowCount(1)
self.tablewidget.setItem(
row, 0, QTableWidgetItem(str("No Record")))
self.tablewidget.setItem(
row, 1, QTableWidgetItem(str("No Record")))
self.tablewidget.setItem(
row, 2, QTableWidgetItem(str("No Record")))
self.tablewidget.setItem(
row, 3, QTableWidgetItem(str("No Record")))
self.tablewidget.setItem(
row, 4, QTableWidgetItem(str("No Record")))
self.tablewidget.setItem(
row, 5, QTableWidgetItem(str("No Record")))
message = "Record does not exist"
else:
message = "Enter a Valid Supplier Name"
ShowMessageDialog(self, message)
except BaseException as ex:
print(ex)
def PrepareCustcombo(self):
con=Connections.Connection()
table_name="customerinfo"
column_values=("CustomerId","CustomerName,contact")
query=con.CreateSelectQuery(column_values,table_name)
self.cust_records=con.ExecuteQuery(query)
if self.cust_records is not None:
for record in self.cust_records:
value=str(record[1])+" ("+ str(record[0])+")"
self.custidcombo.addItem(value)
def PrepareComboItems(self):
con=Connections.Connection()
table_name="supplierinfo"
column_values=("SupplierId","SupplierName","GSTno","contact","EmailId","Address")
query=con.CreateSelectQuery(column_values,table_name)
self.sup_records=con.ExecuteQuery(query)
if len(self.sup_records)>0:
for record in self.sup_records:
value=record[1]+"("+str(record[0])+")"
self.sidcombo.addItem(value)
def ViewDetails(self):
try:
message = ""
name = self.itemnameEdit.text()
if IsEmpty(name):
message = "Enter Item Name"
elif IsNumber(name):
message = "Enter Name In Alphabets"
else:
if name is not None:
column_headers = ("ItemId", "ItemName", "SubCategoryId",
"AvailableQty", "Price")
self.tablewidget.setColumnCount(5)
self.tablewidget.setHorizontalHeaderLabels(column_headers)
con = Connections.Connection()
query = "select * from iteminfo where ItemName='" + name + "'"
row = 0
records = con.ExecuteQuery(query)
if len(records) > 0:
self.tablewidget.setRowCount(1)
for record in records:
self.tablewidget.setItem(
row, 0, QTableWidgetItem(str(record[0])))
self.tablewidget.setItem(
row, 1, QTableWidgetItem(record[1]))
self.tablewidget.setItem(
row, 2, QTableWidgetItem(str(record[2])))
self.tablewidget.setItem(
row, 3, QTableWidgetItem(str(record[3])))
self.tablewidget.setItem(
row, 4, QTableWidgetItem(str(record[4])))
message = "Record is Displayed"
else:
self.tablewidget.setRowCount(1)
self.tablewidget.setItem(
row, 0, QTableWidgetItem(str("No Record")))
self.tablewidget.setItem(
row, 1, QTableWidgetItem(str("No Record")))
self.tablewidget.setItem(
row, 2, QTableWidgetItem(str("No Record")))
self.tablewidget.setItem(
row, 3, QTableWidgetItem(str("No Record")))
self.tablewidget.setItem(
row, 4, QTableWidgetItem(str("No Record")))
message = "Record does not exist"
else:
message = "Enter a Valid Item Name"
ShowMessageDialog(self, message)
except BaseException as ex:
print(ex)
def PrepareComboItems(self):
con = Connections.Connection()
table_name = "iteminfo"
column_values = ("ItemId", "ItemName", "AvailableQty", "Price")
query = con.CreateSelectQuery(column_values, table_name)
self.item_records = con.ExecuteQuery(query)
if len(self.item_records) > 0:
for record in self.item_records:
value = record[1] + "(" + str(record[0]) + ")" + ",Rs." + str(
record[3])
self.itemcombo.addItem(value)
def PrepareComboItems(self):
try:
con=Connections.Connection()
query="select SubCategoryId,SubCategoryName from subcategoryinfo"
print(query)
self.subcategory_records =con.ExecuteQuery(query)
if len(self.subcategory_records )>0:
for record in self.subcategory_records :
value=record[1]+"("+str(record[0])+")"
self.subcategorycombo.addItem(value)
except BaseException as ex:
print(ex)
def ViewDetails(self):
try:
message = ""
id = int(self.itemidEdit.text())
print(4)
if id > 0:
print(id)
column_headers = ("ItemId", "ItemName", "SubCategoryId",
"AvailableQty", "Price")
self.tablewidget.setColumnCount(5)
self.tablewidget.setHorizontalHeaderLabels(column_headers)
con = Connections.Connection()
print(1)
query = "select * from iteminfo where ItemId=" + str(id)
print(query)
row = 0
records = con.ExecuteQuery(query)
print(records)
if len(records) > 0:
self.tablewidget.setRowCount(1)
for record in records:
self.tablewidget.setItem(
row, 0, QTableWidgetItem(str(record[0])))
self.tablewidget.setItem(row, 1,
QTableWidgetItem(record[1]))
self.tablewidget.setItem(
row, 2, QTableWidgetItem(str(record[2])))
self.tablewidget.setItem(
row, 3, QTableWidgetItem(str(record[3])))
self.tablewidget.setItem(
row, 4, QTableWidgetItem(str(record[4])))
message = "Record is Displayed"
else:
self.tablewidget.setRowCount(1)
self.tablewidget.setItem(
row, 0, QTableWidgetItem(str("No Record")))
self.tablewidget.setItem(
row, 1, QTableWidgetItem(str("No Record")))
self.tablewidget.setItem(
row, 2, QTableWidgetItem(str("No Record")))
self.tablewidget.setItem(
row, 3, QTableWidgetItem(str("No Record")))
self.tablewidget.setItem(
row, 4, QTableWidgetItem(str("No Record")))
message = "Record does not exist"
else:
message = "Enter a Valid Item Id"
ShowMessageDialog(self, message)
except BaseException as ex:
print(ex)
def PrepareComboBox(self):
con=Connections.Connection()
query="select SubCategoryId,SubCategoryName from subcategoryinfo"
self.subcategory_records=con.ExecuteQuery(query)
if len(self.subcategory_records)>0:
for record in self.subcategory_records:
value=record[1]+"("+str(record[0])+")"
self.subcategorycombo.addItem(value)
query = "select BrandId,BrandName from brandinfo"
self.brand_records = con.ExecuteQuery(query)
if len(self.brand_records) > 0:
for record in self.brand_records:
value = record[1] + "(" + str(record[0]) + ")"
self.brandcombo.addItem(value)