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()
