def courseNameAvailable(self, course_name): sql = "SELECT id \ FROM courses \ WHERE name = '%s' " % (course_name, ) duplicates = fetch.getCount(sql) if duplicates: return False else: return True
def OnNewSupplier(self, evt): #rint"open dlgTextEntry 'new supplier' " dlg = wx.TextEntryDialog(self, 'Supplier Name', 'New Supplier Name', '') if dlg.ShowModal() == wx.ID_OK: new_name = dlg.GetValue().strip() if new_name: sql = "SELECT Nama FROM Suplier WHERE Nama = '%s'" % new_name if fetch.getCount(sql): msg = "Sorry supplier '%s' already exists" % new_name fetch.msg(msg) else: sql = "INSERT INTO Suplier (Nama) VALUES ('%s')" % new_name fetch.updateDB(sql) self.loadSuppliers() loadCmb.restore_str(self.choice_supplier, new_name)
def OnNewDivision(self, evt): dlg = wx.TextEntryDialog(self, 'Division Name', 'New Division Name', '') if dlg.ShowModal() == wx.ID_OK: new_name = dlg.GetValue().strip() if new_name: sql = "SELECT Nama FROM Divisi WHERE Nama = '%s'" % new_name if fetch.getCount(sql): msg = "Sorry division '%s' already exists" % new_name fetch.msg(msg) else: next_id = fetch.nextID('Divisi') sql = "INSERT INTO Divisi (Kode, Nama) VALUES (%d, '%s')" % (next_id, new_name) #rintsql fetch.updateDB(sql) self.loadDivisions() loadCmb.restore_str(self.choice_division, new_name) dlg.Destroy()