#=======defined===============#

def information():
import subprocess as sp
pName='notepad.exe'
fName='Manual Guidelines'
sp.Popen([pName,fName])
def close():
qExit = messagebox.askyesno("Decision Support System", "Do you want to exit
the system?")
if qExit > 0:
    w1.destroy ()
return

def displayall():
import subprocess as sp
pName = 'notepad.exe'
fName = 'details.txt'
sp.Popen([pName, fName])
#====WIP============#
def clear():
Name.set('')
Gender.set('')
Age.set('')
Weight.set('')
Height.set('')
Marital.set('')
Health.set('')
Licence.set('')
Experience.set('')
Frequency.set('')
Class.set('')
Model.set('')

def save():
try:
    con=pymysql.connect(user='root', password='ghaz23',
                        host='localhost', database='evm')
    cur=con.cursor()
    sql="insert into evm values('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', %s)"
         %(Name.get(), Gender.get(), Age.get(), Weight.get(), Height.get(), Marital.get(), Health.get(), Licence.get(),
           Experience.get(), Frequency.get(), Class.get(), Model.get())
    cur.execute(sql)
    con.commit()
    con.close()
    messagebox.showinfo('Success', 'Record Saved...')
except:
    messagebox.showinfo('Error', 'Error in data entry...')
finally:
    clear()

def displayall():
try:
    con=pymysql.connect(user='root', password='ghaz23',
                        host='localhost', database='evm')
    cur=con.cursor()
    sql='select * evm'
    cur.execute(sql)
    result=cur.fetchall()

    f=open('details.txt', 'w')
    for data in result:
        f.write(str(data)+' n')
    f.close()
    con.close()

    import subprocess as sp
    pName='notepad.exe'
    fName='details.txt'
    sp.Popen([pName,fName])
except:
    messagebox.showinfo('No Data', 'No such data available...')