1- Python  file: CMPython.py  -  the startup file of  CMPython project

"""
Python With Sql database
"""
import tkinter
import tkinter as tk
from tkinter import *
from PIL import Image, ImageTk
import os
import pyodbc

root =Tk()
root.title("Home Page")
root.geometry("1080x650+100+20")
root.resizable(False, False)
global root_window
is_admin = False
root_window = root

def on_existing():

root.destroy()

def on_closing():
global is_on

window.destroy()





def draw_About_page():
global window
newWindow = Toplevel(root_window)
newWindow.title("ABout Page")
newWindow.geometry("400x255+500+200")
newWindow.configure( bg="#fbb1bd")
newWindow.resizable(0, 0)
#newWindow.eval('tk::PlaceWindow . center')
header=Frame(newWindow, bg="#e23946", bd=5)
header.place(x=0,y=0,width=400,height=30)

#1- heading label
nsec=Label(header, text="BIBLE English Application, Info",font=("Times New Roman",12,"bold"), bg = "#e23946",fg="#eae2b7")
nsec.place(x=0, y=1, width=400)

#2- Image
image1 = Image.open("media/jesus1.jpg")
test = ImageTk.PhotoImage(image1)
label1 = tkinter.Label(newWindow,image=test)
label1.image = test
label1.place(x=5, y=40, height = 150)

#3- SQl,Frame1, text1, nv0
conn = pyodbc.connect('Driver={SQL Server};'
'Server=desktop-uegar4h;'
'Database=BKJVDat;'
'Trusted_Connection=yes;')
#connection desktop-uegar4h.BKJVDat.dbo
#name=BKJVDat
#Owner=DESKTOP-UEGAR4H\User
#connection string=Data Source=localhost;Initial Catalog=BKJVDat;Integrated Security=True
#provider=.NET Framework Data Provider for SQL Server
cursor = conn.cursor()
#cursor.execute('SELECT dbo.BBTable1.Book, dbo.BBTable1.TextData FROM dbo.BBTable1 WHERE (((dbo.BBTable1.Book)="00a")) ')
cursor.execute("SELECT TextData FROM dbo.BBTable1 WHERE book='00a'")
rows = cursor.fetchone()
nv0 = rows[0]


Frame1 = Frame(newWindow, borderwidth=2, bg="gray")
Frame1.place(x=115, y=35, width=280,height=75)
#----
scroll = tk.Scrollbar(Frame1)
text1 = tk.Text(Frame1, height=8, width=31, yscrollcommand=scroll.set)
#scroll = tk.Scrollbar(Frame1)
text1.configure(yscrollcommand=scroll.set)
#text1.pack(side=tk.LEFT)

scroll.config(command=text1.yview)
scroll.pack(side=tk.RIGHT, fill=tk.Y)
text1.pack(side=tk.LEFT)

text1.insert(tk.END,nv0)

#----
conn.commit()
conn.close()

#4- SQl,Frame2, text2, nv1
conn = pyodbc.connect('Driver={SQL Server};'
'Server=desktop-uegar4h;'
'Database=BKJVDat;'
'Trusted_Connection=yes;')
#connection desktop-uegar4h.BKJVDat.dbo
#name=BKJVDat
#Owner=DESKTOP-UEGAR4H\User
#connection string=Data Source=localhost;Initial Catalog=BKJVDat;Integrated Security=True
#provider=.NET Framework Data Provider for SQL Server
cursor = conn.cursor()
#cursor.execute('SELECT dbo.BBTable1.Book, dbo.BBTable1.TextData FROM dbo.BBTable1 WHERE (((dbo.BBTable1.Book)="00a")) ')
cursor.execute("SELECT TextData FROM dbo.BBTable1 WHERE Book='00b'")
rows = cursor.fetchone()
nv1 = rows[0]

Frame2 = Frame(newWindow, borderwidth=2, bg="gray")
Frame2.place(x=115, y=115, width=280, height=80)
#----
text2 = tk.Text(Frame2, height=8, width=31)
scroll = tk.Scrollbar(Frame2)
text2.configure(yscrollcommand=scroll.set)
text2.pack(side=tk.LEFT)

scroll.config(command=text2.yview)
scroll.pack(side=tk.RIGHT, fill=tk.Y)
text2.insert(tk.END, nv1)
#----
conn.commit()
conn.close()

#5- line
lertline=Label(newWindow, text="",font=("Times New Roman",8,), bg = "#e23946",fg="#eae2b7")
lertline.place(x=0, y=200, width=400, height=15)

#6- emailButton
emaill = Label(newWindow, text ="echkzouein@gmail.com", font=("Times New Roman", 12), relief = FLAT, bg="#fbb1bd")
emaill.place(x=50, y=220)
submit= Button(newWindow, text="Done", command = on_closing, font=("Times New Roman", 14), bd =2, bg = "#e23946",fg="#eae2b7", relief=RAISED)
submit.place(x=250, y=220, width = 100, height = 25)

newWindow.protocol("WM_DELETE_WINDOW", on_closing)
window = newWindow

def draw_Biography_page():
global window
newWindow = Toplevel(root_window)
newWindow.title("Biography Page")
newWindow.geometry("370x230+500+200")
newWindow.configure( bg="#fbb1bd")
newWindow.resizable(0, 0)

# This will create a LabelFrame
label_frame = LabelFrame(newWindow, text='')
label_frame.pack(expand='yes', fill='both')

label11 = Label(label_frame, text=' Name: Chucri Simon zouein.')
label11.place(x=0, y=5)

label21 = Label(label_frame, text=' Address: Lebanon, Beirut, Sed ElBaouchrie, Ferdaous Str.')
label21.place(x=0, y=35)

label31 = Label(label_frame,
text=' Signification: Engineer on Software System science.')
label31.place(x=0, y=65)


label41 = Label(label_frame,
text=' Web: www.puresoftwarecode.com.')
label41.place(x=0, y=95)

label51 = Label(label_frame,
text=' Tel: 961 01 591436.')
label51.place(x=0, y=125)


#5- line
lertline=Label(newWindow, text="",font=("Times New Roman",8,), bg = "#e23946",fg="#eae2b7")
lertline.place(x=0, y=165, width=400)

#6- emailButton
emaill = Label(newWindow, text ="echkzouein@gmail.com", font=("Times New Roman", 12), relief = FLAT)
emaill.place(x=50, y=190)
submit= Button(newWindow, text="Done", command = on_closing, font=("Times New Roman", 14), bd =2, bg = "#e23946",fg="#eae2b7", relief=RAISED)
submit.place(x=250, y=190, width = 100, height = 30)

newWindow.protocol("WM_DELETE_WINDOW", on_closing)
window = newWindow





def info_data():
conn = pyodbc.connect('Driver={SQL Server};'
'Server=desktop-uegar4h;'
'Database=BKJVDat;'
'Trusted_Connection=yes;')
#connection desktop-uegar4h.BKJVDat.dbo
#name=BKJVDat
#Owner=DESKTOP-UEGAR4H\User
#connection string=Data Source=localhost;Initial Catalog=BKJVDat;Integrated Security=True
#provider=.NET Framework Data Provider for SQL Server

cursor = conn.cursor()
cursor.execute('SELECT * FROM BBTable1')

for i in cursor:
print(i)

def draw_SearchWord():
os.system('python Searchword.py')

def draw_search_1():
# import search_1 Sql
os.system('python search_1.py')
def draw_combo1():
# import combo1 Sql
os.system('python combo1.py')
def draw_combo2():
# import combo2 Sql
os.system('python combo2.py')




def draw_visitor():
for widget in dashboard.winfo_children():
widget.destroy()
welcome_text["text"] = "Welcome to The BIBLE"
image1 = Image.open("media/nsec.jpg")
test = ImageTk.PhotoImage(image1)
label1 = Label(dashboard,image=test)
label1.photo = test
label1.place(x=0, y=0, height = 400, width = 1080)



option= Button(dashboard, text ="Search by word", command = draw_SearchWord, bd =0, font=("Times New Roman",14), bg = "#118ab2",fg="#eae2b7")
option.place(x=30, y=110, width = 200, height = 30)
option= Button(dashboard, text ="Search by Nber or Name", command = draw_search_1, bd =0, font=("Times New Roman",14), bg = "#118ab2",fg="#eae2b7")
option.place(x=30, y=170, width = 200, height = 30)
option= Button(dashboard, text ="Search by Verse", command = draw_combo1, bd =0, font=("Times New Roman",14), bg = "#118ab2",fg="#eae2b7")
option.place(x=30, y=230, width = 200, height = 30)
option= Button(dashboard, text ="Search by Chapter", command = draw_combo2, bd =0, font=("Times New Roman",14), bg = "#118ab2",fg="#eae2b7")
option.place(x=30, y=290, width = 200, height = 30)


option= Button(dashboard, text ="Print Data", command =info_data, bd =0, font=("Times New Roman",14), bg = "#118ab2",fg="#eae2b7")
option.place(x=845, y=110, width = 200, height = 30)
option= Button(dashboard, text ="About", command = draw_About_page, bd =0, font=("Times New Roman",14), bg = "#118ab2",fg="#eae2b7")
option.place(x=845, y=170, width = 200, height = 30)
option= Button(dashboard, text ="Biography", command = draw_Biography_page,bd =0, font=("Times New Roman",14), bg = "#118ab2",fg="#eae2b7")
option.place(x=845, y=230, width = 200, height = 30)

option= Button(dashboard, text ="Exit", command = on_existing, bd =0, font=("Times New Roman",14), bg = "#118ab2",fg="#eae2b7")
option.place(x=845, y=290, width = 200, height = 30)


def draw_admin():
for widget in dashboard.winfo_children():
widget.destroy()
welcome_text["text"] = "Welcome, Admin"
image1 = Image.open("media/nsec.jpg")
test = ImageTk.PhotoImage(image1)
label1 = Label(dashboard,image=test)
label1.photo = test
label1.place(x=0, y=0, height = 400, width = 1080)


#Header
header=Frame(root, bg="brown", bd=0)
header.place(x=0,y=0,width=1080,height=115)
#logo
image1 = Image.open("media/logo.jpg")
test = ImageTk.PhotoImage(image1)
label1 = tkinter.Label(header,image=test)
label1.image = test
label1.place(x=0, y=0, height = 120)
#heading label
nsec=Label(header, text="In the beginning was the Word, and the Word was with God, and the Word was God.",font=("Times New Roman",16,"bold" ), bg = "brown",fg="#eae2b7")
nsec.place(x=105, y=35, width=950)

#Profile frame
frame=Frame(root, bg="#fbb1bd")
frame.place(x=0,y=115,width=1080,height=50)
welcome_text = Label(frame, text = "Welcome to the BIBLE", font=("Minion Pro Regular", 16), bg="#fbb1bd")
welcome_text.place(x=20, y=10)
is_on = True




dashboard=Frame(root, bg="#bbb", bd=0)
dashboard.place(x=0,y=165,width=1080,height=400)
draw_visitor()
#Footer
footer=Frame(root, bg="brown", bd=0)
footer.place(x=0,y=565,width=1080,height=85)
root.mainloop()

  2- Python  file: Searchword.py  - Search by Word,  to display  THE BIBLE  Verse Corresponding to the Searching Word

#import tkinter
import tkinter as tk
from tkinter import *
from tkinter import ttk
from tkinter.ttk import *
#from tkinter import messagebox
from PIL import Image, ImageTk
import pyodbc

Word_to_Search =""

def on_closing():
root.destroy()

def search():
Word_to_Search ="jesus"

#delete treeView data
data_table.delete(*data_table.get_children())

#delete Entries data
BookEntry.delete(0, END)
BookTitleEntry.delete(0, END)
ChapterEntry.delete(0, END)
VerseEntry.delete(0, END)
textDataEntry22.delete("1.0",tk.END)


#show Sql data of Database
conn = pyodbc.connect('Driver={SQL Server};'
'Server=desktop-uegar4h;'
'Database=BKJVDat;'
'Trusted_Connection=yes;')
#connection desktop-uegar4h.BKJVDat.dbo
#name=BKJVDat
#Owner=DESKTOP-UEGAR4H\User
#connection string=Data Source=localhost;Initial Catalog=BKJVDat;Integrated Security=True
#provider=.NET Framework Data Provider for SQL Server+

cursor = conn.cursor()

# TreeView
##Queryys = ("SELECT Verse, TextData FROM BBTable1 WHERE Book<>'00a' and Book<>'00b' and Book = '02' AND Chapter = '001' Order By Book ASC")
Queryys = ("SELECT Book, BookTitle, Chapter, Verse, TextData FROM BBTable1 WHERE Book<>'00a' and Book<>'00b' and (TextData like '%Peter%' or TextData like 'Peter%' or TextData like '%Peter') Order By Book ASC")

#show list of Data rows
r_setBCh=cursor.execute(Queryys)

#Alternate colors for the rows of Treeview
my_tag='normal' # default value
for dt in r_setBCh:
my_tag='gray' if my_tag=='normal' else 'normal'

data_table.insert("", 'end',iid=dt[4], text=dt[4],
values =(dt[0],dt[1],dt[2],dt[3],dt[4]),tags=(my_tag))

#Calcul Number of rows
cursor.execute(Queryys)

rows = cursor.fetchall()

if rows == None:
note_text['text'] = "2- TreeView is Empty, the Search value: Jesus, -- Data: 0 Rows "
return

note_text['text'] = "2- THE BIBLE by Verse in the TreeView, the Search value: Jesus, -- Data: "+str(len(rows))+ " Row"


conn.commit()
conn.close()


def getdata(currow):#event): #

currow = ""
contents= ""
row =""
currow = data_table.focus()
contents = data_table.item(currow)
row = contents['values']

BookEntry.configure(state='normal')
ChapterEntry.configure(state='normal')
#VerseEntry.configure(state='normal')

#delete contents
BookEntry.delete(0, END)
BookTitleEntry.delete(0, END)
ChapterEntry.delete(0, END)
VerseEntry.delete(0, END)
textDataEntry22.delete("1.0",tk.END)

#insert contents
lbselected3['text']="3- THE BIBLE by Verse, Entry Values Corresponding with the Selected Value in Treeview:"
lbselected31['text']=" Book = "+ str(row[0]).rjust(2, '0') + ", BookTitle = "+ row[1] + ", Chapter = "+ str(row[2]).rjust(3, '0') +", Verse = "+ str(row[3]).rjust(3, '0')

#insert contents
BookEntry.insert(tk.END, str(row[0]).rjust(2, '0'))
BookTitleEntry.insert(tk.END, row[1])
ChapterEntry.insert(tk.END, str(row[2]).rjust(3, '0'))
VerseEntry.insert(tk.END, str(row[3]).rjust(3, '0'))
textDataEntry22.insert(tk.END, row[4])


root = Tk()
root.title("Search by Word Operation, to Show The Bible by Verse Corresponding")
#root.geometry('570x600')
root.eval('tk::PlaceWindow . center')
window_height = 590
window_width = 600

screen_width = root.winfo_screenwidth()
screen_height = root.winfo_screenheight()

x_cordinate = int((screen_width/2) - (window_width/2))
y_cordinate = int((screen_height/2) - (window_height/2))

root.geometry("{}x{}+{}+{}".format(window_width, window_height, x_cordinate, y_cordinate))
root.resizable(0, 0)


#Labels

lbselected1=Label(root,text="1- Search Operation: ",font=("Times New Roman", 12), foreground="#000080")
lbselected1.place(x=17, y=3)
lbselected1a=Label(root,text=" 1)- in Entry Box of Search by Word: Input any Word, 2)- then Click Search Button:",font=("Times New Roman", 10), foreground="#000080")
lbselected1a.place(x=17, y=23)
lbselected2=Label(root,text=" 3)- in the TreeView to Show the Corresponding Search of THE BIBLE by Verse ",font=("Times New Roman", 10), foreground="#000080")
lbselected2.place(x=17, y=43)

lbWsearch=Label(root,text="Search by Word:",font=("Times New Roman", 12))
lbWsearch.place(x=17, y=75)
entry_text0 = tk.StringVar()
Wsearch = tk.Entry(root, textvariable=entry_text0,font=("Times New Roman",12))
Wsearch.place(x=140, y =75, width = 180)


#Label Message
note_text=Label(root, text = "2- TreeView is Empty",font=("Times New Roman", 10), foreground="#000080")
note_text.place(x=10, y=140)


lbselected3=Label(root,text="3- no Data Display, when ...",font=("Times New Roman", 10), foreground="#000080")
lbselected3.place(x=10, y=390)
lbselected31=Label(root,text=" ",font=("Times New Roman", 10), foreground="#000080")
lbselected31.place(x=10, y=410)


#2- Image
image1 = Image.open("media/jesus1.jpg")
test = ImageTk.PhotoImage(image1)
label11= tk.Label(root,image=test)
label11.image = test
label11.place(x=490, y=15, height = 140)



#Button
searchBtn=Button(root,text="Search", command = search)#, font=("Times New Roman",12,"bold"), bd = 0)
searchBtn.place(x=350, y=75, height = 20, width = 100)


close = Button(root, text = "Done", command = on_closing)
close.place(x=500, y=535, height = 30, width = 70)

#TreeView
tabfrm=Frame(root,borderwidth=4,relief=RIDGE)
tabfrm.place(x=20,y=160,width=550,height=220)
scrolly=Scrollbar(tabfrm,orient=VERTICAL)
x_scrollbar = Scrollbar(tabfrm, orient=HORIZONTAL)

#data_table= ttk.Treeview(tabfrm,columns=("Verse","TextData"), height=40, yscrollcommand=scrolly.set,xscrollcommand=x_scrollbar.set)
data_table= ttk.Treeview(tabfrm,columns=("Book","BookTitle","Chapter","Verse","TextData"), height=40, yscrollcommand=scrolly.set,xscrollcommand=x_scrollbar.set)
scrolly.pack(side=RIGHT,fill=Y)
scrolly.config(command=data_table.yview)
#------
x_scrollbar.pack(side=BOTTOM, fill='x')
x_scrollbar.config(command=data_table.xview)
#-------

#Alternate colors for the rows of Treeview
data_table.tag_configure('gray', background='lightgray')
data_table.tag_configure('normal', background='white')

# INSIDE RIGHT BOX
data_table.heading("Book",text="Book")
data_table.heading("BookTitle",text="Book Title")
data_table.heading("Chapter",text="Chapter")
data_table.heading("Verse",text="Verse")
data_table.heading("TextData",text="Text Data")
data_table['show']="headings"
data_table.column("Book",width = 40)
data_table.column("BookTitle",width = 60)
data_table.column("Chapter",width = 55)
data_table.column("Verse",width = 40)
data_table.column("TextData",width=600)
data_table.pack(fill=BOTH,expand=1)
data_table.bind("<ButtonRelease-1>",getdata)



#Labels and Entries
BookLable=Label(root,text="Book:",font=("Times New Roman",12))
BookLable.place(x=17, y =440)
entry_textb = tk.StringVar()
BookEntry = tk.Entry(root, textvariable=entry_textb,font=("Times New Roman",12))
BookEntry.place(x=81, y =440, width = 100)


BookTitleLable=Label(root,text="BookTitle:",font=("Times New Roman",12))
BookTitleLable.place(x=220, y =440)
entry_text2 = tk.StringVar()
BookTitleEntry = tk.Entry(root, textvariable=entry_text2,font=("Times New Roman",12))
BookTitleEntry.place(x=304, y =440, width = 100)

ChapterLable=Label(root,text="Chapter:",font=("Times New Roman",12))
ChapterLable.place(x=17, y =470)
entry_textc = tk.StringVar()
ChapterEntry = tk.Entry(root, textvariable=entry_textc,font=("Times New Roman",12))
ChapterEntry.place(x=81, y =470, width = 100)

VerseLable=Label(root,text="Verse:",font=("Times New Roman",12))
VerseLable.place(x=220, y =470)
entry_textv = tk.StringVar()
VerseEntry = tk.Entry(root, textvariable=entry_textv,font=("Times New Roman",12))
VerseEntry.place(x=304, y =470, width = 100)



TextDataLable=Label(root,text="TextData:",font=("Times New Roman", 12))
TextDataLable.place(x=17, y=500)

#Text multi TextBox, textDataEntry22
Frame22 = Frame(root, borderwidth=2)
Frame22.place(x=79, y=500, width=400, height=70)
textDataEntry22 = tk.Text(Frame22, height=8, width=47)
scroll = tk.Scrollbar(Frame22)

textDataEntry22.configure(yscrollcommand=scroll.set)
textDataEntry22.pack(side=tk.LEFT)
scroll.config(command=textDataEntry22.yview)
scroll.pack(side=tk.RIGHT, fill=tk.Y)



root.mainloop()

  3- Python  file: search_1.py  -  Search using the values  of Comboboxes,  to display  THE BIBLE  Verse Corresponding to the values  of Comboboxes

"""
using SQL Database
"""
import tkinter as tk
from tkinter import *
from tkinter import *
from tkinter import ttk
import pyodbc


Bookval = ""
Chapterval=""

root =Tk()
root.title("Search (by Book OR Name)")
root.geometry("850x620+200+50")
root.resizable(False, False)
global root_window
root_window = root
def on_closing():
root_window.destroy()



def combo_Book():

conn = pyodbc.connect('Driver={SQL Server};'
'Server=desktop-uegar4h;'
'Database=BKJVDat;'
'Trusted_Connection=yes;')

global current_varB
cursor = conn.cursor()
cursor.execute("SELECT distinct Book FROM BBTable1 WHERE Book<>'00a' and Book<>'00b' Order By Book ASC")

cboTaskB = []
for row in cursor.fetchall():
cboTaskB.append(row[0])
return cboTaskB


conn.commit()
conn.close()


def combo_BookTitle():
#Chapterval1a = divChapter.get()
connBT = pyodbc.connect('Driver={SQL Server};'
'Server=desktop-uegar4h;'
'Database=BKJVDat;'
'Trusted_Connection=yes;')

cursorBT = connBT.cursor()
cursorBT.execute("SELECT distinct BookTitle, Book FROM BBTable1 WHERE Book<>'00a' and Book<>'00b' Order By Book ASC")


cboTaskBT = []
for row1 in cursorBT.fetchall():
cboTaskBT.append(row1[0])
return cboTaskBT


connBT.commit()
connBT.close()

def combo_Chapter():

Bookval = (divBook.get()).rstrip()
connCh = pyodbc.connect('Driver={SQL Server};'
'Server=desktop-uegar4h;'
'Database=BKJVDat;'
'Trusted_Connection=yes;')

cursorCh = connCh.cursor()
cursorCh.execute("SELECT distinct Chapter FROM BBTable1 WHERE Book = '" + str(Bookval) + "' Order By Chapter ASC")
cboTaskCh = []
for row2 in cursorCh.fetchall():
cboTaskCh.append(row2[0])
return cboTaskCh


connCh.commit()
connCh.close()

def combo_Verse():
Bookval = (divBook.get()).rstrip()
Chapterval = (divChapter.get()).rstrip()

connCh = pyodbc.connect('Driver={SQL Server};'
'Server=desktop-uegar4h;'
'Database=BKJVDat;'
'Trusted_Connection=yes;')

cursorV = connCh.cursor()
cursorV.execute("SELECT distinct Verse FROM BBTable1 WHERE Book = '" + str(Bookval) + "' AND Chapter = '" + str(Chapterval) + "' Order By Verse ASC")
cboTaskV = []
for row2 in cursorV.fetchall():
cboTaskV.append(row2[0])
return cboTaskV


connCh.commit()
connCh.close()

def getdataBKBkT(event):


option = dropdown.get()

#clear combobox divBook
divBook.configure(values=())
divBook.set('')

#clear combobox divChapter
divChapter.configure(values=())
divChapter.set('')

#clear combobox divVerse
divVerse.configure(values=())
divVerse.set('')

#Variables
Bookvala =""
Chaptervala =""

r = 0

#clear combobox divChapter
divChapter.configure(values=())
divChapter.set('')

#delete treeView data
data_table.delete(*data_table.get_children())
note_text['text'] = "2- TreeView is Empty"

#delete Entries data
BookEntry.delete(0, END)
BookTitleEntry.delete(0, END)
ChapterEntry.delete(0, END)
VerseEntry.delete(0, END)
textDataEntry22.delete("1.0",tk.END)

#show Sql data of Database
connop = pyodbc.connect('Driver={SQL Server};'
'Server=desktop-uegar4h;'
'Database=BKJVDat;'
'Trusted_Connection=yes;')
#connection desktop-uegar4h.BKJVDat.dbo
#name=BKJVDat
#Owner=DESKTOP-UEGAR4H\User
#connection string=Data Source=localhost;Initial Catalog=BKJVDat;Integrated Security=True
#provider=.NET Framework Data Provider for SQL Server+

cursorop = connop.cursor()

#show value of current item divBookTitle = current item divBook
#divBookTitle.current(divBook.current())

if option == "Book":
cursorop.execute("SELECT distinct Book FROM BBTable1 WHERE Book<>'00a' and Book<>'00b' Order By Book ASC")

cboTaskop = []
r = 1
for row2 in cursorop.fetchall():
cboTaskop.append(row2[0])
divBook['values'] = cboTaskop
r = r + 1
#current item or 1st item
divBook.current(0)

Bookvala = (divBook.get()).rstrip()

#Chapter Combobox
# add data to Chapter Combobox
Queryy2 = ("SELECT distinct Chapter FROM BBTable1 WHERE Book = '" + str(Bookvala) + "' Order By Chapter ASC")
cursorop.execute(Queryy2)

cboTaskCh = []
r = 1
for row2 in cursorop.fetchall():
cboTaskCh.append(row2[0])
divChapter['values'] = cboTaskCh
r = r + 1
#current item or 1st item
divChapter.current(0)

Chaptervala = (divChapter.get()).rstrip()


#Verse Combobox
# add data to Verse Combobox
Queryy2 = ("SELECT distinct Verse FROM BBTable1 WHERE Book = '" + str(Bookvala) + "' AND Chapter = '" + str(Chaptervala) + "' Order By verse ASC")
cursorop.execute(Queryy2)

cboTaskV = []
r = 1
for row2 in cursorop.fetchall():
cboTaskV.append(row2[0])
divVerse['values'] = cboTaskV
r = r + 1
#current item or 1st item
divVerse.current(0)



elif option == "BookTitle":
cursorop.execute("SELECT distinct BookTitle, Book FROM BBTable1 WHERE Book<>'00a' and Book<>'00b' Order By Book ASC")

cboTaskop = []
r = 1
for row2 in cursorop.fetchall():
cboTaskop.append(row2[0])
divBook['values'] = cboTaskop
r = r + 1
#current item or 1st item
divBook.current(0)

Bookvala = (divBook.get()).rstrip()

#Chapter Combobox
# add data to Chapter Combobox
Queryy2 = ("SELECT distinct Chapter FROM BBTable1 WHERE BookTitle = '" + str(Bookvala) + "' Order By Chapter ASC")
cursorop.execute(Queryy2)

cboTaskCh = []
r = 1
for row2 in cursorop.fetchall():
cboTaskCh.append(row2[0])
divChapter['values'] = cboTaskCh
r = r + 1
#current item or 1st item
divChapter.current(0)

Chaptervala = (divChapter.get()).rstrip()


#Verse Combobox
# add data to Verse Combobox
Queryy2 = ("SELECT distinct Verse FROM BBTable1 WHERE BookTitle = '" + str(Bookvala) + "' AND Chapter = '" + str(Chaptervala) + "' Order By Verse ASC")
cursorop.execute(Queryy2)

cboTaskV = []
r = 1
for row2 in cursorop.fetchall():
cboTaskV.append(row2[0])
divVerse['values'] = cboTaskV
r = r + 1
#current item or 1st item
divVerse.current(0)

else:
return


connop.commit()
connop.close()

#----------------------------
#1-divBook
def getdataBk(event):

option = dropdown.get()
Bookvala = (divBook.get()).rstrip()

#clear combobox divChapter
divChapter.configure(values=())
divChapter.set('')

#clear combobox divVerse
divVerse.configure(values=())
divVerse.set('')

#delete treeView data
data_table.delete(*data_table.get_children())
note_text['text'] = "2- TreeView is Empty"

#delete Entries data
BookEntry.delete(0, END)
BookTitleEntry.delete(0, END)
ChapterEntry.delete(0, END)
VerseEntry.delete(0, END)
textDataEntry22.delete("1.0",tk.END)

#show Sql data of Database

connop = pyodbc.connect('Driver={SQL Server};'
'Server=desktop-uegar4h;'
'Database=BKJVDat;'
'Trusted_Connection=yes;')
#connection desktop-uegar4h.BKJVDat.dbo
#name=BKJVDat
#Owner=DESKTOP-UEGAR4H\User
#connection string=Data Source=localhost;Initial Catalog=BKJVDat;Integrated Security=True
#provider=.NET Framework Data Provider for SQL Server+

cursorop = connop.cursor()

if option == "Book":


#Chapter Combobox
# add data to Chapter Combobox
Queryy2 = ("SELECT distinct Chapter FROM BBTable1 WHERE Book = '" + str(Bookvala) + "' Order By Chapter ASC")
cursorop.execute(Queryy2)

cboTaskCh = []
r = 1
for row2 in cursorop.fetchall():
cboTaskCh.append(row2[0])
divChapter['values'] = cboTaskCh
r = r + 1
#current item or 1st item
divChapter.current(0)

Chaptervala = (divChapter.get()).rstrip()


#Verse Combobox
# add data to Verse Combobox
Queryy2a = ("SELECT distinct Verse FROM BBTable1 WHERE Book = '" + str(Bookvala) + "' AND Chapter = '" + str(Chaptervala) + "' Order By Verse ASC")
cursorop.execute(Queryy2a)

cboTaskV = []
r = 1
for row2 in cursorop.fetchall():
cboTaskV.append(row2[0])
divVerse['values'] = cboTaskV
r = r + 1
#current item or 1st item
divVerse.current(0)


elif option == "BookTitle":

#Chapter Combobox
# add data to Chapter Combobox
Queryy21 = ("SELECT distinct Chapter FROM BBTable1 WHERE BookTitle = '" + str(Bookvala) + "' Order By Chapter ASC")
cursorop.execute(Queryy21)

cboTaskCh = []
r = 1
for row2 in cursorop.fetchall():
cboTaskCh.append(row2[0])
divChapter['values'] = cboTaskCh
r = r + 1
#current item or 1st item
divChapter.current(0)

Chaptervala = (divChapter.get()).rstrip()


#Verse Combobox
# add data to Verse Combobox
Queryy21a = ("SELECT distinct Verse FROM BBTable1 WHERE BookTitle = '" + str(Bookvala) + "' AND Chapter = '" + str(Chaptervala) + "' Order By Verse ASC")
cursorop.execute(Queryy21a)

cboTaskV = []
r = 1
for row2 in cursorop.fetchall():
cboTaskV.append(row2[0])
divVerse['values'] = cboTaskV
r = r + 1
#current item or 1st item
divVerse.current(0)

else:
return


connop.commit()
connop.close()


#2-divChapter
def getdataCh(event):
option = dropdown.get()
Bookvala = (divBook.get()).rstrip()


#clear combobox divVerse
divVerse.configure(values=())
divVerse.set('')

#delete treeView data
data_table.delete(*data_table.get_children())
note_text['text'] = "2- TreeView is Empty"

#delete Entries data
BookEntry.delete(0, END)
BookTitleEntry.delete(0, END)
ChapterEntry.delete(0, END)
VerseEntry.delete(0, END)
textDataEntry22.delete("1.0",tk.END)

#show Sql data of Database
connop = pyodbc.connect('Driver={SQL Server};'
'Server=desktop-uegar4h;'
'Database=BKJVDat;'
'Trusted_Connection=yes;')
#connection desktop-uegar4h.BKJVDat.dbo
#name=BKJVDat
#Owner=DESKTOP-UEGAR4H\User
#connection string=Data Source=localhost;Initial Catalog=BKJVDat;Integrated Security=True
#provider=.NET Framework Data Provider for SQL Server+

cursorop = connop.cursor()
if option == "Book":


Chaptervala = (divChapter.get()).rstrip()


#Verse Combobox
# add data to Verse Combobox
Queryy22 = ("SELECT distinct Verse FROM BBTable1 WHERE Book = '" + str(Bookvala) + "' AND Chapter = '" + str(Chaptervala) + "' Order By Verse ASC")
cursorop.execute(Queryy22)

cboTaskV = []
r = 1
for row2 in cursorop.fetchall():
cboTaskV.append(row2[0])
divVerse['values'] = cboTaskV
r = r + 1
#current item or 1st item
divVerse.current(0)


elif option == "BookTitle":

Chaptervala = (divChapter.get()).rstrip()


#Verse Combobox
# add data to Verse Combobox
Queryy22a = ("SELECT distinct Verse FROM BBTable1 WHERE BookTitle = '" + str(Bookvala) + "' AND Chapter = '" + str(Chaptervala) + "' Order By Verse ASC")
cursorop.execute(Queryy22a)

cboTaskV = []
r = 1
for row2 in cursorop.fetchall():
cboTaskV.append(row2[0])
divVerse['values'] = cboTaskV
r = r + 1
#current item or 1st item
divVerse.current(0)

else:
return


connop.commit()
connop.close()


#3-divVerse
def getdataV(event):

#delete treeView data
data_table.delete(*data_table.get_children())
note_text['text'] = "2- TreeView is Empty"

#delete Entries data
BookEntry.delete(0, END)
BookTitleEntry.delete(0, END)
ChapterEntry.delete(0, END)
VerseEntry.delete(0, END)
textDataEntry22.delete("1.0",tk.END)



#--------------
def search():
option = dropdown.get()
search_input = (divBook.get()).rstrip()
search_inputCh = (divChapter.get()).rstrip()
search_inputV = (divVerse.get()).rstrip()


#show Sql data of Database
conn = pyodbc.connect('Driver={SQL Server};'
'Server=desktop-uegar4h;'
'Database=BKJVDat;'
'Trusted_Connection=yes;')
#connection desktop-uegar4h.BKJVDat.dbo
#name=BKJVDat
#Owner=DESKTOP-UEGAR4H\User
#connection string=Data Source=localhost;Initial Catalog=BKJVDat;Integrated Security=True
#provider=.NET Framework Data Provider for SQL Server+

cursor = conn.cursor()


if option == "Book":
# TreeView
Queryy = ("SELECT Verse, TextData FROM dbo.BBTable1 WHERE Book = '" + str(search_input) + "' AND Chapter = '" + str(search_inputCh) + "' AND Verse = '" + str(search_inputV) + "' Order By dbo.BBTable1.Verse ASC")
#show list of Data rows
r_setBCh=cursor.execute(Queryy)



elif option == "BookTitle":
# TreeView
Queryy = ("SELECT Verse, TextData FROM dbo.BBTable1 WHERE BookTitle = '" + str(search_input) + "' AND Chapter = '" + str(search_inputCh) + "' AND Verse = '" + str(search_inputV) + "' Order By dbo.BBTable1.Verse ASC")
#show list of Data rows
r_setBCh=cursor.execute(Queryy)

else:
return



#Alternate colors for the rows of Treeview
my_tag='normal' # default value
for dt in r_setBCh:
my_tag='gray' if my_tag=='normal' else 'normal'
data_table.insert("", 'end',iid=dt[0], text=dt[0],
values =(dt[0],dt[1]),tags=(my_tag))

#Calcul Number of rows
cursor.execute(Queryy)

rows = cursor.fetchall()

if rows == None:
note_text['text'] = "2- TreeView is Empty - Data: 0 Rows "
return
if option == "Book":
note_text['text'] = "2- THE BIBLE by Verse in the TreeView and ... - Book: "+str(search_input)+ ", Chapter: "+str(search_inputCh)+", Verse: "+str(search_inputV)+" -- "+str(len(rows))+" Row"

BookLable.place(x=50, y =460)
BookEntry.place(x=123, y =460, width = 100)
#insert contents
BookEntry.insert(0, str(search_input))
ChapterEntry.insert(0, str(search_inputCh))
VerseEntry.insert(0, str(search_inputV))

textDataEntry22.insert(tk.END, dt[1])


elif option == "BookTitle":
note_text['text'] = "2- THE BIBLE by Verse in the TreeView - BookTitle: "+str(search_input)+ ", Chapter: "+str(search_inputCh)+", Verse: "+str(search_inputV)+" -- "+str(len(rows))+" Row"
BookTitleLable.place(x=50, y =460)
BookTitleEntry.place(x=123, y =460, width = 100)

#insert contents
BookTitleEntry.insert(0, str(search_input))
ChapterEntry.insert(0, str(search_inputCh))
VerseEntry.insert(0, str(search_inputV))

textDataEntry22.insert(tk.END, dt[1])
else:
return





conn.commit()
conn.close()


#Header
header=Frame(root, bg="brown", bd=0)
header.place(x=0,y=0,width=850,height=75)

#heading label
nsec=Label(header, text="The book of the generation of Jesus Christ, the son of David, the son of Abraham.",font=("Times New Roman", 16,"bold"), bg = "brown",fg="#eae2b7")
nsec.place(x=0, y=10, width=850)

#Profile frame
frame2=Frame(root, bg="#fbb1bd")
frame2.place(x=0,y=75,width=850,height=50)
welcome_text = Label(frame2, text = "Search (by Book OR Name)", font=("Times New Roman", 12), bg="#fbb1bd")
welcome_text.place(x=30, y=10, height = 25, width = 200)

close = Button(frame2, text = "Done", bd = 0, command = on_closing, font=("Times New Roman", 12), bg="#fff", fg = "#000")
close.place(x=725, y=10, width = 80)

#panel
panel=Frame(root, bg="#bbb", bd=0)
panel.place(x=0,y=125,width=850,height=500)

#panel_elements
#Labels
lbselected1=Label(panel,text="1- Search Operation, Select any value of Comboboxes, then Click Button - Search,",font=("Times New Roman", 12,"bold"), bg="#bbb", foreground="#ffffff")
lbselected1.place(x=17, y=3)
lbselected2=Label(panel,text=" to Show the corresponding THE BIBLE by Verse in the TreeView and the Box Entries",font=("Times New Roman", 12,"bold"), bg="#bbb", foreground="#ffffff")
lbselected2.place(x=17, y=24)

lbBook=Label(panel,text="Search by Book or Booktitle:",font=("Times New Roman", 10))
lbBook.place(x=50, y=70)
dropdown=ttk.Combobox(panel, width=15, font=("Times New Roman",10), state='readonly')
dropdown['values']=("Book", "BookTitle")
dropdown.current(0)
dropdown.place(x=250, y=70)
dropdown.bind("<<ComboboxSelected>>", getdataBKBkT)

currentBook = StringVar()
divBook = ttk.Combobox(panel, textvariable=currentBook)
divBook['values'] = combo_Book()
divBook.place(x=430, y=70)
divBook.bind("<<ComboboxSelected>>", getdataBk)

# Shows first item of this Combo as a default value
divBook.current(0)

lbChapter=Label(panel,text="Search by Chapter:",font=("Times New Roman", 10))
lbChapter.place(x=50, y=100)
currentChapter = StringVar()
divChapter = ttk.Combobox(panel, textvariable=currentChapter)
divChapter['values'] = combo_Chapter()
divChapter.place(x=430, y=100)
divChapter.bind("<<ComboboxSelected>>", getdataCh)

# Shows first item of this Combo as a default value
divChapter.current(0)


lbVerse=Label(panel,text="Search by Verse:",font=("Times New Roman", 10))
lbVerse.place(x=50, y=130)
currentVerse = StringVar()
divVerse = ttk.Combobox(panel, textvariable=currentVerse)
divVerse['values'] = combo_Verse()
divVerse.place(x=430, y=130)
divVerse.bind("<<ComboboxSelected>>", getdataV)

# Shows first item of this Combo as a default value
divVerse.current(0)


searchBtn=Button(panel,text="Search", command = search, font=("Times New Roman",12,"bold"), bd = 0)
searchBtn.place(x=650, y=70, height = 20, width = 100)

result=Frame(root, bd=0)
result.place(x=0,y=0,width=0,height=0)



#Label Message
note_text=Label(root, text = "2- TreeView is Empty",font=("Times New Roman", 12,"bold"), bg="#bbb", foreground="#ffffff")
note_text.place(x=17, y=300)

#TreeView
tabfrm=Frame(root,borderwidth=4,relief=RIDGE)
tabfrm.place(x=50,y=330,width=750,height=90)
scrolly=Scrollbar(tabfrm,orient=VERTICAL)
x_scrollbar = Scrollbar(tabfrm, orient=HORIZONTAL)

data_table=ttk.Treeview(tabfrm,columns=("Verse","TextData"), height=40, yscrollcommand=scrolly.set,xscrollcommand=x_scrollbar.set)
scrolly.pack(side=RIGHT,fill=Y)
scrolly.config(command=data_table.yview)
#------
x_scrollbar.pack(side=BOTTOM, fill='x')
x_scrollbar.config(command=data_table.xview)
#-------

#Alternate colors for the rows of Treeview
data_table.tag_configure('gray', background='lightgray')
data_table.tag_configure('normal', background='white')

# INSIDE RIGHT BOX
data_table.heading("Verse",text="Verse")
data_table.heading("TextData",text="Text Data")
data_table['show']="headings"
data_table.column("Verse",width = 40)
data_table.column("TextData",width=600)
data_table.pack(fill=BOTH,expand=1)
data_table.bind("<ButtonRelease-1>",search)




#Labels and Entries
BookLable=Label(root,text="Book:",font=("Times New Roman",12))
BookLable.place(x=50, y =460)
entry_text1 = tk.StringVar()
BookEntry = tk.Entry(root, textvariable=entry_text1,font=("Times New Roman",12))
BookEntry.place(x=123, y =460, width = 100)


BookTitleLable=Label(root,text="BookTitle:",font=("Times New Roman",12))
#BookTitleLable.place(x=253, y =460)
entry_text2 = tk.StringVar()
BookTitleEntry = tk.Entry(root, textvariable=entry_text2,font=("Times New Roman",12))
#BookTitleEntry.place(x=337, y =460, width = 100)



ChapterLable=Label(root,text="Chapter:",font=("Times New Roman",12))
ChapterLable.place(x=50, y =490)
entry_text3 = tk.StringVar()
ChapterEntry = tk.Entry(root, textvariable=entry_text3,font=("Times New Roman",12))
ChapterEntry.place(x=123, y =490, width = 100)


VerseLable=Label(root,text="Verse:",font=("Times New Roman",12))
VerseLable.place(x=253, y =490)
entry_text = tk.StringVar()
VerseEntry = tk.Entry(root, textvariable=entry_text,font=("Times New Roman",12))
VerseEntry.place(x=337, y =490, width = 100)


TextDataLable=Label(root,text="TextData:",font=("Times New Roman", 12))
TextDataLable.place(x=50, y=535)

#Text multi TextBox, textDataEntry22
Frame22 = Frame(root, borderwidth=2, bg="#bbb")
Frame22.place(x=123, y=530, width=400, height=70)
textDataEntry22 = tk.Text(Frame22, height=8, width=47)
scroll = tk.Scrollbar(Frame22)

textDataEntry22.configure(yscrollcommand=scroll.set)
textDataEntry22.pack(side=tk.LEFT)
scroll.config(command=textDataEntry22.yview)
scroll.pack(side=tk.RIGHT, fill=tk.Y)


root.mainloop()

  4- Python  file: combo1.py  -   To Display Data,  THE BIBLE by Verse

import tkinter as tk
from tkinter import *
from tkinter import ttk
from tkinter.ttk import *
#from tkinter import messagebox
from PIL import Image, ImageTk
import pyodbc


Bookval = ""
Chapterval=""
verseval=""

def on_closing():
root.destroy()

def combo_Book():
conn = pyodbc.connect('Driver={SQL Server};'
'Server=desktop-uegar4h;'
'Database=BKJVDat;'
'Trusted_Connection=yes;')

global current_varB
cursor = conn.cursor()
cursor.execute("SELECT distinct Book FROM BBTable1 WHERE Book<>'00a' and Book<>'00b' Order By Book ASC")

cboTaskB = []
for row in cursor.fetchall():
cboTaskB.append(row[0])
return cboTaskB


conn.commit()
conn.close()


def combo_BookTitle():
connBT = pyodbc.connect('Driver={SQL Server};'
'Server=desktop-uegar4h;'
'Database=BKJVDat;'
'Trusted_Connection=yes;')

cursorBT = connBT.cursor()
cursorBT.execute("SELECT distinct BookTitle, Book FROM BBTable1 WHERE Book<>'00a' and Book<>'00b' Order By Book ASC")


cboTaskBT = []
for row1 in cursorBT.fetchall():
cboTaskBT.append(row1[0])
return cboTaskBT


connBT.commit()
connBT.close()

def combo_Chapter():
#global Bookval
#Bookval = (currentBook.get())
connCh = pyodbc.connect('Driver={SQL Server};'
'Server=desktop-uegar4h;'
'Database=BKJVDat;'
'Trusted_Connection=yes;')

cursorCh = connCh.cursor()
cursorCh.execute("SELECT distinct Chapter FROM BBTable1 WHERE Book = '" + str(Bookval) + "' Order By Chapter ASC")
cboTaskCh = []
for row2 in cursorCh.fetchall():
cboTaskCh.append(row2[0])
return cboTaskCh


connCh.commit()
connCh.close()

def combo_Verse():
#global Bookval
#Bookval = (currentBook.get())
#Chapterval = divChapter.current(0)#currentChapter.get().rstrip()

connVr = pyodbc.connect('Driver={SQL Server};'
'Server=desktop-uegar4h;'
'Database=BKJVDat;'
'Trusted_Connection=yes;')

cursorVr = connVr.cursor()
cursorVr.execute("SELECT distinct Verse FROM BBTable1 WHERE Book = '" + str(Bookval) + "' AND Chapter = '" + str(Chapterval) + "' Order By BBTable1.Verse ASC")

cboTaskVr = []
for row2 in cursorVr.fetchall():
cboTaskVr.append(row2[0])
return cboTaskVr


connVr.commit()
connVr.close()


def getdataBK(event):
#Variables
Bookval1a =""
Bookvala =""
Chapterval1a =""
Chaptervala =""
Verseval1a =""
Versevala =""

r = 0

#clear combobox divChapter
divChapter.configure(values=())
divChapter.set('')

#delete treeView data
data_table.delete(*data_table.get_children())

#delete Entries data
BookEntry.delete(0, END)
BookTitleEntry.delete(0, END)
ChapterEntry.delete(0, END)
VerseEntry.delete(0, END)
textDataEntry22.delete("1.0",tk.END)

#value of current item divBook
Bookval1a = divBook.get()
Bookvala = Bookval1a.rstrip()

#show Sql data of Database
connBVal = pyodbc.connect('Driver={SQL Server};'
'Server=desktop-uegar4h;'
'Database=BKJVDat;'
'Trusted_Connection=yes;')
#connection desktop-uegar4h.BKJVDat.dbo
#name=BKJVDat
#Owner=DESKTOP-UEGAR4H\User
#connection string=Data Source=localhost;Initial Catalog=BKJVDat;Integrated Security=True
#provider=.NET Framework Data Provider for SQL Server+

cursorBTD = connBVal.cursor()

#show value of current item divBookTitle = current item divBook
divBookTitle.current(divBook.current())

#Chapter Combobox
# add data to Chapter Combobox
Queryy2 = ("SELECT distinct Chapter FROM BBTable1 WHERE Book = '" + str(Bookvala) + "' Order By Chapter ASC")
cursorBTD.execute(Queryy2)

cboTaskCh = []
r = 1
for row2 in cursorBTD.fetchall():
cboTaskCh.append(row2[0])
divChapter['values'] = cboTaskCh
r = r + 1
#current item or 1st item
divChapter.current(0)

#value of current item divChapter
Chapterval1a = divChapter.get()
Chaptervala = Chapterval1a.rstrip()

#value of current item divVerse
Verseval1a = divVerse.get()
Versevala = Verseval1a.rstrip()

# TreeView
QueryyBCh = ("SELECT Verse, TextData FROM dbo.BBTable1 WHERE Book = '" + str(Bookvala) + "' AND Chapter = '" + str(Chaptervala) + "' AND Verse = '" + str(Versevala) + "' Order By dbo.BBTable1.Verse ASC")
#show list of Data rows
r_setBCh=cursorBTD.execute(QueryyBCh)

#Alternate colors for the rows of Treeview
my_tag='normal' # default value
for dt in r_setBCh:
my_tag='gray' if my_tag=='normal' else 'normal'
data_table.insert("", 'end',iid=dt[0], text=dt[0],
values =(dt[0],dt[1]),tags=(my_tag))

#Calcul Number of rows
cursorBTD.execute(QueryyBCh)

rows = cursorBTD.fetchall()

if rows == None:
note_text['text'] = "2- TreeView is Empty - Data: 0 Rows "
return

note_text['text'] = "2- THE BIBLE by Verse in the TreeView - Book: "+str(divBook.get().rstrip())+ ", BookTitle: "+str(divBookTitle.get().rstrip())+ ", Chapter: "+str(divChapter.get().rstrip())+", Verse: "+str(divVerse.get().rstrip())+" -- "+str(len(rows))+" Row"

lbselected3['text'] ="3- To Display Data, when to Select the Row of THE BIBLE by Verse in the TreeView"


connBVal.commit()
connBVal.close()



def getdataBT(event):
#Variables
BookTitleval1a =""
BookTitlevala =""
Chapterval1a =""
Chaptervala =""
Verseval1a =""
Versevala =""
r = 0

#clear combobox divChapter
divChapter.configure(values=())
divChapter.set('')

#delete treeView data
data_table.delete(*data_table.get_children())

#delete Entries data
BookEntry.delete(0, END)
BookTitleEntry.delete(0, END)
ChapterEntry.delete(0, END)
VerseEntry.delete(0, END)
textDataEntry22.delete("1.0",tk.END)

#value of current item divBook
BookTitleval1a = divBookTitle.get()
BookTitlevala = BookTitleval1a.rstrip()

#show Sql data of Database
connBTVal = pyodbc.connect('Driver={SQL Server};'
'Server=desktop-uegar4h;'
'Database=BKJVDat;'
'Trusted_Connection=yes;')
#connection desktop-uegar4h.BKJVDat.dbo
#name=BKJVDat
#Owner=DESKTOP-UEGAR4H\User
#connection string=Data Source=localhost;Initial Catalog=BKJVDat;Integrated Security=True
#provider=.NET Framework Data Provider for SQL Server+

cursorBTD = connBTVal.cursor()

#show value of current item divBook = current item divBookTitle
divBook.current(divBookTitle.current())

#Chapter Combobox
# add data to Chapter Combobox
Queryy2 = ("SELECT distinct Chapter FROM BBTable1 WHERE BookTitle = '" + str(BookTitlevala) + "' Order By Chapter ASC")
cursorBTD.execute(Queryy2)

cboTaskCh = []
r = 1
for row2 in cursorBTD.fetchall():
cboTaskCh.append(row2[0])
divChapter['values'] = cboTaskCh
r = r + 1
#current item or 1st item
divChapter.current(0)

#value of current item divChapter
Chapterval1a = divChapter.get()
Chaptervala = Chapterval1a.rstrip()

#value of current item divVerse
Verseval1a = divVerse.get()
Versevala = Verseval1a.rstrip()

# TreeView
QueryyBCh = ("SELECT Verse, TextData FROM dbo.BBTable1 WHERE BookTitle = '" + str(BookTitlevala) + "' AND Chapter = '" + str(Chaptervala) + "' AND Verse = '" + str(Versevala) + "' Order By dbo.BBTable1.Verse ASC")
#show list of Data rows
r_setBCh=cursorBTD.execute(QueryyBCh)

#Alternate colors for the rows of Treeview
my_tag='normal' # default value
for dt in r_setBCh:
my_tag='gray' if my_tag=='normal' else 'normal'
data_table.insert("", 'end',iid=dt[0], text=dt[0],
values =(dt[0],dt[1]),tags=(my_tag))

#Calcul Number of rows
cursorBTD.execute(QueryyBCh)

rows = cursorBTD.fetchall()

if rows == None:
note_text['text'] = "2- TreeView is Empty - Data: 0 Rows "
return

note_text['text'] = "2- THE BIBLE by Verse in the TreeView - Book: "+str(divBook.get().rstrip())+ ", BookTitle: "+str(divBookTitle.get().rstrip())+ ", Chapter: "+str(divChapter.get().rstrip())+", Verse: "+str(divVerse.get().rstrip())+" -- "+str(len(rows))+" Row"

lbselected3['text'] ="3- To Display Data, when to Select the Row of THE BIBLE by Verse in the TreeView"
connBTVal.commit()
connBTVal.close()


def getdataCh(event):
Bookval1a =""
Bookvala =""
Chapterval1a =""
Chaptervala =""
Verseval1a =""
Versevala =""

#delete treeView data
data_table.delete(*data_table.get_children())

#delete Entries data
BookEntry.delete(0, END)
BookTitleEntry.delete(0, END)
ChapterEntry.delete(0, END)
VerseEntry.delete(0, END)
textDataEntry22.delete("1.0",tk.END)

Bookval1a = divBook.get()
Bookvala = Bookval1a.rstrip()
Chapterval1a = divChapter.get()
Chaptervala = Chapterval1a.rstrip()

#value of current item divVerse
Verseval1a = divVerse.get()
Versevala = Verseval1a.rstrip()

#show Sql data of Database
connBCh = pyodbc.connect('Driver={SQL Server};'
'Server=desktop-uegar4h;'
'Database=BKJVDat;'
'Trusted_Connection=yes;')
#connection desktop-uegar4h.BKJVDat.dbo
#name=BKJVDat
#Owner=DESKTOP-UEGAR4H\User
#connection string=Data Source=localhost;Initial Catalog=BKJVDat;Integrated Security=True
#provider=.NET Framework Data Provider for SQL Server+

cursorBCh = connBCh.cursor()
# TreeView
QueryyBCh = ("SELECT Verse, TextData FROM dbo.BBTable1 WHERE Book = '" + str(Bookvala) + "' AND Chapter = '" + str(Chaptervala) + "' AND Verse = '" + str(Versevala) + "' Order By dbo.BBTable1.Verse ASC")
#show list of Data rows
r_setBCh=cursorBCh.execute(QueryyBCh)

#Alternate colors for the rows of Treeview
my_tag='normal' # default value
for dt in r_setBCh:
my_tag='gray' if my_tag=='normal' else 'normal'
data_table.insert("", 'end',iid=dt[0], text=dt[0],
values =(dt[0],dt[1]),tags=(my_tag))

#Calcul Number of rows
cursorBCh.execute(QueryyBCh)

rows = cursorBCh.fetchall()

if rows == None:
note_text['text'] = "2- TreeView is Empty - Data: 0 Rows "
return

note_text['text'] = "2- THE BIBLE by Verse in the TreeView - Book: "+str(divBook.get().rstrip())+ ", BookTitle: "+str(divBookTitle.get().rstrip())+ ", Chapter: "+str(divChapter.get().rstrip())+", Verse: "+str(divVerse.get().rstrip())+" -- "+str(len(rows))+" Row"

lbselected3['text'] ="3- To Display Data, when to Select the Row of THE BIBLE by Verse in the TreeView"
connBCh.commit()
connBCh.close()

def getdataVr(event):
Bookval1a =""
Bookvala =""
Chapterval1a =""
Chaptervala =""
Verseval1a =""
Versevala =""

#delete treeView data
data_table.delete(*data_table.get_children())

#delete Entries data
BookEntry.delete(0, END)
BookTitleEntry.delete(0, END)
ChapterEntry.delete(0, END)
VerseEntry.delete(0, END)
textDataEntry22.delete("1.0",tk.END)

Bookval1a = divBook.get()
Bookvala = Bookval1a.rstrip()
Chapterval1a = divChapter.get()
Chaptervala = Chapterval1a.rstrip()
Verseval1a = divVerse.get()
Versevala = Verseval1a.rstrip()

#show Sql data of Database
connBVr = pyodbc.connect('Driver={SQL Server};'
'Server=desktop-uegar4h;'
'Database=BKJVDat;'
'Trusted_Connection=yes;')
#connection desktop-uegar4h.BKJVDat.dbo
#name=BKJVDat
#Owner=DESKTOP-UEGAR4H\User
#connection string=Data Source=localhost;Initial Catalog=BKJVDat;Integrated Security=True
#provider=.NET Framework Data Provider for SQL Server+

cursorBVr = connBVr.cursor()
# TreeView
QueryyBVr = ("SELECT Verse, TextData FROM dbo.BBTable1 WHERE Book = '" + str(Bookvala) + "' AND Chapter = '" + str(Chaptervala) + "' AND Verse = '" + str(Versevala) + "' Order By dbo.BBTable1.Verse ASC")
#show list of Data rows
r_setBVr=cursorBVr.execute(QueryyBVr)

#Alternate colors for the rows of Treeview
my_tag='normal' # default value
for dt in r_setBVr:
my_tag='gray' if my_tag=='normal' else 'normal'
data_table.insert("", 'end',iid=dt[0], text=dt[0],
values =(dt[0],dt[1]),tags=(my_tag))

#Calcul Number of rows
cursorBVr.execute(QueryyBVr)

rows = cursorBVr.fetchall()

if rows == None:
note_text['text'] = "2- TreeView is Empty - Data: 0 Rows "
return

note_text['text'] = "2- THE BIBLE by Verse in the TreeView - Book: "+str(divBook.get().rstrip())+ ", BookTitle: "+str(divBookTitle.get().rstrip())+ ", Chapter: "+str(divChapter.get().rstrip())+", Verse: "+str(divVerse.get().rstrip())+" -- "+str(len(rows))+" Row"

lbselected3['text'] ="3- To Display Data, when to Select the Row of THE BIBLE by Verse in the TreeView"
connBVr.commit()
connBVr.close()


def getdata(event):

currow = data_table.focus()
contents = data_table.item(currow)
row = contents['values']
VerseEntry.configure(state='normal')

#delete contents
BookEntry.delete(0, END)
BookTitleEntry.delete(0, END)
ChapterEntry.delete(0, END)
VerseEntry.delete(0, END)
#insert contents
BookEntry.insert(0, str(divBook.get().rstrip()))
BookTitleEntry.insert(0, str(divBookTitle.get().rstrip()))
ChapterEntry.insert(0, str(divChapter.get().rstrip()))
VerseEntry.insert(0, data_table.selection()[0])

#delete contents
textDataEntry22.delete("1.0",tk.END)
#insert contents
textDataEntry22.insert(tk.END, row[1])




root = Tk()
root.title("Search Operation, to Show Bible by Verse Corresponding")
root.eval('tk::PlaceWindow . center')
window_height = 520
window_width = 600

screen_width = root.winfo_screenwidth()
screen_height = root.winfo_screenheight()

x_cordinate = int((screen_width/2) - (window_width/2))
y_cordinate = int((screen_height/2) - (window_height/2))

root.geometry("{}x{}+{}+{}".format(window_width, window_height, x_cordinate, y_cordinate))
root.resizable(0, 0)


#Labels

lbselected1=Label(root,text="1- Search Operation, Select any value of Comboboxes,",font=("Times New Roman", 12), foreground="#000080")
lbselected1.place(x=17, y=3)
lbselected2=Label(root,text=" to Show the corresponding THE BIBLE by Verse in the TreeView",font=("Times New Roman", 10), foreground="#000080")
lbselected2.place(x=17, y=24)

lbBook=Label(root,text="Book:",font=("Times New Roman", 12))
lbBook.place(x=17, y=55)
lbBookTitle=Label(root,text="Book Title:",font=("Times New Roman", 12))
lbBookTitle.place(x=17, y=80)
lbChapter=Label(root,text="Chapter:",font=("Times New Roman", 12))
lbChapter.place(x=17, y=105)
lbVerse=Label(root,text="Verse:",font=("Times New Roman", 12))
lbVerse.place(x=17, y=130)

#lbVerse1=Label(root,text=str(divChapter.current(0)),font=("Times New Roman", 12))
#lbVerse1.place(x=17, y=170)

#Chapterval = currentChapter.get().rstrip()

lbline1=Label(root,text="----------------------------------------------------------------",font=("Times New Roman", 12))
lbline1.place(x=45, y=150)


#Label Message
note_text=Label(root, text = "2- TreeView is Empty",font=("Times New Roman", 10), foreground="#000080")
note_text.place(x=10, y=180)


lbselected3=Label(root,text="3- no Data Display, when ...",font=("Times New Roman", 10), foreground="#000080")
lbselected3.place(x=17, y=320)

#1st ComBoBox
currentBook = StringVar()
divBook = ttk.Combobox(root, textvariable=currentBook)
divBook['values'] = combo_Book()
divBook.place(x=110, y=55)
divBook.bind("<<ComboboxSelected>>", getdataBK)

# Shows first item of this Combo as a default value
divBook.current(0)

Bookval1 = currentBook.get()
Bookval = Bookval1.rstrip()

#2nd ComBoBox
divBookTitle = ttk.Combobox(root)
divBookTitle['values'] = combo_BookTitle()
divBookTitle.place(x=110, y=80)
divBookTitle.bind("<<ComboboxSelected>>", getdataBT)

# Shows first item of this Combo as a default value
divBookTitle.current(0)


#3th ComBoBox
currentChapter = StringVar()
divChapter = ttk.Combobox(root, textvariable=currentChapter)
divChapter['values'] = combo_Chapter()
divChapter.place(x=110, y=105)
divChapter.bind("<<ComboboxSelected>>", getdataCh)

# Shows first item of this Combo as a default value
divChapter.current(0)
Chapterval1 = currentChapter.get()
Chapterval = Chapterval1.rstrip()


#4th ComBoBox
currentVerse = StringVar()
divVerse = ttk.Combobox(root, textvariable=currentVerse)
divVerse['values'] = combo_Verse()
divVerse.place(x=110, y=130)
divVerse.bind("<<ComboboxSelected>>", getdataVr)

# Shows first item of this Combo as a default value
divVerse.current(0)
Verseval1 = currentVerse.get()
Verseval = Verseval1.rstrip()

#2- Image
image1 = Image.open("media/jesus1.jpg")
test = ImageTk.PhotoImage(image1)
label11= tk.Label(root,image=test)
label11.image = test
label11.place(x=490, y=20, height = 140)



#Button
close = Button(root, text = "Done", command = on_closing)
close.place(x=500, y=445, height = 30, width = 70)

#TreeView
tabfrm=Frame(root,borderwidth=4,relief=RIDGE)
tabfrm.place(x=10,y=200,width=550,height=90)
scrolly=Scrollbar(tabfrm,orient=VERTICAL)
x_scrollbar = Scrollbar(tabfrm, orient=HORIZONTAL)

data_table=ttk.Treeview(tabfrm,columns=("Verse","TextData"), height=40, yscrollcommand=scrolly.set,xscrollcommand=x_scrollbar.set)
scrolly.pack(side=RIGHT,fill=Y)
scrolly.config(command=data_table.yview)
#------
x_scrollbar.pack(side=BOTTOM, fill='x')
x_scrollbar.config(command=data_table.xview)
#-------

#Alternate colors for the rows of Treeview
data_table.tag_configure('gray', background='lightgray')
data_table.tag_configure('normal', background='white')

# INSIDE RIGHT BOX
data_table.heading("Verse",text="Verse")
data_table.heading("TextData",text="Text Data")
data_table['show']="headings"
data_table.column("Verse",width = 40)
data_table.column("TextData",width=600)
data_table.pack(fill=BOTH,expand=1)
data_table.bind("<ButtonRelease-1>",getdata)


#Labels and Entries
BookLable=Label(root,text="Book:",font=("Times New Roman",12))
BookLable.place(x=17, y =350)
entry_text1 = tk.StringVar()
BookEntry = tk.Entry(root, textvariable=entry_text1,font=("Times New Roman",12))
BookEntry.place(x=81, y =350, width = 100)


BookTitleLable=Label(root,text="BookTitle:",font=("Times New Roman",12))
BookTitleLable.place(x=220, y =350)
entry_text2 = tk.StringVar()
BookTitleEntry = tk.Entry(root, textvariable=entry_text2,font=("Times New Roman",12))
BookTitleEntry.place(x=304, y =350, width = 100)



ChapterLable=Label(root,text="Chapter:",font=("Times New Roman",12))
ChapterLable.place(x=17, y =380)
entry_text3 = tk.StringVar()
ChapterEntry = tk.Entry(root, textvariable=entry_text3,font=("Times New Roman",12))
ChapterEntry.place(x=81, y =380, width = 100)


VerseLable=Label(root,text="Verse:",font=("Times New Roman",12))
VerseLable.place(x=220, y =380)
entry_text = tk.StringVar()
VerseEntry = tk.Entry(root, textvariable=entry_text,font=("Times New Roman",12))
VerseEntry.place(x=304, y =380, width = 100)


TextDataLable=Label(root,text="TextData:",font=("Times New Roman", 12))
TextDataLable.place(x=17, y=410)

#Text multi TextBox, textDataEntry22
Frame22 = Frame(root, borderwidth=2)
Frame22.place(x=79, y=410, width=400, height=70)
textDataEntry22 = tk.Text(Frame22, height=8, width=47)
scroll = tk.Scrollbar(Frame22)

textDataEntry22.configure(yscrollcommand=scroll.set)
textDataEntry22.pack(side=tk.LEFT)
scroll.config(command=textDataEntry22.yview)
scroll.pack(side=tk.RIGHT, fill=tk.Y)


root.mainloop()

  5- Python  file: combo2.py  -   To Display Data,  THE BIBLE by Chapter

#import tkinter
import tkinter as tk
from tkinter import *
from tkinter import ttk
from tkinter.ttk import *
#from tkinter import messagebox
from PIL import Image, ImageTk
import pyodbc


Bookval = ""
Chapterval=""

def on_closing():
root.destroy()

def combo_Book():
conn = pyodbc.connect('Driver={SQL Server};'
'Server=desktop-uegar4h;'
'Database=BKJVDat;'
'Trusted_Connection=yes;')

global current_varB
cursor = conn.cursor()
cursor.execute("SELECT distinct Book FROM BBTable1 WHERE Book<>'00a' and Book<>'00b' Order By Book ASC")

cboTaskB = []
for row in cursor.fetchall():
cboTaskB.append(row[0])
return cboTaskB


conn.commit()
conn.close()


def combo_BookTitle():
connBT = pyodbc.connect('Driver={SQL Server};'
'Server=desktop-uegar4h;'
'Database=BKJVDat;'
'Trusted_Connection=yes;')

cursorBT = connBT.cursor()
cursorBT.execute("SELECT distinct BookTitle, Book FROM BBTable1 WHERE Book<>'00a' and Book<>'00b' Order By Book ASC")


cboTaskBT = []
for row1 in cursorBT.fetchall():
cboTaskBT.append(row1[0])
return cboTaskBT


connBT.commit()
connBT.close()

def combo_Chapter():
#global Bookval
#Bookval = (currentBook.get())
connCh = pyodbc.connect('Driver={SQL Server};'
'Server=desktop-uegar4h;'
'Database=BKJVDat;'
'Trusted_Connection=yes;')

cursorCh = connCh.cursor()
cursorCh.execute("SELECT distinct Chapter FROM BBTable1 WHERE Book = '" + str(Bookval) + "' Order By Chapter ASC")
cboTaskCh = []
for row2 in cursorCh.fetchall():
cboTaskCh.append(row2[0])
return cboTaskCh


connCh.commit()
connCh.close()

def getdataBK(event):
#Variables
Bookval1a =""
Bookvala =""
Chapterval1a =""
Chaptervala =""
r = 0

#clear combobox divChapter
divChapter.configure(values=())
divChapter.set('')

#delete treeView data
data_table.delete(*data_table.get_children())

#delete Entry data
VerseEntry.delete(0, END)
textDataEntry22.delete("1.0",tk.END)

#value of current item divBook
Bookval1a = divBook.get()
Bookvala = Bookval1a.rstrip()

#show Sql data of Database
connBVal = pyodbc.connect('Driver={SQL Server};'
'Server=desktop-uegar4h;'
'Database=BKJVDat;'
'Trusted_Connection=yes;')
#connection desktop-uegar4h.BKJVDat.dbo
#name=BKJVDat
#Owner=DESKTOP-UEGAR4H\User
#connection string=Data Source=localhost;Initial Catalog=BKJVDat;Integrated Security=True
#provider=.NET Framework Data Provider for SQL Server+

cursorBTD = connBVal.cursor()

#show value of current item divBookTitle = current item divBook
divBookTitle.current(divBook.current())

#Chapter Combobox
# add data to Chapter Combobox
Queryy2 = ("SELECT distinct Chapter FROM BBTable1 WHERE Book = '" + str(Bookvala) + "' Order By Chapter ASC")
cursorBTD.execute(Queryy2)

cboTaskCh = []
r = 1
for row2 in cursorBTD.fetchall():
cboTaskCh.append(row2[0])
divChapter['values'] = cboTaskCh
r = r + 1
#current item or 1st item
divChapter.current(0)

#value of current item divChapter
Chapterval1a = divChapter.get()
Chaptervala = Chapterval1a.rstrip()

# TreeView
QueryyBCh = ("SELECT Verse, TextData FROM dbo.BBTable1 WHERE Book = '" + str(Bookvala) + "' AND Chapter = '" + str(Chaptervala) + "' Order By dbo.BBTable1.Verse ASC")
#show list of Data rows
r_setBCh=cursorBTD.execute(QueryyBCh)

#Alternate colors for the rows of Treeview
my_tag='normal' # default value
for dt in r_setBCh:
my_tag='gray' if my_tag=='normal' else 'normal'
data_table.insert("", 'end',iid=dt[0], text=dt[0],
values =(dt[0],dt[1]),tags=(my_tag))

#Calcul Number of rows
cursorBTD.execute(QueryyBCh)

rows = cursorBTD.fetchall()

if rows == None:
note_text['text'] = "2- TreeView is Empty - Data: 0 Rows "
return
#note_text['text'] = "Data: "+str(len(rows))+" Rows"
note_text['text'] = "2- THE BIBLE by Chapiter in the TreeView - Book: "+str(divBook.get().rstrip())+ ", BookTitle: "+str(divBookTitle.get().rstrip())+ ", Chapter: "+str(divChapter.get().rstrip())+" -- Data: "+str(len(rows))+" Rows"

lbselected3['text'] ="3- To Display Data, when to Select any Row of THE BIBLE by Chapter in the TreeView"


connBVal.commit()
connBVal.close()



def getdataBT(event):
#Variables
BookTitleval1a =""
BookTitlevala =""
Chapterval1a =""
Chaptervala =""
r = 0

#clear combobox divChapter
divChapter.configure(values=())
divChapter.set('')

#delete treeView data
data_table.delete(*data_table.get_children())

#delete Entry data
VerseEntry.delete(0, END)
textDataEntry22.delete("1.0",tk.END)

#value of current item divBook
BookTitleval1a = divBookTitle.get()
BookTitlevala = BookTitleval1a.rstrip()

#show Sql data of Database
connBTVal = pyodbc.connect('Driver={SQL Server};'
'Server=desktop-uegar4h;'
'Database=BKJVDat;'
'Trusted_Connection=yes;')
#connection desktop-uegar4h.BKJVDat.dbo
#name=BKJVDat
#Owner=DESKTOP-UEGAR4H\User
#connection string=Data Source=localhost;Initial Catalog=BKJVDat;Integrated Security=True
#provider=.NET Framework Data Provider for SQL Server+

cursorBTD = connBTVal.cursor()

#show value of current item divBook = current item divBookTitle
divBook.current(divBookTitle.current())

#Chapter Combobox
# add data to Chapter Combobox
Queryy2 = ("SELECT distinct Chapter FROM BBTable1 WHERE BookTitle = '" + str(BookTitlevala) + "' Order By Chapter ASC")
cursorBTD.execute(Queryy2)

cboTaskCh = []
r = 1
for row2 in cursorBTD.fetchall():
cboTaskCh.append(row2[0])
divChapter['values'] = cboTaskCh
r = r + 1
#current item or 1st item
divChapter.current(0)

#value of current item divChapter
Chapterval1a = divChapter.get()
Chaptervala = Chapterval1a.rstrip()

# TreeView
QueryyBCh = ("SELECT Verse, TextData FROM dbo.BBTable1 WHERE BookTitle = '" + str(BookTitlevala) + "' AND Chapter = '" + str(Chaptervala) + "' Order By dbo.BBTable1.Verse ASC")
#show list of Data rows
r_setBCh=cursorBTD.execute(QueryyBCh)

#Alternate colors for the rows of Treeview
my_tag='normal' # default value
for dt in r_setBCh:
my_tag='gray' if my_tag=='normal' else 'normal'
data_table.insert("", 'end',iid=dt[0], text=dt[0],
values =(dt[0],dt[1]),tags=(my_tag))

#Calcul Number of rows
cursorBTD.execute(QueryyBCh)

rows = cursorBTD.fetchall()

if rows == None:
note_text['text'] = "2- TreeView is Empty - Data: 0 Rows "
return
#note_text['text'] = "Data: "+str(len(rows))+" Rows"
note_text['text'] = "2- THE BIBLE by Chapiter in the TreeView - Book: "+str(divBook.get().rstrip())+ ", BookTitle: "+str(divBookTitle.get().rstrip())+ ", Chapter: "+str(divChapter.get().rstrip())+" -- Data: "+str(len(rows))+" Rows"

lbselected3['text'] ="3- To Display Data, when to Select any Row of THE BIBLE by Chapiter in the TreeView"
connBTVal.commit()
connBTVal.close()


def getdataCh(event):
Bookval1a =""
Bookvala =""
Chapterval1a =""
Chaptervala =""

#delete treeView data
data_table.delete(*data_table.get_children())

#delete Entry data
VerseEntry.delete(0, END)
textDataEntry22.delete("1.0",tk.END)

Bookval1a = divBook.get()
Bookvala = Bookval1a.rstrip()
Chapterval1a = divChapter.get()
Chaptervala = Chapterval1a.rstrip()

#show Sql data of Database
connBCh = pyodbc.connect('Driver={SQL Server};'
'Server=desktop-uegar4h;'
'Database=BKJVDat;'
'Trusted_Connection=yes;')
#connection desktop-uegar4h.BKJVDat.dbo
#name=BKJVDat
#Owner=DESKTOP-UEGAR4H\User
#connection string=Data Source=localhost;Initial Catalog=BKJVDat;Integrated Security=True
#provider=.NET Framework Data Provider for SQL Server+

cursorBCh = connBCh.cursor()
# TreeView
QueryyBCh = ("SELECT Verse, TextData FROM dbo.BBTable1 WHERE Book = '" + str(Bookvala) + "' AND Chapter = '" + str(Chaptervala) + "' Order By dbo.BBTable1.Verse ASC")
#show list of Data rows
r_setBCh=cursorBCh.execute(QueryyBCh)

#Alternate colors for the rows of Treeview
my_tag='normal' # default value
for dt in r_setBCh:
my_tag='gray' if my_tag=='normal' else 'normal'
data_table.insert("", 'end',iid=dt[0], text=dt[0],
values =(dt[0],dt[1]),tags=(my_tag))

#Calcul Number of rows
cursorBCh.execute(QueryyBCh)

rows = cursorBCh.fetchall()

if rows == None:
note_text['text'] = "2- TreeView is Empty - Data: 0 Rows "
return
#note_text['text'] = "Data: "+str(len(rows))+" Rows"
note_text['text'] = "2- THE BIBLE by Chapiter in the TreeView - Book: "+str(divBook.get().rstrip())+ ", BookTitle: "+str(divBookTitle.get().rstrip())+ ", Chapter: "+str(divChapter.get().rstrip())+" -- Data: "+str(len(rows))+" Rows"

lbselected3['text'] ="3- To Display Data, when to Select any Row of THE BIBLE by Chapiter in the TreeView"
connBCh.commit()
connBCh.close()


def getdata(event):

currow = data_table.focus()
contents = data_table.item(currow)
row = contents['values']
VerseEntry.configure(state='normal')

#delete contents
VerseEntry.delete(0, END)
#insert contents
VerseEntry.insert(0, data_table.selection()[0])

#delete contents
textDataEntry22.delete("1.0",tk.END)
#insert contents
textDataEntry22.insert(tk.END, row[1])




root = Tk()
root.title("Search Operation, to Show Bible by Chapter Corresponding")
#root.geometry('580x600')
root.eval('tk::PlaceWindow . center')
window_height = 580
window_width = 600

screen_width = root.winfo_screenwidth()
screen_height = root.winfo_screenheight()

x_cordinate = int((screen_width/2) - (window_width/2))
y_cordinate = int((screen_height/2) - (window_height/2))

root.geometry("{}x{}+{}+{}".format(window_width, window_height, x_cordinate, y_cordinate))
root.resizable(0, 0)


#Labels

lbselected1=Label(root,text="1- Search Operation, Select any value of Comboboxes,",font=("Times New Roman", 12), foreground="#000080")
lbselected1.place(x=17, y=3)
lbselected2=Label(root,text=" to Show the corresponding THE BIBLE by Chapiter in the TreeView",font=("Times New Roman", 10), foreground="#000080")
lbselected2.place(x=17, y=24)

lbBook=Label(root,text="Book:",font=("Times New Roman", 12))
lbBook.place(x=17, y=55)
lbBookTitle=Label(root,text="Book Title:",font=("Times New Roman", 12))
lbBookTitle.place(x=17, y=80)
lbChapter=Label(root,text="Chapter:",font=("Times New Roman", 12))
lbChapter.place(x=17, y=105)

lbline1=Label(root,text="----------------------------------------------------------------",font=("Times New Roman", 12))
lbline1.place(x=45, y=145)


#Label Message
note_text=Label(root, text = "2- TreeView is Empty",font=("Times New Roman", 10), foreground="#000080")
note_text.place(x=10, y=180)


lbselected3=Label(root,text="3- no Data Display, when ...",font=("Times New Roman", 10), foreground="#000080")
lbselected3.place(x=17, y=435)

#1st ComBoBox
currentBook = StringVar()
divBook = ttk.Combobox(root, textvariable=currentBook)
divBook['values'] = combo_Book()
divBook.place(x=110, y=55)
divBook.bind("<<ComboboxSelected>>", getdataBK)

# Shows first item of this Combo as a default value
divBook.current(0)

Bookval1 = currentBook.get()
Bookval = Bookval1.rstrip()

#2nd ComBoBox
divBookTitle = ttk.Combobox(root)
divBookTitle['values'] = combo_BookTitle()
divBookTitle.place(x=110, y=80)
divBookTitle.bind("<<ComboboxSelected>>", getdataBT)

# Shows first item of this Combo as a default value
divBookTitle.current(0)


#3th ComBoBox
currentChapter = StringVar()
divChapter = ttk.Combobox(root, textvariable=currentChapter)
divChapter['values'] = combo_Chapter()
divChapter.place(x=110, y=105)
divChapter.bind("<<ComboboxSelected>>", getdataCh)

# Shows first item of this Combo as a default value
divChapter.current(0)
Chapterval1 = currentChapter.get()
Chapterval = Chapterval1.rstrip()

#2- Image
image1 = Image.open("media/jesus1.jpg")
test = ImageTk.PhotoImage(image1)
label11= tk.Label(root,image=test)
label11.image = test
label11.place(x=490, y=15, height = 140)



#Button
close = Button(root, text = "Done", command = on_closing)
close.place(x=500, y=525, height = 30, width = 70)

#TreeView
tabfrm=Frame(root,borderwidth=4,relief=RIDGE)
tabfrm.place(x=10,y=200,width=550,height=220)
scrolly=Scrollbar(tabfrm,orient=VERTICAL)
x_scrollbar = Scrollbar(tabfrm, orient=HORIZONTAL)

data_table=ttk.Treeview(tabfrm,columns=("Verse","TextData"), height=40, yscrollcommand=scrolly.set,xscrollcommand=x_scrollbar.set)
scrolly.pack(side=RIGHT,fill=Y)
scrolly.config(command=data_table.yview)
#------
x_scrollbar.pack(side=BOTTOM, fill='x')
x_scrollbar.config(command=data_table.xview)
#-------

#Alternate colors for the rows of Treeview
data_table.tag_configure('gray', background='lightgray')
data_table.tag_configure('normal', background='white')

# INSIDE RIGHT BOX
data_table.heading("Verse",text="Verse")
data_table.heading("TextData",text="Text Data")
data_table['show']="headings"
data_table.column("Verse",width = 40)
data_table.column("TextData",width=600)
data_table.pack(fill=BOTH,expand=1)
data_table.bind("<ButtonRelease-1>",getdata)


#Label and Entry
VerseLable=Label(root,text="Verse:",font=("Times New Roman",12))
VerseLable.place(x=17, y =465)
entry_text = tk.StringVar()
VerseEntry = tk.Entry(root, textvariable=entry_text,font=("Times New Roman",12))
VerseEntry.place(x=81, y =465, width = 200)


TextDataLable=Label(root,text="TextData:",font=("Times New Roman", 12))
TextDataLable.place(x=17, y=490)

#Text multi TextBox, textDataEntry22
Frame22 = Frame(root, borderwidth=2)
Frame22.place(x=79, y=490, width=400, height=70)
textDataEntry22 = tk.Text(Frame22, height=8, width=47)
scroll = tk.Scrollbar(Frame22)

textDataEntry22.configure(yscrollcommand=scroll.set)
textDataEntry22.pack(side=tk.LEFT)
scroll.config(command=textDataEntry22.yview)
scroll.pack(side=tk.RIGHT, fill=tk.Y)


root.mainloop()