Tkinter Vehicle Management System

"""MODULE 1"""

import tkinter
import os

from tkinter import *
root=tkinter.Tk()


def new_window():
	os.system('python Project2.py')


root.title("Simple Login Application")


photo=PhotoImage(file="r.jpg")
a=tkinter.Button(root,command=new_window)
a.config(image=photo,width=600,height=450)

a.pack()
status = Label(root, text = "Click on the screen to continue...",bd=1,relief=RAISED,anchor=W)
status.pack(side=BOTTOM,fill=X)
root.mainloop()

"""MODULE 2"""
from tkinter import *
from tkinter import ttk
import os

root = Tk()
root.geometry("650x250+0+0")
def new_window():
    text = USERNAME.get()
    text1 = PASSWORD.get()
    if text == "ADMIN" and text1 == "ADMIN":
       return os.system('python Project3.py')
    else :
       return  print("Username and Password is not Valid")
def exit():
    root.destroy()

root.title("System Login")
form = Frame(root,width=1000,height=1000)
form.pack()
Label1 = Label(form, text="Username", padx=20, pady=10)
Label2 = Label(form, text="Password", padx=20, pady=10)
Label1.grid(row=0, sticky="w")
Label2.grid(row=1, sticky="w")
USERNAME = StringVar()
PASSWORD = StringVar()

username = Entry(form,textvariable=USERNAME,font=(5))
password = Entry(form,textvariable=PASSWORD,show='*', font=(5))

USERNAME.get()
PASSWORD.get()

username.grid(row=0, column=1,sticky='w')
password.grid(row=1, column=1,sticky='w')
Label3 = Label(form, text="Login As", padx=20, pady=10)
Label3.grid(row=2, sticky='w')
combo = ttk.Combobox(form)
combo.place(x=97, y=85)
combo['values'] = ('Administrative', 'Employee')
combo.current(0)
button1 = Button(form, text="  Login ", bg="white", relief='raised', command=new_window)
button1.grid(row=3, ipadx=15, sticky='w',pady=10)
button2 = Button(form, bg="white", relief='raised', text="  Exit ",command=exit )
button2.grid(row=3, column=1, ipadx=15,pady=10, sticky='w')
root.mainloop()

"""MODULE 3"""
import tkinter
from tkinter import *
import os
root = Tk()
root.geometry("800x850+0+0")
root.configure(background="lightblue")
def new_window():
    os.system('python Python4.py')
def new_window1():
    os.system('python project3.1.py')
def new_window2():
    os.system('python project3.2.py')
def new_window3():
    os.system('python project3.3.py')
def new_window4():
    os.system('python python3.4.py')
def new_window5():
    os.system('python python3.5.py')
def new_window6():
    os.system('python python3.6.py')
def new_window7():
    os.system('python python3.7.py')
def new_window8():
    os.system('python python3.8.py')
def new_window9():
    os.system('python python3.9.py')
def new_window10():
    os.system('python python3.10.py')
def new_window11():
    os.system('python python3.11.py')
def exit():
    root.destroy()

root.title("Vehicle Management System")
frame = Frame(root,width=1500,height=1500)
frame.pack()
menu = Menu(frame, background="White", foreground='white',activebackground='white', activeforeground='white')
menu.config(bg = "White")
root.config(menu=menu)

#menu.add_cascade(label=" New Registration ", command= new_window)
submenu1 = Menu(menu, tearoff=False)
menu.add_cascade(label="Bus Details",menu = submenu1)
submenu1.add_command(label="Add Bus",command = new_window1)
submenu1.add_command(label="Edit Bus",command = new_window2)
submenu1.add_command(label="View Bus",command = new_window3)
submenu2 = Menu(menu, tearoff=False)
menu.add_cascade(label="Conductor",menu=submenu2)
submenu2.add_command(label="Add Conductor",command = new_window4)
submenu2.add_command(label="Edit Conductor",command = new_window5)
submenu2.add_command(label="View Conductor",command = new_window6)
submenu3 = Menu(menu, tearoff=False)
menu.add_cascade(label="Driver",menu=submenu3)
submenu3.add_command(label="Add Driver",command = new_window7)
submenu3.add_command(label="Edit Driver",command = new_window8)
submenu3.add_command(label="View Driver",command = new_window9)
submenu4 = Menu(menu, tearoff=False)
menu.add_cascade(label="Trip",menu=submenu4)
submenu4.add_command(label="Add Trip",command = new_window10)
submenu4.add_command(label="Edit Driver",command = new_window11)
submenu5 = Menu(menu, tearoff=False)
menu.add_cascade(label="Salary",menu=submenu5)
submenu5.add_command(label="Driver Salary")
submenu5.add_command(label="Conductor Salary")
submenu6 = Menu(menu, tearoff=False)
menu.add_cascade(label="Report",menu=submenu6)
submenu6.add_command(label="Bus Report")
submenu6.add_command(label="Conductor Report")
submenu6.add_command(label="Driver Report")
submenu6.add_command(label="Trip Report")
submenu6.add_command(label="Salary Report")
menu.add_cascade(label="exit",command=exit)
#form = Frame(root,width=500,height=400)
#form.pack()
#photo=PhotoImage(file="1.jpg")
#frame.config(image=photo,width=600,height=450)
photo=PhotoImage(file="1.jpg")
label=tkinter.Label(frame)
label.config(image=photo,width=600,height=450)
label.place(x=10,y=20)
root.mainloop()



"""MODULE 4"""
from tkinter import *
from tkinter import messagebox
import os
import sqlite3 as sq
import datetime
root = Tk()
root.geometry("450x300+0+0")
root.configure(background="Rosybrown1")
root.title("Add Bus")
frame = Frame(root,width=1000,height=1000)
frame.configure(background="Rosybrown1")
frame.pack()

def process():
    text = BusNumber.get()
    text1 = Driver.get()
    text2 = Conductor.get()
    text3 = Route.get()
    text4 = Price.get()
    con = sq.connect('data.db')
    with con:
       c = con.cursor()
    c.execute('CREATE TABLE IF NOT EXISTS Vehicle (BusNumber TEXT, Driver TEXT, Conductor TEXT,Route TEXT,Price INTEGER)')
    c.execute('INSERT INTO Vehicle(BusNumber , Driver , Conductor , Route ,Price) VALUES(?,?,?,?,?)',(text,text1,text2,text3,text4))
    con.commit()


    print("Bus Details are Saved")
    root.destroy()
def exit():
    root.destroy()
label = Label(frame,text="Add Bus Details",padx=10,pady=10,font=('arail',12,'bold'),bg='Rosybrown1')
label.grid(row=0,column=0)
label1 = Label(frame,text="Bus Number",padx=10,pady=10,bg='Rosybrown1')
label1.grid(row=1, sticky="w")
label2= Label(frame,text="Driver",padx=10,pady=10,bg='Rosybrown1')
label2.grid(row=2, sticky="w")
label3= Label(frame,text="Conductor",padx=10,pady=10,bg='Rosybrown1')
label3.grid(row=3, sticky="w")
label4= Label(frame,text="Route",padx=10,pady=10,bg='Rosybrown1')
label4.grid(row=4, sticky="w")
label5= Label(frame,text="Price",padx=10,pady=10,bg='Rosybrown1')
label5.grid(row=5, sticky="w")
BusNumber = StringVar()
Driver = StringVar()
Conductor = StringVar()
Route = StringVar()
Price = StringVar()
entry1 = Entry(frame,textvariable=BusNumber, font=('arail',15,'bold'),justify='left')
entry1.grid(row=1, column=1,padx=20)
entry2 = Entry(frame,textvariable=Driver,font=('arail',15,'bold'),)
entry2.grid(row=2, column=1,padx=20)
entry3 = Entry(frame,textvariable=Conductor,font=('arail',15,'bold'),)
entry3.grid(row=3, column=1,padx=20)
entry4 = Entry(frame,textvariable=Route,font=('arail',15,'bold'),)
entry4.grid(row=4, column=1,padx=20)
entry5 = Entry(frame,textvariable=Price,font=('arail',15,'bold'))
entry5.grid(row=5, column=1,padx=20)
button1 = Button(frame,text="Save",padx=20,pady=2,fg='black',bg='white',command= process)
button1.place(x=57,y=233)
button2 = Button(frame,text="Exit",padx=12,pady=2,fg='black',bg='white',command=exit)
button2.grid(row=6,column=1,ipadx=10)
root.mainloop()


"""MODULE 5"""
from tkinter import *
from tkinter import ttk
import sqlite3 as sq
root = Tk()
root.geometry("450x300+0+0")
root.configure(background="paleturquoise1")
root.title("Edit Bus")
frame = Frame(root,width=1000,height=1000)
frame.configure(background="paleturquoise1")
frame.pack()

def Update():
    text = BusNumber.get()
    con = sq.connect('data.db')
    with con:
      c = con.cursor()
    c.execute("select Driver,Conductor,Route,Price from Vehicle where BusNumber=?",(text,))
    cursor1=c.fetchall()
    for row in cursor1:
        d=row[0]
        c=row[1]
        r=row[2]
        p=row[3]
        Driver.set(d)
        Conductor.set(c)
        Route.set(r)
        Price.set(p)
    con.commit()

def Update1():
    text = BusNumber.get()
    #c.execute("UPDATE Vehicle SET (Driver='d',Conductor='c',Route='r',Price='p') where BusNumber=?",(text,))
    print("Bus Details are Updated")
    root.destroy()
def Clear():
  print("Bus Details are deleted")
  root.destroy()
def exit():
    root.destroy()
label = Label(frame,text="Edit Bus Details",padx=10,pady=10,font=('arail',12,'bold'),bg='paleturquoise1')
label.grid(row=0,column=0)
label1 = Label(frame,text="Bus Number",padx=10,pady=10,bg='paleturquoise1')
label1.grid(row=1, sticky="w")
label2= Label(frame,text="Driver",padx=10,pady=10,bg='paleturquoise1')
label2.grid(row=2, sticky="w")
label3= Label(frame,text="Conductor",padx=10,pady=10,bg='paleturquoise1')
label3.grid(row=3, sticky="w")
label4= Label(frame,text="Route",padx=10,pady=10,bg='paleturquoise1')
label4.grid(row=4, sticky="w")
label5= Label(frame,text="Price",padx=10,pady=10,bg='paleturquoise1')
label5.grid(row=5, sticky="w")

BusNumber =  StringVar()
combo = ttk.Combobox(root,textvariable=BusNumber)
combo.place(x=185,y=50)
button = Button(frame,text="Show",padx=12,pady=2,fg='black',bg='white',command=Update)
button.place(x=300,y=50)

con = sq.connect('data.db')
with con:
    c = con.cursor()
c.execute('select BusNumber from Vehicle')
bus_num=c.fetchall()
b_num=['w','w','w','w',]
for i in range(len(bus_num)):
    b_num[i]=bus_num[i][0]

con.commit()

combo['values'] = b_num
combo.current(1)

Driver = StringVar()
Conductor = StringVar()
Route = StringVar()
Price= StringVar()
entry2 = Entry(frame,textvariable=Driver,font=('arail',15,'bold'),)
entry2.grid(row=2, column=1)
entry3 = Entry(frame,textvariable=Conductor,font=('arail',15,'bold'),)
entry3.grid(row=3, column=1)
entry4 = Entry(frame,textvariable=Route,font=('arail',15,'bold'),)
entry4.grid(row=4, column=1)
entry5 = Entry(frame,textvariable=Price,font=('arail',15,'bold'))
entry5.grid(row=5, column=1)
button1 = Button(frame,text="Update",padx=20,pady=5,fg='black',bg='white',command=Update1)
button1.grid(row=6,sticky='e',pady=20)
button2 = Button(frame,text="Delete",padx=20,pady=5,fg='black',bg='white',command=Clear)
button2.place(x=160,y=258)
button3 = Button(frame,text="Exit",padx=20,pady=5,fg='black',bg='white',command=exit)
button3.place(x=258,y=258)
root.mainloop()


"""MODULE 6"""
import tkinter
from tkinter import *
from tkinter import ttk
import sqlite3 as sq
root = Tk()
root.geometry("450x300+0+0")
root.configure(background="plum1")
root.title("View Bus")
frame = Frame(root,width=1000,height=1000)
frame.configure(background="plum1")
frame.pack()

def Process():
    text = BusNumber.get()
    con = sq.connect('data.db')
    with con:
      c = con.cursor()
    c.execute("select Driver,Conductor,Route,Price from Vehicle where BusNumber=?",(text,))
    cursor1=c.fetchall()
    for row in cursor1:
        d=row[0]
        c=row[1]
        r=row[2]
        p=row[3]
        Driver.set(d)
        Conductor.set(c)
        Route.set(r)
        Price.set(p)
    con.commit()

def exit():
    root.destroy()
label = Label(frame,text="View Bus ",padx=10,pady=10,font=('arail',12,'bold'),bg='plum1')
label.grid(row=0,column=0)
label1 = Label(frame,text="Bus Number",padx=10,pady=10,bg='plum1')
label1.grid(row=1, sticky="w")
label2= Label(frame,text="Driver",padx=10,pady=10,bg='plum1')
label2.grid(row=2, sticky="w")
label3= Label(frame,text="Conductor",padx=10,pady=10,bg='plum1')
label3.grid(row=3, sticky="w")
label4= Label(frame,text="Route",padx=10,pady=10,bg='plum1')
label4.grid(row=4, sticky="w")
label5= Label(frame,text="Price",padx=10,pady=10,bg='plum1')
label5.grid(row=5, sticky="w")

BusNumber =  StringVar()
combo = ttk.Combobox(root,textvariable=BusNumber)
combo.place(x=160,y=50)

con = sq.connect('data.db')
with con:
    c = con.cursor()
c.execute('select BusNumber from Vehicle')
bus_num=c.fetchall()
b_num=['w','w','w','w',]
for i in range(len(bus_num)):
    b_num[i]=bus_num[i][0]

con.commit()
combo['values'] = b_num
combo.current(1)
button = Button(frame,text="Show",padx=12,pady=2,fg='black',bg='white',command=Process)
button.place(x=280,y=50)

Driver = StringVar()
Conductor = StringVar()
Route = StringVar()
Price= StringVar()
entry2 = Entry(frame,textvariable=Driver,font=('arail',15,'bold'),justify='left')
entry2.grid(row=2, column=1,padx=20)
entry3 = Entry(frame,textvariable=Conductor,font=('arail',15,'bold'),justify='left')
entry3.grid(row=3, column=1,padx=20)
entry4 = Entry(frame,textvariable=Route,font=('arail',15,'bold'),justify='left')
entry4.grid(row=4, column=1,padx=20)
entry5 = Entry(frame,textvariable=Price,font=('arail',15,'bold'),justify='left')
entry5.grid(row=5, column=1,padx=20)

button = Button(frame,text="Exit",padx=12,pady=2,fg='black',bg='white',command=exit)
button.grid(column=1,ipadx=20,pady=20)
root.mainloop()

"""MODULE 7"""
from tkinter import *
import sqlite3 as sq
root = Tk()
root.geometry("450x300+0+0")
root.configure(background="Rosybrown1")
root.title("Add Conductor")
frame = Frame(root,width=1000,height=1000)
frame.configure(background="Rosybrown1")
frame.pack()
def process():
    text = ConductorName.get()
    text1 = Address.get()
    text2 = PhoneNo.get()
    text3 = ShiftTiming.get()
    text4 = DateOfJoining.get()
    con = sq.connect('data.db')
    with con:
       c = con.cursor()
    c.execute('CREATE TABLE IF NOT EXISTS Conductor (ConductorName TEXT, Address TEXT, PhoneNo INTEGER,ShiftTiming TEXT,DateOfJoining TEXT)')
    c.execute('INSERT INTO Conductor(ConductorName , Address , PhoneNo ,ShiftTiming ,DateOfJoining) VALUES(?,?,?,?,?)',(text,text1,text2,text3,text4))
    con.commit()

    print("Conductor Details are Saved")
    root.destroy()
def exit():
    root.destroy()
label = Label(frame,text="Add Conductor Details",padx=10,pady=10,font=('arail',12,'bold'),bg='Rosybrown1')
label.grid(row=0,column=0)
label1 = Label(frame,text="Conductor Name",padx=10,pady=10,bg='Rosybrown1')
label1.grid(row=1, sticky="w")
label2= Label(frame,text="Address",padx=10,pady=10,bg='Rosybrown1')
label2.grid(row=2, sticky="w")
label3= Label(frame,text="Phone No.",padx=10,pady=10,bg='Rosybrown1')
label3.grid(row=3, sticky="w")
label4= Label(frame,text="Shift Time",padx=10,pady=10,bg='Rosybrown1')
label4.grid(row=4, sticky="w")
label5= Label(frame,text="Date of joining",padx=10,pady=10,bg='Rosybrown1')
label5.grid(row=5, sticky="w")

ConductorName = StringVar()
Address = StringVar()
PhoneNo= StringVar()
ShiftTiming = StringVar()
DateOfJoining= StringVar()
entry1 = Entry(frame,textvariable=ConductorName,font=('arail',15,'bold'),justify='left')
entry1.grid(row=1, column=1,padx=20)
entry2 = Entry(frame,textvariable=Address,font=('arail',15,'bold'),justify='left')
entry2.grid(row=2, column=1,padx=20)
entry3 = Entry(frame,textvariable=PhoneNo,font=('arail',15,'bold'),justify='left')
entry3.grid(row=3, column=1,padx=20)
entry4 = Entry(frame,textvariable=ShiftTiming,font=('arail',15,'bold'),justify='left')
entry4.grid(row=4, column=1,padx=20)
entry5 = Entry(frame,textvariable=DateOfJoining,font=('arail',15,'bold'),justify='left')
entry5.grid(row=5, column=1,padx=20)
button = Button(frame,text="Save",padx=12,pady=2,fg='black',bg='white',command=process)
button.place(x=160,y=258)
button = Button(frame,text="Exit",padx=12,pady=2,fg='black',bg='white',command=exit)
button.grid(row=6,column=1,pady=20)
root.mainloop()


"""MODULE 8"""
from tkinter import *
root = Tk()
root.geometry("450x300+0+0")
root.configure(background="paleturquoise1")
root.title("Edit Conductor")
frame = Frame(root,width=1000,height=1000)
frame.configure(background="paleturquoise1")
frame.pack()
def Update():
    print("Conductor Details are Updated")
    root.destroy()
def Clear():
  print("Conductor Details are deleted")
  root.destroy()
def exit():
    root.destroy()
label = Label(frame,text="Edit Conductor Details",padx=10,pady=10,font=('arail',12,'bold'),bg='paleturquoise1')
label.grid(row=0,column=0)
label1 = Label(frame,text="Conductor Name",padx=10,pady=10,fg='black',bg='paleturquoise1')
label1.grid(row=1, sticky="w")
label2= Label(frame,text="Adress",padx=10,pady=10,fg='black',bg='paleturquoise1')
label2.grid(row=2, sticky="w")
label3= Label(frame,text="Phone No.",padx=10,pady=10,fg='black',bg='paleturquoise1')
label3.grid(row=3, sticky="w")
label4= Label(frame,text="Shift Time",padx=10,pady=10,fg='black',bg='paleturquoise1')
label4.grid(row=4, sticky="w")
label5= Label(frame,text="Date of joining",padx=10,pady=10,fg='black',bg='paleturquoise1')
label5.grid(row=5, sticky="w")
entry1 = Entry(frame,font=('arail',15,'bold'),justify='left')
entry1.grid(row=1, column=1,padx=20)
entry2 = Entry(frame,font=('arail',15,'bold'),justify='left')
entry2.grid(row=2, column=1,padx=20)
entry3 = Entry(frame,font=('arail',15,'bold'),justify='left')
entry3.grid(row=3, column=1,padx=20)
entry4 = Entry(frame,font=('arail',15,'bold'),justify='left')
entry4.grid(row=4, column=1,padx=20)
entry5 = Entry(frame,font=('arail',15,'bold'),justify='left')
entry5.grid(row=5, column=1,padx=20)
button = Button(frame,text="Update",padx=12,pady=2,fg='black',bg='white',command=Update)
button.place(x=60,y=258)
button1 = Button(frame,text="Delete",padx=12,pady=2,fg='black',bg='white',command=Clear)
button1.place(x=180,y=258)
button2 = Button(frame,text="Exit",padx=12,pady=2,fg='black',bg='white')
button2.grid(row=6,column=1,pady=20)
root.mainloop()


"""MODULE 9"""
from tkinter import *
root = Tk()
root.geometry("450x300+0+0")
root.configure(background="plum1")
root.title("View Conductor")
frame = Frame(root,width=1000,height=1000)
frame.configure(background="plum1")
frame.pack()
def exit():
    root.destroy()
label = Label(frame,text="View Conductor",padx=10,pady=10,font=('arail',12,'bold'),bg='plum1')
label.grid(row=0,column=0)
label1 = Label(frame,text="Conductor Name",padx=10,pady=10,bg='plum1')
label1.grid(row=1, sticky="w")
label2= Label(frame,text="Adress",padx=10,pady=10,bg='plum1')
label2.grid(row=2, sticky="w")
label3= Label(frame,text="Phone No.",padx=10,pady=10,bg='plum1')
label3.grid(row=3, sticky="w")
label4= Label(frame,text="Shift Time",padx=10,pady=10,bg='plum1')
label4.grid(row=4, sticky="w")
label5= Label(frame,text="Date of joining",padx=10,pady=10,bg='plum1')
label5.grid(row=5, sticky="w")
entry1 = Entry(frame,font=('arail',15,'bold'),justify='left')
entry1.grid(row=1, column=1,padx=20)
entry2 = Entry(frame,font=('arail',15,'bold'),justify='left')
entry2.grid(row=2, column=1,padx=20)
entry3 = Entry(frame,font=('arail',15,'bold'),justify='left')
entry3.grid(row=3, column=1,padx=20)
entry4 = Entry(frame,font=('arail',15,'bold'),justify='left')
entry4.grid(row=4, column=1,padx=20)
entry5 = Entry(frame,font=('arail',15,'bold'),justify='left')
entry5.grid(row=5, column=1,padx=20)
button = Button(frame,text="Exit",padx=20,pady=2,fg='black',bg='white',command=exit)
button.grid(row=6,column=0,pady=20)
root.mainloop()


"""MODULE 10"""
from tkinter import *
import sqlite3 as sq
root = Tk()
root.geometry("450x300+0+0")
root.configure(background="Rosybrown1")
root.title("Add Driver")
frame = Frame(root,width=1000,height=1000)
frame.configure(background="Rosybrown1")
frame.pack()
def process():
    text = DriverName.get()
    text1 = Address.get()
    text2 = PhoneNo.get()
    text3 = ShiftTiming.get()
    text4 = DateOfJoining.get()
    con = sq.connect('data.db')
    with con:
       c = con.cursor()
    c.execute('CREATE TABLE IF NOT EXISTS Driver (DriverName TEXT, Address TEXT, PhoneNo INTEGER,ShiftTiming TEXT,DateOfJoining TEXT)')
    c.execute('INSERT INTO Driver(DriverName , Address , PhoneNo ,ShiftTiming ,DateOfJoining) VALUES(?,?,?,?,?)',(text,text1,text2,text3,text4))
    con.commit()
    print("Driver Details are Saved")
    root.destroy()
def exit():
    root.destroy()
label = Label(frame,text="Add Driver Details",padx=10,pady=10,font=('arail',12,'bold'),bg='Rosybrown1')
label.grid(row=0,column=0)
label1 = Label(frame,text="Driver Name",padx=10,pady=10,bg='Rosybrown1')
label1.grid(row=1, sticky="w")
label2= Label(frame,text="Adress",padx=10,pady=10,bg='Rosybrown1')
label2.grid(row=2, sticky="w")
label3= Label(frame,text="Phone No.",padx=10,pady=10,bg='Rosybrown1')
label3.grid(row=3, sticky="w")
label4= Label(frame,text="Shift Time",padx=10,pady=10,bg='Rosybrown1')
label4.grid(row=4, sticky="w")
label5= Label(frame,text="Date of joining",padx=10,pady=10,bg='Rosybrown1')
label5.grid(row=5, sticky="w")

DriverName = StringVar()
Address = StringVar()
PhoneNo= StringVar()
ShiftTiming = StringVar()
DateOfJoining= StringVar()
entry1 = Entry(frame,textvariable=DriverName,font=('arail',15,'bold'),justify='left')
entry1.grid(row=1, column=1,padx=20)
entry2 = Entry(frame,textvariable=Address ,font=('arail',15,'bold'),justify='left')
entry2.grid(row=2, column=1,padx=20)
entry3 = Entry(frame,textvariable=PhoneNo,font=('arail',15,'bold'),justify='left')
entry3.grid(row=3, column=1,padx=20)
entry4 = Entry(frame,textvariable=ShiftTiming,font=('arail',15,'bold'),justify='left')
entry4.grid(row=4, column=1,padx=20)
entry5 = Entry(frame,textvariable=DateOfJoining,font=('arail',15,'bold'),justify='left')
entry5.grid(row=5, column=1,padx=20)
button1 = Button(frame,text="Save",padx=20,pady=2,fg='black',bg='white',command=process)
button1.place(x=10,y=258)
button2 = Button(frame,text="Exit",padx=20,pady=2,fg='black',bg='white',command=exit)
button2.grid(row=6,column=0,pady=20,sticky='e')
root.mainloop()


"""MODULE 11"""
from tkinter import *
root = Tk()
root.geometry("450x300+0+0")
root.configure(background="paleturquoise1")
root.title("Edit Driver Details")
frame = Frame(root,width=1000,height=1000)
frame.configure(background="paleturquoise1")
frame.pack()
def Update():
    print("Driver Details are Updated")
    root.destroy()
def Clear():
  print("Driver Details are deleted")
  root.destroy()
def exit():
    root.destroy()
label = Label(frame,text="Edit Driver Details",padx=10,pady=10,font=('arail',12,'bold'),bg='paleturquoise1')
label.grid(row=0,column=0)
label1 = Label(frame,text="Driver Name",padx=10,pady=10,bg='paleturquoise1')
label1.grid(row=1, sticky="w")
label2= Label(frame,text="Driver",padx=10,pady=10,bg='paleturquoise1')
label2.grid(row=2, sticky="w")
label3= Label(frame,text="Conductor",padx=10,pady=10,bg='paleturquoise1')
label3.grid(row=3, sticky="w")
label4= Label(frame,text="Route",padx=10,pady=10,bg='paleturquoise1')
label4.grid(row=4, sticky="w")
label5= Label(frame,text="Price",padx=10,pady=10,bg='paleturquoise1')
label5.grid(row=5, sticky="w")
entry1 = Entry(frame,font=('arail',15,'bold'),justify='left')
entry1.grid(row=1, column=1)
entry2 = Entry(frame,font=('arail',15,'bold'),)
entry2.grid(row=2, column=1)
entry3 = Entry(frame,font=('arail',15,'bold'),)
entry3.grid(row=3, column=1)
entry4 = Entry(frame,font=('arail',15,'bold'),)
entry4.grid(row=4, column=1)
entry5 = Entry(frame,font=('arail',15,'bold'))
entry5.grid(row=5, column=1)
button1 = Button(frame,text="Update",padx=12,pady=2,fg='black',bg='white',command=Update)
button1.grid(row=6,sticky='w',pady=20,ipadx=10)
button2 = Button(frame,text="Delete",padx=18,pady=2,fg='black',bg='white',command=Clear)
button2.place(x=120,y=258)
button3 = Button(frame,text="Exit",padx=20,pady=2,fg='black',bg='white',command=exit)
button3.place(x=250,y=258)
root.mainloop()

"""MODULE 12"""
from tkinter import *
root = Tk()
root.geometry("450x300+0+0")
root.configure(background="plum1")
root.title("View Driver")
frame = Frame(root,width=1000,height=1000)
frame.configure(background="plum1")
frame.pack()
def exit():
    root.destroy()
label = Label(frame,text="View Driver",padx=10,pady=10,font=('arail',12,'bold'),bg='plum1')
label.grid(row=0,column=0)
label1 = Label(frame,text="Conductor Name",padx=10,pady=10,bg='plum1')
label1.grid(row=1, sticky="w")
label2= Label(frame,text="Adress",padx=10,pady=10,bg='plum1')
label2.grid(row=2, sticky="w")
label3= Label(frame,text="Phone No.",padx=10,pady=10,bg='plum1')
label3.grid(row=3, sticky="w")
label4= Label(frame,text="Shift Time",padx=10,pady=10,bg='plum1')
label4.grid(row=4, sticky="w")
label5= Label(frame,text="Date of joining",padx=10,pady=10,bg='plum1')
label5.grid(row=5, sticky="w")
entry1 = Entry(frame,font=('arail',15,'bold'),justify='left')
entry1.grid(row=1, column=1,padx=20)
entry2 = Entry(frame,font=('arail',15,'bold'),justify='left')
entry2.grid(row=2, column=1,padx=20)
entry3 = Entry(frame,font=('arail',15,'bold'),justify='left')
entry3.grid(row=3, column=1,padx=20)
entry4 = Entry(frame,font=('arail',15,'bold'),justify='left')
entry4.grid(row=4, column=1,padx=20)
entry5 = Entry(frame,font=('arail',15,'bold'),justify='left')
entry5.grid(row=5, column=1,padx=20)
button = Button(frame,text="Exit",padx=20,pady=2,fg='black',bg='white',command=exit)
button.grid(row=6,column=0,pady=20)
root.mainloop()


"""MODULE 13"""
from tkinter import *
from tkinter import ttk
root = Tk()
root.geometry("600x650+0+0")
root.configure(background="Rosybrown1")
root.title("Add Trip")
frame = Frame(root,width=1000,height=1000)
frame.configure(background="Rosybrown1")
frame.pack()
def process():
    print("Trip Details are Saved")
    root.destroy()
def exit():
    root.destroy()
label = Label(frame,text= "Add Trip Details",padx=10,pady=10,font=('arail',12,'bold'),bg='Rosybrown1')
label.grid(row=0,column=0,sticky='w')
label = Label(frame,text= "Trip ID",padx=10,pady=10,font=('arail',12,'bold'),bg='Rosybrown1')
label.grid(row=1,column=0,sticky='w')
label = Label(frame,text= "Bus Number",padx=10,pady=10,font=('arail',12,'bold'),bg='Rosybrown1')
label.grid(row=2,column=0,sticky='w')
label = Label(frame,text= "Conductor Name",padx=10,pady=10,font=('arail',12,'bold'),bg='Rosybrown1')
label.grid(row=3,column=0,sticky='w')
label = Label(frame,text= "Driver Name",padx=10,pady=10,font=('arail',12,'bold'),bg='Rosybrown1')
label.grid(row=4,column=0,sticky='w')
label = Label(frame,text= "Date",padx=10,pady=10,font=('arail',12,'bold'),bg='Rosybrown1')
label.grid(row=5,column=0,sticky='w')
label = Label(frame,text= "Starting Time",padx=10,pady=10,font=('arail',12,'bold'),bg='Rosybrown1')
label.grid(row=6,column=0,sticky='w')
label = Label(frame,text= "Starting Place",padx=10,pady=10,font=('arail',12,'bold'),bg='Rosybrown1')
label.grid(row=7,column=0,sticky='w')
label = Label(frame,text= "Ending Time",padx=10,pady=10,font=('arail',12,'bold'),bg='Rosybrown1')
label.grid(row=8,column=0,sticky='w')
label = Label(frame,text= "Ending Place",padx=10,pady=10,font=('arail',12,'bold'),bg='Rosybrown1')
label.grid(row=9,column=0,sticky='w')
label = Label(frame,text= "Ticket Rate",padx=10,pady=10,font=('arail',12,'bold'),bg='Rosybrown1')
label.grid(row=10,column=0,sticky='w')
label = Label(frame,text= "No. Of Passengers",padx=10,pady=10,font=('arail',12,'bold'),bg='Rosybrown1')
label.grid(row=11,column=0,sticky='w')
label = Label(frame,text= "Total Collection",padx=10,pady=10,font=('arail',12,'bold'),bg='Rosybrown1')
label.grid(row=12,column=0,sticky='w')
entry = Entry(frame,font=('arail',15,'bold'),justify='left')
entry.grid(row=1, column=1,padx=20)
combo = ttk.Combobox(frame,width='34')
combo.grid(row=2, column=1,padx=20)
combo['values'] = ('301', '302', '303', '304', '305', '306', '307', '308', '309', '310')
combo = ttk.Combobox(frame,width='34')
combo.grid(row=3, column=1,padx=20)
combo['values'] = ('301', '302', '303', '304', '305', '306', '307', '308', '309', '310')
combo = ttk.Combobox(frame,width='34')
combo.grid(row=4, column=1,padx=20)
combo['values'] = ('301', '302', '303', '304', '305', '306', '307', '308', '309', '310')
entry = Entry(frame,font=('arail',15,'bold'),justify='left')
entry.grid(row=5, column=1,padx=20)
entry = Entry(frame,font=('arail',15,'bold'),justify='left')
entry.grid(row=6, column=1,padx=20)
entry = Entry(frame,font=('arail',15,'bold'),justify='left')
entry.grid(row=7, column=1,padx=20)
entry = Entry(frame,font=('arail',15,'bold'),justify='left')
entry.grid(row=8, column=1,padx=20)
entry = Entry(frame,font=('arail',15,'bold'),justify='left')
entry.grid(row=9, column=1,padx=20)
entry = Entry(frame,font=('arail',15,'bold'),justify='left')
entry.grid(row=10, column=1,padx=20)
entry = Entry(frame,font=('arail',15,'bold'),justify='left')
entry.grid(row=11, column=1,padx=20)
entry = Entry(frame,width = '13',font=('arail',15,'bold'),justify='left')
entry.grid(row=12, column=1,padx=20,sticky='w')
button = Button(frame,text="Ok",padx=20,pady=2,fg='black',bg='white')
button.place(x=347,y=522)
button = Button(frame,text="Save",padx=20,pady=2,fg='black',bg='white',command=process)
button.grid(row=13,column=0,sticky='w',pady=10)
button = Button(frame,text="Exit",padx=20,pady=2,fg='black',bg='white',command=exit)
button.grid(row=13,column=0,sticky='e',pady=10)
root.mainloop()

"""MODULE 14"""
from tkinter import *
from tkinter import ttk
root = Tk()
root.geometry("600x650+0+0")
root.configure(background="paleturquoise1")
root.title("Edit Trip")
frame = Frame(root,width=1000,height=1000)
frame.configure(background="paleturquoise1")
frame.pack()
def Update():
    print("Trip Details are Updated")
    root.destroy()
def exit():
    root.destroy()
label = Label(frame,text= "Edit Trip Details",padx=10,pady=10,font=('arail',12,'bold'),bg='paleturquoise1')
label.grid(row=0,column=0,sticky='w')
label = Label(frame,text= "Trip ID",padx=10,pady=10,font=('arail',12,'bold'),bg='paleturquoise1')
label.grid(row=1,column=0,sticky='w')
label = Label(frame,text= "Bus Number",padx=10,pady=10,font=('arail',12,'bold'),bg='paleturquoise1')
label.grid(row=2,column=0,sticky='w')
label = Label(frame,text= "Conductor Name",padx=10,pady=10,font=('arail',12,'bold'),bg='paleturquoise1')
label.grid(row=3,column=0,sticky='w')
label = Label(frame,text= "Driver Name",padx=10,pady=10,font=('arail',12,'bold'),bg='paleturquoise1')
label.grid(row=4,column=0,sticky='w')
label = Label(frame,text= "Date",padx=10,pady=10,font=('arail',12,'bold'),bg='paleturquoise1')
label.grid(row=5,column=0,sticky='w')
label = Label(frame,text= "Starting Time",padx=10,pady=10,font=('arail',12,'bold'),bg='paleturquoise1')
label.grid(row=6,column=0,sticky='w')
label = Label(frame,text= "Starting Place",padx=10,pady=10,font=('arail',12,'bold'),bg='paleturquoise1')
label.grid(row=7,column=0,sticky='w')
label = Label(frame,text= "Ending Time",padx=10,pady=10,font=('arail',12,'bold'),bg='paleturquoise1')
label.grid(row=8,column=0,sticky='w')
label = Label(frame,text= "Ending Place",padx=10,pady=10,font=('arail',12,'bold'),bg='paleturquoise1')
label.grid(row=9,column=0,sticky='w')
label = Label(frame,text= "Ticket Rate",padx=10,pady=10,font=('arail',12,'bold'),bg='paleturquoise1')
label.grid(row=10,column=0,sticky='w')
label = Label(frame,text= "No. Of Passengers",padx=10,pady=10,font=('arail',12,'bold'),bg='paleturquoise1')
label.grid(row=11,column=0,sticky='w')
label = Label(frame,text= "Total Collection",padx=10,pady=10,font=('arail',12,'bold'),bg='paleturquoise1')
label.grid(row=12,column=0,sticky='w')
combo = ttk.Combobox(frame,width='34',height='45')
combo.grid(row=1, column=1,padx=20)
combo['values'] = ('301', '302', '303', '304', '305', '306', '307', '308', '309', '310')
combo = ttk.Combobox(frame,width='34',height='45')
combo.grid(row=2, column=1,padx=20)
combo['values'] = ('301', '302', '303', '304', '305', '306', '307', '308', '309', '310')
combo = ttk.Combobox(frame,width='34',height='45')
combo.grid(row=3, column=1,padx=20)
combo['values'] = ('301', '302', '303', '304', '305', '306', '307', '308', '309', '310')
combo = ttk.Combobox(frame,width='34',height='45')
combo.grid(row=4, column=1,padx=20)
combo['values'] = ('301', '302', '303', '304', '305', '306', '307', '308', '309', '310')
entry = Entry(frame,width='20',font=('arail',15,'bold'),justify='left')
entry.grid(row=5, column=1,padx=20)
entry = Entry(frame,width='20',font=('arail',15,'bold'),justify='left')
entry.grid(row=6, column=1,padx=20)
entry = Entry(frame,width='20',font=('arail',15,'bold'),justify='left')
entry.grid(row=7, column=1,padx=20)
entry = Entry(frame,width='20',font=('arail',15,'bold'),justify='left')
entry.grid(row=8, column=1,padx=20)
entry = Entry(frame,width='20',font=('arail',15,'bold'),justify='left')
entry.grid(row=9, column=1,padx=20)
entry = Entry(frame,width='20',font=('arail',15,'bold'),justify='left')
entry.grid(row=10, column=1,padx=20)
entry = Entry(frame,width='20',font=('arail',15,'bold'),justify='left')
entry.grid(row=11, column=1,padx=20)
entry = Entry(frame,width = '13',font=('arail',15,'bold'),justify='left')
entry.grid(row=12, column=1,padx=20,sticky='w')
button = Button(frame,text="Ok",padx=20,pady=2,fg='black',bg='white')
button.place(x=347,y=522)
button = Button(frame,text="Update",padx=20,pady=2,fg='black',bg='white',command=Update)
button.grid(row=13,column=0,sticky='w',pady=10)
button = Button(frame,text="Exit",padx=20,pady=2,fg='black',bg='white',command=exit)
button.grid(row=13,column=0,sticky='e',pady=10)
root.mainloop()