def update(self):
lCard = self.entryCard.get()
lFamily = self.entryFamily.get()
lvoter = self.entryContact.get()
print("in update")
print(lCard)
print(lvoter)
try:
GUIDB = "voter"
cursor = conn.cursor()
cursor.execute("USE VOTER")
c = '''UPDATE YADI SET cardno = '%s' WHERE voterno = '%s')''' % (
'lCard', 'lvoter')
d = '''UPDATE YADI SET fmailyid = '{}' WHERE voterno = '{}')'''.format(
lFamily)
#messagebox.showinfo(title = "Notification", message = 'Updated')
if cursor.execute(d) is True:
results = cursor.fetchall()
messagebox.showinfo(title="Notification", message='Updated')
else:
messagebox.showinfo(title="Notification",
message='Update Failed')
conn.commit()
except:
conn.rollback()
def search(self):
#lName = StringVar()
#lsearch = StringVar()
lName = self.entry_lastname.get()
fName = self.entry_Firstname.get()
mName = self.entry_middlename.get()
#print(lName)
try:
GUIDB = "voter"
cursor = conn.cursor()
#print(cursor.execute("SHOW DATABASES"))
cursor.execute("USE VOTER")
a = "SELECT voterno,lastname,firstname,middlename,polladd,familyid FROM YADI WHERE (lastname = '{}') OR (firstname = '{}') OR (middlename = '{}')".format(
lName, fName, mName)
#lsearch = cursor.execute("SELECT * FROM LIST WHERE (lastname = '{}') OR (firstname = '{}') OR (middlename = '{}')".format(lName,fName,mName))
if cursor.execute(a) is not True:
#self.text_comments.insert('1.0 + 2 lines', '{}'.format(lsearch))
results = cursor.fetchall()
for row in results:
voterno = row[0]
lastname = row[1]
firstname = row[2]
middlename = row[3]
polladd = row[4]
familyid = row[5]
#print(voterno,lastname,firstname,middlename,polladd,familyid)
self.text_comments.insert('1.0 + 2 lines',
'{} \t'.format(voterno))
self.text_comments.insert('1.0 + 2 lines',
'{} \t'.format(lastname))
self.text_comments.insert('1.0 + 2 lines',
'{} \t'.format(firstname))
self.text_comments.insert('1.0 + 2 lines',
'{} \t'.format(middlename))
self.text_comments.insert('1.0 + 2 lines',
'{} \t'.format(polladd))
self.text_comments.insert('1.0 + 2 lines',
'{} \t'.format(familyid))
self.text_comments.insert('1.0 + 2 lines', '\n')
#self.okFrame.instate(['disabled'])
# commite our query..
conn.commit()
else:
messagebox.showinfo(title="Notification",
message='Name Not Found')
except:
conn.rollback()
def view(self):
voter_no = self.entryContact.get()
family_id = self.entryFamily.get()
window2 = Toplevel(self.headFram)
window2.geometry('750x320+200+30')
window2.title('Voter Family Information')
self.displayFamily = ttk.Frame(window2)
self.displayFamily.pack()
ttk.Label(self.displayFamily, text='Voter No').grid(row=0,
column=0,
pady=10)
ttk.Label(self.displayFamily, text='LastName').grid(row=0,
column=1,
pady=10)
ttk.Label(self.displayFamily, text='FirstName').grid(row=0,
column=2,
pady=10)
ttk.Label(self.displayFamily, text='MiddleName').grid(row=0,
column=3,
pady=10)
self.text_family = Text(self.displayFamily, width=90, height=20)
self.text_family.grid(row=1, column=0, padx=10, columnspan=4)
try:
GUIDB = "voter"
cursor = conn.cursor()
cursor.execute("USE VOTER")
query = "SELECT voterno,lastname,firstname,middlename FROM YADI WHERE familyid = '{}'".format(
family_id)
if cursor.execute(query) is not True:
#self.text_comments.insert('1.0 + 2 lines', '{}'.format(lsearch))
results = cursor.fetchall()
for row in results:
voterno = row[0]
lastname = row[1]
firstname = row[2]
middlename = row[3]
self.text_family.insert('1.0 + 2 lines',
'{} \t'.format(voterno))
self.text_family.insert('1.0 + 2 lines',
'{} \t'.format(lastname))
self.text_family.insert('1.0 + 2 lines',
'{} \t'.format(firstname))
self.text_family.insert('1.0 + 2 lines',
'{} \t\n'.format(middlename))
#self.text_comments.insert('1.0 + 2 lines lineend','\n')
#self.text_comments.insert('1.0 + lineend','\n')
conn.commit()
else:
messagebox.showinfo(title="Notification",
message='No Family Member')
except:
conn.rollback()
def topwindow(self):
lName = self.entry_lastname.get()
fName = self.entry_Firstname.get()
mName = self.entry_middlename.get()
window = Toplevel(self.headFram)
window.geometry('950x520+200+30')
window.title('Voter Information')
panedwindow = ttk.Panedwindow(window, orient=HORIZONTAL)
panedwindow.pack(fill=BOTH, expand=True)
infoFram = ttk.Frame(panedwindow, width=200, height=300, relief=SUNKEN)
familyFram = ttk.Frame(panedwindow,
width=250,
height=300,
relief=SUNKEN)
panedwindow.add(infoFram, weight=3)
panedwindow.add(familyFram, weight=1)
ttk.Label(infoFram, text='LastName:-').grid(row=0,
column=0,
pady=10,
padx=10)
ttk.Label(infoFram, text='FirstName:-').grid(row=1,
column=0,
pady=10,
padx=10)
ttk.Label(infoFram, text='MiddleName:-').grid(row=2,
column=0,
pady=10,
padx=10)
self.entrylastname = ttk.Entry(infoFram, width=30, font=('Arial', 10))
self.entryFirstname = ttk.Entry(infoFram, width=30, font=('Arial', 10))
self.entrymiddlename = ttk.Entry(infoFram,
width=30,
font=('Arial', 10))
self.entrylastname.grid(row=0, column=1, padx=20)
self.entryFirstname.grid(row=1, column=1, padx=20)
self.entrymiddlename.grid(row=2, column=1, padx=20)
ttk.Label(infoFram, text='Polling Address:-').grid(row=3,
column=0,
pady=10,
padx=10)
ttk.Label(infoFram, text='Card No:-').grid(row=4,
column=0,
pady=10,
padx=10)
ttk.Label(infoFram, text='Family Id:-').grid(row=5,
column=0,
pady=10,
padx=10)
ttk.Label(infoFram, text='Voter No:-').grid(row=6,
column=0,
pady=10,
padx=10)
self.entryPoll = ttk.Entry(infoFram, width=50, font=('Arial', 10))
self.entryCard = ttk.Entry(infoFram, width=20, font=('Arial', 10))
self.entryFamily = ttk.Entry(infoFram, width=20, font=('Arial', 10))
self.entryContact = ttk.Entry(infoFram, width=20, font=('Arial', 10))
self.entryPoll.grid(row=3, column=1, padx=20)
self.entryCard.grid(row=4, column=1, padx=20)
self.entryFamily.grid(row=5, column=1, padx=20)
self.entryContact.grid(row=6, column=1, padx=20)
ttk.Button(infoFram, text='View Family',
command=self.view).grid(row=7,
column=1,
columnspan=2,
pady=10)
try:
cursor = conn.cursor()
b = "SELECT * FROM YADI WHERE (lastname = '{}') OR (firstname = '{}') OR (middlename = '{}')".format(
lName, fName, mName)
if cursor.execute(b) is not True:
results = cursor.fetchall()
print("connected")
for row in results:
voterno = row[0]
lastname = row[1]
firstname = row[2]
middlename = row[3]
polladd = row[4]
cardno = row[5]
familyid = row[6]
#contact = row[8]
self.entryPoll.insert(0, '{}'.format(polladd))
self.entrylastname.insert(0, '{}'.format(lastname))
self.entryFirstname.insert(0, '{}'.format(firstname))
self.entrymiddlename.insert(0, '{}'.format(middlename))
self.entryCard.insert(0, '{}'.format(cardno))
self.entryFamily.insert(0, '{}'.format(familyid))
self.entryContact.insert(0, '{}'.format(voterno))
break
conn.commit()
else:
print("Not Connect")
messagebox.showinfo(title="Notification",
message='Name Not Found')
except:
conn.rollback()
#==========================================Family Farm====================
self.logo = PhotoImage(
file=
'C:\\Users\\deepa\\Downloads\\Video\\Lynda_Python_GUI\\Ex_Files_Python_Tkinter\\Exercise Files\\Ch03\\python_logo.gif'
)
ttk.Label(familyFram, image=self.logo).grid(row=0,
column=1,
columnspan=2,
padx=25)
ttk.Label(familyFram, text="Voter List Search",
style='Header.TLabel').grid(row=0, column=1, padx=25)
ttk.Label(familyFram, text="-:: Developed By ::-").grid(row=1,
column=1,
padx=25)
ttk.Label(familyFram, text="Deepak Baliram Adhav").grid(row=2,
column=1,
padx=25,
pady=15)
ttk.Label(familyFram, text="Harshada Ravindra Aher").grid(row=3,
column=1,
padx=25,
pady=15)
ttk.Label(familyFram, text="Komal Gautam Bhadarge").grid(row=4,
column=1,
padx=25,
pady=15)