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)