def run_player(self, event):
box = wx.TextEntryDialog(None, "Enter the name of the Player", "Cricket")
box.SetBackgroundColour('light grey')
if box.ShowModal() == wx.ID_OK:
player = box.GetValue()
disp=SQL.showall_db(arg1="pname",arg2="%"+player+"%",arg3="check")
text=wx.TextCtrl(self,-1,disp,size=(675,550),pos=(350,100))
text.SetBackgroundColour('light grey')
font = wx.Font(10, wx.DECORATIVE, wx.ITALIC, wx.NORMAL)
text.SetFont(font)
checks = ['Country','Born','Current Age','Major Teams','Profile', 'Images', 'All Info']
modal = wx.SingleChoiceDialog(None, "", "CHOICES", checks)
if modal.ShowModal() == wx.ID_OK:
choice= modal.GetStringSelection()
disp=SQL.showall_db(arg1="pname",arg2="%"+player+"%",arg3=choice)
text=wx.TextCtrl(self,-1,disp,size=(675,550),pos=(350,100))
text.SetBackgroundColour('light grey')
font = wx.Font(10, wx.DECORATIVE, wx.ITALIC, wx.NORMAL)
text.SetFont(font)
else:
text=wx.TextCtrl(self,-1,"You have cancelled the Application",size=(675,550),pos=(350,100))
text.SetBackgroundColour('light grey')
font = wx.Font(10, wx.DECORATIVE, wx.ITALIC, wx.NORMAL)
text.SetFont(font)
def run_bowlers(self, event):
box = wx.TextEntryDialog(None, "Enter Bowling Style", "Cricket")
box.SetBackgroundColour('light grey')
if box.ShowModal() == wx.ID_OK:
bowlers = box.GetValue()
disp=SQL.showall_db(arg1="pbowl",arg2="%"+bowlers+"%",arg3="check")
text=wx.TextCtrl(self,-1,disp,size=(675,550),pos=(350,100))
text.SetBackgroundColour('light grey')
font = wx.Font(10, wx.DECORATIVE, wx.ITALIC, wx.NORMAL)
text.SetFont(font)
checks = ['Player Name','Country','All Info']
modal = wx.SingleChoiceDialog(None, "", "CHOICES", checks)
if modal.ShowModal() == wx.ID_OK:
choice= modal.GetStringSelection()
disp=SQL.showall_db(arg1="pbowl",arg2="%"+bowlers+"%",arg3=choice)
text=wx.TextCtrl(self,-1,disp,size=(675,550),pos=(350,100))
text.SetBackgroundColour('light grey')
font = wx.Font(10, wx.DECORATIVE, wx.ITALIC, wx.NORMAL)
text.SetFont(font)
else:
text=wx.TextCtrl(self,-1,"You have cancelled the Application",size=(675,550),pos=(350,100))
text.SetBackgroundColour('light grey')
font = wx.Font(10, wx.DECORATIVE, wx.ITALIC, wx.NORMAL)
text.SetFont(font)
