get_info.py

import sqlite3
from tkinter import *
import main


class GetInfo:
    def __init__(self, root):
        self.root = root
        pad = 3
        self.root.title("Customer Info")
        self.root.iconbitmap("hms.ico")
        self.root.geometry("{0}x{1}+0+0".format(self.root.winfo_screenwidth() - pad, self.root.winfo_screenheight() - pad))
            

        # create mainframe to add message
        top = Frame(self.root)
        top.pack(side="top")

        bottom = Frame(self.root)
        bottom.pack(side="top")

        info_frame = Frame(self.root, width=454, height=20)
        info_frame.pack(side="top")

        button_frame = Frame(self.root)
        button_frame.pack(side="top")

        # display title
        self.label = Label(top, font=('Bookman Old Style', 50, 'bold'), text="Customer Information", fg="#330000", anchor="center")
        self.label.grid(row=0, column=3, padx=10, pady=10)

        # room number label
        self.room_no_label = Label(bottom, font=('Bookman Old Style', 20, 'bold'), text="Enter the Room Number: ", fg="#330000", anchor="center")
        self.room_no_label.grid(row=2, column=2, padx=10, pady=10)                           
                   
        # text enter field for room number
        self.room_number = IntVar()
        self.room_no_entry = Entry(bottom, width=5, text=self.room_number, font="14")
        self.room_no_entry.grid(row=2, column=3, padx=10, pady=10)
        
        # textinfo display field
        self.get_info_entry = Text(info_frame, height=15, width=90)
        self.get_info_entry.grid(row=1, column=1, padx=10, pady=10)

        def get_info():
            room_number1 = int(self.room_no_entry.get())
            conn = sqlite3.connect('Hotel.db')
            with conn:
                cursor = conn.cursor()
            cursor.execute(
                'CREATE TABLE IF NOT EXISTS Hotel (Fullname TEXT,Address TEXT,mobile_number TEXT,number_days TEXT,'
                'room_number NUMBER)')
            conn.commit()
            with conn:
                cursor.execute("SELECT room_number FROM Hotel")
                ans = cursor.fetchall()
                room = []
                for i in ans:
                    room.append(i[0])
                if room_number1 in room:
                    with conn:
                        cursor.execute("SELECT * FROM Hotel")
                        ans = cursor.fetchall()
                        for i in ans:
                            if room_number1 == int(i[4]):
                                self.get_info_entry.insert(INSERT, 'NAME: ' + str(i[0]) + '\nADDRESS: ' + str(i[1]) + '\nMOBILE NUMBER:  ' + str(i[2]) + '\nNUMBER OF DAYS: ' + str(i[3]) + '\nROOM NUMBER: ' + str(i[4]) + '\n')
                                                           
                else:
                    self.get_info_entry.insert(INSERT, "\nPLEASE ENTER VALID ROOM NUMBER")
        
        # create submit button
        self.submit_button = Button(button_frame, text="Submit", font=('Bookman Old Style', 15), bg="#330000", relief=RIDGE, height=2, width=15, fg="white", anchor="center", command=get_info)
        self.submit_button.grid(row=8, column=2, padx=10, pady=10)                           
        
        # create home button
        self.home_button = Button(button_frame, text="Home", font=('Bookman Old Style', 15), bg="#330000", relief=RIDGE, height=2, width=15, fg="white", anchor="center", command=self.root.destroy)
        self.home_button.grid(row=8, column=3, padx=10, pady=10)                         
                
def get_info_ui():
    root = Tk()
    application = GetInfo(root)
    root.mainloop()