Label(top3, text=tickets, borderwidth=1, relief="solid", width=20).grid(row=i+1, padx=10, column=2) Label(top3, text=tickets, borderwidth=1, relief="solid", width=20).grid(row=i+1, padx=10, column=1) Label(top3, text=tickets, borderwidth=1, relief="solid", width=20).grid(row=i+1, column=0) Show_message('Success', 'Ticket deleted') Label(top3, text='Ticket Validity(Date)', font=('Arial', 12), borderwidth=1, relief="solid", width=20).grid(row=0, column=3, pady=10)Ĭursor.execute("DELETE FROM ticket WHERE ticket_id = ?", (ticket_id,)) Label(top3, text='Date of Booking', font=('Arial', 12), borderwidth=1, relief="solid", width=20).grid(row=0, column=2, pady=10) Top3.title('View Ticket Booking History')
# this function will be used to delete a ticket Label(top2, text=tickets, borderwidth=1, relief="solid", width=20).grid(row=i+1, padx=10, column=3) Label(top2, text=tickets, borderwidth=1, relief="solid", width=20).grid(row=i+1, padx=10, column=2) Label(top2, text=tickets, borderwidth=1, relief="solid", width=20).grid(row=i+1, padx=10, column=1) Label(top2, text=tickets, borderwidth=1, relief="solid", width=20).grid(row=i+1, column=0) Label(top2, text='Date of Booking', font=('Arial', 12), borderwidth=1, relief="solid", width=20).grid(row=0, column=2, pady=10) Top2.title('View Ticket Booking History') # this function will be used to display all booked tickets Label(top1, text='Booking Date', font=('Arial', 12)).grid(row=3, column=0, padx=10, sticky='w', pady=10)ĭateEntry(top1,selectmode='day', textvariable=ticket_date).grid(row=3, column=1) Show_message('Successful', 'Your booking is successful, your ticket id is '.format(ticket_id.get())) Show_message('Error', 'Enter valid details')Ĭonn = nnect("ticket_booking_database.db")Ĭursor.execute("INSERT INTO ticket (name, ticket_id, ticket_date, ticket_validity) VALUES (?, ?, ?, ?)", (str(name.get()), str(ticket_id.get()), str(ticket_date.get()), str(ticket_validity.get()))) If len(name.get())<5 or len(ticket_date.get())<7 or len(ticket_validity.get())<7: # this while loop will create a new unique ticket id using get_random_string function # this function will be used to book a new ticket Return ''.join(random.choice(letters) for i in range(8))
# this function will be used to generate random ticket id # this function will be used to show messages and errors Label(top, text='Ticket Management System', font=('Arial', 18)).grid(row=0, column=0, columnspan=2, padx=80, pady=20) Top.title('Ticket Management: CopyAssignment')Ĭonn = nnect('ticket_booking_database.db')Ĭursor.execute("CREATE TABLE IF NOT EXISTS ticket (name TEXT, ticket_id TEXT PRIMARY KEY, ticket_date TEXT, ticket_validity TEXT)")
# defining main window, geometry, and title
#Python contact book project install#
# importing DateEntry from tkcalendar, you need to install tkcalendar-> pip install tkcalendar
0 kommentar(er)
