def importSelected(self): ''' Import selected projects ''' numSelected = self.countRowsSelected(self.tblProjects) if numSelected != 0: # confirm import if numSelected == 1: msg = "Are you sure you want to import the selected project?" else: msg = "Are you sure you want to to import the selected projects?" ret = QMessageBox.question(self,"Confirm Import", msg, QMessageBox.Yes|QMessageBox.No) # if import is rejected return without deleting if ret == QMessageBox.No: return # get project id of the selected projects selectedRows = self.getSelectedRows(self.tblProjects) selectedProjects = [] for row in selectedRows: selectedProjects.append( self.tblProjects.model().item(row,0).text() ) # import selected projects controller = Controller() controller.importProjects( str(self.txtFilename.text()), selectedProjects ) # import message QMessageBox.information(self,"Importing Data from Access","The selected projects have been imported.") self.close() else: QMessageBox.information(self,"Import Data from Access","Please select the rows containing projects to be imported.")
def importAll(self): ''' Import all projects ''' msg = "Are you sure you want to to import all listed projects?" ret = QMessageBox.question(self,"Confirm Import", msg, QMessageBox.Yes|QMessageBox.No) # if import is rejected return without deleting if ret == QMessageBox.No: return selectedProjects = [] # get all project ids as selected items for row in range(0, self.tblProjects.model().rowCount()) : selectedProjects.append( self.tblProjects.model().item(row,0).text() ) # import projects controller = Controller() controller.importProjects( str(self.txtFilename.text()), selectedProjects ) # import message QMessageBox.information(self,"Importing Data from Access","All projects in the database have been imported.") self.close()