def OnRemoveClick(self, event): # wxGlade: MyFrame.<event_handler>
self.remove_row_index
msg="This student along with all data will be deleted\nAre you sure you want to Delete this row?"
if wx.MessageBox(msg, "Want to Delete?", wx.YES_NO) == wx.YES:
removed_item=self.CURRENT_LIST[0][self.remove_row_index+1]
#print "removing",removed_item
self.DB.RemoveScore(removed_item[4]) #Passing score id
#Checking if the student has any other record in any other div
query='SELECT * FROM T1 WHERE STUDENT_ID=?'
self.DB.cur.execute(query,(removed_item[1],))
if self.DB.cur.fetchone()==None:
self.DB.RemoveStudent(removed_item[1]) #passing student_id
else:
print 'other records exixts'
if self.SUBJECT=="Basic Science":
removed_item2=self.CURRENT_LIST[1][self.remove_row_index]
removed_item3=self.CURRENT_LIST[2][self.remove_row_index]
self.CURRENT_LIST[1].remove(removed_item2)
self.CURRENT_LIST[2].remove(removed_item3)
self.grid_1.DeleteRows(self.remove_row_index,1)
#except:
#print "Error in removing row"
event.Skip()
评论列表
文章目录